Loading ASCII Files
> From: M23443@mwvm.mitre.org
> Message-Id: <16BED9CE9.M23443@mwvm.mitre.org>
> Subject: Transfering ascii text to a database table
> Date: Mon, 14 Jun 1993 15:09:29 GMT
> Reply-To: M23443@mwvm.mitre.org
> Organization: The MITRE Corporation, McLean VA 22102
> Sender: informix-list-owner@rmy.emory.edu
> To: informix-list@rmy.emory.edu
> X-Informix-List-To: informix-distr@saad-emh1.army.mil
> X-Informix-List-Id: <news.3567>
>
> I am attempting to transfer a text file to a database >
> table, using the
> following command:
> load from "name" delimiter "\\t" insert into table_name
> It apparently doesn't like "name", yet I can't figure out any
> problem with
> the syntax, based on our manual.
> Any suggestions? Thanks in advance.>
> Michael
> m23443@mwvm.mitre.org
Michael,
From your brief description of the problem it sounds like you
want to take a pure ascii text file and load it into an SQL
database. Suggestion: Try looking at the DBLOAD UTILITY in the
appendix of your SQL manual.
DBLOAD permits you to load pure ascii test files created from
other database types or created from text editors.
From your Operating System Command Line try:
<- dbload -d databasename -c name -l errorlog
There are many more options which can be used if you need them,
this should get you started.
Michael S. Gordon
Foreman, Gyroscope Section
Avionics Division
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* *
* Michael Gordon Sacramento Army Depot *
* Foreman, Gyroscope Section Directorate For Maintenance *
* E-Mail: maint72@saad-emh1.army.mil Attn: SDSSA-MAV-320 *
* DSN: 839-2367 Michael S. Gordon *
* Comm.: (916) 388-2367 Sacramento, CA 96813-5036 *
* *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *