Re: load statement error on 4gl
joe's 4GL program, which ran for years on IDS 9.4 with 4GL 7.32, failed on a LOAD statement after migration to Linux with IDS 11.5. John Fahey suspected an end-of-line difference (LF versus CR/LF) in the transferred data file. joe confirmed the unload data file had a carriage return inside it, which solved it.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Possibly an End-of-line problem (LF vis a vis CR/LF) ???
On Tue, Sep 28, 2010 at 11:08 PM, <jack.parker4@verizon.net> wrote:
> Consider s terminsting "|" in your load file.
>
> j.
>
>
> Sep 29, 2010 03:05:17 AM, joeclhua@gmail.com wrote:
>
> ===========================================
>
> 4gl version : 7.32.uc2
> >ids version: 11.5.uc7
> >redhat : as5
> >
> >$ cat test.4gl> >database test
> >main
> > LOAD FROM '/tmp/temp.dat' DELIMITER "|" insert into tt> > display "status=",status
> >end main
> >$ fglpc test
> >$ fglgo test
> >SQL error number -846.> >Number of values in load file is not equal to number of columns
> >
> >But it run in
> >ids version :ids9.40.uc5
> >4gl : 7.32.uc2
> >aix : 5
> > is OK !
> > Someone help me Please !
> >
> >
> >_______________________________________________
> >Informix-list mailing list
> >Informix-list@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
> >
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
John Fahey
President
Mitchell & McCormick, Inc.
2165 West Park Ct Suite G
Stone Mountain, GA 30087
(770) 465-1511
I doubt that it owing to ids vs 4gl version not matches. That program had running for years on ids 9.4 & 4gl 7.32.uc2 aix box. Recently migrate to linux, ids 11.5 ( newest version) & 4gl 7.32.uc2 ( old version ) Seems that It not allow UNLOAD statemnt in 4GL program .
But is it possible that something about the O.S. change made it such that the way the data (unload) file was transferred to the server might have screwed up the E.O.L. in the file ? On Wed, Sep 29, 2010 at 12:05 AM, joe <joeclhua@gmail.com> wrote: > > I doubt that it owing to ids vs 4gl version not matches. > > That program had running for years on ids 9.4 & 4gl 7.32.uc2 aix box. > > Recently migrate to linux, > ids 11.5 ( newest version) & 4gl 7.32.uc2 ( old version ) > > Seems that It not allow UNLOAD statemnt in 4GL program . > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- John Fahey President Mitchell & McCormick, Inc. 2165 West Park Ct Suite G Stone Mountain, GA 30087 (770) 465-1511
On 9月29日, 下午12時55分, John Fahey <jjfa...@gmail.com> wrote: > But is it possible that something about the O.S. change made it such that > the way the data (unload) file > was transferred to the server might have screwed up the E.O.L. in the file ? > John, Thanks! I got it. the unload data file, has a carriage return inside .