| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| PASSTHRU command to send DB2 command |
« View previous topic :: View next topic » |
| Author |
Message
|
| GaryGWood |
 Posted: Tue Jan 13, 2004 11:46 am Post subject: PASSTHRU command to send DB2 command |
 |
|
Apprentice
Joined: 14 Oct 2003
Posts: 48
Location: Austin, TX
|
I connect to a database (DBASE1) and want to send it the following command but it doesn't work:
PASSTHRU('SET PASSTHRU DBASE2');
Any ideas what I have going wrong here? |
|
| Back to top |
|
 |
| dhincali |
| Posted: Tue Jan 13, 2004 12:03 pm Post subject: |
|
|
Novice
Joined: 29 Dec 2003
Posts: 22
|
Hi Gary,
What is actually not working? Can you tell us what error messages you are getting? As far as i know, the SET PASSTHRU statement opens and closes a session for submitting a data source's native SQL directly to that data source. The statement is not under transaction control.
I dont know if that would work. But what is the error that you are getting in your trace?
_________________
learning traveller |
|
| Back to top |
|
|
| Robert |
| Posted: Wed Jan 14, 2004 4:15 pm Post subject: |
|
|
Apprentice
Joined: 22 Aug 2002
Posts: 46
Location: Quebec, Canada
|
Hi Gary,
You should have a valid SQL Statement within the quotes in your PASSTHRU statement.
Robert |
|
| Back to top |
|
|
| GaryGWood |
| Posted: Mon Jan 19, 2004 8:06 am Post subject: |
|
|
Apprentice
Joined: 14 Oct 2003
Posts: 48
Location: Austin, TX
|
Thanks for the responses. Sorry for the delay - it's always something. 
What we're trying to do is pass the DB2 command thru to the DB2 server. The error I'm getting is: "Error executing SQL statement 'SET PASSTHRU DWP' against datasource 'DB2Connection' with parameters.
A subsequent error message says "DWP" is an undefined name.
I'm thinking Robert may be on to something here with this not being valid SQL. So how could I pass the DB2 command to the server? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
