DB2 Host Variables in Visual Basic

[allanhicks]

Hi,
Can anyone tell me if it is possible to use DB2 host variables in Visual Basic. I have searched the documentation but can only find examples for C++ & COBOL. If it is possible could you provide a code sample on how to utilise them.

I have asked this in the DB2 forum but have received no replies.

Thanks,
Allan Hicks

 

[treesprite]

Hi Allan,

I completed a project recently where I download DB2 table data from our mainframe to SQL server.

What is it you are trying to accomplish?

treesprite

 

[allanhicks]

Hi, I am trying to perform SQL queries on DB2 tables that return a single row result, eg

SELECT PRODUCT_NAME INTO NAME FROM PRODUCT_FILE WHERE PRODUCT_NAME = 'XXXX-XXX'

Where NAME is a 'host variable' as defined in the DB2 SQL guide. For example, in COBOL is could be defined as follows:

WORKING-STORAGE SECTION.
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
01 PNAME PIC X(8).
EXEC SQL END DECLARE SECTION END-EXEC.

The question is how do I accomplish the same thing in Visual Basic?

Thanks,
Allan Hicks

 

[splaisance]

Allan,

I am also using sql to query out DB2 data in visual basic. I have not tried the host variable approach but I do have an idea for you that has worked for me.

Put your sql into a string variable.

sqlline = &quot;SELECT PRODUCT_NAME FROM PRODUCT_FILE WHERE PRODUCT_NAME = &quot; & <productname variable>

Then open a recordset how you wish - i generally use ado

Now your recordset will have the queried product name. If more than one is returned you can also transverse the recordset to process each one.

I hope this helps!



-S

 

[chiph]

allan -

I'm not sure you can use host variables in VB, as it typically requires a pointer to the address of the variable. I think you'll be better off if you use the DB2 ADO or OLEDB driver. Won't be as fast as using DB2's library, but definately more portable and easier to read.

Chip H.