This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
if [2016/03/31 09:30] dmtolpeko [IF Statement - PL/HQL Reference] |
if [2016/03/31 14:48] dmtolpeko |
||
---|---|---|---|
Line 35: | Line 35: | ||
**Compatibility:** Oracle, Teradata, IBM DB2, MySQL, PostgreSQL, Netezza. | **Compatibility:** Oracle, Teradata, IBM DB2, MySQL, PostgreSQL, Netezza. | ||
+ | |||
+ | **Version**: HPL/SQL 0.1 | ||
===== IF - BEGIN - END - ELSE - BEGIN - END ===== | ===== IF - BEGIN - END - ELSE - BEGIN - END ===== | ||
Line 70: | Line 72: | ||
**Compatibility:** Microsoft SQL Server. | **Compatibility:** Microsoft SQL Server. | ||
+ | |||
+ | **Version**: HPL/SQL 0.1 | ||
+ | |||
+ | ===== .IF THEN ===== | ||
+ | |||
+ | Syntax: | ||
+ | |||
+ | <code language=sql> | ||
+ | .IF boolean_expression THEN statement | ||
+ | </code> | ||
+ | |||
+ | **Example:** | ||
+ | |||
+ | <code language=sql> | ||
+ | .if errorcode <> 0 then .quit 1 | ||
+ | </code> | ||
+ | |||
+ | **Compatibility:** Teradata BTEQ | ||
+ | |||
+ | **Version**: HPL/SQL 0.3.31 | ||