Re: dbload under 4GL RDS 4.00
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!dranney
From: dranney@informix.com (David Ranney)
Newsgroups: comp.databases.informix
Message-ID: <1991Sep26.195045.7267@informix.com>
Date: 26 Sep 91 19:50:45 GMT
References: <1991Sep24.153208.3787@watmath.waterloo.edu}
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
In article <1991Sep24.153208.3787@watmath.waterloo.edu} dvadura@plg.uwaterloo.ca (Dennis Vadura) writes:
}This one is for a friend. She's been trying to use dbload (under 4GL RDS 4.00
}the interpretted version) to load a an ascii file containing variable length
}data records into a simple database. The file contains lines of the form:
}
} f1|f2|f3|f4|
} f1|f2|f3|f4|
} f1|f2|f3|f4|
} ...
}
}She's built a command file which contains:
}
} FILE "table1.new" DELIMITER "|" 4 ;
} insert into table1 ;
}
}Which is exactly as is described in Appendix E of Volume 2 of the reference
}manual. running dbload on this with the command line,
}
} dbload -d database -c cmdfile -l err
}
}(I think those are the flags, anyway, you give the file, the database and an
}error log file) produces nothing but a message saying that a file command
}must be the first command in the command file. I've checked the manual for
}her and can see nothing wrong. She's placed a call to informix but alas got
}told "all our soFtware engineers are busy" so I thought I'd post here
}since no doubt someone has tried this and perhaps even figured out what
}the magic incantation should be.
}
}-thanks in advance
}-dennis
I've had this happen to me before. You're not going to like the solution.
Try putting "DELIMITER" in lower case and try it again.
--
+------------------------------------------------------------------------------+
| David Ranney {uunet | pyramid}!infmx!dranney |
| Informix doesn't pay me enough to write their opinions for them. |
+------------------------------------------------------------------------------+