Report Parameters & Filters#
| Report Parameters | |
|---|---|
| Server File | This field provides the name of the file that has been placed on the server in the directory specified in the IMST record LOAD DATA FLDR. |
| Local File | This field allows you to upload a local source file for loading into the database (similar to that of WW Reports in EP). To do this, you must populate the 'Local File' field by selecting the local source file using the file chooser. When selecting a local source file to load, the 'Server File' field MUST be blank. |
| Allow Update | Lexicon value of YES or NO Selecting "NO" disallows the updating of existing records in the database. If there are new records in the load file, the program will still perform an insertion of these records into the destination table. In short, selecting "NO" for Allow Update does not allow you to run the program in trial as it only prevents existing records in the database from being updated. Selecting "YES" will update existing records in the database with changes found in the load file. |
| Allow Insert | Lexicon value of YES or NO By selecting "NO", LMTD will not load any new records into the specified table. By selecting "YES", new records found in the load file will be inserted into the specified table. |
| Exception Level | Lexicon value of 0 to 9. This field allows you to specify the level of trace you wish to see in the report. |
| Interface Code | If using the Table Data Loader logic, leave this blank. If using the DIF Data Loader logic an interface must be specified to load a source file. You can select multiple interfaces if you have to run a particular source file multiple times using different interfaces. If the source file has thousands of records suggested to run the LMTD multiple times selecting only one interface code each time otherwise there may be an impact on performance. |
| File Format | If using the Table Data Loader the field defaults to Character-delimited as the Table Data Loader method only supports Character-delimited files. If using the DIF Data Loader the user may select either Character-delimited or Fixed Position. |
| Destination Table | This field identifies the table that will be inserted or updated. This is a mandatory parameter for the Table Data Loader method. When loading a file using the DIF Data Loader (interface format) the destination table MUST be left BLANK. |
| Delimiter | Indicates the delimiter in the file if it is not a Fixed Format. |
