Easycom .NET
Introduction
Installation
System Requirements
Installing Easycom .NET on a development environment
Activation key
Using Easycom for .NET
Using Easycom in a .NET development environment
Connection pooling
Deployment of an application/assembly based on Easycom for .NET
System.Data.EasycomClient namespace
Introduction
EacConnection
EacConnection Class
EacConnection properties
EacConnection.Database
EacConnection.ConnectionString
EacConnection methods
EacConnection.EacConnection(System.String sConnString)
EacConnection.EacConnection()
EacConnection.Open()
EacConnection.Close()
EacConnection.Dispose()
EacConnection.BeginTransaction
EacConnection.CreateCommand()
EacConnection.RemoteCommand(System.String)
EacConnection.RemoteRtvCommand(System.String)
EacConnection.RemoteRtvCommandGetValue(System.String)
EacTansaction
EacTransaction Class
EacTransaction properties
EacTransaction.Connection
EacTransaction.IsolationLevel
EacTransaction methods
EacTransaction.EacTransaction
EacTransaction.Commit
EacTransaction.Rollback
EacCommand
EacCommand Class
EacCommand properties
EacCommand.CommandText
EacCommand.CommandType
EacCommand.Parameters
EacCommand.Transaction
EacCommand methods
EacCommand.EacCommand
EacCommand.ExecuteNonQuery()
EacCommand.ExecuteReader()
EacCommand.Prepare()
EacCommand.Dispose()
Example 1: call a program
Example 2: call a stored procedure
Example 3: call a stored procedure with input parameter
EacDataReader
EacDataReader Class
Example
Example with EacDataTable
EacParameter
EacParameter Class
EacParameter.EacType
Example
Easycom namespace
Introduction
EasycomType
EasycomType Class
EasycomConnection
EasycomConnection Class
EasycomConnection Constructor
EasycomConnection.ConnectionString Property
EasycomConnection.Open Method
EasycomConnection.OpenFile Method
EasycomConnection.RemoteCommand Method
EasycomConnection.RemoteRtvCommand Method
EasycomConnection.RemoteRtvCommandGetValue Method
EasycomDataSet
EasycomDataSet Class
EasycomDataSet.GetFieldCount Method
EasycomDataSet.GetFieldInformation Method
EasycomDataSet.GetFormatInformation Method
EasycomDataSet.GetPosition Method
EasycomDataSet.GotoPosition Method
EasycomDataSet.GetValue Method
EasycomDataSet.IsDBNull Method
EasycomDataSet.Readxxx Methods
EasycomFile
EasycomFile Class
EasycomFile Constructor
EasycomFile.Readxxx Method
EasycomFile.ReadKey Method
EasycomFile.RecordAppend Method
EasycomFile.RecordDelete Method
EasycomFile.RecordLock Method
EasycomFile.RecordUnLock Method
EasycomFile.RecordUpdate Method
EasycomFile.SetFetchMode Method
EasycomFile.SetValue Method
Example
EacXML
EacXML Class
EacXML Constructor
EacXML.XMLDefine Method
EacXML.XMLLoadDefinition Method
EacXML.XMLBindSrv Method
EacXML.XMLCallProgram Method
EacXML.XMLExecRequest Method
Example 1
Example 2
Example 3
Example 4
Example 5
EasycomException
EasycomException Class
Message Property
NativeCategory Property
ExceptKind Property
EasycomNativeErrorCode Property
EasycomNativeFullMessage Property
EasycomNativeMessage Property
EasycomNativeReturnCode Property
EASYCOM Server
Overview
Installing EASYCOM
System Requirements
Server
Client
Installating EASYCOM server
Principe
Prerequisites - TCP/IP and FTP
Confirm Destination Library Name
Installing the demonstration files
Profile for installation
Installation result
EASYCOM Subsystem
Operations performed on AS/400
Operations performed on PC
Installing an additional EASYCOM server
EASYCOM behavior
EASYCOM server configuration
IPv6 connectivity
Pre-start jobs
IPL process
Default LIBL
Default CCSID, SRTSEQ
Timeout on call program
Protecting access to EASYCOM
Single sign on - EIM
What is EIM ?
EIM installation on IBM i
EIM with Easycom
EIM common problems
Domain names must match.
DES encryption must be enabled on the DC accounts created from keytab.
Error on connect: "Not authorized to access key table".
The time of all machines must be synchronized.
SSL
SSL connection - prerequisites
SSL connection - client configuration
SSL connection - server configuration
SSL connection - client certificate
Create a X.509 registry in EIM, and configure LDAP location (optional)
Create a user certificate
Install the user certificate on your local store
Enable the Easycom server part
EASYCOM jobs on AS/400
The jobs on AS/400
Jobs creation and properties
EASYCOM job priority
EASYCOMD authority
EASYCOM Server configuration commands
CFGEAC (Configure Easycom)
CFGEACTCP (Configure Easycom TCP/IP)
STREACD (EASYCOM service start)
EACINSTALL (Easycom Install)
CFGEACAUTH
CFGEACEIM
EASYCOM Exit Programs
Exit Programs
Easycom startup
Starting Client Job - EACSTART
Prestart job initialization - EACPJINI
SQL initialization - EACSQLINI
Logon and access security
Connection control - EACTCPP01
Logon control - EACLOG002
Security by restriction - EACTCP003
Prestart job control - EACTCP002
'Program Level' Security - EACP003
Easycom mode single signon - EACSSO001
Objects and programs security
EACSOPEN - File open, SQL queries
EACSRCMD - Remote command
EACSCALL - Program Call
EACSIFS - IFS access
Native programs and Data Queues
AS/400 native program description
Migrating procedures and DTAQ from AS/400 to another
Calling a ILE procedure
TroubleShooting
How to diagnose errors
How to contact our Technical Support ?
Important before contacting us ...
Maintenance agreement
AS/400 trace file
EASYCOM trace file activating
Easycom log file
Error codes
TCP/IP Errors
Internal Errors
Error 10060 (3447 in Unix): Connection Timed out
Error 10061 (3425 in Unix): Connection Refused
Error 11001: (Host error 5 in Unix) Host not found
Product licensing
Registration card
Moving licenses to new hardware
What needs to be uninstalled on the old iSeries ?
Copyright
EASYCOM Configuration
The PC tool
Connection parameters
Easycom license key registration
Trace file management
Trace Activation / Deactivation
Trace download
Installation and checking modules versions (DLLs)
Easycom default settings
Easycom security
Easycom.ini
Example : Easycom.ini file
Use example : EacXML class
Develop an application Windows Form
Prerequisites
Project setup
Add Easycom for .NET reference
Open a connection with AS/400
Call AS/400 program
Deploy the developped Windows Form application
Prerequisites
Deployment
Use example: EasycomConnection class and RemoteRtvCommand method
Use example: EacConnection and EacCommand classes
AS/400 Native Programs Description
Other use examples
1) Easycom Sample:
2) Easycom_DataAdapter
3) Easycom_DataQueue
4) Easycom_DataSet
5) Easycom_RemoteCommand
6) Easycom_StoredProcedure
Easycom .NET
