DSXchange

1. You need to define it in the table definition. When you check "supports multi-valued fields" (or whatever it's called) three additional columns become available in the Columns grid. It's all explained in the Help. 2. Dynamic normalization means using the "Normalize on" check box or an equivalent ...

Perhaps you could use a BASIC Transformer stage with this IsValid() function !

You are trying to update the same table as you are selecting from ? The (self-)deadlock is in the database. Consider a better design, where you are not causing a deadlock. You might consider an array size and transaction size of one row (effectively "auto commit"). Or you could use two jobs - one to...

Fair enough - I'm at a server-only site at the moment, so couldn't check, but you hadn't mentioned it. There is no mention in Appendix A of Parallel Job Developer's Guide (Functions) about a square-bracketed format string being available with the IsValid() function - and this is the only reference t...

Welcome aboard. :D

We always ask people asking "what's wrong" questions to post the complete and exact error message. You might also do well to search the forum for "SIGSEGV", perhaps in an "all words" search with "Filter".

All of the APT ones are somewhere in the Orchestrate manuals.

Hi, Can anyone let me know if Row splitter is the only stage through which a file with a header,body and footer can be split seperately or is there any other stage/way through which the file can be split. Thx, Rajee For a single line header, "first line is column names" checked will remove the head...

Have you defined the pertinent multi-valued columns to be multi-valued in your table definition? If you have, you should be able to use the "normalize on" check box in a UV or Hashed File stage. But they really should be associated for this to work properly. You could try adding the name of the para...

WHAT error ?!!!! There is an IsValid() function for parallel jobs that ships with DataStage. That's not the one. There is an IsValid() function for server jobs that was published on DSXchange some time back. That is the one. I just did a search for it (all words "IsValid server" with me as the autho...

OK, it's the Sort stage srcClaims, and the problem has occurred on node numbers 0,1,2 and 3. This suggests that there's something wrong with how the Sort stage is set up - something that is syntactically correct (so the job compiles) but which the tsort operator can not manage. Can you thoroughly in...

In particular, how do you know it's the Sort stage? Please post full error message from the job log (copy/paste), and any others that may have occurred.

Use @FM system variable as the delimiter character for the Field() function.

Use @FM system variable as the delimiter character for the Field() function.

Several. If you want to create a routine, it's very easy - apply an Iconv() function to the string then test the result of the Status() function. Otherwise search the forum for an IsValid() function for server jobs - I believe it will work if there are no delimiters. Otherwise perform range tests on...

Welcome aboard. NOTIFY ON is an important setting - it allows the job to be notified when the Transformer stages (which run in separate process(es)) finish. Get "them" to reinstate it. With NOTIFY OFF in effect, notifications are not received immediately, which can cause the job to remain in a runni...