isc_dsql_xml_fetch_all()

Go Up to API Function Reference

Creates an XML-formatted file using a previously prepared and executed statement handle.

Syntax

 int isc_dsql_xml_fetch(
 ISC_STATUS *status_vector, 
 isc_stmt_handle *stmt_handle, 
 unsigned short da_version, 
 XSQLDA *xsqlda, 
 IB_XMLDA *ib_xmlda);

Parameter	Type	Description
status_vector	ISC_STATUS*	Pointer to the error status vector
stmt_handle	isc_stmt_handle *	Pointer to a statement handle previously executed with isc_dsql_execute_statement() or ­isc_dsql_alloc_execute2().
da_version	unsigned short	Specifies that the XSQLDA descriptor, rather than SQLDA, should be used; set this value to 1.
xsqlda	XSQLDA *	Pointer to an optional, previously allocated XSQLDA used for results of statement execution.
ib_xmlda	IB_XMLDA*	Pointer to an initialized XML descriptor area, IB_XMLDA.

Description

isc_dsql_xml_fetch_all() creates an XML-formatted result set for a query. Use this function if you are interested in creating a complete XML file, but do not need to look at the data one row at a time. This function needs to be called only once (unlike isc_dsql_xml_fetch()). If you are interested in looking at the data one row at a time, use isc_dsql_xml_fetch().

For a complete example of how to generate XML from an InterBase table, see Exporting XML.

See Also

• isc_dsql_xml_buffer_fetch()
• isc_dsql_xml_fetch()

Advance To:

• isc_encode_sql_date()