Re: SQL in RPGIV Error Message

[Justin Houchin <justinh@xxxxxxxxxxxxx>]

Yep, I just did add an indicator variable, that fixed the problem.  
Thanks for all of the help for everyone that replied.

Brian Parkins wrote:

> 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
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>