DSXchange

I have a job parameter called input_file. In my job control code I try to open the file with the following code OPENSEQ "#input_file#" TO FILE THEN The job control parameter has a default value. I added some logging statements to see what is happening and it appears that the job parameter ...

I have a common hash file that will be used as a lookup by a number of different jobs. The jobs will lookup data from the file and then update the contents of the record and write it back to the hash file in the same job. I have tested it with a single job and the reading and writing to the hash fil...

1. not really sure what your saying in this solution? 2. One table is essentially a customer table and the second table is an account table, so a customer may have more than 1 account record. There may be more than 1 match. Therefore I don't think the hash file will work. 3. The source systems are 2...

I have 2 very large tables (million plus rows each). One table is on an Oracle database and the other table is on a Sybase sever. I need to join these 2 tables together. Obviously I can not do it using SQL since they are not in the same database. Can someone tell me the best way to join these tables...

I have a file with account records. I want to detect duplicate account numbers and send the duplicate records to a reject file. I sort the file by account number and then have an input link into a transformer. I have 2 output links from the transformer. Each output link has a constraint defined on i...