DSXchange

Remember the 4019th IT corollary to Murphy's Law; things only go pear shaped when you don't have a backup.

Take a backup of the system, take an export of the project, and verify that each is good before proceeding.

None of which I am aware.

Are you on Windows XP? If so, this is a known problem, and there is a patch available that ameliorates it.

Another thing you can do is to drag the job itself into the job sequence, rather than trying to populate an empty job activity.

Yes if accessed natively, no if accessed via SQL which does enforce data types, etc. If the hashed file is created as a UV table, however, then data types and security and integrity constraints are honoured at all times. The only exception is where you have created triggers - these can not be bypass...

Welcome aboard! :D

And thank you for a useful contribution. Your observation makes a point that I know about, and should have mentioned rather than assuming everyone knows all there is to know about UNIX commands.

Because 4.2 is based on UniVerse, its shared memory keys are of the form 0xace..., while 7.x shared memory keys are of the form 0xade... (or something else if the -itag installation is performed). So that should not be a problem. The "pointer" to the engine is /.uvhome versus /.dshome so, again, thi...

Two problems. 1. Ans is not assigned a value unless a line is read from a successfully opened file. 2. If the file is opened, it must be closed. ROUTINE.NAME = 'CheckFileFlag' FFILE = TRIM(FileName) Ans = "" ; * This way Ans always has a value OPENSEQ FFILE TO F.SEQ THEN READSEQ SE...

You could also use an Execute Command activity and use the test command. Again, supply two triggers, driven by the exit status of the command.

User-defined SQL must be DML, not DDL. DDL is handled by other means (depending on what stage type you are using).

What you're trying to achieve is called a vertical pivot - you can search the Forum for techniques. For a small, finite number of rows the stage variables approach is indicated, but you need to ensure that all values for each pivot key occur on the same processing node. Do this by partitioning and s...

There's an entire chapter in the Manager guide.

Read that, then post any residual questions.

Could it be that, at times, your network is extremely busy and DataStage is unable to read /db2home/sqllib/db2nodes.cfg within its timeout interval due simply to network latency?

You'll need to be VERY careful when building this, in the order in which you link things. DataStage has its own version of malloc() and free(), which are completely unlike the "real" ones. You must ensure that you pick up the "real" ones, rather than the DataStage ones.

Please post the configuration file. Without this it's difficult to judge. For example, what exactly do you mean by "two nodes in the same partition"? Further, be aware that Sequential File stages can only sustain parallel operation under very particular circumstances. This is not the same as "multip...

ill-itr8 ru12?