DSXchange

This is not a reply but a follow up question. I have a job in which I look up a UniverseStage which is being referenced with multi row result set and this job takes forever to run so what I did was I added an INDEX on the table at the before job subroutine ExecTCL=CREATE INDEX TMPINDEX ON SAP_SALES_...

Ken & Craig thanks a lot for your responses but the dummy has one more question how do i *tell* the aggregator stage that the input data is *SORTED*

When I reset the job using director I get the following message --------------------------------------------------------------------- From previous run DataStage Job 2129 Phantom 28311 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC progr...

Craig what do I look for in &PH& ??

I have a job that processees 345889 rows and aborts at around 270000 rows with the message -------------------------------------------------------------------- Message from DataStage Director: 71: xGDW00BocFeedActBudMtrlBillCost..AgGDDWBudMatBillCost: %s 72: Abnormal termination of stage xGDW00BocFe...

Use the FTP stage.

Hope that helps

Has anybody been able to work with DbaseIV files (DBF) on UNIX system though I did find this article http://www.tools4datastage.com/forum/topic.asp?TOPIC_ID=83734 But was just curious to know If anybody out here has been able to configure their systems to work if yes please let me know how to. Would...

I have had some similar problems when I changed the keys in a hash file but re-creating the file solved my problem.

Does anybody knows of any document which speaks about the risks of working with different Source System specially CSV.

Would appreciate if you could tell me the Link to that

Does any body has an example where they are passing the name of the Source file in a batch as being read from a list in a flat file ? So If I have a flat file Named SourceFiles.txt containing FileName1 FileName2 ...... FileNameN And I want to run the Job JobName n times depending on the file SourceF...

Thanks Manjula but that wouldn't help as a "000" for quote character brings in the " as a text and it crashes if I have , (comma) in the columns.

Anybody else has any ideas ?

I did try changing the Incomplete Columns to "Discard and Warn" but it keeps telling me that "The Incomplete Column col2 must have values in ascending order" I cannot set it to anything other than the "Error" Like you suggested where would I put the rule to trap my type...

I have a comma separated source file which looks like "10001257", "SUCCINIMIDE (ORDER ON"B")", "KG","S","B","N","A","Y","N","S","","","I","TJB","...

With so much of discussions going around Version Control. I have a question. Presently we are using DataSatges Export/Import facility and VSS for version control but have also been evaluating DataStages Version Control (after replies for my previous post "Compile Status"). In all my previo...

Thanks Ray but could I ask you one more question ?

Where would I find the RT_BP??? value for a particular Job ?

Thanks a lot once again for making me a little smarter [8D]