UDF DB2 Function

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.

Pseudo code:

For dashes:

-- 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.

## Deliverables

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.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Veja mais: number function, function number, db2 udb, what is account management, pseudo code, pseudo code code, case accept project, udf, pseudo code project, input digits, php locate user, user defined function , function user, account function, acct project, php digits number, function requirements, converts code, input function php, php pseudo code

Acerca do Empregador:
( 32 comentários ) United States

ID do Projeto: #2978059

2 freelancers are bidding on average $29 for this job


See private message.

$29.75 USD in 3 dias
(24 Comentários)

See private message.

$28.9 USD in 3 dias
(6 Comentários)