MQSeries.net :: View topic - Problem with the select

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with the select

Problem with the select

« View previous topic :: View next topic »

Author

Message

mayur2378

Posted: Wed Sep 22, 2004 10:22 am Post subject: Problem with the select

Apprentice

Joined: 26 May 2004
Posts: 47

Hey guys
heres my case am working on V5.0 CSD 3,

have written a select statement

set Environment.Variables.DBConn='select * from process';

set Environment.Variables.DBresult[]=passthru(Environment.Variables.DBConn)

When i run a trace on this, it returns an empty result set

But when i run the debugger on the flow i can see the values being assigned to Environment.Variables.DBConn

Any insight on why this could be happing would be a great help

Mayur

kirani

Posted: Wed Sep 22, 2004 10:30 pm Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Have you tried passing the query to PASSTHRU statement directly?
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with the select

Jump to:

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

Protected by Anti-Spam ACP