Datasources

The datasources element contains all the datasources defined in the environment.

The following elements configure the data sources available in the environment:

Element Purpose
database Defines a database data source
repository Defines a file repository
region Defines a CICS or JES region

Database

The database element defines a database datasource. The following elements configure the database data source:

Element Type Purpose
id string The unique identifier of the data source
type string The database type. Refer to Database type for detailed description.
host string Only for DB2 database types, the host system where the database runs. Refer to DB2 platform for detailed description.
connectionstring string The ADO connection string for the database. For the string format, please refer to the .NET connector documentation of the selected database.
collate string Sets a default collating sequence. If no collate element is defined, no collating sequence is defined as default.
bitdatacodepage string Defines the datasource default codepage to translate the binary data (i.e. CHAR FOR BIT DATA) from EBCDIC to ASCII. If no bitdatacodepage element is defined, no codepage is defined as default.
charasbinary bool If set to true and the database encoding is EBCDIC, all CHAR/VARCHAR columns are treated as binary (i.e. CHAR FOR BIT DATA) and therefore converted according to the specified codepage (when specified). Default is false.
linked bool For DB2 connections only, indicates whether the connection is performed over a SQL Server Linked Server. Default is false.
linkedserver string Name of the linked server, as defined in SQL Server
linkedcatalog string Name of the linked catalog, as defined in SQL Server. If the catalog is "default", just leave it empty.
trimcolumnandparametersnames bool Instructs Ianus to ignore leading or trailing blanks in column and parameter names. Default is false.
collateclause string Provides a custom format for the collate format. Variables {0} and {1} are interpolated respectively with the column name and collate name.
layouts element Defines the data configuration for the column based layouts

Database Type

Value Description
mssql Microsoft SQL Server
db2 IBM DB2
oracle Oracle database
pgsql PostreSQL

DB2 Platform

Value Description
luw Linux, UNIX or Windows
zos z/OS

The Layout element

The layout element defines the data configuration defaults for the columns whihc conversion/comparison depends on a layout

The following elements defines the configuration:

Element Type Purpose
encoding string Text encoding (ebcdic/ascii). The default is ebcdic for DB2 on z/OS, ascii for all other RDBMS.
sign string SIGN mode (ascii or ebcdic) of the ZONED fields. Default is ebcdic.
endian string Endianness of integer fields. Default is big.
codepage string Codepage for EBCDIC/ASCII CONVERSION. Default is ENUS037.

Repository

The repository element defines a file repository data source. The following elements configure the file repository data source:

Element Type Purpose
id string Unique identifier of the data source.
type string Repository type. Refer to Repository type for detailed description.
path string Local path where files are located (local repositories) or staged (remote repositories).
encoding string Default encoding of the files stored in the repository: ascii (default) or ebcdic.
codepage string Default codepage to be used for the EBCDIC to ASCII conversion, if needed, of the of the files stored in the repository. For possible values see the supported codepages. The default is ENUS037.
endian string Default endianness of integer fields in the files stored in the repository: little or big (default).
varfmt string Default variable length record format of the files stored in the repository. Refer to Variable Record Formats.
host string Hostname or IP address of the remote server.
port integer Port number of the FTP service. Default is 21.
user string Username to be used to connect the FTP services.
password string Password to be used to connect the FTP services.
remotepath string Remote path for files. For LUW repositories only. Default is empty string.
cached bool Cached mode. Default is false.
zonedsign string Defines the SIGN mode (ascii or ebcdic) of the ZONED fields. Default is ebcdic.
catalog string (MARS only) catalog database connection string (must set default schema)
vsam string (MARS only) VSAM database connection string
schema string (MARS only) VSAM tables schema name

Repository Type

Value Description
local Local (default)
luw Remote on Linux, UNIX or Windows
zos Remote on z/OS
mars Local MARS repository

Variable Record Formats

Name File format File Header Record header Record Padding
ibm Sequential No 4 bytes RDW No
microfocus Sequential 128 bytes (Micro Focus compliant) 2 or 4 bytes Yes

Cached mode

Remote repositories can be configured as cached (element cached). When cached, input files are downloaded from the remote FTP at their first usage and left staged in the local path.

The next time the same file is used as input, the local copy is used directly.

This can be useful when iterating tests on data coming for remote systems, to avoid to re-transfer the files every time.

The cache can be refreshed:

  • disabling cache by starting ianus with option -c
  • forcing the cache refresh in the file definition of the task, settting attribute cache to false

Region

The region element defines a region end-point. The following elements configure the region data source:

Element Type Purpose
id string The unique identifier of the region.
type string The region type. Refer to Region type for detailed description.
name string The region name (as defined in the host region configuration).
host string Hostname (or IP address) of the system where the region runs.
port integer Port number where the region listener responds.
user string Username of the user submitting the job.
password string Password of the user submitting the job.
host string Hostname or IP address of the remote server
mfdsid string For MFES only, the MFDS identifier as specified in ESCWA (default: Default)
version integer For MFES only, the MFES major version number (default: 9)
jesinterfacelevel integer For IBM JES only, the FTP JES interface level: 1 or 2 (default).
spool string Set of spool files management information.
path string Local path for spool storage.
sync bool If true, all submit operations towards teh region are serialized. Default is false.

Region Type

Value Description
ibmjes IBM z/OS JES2 subsystem. The JCL submission process relies on z/OS FTP/JES interface mechanisms (FTP protocol). The connection details refer to the z/OS FTP server.
mfesjes Micro Focus Enterprise Server JES region (native). The JCL submission process relies on Micro Focus ESCWA REST API. The connection details refer to ESCWA.