if
Differences
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] (current) 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 | ||
Page Tools
