This works fine with 4GL 7.32

$ echo "create table t1 (c1 serial, c2 varchar(20))" | dbaccess dk
$ echo -e "0|some text|\n0|more text|" > input.unl

test.4gl:

main
  define inpfile, outfile varchar(20)
  database dk
  let inpfile = "input.unl"
  let outfile = "output.unl"
  load from inpfile insert into t1
  unload to outfile select * from t1
end main

fglpc test.4gl
fglgo test.4go

$ cat output.unl
1|some text|
2|more text|

The fine Art of 4GL programming

Hi,

Try this:
LET g_stmt = 'LOAD FROM "',g_filename clipped, '" INSERT INTO t_sp '

It means using inverted commas (" ") and into it the file name.

BR

Ferronato

How about this:

   LET mover = "ln -s ", g_filename, " tmpname"
   RUN mover

   LOAD FROM tmpname INSERT INTO t_sp

   LET cleanup = "rm tmpname"
   RUN cleanup

  ...

Art S. Kagel

----- Original Message -----
From: Navdeep Virk  <nvirk@msn.com>
At:  2/22 21:36

sending to informix-list

Art & Navdeep-
    Navdeep never said what the behavior of his application was; he
just said "it did not work."  I see no reason that his original syntax
without the prepare statement should not have worked, unless there was
another problem interfering with it.  Navdeep: did the app give you any
error messages?  Did you check the contents of g_filename to make sure
that the name of the load file actually was stored there?  Is the file
in the same directory as the program trying to load it?  Did you make
sure to execute this statement before the LOAD statement:

    LET g_filename = ARG_VAL(1)

If not, the reason it won't work is because there is nothing in
g_filename for the app to load from.  If the load file is not in the
same directory, you will need to supply a complete pathname and user a
bigger variable for g_filename.  Also, assuming that g_filename is a
global, it may be getting reset after the ARG_VAL() loads it.  It may
help to see a bigger section of your original (without the prepare)
code, i.e.: Where the g_filename is loaded, where the temp table is
created, etc.
   
            --EEM

otherwise

sending to informix-list

Everett  ,

You are right , the syntax worked as it is ,However for the life of me I
cannot figure out what kinda of error I was encountering . I kept on getting
a runtime error ,something like syntax error etc . Could be I changed the
code to test too often and kept making different mistakes like not giving
the correct file name as argument  etc.

Thanks to all ,

Navdeep

----- Original Message -----
From: "Everett Mills" <eemills@nationalbeef.com>
To: <informix-list@iiug.org>
Sent: Wednesday, February 23, 2005 4:30 PM
Subject: RE: LOAD In 4GL Problems

sending to informix-list

Why not - what was the error?

The server has no knowledge of either LOAD or UNLOAD; they are
inherently non-preparable and hence non-executable.

They are simulated in I4GL and ISQL and DB-Access (and SQLCMD and
Aubit4GL and ...).

Use:
LET ins = "INSERT INTO tb_sp"
LOAD FROM g_filename ins

(A tb_sp is a bit bigger than a t_sp - otherwise, there's no difference.)

See above.