Hi,
The output should be something like this :
programme1.out;TABLE1;TAB_PERS;DISTINCT ID_PERS (or just ID_PERS, DISTINCT only if it's possible but not essential)
programme1.out;TABLE2;TABLE_FROM1;ID_PERS
Hi!
I'm not really "programmer" but I have to do a script.
The purpose of this script is to have something like this on input :
CREATE TABLE : prg1;TAB1 AS
SELECT : prg1;COL1,COL2,COL3
FROM : prg1;TABLEFROM
CREATE TABLE : prg1;TAB2 AS
SELECT : prg1;ALIAS1.COL1,ALIAS2.COL2
FROM ...
Thanks a lot! That's work for the data on exemple.
But I've tried with real data like this :
CREATE TABLE : programme1.out;TABLE1 AS
SELECT : programme1.out; DISTINCT PERS.ID_PERS
FROM : programme1.out;TAB_GRP GRP , TAB_PERS PERS
CREATE TABLE : programme1.out;TABLE2 AS
SELECT ...
I'm not really "programmer", actually I just have to test scripts and install it on the server.
Sometimes I have to do little modifications on scripts but I don't known any language well.
The purpose of this script is to have something like this on input :
[code]
CREATE TABLE : prg1;TAB1 AS...
Thanks for your response,
No I can't install gawk on this server, it's a production server I only can copy my script on it after testing on the testing server (where awk AND gawk are installed)
Is it very difficult to replace the match function? Nobody have already did that?
Hi,
I've a gawk script wich work fine with gawk but on the IBM AIX server I've just awk, the script doesn't work with awk, I've got this error :
$ awk -f awk_sql2.awk
syntax error The source line is 1. The function is parseCreate.
The error context is
<<< function parseCreate(t)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.