Shell Programming and Scripting

Hi

I am using SQSH to construct 10-20 bcp commands that I would like to execute. I can write all to file and open and do a for loop in the file.
My question is if there is some way I can skip the file part and somehow pipe out the resulting dataset from SQSH and execute those directly?
My experience with bashscripting is very limited at the time so please bare with me :-)

Thanks
Mike

First, bcp out is just a formatted select, so just select serially or in a union and pipe the client to bash 'while read' (lower latency than 'for' and splits lines), like this:

Code:

echo '
 select a, b, c from d;
 select e, f, g from h ;
 ' | sql_client connect args | while read i j k
  do
    . . . $i . . . $j . . . $k . . . .
  done > output_file