Hello List, My current environment is Z/OS V 1.7 and DB2 V 7.1 I am migrating from Tivoli Decision Support for Z/OS Version 1.5.1 to TDS 1.6.0. My problem is when I run data collection job I get a -407 abend . SQLSTATE is 23502
(An insert or update value is null, but the column cannot contain null values.) . I ran the collection program with SQL trace option which is &ZZSQLSHOW=STMT. The trace shows the last call before abend -407 is insert to MVS_ACCNT23_PGM_T. I listed URLUPDATES table. The information from the table about MVS_ACCNT23_PGM_T is as follows: UPDATE NAME MVS_ACCNT23_PGM_T SOURCE SMF_030_2_3_X TARGET MVS_ACCNT23_PGM_T In this run of the collection program, this is the first insert to table MVS_ACCNT23_PGM_T. In one of my earlier run of the collection program, two inserts to the table were successful. The third insert abended. If I run the same job with version 1.5.1 libraries, the collection job runs successfully although I have migrated the tables to Version 1.6.1. Thanks for any feedback Ale --------------------------------- Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html