DSXchange

I have several delimited files that I want to use to update an Oracle table using RCP and a schema file. Each table has a different set of keys and each file has different columns. Is it possible to do this dynamically?

Hello. We are using Datastage version 9.1 on Windows 2008. We have a job that takes multiple datasets and tries to combine them in the XML stage. This job was running fine but is now failing with the following errors: xml_assemble_aqi_files,0: Failure during execution of operator logic. xml_assemble...

Thank you, we will head in that direction.

Your help is very much appreciated.

Hello. I am new to Datastage 9.1 and am trying to find a way to collect the following information from a parallel job after it runs: Job Name Job Status Start Date End Date Records Read Records Updated Records Inserted I want to take this information and update a table in our Data Warehous for each ...

Thanks for the replies. I will try the suggested and let you know how it goes.

Hi, I am creating a Datastage job that is making a call to an oracle DB. I need to be able to pass in the min/max values from a flat file as parameters to only pull the records that apply (to avoid pulling the entire table into memory). Things I have tried: Temp table (Doesnt work due to DB environm...

Hello.. We are using Datastage 9.1 on Windows. I am trying to convert a date format of mm/dd/yy to yyyy/mm/dd and am having problems getting the correct 4-digit year. Here is my derivation: DateToString(StringToDate(DSLink6.DischargeDate,"%dd/%mm/%yy"),"%yyyy-%mm-%dd") Example: 0...

That worked (selecting something after the delete). Thanks!

I am using an OLE/DB stage to do a delete from a SQL database. There will be no output from the stage, but I have it linked to a Transformer and then a Sequential file so I can get the output tab on the OLE stage. I am getting a link initialization failure on the job, but it executes the delete stat...

I need to run a SQL delete statement. I am using the OLEDB stage and need to have either an input or output stage in order to be prompted for the SQL select tab. I tried using an output file and am getting a 'link initialization failed' error. I am not sure how to correct.

Thanks.