Query related to inserting an auto populated value in db2

Gopalakrishnan V · Posted: Fri Dec 18, 2015 12:09 am

Hi,
I want to insert values in child table.I have seq-num field which is auto populated.so I hav not used the field itself in insert querry.
While promoting in changeman I get SQL code -407 .
Seq num is defined as smallint not null.
SQL 407 means trying to insert null value in a field declared as not null.I havnt used the field itself in insert.Any idea how to solve it??
I tried inserting the field also.I got SQL -206. Object used in a place which is not valid.I.hav no clue..Pls help
Thanks in advance

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

Why do you think it is the Seq-num which is giving trouble?

Are you sure you are not missing any column in the insert query ?

.

Rohit Umarjikar · Posted: Fri Dec 18, 2015 5:43 am

chandan.inst · Posted: Fri Dec 18, 2015 9:03 am

Hi,

If the Seq-num is defined as smallint Not null, how its getting auto populated?

Also how you come to conclusion seq-num is the culprit for -407?

its better if you share the table structure and code snippet

Regards,
Chandan

Nic Clouston · Posted: Sat Dec 19, 2015 5:58 pm

What has changeman got to do with this? When promoting, object are moved not executed. Are you saying that before promotion the objects worked in the environment but failed after in the same environment or failed in a different environment. If the latter then there is a discrepancy between environments. If you did not test before promotion then go shoot yourself.