Have PLANNING_INFO table, there is a field ids, the DATE, check first after the DATE the incoming PLANNING_INFO table, match the DATE fields find out what is today new ID; In these ID at the same time, the new library will generate some table, the table is the name of the table according to the form of ACTIVE_ID patchwork, and get a check to the ID of the joining together and then the table name, respectively, to check the list of information, my understanding is need two cursors nested, but for the first time to write the DB2 stored procedures are always all kinds of error, and internal cursor is joining together the SQL table name, make for a long time didn't come out, bosses help
CodePudding user response:
Written check dynamic SQL, you know