SQLCODE -305 SQLSTATE 22002 - Indicator variable required-Reply

[David Morris <dmorris@xxxxxxxxxxxxx>]

>>> "Juris Krikis Jr." <juris.rfb@mail.bkc.lv> 09/09 5:59 am >>>


I am writing quite a simple program embedding DB2/400 SQL in ILE
RPG/400 programs and having a really weird problem.

The problem is that after line 0045.00 I get an SQLCODE of -305 and an
SQLSTATE 22002, which means "Indicator variable required" (B-13 of "DB2
for OS/400 SQL Programming V3R7").

If you do a partial join or the table could contain null fields you need to code
an indicator array to indicate null fields.

It  wants an array of 2 byte Binary.  1 element per field selected.  If it 
contains
a -1 it is null.  You can specify the array on the fetch after the fields.  I 
don't
have time right now to send and example but it is in the SQL manual (with
poor examples).

Hope to have helped

David Morris  


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *