Even simpler XML timport

barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Even simpler XML timport

Post by barry.marcus »

OK. I've simplified this as much as I think I possibly can, and I'm still getting nowhere. Here is schema.scm:

xml
database /data1/texisdb/camp
table mytest
field docnum varchar(8) dataset/record/docnum NONE

Here is datasmallsimple.xml:

<dataset>
<record>
<docnum>D1</docnum>
</record>
</dataset>

Here is my command line:

timport -s schema.scm -v -t datasmallsimple.xml

Here is the output:

200 Reading schema schema.scm
800 Inserting default "id" field into table
800 Statement: "insert into mytest2 values(counter,?);"
200 Connecting to server
200 Opening database /data1/texisdb/camp
200 Verifying schema
105 No such table mytest2 In the function: getrowattrs
215 Creating the table(s):
215 create table mytest2("id" counter,"docnum" varchar(8));
215 grant select on mytest2 to PUBLIC;
200 Loading data
800 File: "datasmallsimple.xml"
000 Texis daemon (15765) ABEND: signal 11
000 Texis daemon (15765) ABEND: signal 11

Same thing... i.e., ABEND and no data written to new table.

Here is the output of texis -version:

Texis Web Script (Vortex) Copyright (c) 1996-2004 Thunderstone - EPI, Inc.
Commercial Version 5.00.1090358162 20040720 (i686-unknown-linux2.4.2-64-32)

This can't be that hard, but as newbie, I'm at a complete loss...
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Even simpler XML timport

Post by mark »

Hmm, I'm seeing the same thing in a 2004 version using command line timport. Using <timport> from within vortex works though. Try that. Don't forget to use "row" in your <timport> directive.