ODBC supports only forward movement in the query result set and this behavior affects how you create a mapping file. Verify that the value mapping matches the order of the query selections in the mapping file.
Example: Value mapping and query selections for an ODBC mapping file
In this example, the values in the mapping file have been mapped in the same order as the query selection.
<general query="select c.devicename, c.hostname, c.address from Computer c">
<host_name value="{general.devicename}"/>
<default_hostname value="{general.hostname}"/>
<default_address value="{general.address}"/>
</general>
In the query attribute, devicename, hostname, and address are queried in that order, from left to right. The values that follow are also mapped in the same order. A mismatch in the order results in null values in the output XML files.
|
Copyright © 2013 CA.
All rights reserved.
|
|