I have a file with a field for account number, and then nine similar fields that can contain a 3 letter code.
For a set of account numbers that I already have in a cursor, I need to find a certain code (in this case 'GNS') that can exist in any one of those nine code fields, and remove it.
Can I do something like this? What is the correct syntax to do what I would like to do?
Exec Sql
update MYFILE
case CODE1 = 'GNS'
set CODE1 = ' ',
case CODE2 = 'GNS'
set CODE2 = ' ',
case CODE3 = 'GNS'
set CODE3 = ' ',
case CODE4 = 'GNS'
set CODE4 = ' ',
case CODE5 = 'GNS'
set CODE5 = ' ',
case CODE6 = 'GNS'
set CODE6 = ' ',
case CODE7 = 'GNS'
set CODE7 = ' ',
case CODE8 = 'GNS'
set CODE8 = ' ',
case CODE9 = 'GNS'
set CODE9 = ' ',
where ACCOUNT = :custAcct;
Thanks in advance!
For a set of account numbers that I already have in a cursor, I need to find a certain code (in this case 'GNS') that can exist in any one of those nine code fields, and remove it.
Can I do something like this? What is the correct syntax to do what I would like to do?
Exec Sql
update MYFILE
case CODE1 = 'GNS'
set CODE1 = ' ',
case CODE2 = 'GNS'
set CODE2 = ' ',
case CODE3 = 'GNS'
set CODE3 = ' ',
case CODE4 = 'GNS'
set CODE4 = ' ',
case CODE5 = 'GNS'
set CODE5 = ' ',
case CODE6 = 'GNS'
set CODE6 = ' ',
case CODE7 = 'GNS'
set CODE7 = ' ',
case CODE8 = 'GNS'
set CODE8 = ' ',
case CODE9 = 'GNS'
set CODE9 = ' ',
where ACCOUNT = :custAcct;
Thanks in advance!
Comment