In this blog post I am listing some handy MOCA commands that can help when performing adhoc support tasks on a RedPrairie server.
| Command |
Description |
Sample Call |
Sample Use Case |
| Manage data via in memory tables |
| File System |
| remove file |
Remove a file on the file system
|
remove file
where filnam = 'xxxx'
|
You can remove a file on the file system |
| sl_cat file |
get contents of a file in a single string
|
sl_cat file
where filename = @@DCSDIR || '.../move_inventory.mcmd'
|
You can read a file in one string and then you could search for text within tha file |
| write output file |
write file on the file system |
write output file
where path = @@LESDIR || '/log'
and filnam = 'temp.log'
and data = 'test'
|
You can write a file on the file system |
| find file |
Look for files on the file system
|
/*
* This simple snippet traverses
* all custom code and lists
* all source code files
*/
find file
where pathname = @@LESDIR || '/src/cmdsrc/*'
|
{
if ( @type = 'D' )
find file
where pathname = @pathname || '/*.m*'
}
|
You can query all commands for a certain text without going at the file system |
| Command Repository |
| list active commands |
This will list all active commands on the server without need of going to the file system.
It will return business logic as well
|
list active commands
where command = "list carrier details"
|
You can query all commands for a certain text without going at the file system |
| list active command arguments |
This will list all command arguments for a command
|
list active command arguments
where command = "move inventory"
|
You can query all command arguments for a certain text without going at the file system |
| list active triggers |
This will list all command triggers for a command
|
list active triggers
where command = "move inventory"
|
You can query all command triggers for a certain text without going at the file system |
| Database. RedPrairie supports multiple databases. These commands make it easy to query data dictionary
without worrying about specific database being used |
| sl_get db_info |
Get important information about the database we are connected to
|
sl_get db_info |
get basic information like database type, name, instance, schema, version, etc. |
| dbtype |
Function to get database type, i.e. ORACLE or SQLSERVER
|
publish data
where x = dbtype()
|
Useful if you every have to write database specific code |
| list user tables |
Get all the tables in the database
|
/*
* Return all authentication
* tables
*/
list user tables
where table_name like 'LES%ATH%'
|
Useful to do adhoc database operations |
| list table columns |
Get all the columns for a table |
list table columns
where table_name = 'les_usr_ath'
|
Useful to do see columns of a table |
| list tables with column |
Get all the tables in data dictionary that have a certain column |
list tables with column
where column_name = 'usr_id'
|
To find affect of changing value of a column or other adhoc support tasks |
| list table indexes |
Get all indexes for a table |
list table indexes
where table_name = 'invlod'
|
To see indexes for a table and then columns within the index in easy to read format as a coma-separated list |
| Groovy Groovy Groovy |
| And best of all is Groovy - you can do almost anything you can imagine. Call web services, perform complex string operations etc. etc. etc. With groovy available there is hardly ever a need to write components in C or Java |
