Parse and validate select statement

Database
N/A

Parse and validate select statement

Hi All,

Is there a way to parse and validate a SQL select statement w/o executing it using Teradata JDBC driver or another mechanism?

Thanks,

Hien

Tags (1)
2 REPLIES
WAQ
Enthusiast

Re: Parse and validate select statement

Well in SQLA you can use F6 to get the explain plan. It will only generate the plan if you query is correct syntatically.

Teradata Employee

Re: Parse and validate select statement

Yes, the way to parse and validate a SQL select statement without executing it, using the Teradata JDBC Driver, is to prepare the SQL statement:

PreparedStatement ps = con.prepareStatement("select * from mytable");