Create the **Convert_Account** UDF which will accept one input parameter (acct#) & will return 9 digits account number with leading zeros.
The account number can contain dashes (-) and has a variable length.
-- Case when locate ('-', CHECKING_ACCOUNT_NO) >0, what is the length?
If less than 9 then add zeros (example: 0-12345 converts to 000012345, 0-123 converts to 00000123, 0-12345678 converts to 012345678, etc.)
For no dashes: 12345 converts to 00012345, etc.
DB2 UDB on Unix
The coder must have strong experience in creating user defined functions using DB2 UDB on unix.
Please review the requirements before placing a bid.