Setting variable for query using iSql / Korn Shell

Cailet · #1 (**permalink**) 02-09-2009

Hi All-

First time using iSql.
I have 4 query files - some have more than 1 line of sql statements

After a bit of research it appears I can just use the -i command and specify the input file.

Questions:

Does it matter that there are multiple queries in each file? Do I need to have special formatting within the files to ensure everything processes correctly?
Is there any way to pass in variables for the query statements?

Thanks!

quirkasaurus · #2 (**permalink**) 02-09-2009

1.) Multiple queries can be separated by semi-colons.

2.) Within the SHELL, you can use this:

Code:


isql << EOF

SELECT some_stuff
  FROM table_some_thing
 WHERE some_field = "$some_input_variable" ;

EOF

Cailet · #3 (**permalink**) 02-09-2009

Ok - so I can put multiple queries in my file as long as they all have the semi colon.

since I have a file full of queries, I would want to use the "-i" option. Unless I am missing something, it seems like putting them hardcoded into the script would be way too much. Is there any way for me to pass a variable into the iSql command when it runs the file?

quirkasaurus · #4 (**permalink**) 02-09-2009

Using my answer to #2.

Substitute a positional parameter like so:

% my_sql_stuff.sh first_arg second_arg

inside the my_sql_stuff.sh:

Code:


isql << EOF

SELECT some_stuff
  FROM table_some_thing
 WHERE some_field = "$1"
   AND something_else = "$2";

EOF

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Using isql in korn shell	risk_sly	UNIX for Dummies Questions & Answers	2	09-25-2008 10:46 PM
get values from isql query	DebianJ	Shell Programming and Scripting	3	06-27-2008 06:52 AM
isql query in unix shell script	jaydeep_sadaria	Shell Programming and Scripting	3	11-14-2007 03:07 AM
compound variable in korn shell	ZINGARO	Shell Programming and Scripting	5	10-03-2007 10:57 AM
Setting value of Shell variable from within ISQL	tipsy	Shell Programming and Scripting	3	08-29-2006 07:23 PM

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