pass a variable to sql - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
pass a variable to sql

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
ksh variable pass to awk	meman1188	Shell Programming and Scripting	4	05-10-2009 01:30 AM
How do I pass a variable to awk?	eja	UNIX for Dummies Questions & Answers	12	04-03-2007 06:46 PM
How to pass a variable to Awk ?	Raynon	Shell Programming and Scripting	24	02-26-2007 09:25 AM
pass variable to awk	inquirer	UNIX for Dummies Questions & Answers	4	02-11-2004 03:23 AM
Pass variable to sed?	kristy	Shell Programming and Scripting	2	04-04-2002 04:14 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

4 Weeks Ago

mac4rfree

Registered User

Join Date: Sep 2008

Posts: 170

pass a variable to sql

Hi Guys,

I like to pass a variable to a sql file in a unix script..

I tried a below code..

Code:

 
var=200903
 
db2 -vf  test.sql 200903

test.sql is as below.

Code:

select *  from db2.users where quarter = $1;

Please tell me where i go wrong..

Thanks in advance,
Magesh

Bookmarks

« Escape Space in a ssh command | parsing rows »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 08:14 AM.