ALWNULL(*USRCTL) v ALWNULL(*YES) was (strange SQL dumps)

[Frank.Kolmann@xxxxxxxxxx]

Thanks Carel,
I still dont understand what is the difference between
ALWNULL(*USRCTL) and  ALWNULL(*YES).
I thought  (*USRCTL)  did everything (*YES) did and
more (dont know what more).

Anyone shed light on this, and does the precompiler
treat the ALWNULL parm differently to the RPG compiler.

Frank Kolmann


*********** REPLY SEPARATOR  ***********
from: "Carel Teijgeler" <coteijgeler@chello.nl>
subject: Re: Strange SQL dumps

Frank,

ALWNULL(*USRCTL) gives you the possibility to use the %NULL bif.

I could not use that option, because my programmes run in batch and can
accept any kind of prepared SQL statement.

It is more a problem with the compilation, not the well-honoured and
all-loved precompiler (which appears to be older than RPG II).

Regards,
Carel Teijgeler.


*********** REPLY SEPARATOR  ***********

On 13-2-03 at 10:29 Frank.Kolmann@revlon.com wrote:

>Thanks Carel,
>I already have ALWNULL(*USRCTL) in the header.
>Is this different to ALWNULL(*YES)?
>But this is a SQLRPGLE  so I suspect it could be a
>problem with the <...censored..> SQL precompiler