DSXchange

The following is routine that had given as input: Cmd='. ~/.profile;db2 "connect to ':DatabaseName:' user ':UserId:' using ':Password:'"; db2 "delete from ':SchemaNameDM:'.':TableName:' where CALENDAR_MONTH_KEY IN (SELECT CALENDAR_MONTH_KEY FROM ':SchemaNameDM:'.D_CALENDAR_MONTH WHERE...

Hi all, We are using one DS routine to DELETE the data from a table (DB2) befor e load. The routine, if run individually, works fine. But when integrated in a sequencer, doesn't work. We have String comparison in the WHERE clause of the DELETE SQL. If we remove WHERE clause the routine works fine ev...