Re: Pro*C: declare table w. variable types?

In article <40afr8$kmu_at_hal.do.isst.fhg.de>, isenberg_at_kairo (Holger Isenberg) writes:
|> The Pro*C function DECLARE TABLE creates a table with column types
|> which are defined as constants.
|>

Actually, no. DECLARE TABLE is used only during the precompile if sqlcheck=semantics. It doesn't create anything.  

|> Does there exists a function like this
|>
|> createTable(STRING table_name, STRING column_a_type, STRING column_a_name,
|> col_b_type, ...)
|>
|> which creates a table of the desired column-types and -names?

I don't think there is a pre-existing one, but this would be awfully easy to write using dynamic SQL.

|>
|>
|> --
|> -------------------------------------------------------------------
|> Holger Isenberg
|> isenberg_at_do.isst.fhg.de
  Received on Wed Aug 09 1995 - 00:00:00 CEST