Shell Programming and Scripting

COMMENT ON TABLE DATABASE.TABLE_NM AS 'PK=,COL1,COL2; ';
COMMENT ON TABLE DATABASE.TABLE_NM AS 'PK=,COL1; ';
COMMENT ON TABLE DATABASE.TABLE_NM AS 'PK=,COL2; ';

TBL_DB="DATABASE"
awk -v VAL_DB="${TBL_DB}" '/CREATE UNIQUE INDEX/,/)/ {
if(/CREATE UNIQUE INDEX|\(/) {
  next
}
if (!/\)/){
  A=A $NF
}
else{
  X=$NF
  sub(/;/,"",X)
  print "COMMENT ON TABLE "VAL_DB"." X " AS \047PK=," A "; \047;"
  split(A,B,",")
  for (i in B){
   print "COMMENT ON TABLE "VAL_DB"." X " AS \047PK=," B[i] "; \047;"
  }
}
}' input_index.txt > cmnt1.txt

CREATE  TABLE TBL_NM
(

        COL1               DECIMAL(18,0) NOT NULL,
        COL2               CHAR(2) NOT NULL ,
        COL3               CHAR(5) NOT NULL ,
        COL4               SMALLINT NOT NULL
);

REPLACE VIEW DB_NM.TBL_NM 
AS
COL1,
COL2,
COL3,
COL4
FROM DBASE.TBL_NM;

DBASE="FOO"
DB_NM="BAR"
awk -v VAR1="${DB_NM}" -v VAR2="${DBASE}" '/CREATE *TABLE/,/);/ {
 switch ($0) {
  case /CREATE *TABLE/:
   X=$3
   print "REPLACE VIEW "VAR1"."$3
   break
  case /^\(/:
   print "AS"
   break
  case /^$/:
   break
  case /^\);/:
   print "FROM "VAR2"."X";"
   break
  default:
   gsub(/[^,]/,"",$NF)
   print $1$NF
 }
}' file.txt

awk: cmd. line:2:  switch ($0) {
awk: cmd. line:2:              ^ syntax error
awk: cmd. line:4:   case /CREATE *TABLE/:
awk: cmd. line:4:                       ^ syntax error
awk: cmd. line:7:   case /^\(/:
awk: cmd. line:7:         ^ syntax error
awk: cmd. line:7:   case /^\(/:
awk: cmd. line:7:          ^ backslash not last character on line

DBASE="FOO"
DB_NM="BAR"
awk -v VAR1="${DB_NM}" -v VAR2="${DBASE}" '/CREATE *TABLE/,/);/ {
  if (/CREATE *TABLE/){
   X=$3
   print "REPLACE VIEW "VAR1"."$3
   next
  }
  if (/^\(/){
   print "AS"
   next
  }
  if (/^$/){
   next
  }
  if (/^\);/){
   print "FROM "VAR2"."X";"
   next
  }
   gsub(/[^,]/,"",$NF)
   print $1$NF
}' file.txt