DSXchange

As I noted in the other thread... depends.

When a routine returns a 'non-zero' value and you have the 'automatically handle activities that fail' option enabled, they are considered to have failed. It considers it 'unhandled' because you haven't provided trigger conditions to handle the 'failure' so it handles it for you. We've discussed thi...

Exactly. From a custom trigger.

Note that you may need to 'source' your dsenv file first to prevent core dumps or other problems launching the shell:

Welcome aboard. :D Job name and category are elements of the DS_JOBS repository 'table'. So something simple like: SELECT NAME, CATEGORY FROM DS_JOBS; will get you a complete list of job names and categories. This can be run from either the Administrator client or from the TCL command line. There ar...

Ascential PPT's course? What be that?

Congrats, by the way. :D

You can 'run' dsjob from any directory as long as $PATH is setup correctly.

Of course. I believe that If the file is a Hashed file or ready-to-be-converted-as-Hashed file, We could take advantage of Hashed File concept and derive the solution using multi-valued metadata handling capacity of the UV stage as ray.wurlod reacted. Or for us Luddites who didn't cut our teeth on ...

Good Lord, calm down. How long did you wait before whining, a hour and a half? Sheesh!!!!!!!!

Jobs automatically process records 'in a loop' without you having to do anything special. Meaning, each record will go from the first stage to the last stage individually and in order. An obvious simplification but generally correct.

So just build your job and don't worry about any 'loops'.

Good luck! :D

Maximum number of pivoted columns is known? Always 4?

How about some details about what you are trying to accomplish? Join 'in transformer' with what - hashed file?

Post examples - sample input records and what they should look like after the pivot.

Of course there are all kinds of ways to do what you want, some more (unnecessarily) complicated than others. I guess you are bent on not accepting the One True Answer. One 'polls' in a looping structure. My old post you linked to was all about a hand coded solution. Nowadays, Sequence jobs support...