DSXchange

The problem looks like your meta data is not in agreement with your seq file. The offset is bieng caused due to the meta data and seq file mismatch.

The pic s9 is the one that could be creating the offset for you. In the transformer You need to use fmt DatatypePicComp for converting that field. I had the same problem but used fmt(DatatypePicComp(link.columnname),"R#9") for a pic s9 (09) field and it solved the problem. Hope this helps....

Thanks for the replies. I think a sequential file would be good for temp storage and then use a hash file too to run look ups on it later on. I am creating both a sequential file and a hash file same time from the transformer stage when ftping from the source mainframe.

Hi, We have to ftp a file from mainframe. It has around 400 thousand rows. I wanted to know if I should use a database temp table or use a sequential file as temp storage of this file, before further processing. On using target as sequential file it was around 39MB. What is good performance wise. Th...

You can have 3 different configuration files, one for each project. You have to point the APT_CONFIG_FILE enironment varaible to the specific .apt file.
Sam

welcome Aboard Srinu ! Dataset is Datastage specific file with .ds extension. It is used in parallel jobs for faster data loading as the dataset resides in the temporary disk space used by datastage parallel extender. The metadata should be same on the i/p and o/p links. You can check the manuals or...

That helps! thanks craig and vincent, hope to discuss more things in future.
Sam

Thanks vincent for your input. You got my requirement right, I want to duplicate the 44 columns 6 times with each row containing one of the remaining 6 columns.
Thanks again.
Sam

Thanks Craig I dont have the splitter.pdf, I will try to find out more about the row splitter and merger stage. Can I have 6 hash files which would have all the coulmns and one of the 6 columns to be split into separate row then use funnel stage if its a parallel environment ?, how else we could do ...

Hi,
This is my first post, quite a happening forum I must say. My question is how can we split a row with more than 50 columns which has 6 colums to be split into 6 rows. Whats the best strategy for implementing this. I know it can be done in a multitude of ways.
Thanks
Sam