What programming SQL constructs are available in PointBase? Specifically is there a CASE (or similar) sql keyword in pointbase?
PointBase 5.4 and later supports the use of a CASE expression in a SELECT statement. For example: SELECT Name, CASE WHEN Grade > 80 THEN 'Honors' WHEN Grade >= 50 THEN 'Pass' ELSE 'Fail' END FROM students; Also a WHEN clause is supported in the TRIGGER creation statement. CREATE TRIGGER trigger3 BEFORE UPDATE ON product_tbl REFERENCING NEW AS NEWROW FOR EACH ROW WHEN (NEWROW.purchase_cost <0) SIGNAL 'Products prices cannot be negative' The details for both can be found in the PointBase Embedded documentation.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.