Warehouse Release 3.02.1220

06/29/2006

 

The features in the 3.02.1220 release are:

 

. Changed CHAR, SIGNED and UNSIGNED types specifiers to allow optional

  "TEXT" designator.  For example, an eight byte character field

  may now be declared as either "CHAR(8)" or "TEXT CHAR(8)".  Future

  examples and documenation should always include the TEXT designator

  and the TEXT types will be made available in DataBridger Studio.

  Example:

 

 

        FORMAT TXTFMT : RECORD

            CUSTNO      : TEXT UNSIGNED(8)

            CUSTNAME    : TEXT CHAR(60)

            CUSTADDR    : TEXT CHAR(60)

            CUSTAMT     : TEXT SIGNED(10,2)

        END

 

 

 

. Added ability of DataBridger Studio to obtain a list of Oracle

  synonyms for display in the tree view.

 

 

. Fixed problem when running scripts using job scheduling.  Updating

  statistics could cause internal data corruption. (Case 8007)

 

 

. Identity columns may now be written to a SQL Server database using

  a the values from the record.  If "(IDENTITY_INSERT)" is specified

  after the target table name in the COPY statement, all columns are

  written to the target table, including any identity columns.  Without

  the IDENTITY_INSERT option, identity columns are not written to the

  target table.  The COPY syntax is:

 

 

    COPY record TO db-tag.table [(IDENTITY_INSERT)] [ copy-options ]

 

 

    Example:

        OPEN SRCDB REMOTE ...

        OPEN TGTDB ODBC MYODBCDB

 

 

        DEFINE TGTORDREC : USING TGTDB.ORDERS

 

 

        READ SRCCUST_R = SRCDB.ORDERS

            // CUSTOMERID is an identity column

            SETVAR TGTORDREC.CUSTOMERID     = SRCCUST_R.CUSTOMERID

 

 

            SETVAR TGTORDREC.NAME           = SRCCUST_R.NAME

            SETVAR TGTORDREC.STATUS         = SRCCUST_R.STATUS

            SETVAR TGTORDREC.TOTAL          = SRCCUST_R.TOTAL

            SETVAR TGTORDREC.LINEITEMCOUNT  = SRCCUST_R.LINEITEMCOUNT

 

 

            COPY TGTORDREC TO TGTDB.ORDERS(IDENTITY_INSERT)

        ENDREAD

 

 

        This example copies ORDERS from the source to the target where

        CUSTOMERID is a SQL Server identity column.  The

        (IDENTITY_INSERT) causes the CUSTOMERID value in the target to

        be same as in the source.  Without (IDENTITY_INSERT), the

        CUSTOMERID would be assigned automatically by SQL Server and

        would probably not contain the same value as the source record.

 

 

Release 3.02.1220 is available now on all supported platforms.