long shell commands

[codemut]

Perhaps awk is not the best language for a long bash/sql interaction like that in quotes here:

command = "sqlite3 filename.sql <<SQL_ENTRY
... several lines of SQL ...
SQL_ENTRY"

Any ideas on how to make a command of many lines appear as one string (or how to better combine awk and sql)?

 

[PHV]

Something like this ?
command = "sqlite3 filename.sql <<SQL_ENTRY"
command = command "\nline1 of SQL ..."
...
command = command "\nlastline of SQL ..."
command = command "\nSQL_ENTRY"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886