All Supplied Activities

This is a list of all the supplied Activities. There is a quick reference list of Activities in Activities by Group.

Activity ID

Description

BASE64_DECODE

Base64 decode the contents of a specified file.

BASE64_ENCODE

Base64 encode the contents of a specified file.

BLANKCONCAT

Concatenates one or more strings, removing trailing blanks and inserting a single blank between each string.

CALCULATE

Perform a simple arithmetic calculation.

CALL_3GL

Calls an RPG, COBOL or other 3GL program on IBM i servers

CALL_FUNCTION

Calls a LANSA function.

CALL_JAVA

Calls a Java program.

CALL_RUBY

Call a Ruby script with optional arguments

CALL_RUBY_EX

Call a method in a Ruby script

CLEARLIST

Clears a variable list.

CLEARVARIABLE

Clears a variable.

COMPOSER_RUN

Run a LANSA Composer Processing Sequence

CONCAT

Concatenates one or more strings, removing trailing blanks from each.

COPY_FILE

Copy file(s) from one directory to another.

COUNTLIST

Counts the entries in a variable list.

DELETE_FILE

Delete file(s) from a directory.

DELETE_SPLF

Deletes an IBM i spool file.

DIRECTORY_LIST

Lists the contents of a directory.

DISCOVER_DOC

Discover the document type for a document file

DISCOVER_EDI

Discover, catalogue and validate EDI document file

DISCOVER_MAP

Discover attributes associated with map

DISCOVER_XML

Discover the root element name of an XML document

DTAQ_CLEAR

Clear a named data queue

DTAQ_RECEIVE

Receive data from a named data queue

DTAQ_SEND

Send data to a named data queue

EDI_SPLIT

Split EDI document file

FIND_TPMAP

Find linked transformation map(s) for a trading partner

FINDINLIST

Find a value in a variable list.

FOR_EACH_CSVROW

Iterate for each row in a CSV file

FOR_EACH_INDEX

Iterate for each index in a range

FOR_EACH_OBJECT

Iterate for each object in an IBM i server library

FOR_EACH_SQL_QUERY

Query database using SQL and iterate the results.

FOR_EACH_TOKENFOR_EACH_TOKEN

Iterate for each token in a string.

FOR_EACH_TXDOCO

Iterate for each pending outbound transaction doc

FOR_EACH_TXDOCT

Iterate for each transaction set (message) registered for a transaction document

FOR_EACH_TXTLIN

Iterate for each line in a text file

FOR_EACH_VAR

Iterate for each processing sequence variable

FTP_COMMANDLIST

Connects to the FTP host specified in the FTP Configuration and then executes FTP commands from a command list file.

FTP_DIRLIST

Connect to the host specified via FTP and then returns a list of files available in the remote directory.

FTP_INBOUND

Retrieves a list of files from a remote host using FTP.

FTP_OUTBOUND

Transfers files from the local machine to a remote host by FTP.

FTP_SCRIPT

Execute an FTP script using the native IBM i FTP client

GET_DTAARA

Read a value from a data area

GET_MAP_PARAMETERS

Gets transformation map parameters information

HASH_FILE

Generate a hash value for a specified file

HTTP_BEGIN_INBOUND

Begin HTTP inbound request handling

HTTP_BEGIN_OUTBOUND

Begin HTTP outbound request handling

HTTP_END

End HTTP request processing

HTTP_MULTIPART_GET

Get inbound multipart component item

HTTP_MULTIPART_SET

Set outbound multipart component item

HTTP_PROPERTY_GET

Get HTTP protocol property value(s)

HTTP_PROPERTY_SET

Set HTTP protocol property value(s)

HTTP_RECEIVE_FILE

Receive a single file HTTP payload

HTTP_RECEIVE_MULTI

Receive HTTP payload as multipart content

HTTP_RECEIVE_NAMEVAL

Receive HTTP payload as name-value pairs

HTTP_RESET

Reset for further HTTP outbound requests

HTTP_RESPOND_FILE

Send file as response to HTTP request

HTTP_RESPOND_MULTI

Send multipart content as response to HTTP request

HTTP_RESPOND_NAMEVAL

Send name-value pairs as response to HTTP request

HTTP_RESPOND_STATUS

Send status as response to HTTP request

HTTP_SEND

Send request to HTTP server

HTTP_SEND_FILE

Send file to HTTP server

HTTP_SEND_MULTI

Send multipart content to HTTP server

HTTP_SEND_NAMEVAL

Send name-value pairs to HTTP server

HTTP_SIMPLE_GET

Retrieves a document from an HTTP server.

HTTP_SIMPLE_INBOUND

Handles an inbound HTTP message and saves it to a specific directory.

HTTP_SIMPLE_POST

Sends data to an HTTP server and/or receives response data from the server..

JSM_BINDSCRIPT

Execute a LANSA Integrator JSM binding script

JSM_RECLAIM

Reclaim LANSA Integrator JSM resources.

JSM_SCRIPT

Execute a LANSA Integrator JSM script

LAST_SPLF

Retrieve identity of the last spooled file created in the current job

LOAD_PSVSET

Loads processing sequence variables from one or more PSV sets into a PSV file.

LOGBOOKMARK

Bookmarks the last or next summary log entry.

LOGCOMPLETION

Creates a processing sequence completion log entry.

LOGLIST

Creates entries in the processing sequence log that contain a variable list's values.

LOGUSERINFO

Creates an impromptu entry in the processing sequence log.

LOGVARIABLE

Creates an entry in the processing sequence log that contains a variable's value.

LOWERCASE

Converts uppercase characters to lowercase.

MAIL_RECEIVE

Retrieves a single email message from the mail server.

MAIL_RECEIVEALL

Retrieves multiple email messages for a user from the mail server.

MAIL_SEND

Sends an email by SMTP.

MOVE_FILE

Move file(s) from one directory to another.

MOVE_SPLF

Moves an IBM i spool file to a specified output queue.

MSG_RECEIVE

Receives a message from a supported message brokering system such as IBM MQ Series.

MSG_SEND

Sends a file through a supported message brokering system such as IBM MQ Series.

MSGQ_RECEIVE

Receive a message from a message queue

MSGQ_SEND

Send a message to a message queue

MUTEX_ACQUIRE

Acquire lock for a conceptual resource identifier

MUTEX_RELEASE

Release lock for a conceptual resource identifier

NEXTNUMBER

Generates the next number in a series.

NOTIFYEVENT

Trigger an event notification

NULL

This activity does nothing but can be useful as a placeholder during the design of your processing sequence.

PARSE_CSV

Parse a string of CSV values

PATHCHECK

Checks whether a file or folder path exists.

PATHMAKE

Constructs a file path from folder path and file name.

PATHSEPREMOVE

Removes the trailing path separator from the specified path, if present

PATHSPLIT

Splits a file path into its constituent components.

PGP_DECODE

PGP decode the contents of a specified file.

PGP_ENCODE

PGP encode the contents of a specified file.

PUT_DTAARA

Write a value to a data area

QUERY_CCSID

Returns the IBM i CCSID for a specified file

RANDOMNUMBER

Generate a pseudo-random number

RENAME_FILE

Renames a file.

SAVE_PSVSET

Saves processing sequence variables and their values to a PSV file.

SLEEP

Suspend processing for a specified time interval

SMB_CONNECT

Connect to a server using the SMB Service.

SMB_COPY

Copy a file using the SMB service

SMB_CREATEDIR

Create a directory on a server using the SMB service

SMB_DELETE

Delete a file using the SMB Service.

SMB_DISCONNECT

Disconnect SMB service

SMB_GET

Get Files from a server using the SMB service.

SMB_LIST

Produce a list of files and directories using the SMB service

SMB_PUT

Put files on to a server using the SMB service

SMB_RENAME

Rename files on a server using the SMB service

SMS_SEND

Send an SMS message to a mobile number using an email service provided by a third-party SMS provider

SORT_LISTS

Sort one or more variable lists in "parallel"

SPLF_LIST

Lists IBM i spool files in an output queue that meet specified selection criteria.

SPLF_TO_PDF

Converts an IBM i spool file to a PDF document.

SPLF_TO_TEXT

Converts an IBM i spool file to a text document

SQL_CALL

Execute an SQL stored procedure

SQL_CALLQRYCSV

Query database using an SQL stored procedure to CSV

SQL_CALLQUERY

Query database using an SQL stored procedure

SQL_COMMIT

Commit a database transaction using SQL

SQL_CONNECT

Connect to database using SQL

SQL_DISCONNECT

Disconnect from database using SQL

SQL_GETJSMHANDLE

Get JSM session handle for SQL connection

SQL_PARAMS

Set parameter values for SQL operation

SQL_PARAMSCSV

Set parameter values for SQL operation from CSV

SQL_QUERY

Query database using SQL

SQL_QUERYTOCSV

Query database using SQL to output CSV file

SQL_ROLLBACK

Rollback a database transaction using SQL

SQL_UPDATE

Update database using SQL

STRINGLEN

Determines the string length, in characters, of a string.

STRINGPOS

Finds the first position of one string in another string.

STRINGPOSLAST

Finds the last position of one string in another string.

STRINGREPLACE

Replaces occurrence(s) of a specified string in the input string.

STRINGREPLACEPOS

Replaces a specified portion of the input string.

SUBSTITUTE

Formats an input string with variable substitution.

SUBSTITUTE_VAR

Formats an input string with variable substitution.

SUBSTRING

Extracts a portion of a string.

SYSTEM_COMMAND

Executes an operating system command.

TEXTFILE_SPLIT

Split a text document file.

TEXT_SUBSTITUTE

Reads a skeleton text file and replaces %%parm.parmeter%% references in the text with the current parameter value and writes the expanded text file.

TEXTFILES_COMBINE

Combines one or more text files into one.

TRANSFORM

Runs a transformation map (used as an alternative to the Transform processing sequence directive where the identifier of the transformation map to run is variable and determined at run-time)

TS_CAPTURE

Capture aXes 5250 terminal session screen image

TS_CONNECT

Connect to aXes 5250 terminal session

TS_DISCONNECT

Disconnect from aXes 5250 terminal session

TS_EXECUTE

Execute an aXes terminal operations script

TS_GET

Get aXes terminal session attributes

TS_GETBYNAME

Get aXes 5250 terminal session value by name

TS_GETBYPOS

Get aXes 5250 terminal session value by position

TS_GETFIELD

Get aXes 5250 terminal session field attributes

TS_SEND

Send data to aXes 5250 terminal session

TS_SETBYNAME

Set aXes 5250 terminal session value by name

TS_SETBYPOS

Set aXes 5250 terminal session value by position

TS_SETCURSOR

Set aXes 5250 terminal session cursor position

TXDOC_ALLOCCTRL

Allocate transaction document control number(s)

TXDOC_EXPORT

Export transaction data to staging files

TXDOC_IMPORT

Import transaction data from staging files

TXDOC_KEYS

Retrieve staging file keys for a pending outbound transaction document

TXDOC_REGISTER

Register transaction document

TXDOC_REGOUTBND

Register pending outbound transaction document

TXDOC_REGOUTEDI

Register pending outbound EDIFACT transaction document

TXDOC_REGOUTX12

Register pending outbound EDI X12 transaction document

TXDOC_STATUS

Update transaction document status

UNIQUEID

Generate a unique identifier.

UPPERCASE

Converts lowercase characters to uppercase.

WAIT_FILESREADY

Cache operations for files waiting for "ready"

WATCH_DIRECTORY

Watch a directory for new or changed files

WATCH_DTAQ

Watch a data queue for new entries

WATCH_MSGQ

Watch a message queue for new messages

WRITE_FILE

Write text to a file.

XML_SPLIT

Split an XML document file.

XML_QUERY

Query value(s) in an XML document file.

XML_VALIDATE

Validate an XML document file.

XSL_TRANSFORM

Executes an XSL transformation.

ZIP_DIRECTORIES

Zips a list of directories and places the contents in a zip archive.

ZIP_FILES

Zips a list of files and places them in a zip archive.

ZIP_LIST

Lists the contents of a zip archive.

ZIP_UNZIP

Lists the contents of a zip archive.