DSXchange

Hi, We have a DB2 table which contains more than 100 million records. And this table is a part of container logic, where we are performing sparse lookup on this table twice in the same job using ODBC Stage. This Job runs fine, if we pass less than 100 Records. If Records are more than 100, Job abort...

We are getting pipe line delimited file in production and splitting it using the following logic. else if svRecNum='510' and len(Field(in_D0225.Column1,'|',14)) >40 then Field(in_D0225.Column1,'|',14) else if svRecNum='510' and len(Field(in_D0225.Column1,'|',15)) >40 then Field(in_D0225.Column1,'|',...