I am using DB2 v8.1, I have a requirement to unload from table A, which is to be joined with another table B to check certain condition.

The unloaded file should be in ASCII, delimited format and have unpacked data.
1)I know about DSNUPROC but I am unable to give join condition there.

2)I know about DSNTIAUL, here I can unload but how to generate the file in ASCII and delimited dormat.

Can anybody tell me which way accomplishes my requirement.