DSXchange

Thanks Ernie,

I have contacted support provided and they have advised to install APAR JR37813. Hopefully it might work for us. Will let you guys know if that is the case.

Hi, I am fairly new to Metdata Workbench and am working on proof of concept in using Metadata Workbench procured recently. The version of Metadata Workbench used at site is 8.1.2.3 and DataStage version is 8.1 Job details: We have written a simple job to test the functionality to begin with, where d...

Hi Vidyut, You can still try Mansoor's original approach. Before loading Link 1 with duplicate rows into the table put them into a flat file and then load it. This will allow for unique data to be loaded into the table (Link 2) before Link 1 (via Flat file) attempts to put a lock into the table. Thi...

For job name, start date and start time you can call DataStage macros DSJobName, DSJobStartDate and DSJobStartTime in a transformer stage and pass them to Oracle stage to be stored. Not sure for end date and end time.

Thanks for your quick response. After making below changes its working now. When I'm wirting the xml file using xml output stage,i have unchecked the option of generate formatted output and it resulted the file in below format <import><row><a>10</a><b>20</b><c>30</c></row></import>. When reading thi...

Hi, I'm trying to read xml file and write it into text file using folder stage ->xml input -> transformer->Seq file. Job finishes successfully but when i try to open the seq file data looks in b elow format 10 , 20 , 80 .I want the output to be like 10,20,80 2nd record .............. Here is the Inp...

Hi Ray,

I haven't used '?' this character anywhere in my job.
In command prompt stage if i select the check box of
'Abort if command fails' the job fails though the script is excected successfully.If i disable the checkbox job too finishes successfully.


Thank you
Kartheek Matoor

Hi, I'm running a .bat file using command prompt stage.Bat file is executed successfully but job is failing with below error. Command failed to execute - e:\apps\ascential\Projects\xxx>More? . Log file is created which contains this message 'e:\apps\ascential\Projects\xxx>More?' Please let me know w...

Hi chulett,

Yes,I'm creating a file before the loop begins and using basic statement WriteseqF to insert data into the file created and delete the file at Exit.

Thanks to all of you for your inputs.
Yes,I think the only way to do is writing into file and then reading it again after End loop activity.

Hi, I want to capture the user status of same job executed in loop with different parameters. Here is my scenario Job Seq: Start Loop Activity(For loop i=1 to 4) ->Job Activity->End Loop Activity. I want user status of each job activity run so that I can use it after End loop activity.I want to avoi...

Hi Ray,

This is resolved now.

I tried placing quotes but it didn't work.Lastly I tried rewriting the same sql in one line and it worked.

Thanks.


Regards,
Kartheek

Hi, When I'm trying to access two hash files from universe stage i get below error.These two hash files are created under directory.I set these file paths,created and built indexes through ds adminstratior. Please let me know how to fix this error? GSO05_Occ_Investigation_FactLoad..UniVerse_39.DSLin...