-
What is the minimum specification for a Altair SLC workstation?
The minimum specifications required just to run Altair SLC on a Windows machine are very modest. Less than 1G of disk space is required for the installation, and the software has been run on operating systems Windows 7 and later, so any modern PC will be perfectly adequate for most operations. We typically recommend a…
-
What is the difference between LINK and COMMUNICATE?
Altair SLC Link Altair SLC Link is a technology that essentially takes a local script or part of a local script from a local Workbench client and executes it on a remote platform. Any log files, HTML or Listing results, and any datasets created from executing the program remotely are returned to the client through the…
-
What colour names does Altair SLC support?
BLACK, 0x0, 0x0, 0x0 BL, 0x0, 0x0, 0x0 BLUE, 0x0, 0x0, 0xff B, 0x0, 0x0, 0xff BROWN, 0xa0, 0x50, 0x0 BR, 0xa0, 0x50, 0x0 CHARCOAL, 0x4f, 0x4f, 0x4f CREAM, 0xe8, 0xd8, 0x98 CYAN, 0x0, 0xff, 0xff GOLD, 0xff, 0xaa, 0x0 GRAY, 0x80, 0x80, 0x80 GREY, 0x80, 0x80, 0x80 GR, 0x80, 0x80, 0x80 A, 0x80, 0x80, 0x80 GREEN, 0x0, 0xFF, 0x0…
-
What are the license expiring rules related to the log output?
The wpskey/setinit license alert mechanisms conform to the following rules: 1. No license at all, or license cannot be found. Message to the console or standard out: This Altair SLC software is not currently licensed: please apply a license key. 2. License Working in Valid Period Normal log file output continues right up…
-
Unable to start the workbench?
In some problematic situations (e.g. if a user has ran out of disk space) then a file or files in the workspace sub-folder ".metadata" can get corrupted and Workbench may not start up correctly when you restart Altair SLC. By pointing to a different workspace this can help verify that there is something wrong with the old…
-
Trouble reading an XLSX file into Altair Analytics Workbench?
Issue Reading an Excel sheet causes the following error: NOTE: SELECT `Store`,`Year`,`Week`,`UPC`,`Description`,`Reg Retail`,`RET QTY`,`Instore RET`,`Instore Qty`,`Trimester Ret`,`Tri QTY`,`Fyler`,`Flyer Qty`,`TOTAL`,`Total Qty`,`# SAP`,`PLANO`,`CATEGORIES` FROM `STR4857$` _N_=1 _ERROR_=1 Store=. Year=. Week= UPC=.…
-
In a multi-byte char set database environment, is dbmax_text in characters or in bytes?
Parameter dbmax_text is always in bytes. Format widths are also always in bytes.
-
How to use implicit passthrough in PROC SQL?
Implicit passthrough is the default PROC SQL mode in Altair SLC. The Altair SLC (acting as database client) will process the PROC SQL and decide if certain portions of the query can be passed to the database to be processed more efficiently e.g libname mylib odbc ..connection-options..; proc sql; select * from…
-
How to use explicit passthrough in PROC SQL?
Explicit passthrough is typically used when you wish to 1. pass the whole query to the DBMS without any intervention from PROC SQL. 2. pass some DBMS specific SQL syntax to the DBMS that does not form part of the standard PROC SQL syntax. Explicit passthrough is defined using the proc sql CONNECT, DISCONNECT, EXECUTE and…
-
How to remove sequence numbers from mainframe source code?
You are logged into the Mainframe using your terminal emulator software. Using the ISPF editor, select each affected member, and type NUM OFF in the command line, then PF3 to save the edited member. That's it. You don't even need to check to see if the script has got sequence numbers or not – just edit every one in the…