DSXchange

quote: Originally posted by dsproj2003 [br]Hi, I have a Parallel job in PX 6.0. It has one dataset providing input data to a transformer. I obtain multiple (around 10) datsets as output from transformer. This jobs runs indefintely. When the DSEngine is brough down adn brought up again it works good....

Hi guys, I try to read and write in a UV file(table) and don't work.I don't have a clearly error message only "Abnormal termination of stage ", and the stage is the transformer. The table is created with a HF stage and I have secondary indexes. Can you provide us with further details on t...

Thanks for your help on this matter.

Everything appears to be working at this time. Of course, that's relative (I just found out that a Right() would truncate the negative sign if the value was negative for PX... *groan*).

-T.J.


* * *

... now if this can make breakfast, my life is complete.

Hello folks -- Server Job - DS 6.0 I am trying to see if there is a better method to ensure that a passed value onto a Transform Stage is valid. I have an input variable of a Varchar(10) that is a YYYYMMDD date format. I know that I could do an if/then/else bunch of checks by breaking down those fie...

quote: Originally posted by Ray.Wurlod [br]You certainly can use a stage variable as a counter. Initialize it to zero (type is Integer for Mainframe jobs), and derive it as StageVariable + 1, possibly qualified by a test based on whatever it is you wish to count. I'm thinking along of the line of ho...

quote: Originally posted by Ray.Wurlod [br]In a word, yes. It's all in the Parallel Job Developer's Guide. [:)] Oh... That's why we can't use it -- we are on a cluster system. No wonders they were telling us to wait until 7.0. -T.J. * * * ... now if this can make breakfast, my life is complete.

quote: Originally posted by gpbarsky [br]By example, I would like to have a job running and monitoring this screen. If the column status of a job is "Finished", then I would like this job to be deleted from the system. Otherwise, if the column status of a job is "Aborted", I woul...

quote: Originally posted by Ray.Wurlod [br]Of course, you don't need a Rejects output if you don't want the warning message to be logged. It is enough to have constraint expressions on each output link (VoidIndicator = "V" on one, and VoidIndicator "V" on the other, the one that ...

quote: Originally posted by Ray.Wurlod [br]A workaround for now is to create a server job that does the transformation you require, encapsulate that server job in a shared container, and use the shared container in the parallel job. Read the restrictions on using shared containers in parallel jobs i...

quote: Originally posted by Johnno [br]DS Version 6, Windows 2000 My question is: when you use DS Manager to import ODBC table definitions from an Oracle table, should you expect these definition to come directly from the Oracle database? Can anyone think of any reason why the DS manager would alter...

quote: Originally posted by kduke [br]Will your company survive without all these tools? Most will not. Actually it is more of a "Will your company which have been chugging along for years using your own legacy programs thrive without these tools?" Survive is most likely possible especiall...

quote: Originally posted by degraciavg [br]3. for the insert job, disable table constraints -> use bulk load -> enable table constraints I would strongly advise against employing this particular suggestion unless you have a method to restore the table to its previous state in case table constraints ...

quote: Originally posted by Ray.Wurlod [br]Yeah, you could, but why would you? The sequential I/O statements in DataStage BASIC are easy to understand, and sample code has been posted right on this site, so you don't have to go outside your DataStage environment. Well, I am coming from an PX environ...

I'm not saying other readers will be locked. But surely other writers have to be. How else can you scan a consistent read of the entire table ? I take it that you do not understand the term: "Snapshot". It means exactly what it is defined as: A moment illustration of what the table's data...

quote: Originally posted by prashanto_dev [br]Anyone can tell me please how to read parameters for multiple jobs from a single common parameter file. You can also run an external shell script that would run the jobs using dsjob, and pull the parameters from the file. -T.J. * * * ... now if this can ...