DSXchange

Thanks for taking the time to respond: I am however having a hard time making sense of it, being fairly new to datastage. My comments are listed beneath your steps. Step 1 is very straightforward. Generate the current date (CurrentDate() function) in a single generated row and use user-defined SQL t...

As part of a migration process I have to record receipt and validation of multiple input files to the process. To do this I need to to do the following: * Create an entry in a a batch register table on an oracle database - I have written the following sql to do this: INSERT INTO MIGRATIONBATCH (MIGR...

Thanks "ArndW" and "chulett". I got it to work now. Mention was made of UserStatus - how do i go about accessing and setting this. I assume I can access the values in UserStatus by doing a similar routine as for the job info, but how do I go about populating values into UserStatu...

This looks like the answer to my dilemna if i can get the routine set up and working. Can you give me some pointers on how to create and use a server routine. What I am doing is not working. I created a new server routine and set the routine name to GetJobRowCount I left the type as Transform Functi...

The Px Job to validate the file content does the following: It has a CFF stage that reads the file and streams the data to a Transform function that does some type conversion and then routes the records down one of two paths. All detail records are routed to a copy stage that copies the fields to 2 ...

Yes\No validation would be fine, although it would be nice to get the rowcount recurned as well, but i can do without that.

I am new to datastage development having spent about 10 years working in various other ETL tools. I am finding working in Datastage rather heavy going. Anyway my scenario is the following. I need to build a job that will genertate an output file from multiple input files. Before these input files ca...