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 firstname.lastname@example.org -----Original Message----- From: Frank.Kolmann@revlon.com [mailto:Frank.Kolmann@revlon.com] Sent: Thursday, February 13, 2003 14:53 To: email@example.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" <firstname.lastname@example.org> 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-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.