Hi Folks.
I am working on pulling report specifications from Cognos, and one of the things I get is a hunk of XML which describes the sql statements. Inside that XML it describes the columns with "columninfo". I'm seeking documentation on the attributes of the "columninfo" tag. For example when it says datatype=45, what exactly does that mean? What other datatypes are there?
sample XML content (edited)
<sql><masterDataSet><datasetInfo...><edgeinfo><rowsetInfo...>
<columnInfo name="PITEM_LOCATION" scale="0" length="12" nullsOk="1" datatype="45" precision="5" summaryLevel="-1"/>
All pointers to documentation are welcome.
-Vik