Home Explore Help
Sign In
Neil
/
Q5
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Q5
/
ws_objects
/
Ew_mainface.pbl.src
/
test.srp

test.srp 723 B
Permalink History Raw

1234567 
  1. $PBExportHeader$test.srp
    2. 

  2. PIPELINE(source_connect=ecv_demo,destination_connect=ecv25_his,type=update,commit=100,errors=100,keyname="u_mtrl_storage")
    3. 

  3. SOURCE(name="u_mtrl_storage",COLUMN(type=long,name="mtrlid",dbtype="int",key=yes,nulls_allowed=no)
    4. 

  4.  COLUMN(type=long,name="storageid",dbtype="int",key=yes,nulls_allowed=no))
    5. 

  5. RETRIEVE(statement="PBSELECT(TABLE(NAME=~"u_mtrl_storage~") COLUMN(NAME=~"u_mtrl_storage.mtrlid~")COLUMN(NAME=~"u_mtrl_storage.storageid~"))")
    6. 

  6. DESTINATION(name="u_mtrl_storage",COLUMN(type=long,name="mtrlid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0",default_value="(0)")
    7. 

  7.  COLUMN(type=long,name="storageid",dbtype="int",key=yes,nulls_allowed=no,initial_value="0",default_value="(0)"))
    8.