unload data for 3 fields from large informix table

[singhald]

Hello All DataStage Guru,

I am using informix DB in my DS project. I want to unload the three columns from a very big table which having more than 100000000 records.

Please sugest me some efficient way to unload the data from table.
it can be by DS job or any scripts.

one column out of thouse is primary key .

Thanks

Singhal

[chulett]

Define 'unload'. If all that means is 'dump to a file' with no transformations, that is usually best done with tools your database provides.