topic Re: Informix- moving a file in Operating System - HP-UX

Informix- moving a file

Krista A — Thu, 07 Sep 2006 07:40:31 GMT

In informix code, I know how to write output to a file, but how would I append a datestamp to the end of a file, and them move the file to a different folder once the file has been written to by the program?
Thanks!

Re: Informix- moving a file

Jonathan Fife — Thu, 07 Sep 2006 07:50:30 GMT

I would look into the "run" command, which can execute OS commands from within 4GL.

Re: Informix- moving a file

Steve Lewis — Thu, 07 Sep 2006 08:02:48 GMT

The other method is to wrap your informix programs inside a shell script, which renames the output / report files as necessary and moves them wherever you need to. These could also decide on the report filename in the first place.

The other method is to generate the correct filename within the program using TODAY/CURRENT keywords into a variable and start the report to the variable name.

Be aware of security implications of using start report to pipe.

Re: Informix- moving a file

Peter Godron — Thu, 07 Sep 2006 08:06:11 GMT

Krista,
you could use a stored procedure which uses the "SYSTEM" command.
This procedure would then be called via:
EXECUTE PROCEDURE

Further reading (Can not vouch for the source):
http://docs.rinet.ru/InforSmes/index.htm

Re: Informix- moving a file

Krista A — Thu, 07 Sep 2006 08:35:25 GMT

Jonathan_Fife,
So, by using the run command, you mean that I could do something like:

run mv report.out $HOME/report.out.current year to minute

in the 4gl code?

Thanks.

Re: Informix- moving a file

Jonathan Fife — Thu, 07 Sep 2006 08:51:36 GMT

I'd set the command you want to run to a variable, then run that. eg:

DEFINE runcmd char(80),
returncode int

LET runcmd = "mv report.out $HOME/report.out.", current.year to minute
RUN runcmd RETURNING returncode

I don't have an Informix environment to test on at the moment, but that should be the general gist of the syntax.

HTH

Re: Informix- moving a file

Peter Godron — Thu, 07 Sep 2006 09:03:47 GMT

Krista,
for 4gl example of running commands please see:
http://aubit4gl.sourceforge.net/aubit4gldoc/manual/html/4GLcoding.html#Reading/Writing%20Outside%204GL

Section
"C Function Calls and "RUN" statements"

Re: Informix- moving a file

Krista A — Thu, 07 Sep 2006 10:47:53 GMT

Thanks to all for your help!