Re: LOAD In 4GL Problems

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 > 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 > >> -----Original Message----- >> From: ART KAGEL, BLOOMBERG/ 731 LEXIN [mailto:KAGEL@bloomberg.net] >> Sent: Wednesday, February 23, 2005 2:39 PM >> To: informix-list@iiug.org >> Subject: Re: LOAD In 4GL Problems >> >> >> 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 >> >> > Art and all , >> > >> > I tried to load rows into a temp table in a 4GL program ,where I am >> passing >> > the filename as an argument . >> > So I used the following syntax. >> > DEFINE g_filename CHAR(10) >> > ..... >> > LOAD FROM g_filename INSERT INTO t_sp ,where g_filename is a char>> variable >> > and t_sp is a Temp table. >> > >> > This did not work , >> > >> > So I tried >> > >> > LET g_stmt = "LOAD FROM ",g_filename, " INSERT INTO t_sp " >> > >> > PREPARE p_curs FROM g_stmt >> > EXECUTE p_curs >> > >> > did not work , >> > >> > the third approach was >> > >> > LET g_stmt = "LOAD FROM ? INSERT INTO t_sp " >> > PREPARE p_curs FROM g_stmt >> > EXECUTE p_curs USING g_filename >> > >> > This also did not work . >> > >> > I can of course hard code the name of the load file ,also I can try >> fglgets >> > to read in the rows one by one to solve the problem. >> > >> > But my question is that is there no way the "load into a temp table" >> > achieved by passing a file as an argument and using prepare or > otherwise >> > >> > >> > TIA. >> > >> > Navdeep >> >> >> >> sending to informix-list > > sending to informix-list > sending to informix-list