SET command

Used to specify values for configurable ACL options.

Note

The SET command sets an ACL option for the duration of the ACL session only. This behavior applies whether you use the SET command in the ACL command line or in an ACL script.

Syntax

Syntax

Examples and remarks

SET BEEP value

SET BEEP 2

Specifies the number of beeps to sound when command processing is completed.

The value parameter must be between 1 and 255.

SET CENTURY value

SET CENTURY 40

Specifies the start-of-century year for two-digit years.

The value parameter must be from 0 to 99.

Setting the start-of-century value to 40 means that two-digit years 40 to 99 are interpreted as 1940 to 1999, and two-digit years 00 to 39 are interpreted as 2000 to 2039.

SET CLEAN {ON|OFF}

SET CLEAN ON

When this option is turned on, ACL replaces invalid character data with blanks and invalid numeric data with zeros.

SET DATE <TO> {0|1|2|string}

SET DATE "YYYY/MM/DD"

Specifies how ACL displays dates, and the date portion of datetimes, in views, reports, and exported files.

  • SET DATE 0 sets the date to MM/DD/YYYY format

  • SET DATE 1 sets the date to MM/DD/YY format

  • SET DATE 2 sets the date to DD/MM/YY format

  • SET DATE "<string>" sets the date to the custom format you specify

    When using the SET DATE command to specify custom date formats, you must use 'D' for Day, 'M' for Month, and 'Y' for Year, even if you have specified different date format characters in the Options dialog box. For example:

    SET DATE "DD MMM YYYY"

SET DESIGNATION value

SET DESIGNATION "Produced by ACL Services"

The value parameter is a quoted string that specifies the label to display at the top of each printed page.

SET ECHO {ON|NONE}

SET ECHO NONE

COM Commands and results in scripts excluded from log.

SET ECHO ON

Specify NONE to stop writing commands and results in scripts to the ACL command log. Specify ON to resume logging.

The SET ECHO command applies only to the logging of commands and results in scripts. Commands performed through the user interface or issued from the command line, and any results they produce, are always logged, regardless of how ECHO is set.

You can issue the SET ECHO NONE/ON command in a script or from the command line, but regardless of where you issue the command, it affects only the logging of commands and results in scripts.

Specifying SET ECHO, without any parameter, in the command line displays whether the logging of commands and results in scripts is currently on or off.

SET EXACT {ON|OFF}

SET EXACT ON

OFF is the default setting. If you use the ON parameter, ACL compares character fields or expressions based on their full length, which must be exactly the same in order to match.

SET FILTER <TO>{test|filter_name}

SET FILTER TO ProdNo = "070104347"

SET FILTER TO ProdNoFilter

To create a global filter (view filter), specifies either a logical test, or the name of an existing saved filter.

SET FOLDER folder path

Specifies the ACL project folder in the Overview tab for command output. The default output folder is the folder containing the active table.

This a DOS-style path using the format /foldername/subfoldername, in which the initial slash (/) indicates the root level in the Overview tab. You must specify a full file path.

  • SET FOLDER /Tables/Results sets the output folder to the Results subfolder. If the Results subfolder does not exist, it is created.

  • SET FOLDER / sets the output folder to the root level in the Overview tab

  • SET FOLDER sets the output folder to the default (the folder containing the active table)

The output folder remains as whatever you set it – until you reset it, or close the project. Upon opening the project, the output folder reverts to the default of the active table folder.

SET FORMAT {ON|OFF}

SET FORMAT ON

OFF is the default setting. If you use the ON parameter, ACL automatically displays the current table layout and computed field definitions when you open a new table. The results appear in the command log.

SET FUZZYGROUPSIZE <TO> num

SET FUZZYGROUPSIZE TO 10

Specifies the maximum number of items that can appear in a fuzzy duplicate group in the output results. The num parameter cannot be less than 2 or greater than 100. The default size is 20. The specified size remains in effect for the duration of the ACL session.

SET GRAPH type

SET GRAPH LINE

Specifies the graph type to use for all subsequently generated graphs. The commands run must be compatible with the specified graph type. For example, the BENFORD command cannot produce a PIE2D or PIE3D chart. If an incompatible graph type is specified the default graph type is used (BAR3D).

The type parameter must be one of the following:

  • PIE2D

  • PIE3D

  • BAR2D

  • BAR3D – This is the default graph type.

  • STACKED2D

  • STACKED3D

  • LAYERED

  • LINE

  • BENFORD – Combines 2D bar graph and 2D line graph.

SET HISTORY <TO> value

SET HISTORY TO 50

Specifies the maximum number of table history entries to retain. The value parameter must be between 1 and 100.

SET INDEX <TO> value

SET INDEX TO "CustomerCode.IDX"

Specifies the index to apply to the active table.

SET LEARN <TO> script

SET LEARN TO InventoryRec

Specifies the name of the script file that the Script Recorder uses to record commands.

SET LOG <TO> {file | OFF}

SET LOG TO "analysis.log"

SET LOG OFF

The first command specifies that log entries should be written to a new log, and the second command restores logging to the original ACL command log.

SET LOOP <TO> num

SET LOOP TO 5000

Specifies the number of loops that should be executed by the LOOP command before the command is terminated. The num value is 0 to 32767, where 0 turns off loop testing.

SET MARGIN side <TO> value

SET MARGIN TOP TO 100

Specify LEFT, RIGHT, TOP, or BOTTOM for the side parameter. If you want to change the margin on all sides, you need to specify each margin with a separate SET MARGIN command. Specifying a value of 100 creates a margin of 1 inch.

SET MATH <TO> {FIRST|LAST|MIN|MAX}

SET MATH TO MIN

Select the appropriate option from the following:

  • FIRST uses the number of decimal places of the first operand.

  • LAST uses the number of decimal places of the last operand.

  • MAX uses the maximum number of decimal places of any operand (default).

  • MIN uses the minimum number of decimal places of any operand.

SET MONTHS <TO> string

Specifies the default three-character abbreviations for month names. The string parameter is the list of month abbreviations separated by commas.

SET ORDER <TO> values

Specifies the sort sequence for character fields. The values parameter lists all of the character for the selected sort order.

SET OVERFLOW {ON|OFF}

SET OVERFLOW OFF

The default value is ON. If OFF is specified ACL does not stop processing when an overflow error occurs.

SET PASSWORD num <TO> string

SET PASSWORD 1 TO "password123"

Used to create a password definition, and specify a password value, for unattended script execution.

The num parameter uniquely identifies the password definition and must be a value from 1 to 10. Specify the password value as a quoted string.

SET PERIODS <TO> value <,...n>

SET PERIODS TO "0,30,90,180,10000"

Specifies the default aging periods used by the AGE command.

SET PICTURE format

SET PICTURE "(9,999,999.99)"

Specifies the default formatting for numeric values.

SET READAHEAD TO size

Specifies the size of the data block read. You should only change this setting if you are advised to do so by ACL Support Services.

SET SAFETY {ON|OFF}

SET SAFETY OFF

Specify ON to display a confirmation dialog box when overwriting files, or specify OFF to prevent the dialog box from being displayed.

Specifying SET SAFETY, without any parameter, in the command line displays whether SAFETY is currently on or off.

SET SEPARATORS <TO> values

SET SEPARATORS TO ".,,"

Specifies the default decimal, thousands, and list separators used by ACL. The SET SEPARATORS values must be three valid separator characters in the following order:

  • decimal (period, comma, or space)

  • thousands (period, comma, or space)

  • list (semi-colon, comma, or space)

Among the three separators, the decimal separator must be unique. You must specify all three separators when you use the command. The list separator is used primarily to separate function parameters.

SET SESSION session_name

SET SESSION "Analysis"

The session_name parameter specifies the name of the session to create in the ACL command log.

SET SORTMEMORY num

SET SORTMEMORY 800

Specifies the maximum amount of memory allocated for sorting and indexing processes. The num parameter must be a value from 0 to 2000 megabytes (MB), to be entered in 20MB increments. If the sort memory is set to 0, ACL uses the memory currently available.

SET SUPPRESSTIME {ON|OFF}

SET SUPPRESSTIME ON

Only for use when defining an ACL table that uses an ODBC data source (IMPORT ODBC command), or direct database access (DEFINE TABLE DB command).

OFF is the default setting. If you use the ON parameter, when defining the table ACL suppresses the time portion of datetime values. For example, 20141231 235959 is read, displayed in views, and subsequently processed as 20141231.

Including this command in a pre-datetime ACL script (pre v.10.0) that assumes the time portion of datetime data will be truncated allows the script to run in the datetime-enabled version of ACL.

ACL suppresses the time portion by using only the date portion of the datetime format. The time data is still present in the .fil file or the database table. If required, you can redefine the field or define a new field to include the time portion of the data.

If SET SUPPRESSTIME = OFF, ACL tables defined using ODBC or direct database access include full datetime values.

You can issue the SET SUPPRESSTIME ON/OFF command in a script or from the command line.

Specifying SET SUPPRESSTIME, without any parameter, in the command line displays whether the suppression of the time portion of datetime data is currently on or off.

SET SUPPRESSXML {ON|OFF}

SET SUPPRESSXML ON

OFF is the default setting. Specifies that command output is in plain text rather than formatted text.

SET TEST {ON|OFF}

SET TEST ON

Specifies whether the results of IF, WHILE, FOR, and NEXT tests associated with GROUP commands should be recorded in the log.

SET TIME <TO> string

SET TIME "hh:mm:ss PM"

Specifies how ACL displays the time portion of datetimes, and standalone time values, in views, reports, and exported files.

When using the SET TIME command to specify time formats, you must use 'h' for Hour, 'm' for Minute, and 's' for Second, even if you have specified different time format characters in the Options dialog box. For example:

SET TIME TO "hh:mm"

SET UTCZONE {ON|OFF}

SET UTCZONE OFF

ON is the default setting.

When UTCZONE is ON, ACL changes the display of local times with a UTC offset to the UTC equivalent of the local time. (UTC is Coordinated Universal Time, the time at zero degrees longitude.)

When UTCZONE is OFF, ACL displays local times with a UTC offset without converting them to UTC.

For example:

  • 01 Jan 2015 04:59:59 (SET UTCZONE ON)

  • 31 Dec 2014 23:59:59-05:00 (SET UTCZONE OFF)

Conversion of local time to UTC is for display purposes only, and does not affect the source data. You can change back and forth between the two different display modes whenever you want to.

SET VERIFY {ON|OFF|BLANK}

SET VERIFY ON

When ON is specified, ACL automatically checks whether the contents of a data field correspond to the field's data type in the table layout whenever a table is opened. When BLANK is specified, ACL replaces invalid character data with blanks and invalid numeric data with zeros, in addition to the verification described for the ON parameter.

SET WIDTH <TO> num

SET WIDTH TO 20

Specifies the default display width for numeric computed fields or ad hoc numeric expressions when ACL cannot determine the maximum width.



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback