Re: onpladm load job with spec file (includes simple but lengthy test case)
First of all, in my copy and paste of the test case, I doubled the
"END SEQUENCE" for the map. D'oh, as it were.
Richard Kofler copied my entire message before asking for the error I
am still getting and the output of various onpladm list and describe
commands.
$onpladm create object -F specfilename
Successfully created object DEVICEARRAY device_array_name
Successfully created object DELIMITEDFORMAT formatname
Successfully created object LOADMAP mapname
Syntax error in interface file line :56
Create object LOADJOB failed!
Invalid format!
Note, line 56 is the 'PROJECT projectname' line. If there truly is a
syntax error, I suspect it is in the 'BEGIN OBJECT LOADJOB jobname'
line which precedes it.
Though lengthy, the output from the list and describe commands is
below.
As for using one specification file, it should not matter. In any
case, I have split it up with no change but the line number in the
error.
By the by, I get an error when listing defaults. Could that be
related?
$onpladm list defaults
Error Encountered When Building Server List!
Sincerely,
Christopher Coleman
Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
$onpladm list project
<default>
projectname
$onpladm describe project projectname
BEGIN OBJECT PROJECT projectname
END OBJECT
$onpladm list format -p projectname
formatname
$onpladm describe format formatname -p projectname
BEGIN OBJECT DELIMITEDFORMAT formatname
PROJECT projectname
CHARACTERSET ASCII
RECORDSTART
RECORDEND newline
FIELDSTART
FIELDEND
FIELDSEPARATOR |
BEGIN SEQUENCE
FIELDNAME fieldname
FIELDTYPE Chars
END SEQUENCE
END OBJECT
$onpladm list map -p projectname
mapname [L]
$onpladm describe map mapname -p projectname -fl
BEGIN OBJECT LOADMAP mapname
PROJECT projectname
FORMAT formatname
DATABASE targetdatabasename
TABLE targettablename
BEGIN SEQUENCE
COLUMNNAME columnname
FIELDNAME fieldname
JUSTIFICATION
CASECONVERT
DEFAULTVALUE
TRANSFERBYTES 0
COLUMNOFFSET 0
FIELDOFFSET 0
FIELDMINIMUM
FIELDMAXIMUM
FILLCHARACTER
PICTURE
FUNCTION
STORAGECODING
BLOBCOLUMN
END SEQUENCE
END OBJECT
$onpladm list job -p projectname
There are no Jobs in the Project
$onpladm describe job jobname -p projectname -fl
Invalid Job Name!