Use selected SQL calls to reference and test special registers as column values. Special Registers include:
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- CURRENT DATE
- CURRENT TIME
- CURRENT TIMESTAMP
- CURRENT TIMEZONE
Use special registers in DB-DECLARE, DB-OBTAIN, and DB-PROCESS calls to:
- Store and display the special register values.
- Evaluate special register values in WHERE clauses for conditional processing.
Examples:
Store the value of CURRENT-DATE in a Working-Storage field.
DB-OBTAIN REC D2TAB-REC
... PM_PART_NO
... PM_COLOR (WS-COLOR)
... CURRENT DATE (WS-CURR-DATE)
... WHERE PM_PART_SHORT_DESC = 'WIDGET'
... AND PM_COLOR = 'RED'
Select rows by comparing column SHIP_DATE with the special register CURRENT DATE.
DB-PROCESS REC D2INVEN-REC
... DB-PROCESS-ID D2INV-ID
... IN_PART_NO
... IN_PART_SHORT_DESC
... IN_QTY_ONHAND
... WHERE SHIP_DATE = CURRENT DATE
Comment:
Do not use SQL function names, such as HOUR, TIMESTAMP, as column names.