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
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