This is version 1 2 3 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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:

So +34567 will return as '34567' but -34567 will return as '3456P'