DSXchange

That makes sense. I will give the stage variable approach a try, because I do want to use it in the future...assuming we will one day get to Parallel stages.

Ray et al, Ok, full disclosure...I have this working now. Thanks for all your help. At the risk of seeming uber -geeky... I believe this approach to be overly complex and will continue to refactor it until there is nothing left to throw away. Kind of like the processes used in poetry, sculpting or p...

Nice. I do love a tool with parameter whitespace sensitivity...reminds me of the bad ole RPG days of the mid-80's. I was able to get DSGetVar() working today, but DSSetVar() has not proven as maleable, and my hammer is getting heavy. Stone-age Perl is looking better all the time. The template is alm...

While attempting the first command: COPY FROM VOC DSGetVar, DSGetVar.BAK I received: Record "DSGetVar" already exists in file "VOC"; not COPIED. Record "DSGetVar.BAK" not found in file "VOC". 0 records copied. I assume this means DSGetVar is already defined in the VOC. I will muddle along in the Uni...

Ray, I'm sure you are right. What I have is a pretty simple test job stage... Input Sequential File ---> XFormer ---> PassedRows | +--------->RejectedRows However, you touched on the very subject that has escaped me... how do I get/set Stage Variables from column-level validation functions? Is there...

Ray, I'd really prefer not to have to manage a potentially large dynamic array until end of stage, preferring instead to collect any/all errors on a row-by-row basis and pump each one individually out in a rejected row table for later consumption. BTW, Is there a FAQ somewhere on COMMON processing I...

Couldn't get them to compile regardless of the definitions in JOBCONTROL.H Tried: $INCLUDE DSINCLUDE JOBCONTROL.H DEFFUN GetStageVar(varname) Calling "*DataStage*DSGetVar" sVarVal = GetStageVar("sInRejectMsg") Ran a test and received the following error: Test fail...

What I would like to have is an edit function for each column which posts messages and diagnostics to a common memory area. I did attempt to do this via a COMMON dimensioned array... The Function would be called via Xformer as follows: MyTableEdit(ColIndex, ColName, InputRowNo, ExpectedValues, A...

I have searched the forum, and I have been unable to find a DS Server Edition BASIC code snippet for setting and getting stage variables inside a routine / function. I know this must be a simple process, since it is referred to in many posts, but I have not been able to locate it on DSExchange and n...