Pro*C

From: Abe Jacob <abrahamj_at_planmatics.com>
Date: Thu, 4 Feb 1999 17:37:58 -0500
Message-ID: <Jopu2.7604$r%4.15777_at_news21.bellglobal.com>

[Quoted] Would anybody be able to tell me how I can do the following using dynamic SQL in PRO*C:

I have approx. 600 tables in my database, my program does inserts and selects on any of these tables depending on the table name and some other data passed to it. I follow the steps in the sample10.pc. I want to keep the cursors open so that I do not have to re-declare and close it for speed. The only way it seems I can do this by using some sort of a "if else" or "switch case" statement which will be a huge one (with 600 tables).

In INFORMIX ESQL/C I could declare a Host variable which could be used as a cursor so I used to copy the table name into this host variable and then do the steps in sample10.pc.

Is their any way I can achieve what I want to do above?

Thanks for the help.

Abe Received on Thu Feb 04 1999 - 23:37:58 CET