12.2.7 Operands related to DESCRIBE statement

14) pd_hb_use_describe = Y | N
Specifies whether to allow a foreign server (ORACLE) to issue a DESCRIBE statement when receiving data from that foreign server. If the foreign server is allowed to issue a DESCRIBE statement, the data type of the foreign server can be mapped to a larger number of columns in a foreign table. For details on data type correspondence when a foreign table is used, see the manual HiRDB Version 8 SQL Reference.
Y: Allows the issuance of a DESCRIBE statement.
N: Does not allow the issuance of a DESCRIBE statement.
Specification guidelines
  • Specify Y if a DESCRIBE statement is needed for mapping a data type to HiRDB.
  • When Y is specified for this operand, a DESCRIBE statement is internally issued for each SQL execution, and therefore the performance may decrease compared to a case in which N is specified.