VB6 with AS400 cwbautsv.tlb

[Blobtech]

Hi,

I've tried this post on the IBM servers forum, but no joy yet so I thought I'd give it a go here.

I am writing a VB6 app that connects to our AS400, runs an SQL command and retrieves returned records. I've got no problem splitting the returned data stream into the correct fields and unpacking the packed fields. What I cannot do though, is work out how to submit the SQL command to look at other members within the file.

Any help would be appreciated.

P.S I don't want to do this with ODBC or ADO 'cos I find them both a pain

 

[chiph]

ADO is your best bet, as IBM's OLE-DB driver is quite good.

Chip H.

 

[dvannoy]

I do something similar to this as well using IBM's OLEDB driver. but you must make sure you specify the system name as well as the correct library you wish to query. if your running sql your best bet is just do a stored procedure that gets the records for you.

 

[Blobtech]

Thankyou for the replies.

Although chiph, if you read my original post I don't want to do this with ADO! And besides with my chosen mehthod I can call AS400 commands and run programs (stored procedures if you like)

And dvannoy, I am using the correct system and library name but the fetch command will only pickup the first member of the file. I am trying to find a way to get other members of the file but I can't figure out the SQL.

 

[Blobtech]

I have sorted out this problem myself now, so please ignore it.

 

[johnwm]

Blobtech,
..and the answer was?

The guys that tried to help you may appreciate knowing what your answer was.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Blobtech]

And the winner is......

to use to cwbdbOverrideFile method of the cwbDatabaseDB2 object before using the cwbDatabaseSQL object