COMPLETE_SQL

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

COMPLETE_SQL

Previous pageReturn to chapter overviewNext page

This function, along with IS_VALID_SQL, VALIDATE_SQL and FORMAT_SQL is primarily used for tool developers (s-Studio uses these functions to complete, validate, and format SQL). Auto-completes SQL statement.

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.

Syntax:

SYS_BOOT.MGMT.COMPLETE_SQL(SQL_STATEMENT,OFFSET);

 

Returns table with item_type and item_name