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

["Tyler, Matt" <mattt@xxxxxxxxxxxxxx>]

Frank,
        There is no reason to have ALWNULL() in your program unless you
coded a file in the F-specs that allows nulls.  ALWNULL() have no effect on
any embedded SQL.  By the way I do not see in (V5.1) RPG manual anything
about ALWNULL(*YES).  Could that be your problem?   *USRCTL means you test
and set on/off the null indicator used for Input/Output.  The other useful
option is *INPUTONLY allows testing of the null indicator but nothing else.
See page 203-209 in V5.1 RPG reference. 

Thank you,
Matt Tyler
WinCo Foods, Inc
mattt@wincofoods.com

-----Original Message-----
From: Frank.Kolmann@revlon.com [mailto:Frank.Kolmann@revlon.com]
Sent: Thursday, February 13, 2003 14:53
To: rpg400-l@midrange.com
Subject: ALWNULL(*USRCTL) v ALWNULL(*YES) was (strange SQL dumps)

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


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