DSXchange

Visual Studio .NET from your friendly dealer.

And it really should be installed prior to DataStage 7.5x2.

Where are the source data? How do you extract them? If they are already in five columns you don't need to do anything, except specify the format of the sequential file.

Where is "any ware"?

Etiquette Note
All upper case is "shouting" and regarded as rude.

Mainframe job developement is probably the easiest of the three job types, as there are fewer stage types and fewer exceptions. That's my opinion, anyway. You do need some mainframe knowledge, particularly about how to specify storage (cylinders and all that!), but that's readily obtained from "them".

It's no different really, it's just that there's no property so that your design must ensure that whatever value is used to represent NULL has the same width in the fixed-width DATA file as the field.

Scratch space is used by any stage type in a parallel job that needs more memory than it can be allocated. It is not feasible to attempt to give a complete list. Any file left in scratch space is no longer required once a job ends - indeed in the normal run of events files in scratch space should be...

F1 key invokes context-sensitive help in most cases.

Read Pivot.pdf and learn about pivot keys (looks like you will need ten of these) and pivoted column lists (looks like you will need three of these).

Why not use Windows remote console to take over his machine (as Administrator of course) and close the Designer?

You really need to find out what code 113 means. For example, can the oerr executable be found in the PATH for the executing user?

Have you visited IBM's web site to try the practice questions?

... in days. Conversion to years and months is not so straightforward.

On this page you will find a link to some date manipulation routines that you might be able to adapt.

The PDFs are installed with your DataStage client software, by default C:\Program Files\Ascential\DataStage\Docs. You also really need some hands-on experience. This can not be had from books. I believe the passing score is 75%; you can find out from the IBM certification website, as well as some pr...

1. Can I use DB2/UDB load stage for bulk loading for 20 million records . But here iam not the only one who is using the tables , I mean target tables . I read in some post that it will lock my tables if I use DB2/UDB load stage . What stage I need to use for better and for faster processing . And ...

There is a perfectly serviceable Transformer stage for parallel jobs - use that. It doesn't do reference lookups - there is a Lookup stage for that. But it does have stage variables, output link constraints and column derivations. It generates C++ rather than DataStage BASIC, but so what?

What has changed between then and now?

"Nothing" is not the correct answer, even though the change may not be within DataStage.

Is it reliably slow now, or was it just the once? Was a large sorted query or correlated subquery also competing for DB2 resources at the time?