Bteq import

Tools
N/A

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
N/A

Re: Bteq import

Hi,

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

Regards.
N/A

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?

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

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:)

Re: Bteq import

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

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
N/A

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