documentation.HELP! LANSA Integrator Documentation

C Examples

LANSA Integrator

previous page next page

C Examples

C Client Open/Close Example

C Client Working List Example

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]

© documentation.help. Design: rehmann.co.