I'm trying to do a dataload into a Rocket Universe database. In going through the SQL Admin documentation, they give the following example, but very little in the way of describing what is going on with the config file. Can anyone shed a little more light on how the config file is defined? Any example resources on this? Thanks!
The following is an example of a data file:
tomr:"Tom" '"'Thomas Rand^29:77:240:"blond"green:Kevin
lisam:Lisa Michaels^28:66:130:"brown"brown:Troy
kellyv:Kelly Verock^37:72:180:"black"brown:none
paulv:Paul Vander^33:63:110:"brown"brown:Trisha
andyu:Andy Andrews^28:74:250:"blond"blue:none
ken:Ken Thompson^35:73:170:"grayy"blue:Peter
tim:Tim Tarks^35:75:180:"black"brown:none
steve:Steve Gough^35:68:180:"black"green:Nancy
ellen:Ellen Peters^33:75:220:"black"brown:Michael
derek:Derek Starks^34:66:120:"brown"brown:Karissa
The following example shows the corresponding configuration file:
FILE NUMBER: 1
LOCATION: ../dataloader/names2.data
Row Separator CHARACTER(S): 10
COLUMN SEPARATOR CHARACTER(S): :
QUOTE CHARACTER: "
ALTERNATE QUOTE CHARACTER: '
COLUMN NUMBER: 1
SOURCE FORMAT: RAW
COLUMN NUMBER: 2
SOURCE FORMAT: RAW
NEXT SEPARATOR CHARACTER(S): ^
COLUMN NUMBER: 3
SOURCE FORMAT: RAW
COLUMN NUMBER: 4
SOURCE FORMAT: RAW
COLUMN NUMBER: 5
SOURCE FORMAT: RAW
COLUMN NUMBER: 6
SOURCE FORMAT: RAW
WIDTH: 7
COLUMN NUMBER: 7
SOURCE FORMAT: RAW
COLUMN NUMBER: 8
SOURCE FORMAT: RAW
DESTINATION FILE:
LOCATION: TMP5950
AUTOSIZE: n
AUTOSIZE ROWS:
CREATE FILE: N
PARAMETER(S):
KEY COLUMN(S): KEY1
COLUMN NUMBER: KEY
COLUMN NAME: KEY1
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 1
COLUMN NUMBER: 1
COLUMN NAME: COL1
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 1
COLUMN NUMBER: KEY
COLUMN NAME: KEY2
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 2
COLUMN NUMBER: 2
COLUMN NAME: COL2
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 2
COLUMN NUMBER: KEY
COLUMN NAME: KEY3
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 3
COLUMN NUMBER: 3
COLUMN NAME: COL3
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 3
COLUMN NUMBER: 4
COLUMN NAME: COL4
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 4
CONVERSION TYPE: O
CONVERSION CODE: MD2
COLUMN NUMBER: 5
COLUMN NAME: COL5
SOURCE FILE NUMBER(S): 1
SOURCE COLUMN NUMBER(S): 8
>DATALOAD 5950.CONFIG
Does this define the config file enough for you - on page 5-42 there is a table.