Re: using LOAD DATA INFILE with dbexport from informix

[Brian P. Millett]

On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote:
 Your message cannot be posted because it appears to be either spam or
 simply off topic to our filter. To bypass the filter you must include
 one of the following words in your message:
 
 sql,query
 
 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. Just typing the word MySQL once will be sufficient, for example.
 
 You have written the following:
 
 I've noticed the hard way that there is more to loading data exported
 from informix than just:
 
 LOAD DATA LOCAL INFILE speci02695.unl
  INTO TABLE specimens FIELDS TERMINATED BY '|';
 
 I have all of the columns that are INTEGER that were NULL in informix,
 now have the value 0. 
 
 I have several export files that are over a gig.  I do not want to
 preparse the file with perl to make all of the NULL values \N, so what
 can I do?
 
 Thanks.

I really think that you need to check the spam-o-meter for this kind of
query. 
-- 
Brian Millett
Enterprise Consulting Group   Shifts in paradigms
(314) 205-9030   often cause nose bleeds.
[EMAIL PROTECTED]   Greg Glenn


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql+gemini compile errors

[Brian P. Millett]

Hello,
SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc
gcc version 2.95.3 20010315 (release)

I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box.
I get the following error which has me completly confussed:

ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o
Assembler:
tstset.s, line 43 : Illegal mnemonic
tstset.s, line 43 : Syntax error
tstset.s, line 43 : Illegal mnemonic
tstset.s, line 44 : Illegal mnemonic
tstset.s, line 44 : Syntax error
tstset.s, line 45 : Illegal mnemonic
tstset.s, line 45 : Syntax error
tstset.s, line 45 : Illegal mnemonic
tstset.s, line 47 : Illegal mnemonic
tstset.s, line 47 : Syntax error
tstset.s, line 47 : Illegal register: o0
tstset.s, line 47 : Illegal register: o1
tstset.s, line 47 : Illegal mnemonic
tstset.s, line 47 : Illegal mnemonic
tstset.s, line 48 : Syntax error
tstset.s, line 48 : Illegal mnemonic
tstset.s, line 48 : Illegal mnemonic
tstset.s, line 48 : Illegal mnemonic
tstset.s, line 48 : Illegal register: o0
tstset.s, line 48 : Illegal register: o1
tstset.s, line 49 : Syntax error
tstset.s, line 49 : Illegal mnemonic
tstset.s, line 49 : Illegal mnemonic
tstset.s, line 49 : Illegal register: o0
tstset.s, line 50 : Illegal mnemonic
tstset.s, line 50 : Syntax error
tstset.s, line 50 : Illegal register: o1
tstset.s, line 50 : Illegal mnemonic
tstset.s, line 50 : Illegal mnemonic
tstset.s, line 50 : Illegal mnemonic
tstset.s, line 50 : Illegal mnemonic
Too many errors - Goodbye
-rw-r--r--   1 bpm  develop 2252 Jul 16 17:53 tstset.c
-rwxr-xr-x   1 bpm  develop32426 Jul 16 18:00 tstset.cc
-rw-r--r--   1 bpm  develop  897 Aug  1 14:53 tstset.s
rm -f libdb.a
ar cru libdb.a bkcheck.o bkcrashtest.o bkio.o bkiolk.o bkiotop.o bklog.o
bkopen.o bkrec.o bkrepl.o bksubs.o bmapw.o bmbuf.o cx.o cxaux.o
cxblock.o cxcompact.o cxdo.o cxfil.o cxgen.o cxkill.o cxky.o cxkyut.o
cxmove.o cxnxt.o cxtag.o cxundo.o cxvsi.o db.o dbarea.o dbblob.o
dbclose.o dbindex.o dblang.o dblksch.o dbobject.o dbopen.o dbquiet.o
dbrecord.o dbtable.o dbuser.o dbwdog.o geminifromkey.o geminikey.o
keysvc.o keyut.o ky.o kyut.o latctl.o lkmu.o lkrecd.o om.o omundo.o
rec.o recformt.o recget.o recput.o rlai.o rlaiovl.o rlaoff.o rlcl.o
rlmem.o rlnote.o rlrej.o rlrw.o rlset.o rltl.o rm.o rmdoundo.o semadm.o
semmgr.o seqdundo.o seqgen.o shm.o shmatt.o shmcr.o shmdel.o shmpid.o
shmptoq.o shmsiz.o stm.o tm.o tmdoundo.o tstset.o
ar: cannot open tstset.o
No such file or directory
ar: tstset.o not found
gmake[4]: *** [libdb.a] Error 1
gmake[4]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini/db'
gmake[3]: *** [all-recursive] Error 1
gmake[3]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini'
gmake[2]: *** [all-recursive-am] Error 2
gmake[2]: Leaving directory `/opt/src/mysql+gemini-3.23.39/gemini'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/opt/src/mysql+gemini-3.23.39'
gmake: *** [all-recursive-am] Error 2
shaka:


--
Brian Millett
Enterprise Consulting Group Shifts in paradigms
(314) 205-9030 often cause nose bleeds.
[EMAIL PROTECTED]   Greg Glenn

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php