Upload files .dat in Teradata

Tools
Enthusiast

Upload files .dat in Teradata

Hello ,

I have a question concerning the upload of files in Teradata.

Is it possible to upload in files .dat in Teradata? Files .dat are files with fixed record lengths, without tab or any other coloumn delimiter.

Thank you and best regards,

Valeria

7 REPLIES
Senior Apprentice

Re: Upload files .dat in Teradata

Hi Valeria,

of course Teradata's load tools support fixed length data, depending on your actual data & tool it's e.g. Format = 'Text' in TPT for all character fixed length (your input schema must be all CHARs then).

Enthusiast

Re: Upload files .dat in Teradata

Hello Dieter,

thank you for your quick answer.

Please have a look at my Teradata Tools Settings in the file in attachment. Maybe you can help me to flag and choose the correct settings because I don't find "Format = "Text".

Thank you,

Valeria

Teradata Employee

Re: Upload files .dat in Teradata

SQL Assistant only imports delimited files. But the command-line utilities allow you to define fixed record layouts.

Enthusiast

Re: Upload files .dat in Teradata

Hello Fred,

thank you. Where can I find the command-line utilities?

Thank you and best regards,

Valeria

Teradata Employee

Re: Upload files .dat in Teradata

Teradata Parallel Transporter, BTEQ, FastLoad, MultiLoad are part of the TTU base bundle that also includes SQL Assistant.

Enthusiast

Re: Upload files .dat in Teradata

Hello Fred,

a question concerning this topic. Teradata Parallel Transporter, BTEQ, FastLoad, MultiLoad are programs thatI have to download to be used with SQL Assistant or are kind of SQLs that allows to upload flat files in Teradata?

Thank you and best regards,

Valeria

Teradata Employee

Re: Upload files .dat in Teradata

They are separate batch-oriented client utilities, unrelated to SQL Assistant.