Utilities 400 Ltd Churchgate House
Churchgate
Bolton
BL1 1HS
01204 388883
Fax: 01204 380076
Utilities 400 Inc. 26 Horseshoe Road
Millbrook, NY 12545
(845) 677 4303
info@uti400.com
RouteOne database featuresGeneral FeaturesSpool File Features
Runtime Parameters
The ability to define parameters which may be changed at runtime. These are in addition to fixed record selections. These are also prompted for if the request is submitted to batch and also available as part of the command for inclusion in a CL program.
Multiple File Selection & Advanced Joins
Data may be selected from a number of either physical or logical files. With the advanced join methodology file links are retained. Once the file links are specified they do not need to be re-specified as they are held in the data dictionary. The links may be specified at the time of the RouteOne definition or in advance using the link option. Virtual fields may be used in the links.
Data Dictionary
The data dictionary holds information relating to files and fields used within RouteOne. File links are also retained. Field text and attributes may be changed.Date fields may be specified. Field attributes may be changed to reflect specified PC formats. Virtual fields may be created to save repetitive result field calculations. These can be used to join files.
Date Conversion & Calculations
The system date is available in any of the standard date formats. Date calculations are possible, date fields may be subtracted from each other to give a number of days. A number of days may be added or subtracted from a date including the system date. Date fields are specified within the data dictionary. Any fields specified in this format will automatically be converted to a true date format. All standard date formats are catered for.
Record Filters
Record selection is available using fixed record selections and/or at run time, see run time parameters.
Conditional Result Fields
As well as standard result field calculations, result fields may be created based on 'If' statements. Multiple levels may be specified.
Download New Data Only
The facility to only download new records which have been added to a file, these can then be appended to the target file. To use this facility the user needs to be able to specify a combination of fields from the selected files,which will make the records unique.
Multi Columns vs. Multi Rows (Pivot the data)
Using the indexed array functionality multiple records may be transferred into columns rather than rows.
