122 | 07 Apr 2016 @ 09:02 PDT | Database | Reply | convert integer value to binary | Thank you Dnoeth and Fred for your assistance. My requirement was finally fulfilled by using bit functions and data type functions. If any further help is required I may get in touch with you.
Tha... |
121 | 05 Apr 2016 @ 03:44 PDT | Database | Reply | convert integer value to binary |
Thanks Dieter for your reply.
Actually there is a weird requirement which I need to implement.
Say there is one column COL1 which has integer value 23.
... |
120 | 04 Apr 2016 @ 10:37 PDT | Database | Reply | convert integer value to binary | Never Mind, I have figured it out. I suppose the below SQL should suffice. If you guys have any better suggestion then please advise.
SEL CAST(23 AS VARCHAR(20) CHARACTER SET UNICODE ) VL, &... |
119 | 04 Apr 2016 @ 10:23 PDT | Database | Reply | convert integer value to binary | Hi Experts
Any update for the question. Also I tried the below SQL. But when I am using column instead of hardcoded value it is giving error.
SEL TO_BYTES ('23', 'base10') ; ... |
118 | 04 Apr 2016 @ 08:54 PDT | Database | Topic | convert integer value to binary | Hi
Please advise in Teradata how to convert integer value to binary and then back to integer ? If there is any function for that ?
For example: integer value is 50, binary will be ... |
117 | 26 Mar 2016 @ 09:32 PDT | Training | Reply | Teradata guide by Tera Tom | Guys, any update on Tera Tom V14 Certification - Teradata SQL ?
Please email me @ sanutopia@gmail.com
Thanks
San
|
116 | 16 Mar 2016 @ 08:02 PDT | General | Topic | Teradata SQL guide by Tera Tom |
Hi Guys
Does anybody have the online book or pdf of "Tera Tom V14 Certification Teradata SQL" ?
Please do let me know your response.
Thanking You
... |
115 | 16 Mar 2016 @ 08:01 PDT | Training | Topic | Teradata guide by Tera Tom |
Hi Guys
Does anybody have the online book or pdf of "Tera Tom V14 Certification Teradata SQL" ?
Please do let me know your response.
Thanking You
... |
114 | 07 Sep 2015 @ 09:32 PDT | Tools | Topic | Fast Load to NOPI Table |
Hi All
Need help to clear my understanding on few points as mentioned below.
1.
One way of loading data into NOPI table is using Fast Load. There TD uses config... |
113 | 02 Sep 2015 @ 01:40 PDT | Database | Reply | Row Allocation to NOPI Table using FastLoad | Hello Everybody , any update or guidance would be helpful ?
Thanks
Santanu
|
112 | 29 Aug 2015 @ 11:15 PDT | Database | Reply | Teradata Stored Procedure GOTO | Hi Fred,
Sorry for the delay in response. Thanks a lot for your help. I finally managed it using While loop and If Then Else option.
Thanking You
Santanu
|
111 | 29 Aug 2015 @ 11:13 PDT | Database | Reply | Row Allocation to NOPI Table using FastLoad | Oh just to add one more thing, the data volume is really high say 20 million or more.
Thanking You
Santanu
|
110 | 29 Aug 2015 @ 10:57 PDT | Database | Topic | Row Allocation to NOPI Table using FastLoad | Hi All
I need help to clear my understanding on few points as mentioned below.
1.
One way of loading data into NOPI table is using Fast Load. There TD uses configuration map and list downs ... |
109 | 01 Jul 2015 @ 12:42 PDT | Database | Topic | Teradata Stored Procedure GOTO | Hi
I am using TD 14.0 and writing a stored procedure where using GOTO I am trying to move to another Label.
But surprisingly it is showing me error as below.
SPL1027:E(L34), Missing/Inva... |
108 | 20 Feb 2015 @ 03:30 PST | Database | Reply | bteq utility query on TD database | Thanks Raja for your help.
Thanking You
Santanu
|
107 | 20 Feb 2015 @ 03:30 PST | Database | Reply | Find Second Highest Salary - SQL | Thanks guys for your response.
Thanking You
Santanu
|
106 | 30 Jan 2015 @ 03:42 PST | Database | Topic | bteq utility query on TD database |
Hi All
Need help for one requirement. We are writing a bteq script. The statements are like below.
Insert into TableA ;
Insert into TableB;
Insert into Tabl... |
105 | 01 Jan 2015 @ 07:09 PST | Database | Reply | Find Second Highest Salary - SQL | Thanks Raja and Dnoeth for your responses. It was really helpful.
Thanking You
Santanu
|
104 | 31 Dec 2014 @ 10:58 PST | Database | Topic | Find Second Highest Salary - SQL | Hello Experts
New year greetings. I need another help. Creating a seperate post for that.
EMP
--------
ID NAME SAL DEPT
1 SAM 50 D1
2 TOM 50 D1
3 RAM 40 D1
4 PAM 30 D1
... |
103 | 31 Dec 2014 @ 10:50 PST | Database | Reply | Query on efficient join and update | Hi Dnoeth
Thanks for your reply. Below example might give you some idea what we are trying to do.
CUST
----------
CUSTID CUSTNAME ORDRID ORDRDT
1 SAM O1 ... |
102 | 25 Dec 2014 @ 06:07 PST | Database | Topic | Query on efficient join and update | Hi Experts
I have two requirements. Need your help to solve them for project.
1. there is TableA with 10M rows and 50 cols. Need to update only 3 cols out of them for 1M rows. Will a single updat... |
101 | 11 Sep 2014 @ 09:53 PDT | Database | Reply | Defining two derived tables using WITH clause ?? | Thanks Dieter for your update.
Santanu
|
100 | 11 Sep 2014 @ 05:29 PDT | Database | Reply | Number of tables | This document is really good. Thanks Raja
|
99 | 11 Sep 2014 @ 05:24 PDT | Database | Reply | Defining two derived tables using WITH clause ?? | Hi
See if this is helpful. I am sure Dieter will give us something more effective.
WITH YESDATE (YDT, CDT) AS
(
SEL CDT - 1 , CDT
FROM
( SEL CURRENT_DATE AS CDT ) TODATE
)
... |
98 | 28 Jul 2014 @ 06:12 PDT | Database | Reply | ESCAPE with Single Quote ? |
Are you trying this? Please share your table and data.
CREATE MULTISET TABLE db.TABLES
(
C1 VARCHAR(10)
)
NO PRIMARY INDEX
;
INSERT INTO db.TABL... |