Skip to main content

OUTREC IFTHEN and OVERLAY invalid syntax

  • December 8, 2018
  • 4 replies
  • 3 views
D

I want to achieve below logic, which work in DFSORT, in MFJSORT. 

OUTREC IFTHEN=(WHEN=(1,9,CH,EQ,C'A00000000'),OVERLAY=(1:C'000000000'))

Getting error IFTHEN and OVERLAY are invalid syntax. This works irrespective of input files record length. How to achieve the same in MFJSORT.


#EnterpriseDeveloper

    4 replies

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • December 10, 2018

    I want to achieve below logic, which work in DFSORT, in MFJSORT. 

    OUTREC IFTHEN=(WHEN=(1,9,CH,EQ,C'A00000000'),OVERLAY=(1:C'000000000'))

    Getting error IFTHEN and OVERLAY are invalid syntax. This works irrespective of input files record length. How to achieve the same in MFJSORT.


    #EnterpriseDeveloper
    You may be able to get the OVERLAY option to work by switching over to SYNCSORT emulation. The steps to do this are in the product documentation. The base product is not a complete emulation of DFSORT, ICETOOLS or SYNCSORT. It appears that at the current product does not have support for IFTHEN currently. You can reach out to the support line and ask about an enhancement request to have that feature added.

    If you need this capability immediately we do have a Filed developed solution (FDS) that adds this capability on top of the existing product capabilities. You can reach out to your sales team for information as to the cost
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • December 12, 2018

    I want to achieve below logic, which work in DFSORT, in MFJSORT. 

    OUTREC IFTHEN=(WHEN=(1,9,CH,EQ,C'A00000000'),OVERLAY=(1:C'000000000'))

    Getting error IFTHEN and OVERLAY are invalid syntax. This works irrespective of input files record length. How to achieve the same in MFJSORT.


    #EnterpriseDeveloper
    What syntax does the FDS cover? Looking at a situation with lots of syntax not handled by the base MFJSORT, including the two mentioned here.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • December 12, 2018

    I want to achieve below logic, which work in DFSORT, in MFJSORT. 

    OUTREC IFTHEN=(WHEN=(1,9,CH,EQ,C'A00000000'),OVERLAY=(1:C'000000000'))

    Getting error IFTHEN and OVERLAY are invalid syntax. This works irrespective of input files record length. How to achieve the same in MFJSORT.


    #EnterpriseDeveloper
    You'll need to reach out to your sales team to have them get you a copy of the documentation around the FDS.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • December 12, 2018

    I want to achieve below logic, which work in DFSORT, in MFJSORT. 

    OUTREC IFTHEN=(WHEN=(1,9,CH,EQ,C'A00000000'),OVERLAY=(1:C'000000000'))

    Getting error IFTHEN and OVERLAY are invalid syntax. This works irrespective of input files record length. How to achieve the same in MFJSORT.


    #EnterpriseDeveloper
    found an alternative in DFSORT emulation itself which seems to work-
    OUTREC OVERLAY=(1,9,CHANGE=(9,C'A00000000',C'000000000'),
    NOMATCH=(1,9))


    Terms & ConditionsAccessibility statement