DSXchange

If the data are partitioned and sorted on the key for which you want to generate independent sequences, then three stage variables ought to be able to do it. svKeyChanged: InLink.KeyValue <> svOldValue Or @INROWNUM = 1 svOldValue: InLink.KeyValue svSequenceValue: If svKeyChanged Then 1 Else svSequen...

If the CFF has binary/packed data, you can't use an ASCII mode FTP operation. Other than that, it should be OK either way.

That's obviously a DB2 thing. In Informix you might have created the table with no logging. Doubtless other databases have similar functionality.

Get the UNIX SA to switch on large file support sounds like the best idea to me. 2GB limit in UNIX is so 1990s. cat file1 file2 may work, depending on how much of it has to spill to disk. Hopefully none. If the rows are independent, why not create a multi-instance job and run one instance against ea...

Recursive functions are possible in server routines. Include a self-referential DEFFUN declaration. Beyond that, it's impossible to suggest anything without some kind of specification - what do you want to lookup recursively, and what is the rule that lets you exit from the recursion stack. Dictiona...

Two Transformer stages, one for each task.

If you initialize the stage variable, and don't provide a derivation expression , it will retain its initial value throughout the job run. Whether you initialize it from the macro, or from the expression, is up to you. Incidentally there's a typo in the previous post; a right bracket is missing in t...

D'you know, that just doesn't look like a parallel routine to me! I'm fairly certain that C++ code would have more curly braces and semi-colons than appear in your code. As noted in my earlier post, which everyone appears to have bypassed, there are solutions available that don't require either rout...

The error message indicates that the row is getting out of DataStage successfully, but something about it is being rejected by DB2. Chat with your DBA as to the meaning and remedial action possible when error code SQL7008N occurs. Track down (or search the Web) for information about the generic ODBC...

That information is also on Kim's web site. Let me add my recommendation to Craig's concerning the efficacy of Kim's tools.

The Hawk release is still in beta. There are email addresses within IBM where they might be prepared to give you more information. There were handouts at the Las Vegas conference. But I'm on the road, and not carrying them with me, so can't help. Try asking your account representative to get them fo...

Various ways you can do this. Us telling you a solution won't help you to learn independence, grasshopper. See what you can come up with alone (with the help of the manuals, of course). To make it interesting, let me set you this challenge. Come up with one solution using a Modify stage and another ...

You can parameterize the SQL statement, and therefore supply same from a job sequence. But, and this is the grabber, the SQL must generate or consume the same columns that are defined within the DataStage job; DataStage is metadata-driven; the list of columns is NOT dynamic.

You need to find out who the DBA is. SELECT * FROM UV_USERS WHERE DBAAUTH = 'YES'; Connect (via telnet or Administrator client Command window) as that user and issue CONNECT privilege to that user. GRANT CONNECT TO aa; You will also need to add entries to the UV.LOGINS table to map all the different...