GlogXML Document Hierarchy

Below you can see the XML document hierarchy. The elements have been indented to show the hierarchy and relationship.

<Transmission>
        <TransmissionHeader> . . .
        </TransmissionHeader>
        <TransmissionBody>
        <GLogXMLElement>
            <CSVDataLoad>
                ---CSV Data Load Contents---
            </CSVDataLoad>
        </GLogXMLElement>
        <GLogXMLElement>
            <CSVDataLoad>
                ---CSV Data Load Contents---
            </CSVDataLoad>
        </GLogXMLElement>
        </TransmissionBody>
    </Transmission>

Below is a sample document that would be used to insert some data into the rate tables:

<Transmission>
        <TransmissionHeader>
            <UserName>DBA.ADMIN</UserName>
        </TransmissionHeader>
        <TransmissionBody>
        <GLogXMLElement>
            <CSVDataLoad>
                <CsvCommand>iu</CsvCommand>
                <CsvTableName>X_LANE</CsvTableName>
                <CsvColumnList>X_LANE_GID,X_LANE_XID,SOURCE_POSTAL_CODE,SOURCE_COUNTRY_CODE3_GID,SOURCE_GEO_HIERARCHY_GID,DEST_POSTAL_CODE,DEST_COUNTRY_CODE3_GID,DEST_GEO_HIERARCHY_GID,DOMAIN_NAME</CsvColumnList>
                <CsvRow>"MYDOMAIN.194064","194064","194","USA","USZIP3","064","USA","USZIP3","MYDOMAIN"</CsvRow>      
                <CsvRow>"MYDOMAIN.194065","194065","194","USA","USZIP3","065","USA","USZIP3","MYDOMAIN"</CsvRow>
            </CSVDataLoad>
        </GLogXMLElement>
        </TransmissionBody>
    </Transmission>

The CSV rows are also used to define any EXEC SQL commands as well as the actual rows of data. For example, if the rows contain data for columns which are dates, then an EXEC SQL statement must be present as the first <CsvRow> before any rows containing data. For example: <CsvRow>EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT ='YYYYMMDDHH24MISS'</CsvRow>

Note: the <CSVRow> line text bodies must not contain any reserved XML characters such as < or >. If they do, the characters must be escaped with < and >.