File Executor

In the file executor form you can execute an optional tem files like the ial.tem, replication.tem, etc. You can also execute any custom database script you like. You may include compilation of possible invalid objects after execution of a custom script.

Selected the script you would like to execute.

Actions

1. Select which script you want to execute in the Script to run field (you may browse to find it). If you suspect that your scripts will end up with invalid objects in the database, you could choose to recompile possible invalids afterwards, just check the box. If you just want to recompile invalids without executing any script first, it is possible as well. Click in the Check box and leave Script to run empty.

   Parameter	Description	Alternatives/Suggestion
   Script to run	The script that should be deployed into the database.	NA
   Compile Invalid Objects	If you want to recompile any invalid objects after you have executed a your script.	NA

    

2. Browse, or write directly in the field, where you want the output logs from the execution. If you enter the path to folder that doesn't exist, you will be prompted if you want to create a new folder at that path. Note: This is a top location for the log files, a sub folder named fileexec_<timestamp> will be created under this folder. Off course, you must have write access to this directory.

   Parameter	Description	Alternatives/Suggestion
   Top location of logs	Top location for output logs during the execution	NA

    

3. Fill in information for database connection

   Parameter	Description	Alternatives/Suggestion
   Database host	On which server is the database located	NA
   Database port	Database port	Normally 1521
   Database Service Name	Name of the database service	NA

    

4. Enter the oracle user name and password where the user corresponds to your selected script.

   Parameter	Description	Alternatives/Suggestion
   User	Which Oracle user should be used.	IFSAPP, IFSINFO etc.
   Password	User password

    

5. Click the Test Connect button to verify the username and password at the given database. A popup tells you whether you manage to connect or not. An error message is available if you did not succeed in connecting the database.

   

   You manage to connect to the database.

6. Click Next to continue 

Verify

	When all fields contain values that make the installer to continue, i.e. the script you want to run really exists, the lop location for logs exists and you have write access to this director and it is possible to logon to the database and you have clicked Next the Installer will jump to the next form.
	To close the program click Exit It's not possible to go to the next step if you haven't written values in all fields. Also, the installer prevent you from continue if the database is not up and running and able to connect with the given logon parameters before.