The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Setting variable for query using iSql / Korn Shell
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Setting variable for query using iSql / Korn Shell
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 02-09-2009
quirkasaurus's Avatar
quirkasaurus quirkasaurus is offline
Registered User
  
 

Join Date: Jan 2009
Location: canton, michigan
Posts: 396
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