Warehouse Release 3.00.4800

12/17/2004

 The features in the 3.00.4800 release are:

. The dates in a job control database should now all be in the format:  YYYY-MM-DD HH:MI:SS.  Previously there was more than one format used.

. An enhancement was made to return the Warehouse server version to the caller.  This allows DataBridger Studio to display the Warehouse server version to the user.

. When a job is scheduled under job control, the scheduled time is stored in the start time column.  When the job actually starts, the start time is overwritten with the time the job actually started.  In previous releases, the scheduled time was not stored in the job control database.

. The FLATTEN keyword has been added to the OPEN statement when opening an XML file. Using FLATTEN causes Warehouse to place  additional columns in XML records that can be used to link  nested records.  The additional column names are in the format of column_KEYLINK and contain a 10 digit number linking nested records.  Without using FLATTEN records that contain nested records are unavailable in Warehouse.

The syntax to open an XML file is now:

OPEN db-tag XML xml-file-name [MODE=mode][CASEID] [NSTRING] [FLATTEN]

For example, the XML file below contains nested records. Without using FLATTEN, only the CCC data is available with Warehouse because CCC is the only record that does not contain nested records.

        <?xml version="1.0"?>

        <dataroot>

            <aaa>

                <af1>1 AAA Field 1</af1>

                <af2>1 AAA Field 2</af2>

                <bbb>

                  <bf1>1.1 BBB Field 1</bf1>

                  <bf2>1.1 BBB Field 2</bf2>

                    <ccc>

                      <cf1>1.1.1 CCC Field 1</cf1>

                      <cf2>1.1.1 CCC Field 2</cf2>

                    </ccc>

                </bbb>

                <bbb>

                  <bf1>1.2 BBB Field 1</bf1>

                  <bf2>1.2 BBB Field 2</bf2>

                    <ccc>

                      <cf1>1.2.1 CCC Field 1</cf1>

                      <cf2>1.2.1 CCC Field 2</cf2>

                    </ccc>

                </bbb>

            </aaa>

        </dataroot>

When FLATTEN is specified, the DATAROOT, AAA, BBB, and CCC tables all become available with layouts as follows:

    XML DATAROOT layout:

        DATAROOT_KEYLINK    Parent Link to nested records (AAA)

    Table AAA layout:

        DATAROOT_KEYLINK    Child Link back to parent (DATAROOT)

        AF1

        AF2

        AAA_KEYLINK         Parent Link to nested records (BBB)

    Table BBB layout:

        AAA_KEYLINK         Child Link back to parent (BBB)

        BF1

        BF2

        BBB_KEYLINK         Parent Link to nested records (CCC)

    Table CCC layout:

        BBB_KEYLINK         Child Link back to parent (BBB)

        CF1

        CF2

  The data from this file is as follows:

        Record #1: DATAROOT

            DATAROOT_KEYLINK : 0000000001

        Record #2: AAA

            DATAROOT_KEYLINK : 0000000001

            AF1              : 1 AAA Field 1

            AF2              : 1 AAA Field 2

            AAA_KEYLINK      : 0000000002

        Record #3: BBB

            AAA_KEYLINK      : 0000000002

            BF1              : 1.1 BBB Field 1

            BF2              : 1.1 BBB Field 2

            BBB_KEYLINK      : 0000000003

        Record #4: CCC

            BBB_KEYLINK      : 0000000003

            CF1              : 1.1.1 CCC Field 1

            CF2              : 1.1.1 CCC Field 2

        Record #5: BBB

            AAA_KEYLINK      : 0000000002

            BF1              : 1.2 BBB Field 1

            BF2              : 1.2 BBB Field 2

            BBB_KEYLINK      : 0000000005

        Record #6: CCC

            BBB_KEYLINK      : 0000000005

            CF1              : 1.2.1 CCC Field 1

            CF2              : 1.2.1 CCC Field 2

Release 3.00.4800 is available now on all supported platforms.