Export data from DB2 table to .txt file(space delimited)

Hi

I need help on this. Its very urgent for me.. please try to help me out..

I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export data using this but, it throws out errors.

first i created a file

touch masterDB.txt
chmod 777 masterDB.txt

export to masterDB.txt of txt select * from masterDB;

It throws the following error.

ksh: masterDB.txt: is not an identifier

Please help me out.. This is like a very urgent task for me..

I think its looking for some variable...or try it from any other shells..

I think you executed that command from the shell.
Try executing it after connecting to your DB2 database.

tyler_durden