I've got a real newbie question (just a few days of playing and fiddling with this under my belt) and I'm looking for some direction. As a very simple first pass I'm attempting to import data, using the timport command line, into a very simple existing table from an XML source file. Ultimately my tables and source files will be considerably more complex, but for now...
Here is the schema file (schema.scm):
xml
database /data1/texisdb/camp
table patn
field did varchar(8) patn/biblio/pub/docid/docnum NONE
field aid varchar(8) - NONE
Here is the XML file (datasmall.xml):
<?xml version="1.0" encoding="UTF-8"?>
<patn>
<biblio>
<pub>
<docid>
<docnum>D1</docnum>
</docid>
</pub>
<app apptype="design">
<docid>
<docnum>AD1</docnum>
</docid>
</app>
</biblio>
</patn>
Here is my command line:
timport -s schema.scm -v -t datasmall.xml
Here is the output I get:
200 Reading schema schema.scm
800 Inserting default "id" field into table
800 Statement: "insert into patn values(counter,?,?);"
200 Connecting to server
200 Opening database /data1/texisdb/camp
200 Verifying schema
200 Loading data
800 File: "datasmall.xml"
000 Texis daemon (1893) ABEND: signal 11
000 Texis daemon (1893) ABEND: signal 11
Nothing is written to the table. I have no idea what might be causing the ABEND. A kick in the right direction would be appreciated.
Here is the schema file (schema.scm):
xml
database /data1/texisdb/camp
table patn
field did varchar(8) patn/biblio/pub/docid/docnum NONE
field aid varchar(8) - NONE
Here is the XML file (datasmall.xml):
<?xml version="1.0" encoding="UTF-8"?>
<patn>
<biblio>
<pub>
<docid>
<docnum>D1</docnum>
</docid>
</pub>
<app apptype="design">
<docid>
<docnum>AD1</docnum>
</docid>
</app>
</biblio>
</patn>
Here is my command line:
timport -s schema.scm -v -t datasmall.xml
Here is the output I get:
200 Reading schema schema.scm
800 Inserting default "id" field into table
800 Statement: "insert into patn values(counter,?,?);"
200 Connecting to server
200 Opening database /data1/texisdb/camp
200 Verifying schema
200 Loading data
800 File: "datasmall.xml"
000 Texis daemon (1893) ABEND: signal 11
000 Texis daemon (1893) ABEND: signal 11
Nothing is written to the table. I have no idea what might be causing the ABEND. A kick in the right direction would be appreciated.