Re: Does RPGLE handle NULL capability differently between DDS-based and SQL-based files?

Hi Charles

Your understanding is the same as mine. And I appreciate the questions - so I looked at a couple listings. The one failure also had a mismatch on program name and procedure name. So that's inconclusive.

So I changed the code back to no ALWNULL control or compile option, and it compiled - even though there is a 0-severity message that says there are NULL=capable fields in the file - same for both programs.

One thing different about both - I am using an OAR handler - I've not done the NULL-capability processing into the handler, and RPG isn't telling me that the columns ARE null-capable, even though it knows. And sending data back, RPG doesn't stop it.

So I suspect that IF I return an indication that a field is null, that the program might blow up, unless I add the alwnull option - we shall see!

Thanks, man!
Vern

On 10/15/2015 8:01 AM, Charles Wilt wrote:

Vern,

I'm not aware of any differences, and my understanding is it shouldn't.

Are you sure about what you are saying? Are you sure the table has allow
null?

Same *LIBL for both compiles? Same compile command, CRTBNDRPG vs CRTRPGMOD?

Check the compile listing to see actual options in effect for both
compiles. I'm wondering if you've got a RPGLEHSPEC data area affecting one
compile but not the other.

Charles



On Thu, Oct 15, 2015 at 8:43 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Just ran into this and I' m not sure what I'm seeing.

I have a table (SQL) that I'm using in an RPGLE program. It has
null-capable columns in it. The compile went fine - I had no control option
and CRTBNDRPG ALWNULL parameter = *NO.

I have an LF (DDS) over the table that I'm using in another RPGLE program.
The compile fails, saying there are null=capable fields.Adding the ALWNULL
setting made it work.

So does RPG default to ALWNULL in some form with SQL tables? By design?

Curious I am!

Vern
--
This is the RPG programming on the IBM i (AS/400 and 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.