VALIDATE_SQL

<< Click to Display Table of Contents >>

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

VALIDATE_SQL

Previous pageReturn to chapter overviewNext page

This function, along with COMPLETE_SQL, VALIDATE_SQL and FORMAT_SQL is primarily used for tool developers (s-Studio uses these functions to complete, validate, and format SQL). Validates 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.VALIDATE_SQL(sql_statement,default_schema);

 

Returns table

Field

Type

start_line_num

integer

start_column_num

integer

end_line_num

integer

end_column_num

integer

message

varchar(4096)