• User's guide
  • API
Search Results for

    Show / Hide Table of Contents
    • Concepts
    • Installation
    • Configuration
      • Overview
      • License
      • Datasources
      • Configuration
      • Plug-Ins
      • Codepages
      • Environment Variables
      • Include files
      • Example
    • Jobs
      • Jobs
      • Include
      • Multi-Threaded Jobs
      • Tracking Jobs
    • Tasks
      • Overview
      • Copy Check
      • Excel
      • Execute
      • File Compare
      • File Copy
      • File Dump
      • File Edit
      • File Format
      • Foreach
      • Generate
      • IMS/DB Data Conversion
      • JCL Submit
      • Listcat
      • Log
      • Powershell
      • Set Environment Variable
      • Sql
      • Stored Procedure Compare
      • Table Compare
      • Table Copy
      • Table Load
      • Table Scan
      • Table Unload
      • User Script
    • Layouts
      • Overview
      • XML Definition
      • COBOL Definition
      • Field data Types
    • Extensibility
      • Extending Ianus
      • Column Comparators
      • Column Converters
      • Record Comparators
      • File Editors
      • User Script
      • Record Layout Match Class
      • Column Layout Match Class
      • User Fields
      • Codepages
      • Resources
    • Usage
      • Command Line
      • Monitors
      • Programmatically
      • Unit Testing
      • Docker
    • Known Issues
    • Disclaimers

    Example Environment File

    This is an example environment file.

    <?xml version="1.0" encoding="utf-8"?>
    <environment>
    <license file="C:\Licenses\%COMPUTERNAME%.license.xml"/>
      <codepage>
        <register>
    	<name>MYENUS037</name>
    	<source>C:\Ianus\Codepages\ENUS037.cpg</source>
        </register>
        <register trace="false">
    	<name>IBM937</name>
    	<source>C:\Ianus\Codepages\IBM937.cpg</source>
           <dbcs>true</dbcs>
    	<encoding>Big5</encoding>
        </register>
      </codepage>
      <datasources>
        <database>
          <id>IANUS</id>
          <type>mssql</type>
          <connectionstring>
             Server=CALABRET4\SQLEXPRESS;Database=IDB;Trusted_Connection=True
          </connectionstring>
        </database>
        <database>
          <id>MOD</id>
          <type>mssql</type>
          <connectionstring>
            Server=CALABRET4\SQLEXPRESS;Database=ATDB;Trusted_Connection=True;
          </connectionstring>
        </database>
        <database>
          <id>ORIG</id>
          <type>mssql</type>
          <connectionstring>
             Server=CALABRET4\SQLEXPRESS;Database=ORIG;Trusted_Connection=True;
          </connectionstring>
        </database>
    
        <database>
          <id>DB2</id>
          <type>db2</type>
          <host>LUW</host>
          <connectionstring>
             SERVER=192.168.1.8:50000;DATABASE=SAMPLE;UID=Administrator;PASSWORD=acme;
          </connectionstring>
        </database>
        
        <database>
          <id>ORA</id>
          <type>oracle</type>
          <connectionstring>
            Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.7)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORA12C.WORLD)));User Id=fab;Password=fab
          </connectionstring>
        </database>
        
        <database>
    	  <id>ORAEBC</id>
    	  <type>oracle</type>
    	  <connectionstring>Data Source=//localhost:5521/xepdb1;User Id=ianus;Password=ianus</connectionstring>
    	  <collate>ebcdic</collate>
    	  <collateclause>NLSSORT(TO_NCHAR({0}), 'NLS_SORT={1}')</collateclause>
    	</database>
    
        <database>
          <id>DB2_LINKED</id>
          <type>db2</type>
          <linked>true</linked>
          <linkedserver>WINDB2</linkedserver>
          <linkedcatalog>SAMPLE</linkedcatalog>
          <host>LUW</host>
          <connectionstring>
               Server=CALABRET5\SQLEXPRESS;Database=IanusTest;Trusted_Connection=True;
          </connectionstring>
        </database>
        <repository>
          <id>REPOASCII</id>
          <type>local</type>
          <path>C:\STORAGE\VSWorkSpaces\Development\Ianus\Ianus\Test\Files\ASCII</path>
          <encoding>ascii</encoding>
          <endian>little</endian>
          <varfmt>microfocus</varfmt>
        </repository>
        <repository>
          <id>REPOEBCDIC</id>
          <type>local</type>
          <path>C:\STORAGE\VSWorkSpaces\Development\Ianus\Ianus\Test\Files\EBCDIC</path>
          <encoding>ebcdic</encoding>
          <endian>big</endian>
          <varfmt>ibm</varfmt>
        </repository>
        <repository>
          <id>REMOTE_EBCDIC</id>
          <type>luw</type>
          <host>192.168.1.6</host>
          <user>ianus</user>
          <password>giano</password>
          <remotepath>/home/ianus/data/ebcdic</remotepath>
          <path>C:\tmp\Files\EBCDIC</path>
          <encoding>ebcdic</encoding>
          <endian>big</endian>
          <varfmt>ibm</varfmt>
        </repository>
        <repository>
          <id>REMOTE_ASCII</id>
          <type>luw</type>
          <host>192.168.1.6</host>
          <user>ianus</user>
          <password>giano</password>
          <remotepath>/home/ianus/data/ascii</remotepath>
          <path>C:\tmp\Files\ASCII</path>
          <encoding>ascii</encoding>
          <endian>big</endian>
          <varfmt>microfocus</varfmt>
        </repository>
        <repository>
    		<id>MARS-ASCII-PGSQL</id>
    		<type>mars</type>
    		<catalog>MARS-PGSQL</catalog>
    		<vsam>MARS-PGSQL</vsam>
    		<schema>vsam</schema>
    		<encoding>ascii</encoding>
    		<endian>big</endian>
    		<varfmt>ibm</varfmt>
    		<zonedsign>ascii</zonedsign>
        </repository>
    
        <region>
    		<id>MFESCLASSIC</id>
    		<name>BGLDEVEL</name>
    		<type>mfesjes</type>
            <version>9</version>
    		<host>localhost</host>
    		<port>10086</port>
    		<mfdsid>Default</mfdsid>
    		<user>SYSAD</user>
    		<password>SYSAD</password>
    		<spool>
    			<path>C:\TMP\SPOOL\MFES</path>
    		</spool>
    	</region>
      </datasources>
    
      <configuration>
        <log>
          <path>C:\STORAGE\VSWorkSpaces\Development\Ianus\Ianus\logs</path>
          <stacktrace>true</stacktrace>
          <systemqueries>true</systemqueries>
          <file>true</file>
          <layout>
            <!--<console></console> -->
            <file>[${level:lowercase=true}] ${message}</file>
          </layout>
        </log>
        <tracking>
          <enabled>true</enabled>
          <datasource>IANUS</datasource>
          <log>true</log>
          <diffs>true</diffs>
        </tracking>
        <datacomparison>
          <!--
          <ignoretrailingnulls>true</ignoretrailingnulls>
          <ignoretrailingspaces>true</ignoretrailingspaces>
          <ignoreinbinaries>true</ignoreinbinaries>
          -->
        </datacomparison>
        <dataconversion>
          <converthighvalues>false</converthighvalues>
        </dataconversion>
        <reports>
          <path>C:\tmp\reports</path>
          <enabled>true</enabled>
        </reports>
      </configuration>
    </environment> 
    
    In This Article
    Back to top Copyright 2021 - Hewlett-Packard Enterprise