-- ROWS=1 is needed to make the CURRVAL of sequences work
--OPTIONS (ROWS=1)
LOAD DATA
APPEND

INTO TABLE cfdat_version
  WHEN (1) = 'VERSION'
  (  name    POSITION(9) ENCLOSED BY '"', 
     ver_id  EXPRESSION "cfdat_version_id_seq.NEXTVAL",
     svn_url ENCLOSED BY '[' AND '|',
     svn_rel TERMINATED BY ']'
  )

INTO TABLE cfdat_config
  WHEN (1) = 'CONFIG'
  TRAILING NULLCOLS
  (  
     cfg_id     EXPRESSION "cfdat_config_id_seq.NEXTVAL",
     name       POSITION(8) ENCLOSED BY '"',
     ver_id     EXPRESSION "cfdat_version_id_seq.CURRVAL" 
  )

INTO TABLE cfdat_script
  WHEN (1) = 'SCRIPT'
  TRAILING NULLCOLS
  (  script_id  EXPRESSION "cfdat_script_id_seq.NEXTVAL",
     name       POSITION(8) ENCLOSED BY '"',
     ver_id     EXPRESSION "cfdat_version_id_seq.CURRVAL"
  )

INTO TABLE cfdat_command
  WHEN (5) = 'cmd'
  TRAILING NULLCOLS
  (
    script_id  	POSITION(9) TERMINATED BY WHITESPACE
		"(SELECT script_id FROM cfdat_script WHERE name=:script_id AND ver_id=get_curr_ver_id(1))",
    seq		INTEGER EXTERNAL TERMINATED BY WHITESPACE,
    cmd		INTEGER EXTERNAL TERMINATED BY WHITESPACE,
    addr	INTEGER EXTERNAL TERMINATED BY WHITESPACE,
    data	INTEGER EXTERNAL TERMINATED BY WHITESPACE,
    dest	INTEGER EXTERNAL TERMINATED BY WHITESPACE
  )

INTO TABLE cfdat_config_scripts
  WHEN (5) = 'scr'
  TRAILING NULLCOLS
  (
    cfg_id	POSITION(9) TERMINATED BY WHITESPACE
		"(SELECT cfg_id FROM cfdat_config WHERE name=:cfg_id AND ver_id=get_curr_ver_id(1))",
    seq		INTEGER EXTERNAL TERMINATED BY WHITESPACE,
    script_id	TERMINATED BY WHITESPACE 
		"(SELECT script_id FROM cfdat_script WHERE name=:script_id AND ver_id=get_curr_ver_id(1))",
    ver_id	EXPRESSION "get_curr_ver_id(1)"
  )