run of sql BTEQ script parts

General
New Member

run of sql BTEQ script parts

Hi Team,

I want to extract data for aprox 15K records, how can i execute command in bteq.

 

Thanks

1 REPLY
Senior Apprentice

Re: run of sql BTEQ script parts

Hi,

 

You need a SELECT statement to build the answer set.

 

You need to use the ".EXPORT" command if you want to write the data to a file.

 

If you want to know how to write a BTEQ script then have a look at the BTEQ reference manual.

 

Cheers,

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com