UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.00 seconds. Search: Posts Made By: sgmini

Forum: Shell Programming and Scripting 11-11-2009

Assigning value of SQL output to a variable in shell scripting

6,115

Posted By

if i give the first code its giving the error as...

if i give the first code its giving the error as 'ksh: select COLUMN_NAME_1 from TABLE_NAME where COLUMN_NAME_2='VALUE_TO_CHECK': not found'.

and for the second its just displaying the select...

Forum: Shell Programming and Scripting 11-11-2009

Assigning value of SQL output to a variable in shell scripting

6,115

Posted By

Assigning value of SQL output to a variable in shell scripting

I am trying to assgn the output of the select statement to a variable, like this

"VARIABLE_NAME=$ db2 "select COLUMN_NAME_1 from TABLE_NAME where COLUMN_NAME_2='VALUE_TO_CHECK'"; "

but the...

Showing results 1 to 2 of 2