Function API_ROUTINE isc_embed_dsql_prepare

src/yvalve/user_dsql.cpp:522–630

ISC_STATUS API_ROUTINE isc_embed_dsql_prepare(ISC_STATUS*	user_status,
											  FB_API_HANDLE*	db_handle,
											  FB_API_HANDLE*	trans_handle,
											  const SCHAR*	stmt_name,
											  USHORT	length,
											  const SCHAR*	string,
											  USHORT	dialect,
											  XSQLDA*	sqlda)
 {
/**************************************
 *
 *	i s c _ e m b e d _ d s q l _ p r e p a r e
 *
 **************************************
 *
 * Functional description
 *	Prepare a statement for execution.
 *
 **************************************/
	ISC_STATUS s;
	ISC_STATUS_ARRAY local_status;
	dsql_stmt* statement;
	FB_API_HANDLE stmt_handle;

	init(db_handle);
	set_global_private_status(user_status, local_status);

	try {

	dsql_name* name = lookup_name(stmt_name, statement_names);

	if (name && name->name_stmt->stmt_db_handle == *db_handle)
	{
		// The statement name already exists for this database.
		// Re-use its statement handle.

		statement = name->name_stmt;
		stmt_handle = statement->stmt_handle;
	}
	else
	{
		// This is a new statement name for this database.
		// Allocate a statement handle for it.

		if (name) {
			isc_embed_dsql_release(user_status, stmt_name);
		}
		statement = NULL;
		stmt_handle = 0;
		s = isc_dsql_allocate_statement(user_status, db_handle, &stmt_handle);
		if (s)
		{
			return s;
		}
	}

	s = isc_dsql_prepare(user_status, trans_handle, &stmt_handle, length, string, dialect, sqlda);