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
using SQL in routine
Moderators: chulett, rschirm, roy
using SQL in routine
Last edited by India2000 on Sun Dec 24, 2017 11:01 am, edited 1 time in total.
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...
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: