P2K_SMZONE#
Functionality#
This database function will convert the number passed into a zoned overpunch number, which is used to interface to COBOL systems.
Parameters:#
NUMBER | The number you wish to convert |
Returns:#
Varchar2
Errors:#
None
Example:#
P2K_SMZONE(~)
Operation#
The Zoned overpunch changes the least significant digit (LSD) to a character if the value is negative. In this manner, older systems can deal with positive and negative values without taking up an extra character on the interface file. If the number passed is positive, then the result will return the same number. If the value is negative, the last number will be converted according to the following table:
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation