Q:Pro*C host vars

I have a question. I would like to concatenate an owner to the front of a table name, but I can't seem to find the answer. All I am trying to do is a simple embedded sql query like so:

SELECT ITEM_ID into :item_id FROM OWNER.SOMETABLE WHERE ITEM_NBR = :number;

My problem is my 'OWNER' is variable. I tried turning the table name into a host variable :table and concatenating the owner to the front, but to no avail. Is what I want to do possible? Any help would be greatly appreciated.

Jeff Pickett
jdp_at_pittslug.sug.org Received on Wed Aug 18 1993 - 21:29:30 CEST