Re: Embedded SQL question

Bill,

So basically you are changing the company name in all your tables, right?
And you have some logic to determine what columns are your company name?
Are all the company name columns named the same? Like CMPNAM? Or do they
have silly names like RMCMNM, XYCNAM, ABCMPNAM and that sort? Or is it
somewhere in between like xxCMPNAM where xx is some table prefix?

I ALWAYS question using output files from DSPFFD. Is there something that
gives you, which you need to complete this project, that you cannot find
in SYSCOLUMNS? Because you could combine this into a single program and
eschew the whole CL program. This would reduce the outside chance of
someone calling the RPG program with parameters which make it easy to do
the SQL injection. Of course, with 10 character column and 10 character
table names those would be hard to pass an sql injection to. The open
area is the new company name.

select sys_cname, sys_tname, sys_dname
from syscolumns
where sys_cname like '%CMPNAM%'

and if you need further information, like you only want to select 15
character columns, then consider

select sys_cname, sys_tname, sys_dname
from syscolumns
where sys_cname like '%CMPNAM%'
and data_type='CHAR' and length=15


Rob Berendt