Oninit cdi / Archive
Talk to an expert →

Question Concerning DBLOAD Syntax Error.

Posted in 2008

Topics: Versions, Editions & End-of-Life

Knox, Ernest — — source: IIUG Forums & Mailing Lists

I am trying to load a file with error rows using DBLOAD. I test it on AIX 4.3.3.0 and IDS 7.31 and it works fine. I'm receiving a syntax error when I try to run it on SUN 5.6 and IDS 7.30. Any idea or manual doc differences between the two versions? 307a :/sidcbackup/ernie_knox>ls -l total 46112 -rw-r--r-- 1 informix informix 7880729 Nov 3 17:06 aggr_period_full.unl rw-r--r-- 1 informix informix 73 Nov 3 22:41 recon_aggr_dtl.cmd -rw-r--r-- 1 informix informix 275 Nov 3 22:08 recon_aggr_dtl.out AIX 4.3.3.0 Informix Dynamic Server Version 7.31.UC5 Runs fine with no syntax errors. Sun Microsystems Inc. SunOS 5.6 Informix Dynamic Server Version 7.30.UC3 307a :/sidcbackup/ernie_knox>cat recon_aggr_dtl.out DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3 Copyright (C) Informix Software, Inc., 1984-1998 Software Serial Number ACN#J284372 FILE /sidcbackup/ernie_knox/aggr_period_full.unl DELIMITER '|' 16; Syntax error occurs on statement above. Line 1 Character 6 Thanks, *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com <mailto:eknox@searshc.com> Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " It's always a great day to watch Football - GO LIONS, TIGERS and BEARS! " ***************************************

↪ replying to Knox, Ernest
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

On Mon, Nov 3, 2008 at 9:22 PM, Knox, Ernest <eknox@searshc.com> wrote: > I am trying to load a file with error rows using DBLOAD. I test it on > AIX 4.3.3.0 and IDS 7.31 and it works fine. I'm receiving a syntax > error when I try to run it on SUN 5.6 and IDS 7.30. Any idea or manual > doc differences between the two versions? > > 307a :/sidcbackup/ernie_knox>ls -l > > total 46112 > > -rw-r--r-- 1 informix informix 7880729 Nov 3 17:06 > aggr_period_full.unl > > rw-r--r-- 1 informix informix 73 Nov 3 22:41 recon_aggr_dtl.cmd > > -rw-r--r-- 1 informix informix 275 Nov 3 22:08 recon_aggr_dtl.out > > AIX 4.3.3.0 > > Informix Dynamic Server Version 7.31.UC5 > > Runs fine with no syntax errors. > > Sun Microsystems Inc. SunOS 5.6 > > Informix Dynamic Server Version 7.30.UC3 > > 307a :/sidcbackup/ernie_knox>cat recon_aggr_dtl.out > > DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3 > > Copyright (C) Informix Software, Inc., 1984-1998 > > Software Serial Number ACN#J284372 > > FILE /sidcbackup/ernie_knox/aggr_period_full.unl DELIMITER '|' 16; > > Syntax error occurs on statement above. > > Line 1 Character 6 You don't need telling, I assume, that both 7.30 and 7.31.xCn are old (7.31.xDn is more or less current - but soon to be retired). Since character 6 is the '/', I am suspicious that there's a bug in the 7.30 code. I don't believe the syntax has consciously changed, and the fact that it works on one suggests it should work on the other. Possible workaround: FILE "/sidcbackup/ernie_know/aggr_period_full.unl" DELIMITER '|' 16; If it works in 7.30, the chances are it will work in 7.31 too. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.

Glossary