EXPORT RESULT TABLE

[Ann28]

Any help is appreciated!!!!

DB2 8.2 on AIX.environment.


How do I export the result query into the non-delimited ASCII file and specify the export location?

Here is my export statement:

EXPORT TO testexp  OF DEL 
SELECT EARN, HRS
FROM BASYS.ACT_VAL_04  
FETCH FIRST 500 ROWS ONLY

EXPORT TO testexp OF DEL SELECT EARN, HRS FROM BASYS.ACT_VAL_04 FETCH FIRST 500 ROWS ONLY

Results:
SQL3104N The Export utility is beginning to export data to file "testexp".
SQL3105N The Export utility has finished exporting "500" rows.
Number of rows exported: 500

Where on AIX dir the file is located?

 

[Hattusas]

Warn me If I understand it wrong... But..
You can always state the location from the control center,both the import file and the export file.After the look at your generated script by pressing show script button.


Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[BrianTyler]

'testexp' could be a full catalog / file string, not just a file name.

e.g. /home/myuser/mydata/testexp

Obviously the syntax etc depends on your platform.

Your export example is to a comma-delimited file.


Brian

 

[Ann28]

Thanks everone for help
Here is the statment on how to export the result tbl:

export to "c:\temp\qtrfile.IXF" of del modified by nochardel decplusblank striplzeros