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

I am pretty sure that is not the case - because DSPFFD of the table shows the fields as null-capable. DSPFFD of the logical shows the same fields as null-capable.

BTW, the table is named TITLES - I duplicated the titles table that is in the SQL Server pubs sample database. Basically used the CREATE TABLE statement that would have been used there, modified as needed for IBM i.

On 10/15/2015 7:53 AM, darren@xxxxxxxxx wrote:

Was your SQL table created without the "not null with default" clause on
each field by chance?

This is some example source of how we create files:

create table PMGLS (
Year char(4) not null with default,
Period char(3) not null with default,
Account char(16) not null with default,
Company char(16) not null with default,
Customer char(12) not null with default,
Product char(48) not null with default,
Amount decimal(15, 2) not null with default,
Book char(10) not null with default
)



From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date: 10/15/2015 08:43 AM
Subject: Does RPGLE handle NULL capability differently between DDS-based
and SQL-based files?
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



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.