%SQL.DynamicStatement

Prepare() - this method must be invoked within a try/catch bas it throws an exception. This method is responsible for accepting an SQL statement and preparing an implementation of that statement. The implementation is an instance of a class that is a subclass of the statement type class (CURSOR = result set, non-cursor is a simple statement class, etc) The first task of prepare is to lookup the statement in the prepared statement cache by calling findStatement. Parameters: pStatementId pStatementText pStatementImports pSchemaPath : this is a comma delimited list of schema names. Generic tokens such as CURRENT_PATH and CURRENT_SCHEMA have been replaced with actual names pStatementHash : the hash key computed from the prequalifiers and the statement text (pStatementText) pStatementType : the integer identifying the type of statement contained in pStatementText pObjectMode : Object Select Mode pDialect : The statement dialect, CACHE, MSSQL[SERVER], Sybase, and DOCTYPE. DOCTYPE is used for caching json_columns_expression statements and other DocDB Types;

This is a trimmed down Prepare specifically for the purposes of preparing special cached statements for DOCTYPE (JSON_TABLE), etc. The table list for a type will include one or more collection names (syscollections) and perhaps a type name (systypes).