DSXchange

"Bind bombed" means that the process was unable to bind the socket it expected to be able to bind. Probably this is because of a process that had it earlier (an earlier invocation of the RPC daemon that crashed, perhaps) not releasing the socket. You can verify this with netstat . However, the exact...

Use a Stage variable in the Transformer stage. Imagine you call it varSequence, and initialize it to 0 Its derivation would be something like: If @INROWNUM = 15000 Then 1 Else varSequence + 1 If you wanted to reset EVERY 15000 rows the change is simple: IF Mod(@INROWNUM) = 0 Then 1 Else varS...

I am not too sure if there are any solutions for this but when I open datastage director with categories turned off it takes about 5mins to display the jobs. Is there any way to make this quicker? Categories off means that Director has to fetch every job back from the server, not just the ones in t...

[quote="kcbland"]There are blanks and there are NULLs. NULL is ASCII character 0. Blank is blank. x = @NULL If x=@NULL Then Do This End Else Do That End The reason for that, which strictly speaking isn't the way to go, is that because NULL is unknown, one can never assert that the comparis...

The date is not in the format required by the target table. You need to massage it so that it is.
Can't give more specific advice until you tell us what the target database is and, ideally, the date picture (for example DD/MM/YYYY) that it expects.

The number you supply forms the primary key in a table called SDKSequences. To reset it you need an UPDATE statement. However, metadata for the SDKSequences table is not supplied, so you need to "borrow" column definitions from another table (via a USING clause). Note in this example that everything...

That kind of scheme - which we were perforce required to implement prior to the advent of PX - works particularly well because the four readers tend to "piggy back" - the one that's actually reading at any one time has the effect of warming the cache for the others. An alternate approach, if the row...

The benefit of its size is that it makes excellent bedtime reading; it's then large enough to be a pillow!

My point was that DataStage jobs run as background processes, so (in theory at least) do not have access to the terminal. Can you explain how this happens in your case? Certainly it could be done in a job sequence which, after all, is simply a GUI used to write a job control routine. You would use e...

There is a built-in procedure called MNS (multi-national address standardization). There is also a COUNTRY rule set, that can be applied ahead of anything else to separate your data into country based on the contents of address and area fields, then individual per-country domain preprocessors can be...

HOW are you "getting an output value" from one job? This is not a usual concept in DataStage.

This will affect how you "pass it to the next job".

The usual way is to use some form of persistent storage, such as a disk file.

How about a two-part identifier?
The first part could be simply "A" and "B" (or similar).
The second part can then be a simple sequence in each case.
Or am I missing something here?

Y10K!! Y10K!! Y10K!!

Never follow the ISO8601 standard of a four digit year!!!!

Would that difference still occur if you started four instances of a multi-instance server job, with appropriate parameters to partition the data?
Just curious.

Think about it from an object perspective. Column definitions are a property of the link. The stage merely serves as a means (an object) to deliver the appropriate functions (methods) for communicating to a particular form of persistent storage. For example, the "getnext" method is handled by a Sequ...