DSXchange

In a parallel job you can use a before/after job subroutine.

It may also be possible to use an ODBC Enterprise stage, but no promises here. Try it. You may need to be careful to make sure that the stage only executes on the machine where DataStage server engine is installed.

No idea. You have not shown your SQL. However, a hashed file MUST have a key. You can't simply "remove the key".

Of course they are. For DB2 for example you can use DB2 Control Center.

There are 847 tables in a newly-installed instance of the common repository.

There is no documentation in the public domain. You're on your own. But it is fully "open".

"HUB" : Char(0) : Char(0) would be one way. 0x00 is another way to represent the single-byte character whose encoded value is 0. In ASCII this character is called NUL (not the same as NULL in SQL). This character is recognized in the C language as terminating a string, so it is a useful c...

You specify 20 decimal places and are surprised to get 20 decimal places? Floating point numbers can not be represented accurately in computers; there is a limit to the accuracy. The IEEE has done a lot of work on this problem, but it is provable that there will never be a completely general solutio...

No, you just need to learn to use Oconv() correctly.

This article explains it thoroughly.

The expression you require is

It will pad, and it will use whatever character is set as the value of APT_STRING_PADCHAR environment variable as the pad character. If this is a space, then yes, it will pad with spaces. If this is Ctrl-@, then it will pad with Ctrl-@ (NUL) characters.

Search for "vertical pivot", for it is that which you are striving to accomplish.

Welcome aboard. DataStage does not have log files; it has logs stored in tables. RT_LOGnnn is a hashed file. That is, it is a database table, which happens to be stored in two (binary) files called DATA.30 and OVER.30. RT_LOGnnn is the log table for job number nnn. You examine its contents with SQL ...

Clear Status File option from Director for the Load job.

Moderator: please move to server forum Yes, it is possible to set up operating system commands to read from a hashed file, but what particularly do you wish to achieve? For example do you want to read a single value from a single record, do you want to execute some kind of query (to return multiple...

It's not clear what you're asking. By "mode" do you mean status? What it the status of each of the underlying five jobs? How are the job sequence compilation options set?

Get your Oracle DBA to monitor the session associated with the running DataStage job and, in particular, the SQL statement that is received in that session.

You're not alone. The job control code in a job sequence (and note that it's not "sequencer", which is a component in a job sequence) is deliberately read-only so that the nexus between the graphical design and the generated code is preserved. If you wish you can copy the code into the job...

No, you can't do it that way. The file pathname must appear in the filter command itself, the actual File Name property is ignored, and DataStage reads stdout of the actual (given) filter command.