isql query in unix shell script - Shell Programming and Scripting

jaydeep_sadaria · #1 11-13-2007

Dear all

I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.

isql -U -P
use gdb_1
go
select count (*) from table_x
go

porter · #2 11-13-2007

Do you mean

Code:

#!/bin/sh

isql -U -P <<EOF
use gdb_1
go
select count (\*) from table_x
go
EOF

jaydeep_sadaria · #3 11-13-2007

Quote:

Originally Posted by porter

Do you mean

Code:

#!/bin/sh

isql -U -P <<EOF
use gdb_1
go
select count (\*) from table_x
go
EOF

what does mean by <<EOF and EOF at last statement.

porter · #4 11-14-2007

It means use everything between these two tags as stdin.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
get values from isql query	DebianJ	Shell Programming and Scripting	3	06-27-2008 03:52 AM
C Shell Script query	bpupdown	Shell Programming and Scripting	1	05-13-2008 04:38 PM
A simple query on unix shell script	shekhar_ssm	Shell Programming and Scripting	2	01-23-2008 08:41 AM
sql query results in unix shell script	skyineyes	UNIX for Dummies Questions & Answers	1	06-20-2007 07:56 AM
isql in shell script help	mrviking	Shell Programming and Scripting	2	06-09-2006 02:11 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode