| 56 | 12 May 2014 @ 07:25 PDT | Tools | Reply | BTEQ Import REPORT Mode. Growing to buffer | THanks Dnoeth.. :).. Now the code is working fine.. |
| 55 | 03 May 2014 @ 05:21 PDT | Tools | Topic | BTEQ Import REPORT Mode. Growing to buffer | Hello 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... |
| 54 | 03 May 2014 @ 05:21 PDT | Tools | Topic | BTEQ Import REPORT Mode. Growing to buffer | Hello 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... |
| 53 | 02 May 2014 @ 12:51 PDT | Tools | Reply | BTEQ Batch Mode Logon | Hi 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.
|
| 52 | 01 May 2014 @ 08:08 PDT | Tools | Topic | BTEQ Batch Mode Logon | Hello 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... |
| 51 | 24 Apr 2014 @ 11:27 PDT | Database | Topic | Join Indexes Teradata | Hello 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.... |
| 50 | 22 Apr 2014 @ 09:23 PDT | Database | Reply | GENERIC JDBC and Teradata Databases | Thanks for clarifying my doubt Tom. :-)
|
| 49 | 22 Apr 2014 @ 02:29 PDT | Database | Reply | GENERIC JDBC and Teradata Databases | Then 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... |
| 48 | 19 Apr 2014 @ 07:05 PDT | Database | Topic | GENERIC JDBC and Teradata Databases | 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 default, it is c... |
| 47 | 19 Apr 2014 @ 07:04 PDT | Database | Topic | GENERIC JDBC and Teradata Databases | Hello 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 ... |
| 46 | 07 Apr 2014 @ 04:14 PDT | Database | Reply | Fast Load Format Binary Error | I 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?
|
| 45 | 07 Apr 2014 @ 03:14 PDT | Database | Topic | Fast Load Format Binary Error | Hello 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 ... |
| 44 | 04 Apr 2014 @ 02:28 PDT | Tools | Reply | Different Modes and Format | Thanks feinholz. The Link u provided is very helpfull.
|
| 43 | 03 Apr 2014 @ 05:05 PDT | Tools | Reply | Different Modes and Format | Feinholz,
Where can i find the documentations?
Can i find it in the forum itself?
|
| 42 | 03 Apr 2014 @ 03:16 PDT | Tools | Reply | Different Modes and Format | I 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. :)
|
| 41 | 03 Apr 2014 @ 03:13 PDT | Tools | Reply | Fast Export and Fast Load Error | Thanks feinholz.
|
| 40 | 02 Apr 2014 @ 06:51 PDT | Tools | Reply | Fast Export and Fast Load Error | Hi 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 ... |
| 39 | 02 Apr 2014 @ 03:19 PDT | Tools | Topic | Fast Export and Fast Load Error | Hello 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... |
| 38 | 01 Apr 2014 @ 07:32 PDT | Tools | Topic | Different Modes and Format | Hello 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... |
| 37 | 28 Mar 2014 @ 03:44 PDT | Tools | Reply | TPT Error using DATACONNECTOR PRODUCER Operator | Feinholz,
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.... |
| 36 | 28 Mar 2014 @ 02:38 PDT | Tools | Reply | TPT Error using DATACONNECTOR PRODUCER Operator | Feinholz,
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... |
| 35 | 27 Mar 2014 @ 02:32 PDT | Tools | Reply | TPT Error using DATACONNECTOR PRODUCER Operator | Hi 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... |
| 34 | 26 Mar 2014 @ 09:06 PDT | Tools | Reply | TPT Error using DATACONNECTOR PRODUCER Operator | Hi Krishhan,
Below is the DDL:
CREATE MULTISET TABLE DB.MLOAD_INPUT_INSERT ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL... |
| 33 | 26 Mar 2014 @ 08:00 PDT | Tools | Topic | TPT Error using DATACONNECTOR PRODUCER Operator | Hi 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... |
| 32 | 21 Mar 2014 @ 02:27 PDT | Tools | Topic | Error in MLOAD | Hello 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... |