documentation.HELP! LANSA Integrator Documentation

LANSA Integrator Guide

LANSA Integrator

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

next page

Get in touch

Submit feedback about this site to:

• [email protected]