• 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

    Known Issues

    DB2

    Columnns of type DATE contained in resultsets returned by stored procedures might incorrectly format (day and month swapped).

    To fix the behavior change the Windows system language for non-Unicode programs and make sure it matches the database language:

    Screenshot 1

    Screenshot 2

    PostgreSQL

    Stored Procedure Compare does not support Resultsets comparison with PostgreSQL.

    Stored Procedures comparison steps involving PostgreSQL database on either or both sides of the comparison, simply compare parameters and ignore any resultsets on both sides.

    A possible workaround might be the recording of the stored procedures resultset into temporary tables (maybe using the SQL Task) to be then compared by Table Compare.

    In This Article
    Back to top Copyright 2021 - Hewlett-Packard Enterprise