DSXchange

DataStage can request anything the database server will permit. On some databases you need to change the environment to allow Cartesian products (for example SET CROSS JOIN ON in Red Brick). 23 million x 31 million will always take a lot of time. At one row per second, indeed, it would take over a m...

You're welcome. Well done on a cautious, and ultimately successful, result.

Welcome aboard. The answer is yes, but at least one of the installations must be an "-itag" installation, that uses non-default shared memory keys, etc., so that the two servers' working sets are not in conflict. Full details of -itag installations are in the installation and upgrade guide. However,...

Change the Output Link Execution Order.

Only someone in a group to which the DataStage role "Business Manager" has been assigned can move anything into a protected project.

You can Search for the answer to this question. I know that I have answered that precise question in the past.

Are you certain that you have set Null Field Value property properly for this particular field?

Is it the value of the environment variable or the name of the environment variable that you wish to change globally?

If it's the latter, then I don't see that you have any option other than to edit an export file.

I did, in my previous post.

Not really. You could use a Cycle to generate a single character alphanumeric field, but beyond that you need multiple stages (Lookups and Transformer).

Will compiling a sequencer compiles all the underlying jobs? Thanks No, because you can not compile a sequencer alone. A sequencer is one of the components you can use in a job sequence. Please be careful with terminology. (Yes, I know that the official IBM training materials aren't always 100% acc...

Do the hot keys work? For example, does Alt-V display the View menu?

DataStage/SQL does not generated delimited output at all - it generates fixed width output. To get pipe-delimited, the only way is to generate the pipe characters yourself. SELECT col1, '|', col2, '|', col3 FROM hashedfile; Even then the data columns will be fixed width as specified in the file dict...