Hi all,

I am getting following error while I try to use a complex query to export the resultset.

SQL3022N An SQL error "437" occurred while processing the SELECT string in
the Action String parameter.

SQL0437W Performance of this complex query may be sub-optimal. Reason code:
"3". SQLSTATE=01602

SQL0437W is just a warning message for the select query and does return desired resultset. But because of that warning message my export command is failing with reason code 437 and error code SQL3022N .

This is ver 8.1 fixpack 5 on AIX 5.3 with 4 logical nodes.

I checked the forums and only error I got was for ver 6 that was fixed with service packs.

Has anyone faced such problem and how to resolve it?

Thanks in advance,
toby

Hi,

I also ran runstats on all the tables. But getting same error.
Any help is gretly appreciated.

Thanks,
toby

Dear Friend,

This is a simple error that you can resolve it by checking the fields which are in the table & the data which you want to import into the table. Both the fileds & the data should be same.
For Eg.

Consider a table called "student" which has 4 fields namely sno, name, total, percentage. But the user is going to import the data for that table like below

1, KK, 373, 74.5, 'Pass'
........
See the table is actually having 4 fields, but the user is trying to import the data for 5 fields. This is the problem caused in the given error.

Use the given below statement while importing....

db2 "import from data.csv of del insert into student(sno, name, total,percentage)"

Regards,
KK