Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: SQL3022N after SQL0437W

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    63
    Hi,

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

    Thanks,
    toby

  3. #3
    Join Date
    Jun 2009
    Location
    Chennai (Working), Trichy (Hometown)
    Posts
    1

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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •