Problem description
Command line switches are required to run transformer in batch mode from Scheduler.
Solution Description
From the On-Line Help:
You can use command-line options to do any or all of the following:
1. Run Transformer in batch to create or update PowerCubes,
2. Run Transformer in batch and update the model with new categories generated during the category generation process,
3. Change the current date setting so that relative time calculations in batch cube creation are based on a specific date,
4. Use different preference settings or preference files,
5. Open or delete checkpoint files,
6. Supply database signon information
7. Change the degree of detail for log file messages.
The syntax is
trnsfrmr -<option> <model_file>|<MDL_file>
Notes:
1. The command-line syntax is not case-sensitive for Transformer running under Windows.
2. Command-line options that take arguments cannot contain spaces between the switch and the argument. For example:
trnsfrmr -r 2 july.mdl is not valid, whereas trnsfrmr -r2 july.mdl is valid.
3. You can combine command-line options. For example:
trnsfrmr -n -i sales.py?trnsfrmr -i -t19932 sales.py?
The ? (question mark) in the extension .py? is replaced by the character that is used in your release of Transformer.
4. The space character is used to separate multiple command-line options. Therefore, if any of the arguments contain spaces, you must enclose them in double quotes. For example:
trnsfrmr -n -kfield three=CarlosR/pw462 is not valid, whereas trnsfrmr -n -k”field three=CarlosR/pw462″ is valid.
For more information on the specific command options consult the online help.
These are the available command line switches:
-d (Set Preference)
-f (Set Preference File)
-i (Open Saved Model)
-k (Specify Database Signon)
-n (Run in Batch Mode)
-o (Do Not Create PowerCubes)
-p (Open Checkpoint File)
-r (Log Level Detail)
-s (Save Model)
-t (Set Current Period)
-u (Get Partition Status)
-nologo