DSXchange

How can I pass the current loop variable contents (an input file name) to the parameter a job that follows it in the sequence?

The loop is being controlled by a comma delimited string which contains the files I wish to process.

Thanks in adance for the help.

I wrote a Routine executed from Job Routine the returns a comma delimited string which is passed to a Start Loop. file1,file2,file3 The Start Loop uses it determine number of times to loop. How can I get the Sequential File Stage in the next Job in the Sequence to read each of the file names seperat...

I can get DSExecute to successfully excute the DOS and build a file on the Windows 2000 machine that contains the files that require processing. However, I can't get this into the correct delimited format, stored in a parameter, or get the Loop Stage to read the parameter. To my knowledge the 'type'...

Thank you for the suggestions. I will work with DSExecute to complete the task. Only thing is that I am running in a Windows 2000 environment so I can't use the Unix 'cat' function.

Thnaks again.

Is it poosible and if so looking for suggestions. I create a file list which contains the names of the sequential files that I need to process using an Execute Command Stage. I would like to process each of these files in the file list individually by looping within a job sequence. How can I pass th...

Amos,

That was it.

Thanks for the help,
dak

DataStage Server is located on a Windows 2000 Server and the Oracle Database is located on a Unix machine. When trying to import the Table Definitions it only looks for DSN located on the Windows 2000 Server. How can I get it to look on another machine to be able to import table definitions? In othe...

The data was fine. It was a metadata issue. The output and input table definitions must match for all columns, whether they are key columns or columns being updated.

I solved the problem.

I am really starting to understand how sensitive DS is in terms of definitions for data.

Thanks again for the suggestions.

Data isn't the issue. I have defined all the PK fields within the DS definitions to be decimal(9) and the remaining column is defined VARCHAR(15). I load the data to an empty table via DS and all rows are inserted. I try and run the exact same file again and the abort occurs. I don't have an issue r...

Thanks for the suggestions, I tried but still failed. Here is more info. 2 coulmn PK all columns set to DECIMAL(9). Job still failed with ORA-01401 and ORA-00001. First is value to large second is PK violation. I would agree with you based on the errors, but as you can see it didn't fix the problem....

In the ORA OCI I have set the Update Action to "Update existing rows or insert new rows", but I get Unique PK violation warnings. According to the manuals the OCI will attempt to update existing rows and if this fails perform an insert. I know all of the records should be Updates, could th...

Thanks Ray. That was almost as easy as writing a SQL UNION statement.

Is is possible to populate one of the pivot stage columns with a specific value based on which input column was placed in the output pivot column. For example: input data: EmpID CellNumber EmergencyNumber 1 618-555-1212 618-555-1313 2 618-999-1234 618-888-5678 desired result: EmpID PhoneNumber Type ...

Thanks Sainath. Now I understand.