#DateForumTypeThreadPost
2527 May 2013 @ 06:14 PDTGeneralReplyteradata SQL sequence generationTRY THIS:   INSERT INTO xref_subject_area SEL TB3.MAX_ID+CSUM(1,TB1.subject_area_nm) AS subject_area_ID, TB1.subject_area_nm,TB1.subject_area_nm||' DESC' FROM detail_s...
2427 May 2013 @ 05:59 PDTGeneralReplyHow to INPUT values from table into Stored ProcedureHi Guys I got this requirement working. I used ref cursor and it worked fine.
2324 May 2013 @ 10:38 PDTGeneralTopicHow to INPUT values from table into Stored ProcedureHi Guys I have created a Stored Procedure which do some string manipulation. Below is much simple version of actual string manipulation. REPLACE PROCEDURE TST_PROC(IN VAL_TO_CHANGE VARCHAR(30),...
2214 May 2013 @ 01:27 PDTGeneralReplyCheck the Header of Flat file while MloadWhy you want to do this pre-check via MULTILOAD? You can check this via UNIX and discard the file if header is not matching. In that case, you don't have to invoke Multiload utility.
2114 May 2013 @ 01:24 PDTGeneralTopicDoes type of table [SET/MULTISET] is considered while fetching data from table ?Hi, As per my understanding, if I am sure that SOURCE will always send UNIQUE rows I should create Target table as MULTISET table as it will ignore the ROW LEVEL CHECK which a SET table performs t...
2014 May 2013 @ 01:16 PDTGeneralReply'Row Number () Partition By' syntax problemSELECT AA.Subscription_Id , AA.Wrls_Prod_Eff_Dt , AA.Wrls_Prod_Cd , AA.Wrls_Prod_Ds ,AA.RANK_ID FROM ( SELECT A.*, ROW_NUMBER () OVER (PARTITION BY Subscription_Id ORDER BY Wrls_Prod_...
1910 Apr 2013 @ 07:49 PDTGeneralReplyBLANK FROM SOURCE IS CONVERTED TO 0 while loading into TableThanks for the replies. KS42982: It is not the NULL I am talking about, NULL are getting loaded as NULL only in the table. It is Blank Values ('') which are getting converted to 0 while in...
1809 Apr 2013 @ 04:30 PDTGeneralTopicBLANK FROM SOURCE IS CONVERTED TO 0 while loading into TableHi I have a table and while loading the table , if the column is INTEGER then blank from SOURCE is converted to 0 i.e. numerical ZERO.  Why is this happening ? Does this mean we cannot have B...
1702 Apr 2013 @ 07:04 PDTGeneralTopicCURRENT_TIME - TIME '00:00:00' hour to second giving wrong outputHi   I am trying below SQL: SEL CURRENT_TIME, ((CURRENT_TIME - time '00:00:00') hour to second(0)) ;   Output is : 09:23:56 | 8:23:56 Doubt is why the second column is havin...
1629 May 2012 @ 03:21 PDTGeneralTopicCatching ACITIVITYCOUNT value using PROCEDURE Hi I have created a procedure to catch activitycount of any DML.   replace PROCEDURE test_SP(tb_name varchar(250)) BEGIN UPDATE stats_data SET TOTAL = TOTAL + ACTIVITY_...
1527 Mar 2012 @ 04:53 PDTDatabaseReplyteradata sql return string to blank column Kindly specify the SQL Assistant Version you are using and also the structure of the table. Trying casting name & address into varchar and check if it display the values.
1416 Feb 2012 @ 10:56 PSTDatabaseReplyImport Problem - Date field Hi Make sure that the format of Date column in Target is same as the one in file you are using for Import.
1316 Feb 2012 @ 05:54 PSTGeneralTopicWhich is better GROUP BY, DISTINCT or SET table I want to know which one is better to handle duplicate records ; is it using GROUP BY or DISTINCT while selecting data from Source table or Creating Target table as SET table ? Thanks in adv...
1213 Dec 2011 @ 03:11 PSTGeneralTopicTeradata CHAR datatype not storing NUMERIC values Hi I am trying to store some numeric values in a field. however when I am trying to select that field it is not showing me proper result. eg:   create volatile table test ...
1116 Mar 2011 @ 01:24 PDTGeneralReplySET CHARSET IN MULTILOADCan I give something like this in my mload.However it is not working for charset. BEGIN IMPORT WORKTABLES ERRORTABLES ERRLIMIT SESSIONS CHARSET 'UTF8' Any suggestions ?
1015 Mar 2011 @ 05:00 PDTGeneralTopicSET CHARSET IN MULTILOADHOW TO SET CHARSET IN MULTILOAD. I TRIED THE FOLLOWING CODE SET SESSION CHARSET 'UTF8' IN MY FASTLOAD AND IT WORKED FINE.HOWEVER WHEN TRYING IT IN MULTILOAD I AM GETTING ERROR : INVALID CO...
914 Mar 2011 @ 06:28 PDTGeneralTopicCall macro inside a macro based on some conditionHi I want to call a macro inside a macro based on some condition. Say: replace macro testMacro1(Name varchar(20)) as ( if ( :Name='XYZ') then exec testMacro2 else exec testMacro3 );...
829 Sep 2010 @ 11:20 PDTGeneralReplyWhat role does last 16bit play in 32 bit ROW HASHHi Jim I used to think that last 16bits are used to identify Table to which it belongs to. Can you confirm if last 16bits act as Table ID or not ?
729 Sep 2010 @ 12:43 PDTGeneralTopicWhat role does last 16bit play in 32 bit ROW HASHI learned that after hashing algorithm 32bit ROW HASH is generated. First 16bit helps in determining AMP in which we will store our row. However I want to know what role does last 16bit have? ...
629 Sep 2010 @ 12:40 PDTGeneralReplyDifference between Product Join and Cartesian Product JoinI read it in some book , separate Join strategies as Product and Cartesian. Anyways Thanks for sharing the info.
526 Sep 2010 @ 11:47 PDTGeneralTopicDifference between Product Join and Cartesian Product JoinHi ! I want to know if there any difference between Product Join and Cartesian Product Join ? If not then why do we have separate Join strategies as Product and Cartesian in Teradata ? Tha...
402 Sep 2010 @ 03:46 PDTDatabaseTopicTIMESTAMP(0) showing .0 at the endHi ! I am trying to fetch some data from my table and save it in a file using JDBC. One of the column is of TIMESTAMP(0) format. In the table data is like : 2010-09-02 07:47:02 However ...
311 Aug 2010 @ 11:43 PDTGeneralReplyTeraJDBC driver not supporting BIGINT DatatypeHey Thanks Dude ! It is working perfect now ... KUDOS !
211 Aug 2010 @ 10:57 PDTGeneralReplyTeraJDBC driver not supporting BIGINT DatatypeHi ! I am using TeraJDBC4. Still it is not working. It is giving unrecognized datatype.
111 Aug 2010 @ 05:40 PDTGeneralTopicTeraJDBC driver not supporting BIGINT DatatypeHi ! I am trying to connect to Teradata using JDBC. However for BIGINT datatype it is thowing an error. I want to know if TeraJDBC4 does not support BIGINT datatype. Is there any other JDBC...

Pages