DSXchange

Hi, I have a Job Sequencer [in Parallel]. [1] If the Job aborts in one of the jobs in the sequence, should that job be recompiled, before starting the Job sequence again ?? Am I missing something here. [2] Also instead of changing the file name in the first job each time, I introduced a FILE Paramet...

kumar_s wrote:Make sure the setting in adminstrator is turned on.
Parallel ---> Reporting ---> APT_NO_JOBMON --> FALSE

Figured it out after I posted...Works like a charm...Thanks anyways

Hi, I faced this exact same problem...Your job would have executed correctly. The target tables would be populated but still you cannot see the link change color nor get the performance stats. For this, I learnt from the forum that JobMonApp should be running. Make sure your JobMonApp is running. e...

You can use CurrentDate() function. To add n days to current date, use CurrentDate() + n To subtract n days from current date, use CurrentDate() - n This fuction is even listed in Functions> Date & Time in derivation field in Transformer. In the sameline, with a date in yyyy-mm-dd available, ho...

Hai In which seneario will be used Filter and switch stages.which one is better for performance issue considerations. Well SWITCH is like your CASE statement in C or an EVALUATE statement in COBOL wherein when the condition is met, exit is taken. FILTER is used to drive an input to many different s...

Vijay - sorry about that, I meant to address my mail to bmadhav. The CFF stage won't make a difference if your metadata is wrong. You need to specify the conversion correctly. Are you using PX or Server? That's alright..Well using PX=Parallel. COMP-3 fields from the COBOL file like amounts are good...

Vijay, don't you think that copying a premium post in full is not ethical? >> I didn't get this at all...Did I do something unethical ? Also, COBOL fields that are COMP utational and not DISPLAY are the same in ASCII and EBCDIC as they are binary and have nothing to do with character sets. There is...

With no V in the PIC, and fewer than 10 digits specified, it should correctly choose Integer. If there is a V in the PIC, such as 9(9)V99, or ten or more unmasked digits specified, then it should cho ... Thanks for replying..but your answer seem to be chopped off...!! >>then it should cho.... ??

Your data and metadata are not in synch. I don't know how you have loaded your file's metadata into the repository, but the COMPutational part did not get set correctly. You need to edit the file's definition in the manager (right mouse-click on the column(s) in question, "edit row" and s...

Hi,
I have a COBOL Mainframe file with few COMP fields.
e.g., Item-QTY PIC S9(9) COMP. where the value could be 1,etc
When this metadata is loaded, it shows up as
Item-QTY Integer 9 and the value shows up as 1654772 [something like this]. How do circumvent this issue...
Thanks

Thanks bcarlson for the detailed explanation. I'm gonna try this out. But being a newbie, with just a 4day training and 1week hands-on so far in my current project, I'm not sure, if I can crack it out. But would definitely give it a shot. THANX again for the help. -V I highly recommend using buildop...

Switch, Filter or Transformer stage to split into separate stream for each record type; Modify, Column Generator or Transformer stage to supply missing columns; Funnel stage to bring them all back tog ... Ray, Thanks for the Input. Correct me if I'm wrong: I have the varying Input records already i...

Hi, I have set of Various Input records that carry distinct information. e.g., Input type 1 would carry AC-NR,INV-NR,INV-AMT,QTY etc Input type 2 would carry AC-NR,INV-NR,REF-NR,INV-AMT,QTY etc Input type 3 would carry AC-NR,INV-NR,TRK-NR,INV-AMT,QTY etc and so on and so forth. The Output Record out...

If you use a Complex Flat File stage you can specify exactly how the repeating group is to be handled - in your case normalized. Ray, can you please elaborate on this a little bit more..I use complex flat file stage for my cobol file and I''m interesting in knowing how repeating groups handling by ...

Sunshine2323 wrote:

vijayrc wrote:Is this a Parallel job Stage ??

Yes

Thank you all, got this working with a Transformer stage, but would try with a Pivot stage later on, as Transformer stage seems to be overhead w.r.t perfomance for this task. Will keep posted. Thanks again