#DateForumTypeThreadPost
5612 May 2014 @ 07:25 PDTToolsReplyBTEQ Import REPORT Mode. Growing to bufferTHanks Dnoeth.. :).. Now the code is working fine..
5503 May 2014 @ 05:21 PDTToolsTopicBTEQ Import REPORT Mode. Growing to bufferHello All, When i try to import the fixed length data. The data is growing to buffer to 65473 and getting imported to the table. The problem is in the USING part. But not able to figure how to ove...
5403 May 2014 @ 05:21 PDTToolsTopicBTEQ Import REPORT Mode. Growing to bufferHello All, When i try to import the fixed length data. The data is growing to buffer to 65473 and getting imported to the table. The problem is in the USING part. But not able to figure how to ove...
5302 May 2014 @ 12:51 PDTToolsReplyBTEQ Batch Mode LogonHi Krishna, I have created the user Jugal. When i follow as what u suggest. THen i logon to interactive mode rite. I want to access the Teradata Mode.
5201 May 2014 @ 08:08 PDTToolsTopicBTEQ Batch Mode LogonHello All,   I tried loggin in BTEQ through the Batch mode: Below is how i tried Logging .LOGON 127.0.0.1/jugal,jugal <ENTER>   I am getting a Error as invalid logon. Could y...
5124 Apr 2014 @ 11:27 PDTDatabaseTopicJoin Indexes TeradataHello All, Below is my understanding of Join Indexes. Please help me correct if i am missing somewhere. Join Index creates a seperate storage in the PERM Space, used to reduce the CPU usage time....
5022 Apr 2014 @ 09:23 PDTDatabaseReplyGENERIC JDBC and Teradata DatabasesThanks for clarifying my doubt Tom. :-)
4922 Apr 2014 @ 02:29 PDTDatabaseReplyGENERIC JDBC and Teradata DatabasesThen what is the difference between GENERIC JBDC and Teradata Database connections. What changes does it bring when i create a user depending on these connections.   Could plz help...
4819 Apr 2014 @ 07:05 PDTDatabaseTopicGENERIC JDBC and Teradata DatabasesCould plz help me understand the difference between these two connections. Is it like when i connect a user with GENERIC JDBC, the session is ANSI. Eg. When i create table. By default, it is c...
4719 Apr 2014 @ 07:04 PDTDatabaseTopicGENERIC JDBC and Teradata DatabasesHello All,   Could plz help me understand the difference between these two connections. Is it like when i connect a user with GENERIC JDBC, the session is ANSI. Eg. When i create table. By ...
4607 Apr 2014 @ 04:14 PDTDatabaseReplyFast Load Format Binary ErrorI think the error is the DEFINE KEYWORD. I think i have not given a proper length for the columns EmpId and DeptId. I am right?
4507 Apr 2014 @ 03:14 PDTDatabaseTopicFast Load Format Binary ErrorHello All,   I am importing a Binary file using Fast Load. I am getting a error. Please help me find the error   Script: .LOGON jugal/jbhatt,jugal; drop table DB.employees; CREATE ...
4404 Apr 2014 @ 02:28 PDTToolsReplyDifferent Modes and FormatThanks feinholz. The Link u provided is very helpfull.  
4303 Apr 2014 @ 05:05 PDTToolsReplyDifferent Modes and FormatFeinholz, Where can i find the documentations? Can i find it in the forum itself?  
4203 Apr 2014 @ 03:16 PDTToolsReplyDifferent Modes and FormatI do not have any documents in particular. I google when i go wrong. In the worst case i post it here to get my doubts clarified. Thanks feinholz. :)
4103 Apr 2014 @ 03:13 PDTToolsReplyFast Export and Fast Load ErrorThanks feinholz.
4002 Apr 2014 @ 06:51 PDTToolsReplyFast Export and Fast Load ErrorHi Santanu, I have tried the sccript with TPT. i got a result. The above script ran when i changed the Empid and DeptId to Char(10). Because when we use the SET RECORD TEXT. we sud define a ...
3902 Apr 2014 @ 03:19 PDTToolsTopicFast Export and Fast Load ErrorHello All, Below script i exported the data using Fast Export and tried to import the data using Fast Load. While doing so. I am getting a error in FastLoad. Plz help me understand. Where i am goi...
3801 Apr 2014 @ 07:32 PDTToolsTopicDifferent Modes and FormatHello All, I am new to teradata. Could u help me understand the advantages of using different MODES and FORMAT in Fast Export and Fast Load. MODE RECORD[INDICATOR] FORMAT BINARY[FASTLOAD,TEXT,UN...
3728 Mar 2014 @ 03:44 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorFeinholz, For the issue i was facing for FORMAT "delimited" is working fine. Please help me understand the "FORMATTED" type with an example.   It would be very helpfull....
3628 Mar 2014 @ 02:38 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorFeinholz, I have entered the data with the end of record marker. When i entered the 1st record. I clicked on ENTER button and the 2nd set of record was included. But still this error per...
3527 Mar 2014 @ 02:32 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorHi Feinholz, I applied "Delimited" Format with the TextDelimiter=','. I also made the changges in SCHEMA EmpId VARCHAR(10). Below is the changes in the Scrip...
3426 Mar 2014 @ 09:06 PDTToolsReplyTPT Error using DATACONNECTOR PRODUCER OperatorHi Krishhan,   Below is the DDL:   CREATE MULTISET TABLE DB.MLOAD_INPUT_INSERT ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL...
3326 Mar 2014 @ 08:00 PDTToolsTopicTPT Error using DATACONNECTOR PRODUCER OperatorHi All, Please help me where I am going wrong. The error im getting is relating to the FileName given. This is the First time i am using TPT. Below is the TPT Script:   DEFINE JOB FlatJOB...
3221 Mar 2014 @ 02:27 PDTToolsTopicError in MLOADHello All, This the first time i am running MLOAD Script. Please Help me find the error. Script: .LOGTABLE DB.logs2; .LOGON Jugal/jbhatt,jugal; CREATE MULTISET TABLE DB.Mload_Input ,NO FALLB...

Pages