Shell Programming and Scripting

Hi,

can we use arrays in shell script?

I have this so far:
#!/bin/sh
isql -Usa -P -S DBSERVER -o output << EOF
sp_transactions "state", "prepared", "xactname"
go
/
EOF

the file 'output'' will be have many entries and I want to caputre the transaction names only: grep 000 output works fine.

how to put these names into an array?

TRAN_NAME_LIST=$(grep 000 output) does not work.

thanks.

Melanie,
Do you have to put the data into an array?
Would this work for you:

Code:

mSQL="sp_transactions "state", "prepared", "xactname";"
mSQL=$mSQL"go;"
echo $mSQL | isql -Usa -P -S DBSERVER -o output 2>>mLogFile

Then you can do a grep to the output file.
If this doesn't work, give us the format of your output and what
your expected results.

thanks but this gives the same result: A file with this format:

xactname



-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
000007D6_dj0TcjcQnPgOc30PdPAPe5YTdjgRdjdvd34Ve38VdPsTnQ5ll4ZvnRZv00000000000000
0000000000000000_dPkQdjkPnPgNejwOejsTe5ZvnRY000000000000000000000000000
00000000000000000000000000000000

000007D6_dj0TcjcQnPgOc30PdPAPe5YVdj8NcPhvd34Ve38VdPwOnQ5ll4ZvnRZv00000000000000
0000000000000000_ejkOcjcQnPgNejwOejsUcRZvnRY000000000000000000000000000
00000000000000000000000000000000


these are 2 rows and I want to use them in this command:

dbcc complete_xact("$TRAN_NAME","rollback")

the TRAN_NAME is each of the values grepped in the file. To put these grepped values, I need an array or a list.

Melanie,
After the file has been written, you can read it and execute the
"complete_xact" procedure:

Code:

mSQL="sp_transactions "state", "prepared", "xactname";"
mSQL=$mSQL"go;"
echo $mSQL | isql -Usa -P -S DBSERVER -o output 2>>mLogFile
while read TRAN_NAME
do
  dbcc complete_xact("$TRAN_NAME","rollback")
done < the_previous_output_file_name