FrankLv

[user@centos ~]$ cat db_object.list
BOX,FUNCTION,BASE_TO_LOCAL_TIME
BOX,FUNCTION,LOCAL_TO_BASE_TIME
[user@centos ~]$ cat 2spool.awk
BEGIN { FS = "," }
{
FILE_EXT=".sql";
if        ( $2 == "FUNCTION" ){
    FILE_EXT=".fnc"
} else if ( $2 == "PROCEDURE" ){
    FILE_EXT=".prc"
} else if ( $2 == "PACKAGE" ){
   FILE_EXT=".pks"
} else if ( $2 =="PACKAGE BODY" ){
   FILE_EXT=".pkb"
} else if ( $2 == "TRIGGER" ){
   FILE_EXT=".trg"
}

print "1 " $2
print "2 " FILE_EXT
SPOOL_FILENAME=$1 "." $3 FILE_EXT
print "3 " SPOOL_FILENAME

#fflush()
#print "spool off;"
}
END { print "exit;" }
[user@centos ~]$ awk -f 2spool.awk db_object.list
1 FUNCTION
2 .fnc
.fncX.BASE_TO_LOCAL_TIME
1 FUNCTION
2 .fnc
.fncX.LOCAL_TO_BASE_TIME
exit;