sctoolsguy
15th November 2006, 16:17
I would like to create a recurring job for Create Sequential Dump of Table.' I want the dump file and error files to have the create date in their respective file names. When using the session I can see that the variable @#$ is somehow used to append the company number to the dump file name. I discovered this by running the dump and tabbing through the fields after the dump completed. Does anyone know how this variable gets populated? Are there other variables like this one available for use as parameters for file names?
mark_h
15th November 2006, 17:54
I have never really done this but I believe any of the UNIX environment variables are available. I have done this with path names, but have never tried to use one in a file name. You can give that a try.
sctoolsguy
15th November 2006, 18:37
Thanks for the input Mark. I will give it a try.
lbencic
15th November 2006, 19:39
You can also look at the predefined variable section of the manual, all of those are available as well:
http://www.baanboard.com/programmers_manual_baanerp_help_misc_predefined_variables
In addition...try compiling in debugger and running to the point where you print your file. Enter the debugger command 'L', this will list all the open variables, including system ones that you can use, along with their value.
Hitesh Shah
18th November 2006, 16:05
U can access unix variables through getenv$ function in a baan script .
bigjack
20th November 2006, 06:23
Alternately you can write an AFS for taking sequential dump and after the dump is taken you can move the dump file into a new file (with the desired name) using function shell(). You can schedule this AFS session to take dump periodically.