* 0: sqlstate: Please help

[Former Member]

Hi,

running a select statment in a bash script is giving as reult: * 0: sqlstate, where nothing was found

var1=`/opt/sdb/programs/bin/sqlcli -n ***** -d ***** -u ***,*** "select * ....."`

echo $var1 : * 0: sqlstate

it is not a NULL, it is not an empty string!

what is this for a result please ?

your help is much appreciated

Edited by: slac ware on Oct 25, 2010 10:02 AM

Edited by: slac ware on Oct 25, 2010 3:10 PM

[Former Member]

Look like your script doesn't like *, can you try to execute with some field rather than *

[Former Member]

thanks Sunil Bujade,

i am selecting only 1 field, so i am not using select *, i put it in my post to but i am not using it, btw. the problem when noting was found "NULL", not when the select was successful

Edited by: slac ware on Oct 25, 2010 3:54 PM