DSXchange

Is the "branch" in the file the same as the "branch code" in the database table? How many lines in the file? How many rows in the table? These volumes will affect the "best" solution.

U is one of our posters (and a reasonably common Burmese name), Ur was a city in ancient Babylon, and rpy presumably is an abbrevation for revolutions per year. Plz might be a town in the Balkans. Please use a professional standard of English when posting on DSXchange; it makes it easier for everyo...

Actually the GE stems from #< which DataStage BASIC interprets as "not less than". So it's necessary to ask where "#<>~" comes from in your job design, and why it's unquoted if it's a string. If it's any help, it's the derivation of the first column on an output link from the second Transformer stag...

Then use more filtering, on timestamp!

where nnn is the job number and yyyy-mm-dd hh:mm:ss is the start date/time of the job.

The total of field widths plus separator space must be less than your device width. Five at 40 equals 200, which is way too many, so you get vertical format. Try this: SELECT Field1 FMT '12R', Field2 FMT '15L', Field3 FMT '20R', Field4 FMT '10L', Field5 FMT '10R' FROM HashOther; In this query the to...

What you are asking about is called a "vertical pivot". Searching DSXchange will yield at least three different ways to accomplish vertical pivoting in DataStage server jobs.

What a surprise! When you ask a running job for its status, it returns "Running" (which is what 0 means). You need to re-think your logic, probably to split it into two separate pieces, the first of which does any processing, the second of which only executes if the first does not abort. The only al...

What precise version of DataStage - 7.5x2 or something else?

Original post was for 7.x. You are correct that ProfileStage no longer exists in 8.0 having been morphed into Information Analyzer. Elements of QualityStage and AuditStage will also migrate into Information Analyzer over the next couple of years. In the meantime, AuditStage continues to exist as a s...

Mainframe capability has been in the product since very early days - if pressed I would opt for version 2.2 or thereabouts. I have been involved in banking/insurance projects using mainframe jobs.

So would we. Where did you encounter them?

A useful summary. Thank you.

I prefer not to use RCP, so someone else will need to answer that.

It matters only internally. A Batch is created in Director and compiled automatically. Job control routine is not compiled automatically; it must be compiled by manually compiling the job in which it is a property.