0 - 10 of 10 tags for tdload

Hello:
Is there a way to only load specific columns from a flat file using tdload?  Say my flat file has five columns, but I only need the last three.  Is there anyway to specify the first two columns as dummy columns or something equivalent maybe in the schema?  Thanks for your help!

[1] $FILE_READER[1]: TPT19134 !ERROR! Fatal data error processing file 'input_import.csv'. Delimited Data Parsing error: Invalid multi-byte character in row 221, col 1.

[2] freetext VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC

Hi,
We are using TDLOAD mechanism to load Staging Layer from File. I belive the default DATE and Timestamp format in the input file which has been configured in DBS Utility would be accepted only. e.g. YYYY-MM-DD.

I want to load a flat file which is divided by 0x0001 by tdload command to Teradata. You can find my two commds below.

But they both reported "length overflow the first row" .In my opinions, I dont's set delimeter corretly.

 

tdload -f filename \

-u user -p passwd -h server -t tablename \

I want to load a flat file which is divided by 0x0001 by tdload command to Teradata. You can find my two commds below.

But they both reported "length overflow the first row" .In my opinions, I dont's set delimeter corretly.

 

tdload -f filename \

-u user -p passwd -h server -t tablename \

I'm trying to load a csv file into a table using TPT Easy Loader.
The error I'm receiving is "Object Addresses2_RL does not exist." on the first run of the below script.
tdload -f "C:\addresses_table.csv" -t "Addresses2" -h tdat15 -u user1 -p *pw* --TargetWorkingDatabase "SQL_CLASS" -d ,

Hi,
I am trying to load a file with sample content like below, where the delimiter is comma(,) and have one of the field which actually contains a comma. The Source team has sent the data set by including such fields in quotes (""). I tried loading using tdload of version 13, but it failed.
Ex: 

Hi
I need to load a flatfile into TD using tdload utility, but skip the header row while loading. Is it possible to skip the 1st row i.e Header and load the remaining lines.
Thanks
Manjeeth
 

Hi, I'm trying load a txt file into a table with auto increment primary key. Don't know why even though i defined my 2nd column as varchar (18), tdload thinks max length for it is 11. Can anybody please help? Thanks!

If you’re waiting for an easy way to load data from one or more Teradata table(s) into a Teradata table without writing a Teradata PT script, wait no further.  Teradata PT Easy Loader can do it easily.  In the 14.0 release, the tool can load data from a Teradata table or from SELECT statement(s).