Topic
  • 1 reply
  • Latest Post - ‏2012-07-10T10:31:27Z by RobertDickson
SystemAdmin
SystemAdmin
7754 Posts

Pinned topic Convert QS Legacy Stage Logic to DataStage job

‏2012-07-10T06:13:27Z |
Hi All,

There is a business requirement to convert all QS Legacy stage jobs to DataStage jobs due to the change of the file layouts. Below is the one of the example.

;;QualityStage v7.0
INFILE FIXEDTERM 1100 DEFAULT
OUTFILE FIXEDTERM 0600 DEFAULT
MOVEL 0648 003 0001 003 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM
MOVEL 0601 020 0004 018 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM
MOVEL 0642 006 0022 006 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM
MOVEL 0266 005 0028 005 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM
MOVEL 0695 020 0053 240 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM
P
MOVEL 0648 003 0001 003 I
INTYPE ALPHANUM
OUTTYPE ALPHANUM

From where I can get the information about syntax of the above code.
Any help would be greatly appreciated.

Regards,
NP
Updated on 2012-07-10T10:31:27Z at 2012-07-10T10:31:27Z by RobertDickson
  • RobertDickson
    RobertDickson
    33 Posts

    Re: Convert QS Legacy Stage Logic to DataStage job

    ‏2012-07-10T10:31:27Z  
    Hi,

    That is SAVE language in a UNIJOIN. The v7 documentation will be able to help you understand this (and possibly other) UNIJOIN's you have. The v7 documentation is not available on the Web, but is on the client machine where v7 was installed.

    While UNIJOIN is not available in QualityStage v8.x, you should be able to re-engineer them with 8.x stages. The most likely is the Transformer.

    Regards,
    Robert