AXCLI Commands

Products

• EUREKA:Strategy

Issue/Introduction

AXCLI (Conman) Commands

Environment

Release:
Component: STGY

Resolution

The following commands are utilized within WebOLAP, however they are not all fully supported within IA Technical Support. Therefore, this document should be considered for Internal Use Only.

Sources and Destinations

0 CLIENT bridge
1 ROUTER rtmain
2 SCHEDULER cmmain
3 BROWSER ?
4 FILE SERVER fsmain
5 SQL SERVER qsmain.exe 
6 OBJECT user defined (afomain.exe, afomain1.exe)
7 PRINT SERVER psmain.exe
8 SQL OBJECT qosybase.exe
9 BKG SERVER bkgmain
10 BKG OBJECT ?
CONMAN Notes

Variables beginning with '#' are considered to be global, otherwise, they are considered to be a local variable.

VARIABLE LOAD, {Global or Local}, Path, FileName
VARIABLE SAVE, {Global or Local}, Path, FileName
VARIABLE GET, {Global or Local}, VarName, {EXPAND or NOEXPAND}
VARIABLE SET, {Global or Local}, VarName, Value, Value, ...
VARIABLE REMOVE, {Global or Local}, VarName
* returns up to 26 variables in a block - no longer supported

VARIABLE RECEIVE, {Global or Local}, {Start, Next, Previous}
VARIABLES /*Handled exactly the same as VARIABLE command */
DATABASE DEFINE, Logical Name, Database Name, Commit
DATABASE DEFREQUEST, Database Name /* used only by the ODK */
DATABASE CONNECT, Database Name
DATABASE {DISCONNECT or CLOSE}, Database Name
DATABASE QUERY, Database Name, target, {SQL or PACKET}, sql
DATABASE QUERY, Database Name, target, {!SQL and PACKET}, path/filename target: 'home', or path/filename to place results
/*droe - is next line true?*/
Note: path/filename must contain a '/' (./filename, for example)
DATABASE {READ or FETCH}, Database Name [, Row | Table]
(Row | Table) - optional fields.
Table will send entire query.
Row sends one row; just like if the 3rd parameter was not present
DATABASE FILTER, DB, PRECISION, SET, [ALL | DEFAULT], precision-value, auto-reset
DATABASE FILTER, DB, PRECISION, SET, COLUMN, NUMBER, number, precision, auto-reset
DATABASE FILTER, DB, PRECISION, SET, COLUMN, NAME, name, precision,
auto-reset
DATABASE FILTER, DB, PRECISION, RESET, [ALL | DEFAULT]
DATABASE FILTER, DB, PRECISION, RESET, COLUMN, NUMBER, #, #, ...
DATABASE FILTER, DB, PRECISION, RESET, COLUMN, NAME, name, name, ...
FILE ACCESS, Path, Mode /* 'r'=read, 'w'=write, 'x'=execute, 'e'=exists */
FILE SAVE, /* NOT CURRENTLY SUPPORTED */
FILE SET FOLDER, Directory name, Mask
FILE SET FOLDER, WITHEXT, Directory name, Mask
FILE REQUEST, /* NOT CURRENTLY SUPPORTED */
The following file commands illustrate the front end interface:

FILE TRANSFER, Path, Filename, type {type = text or binary}
FILE RECEIVE, Path, Filename, type {type = text or binary}
FILE SEND, type, Path, Filename {type = text or binary}
The axcli interface is:
FILE TRANSFER, ServerPath, ServerFile, LocalPath, LocalFile, type
FILE RECEIVE, ServerPath, ServerFile, LocalPath, LocalFile, type
FILE SEND, ServerPath, ServerFile, LocalPath, LocalFile, type
{type=text or binary, Send=> pc to server, Receive=> server to pc}
FILE DELETE, Path, Filename (deletes files or directories)
FILE DELETE WILD, Path, Filename (expands wildcards in Filename)
FILE DIRECTORY CREATE, Path, Filename
FILE DIRECTORY, Path, Mode, Search mask (see filedir.doc)
FILE DIRECTORY, Path, Mode, PACKET, Search mask (see filedir.doc)
FILE COPY, Source Path, Source Filename, Destination Path, Dest. Filename
FILE SET PERMISSION, Path, Filename, permission
FILE GET SIZE, Path, Filename
FILE GET DATE, Path, Filename, format (see filemisc.doc)
FILE SET GROUP, Path, Filename, Groupname
FILE DEFAULT DIR
PRINT FILE, Print Queue, Print Form, Job, File Path, Filename
PRINT FORM /* Display Available Forms */
PRINT QUEUE /* Display Available Print Queues */
LIST QUERY, Browse Name, Target Column, Page Size(# rows @ a time sent), Table, sql string
LIST QUERY, Browse Name, Target Column, Page Size(# rows @ a time sent), Table [,PACKET | SQL], sql string
*this alternate version will send the sql string as is. The original version removes spaces between ',' separated chunks and parses the string to insert control characters
LIST STREAM, Browse Name, Target Column, Page Size(#rows @ time sent), path
LIST INIT (Column List Name == Browse List)
LIST WINDOW, Column Name, {Start, Next, Previous, Marked}, Browse List
LIST UPDATE, Browse List, Column Name
LIST MARK, Browse List, Column Name, List Element, List Element, ...
LIST RESET, COLUMN, Browse List, Column name
LIST RESET, ??? /* not column */, Browse List
LIST REMOVE, Browse List
LIST COLUMNS, Browse List
LIST SIZE, Browse ListId (returns # of currently active rows)
CODE LOAD [, listid [,section]], PACKET, code
CODE EXECUTE [, listid [, section]]
PASSWORD, AccountName, Oldpassword, Newpassword
OBJECT INITIALIZE, Object Definition Id, Object Definition Name [,args...]
(args are for backward compatibility)
OBJECT MESSAGE, Object Definition Id, PACKET, code
OBJECT CLOSE, Object Definition Id
INI LOAD, path, filename
INI SAVE, listId, path, filename
INI SET, listId, section, vName [,value,...] /* main version */
INI SET, listId, section, vName, PACKET [,value,...] /*alt. Version*/
INI GET, listid, section, vName, mode [, NOXLATE]
mode = expand or noexpand
noxlate means \t not translate to tab character
INI DELETE, listid, section, vName
INI COPY, sourceListId, sourceSection, destListId, destSection
INI CREATE
INI SECTIONS, ListId
INI VARIABLES, ListId, Section
INI ISVARIABLE, listId, section
INI ISCODE, listId, section
RC LOCATE, section, entry
GROUP GET
GROUP SET, group
GROUP LIST
DEBUG SET, OBJECT, {ON or OFF}
OPTION GET, ACKCNT
DIMENSION CREATE, Dimension name, BROWSE [,BROWSE ...]
DIMENSION LIST, Dimension name
DIMENSION REMOVE, Dimension name [,FULL]

Examples:

file set folder,axtmp,*.*

Verifies installation with AXCLI:

• Database Define,dbase,demo,yes
• Database Connect,dbase
• Database query,dbase,q6,sql,select * from IAICatalog
• database fetch,dbase
• database close,dbase

Running a report:

• ./axcli <server> <port#> <ID> <password>
• variables load, local, <directory path>, <file name>
• code execute