Re: SQL problem with DDL and record id constraint additional NULL problems

On 25-Apr-2014 15:14 -0500, Dale Janus wrote:

I have added the new field to my file with DDL. I removed
constraints, added constraints, I kept trying stuff until something
worked.

Not sure what this has to do with RPG.?

Now I am trying to use the tools I have used for many years to use
the new file in all my libraries. I use CRTDUPOBJ to make an empty
copy of the file I just added the field to in the next library I need
it. I try to move data into it using CPYF and *MAP *DROP. It fails
with CPF5035 error code 20 "-- A field that is not null capable could
not be set to null. "

The msg CPF5035 RC20 is indicating the row for the named column has a NULL value but the corresponding same-named field in the TOFILE() does not allow the NULL value.

I don't want null capable in any way, shape, or form to avoid
problems like this one. Yet I have them anyway.

When using ALTER TABLE [or CHGPF SRCFILE(named)] to modify the Record Format of the file, and the null-capable [ALWNULL] attribute is not desirable, then assign a DEFAULT [DFTVAL] for the column.

I just want to copy data, like I've done for years and years. If
there is an SQL command/tool as easy to use as CPYF, I'm willing to
try it.

INSERT INTO ... SELECT ... FROM ...

I am trying to use the new methods like DDL. But I have spent over a
day on something that should have taken less than an hour.

I am pretty sure I explained the situation and how to overcome the difficulties in my response on midrange-l:
http://archive.midrange.com/midrange-l/201404/msg00843.html