Re: SQL in RPGIV Error Message

[Brian Parkins <parkib@xxxxxxxxxx>]

It would appear at least one of the columns in the table is null-capable - 
and contains a null value.

Have you compiled with ALWNULL(*USRCTL) to accommodate this?

If you wish to process the null-value column, you will need to define a 
further indicator variable, (5I 0 - NOT a Logical Indicator) on the SELECT 
statement, e.g.

SELECT COL1, COL2 ,,,,,  INTO  :VAR1 :IND1, :VAR2, etc.

The indicator variable will contain 0 (not-null) or -1 (null).  (Indicator 
variables can also be used to check for errors such as truncation or data 
mapping.)

Brian Parkins