다음의 ESQL 코드에는 세 가지 조작을 모두 보여주는 명령문이 있습니다. 이 코드는 Database 및 Filter 노드에 적합합니다. 이 코드를 Compute 노드용으로 작성한 경우 Root 대신 상관 이름 InputRoot를 사용합니다.
IF Root.XML.TestCase.Action = 'INSERT' THEN INSERT INTO Database.STOCK (STOCK_ID, STOCK_DESC, STOCK_QTY_HELD, BROKER_BUY_PRICE, BROKER_SELL_PRICE, STOCK_HIGH_PRICE, STOCK_HIGH_DATE, STOCK_HIGH_TIME) VALUES (CAST(Root.XML.TestCase.stock_id AS INTEGER), Root.XML.TestCase.stock_desc, CAST(Root.XML.TestCase.stock_qty_held AS DECIMAL), CAST(Root.XML.TestCase.broker_buy_price AS DECIMAL), CAST(Root.XML.TestCase.broker_sell_price AS DECIMAL), Root.XML.TestCase.stock_high_price, CURRENT_DATE, CURRENT_TIME); ELSEIF Root.XML.TestCase.Action = 'DELETE' THEN DELETE FROM Database.STOCK WHERE STOCK.STOCK_ID = CAST(Root.XML.TestCase.stock_id AS INTEGER); ELSEIF Root.XML.TestCase.Action = 'UPDATE' THEN UPDATE Database.STOCK as A SET STOCK_DESC = Root.XML.TestCase.stock_desc WHERE A.STOCK_ID = CAST(Root.XML.TestCase.stock_id AS INTEGER); END IF;