DSXchange

Anything can be read using an ODBC driver if you have an ODBC driver capable of reading that something. If you're contemplating using the ODBC driver for text files shipped with DataStage, you will almost certainly find that it has no means for handling the structure that is found in all but the sim...

At this time the answer is no.

You could, of course, create one yourself. If so, you might have a saleable product.

If you could establish a business case, you could submit an enhancement request to Ascential.

See here for one technique. In terms of determining which columns are too large, unfortunately you have to do this yourself. For example, on the output link that handles rejects, you could test each of the likely columns against its known width, for example (CITY <> Trim(Fmt(CITY,"L...

Not sure that -wait and -jobstatus are both needed; check the documentation (and, possibly, source code) in Server Job Developer's Guide.

This is not really the way you test for rejected rows, because there can be timing issues - updating the log file is buffered I/O, so the warning that you want to catch may not yet be in the log file. Earlier today I posted a technique for capturing database errors. Other reasons for rejection shoul...

Job parameters are set when the job starts and are not affected by the data passing through the job. If you want to constrain based on the value of a job parameter, then specify the parameter reference (the parameter name surrounded by "#" characters) in the WHERE clause. For example: UPDATE tablena...

There is a class called Programming with DataStage BASIC available from Ascential. It's not scheduled regularly, but you can join a wait list. When there are enough candidates, they run it. At least in this part of the world (Asia-Pacific, including Australia).

The guys who run the site read all posts. So the message will already be there with them. Of course, they're also earning a living, so things aren't always immediate.
Otherwise, scroll down to the Suggestions for the Site forum, and post there.

You can capture this information in the following manner. Create a job design that looks like this. out ODBC ----> Transformer -----> ODBC | | [Reject] | SeqFile The link called out tries to affect the target table. If this fails, the row is deemed not to have been processed on the link called out ,...

I'd have to disagree that the Reporting Assistant "leaves a lot to be desired" but, to get the most benefit from it, you need to step outside the canned reports that come with it, and develop your own reports. This, in turn, pre-supposes some skill with generating queries and reports in Access, and ...

Good catch. The ITERATIONS methodology came on board when VMark and UniData merged to become Ardent; UniData had acquired it along with PWE. I understand that Bill Inmon had a hand in developing the ITERATIONS methodology. ITERATIONS is a project management plan for the entire DW project, not just t...

The class was a customised one for Peoplesoft support staff. That's why I felt that the support story from Peoplesoft might be better for you in the future - at least they've made some effort to have their support staff learn the product. I had students from Singapore and Japan as well as from Austr...

Ultimately, performance is mainly about the work you can avoid doing.

DataStage version 7.x has XML reader and XML writer stage types. Consult on-line help or the relevant manual (these are in your DataStage client install folder, in the Docs sub-folder). The relevant manual in this case is XML PACK Designer Guide (XMLPACK_20_Designer.pdf). In response to your private...

Flat file is fastest, if for no other reason than that it's easier to parse the data from it based on metadata definitions. You only need to process flat file metadata once (assuming the format/content doesn't change, which is not always the case!). With XML there's the overhead of processing the ta...