Due to the recent acquisition by IBM, the Adabas & Natural Ideas Portal does not contain ideas from products ApplinX and EntireX any longer. Please refer to the IBM Ideas Portal for these products from now on (IBMid required). Existing content will be migrated during the next few weeks.
Add a new idea Subscribe
Status Not in Plan
Workspace Natural for z/OS
Categories Natural (NAT)
Created by Guest
Created on Jul 15, 2021

RELATED IDEAS

NAT: Numeric target operands in SEPARATE statement desired

Unfortunately it is not possible with the SEPARATE statement to assign numeric values directly to numeric target fields.
Message:
NAT0240 Operand format invalid. Format A, B or U expected.

So, sometimes laborious redefinitions are necessary.
It would be a great improvement if numeric target operands were possible.


Created on Brainstorm 05/30/2017 11:53 PM
Brainstorm ID 4851
  • Admin
    Eli Cohen
    Reply
    |     Nov 10, 2021

    Source for a SEPARATE statement is always a string type variable format (A,U,B). The result is also always a string type variable (A,U,B).

    A conversion would be required to come to a numeric format.

    The VAL() function of Natural need to be used for such a conversation or MOVE EDITED statement could be used.

    In general MOVE Alpha to Numeric field is not supported.

  • +3
The Adabas & Natural by Software AG Ideas Portal is hosted by Aha! Labs Inc.. Therefore, personally identifiable information are processed by Aha! Labs Inc., a company based in the United States of America. By using this Ideas Portal you agree to the Terms of Service of Aha! Labs Inc.. For further information about Aha’s handling of your personally identifiable information, please go to: https://www.aha.io/legal/security/gdpr.