a year ago, our php programmer set up a table with null values allowed. That caused me a problem, so I generated the sql, changed it to not null, deleted the table off, and rebuilt it. All was fine (or so I thought). We use it every day, all day long, without problems.
Today I try to add a new field and I get a sql system state error that says that a not null field contains null values. I remember a year ago when I put in a topic asking some questions, bob told me that the null stuff is stored somewhere.
I made a copy of the table and then used an rpg2 program to read all the records and I get a "empty record" which if you look with wrkf in the db table it isn't there. I tried on a copy of the table to clear it, delete the blank record and reload the data into it, and I get the data mapping errors but the odd thing is there is NOTHING wrong with the data, it tells me record 0...
I have this same table on another i, and of course when I generated the specs for it and loaded it over there, it was all not null and it has the same sort of data in it and all is fine in adding columns, etc. (no data mapping errors).
Any thoughts on this? Doing sql selects, there are no records with values less than 1 in the numeric fields, etc. And what really stumped me when I had a flat file to load into a cleared table, I couldn't and got same mapping error.
It is like there is some attribute somewhere in one of those other sql related crap that...