DSXchange

This is one of those occasions when resetting (not re-compiling) the job ought to yield a "from previous run" entry in the log explaining where the abort occurred. So reset your job and see what appears.

There are certainly a lot of Data Sets associated with the Transformer stage. This may explain why demand for memory is so high. It will take some time to review the score and construct the actual job that runs. Please be patient, or attempt it yourself. On paper create a "link" for each data set an...

Premium membership costs less than 30c (Rs12) per day. Among other things it will let you read the five premium posters' contributions in their entirety. All revenue from premium memberships is devoted to defraying hosting and bandwidth costs incurred by DSXchange so, by taking up premium membershi...

Could you please phrase your questions in English? DSXchange is not a mobile telephony device - there is no need to abbreviate. Further, the abbreviations make understanding more difficult for those whose first language is not English. A search here or on the internet for the term "business key" wi...

There's nothing in DataStage that will do this. However, if you use a Filter command in the Sequential File stage that writes the file(s), then you could create a script/command that starts a new file when your limit is reached. Running the data through this would seem to me to be the best solution ...

Well, at least now we know who the "Kingkongs of DataStage" are!

Well, at least now we know who the "Kingkongs of DataStage" are!

That would be Oracle bin Larry, n'est pas?

Grid is different - for a start you need a dynamic configuration file. The Grid PACK referred to contains the facilities needed. Unfortunately I can not offer any advice, as I have no experience (yet) with DataStage on a grid. But there are some out there, so I hope someone answers who can provide c...

There are several techniques for reading a parameter file. Searching DSXchange will reveal at least some of them. Remember that parameter values must be set before the job run request is issued, so you will need a job sequence or controlling job.

They point to a sequential operator, not necessarily to a sequential file stage. Any stage can be constrained, mandatorily or otherwise, to execute in sequential mode. It suggests that your database stage is constrained to execute in sequential mode. But, be be certain, can you post the entire messa...

Stage variables are still a good way to collect running totals from sorted data. When it's the second week number, append a line terminator and the total to the final column and write to a sequential file, then read from that sequential file to get the desired result. Put the grand total in the user...

Just because Oracle does it one way does not make it a standard. Here's a hint. 00222 is a valid date, so is 00365, but 00367 is not.