DSXchange

Hi,

I want to use SQL statement :

select colum1 from schema.table where colum2='abc'


Cmd = "db2 " : "'connect to pdw_dev user pdw using Db2dba1'"

Call DSExecute('UNIX',Cmd,Output,Status)

Cmd = "db2 -x " : "'select colum1 from schema.table where colum2='abc' '"

Call DSExecute('UNIX',Cmd,Output1,Status)




This routine doesn't return anything from the SQL. Can anyone help me with the syntax? Thanks

How about starting by checking the status of your calls and logging that? I'd also include logging the output so you have some clue what is going on while you get this working.

db2 -x 'select colum1 from schema.table where colum2='abc' '

DSLogInfo called from :0

Result= SQL0206N "abc" is not valid in the context where its used
SQLSTATE=42703

And... solved?

If not, did you look up the error or have any thoughts on what the issue might be? What happens when you run that same statement at the command line as the user that the job is running under? Get it running there before throwing it into the routine...

no, not.
if I use the DB2 commandline processor to run the query it returns the rows.

This command works for the numeric constant values like but not for character value.
db2 -x 'select colum1 from schema.table where colum2='1123'

You can't (successfully) enclose single quote characters in single quotes.

... or (successfully) use mismatched quotes.

Try running with Double quotes

db2 -x "select colum1 from schema.table where colum2='abc'"