#DateForumTypeThreadPost
12207 Apr 2016 @ 09:02 PDTDatabaseReplyconvert integer value to binaryThank 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...
12105 Apr 2016 @ 03:44 PDTDatabaseReplyconvert 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.  ...
12004 Apr 2016 @ 10:37 PDTDatabaseReplyconvert integer value to binaryNever 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, &...
11904 Apr 2016 @ 10:23 PDTDatabaseReplyconvert integer value to binaryHi 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') ; ...
11804 Apr 2016 @ 08:54 PDTDatabaseTopicconvert integer value to binaryHi  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 ...
11726 Mar 2016 @ 09:32 PDTTrainingReplyTeradata guide by Tera TomGuys, any update on Tera Tom V14 Certification - Teradata SQL ? Please email me @ sanutopia@gmail.com Thanks San
11616 Mar 2016 @ 08:02 PDTGeneralTopicTeradata 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 ...
11516 Mar 2016 @ 08:01 PDTTrainingTopicTeradata 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 ...
11407 Sep 2015 @ 09:32 PDTToolsTopicFast 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...
11302 Sep 2015 @ 01:40 PDTDatabaseReplyRow Allocation to NOPI Table using FastLoadHello Everybody , any update or guidance would be helpful ? Thanks Santanu
11229 Aug 2015 @ 11:15 PDTDatabaseReplyTeradata Stored Procedure GOTOHi 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
11129 Aug 2015 @ 11:13 PDTDatabaseReplyRow Allocation to NOPI Table using FastLoadOh just to add one more thing, the data volume is really high say 20 million or more. Thanking You Santanu
11029 Aug 2015 @ 10:57 PDTDatabaseTopicRow Allocation to NOPI Table using FastLoadHi 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 ...
10901 Jul 2015 @ 12:42 PDTDatabaseTopicTeradata Stored Procedure GOTOHi 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...
10820 Feb 2015 @ 03:30 PSTDatabaseReplybteq utility query on TD databaseThanks Raja for your help. Thanking You Santanu
10720 Feb 2015 @ 03:30 PSTDatabaseReplyFind Second Highest Salary - SQLThanks guys for your response. Thanking You Santanu
10630 Jan 2015 @ 03:42 PSTDatabaseTopicbteq 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...
10501 Jan 2015 @ 07:09 PSTDatabaseReplyFind Second Highest Salary - SQLThanks Raja and Dnoeth for your responses. It was really helpful. Thanking You Santanu
10431 Dec 2014 @ 10:58 PSTDatabaseTopicFind Second Highest Salary - SQLHello 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 ...
10331 Dec 2014 @ 10:50 PSTDatabaseReplyQuery 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 ...
10225 Dec 2014 @ 06:07 PSTDatabaseTopicQuery 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...
10111 Sep 2014 @ 09:53 PDTDatabaseReplyDefining two derived tables using WITH clause ??Thanks Dieter for your update. Santanu
10011 Sep 2014 @ 05:29 PDTDatabaseReplyNumber of tablesThis document is really good. Thanks Raja
9911 Sep 2014 @ 05:24 PDTDatabaseReplyDefining 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 ) ...
9828 Jul 2014 @ 06:12 PDTDatabaseReplyESCAPE 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...

Pages