Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a little problem for several qvw script.
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.
Thank you for your help guys !
might be the one you're looking for:
Hi Johnatan, are you sure you can use this to modify a full script in a .csv or word file ? (full text)
Best regards