Hello everybody,

I am bulding a unix shell script which does several database
connections to return or modify some data.

To do this I use the isql comand.

Since now I have had no problems in returning the value a table field
assigning it to a shell variable, in the following way:

VAR=$(/opt/firebird/bin/isql $PATHDB -user $DBUSER -password
$DBPASSWORD -i my_select.sql)

Is there a nicer way of doing this?

If I have to return more tan one field, in the same query, I have to
"look into" the variable and it gets more complex.

Is it possible to assign a value in isql, and use it in the shell
script, in an easier way?

Thanks in advance.