DSXchange

Hi,
I was able to solve this ODO problem using substring function available in transformer. Since we know in record how many times occurs clause occurs, I was abale to do substring and move to a fixed length column.

Hi,
One more thing is we have ODO in middle and after that we have regular fields which we want to use, so I can't really max out occurs.

Sreenivas

Hi, I am also having same problem, variable length file (file we are getting from third party) and I try to use CFF stage using OCCURS and depending on clause but it is not working. When I import copybook, it is expanding copybook to max occurs times(which is wrong). Thanks in advance for your help....

Hi Ray, Thanks for your reply on this. I looked into UV stage and if I have to use this stage looks like it is going to create table and then by using sql it will fetch data. In my case I am extracting information from Oracle table and loading into hash files for performance. I guess I can use direc...

Is it possible to do a range lookup in data stage server job?

In data stage job transform stage hashfile lookup, instead of using equal to, I want to do data range lookup (eg date between beg and end dt).

Data stage job stats (counts) stopped updating counts once it reached running time(elapsed time) of 24 hours, but it is till extrating records and writing into output file, only counts are not getting updated. Any idea why it is stopped updating counts after 24 hours mark reached, is it because coun...