Hello Guys,

Well, using shell script, I'm doing loop on DB query as below:

isql -Usa -Ptest -I /opt/sybase/interfaces << EOF
use testdb
go
declare @i int
select @i = 1
while(@i <= 5)
begin
Insert into TEST values (@i,"Test","TestDesc")
select @i = @i + 1
end
go
EOF

The Issue here, that i want to print out the index on the console for each loop after the insertion has been done, or redirect the indexs to a file.

Ex: echo "Row @i has been inserted"

But i tried to put this echo after the insertion, but gave me error, any advice !!!!

Tha idea behind that, i want to know what indexes have been inserted successfully !!!

Thanks,
- Ala'eddin