Modifying Data Using CA Dataquery › DQL Language Data Modification › DQL Language Examples

DQL Language Examples

Sample ERASE Query

ERASE  CA-DETAIL-REC WITH ORD-ID = 9000

Sample INSERT Query

INSERT CA-DETAIL-REC
SET   ORD-ID       = 9000
SET   ITM-ID       = 'X10000'
SET   ORD-QTY      = 99
SET   SHIP-QTY     = 99
SET   UNIT-PRICE   = 99.99
SET   DISC-PCT     = 0.0
SET   ACT-YR       = '87'
SET   ACT-MO       = '01'
SET   ACT-DAY      = '01'

Sample UPDATE Query

UPDATE CA-DETAIL-REC WITH ORD-ID = 9000
SET   ORD-QTY      = 01
SET   SHIP-QTY     = 01
SET   UNIT-PRICE   = 100.00
SET   DISC-PCT     = 0.0
SET   ACT-YR       = '87'
SET   ACT-MO       = '04'
SET   ACT-DAY      = '21'