Bteq import

Tools
Fan

Bteq import

Hi all,

I need to import my data to teradata, from BTEQ script
i have more than 20 000 row and more than 20 column
how does it wokrd?
thank you for your help in advance
7 REPLIES
Enthusiast

Re: Bteq import

Hi,

If the destination table is empty, the best tool is fastload, else use multiload tool.

Regards.
Fan

Re: Bteq import

thank you for your replay but
i do not have any tools,
i have to do it only by bteq scropt
any help plz?
Enthusiast

Re: Bteq import

Hi all,
we are all working with all teradata utilities...
but real time when you will go for TPUMP??
don't say that if you want to store the data into target tables more than 60
Enthusiast

Re: Bteq import

we have five loads in MLOAD?
I know the phases...i need the execution process of those phases
can you please send me the information

thank you for your help in advance:)
Enthusiast

Re: Bteq import

by using bteq you can load the data into target tables uptp <1/2billon rows
Fan

Re: Bteq import

could you plz give an example of a bteq imprt file

the structure of my file is as below:
id_tem; cdP;ref;
-------------------
123. fr slqms mlkmlk

and the data type are as below

first is decimal the rest are varchar 30
thank you for your helps
Arash
Fan

Re: Bteq import

could you plz give an example of a bteq imprt file

the structure of my file is as below:
id_tem; cdP;ref;
-------------------
123. fr slqms mlkmlk

and the data type are as below

first is decimal the rest are varchar 30
thank you for your helps
Arash