Data Replication 1

Search:

Type: Posts; User: laura; Keyword(s):

Search: Search took 0.00 seconds.

  1. Specifying Database name when working with DB2 on AS400

    PROBLEM

    After we upgraded AIS from version 4.5 to version 4.8, our interactions stopped to work.

    SOLUTION

    Prior to version 4.8 of AIS there was no need to explicitly specify the database...
  2. QP Average function (AVG)

    As describe in the Attunity Connect User Guide, we have an Average function (AVG) - please refer to the Chapter 69 Attunity SQL Syntax / Functions / Aggregate Functions.

    But our QP AVG function...
  3. ERROR: After we changed the Codepage of our Server we got a Time Out Error

    Description:

    After we changed the Codepage of our Server we got a Timeout Error when trying to connect to our Adapters or when trying to build new ones.

    Solution:

    Steps to recover and switch...
  4. Replies
    1
    Views
    14,083

    CONVERT Function

    Regarding your first question, you need to use Attunity SQL syntax.

    You can find some details about the Attunity SQL functions on the AIS User Guide in the chapter: Attunity SQL Syntax >...
  5. The default value of a DATE field is not returned correctly through Attunity

    Description:

    We created a table in INGRES that contains a field DATE.
    We set his default value to '31/12/2099'.

    When extracting through Attunity Connect from the Server, it extracts...
  6. Replies
    2
    Views
    4,983

    Hi, 1. The error you are getting when...

    Hi,

    1. The error you are getting when attempting to test a Store Procedure in Studio, is a known issue in the version you are using.
    It has been fixed in version 5.0.1.

    To test your Store...
  7. ERROR: When trying to connect to the DB2 data source we are getting SQLConnect error.

    Description:

    When trying to connect to the DB2 data source we are getting SQLConnect error.

    Solution:

    If DB2 CLI driver cannot connect to DB2 (SQLConnect problem), check that ALL ODBC...
  8. DB2 connection test

    How to: test the connection to a DB2 data source

    Description:

    When trying to query tables from a DB2 data source, we are getting DB2 errors.
    How can we test the connection to the DB2 data...
  9. HOW TO: insert/update records in virtual tables

    Description:

    When trying to insert/update records in virtual tables, we are getting maximum usage of I/O.

    Solution:

    Every write operation causes physical I/O on the parent record.
    If for...
  10. Replies
    0
    Views
    5,586

    Non-Latin characters in DB2 version 8

    DESCRIPTION:

    We are trying to execute a Select query on a table from a DB2 data source that contains non-Latin characters but those characters are not displayed correctly – they are returned as an...
  11. HOW TO: Back up metadata of many tables in Mainframe

    DESCRIPTION:

    We need to back up our metadata definitions from AC in Mainframe; The Data source Flat file has more than 2500 tables.

    When executing the export using NAVCMD under TSO we are...
  12. Uninstallation on UNIX

    The article written is about Windows - I will specify this in the title of the article.

    There is no uninstallation on UNIX, you just need to delete the contents of the directory or overwrite the...
  13. Replies
    0
    Views
    3,220

    Uninstallation on Unix

    The article written is about Windows - I will specify this in the title of the article.

    There is no uninstallation on UNIX, you just need to delete the contents of the directory or overwrite the...
  14. Adabas CDC - Some update operations can be returned as DELETE-INSERT operations

    Description

    Some update operations can be returned as DELETE-INSERT couple operations instead of BEFOREIMAGE-UPDATE in the Adabas CDC.

    Explanation

    Sometimes when an update occurs, there is...
  15. ERROR: "The data from the last read was changed, cannot lock"

    Description

    When trying to run a Select in pessimistic locking mode we get the following error: "The data from the last read was changed, cannot lock"

    Meaning

    When the Query Processor is...
  16. Replies
    0
    Views
    3,075

    Alternative binding

    DESCRIPTION:

    When should we create an alternative binding?

    SOLUTION:

    The need for an alternative binding on a client is rare and is only necessary if there are specific properties that need...
  17. ERROR : Attunity server not available after the upgrade of Attunity Connect - Windows

    DESCRIPTION

    We wanted to install a new version of Attunity Connect on a machine.
    We did not uninstall previous version; we just deleted all the folders.
    We did the new installation in a new...
  18. Thread: ADO.NET sample

    by laura
    Replies
    0
    Views
    5,695

    ADO.NET sample

    HOW TO : ADO .NET sample

    DESCRIPTION

    The solution attached is a sample code of an ADO.NET connection.
    The code is written in VB .NET
    It shows how to connect to an RDB data source, and how to...
  19. Replies
    0
    Views
    4,650

    optimization strategy

    HOW TO:choose the optimization strategy used by the query optimizer?

    Description:

    Can I choose the optimization strategy used by the query optimizer?

    Solution:

    You can choose the...
Results 1 to 19 of 19