Adapter Data with Opcodes

win1,i,1,abc, row1
win1,i,2,zzzz, row2
win1,i,3,dfp, row3
win1,d,1,abc, row1
win1,u,3,dfp12, row3a

The i, d, and u values in the data are opcodes for inserting, deleting, and updating data, respectively.

The example creates an input window for the data named win1, to which it attaches the File CSV Input adapter.

The adapter property expectStreamNameOpcode is set to true so that the project server knows there are opcodes in the incoming data that it must execute.

Input Window
CREATE  INPUT  WINDOW win1
  SCHEMA (
  	a integer, 
  	b string , 
  	c string )
  PRIMARY KEY (a);

 
Input Adapter
ATTACH INPUT ADAPTER csvInConn1
  TYPE dsv_in
  TO win1
  PROPERTIES expectStreamNameOpcode = TRUE ,
  dir='../exampledata',
  file = 'input1.csv' ;