I would know if there is an existing too that will be able to read the all script and change field name through a table with old and new field.
I had to change all field by aliases in script, but what i need to rename is not proprely the aliases but the original field name from the databasis (DB400 from IBM). In my example strange name before aliases.
A tool which would modify everything through a table old/new field (i have a lots of fields concerned in differents tables) would be wonderful !
Example :
LOAD NMEN000LB as [Street number],
CMLX000LB as [street adress 1],
NMON000LB as [street adress 2],
CDPT000 as [zip code],
NMBL000LB as [City],
PSGL000CD as [Country],
TLAL000RF as Phone,
FXAG000CD as Fax,
CNAD000LB as email;
SQL SELECT *
FROM XXXX.XXXX.GFGADR
I tried to found some text editors, but i can not find something like that.
