documentation
.HELP!
LANSA Integrator Documentation
5 37 4 ExcelReadService Examples
LANSA Integrator
previous page
next page
5.37.4 ExcelReadService Examples
Examples are supplied for:
RDML
RDMLX
previous page
start
next page
Menu
Homepage
Table of contents
LANSA Integrator Guide
About this Guide
What is LANSA Integrator?
Who should use this Guide
How to use this Guide
Samples and Examples
Additional Information
Installation and Licensing
What's New in this Version?
1. Introduction to LANSA Integrator
1.1 What is Java Service Manager (JSM)?
1.1.1 Why use Java Service Manager?
1.1.2 What is a JSM Client?
1.1.3 What is JSMDirect?
1.1.4 How does the Java Service Manager work?
1.1.5 How Can I Use Java Service Manager
1.1.6 Can I Create My Own Services?
1.2 What is Integrator Studio?
1.3 What is Integrator User Agent?
2. Java Service Manager Administration
2.1 Java Service Manager Administration for IBM i
2.1.1 File and Folder Security
2.1.2 Network Security
2.1.3 JSM Job Management
2.1.4 Java Service Administration
2.1.4.1 Start Java Service Manager (STRJSM)
Exit Program (IBM i)
2.1.4.2 Clear Java Service Manager (CLRJSM)
2.1.4.3 Optimize Java Service Manager (OPTJSM)
2.1.4.4 Edit Manager Properties (EDTJSMMGR)
2.1.4.5 Edit Service Properties (EDTJSMSRV)
2.1.4.6 Change Default Instance (CHGJSMDFT)
2.1.4.7 Work with Java Service Manager (WRKJSM)
2.1.4.8 Work with Object Links
2.1.4.9 Change JSM Owner (CHGJSMOWN)
2.1.4.10 Change JSM Authority (CHGJSMAUT)
2.1.4.11 Change JSM Primary Group (CHGJSMPGP)
2.1.4.12 Change Attribute (CHGATR)
2.2 Java Service Manager Administration for Windows
2.3 Java Service Manager Administration for Linux
2.4 Java Service Manager Console
2.5 Java Service Manager Refresh
2.6 Java Service Manager Pool Server
2.7 Java Service Manager Additional Servers
2.8 Java Hotspot Technology
2.9 Java Endorsed Standards Override Mechanism
2.10 JSM Startup Class
2.11 Activation Framework
2.12 IBM Java System Properties
2.13 IBM Technology for Java Shared Classes
2.14 LOG4J Logging Services
2.15 Axis Properties
2.16 Axis Message Handler
2.17 SOAP Agent Message Handler
2.18 Apache Axis 1.4 WS-Security and WS-Addressing
2.19 REST Representational State Transfer
2.20 JCE Unlimited Strength Policy Files
3. Java Service Manager Clients
3.1 LANSA RDML Client
3.1.1 JSM_OPEN
3.1.2 JSM_COMMAND
RDML Reserved Commands
RDML Reserved Keywords
RDML Reserved Field Names
3.1.3 JSM_CLOSE
3.1.4 Sample LANSA RDML Client Programs
3.2 LANSA RDMLX Client
3.2.1 JSMX_BEGIN
3.2.2 JSMX_OPEN
3.2.3 JSMX_COMMAND
RDMLX Reserved Commands
RDMLX Reserved Keywords
RDMLX Reserved Field Names
3.2.4 JSMX_CLOSE
3.2.5 JSMX_END
3.2.6 Sample LANSA RDMLX Client Programs
3.3 ILE RPG Client
3.3.1 JSMOPEN
3.3.2 JSMCMD & JSMCMDX
3.3.3 JSMCLOSE
3.3.4 RPG Reserved Commands
3.3.5 RPG Reserved Keywords
3.3.6 RPG Data Structure
3.3.7 Sample ILE RPG Client Programs
3.4 ILE RPGX Client
3.4.1 JSMX_BEGIN
3.4.2 JSMX_OPEN
3.4.3 JSMX_BINDFLD
3.4.4 JSMX_BINDLST
3.4.5 JSMX_COMMAND
RPGX Reserved Commands
RPGX Reserved Keywords
3.4.6 JSMX_CLOSE
3.4.7 JSMX_END
3.4.8 Sample ILE RPGX Client Programs
3.5 C Client Error Messages
3.6 Tracing
3.6.1 Manager Tracing
3.6.2 Client Command Tracing
3.6.3 Service Program Tracing
3.6.4 Service Program Tracing from the Client
3.6.5 How Do I Start Tracing?
3.6.6 Where Do I Find Trace Files?
3.6.7 How Do I Clear Trace Files?
3.7 Command
3.8 Data Areas
3.9 Resource properties - Studio sections
3.10 Resource properties - Internationalization
4. Java Service Manager HTTP Extensions
4.1 JSMDirect
4.1.1 WSDL Option
4.1.2 SERVICE_LOAD
4.1.3 JSMDirect Set up on IBM i
Registering Functions for JSMDirect
Maintaining Registration File DC@W29
JSMDirect Program Logic
4.1.4 JSMDirect Set up on Windows
Registering Functions for JSMDirect
4.1.5 JSMDirect Set up on Linux
Registering Functions for JSMDirect
4.2 JSMProxy
4.2.1 JSMProxy Set up on IBM i
Registering Functions for JSMProxy
JSMProxy Program Logic
4.2.2 JSMProxy Set up on Windows
Registering Functions for JSMProxy
4.2.3 JSMProxy Set up on Linux
Registering Functions for JSMProxy
4.3 JSMAdmin
4.3.1 JSMAdmin Set up on IBM i
4.3.2 JSMAdmin Set up on Windows
4.4 Location of the LANSA System (IBM i)
4.5 Location of the LANSA System (Windows)
4.6 Location of the LANSA System (Linux)
4.7 Exit Programs (IBM i)
4.7.1 JSMDRTEXT
4.7.2 JSMLSAEXT
4.7.3 JSMPXYEXT
4.7.4 JSMADMEXT
4.7.5 JSMCHGUSER
4.7.6 JSMCHGJOB
4.7.7 JSMGETENV
4.7.8 JSMTRCENV
4.7.9 RUNJSMEXT
4.8 Deployment (IBM i)
4.9 Log Files (Windows)
4.10 Apache Directives
4.11 Apache URL Rewriting
4.12 Apache Reverse Proxy
4.13 Apache SSL Support
4.14 Apache Tracing (IBM i)
4.15 SSL Support
4.16 SSL Handshake
4.17 JSM HTTP Server
5. Java Service Manager Services
5.1 Supplementary Information
5.1.1 Mapping Service Name to Java Classes
5.1.2 IANA Encodings
5.1.3 Time Zones
5.1.4 Date and Time Formats
5.1.5 Decimal Formats
5.1.6 Web Browser Content
5.1.7 Carriage Return, Line Feed and New Line
5.1.8 XML Validation
5.1.9 XML Entity Resolver
5.1.10 XML Namespace
5.1.11 XML Transformation
5.1.12 XSL Extension
5.1.13 MQSeries Built-In Functions
MQ_CONN
MQ_DISC
MQ_BEGIN
MQ_CMIT
MQ_BACK
MQ_OPEN
MQ_CLOSE
MQ_GET
MQ_PUT
MQ_DEPTH
5.1.14 MQSeries IBM i Configuration
5.1.15 MQSeries Programs
5.1.16 Data Queue Programs
5.1.17 IBM Toolbox for Java
5.1.18 Common Command Keywords
ARCHIVE
BIND
CONTENT
ENCODING
METHOD
VERSION
XSL
SCHEMA
VALIDATING
FRAGMENT
OUTPUT
NUMBERFORMAT
LOCALE
SVROW
SVROWLIMIT
SVMODE
SVQUOTE
SVHEAD
SVEXCLUDE
SVCOLUMN
SVTABLE
SVLABEL
SEPARATOR
TRIM
TRUNCATE
DOMSET
DOMSETMODEL
DOMSETRESULT
DOMGET
DOMGETRESULT
FILTER
5.2 FTPService
5.2.1 What can I use the FTPService for?
5.2.2 Using the FTPService
5.2.3 FTPService Commands
SERVICE_LOAD
CONNECT
LOGIN
CHGDIR
GETDIR
ASCII
BINARY
NOOP
PUT
GET
SITE
QUOTE
CREATE
DELETE
RENAME
LIST
QUIT
SERVICE_GET
SERVICE_UNLOAD
5.2.4 FTPService Examples
5.3 SFTPService
5.3.1 SERVICE_LOAD
5.3.2 SERVICE_GET
5.3.3 CONNECT
5.3.4 LOGIN
5.3.5 CHGDIR
5.3.6 GETDIR
5.3.7 PUT
5.3.8 GET
5.3.9 CHMOD
5.3.10 DELETE
5.3.11 CREATE
5.3.12 RENAME
5.3.13 LIST
5.3.14 QUIT
5.3.15 SERVICE_UNLOAD
5.4 HTTPService
5.4.1 SERVICE_LOAD
5.4.2 SERVICE_GET
5.4.3 IS
5.4.4 GET
5.4.5 SET
5.4.6 SEND
5.4.7 RECEIVE
5.4.8 BIND
5.4.9 WRITE
5.4.10 Content Handlers
InboundSeparatedValue
InboundXML
InboundXMLBind
InboundJSONBind
InboundNameValue
InboundFile
InboundLocation
InboundStatus
InboundMultiPart
InboundTextHandler
OutboundNameValue
OutboundXML
OutboundXMLBind
OutboundJSONBind
OutboundSeparatedValue
OutboundMultiPart
OutboundFile
5.4.11 SERVICE_UNLOAD
5.4.12 HTTPService Examples
5.5 HTTPInboundJSONBindService
5.5.1 SERVICE_LOAD
5.5.2 SERVICE_GET
5.5.3 BIND
5.5.4 CLOSE
5.5.5 GET
5.5.6 SET
5.5.7 WRITE
5.5.8 SEND
5.5.9 SERVICE_UNLOAD
5.6 HTTPInboundQueryService
5.6.1 SERVICE_LOAD
5.6.2 SERVICE_GET
5.6.3 GET
5.6.4 SET
5.6.5 SEND
5.6.6 SERVICE_UNLOAD
5.7 HTTPInboundXMLService
5.7.1 SERVICE_LOAD
5.7.2 SERVICE_GET
5.7.3 GET
5.7.4 SET
5.7.5 RECEIVE
5.7.6 SEND
5.7.7 SERVICE_UNLOAD
5.8 HTTPInboundXMLBindService
5.8.1 SERVICE_LOAD
5.8.2 SERVICE_GET
5.8.3 BIND
5.8.4 CLOSE
5.8.5 GET
5.8.6 SET
5.8.7 WRITE
5.8.8 SEND
5.8.9 SERVICE_UNLOAD
5.9 HTTPInboundSVService
5.9.1 SERVICE_LOAD
5.9.2 SERVICE_GET
5.9.3 GET
5.9.4 SET
5.9.5 RECEIVE
5.9.6 SEND
5.9.7 SERVICE_UNLOAD
5.10 HTTPOutboundXMLBindService
5.10.1 SERVICE_LOAD
5.10.2 SERVICE_GET
5.10.3 BIND
5.10.4 CLOSE
5.10.5 GET
5.10.6 SET
5.10.7 WRITE
5.10.8 SEND
5.10.9 SERVICE_UNLOAD
5.11 HTTPOutboundJSONBindService
5.11.1 SERVICE_LOAD
5.11.2 SERVICE_GET
5.11.3 BIND
5.11.4 CLOSE
5.11.5 GET
5.11.6 SET
5.11.7 WRITE
5.11.8 SEND
5.11.9 SERVICE_UNLOAD
5.12 SMTPMailService
5.12.1 What can I use the SMTPMailService for?
5.12.2 Using the SMTPMailService
5.12.3 SMTPMailService Commands
SERVICE_LOAD
SET
ADD
SEND
RESET
SERVICE_GET
SERVICE_UNLOAD
5.12.4 SMTPMailService Examples
5.12.5 Troubleshooting
5.13 SMTPMailAttachmentSignatureService
5.13.1 SERVICE_LOAD
5.13.2 SERVICE_GET
5.13.3 SET
5.13.4 RESET
5.13.5 SEND
5.13.6 SERVICE_UNLOAD
5.14 POP3MailService
5.14.1 What can I use the POP3MailService for?
5.14.2 Using the POP3MailService
5.14.3 POP3MailService Commands
SERVICE_LOAD
OPEN
GET
SAVE
READ
DELETE
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.14.4 POP3MailService Examples
5.14.5 Troubleshooting
5.15 SMSService
5.15.1 What can I use the SMSService for?
5.15.2 Using the SMSService
5.15.3 SMSService Properties
5.15.4 SMSService Commands
SERVICE_LOAD
SET
SEND
SERVICE_UNLOAD
5.15.5 SMSService Examples
5.16 XMLFileService
5.16.1 SERVICE_LOAD
5.16.2 SERVICE_GET
5.16.3 READ
5.16.4 WRITE
5.16.5 SEND
5.16.6 RECEIVE
5.16.7 DELETE
5.16.8 RENAME
5.16.9 SET
5.16.10 LIST
5.16.11 SERVICE_UNLOAD
5.17 XMLBindFileService
5.17.1 What can I use the XMLBindFileService for?
5.17.2 Using the XMLBindFileService
5.17.3 XMLBindFileService Properties
5.17.4 XMLBindFileService Commands
SERVICE_LOAD
READ
WRITE
BIND
GET
SET
DELETE
RENAME
LIST
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.17.5 XMLBindFileService Examples
5.18 XMLParserService
5.18.1 SERVICE_LOAD
5.18.2 SERVICE_GET
5.18.3 SET
5.18.4 RESET
5.18.5 LOAD
5.18.6 PARSE
5.18.7 STORE
5.18.8 TRANSFORM
5.18.9 GET
5.18.10 CHECK
5.18.11 FOREACH
5.18.12 NEXT
5.18.13 SERVICE_UNLOAD
5.18.14 XMLParserService Examples
5.19 XMLReaderService
5.19.1 What can I use the XMLReaderService for?
5.19.2 Using the XMLReaderService
5.19.3 XMLReaderService Commands
SERVICE_LOAD
SET
OPEN
NEXT
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.20 XMLWriterService
5.20.1 What can I use the XMLWriterService for?
5.20.2 Using the XMLWriterService
5.20.3 XMLWriterService Commands
SERVICE_LOAD
SET
OPEN
WRITE
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.21 XMLQueryService
5.21.1 What can I use the XMLQueryService for?
5.21.2 Using the XMLQueryService
Typical XMLQueryService Command Usage
Quick Guide to XPath expressions for use with XMLQueryService
5.21.3 XMLQueryService Commands
SERVICE_LOAD
LOAD
SET
RESET
QUERY
SERVICE_GET
SERVICE_UNLOAD
5.21.4 XMLQueryService Example
5.22 SOAPAgentService
5.22.1 SERVICE_LOAD
5.22.2 SERVICE_GET
5.22.3 OPEN
5.22.4 SET
5.22.5 CALL
5.22.6 GET
5.22.7 IS
5.22.8 CLOSE
5.22.9 SERVICE_UNLOAD
5.23 SOAPServerService
5.23.1 SERVICE_LOAD
5.23.2 SERVICE_GET
5.23.3 OPEN
5.23.4 IS
5.23.5 GET
5.23.6 SET
5.23.7 CLOSE
5.23.8 SERVICE_UNLOAD
5.24 XMLQueueService
5.24.1 SERVICE_LOAD
5.24.2 SERVICE_GET
5.24.3 RECEIVE
5.24.4 SEND
5.24.5 ARCHIVE
5.24.6 SERVICE_UNLOAD
5.25 XMLBindQueueService
5.25.1 SERVICE_LOAD
5.25.2 SERVICE_GET
5.25.3 BIND
5.25.4 CLOSE
5.25.5 GET
5.25.6 SET
5.25.7 WRITE
5.25.8 ARCHIVE
5.25.9 SERVICE_UNLOAD
5.26 FileQueueService
5.26.1 SERVICE_LOAD
5.26.2 SERVICE_GET
5.26.3 READ
5.26.4 WRITE
5.26.5 SERVICE_UNLOAD
5.27 OpenLDAPService
5.27.1 What can I use the OpenLDAPService for?
5.27.2 Using the OpenLDAPService
5.27.3 OpenLDAPService Commands
SERVICE_LOAD
BIND
GET
ADD
MODIFY
DELETE
SEARCH
UNBIND
SERVICE_UNLOAD
5.27.4 OpenLDAPService Examples
5.28 JMSFileService
5.28.1 SERVICE_LOAD
5.28.2 SERVICE_GET
5.28.3 CONNECT
5.28.4 SEND
5.28.5 RECEIVE
5.28.6 COMMIT
5.28.7 ROLLBACK
5.28.8 CLOSE
5.28.9 SERVICE_UNLOAD
5.29 JMSXMLBindService
5.29.1 SERVICE_LOAD
5.29.2 SERVICE_GET
5.29.3 CONNECT
5.29.4 SEND
5.29.5 RECEIVE
5.29.6 BIND
5.29.7 GET
5.29.8 SET
5.29.9 WRITE
5.29.10 ARCHIVE
5.29.11 COMMIT
5.29.12 ROLLBACK
5.29.13 CLOSE
5.29.14 SERVICE_UNLOAD
5.30 JSONBindFileService
5.30.1 What can I use the JSONBindFileService for?
5.30.2 Using the JSONBindFileService
5.30.3 JSONBindFileService Properties
5.30.4 JSONBindFileService Commands
SERVICE_LOAD
READ
WRITE
BIND
GET
SET
DELETE
RENAME
LIST
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.31 RFIDataSourceService
5.31.1 SERVICE_LOAD
5.31.2 SERVICE_GET
5.31.3 CREATE
5.31.4 CHECK
5.31.5 DROP
5.31.6 GET
5.31.7 PUT
5.31.8 CLEAR
5.31.9 SEND
5.31.10 SERVICE_UNLOAD
5.31.11 RFIDDataSourceService Examples
5.32 ZipService
5.32.1 What can I use the ZipService for?
5.32.2 Using the ZipService
5.32.3 ZipService Commands
SERVICE_LOAD
CREATE
OPEN
ADD
GET
CLOSE
DELETE
SERVICE_GET
SERVICE_UNLOAD
5.32.4 ZipService Examples
5.33 PDFSpoolFileService
5.33.1 What can I use the PDFSpoolFileService for?
5.33.2 Using the PDFSpoolFileService
5.33.3 PDFSpoolFileService Commands
SERVICE_LOAD
CONNECT
LIST
SET
CREATE
DISCONNECT
DELETE
SERVICE_GET
SERVICE_UNLOAD
5.33.4 PDFSpoolFileService Examples
5.33.5 Troubleshooting
5.34 PDFDocumentService
5.34.1 SERVICE_LOAD
5.34.2 SERVICE_GET
5.34.3 CREATE
5.34.4 ADD
5.34.5 CLOSE
5.34.6 DELETE
5.34.7 SIGN
5.34.8 FILL
5.34.9 READ
5.34.10 SERVICE_UNLOAD
5.34.11 XML Content
Element - document
Element - content
Element - template
Element - color
Element - style
Element - annotation
Element - grid
Element - add
Element - import
Element - import-image
Element - attachment
Element - page
Element - annotation
Element - anchor
Element - text-align
Element - text
Element - input field
Element - input hidden
Element - input password
Element - input checkbox
Element - input radio-group
Element - input radio
Element - input combobox
Element - input submit
Element - table
Element - column
Element - list
Element - item
Element - if
Element - return
Element - line
Element - circle
Element - rectangle
Element - image
Element - barcode
Element - sign-box
Element - date-box
Element - group-box
Element - signature
5.34.12 Example XML Content
5.34.13 Example RDML function
5.35 SVFileService
5.35.1 What can I use the SVFileService for?
5.35.2 Using the SVFileService
5.35.3 SVFileService Commands
SERVICE_LOAD
READ
WRITE
DELETE
RENAME
CONNECT
SET
LIST
COMMIT
ROLLBACK
DISCONNECT
SERVICE_GET
SERVICE_UNLOAD
5.35.4 SVFileService Examples
5.35.5 Troubleshooting
5.36 ExcelService
5.36.1 What can I use the ExcelService for?
5.36.2 Using the ExcelService
5.36.3 ExcelService Commands
SERVICE_LOAD
OPEN
CREATE
SAVE
GET
SET
ADD
REMOVE
READ
WRITE
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.37 ExcelReadService
5.37.1 What can I use the ExcelReadService for?
5.37.2 Using the ExcelReadService
5.37.3 ExcelReadService Commands
SERVICE_LOAD
OPEN
GET
SET
ADD
REMOVE
READ
WRITE
DEFINE
CLOSE
SERVICE_GET
SERVICE_UNLOAD
5.37.4 ExcelReadService Examples
5.37.5 Troubleshooting
5.38 SQLService
5.38.1 What can I use the SQLService for?
5.38.2 Using the SQLService
5.38.3 SQLService Properties
5.38.4 SQLService Commands
SERVICE_LOAD
CONNECT
SET
GET
EXECUTE
READ
COMMIT
ROLLBACK
METADATA
DISCONNECT
SERVICE_UNLOAD
5.38.5 SQLService Examples
5.39 BASE64FileService
5.39.1 SERVICE_LOAD
5.39.2 SERVICE_GET
5.39.3 ENCODE
5.39.4 DECODE
5.39.5 DELETE
5.39.6 RENAME
5.39.7 SET
5.39.8 LIST
5.39.9 SERVICE_UNLOAD
5.40 PGPFileService
5.40.1 SERVICE_LOAD
5.40.2 SERVICE_GET
5.40.3 ENCODE
5.40.4 DECODE
5.40.5 DELETE
5.40.6 RENAME
5.40.7 SET
5.40.8 LIST
5.40.9 SERVICE_UNLOAD
5.41 AxesTerminalService
5.41.1 What can I use the AxesTerminalService for?
5.41.2 Using the AxesTerminalService
5.41.3 AxesTerminalService Scripts
5.41.4 AxesTerminalService Commands
SERVICE_LOAD
CONNECT
DISCONNECT
CAPTURE
EXECUTE
GET
GETBYNAME
GETBYPOS
GETFIELD
LOADSCRIPT
SEND
SETBYNAME
SETBYPOS
SETCURSOR
SERVICE_GET
SERVICE_UNLOAD
5.41.5 AxesTerminalService Examples
5.42 HashService
5.42.1 SERVICE_LOAD
5.42.2 SERVICE_GET
5.42.3 HASH
5.42.4 SERVICE_UNLOAD
6. Create Your Own Services
6.1 Create your Custom Service
6.2 Java Service Manager Interfaces
6.2.1 JSMService Interface
6.2.2 JSMContainer Interface
6.2.3 JSMCommand Interface
6.2.4 JSMClient Interface
6.2.5 JSMResource Interface
6.2.6 JSMStorage Interface
6.2.7 JSMTrace Interface
6.2.8 JSMList Interface
6.2.9 JSMFieldList Interface
6.2.10 JSMField Interface
6.3 Java Service Manager Classes
6.3.1 JSMResponse Class
6.3.1.1 Constructors
6.3.1.2 Getter/Setter Methods
6.3.2 JSMException Class
6.3.2.1 Constructors
6.3.2.2 Other Exception Handling
6.3.3 Miscellaneous Helper Class
6.3.4 Native IBM i Classes
6.3.4.1 DataQueue Class
6.3.4.2 MessageQueue Class
6.3.4.3 UserSpace Class
6.3.5 Utility Classes
6.3.5.1 DataTypeText
6.3.5.2 DataTypePacked
6.3.5.3 DataTypeZoned
7. Integrator Studio
7.1 Get Started with Studio
7.1.1 Studio Main Window
7.1.2 Set Java Compiler and Java Runtime
7.2 Use Studio with Projects
7.3 Use Studio with Servers
7.4 Use Studio with Services
7.5 Use Studio to check sections
7.6 Projects
7.6.1 New Project
7.6.2 Open Project
7.6.3 Publish and Retrieve
7.6.4 Deployment
7.7 Servers
7.7.1 New Server
7.7.2 Open Server
7.8 Services
7.8.1 New Service
7.8.2 Open Service
7.9 Solutions
7.9.1 New Solution
7.10 XML Editor
7.11 XML Viewer
7.12 XMLSchema Viewer
7.13 Trace Viewer
7.14 Text Editor
7.15 SEF Editor
7.16 Property Editor
7.17 XSL Compiler
7.18 PKI Editor
7.18.1 Introduction to Certificates
7.18.2 Create a PKI Project
7.18.3 Create a Certificate Authority
7.18.4 Create a Certificate Request
7.18.5 Create a Certificate Client
7.18.6 PKI Editor Configuration
7.18.7 View Certificate
7.18.8 View Certificate Request
7.18.9 View Remote Host
7.18.10 View Certificates and Keystores using Studio
7.18.11 Keystore Management
7.18.12 PEM Format
7.18.13 IBM i Digital Certificate Manager Interoperability
7.19 CRL Editor
7.19.1 Create a CRL Project
7.19.2 Distribute a CRL File
7.20 SOAP Wizard
7.20.1 Create a SOAP Agent Project
7.20.2 Updating a SOAP Agent Project
7.20.3 Create a SOAP Server Type
7.20.4 Create a SOAP Server Project
7.20.5 SOAP Server Wizard Naming Conventions
Example of a SOAP Server Wizard generated bean class
Example of Apache Axis WSDL2Java generated bean class
7.21 XML Binding Wizard
7.21.1 Sample XML Document
7.21.2 Changing Sample XML Document
7.21.3 Create an XML Binding Project
JavaScript Function Example
7.22 JSON Binding Wizard
7.22.1 Create a JSON Type
7.22.2 Create a JSON Binding Project
7.22.3 Create a JSON HTML Browser Client
7.23 XML Transformation Wizard
7.23.1 Architecture Overview
7.23.2 Sample XML Document
7.23.3 Create an XML Transformation Project
7.23.4 How to use the XML Transformation Wizard
File Menu
Project Tab
Source Tab
Fields Tab
List Tab
Inbound Transformation Tab
Outbound Transformation Tab
Map Fields
Test Transformation
Save Transformation
7.24 Repository Viewer
7.24.1 Create a Repository Project
7.24.2 LANSA Repository Functions
JSMLR01 LANSA Process List
JSMLR02 LANSA Process Information
JSMLR03 LANSA Function Information
JSMLR04 LANSA File List
JSMLR05 LANSA File Information
JSMLR06 LANSA Field List
JSMLR07 LANSA Field Information
JSMLR08 LANSA SOAP Type List
JSMLR09 LANSA SOAP Type Information
JSMLR10 LANSA JSON Type List
JSMLR11 LANSA JSON Type Information
JSMLR0A LANSA Type List
JSMLR0B LANSA Type Information
7.25 Test Editor
7.25.1 Create a Test Project
7.25.2 Test Samples
8. Integrator User Agent
8.1 Introduction to the User Agent
8.2 Getting Started with the User Agent
8.2.1 User Agent Architecture Overview
8.2.2 Prerequisites
8.2.3 Starting the User Agent
Starting From a Command Line or Custom Built Shortcut
User Selects Host & Source Files
User Selects Source File
User Selection Bypassed
Batch Mode With no Manual Selections
8.2.4 Using the User Agent Interactively
8.2.5 Using the User Agent in Batch Mode
8.2.6 Understanding Source Files
8.3 User Agent Main Window
8.3.1 File Menu Commands
Open Host
Close Host
Open Source
Close Source
Send
Response
Exit
8.3.2 Help Menu Commands
Customized Help Entries
User Agent Help
About
8.4 How to Build a Configuration File
8.4.1 File Data Source Directives
8.4.2 SV Data Source Directives
8.4.3 Excel Data Source Directives
8.4.4 Application Directives
8.4.5 Transport Directives
8.4.6 Data Encoding Directives
8.4.7 SOCKS Directives
8.4.8 HTTP Directives
8.4.9 FTP Directives
8.4.10 SFTP Directives
8.4.11 JMS Directives
8.4.12 MQ-Series Directives
8.4.13 Help Directives
8.4.14 Sample Configuration File
8.4.15 User Agent Log
8.4.16 User Agent Workspace
8.5 Build your own Help Files
8.5.1 Linking Your Help Files
8.5.2 Building a Table of Contents
8.6 Create your own User Agent Application
8.6.1 Define your Application
8.6.2 What Needs to be Installed?
8.6.3 User Agent Troubleshooting
9. Remote Function Invocation
9.1 Using the RFIService client class
9.2 Working with the RFIDataSource on the client
9.3 RFI Example
9.4 RFI Example Viewer
10. Troubleshooting
10.1 How to Display the version of Java
10.2 How to Display the version of the Java Service Manager
10.3 Tracing
10.4 STRJSM command not working
10.5 Locating error messages on IBM i
10.6 JSMDirect or JSMProxy not working
10.7 Java Virtual Machine is shut down when you log off from a Windows Server
11. Recommendations
Integrator Tutorials
About the Tutorials
Naming conventions
INT001 - Verify JSM Install & Test
Step 1. Find a specific SET example
Step 2. Execute SET218 FTP example
Step 3. Locating Source Code
Summary
INT002 - Getting Started with Basic JSM Operations
Step 1. Create a Function using Template JSMXSKEL
Step 2. Add a Working list to save Status and Messages to the CHECK_STS Subroutine
Step 3. Create RDML function to display statuses and messages
Step 4. Test iiiFN01 function
Summary
INT003 - Using the FTP Service
Step 1. Build the Basic JSM functions
Step 2. Build the JSM Commands for the FTP Service
Step 3. Test iiiFN03 and iiiFN04 functions
Step 4. Set up file JSMCLTDTA.txt - Optional
Summary
INT004 - Using the LANSA User Agent
Concepts
Step 1. Create a User Agent Solution and edit Host Properties file
Step 2. Create a CSV file with Column Headings to Send
Step 3. Create a Server Function iiiFN05
Step 4. JSMDirect Service Configuration
Step 5. Test iiiFN05 function
Step 6. Ignore the Column Headings
Step 7. Using a CSV without Column Headings
Step 8. Sending an Excel spreadsheet. Optional
Step 9. Invoke User Agent in Batch Mode
Summary
INT005 - Department Inquiry Bindings
Concepts
Step 1. Extend Studio Project iii Training
Step 2. Create Request XML - iiiPRO04_request.xml
Step 3. Create Response XML - iiiPRO04_response.xml
Step 4. Create iiiFN06 Server Inbound (request) binding
Step 5. Create iiiFN06 Server Outbound (response) binding
Step 6. Binding Deployment and Configuration
Summary
INT006 - Department Inquiry Functions
Step 1. Code iiiFN06 Server GET functionality
Step 2. Code iiiFN06 Server SET functionality
Step 3. iiiFN06 Update JSMDirect Configuration Table
Step 4. Create User Agent Host Configuration file
Step 5. Test iiiFN06 function with User Agent
Step 6. Tracing (Optional)
Summary
INT007 - Department List Inquiry
Concepts
Step 1. Create XML iiiPRO05_request.xml
Step 2. Create XML iiiPRO05_response.xml
Step 3. Create iiiFN07 Server inbound (request) binding
Step 4. Create iiiFN07 Server outbound (response) binding
Step 5. Binding Deployment and Configuration
Step 6. Code iiiFN07 Server GET functionality
Step 7. Code iiiFN07 Server Database Logic and SET functionality
Step 8. Update Configuration Table for iiiFN07
Step 9. Create User Agent file for iiiFN07
Step 10. Test iiiFN07 function with User Agent
Summary
INT008 - Department & Employee Server
Concepts
Step 1. Create XML iiiPRO06_request.xml
Step 2. Create XML iiiPRO06_response.xml
Step 3. Create iiiFN08 Server Inbound (request) binding
Step 4. Create iiiFN08 Server Outbound (response) binding
Step 5. Binding Deployment & Configuration
Step 6. Code iiiFN08 Server GET Functionality
Step 7. Code iiiFN08 Server Database Logic and SET functionality
Step 8. Update JSMDirect Configuration Table for iiiFN08
Step 9. Create User Agent Host Configuration file for iiiFN08
Step 10. Test iiiFN08 Server Function with User Agent Client
Summary
INT009 Department & Employee Client (Optional)
Step 1. Create iiiFN09 Client Outbound (request) bindings
Step 2. Create iiiFN09 Client Inbound (response) bindings
Step 3. Binding Deployment and Configuration
Step 4. Code iiiFN10 Client Wrapper Function
Step 5. Code iiiFN09 Client SET functionality
Step 6. Code iiiFN09 Client GET functionality
Step 7. Test iiiFN08 Server with Client functions
Step 8. A Client Visual Form (optional)
Summary
INT010A - SOAP Service - Define Server
Step 1. Create a New project
Step 2. Define custom SOAP Server Types
Step 3. Create a new SOAP Server Solution
Step 4. Create a new SOAP Operation
Step 5. Map Parameters to Program Variables
Step 6. Build the SOAP Server Solution
Step 7. Deploy the SOAP Server Solution
Part A. Publish Files
Part B. Define Service entry
Step 8. Create the SOAP Server Business Logic
Summary
INT010B - SOAP Service - Define Agent
Step 1. Create a New Agent Solution
Step 2. Map Parameters to Program Variables
Step 3. Build the SOAP Agent Solution
Step 4. Deploy the SOAP Agent solution
Step 5. Review required Program to use the SOAP Agent Solution
Step 6. Create form iiiFRM02 - Get Employees using SOAP
Summary
INT010C - SOAP Service - Test
INT011 - Create Excel Document
Step 1. Create RDMLX function iiiFN12
Step 2. Complete function iiiFN12
Step 3. Create RDML function iiiFN13
Summary
INT012 - Create Excel Document with Template and Formatting
Step 1. Create RDMLX function iiiFN14
Step 2. Complete Function iiiFN14
Step 3. Create Function iiiFN15 and test
Step 4. Add DEFINE Command to Format Output
Step 5. Format Start Date Column
Step 6. Insert a Total Salary Formula
Step 7. Password Protect the Document
Summary
INT013 - Create PDF Output using PDFDocumentService
Step 1. Plan the PDF Page Content
Step 2. Create the PDF XML Template
Step 3. Create an RDMLX Function to Produce a Single Page PDF
Step 4. Create Function iiiFN17 - Create PDF Output for Employees
Step 5. Create Function iiiFN18 Test PDF Output for Employees
Summary
INT013 - Appendix A
INT013 - Appendix B
INT013 - Appendix C
Personnel System
Physical Database Map of Personnel System
Sample Data in the Personnel Files
Create RDMLX Templates
JSMXSKEL Source Code
BBJSMXCMD Source Code
Appendix A. Performance and Tuning
Java Service Manager Thread Safety
IBM i - Java Heap Size
IBM i - Pool Size
IBM i Work with JVM Jobs
IBM i - Tuning GC for Java
IBM i - DUMP JVM
IBM i - ANALYZE JVM
IBM i - Network Performance
IBM i - Java License Program
Oracle Java Performance Tuning
JSM Console
Appendix B. Client Application Examples
RDML Examples
Open/Close Example
FTPService Example
HTTP Service Example (XML Inbound)
HTTP Service Example (XML Outbound)
SMTPMailService Example
POP3MailService Example
SMSService Example
XMLBindFileService Example
Step 1: XML Binding Wizard
Step 2: Create some folders and some sample XML documents
Step 3: RDML Function Code
XMLParserService Example 1
XMLParserService 2 (Node traversal)
XMLQueryService Example
MQSeries Built-in Function Example
MQSeries and DataQueue programs Example
OpenLDAPService Example
RFIDataSourceService Example
ZipService Example
PDFSpoolFileService Example
SVFileService Example
ExcelReadService Example
SQLService Examples
Example 1 - Use of the SET PARAMETER(*SQL) command
Example 2 - Use of the SET PARAMETER(*LIST)
Example 3 - READ command receiving the result set from query
JSMDirect Example
RDMLX Examples
FTPService Example
SMTPMailService
POP3MailService Example
SMSService Example
XMLBindFileService
Step 3. RDMLX Form Code
OpenLDAPService Example
ZipService Example
PDFSpoolFileService Example
SVFileService Example
ExcelReadService Example
SQLService Example
aXesTerminalService Example
RPG Examples
FTPService Example
SMTPMailService Example
POP3MailService Example
SMSService Example
ZipService Example
PDFSpoolFileService Example
SVFileService Example
ExcelReadService Example
ILE RPG Client JSM API Example
C Examples
C Client Open/Close Example
C Client Working List Example
Appendix C. EDI Services
EDICatalogService
SERVICE_LOAD
SERVICE_GET
DELETE
RENAME
COPY
MOVE
LIST
SET
GET
READ
SPLIT
BREAK
SPLITBREAK
FORMAT
VALIDATE
SERVICE_UNLOAD
EDIDataSetService
SERVICE_LOAD
SERVICE_GET
GET
READ
WRITE
SERVICE_UNLOAD
EDIDatabaseService
SERVICE_LOAD
SERVICE_GET
CONNECT
SET
SEND
RECEIVE
COMMIT
ROLLBACK
METADATA
DISCONNECT
SERVICE_UNLOAD
EDIInterchangeService
SERVICE_LOAD
SERVICE_GET
BEGIN
ADD
END
WRITE
VALIDATE
GET
SERVICE_UNLOAD
Appendix D. AS2 and AS3 Services
AS2InboundService
SERVICE_LOAD
SERVICE_GET
GET
RECEIVE
SAVE
SEND
SERVICE_UNLOAD
Sample AS2InboundService resources
AS2OutboundService
SERVICE_LOAD
SERVICE_GET
SEND
GET
SERVICE_UNLOAD
Sample AS2OutboundService resources
AS2OutboundReceiptService
SERVICE_LOAD
SERVICE_GET
SEND
GET
SERVICE_UNLOAD
Sample AS2OutboundReceiptService resources
AS2CertificateService
SERVICE_LOAD
SERVICE_GET
CREATE
SERVICE_UNLOAD
AS3FileService
SERVICE_LOAD
SERVICE_GET
READ
GET
RECEIVE
CREATE
WRITE
SERVICE_UNLOAD
Sample AS3FileService resources
Get in touch
Submit feedback about this site to:
[email protected]