DSXchange

Welcome aboard. As you are probably aware, you need to have descriptions of the rules that make one of these numbers valid. To make your task more difficult, each State in Australia has its own rules for drivers' licences, in addition to which there may be foreign and international licences being us...

Please change the name of the ProfileStage forum to
ProfileStage / Information Analyzer

BASIC routine ---> server job only, or BASIC Transformer stage in parallel job

Parallel routine ---> parallel job

You could, as suggested, re-write the logic as a parallel routine (in C++) and invoke that from a parallel Transformer stage.

Clearly your understanding and SQL Server's do not coincide. The mere fact that there are no duplicates in the source data means nothing if one value in the source matches a value already in the target table. You must check, in your job flow, that this is not the case. Do a lookup against the target...

Professional Standards Please do not use SMS-style abbreviations on DSXchange. It is difficult enough reading technical English for those whose first or second language is not English, without needing to decode these as well. The correct spellings should have been "Why" and "you" in your first sent...

We mentioned Trim() because your original post - and, indeed, your subject line - did. Tab is Char(9). Include that in the string to be converted. Convert("|-\:;,. " : Char(9), "", InLink.TheString) You can use multiple, nested, Convert() functions, but it is rare...

Do you have any processing that invalidates the nullability, for example an Aggregator stage with Allow Null Output set to False?

You can not use cp command.
You must use orchadmin cp command.

Only by constructing a multiple command pipeline. orchadmin rm controlfile1.ds ; orchadmin rm controlfile2.ds ; orchadmin rm controlfile3.ds Alternatively (and better, I believe) construct a shell script containing the required commands and execute that. You can also include other commands (such as ...

What value did you supply for $EVENT ? Typically dsjob -logdetail returns all lines for one particular event. Can you demonstrate how you know that this event has 113 lines? The fact that it's 23 lines suggests that the output is being handled through some kind of "Press any key to continue..." func...

Perhaps you are calling FileFound() from another routine in which you have neglected to place a DEFFUN declaration. But it's more likely, from the error message, that you have not imported the FileFound() routine, or have imported source code only and not compiled. If you have the source code in you...

Yes. Simply take a copy of it. Copy the permissions as well.

Observation: COBOL files don't usually have delimiters.

Are you translating from EBCDIC to ASCII as part of your processing?

You need a "fok join" design - Join the count back onto the original rows. Remove duplicates if desired. Search the forum for how to implement.

Think about it in SQL terms. What are the rules in SQL? Every column named in the SELECT clause, if there is a GROUP BY clause, must either be mentioned in the GROUP BY clause or have a set function applied to it. A column propagated via RCP would meet neither of these conditions. Therefore it would...