Progress
Embedded SQL-92
Guide and Reference
Using SQL for Condition Evaluation
You can use an SQL SELECT statement for condition evaluation in an ESQL program. The condition evaluation is performed using the syscalctable system table.
EXAMPLEThe following example shows how to use the SELECT statement to check whether the value in the ship_date column is valid:
The above example returns zero ( 0 ) in SQLCA.SQLCODE if the validation is successful. If the validation is unsuccessful SQLCODE is not set to zero.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |