DSXchange

It IS static. DEFFUN only exists to notify the compiler that the name followed by a left parenthesis is that of a function (rather than that of a dimensioned array), to confirm the number of arguments in the call, and to advise the name under which the routine is catalogued; user-written routines ha...

Stage variables are evaluated after all inputs have been fetched, so all columns from all inputs are available in stage variables. However, if the lookup fails, the value returned in all columns on the reference input link is NULL. Does your stage variable derivation expression take into account the...

Is this a parallel job or a server job?

Welcome aboard. :D There isn't really enough information to enable us to help. If you were to post the batch code - surrounded by Code tags - then we could inspect that. Also post the English text of what the looping batch is supposed to do, so we can check the code against that. This text should ex...

Chuck Smith posted a (link to) a utility for this kind of search. You should be able to find it by searching the forum. It's also possible with Kim Duke's tool kit. Why do you want to re-invent the wheel?

You don't need to know this. DataStage will be issuing the equivalent of SQLFetch() functions to the database to retrieve rows from the query result set. When this function returns an appropriate value, indicating "no more data", DataStage "knows" that it can exit from its main loop. There is no use...

Does your DataStage job connect to Oracle using the same login/password that you used in TOAD?

You'll have to stop drinking that English beer!

The Lookup stage performs only equi-joins. You are probably better off performing the join in the database prior to receiving the result rows into DataStage. Of course, I am assuming that your other source data are also in Teradata; if they're not, you could readily load them into a temporary table ...

Do you design your jobs by Load of column definitions from previously imported Table Definition, or by just putting column definitions into job designs by hand? If the latter, there is no linkage back to a table definition in the Repository.

Great. But how did you (or "they") discover that there was a communication problem? What other symptoms or error messages occurred, either in DataStage or in the SAP environment? This kind of knowledge posted here is what makes this a useful site for others searching for help on IDOC stage problems ...

Yes, but if I may re-offer a piece of advice: this site is not SMS-capable. Please write in English, as if you were producing documentation. It makes life easier for those who are not quite comfortable with English not to have to figure out what SMS-style shortcuts mean.

Welcome aboard. :D
What exact version of DataStage are you using? Is it on Windows XP sp2? You probably need a patch from the vendor.

The Fold() function will separate the string into four-character pieces separate by @FM characters, a Convert() function will do the rest.

Once you've established a Select List (a list of key values in memory) you process it with ReadNext statements until the list is exhausted. It's a good idea to use a non-default Select List number, in case the default Select List is being used by something else. Perform "SELECT JOBNO DS_JOBS WI...