Can we use a BCP Load to load data into Sequential Files

[sck]

Hi All,
Can we use BCP to be loaded in Sequential Files. If yes how can we do it.
I see only options to a SQL Server.

Thanks
Krishna

[ogmios]

Hi All,
Can we use BCP to be loaded in Sequential Files. If yes how can we do it.
I see only options to a SQL Server.

Thanks
Krishna

How would you bulk load to a sequential file ?
Bulk loaders usually take a sequential file and dump it into a database by sidestepping a lot of database checks, temporarily dropping indexes, ... For simple sequential files no such thing exists or would be needed.

Just use a sequential stage.

Ogmios

[marc_brown98]

Hi All,
Can we use BCP to be loaded in Sequential Files. If yes how can we do it.
I see only options to a SQL Server.

Thanks
Krishna

How would you bulk load to a sequential file ?
Bulk loaders usually take a sequential file and dump it into a database by sidestepping a lot of database checks, temporarily dropping indexes, ... For simple sequential files no such thing exists or would be needed.

Just use a sequential stage.

Ogmios

natively in sql server and sybase you used to be able to use bcp with a -out parameter and it would unload tables. It can be handy, when needed.

[ray.wurlod]

But then you wouldn't need DataStage.

You could, of course, use DataStage to trigger the bcp -out command if needed as part of something larger. But why not use the graphical design paradigm; SELECT from your SQL Server table and write to a file through a Sequential File stage.

A Sequential File stage is the fastest of all DataStage stage types.