Difference between revisions of "AS400 Action"
(69 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | [[file:as400_action_header.png]] | |
== AS400 Action Node == | == AS400 Action Node == | ||
The purpose of this Node is to interact with the iSeries / AS400, for which you will need the | The purpose of this Node is to interact with the iSeries / AS400, for which you will need the | ||
− | + | hostname of the as400 (or ip address) along with a valid username and password. | |
The supported actions are: | The supported actions are: | ||
− | + | * [[AS400_Action#Read Data Area|Read Data Area]] | |
+ | * [[AS400_Action#Program Call|Program Call]] | ||
+ | * [[AS400_Action#Program Call Via A Command|Program Call Via A Command]] | ||
+ | * [[AS400_Action#Command|Command]] | ||
+ | * [[AS400_Action#Copy File|Copy File]] | ||
+ | * [[AS400_Action#Check File Exists|Check File Exists]] | ||
− | + | == Read Data Area == | |
− | + | This is perhaps the simplest action available on the AS400 Actions list. | |
− | + | Select "Read Data Area" from the "Type of Request" drop down, | |
− | Member Type | + | Then edit the <b>Library Name</b>,<b>Object Name</b>,<b>Member Name</b> and <b>Member Type</b> to specify the Data Area that is to be read. |
− | + | Finally the <b>Return Column Name</b> specifies the Column Name to be created in the Presence Datatable into which the data value will be put. | |
− | + | As an example the following Read Data Area action:- | |
− | + | [[file:as400_readdataarea.png]] | |
− | + | Results in this Datatable:- | |
− | + | [[file:as400_readdataarearesults.png]] | |
− | + | == Program Call == | |
− | + | This action can be used to call a Program on the AS400, passing into it parameters and receiving returned parameters. | |
− | + | It requires <b>Library</b> and a <b>Program</b> followed by a <b>List of Parameters</b>. | |
− | + | These contain a <b>Param</b> value and if the parameter is to be altered by the program a <b>Return Param</b> name, <b>Type</b> and <b>Length</b>. | |
− | + | We can add or remove extra parameters with the Add and Remove buttons. | |
− | + | [[file:as400_programcall.png]] | |
− | + | Once you've set the parameters, you can go to the test tab and hit 'Test The Action'. | |
− | + | ||
− | + | ||
− | + | The output tab will let you know if anything went wrong, such as the wrong number or type of parameters being passed to the call. | |
− | + | [[file:as400_output.png]] | |
− | + | The results tab will again give you the data returned by the action. | |
− | + | [[file:as400_results.png]] | |
− | == | + | == Program Call Via A Command == |
− | + | This is a simplified version of Program Call, and requires <b>Library</b>, <b>Program</b> and a list of <b>Parameters</b> | |
− | Return Column Name | + | It effectively runs the command:- |
+ | |||
+ | <b>Call LIBRARY/PROGRAM PARM('p1','p2')</b> | ||
+ | |||
+ | As such, it can't return parameter values, or set parameter types. | ||
+ | |||
+ | Once again extra parameters can be added or removed. | ||
+ | |||
+ | == Command == | ||
+ | |||
+ | This runs a basic <b>Command</b>, in the specified <b>Library</b> with the extra parameters specifying each <b>Key</b> and <b>Value</b>. | ||
+ | |||
+ | It effectively runs:- | ||
+ | |||
+ | <b>LIBRARY/COMMAND key1(value1) key2(value2)</b> | ||
+ | |||
+ | Once again extra parameters can be added or removed. | ||
+ | |||
+ | == Copy File == | ||
+ | |||
+ | This action copies a file from a local file <b>From</b> to a location on the as400 <b>To</b>. | ||
+ | |||
+ | The <b>Return Column Name</b> will create a DataTable with this column name set to TRUE or FALSE depending | ||
+ | on the successful action. | ||
+ | |||
+ | It will also throw an error if the command fails. | ||
+ | |||
+ | [[file:as400_filecopy.png]] | ||
+ | |||
+ | Output:- | ||
+ | |||
+ | [[file:as400_filecopyoutput.png]] | ||
+ | |||
+ | == Check File Exists == | ||
+ | |||
+ | This checks whether the file specified by <b>File</b> exists and will return TRUE or FALSE in the | ||
+ | |||
+ | <b>Return Column Name</b>, or throw an exception if the action fails. | ||
+ | |||
+ | [[file:as400_fileexists.png]] | ||
+ | |||
+ | Results:- | ||
+ | |||
+ | [[file:as400_fileexistsresults.png]] | ||
+ | |||
+ | |||
+ | == See Also == | ||
+ | |||
+ | {{Actions}} |
Latest revision as of 12:50, 21 August 2015
Contents
AS400 Action Node
The purpose of this Node is to interact with the iSeries / AS400, for which you will need the hostname of the as400 (or ip address) along with a valid username and password.
The supported actions are:
Read Data Area
This is perhaps the simplest action available on the AS400 Actions list.
Select "Read Data Area" from the "Type of Request" drop down,
Then edit the Library Name,Object Name,Member Name and Member Type to specify the Data Area that is to be read.
Finally the Return Column Name specifies the Column Name to be created in the Presence Datatable into which the data value will be put.
As an example the following Read Data Area action:-
Results in this Datatable:-
Program Call
This action can be used to call a Program on the AS400, passing into it parameters and receiving returned parameters.
It requires Library and a Program followed by a List of Parameters.
These contain a Param value and if the parameter is to be altered by the program a Return Param name, Type and Length.
We can add or remove extra parameters with the Add and Remove buttons.
Once you've set the parameters, you can go to the test tab and hit 'Test The Action'.
The output tab will let you know if anything went wrong, such as the wrong number or type of parameters being passed to the call.
The results tab will again give you the data returned by the action.
Program Call Via A Command
This is a simplified version of Program Call, and requires Library, Program and a list of Parameters
It effectively runs the command:-
Call LIBRARY/PROGRAM PARM('p1','p2')
As such, it can't return parameter values, or set parameter types.
Once again extra parameters can be added or removed.
Command
This runs a basic Command, in the specified Library with the extra parameters specifying each Key and Value.
It effectively runs:-
LIBRARY/COMMAND key1(value1) key2(value2)
Once again extra parameters can be added or removed.
Copy File
This action copies a file from a local file From to a location on the as400 To.
The Return Column Name will create a DataTable with this column name set to TRUE or FALSE depending on the successful action.
It will also throw an error if the command fails.
Output:-
Check File Exists
This checks whether the file specified by File exists and will return TRUE or FALSE in the
Return Column Name, or throw an exception if the action fails.
Results:-
See Also
Task Elements : Action Task Elements : AS400 Action
Send Email | Send SMS | Send Fax | Broadcast Messages |
Read Text File | Read Binary File | Write Text File | Write Binary File | Parse File Action |
Rename File | Copy File | Delete File | Parse File Action |
Generate Bar Code | Read Bar Code |
Dynamic Task Call | Call Native Program | FTP Upload | Scorecard Collector | Create Graph | AS400 Action |
Socket Client Action | Socket Server Action |
JMS Producer | JMS Consumer |