Gen EDGE

  • 1.  Data Type

    Posted Aug 07, 2018 11:40 PM

    Hello, Hi

     

    I have situation which is when i call the value from the DB2... example

     

     

    picture above is value from one of the column in reference table....it suppose show the value '01115021' after read statement... but the value that i get not '01115021' but '1115021'....the value that i get is not enough....i think at first it maybe because of data type is integer...and how ca gen can work with that???

     

    Thank you

     

    Regards

    Amirah.



  • 2.  Re: Data Type
    Best Answer

    Posted Aug 07, 2018 11:46 PM

    There is no real problem here - in both cases, DB2 will be storing the value '1115021' because it's an integer.  Your GUI tool will be prefixing it with leading zeros.

     

    If you want Gen to display it on a screen or window with leading 0s in the same fashion, then ensure the edit pattern for the field is set correctly.  The default pattern will be something like ZZZZZZZZ9.  Change it to 999999999 or similar. See 
    https://docops.ca.com/ca-gen/8-6/en/developing/designing/understanding-the-design-phase/z-os-block-mode-screen-design/editing

     

    From a numeric perspective, however, they are the same.  It's presentation that is different.