Understanding SQLDATATYPES in XML file

[Former Member]

In my XML file, I am generating data that display I have a certain SQL Data Type. Is there a list of SQL Data Types I can refer to if I am unable to view the table properties of the query?

So my question would be, "What data type is this SQLDataType="-9" ?" and is there a list I can refer to?

<Columns>
            <Column Description="PAYDAY" MaxRange="1" MinRange="0" Name="PAYDAY" SQLDataType="93" SourceColumn="PAYDAY" />
            <Column Description="WK" MaxRange="1" MinRange="0" Name="WK" *SQLDataType*="-9" SourceColumn="WK" />
            <Column Description="YEARNUMERIC" MaxRange="1" MinRange="0" Name="YEARNUMERIC" SQLDataType="-9" SourceColumn="YEARNUMERIC" />
            <Column Description="DEPT" MaxRange="1" MinRange="0" Name="DEPT" SQLDataType="-9" SourceColumn="DEPT" />
            <Column Description="REJQTY" MaxRange="1" MinRange="0" Name="REJQTY" SQLDataType="6" SourceColumn="REJQTY" />
</Columns>

[Former Member · Accepted solution]

Yes there certainly is.

Check http://help.sap.com/saphelp_xmii115/helpdata/en/Business_Logic_Services/illuminator_xml_format.htm

This is from 11.5 help and I don't see a -9 there though.See if you can find something extra in the 12.0 help.

[agentry_src · Accepted solution]

Is your data being generated by a query from a database? If so, what type of database are you using? You may have to investigate that particular database for a list of its own datatypes. But I have to agree with Udayan, I have never heard of a -9 for an sqldatatype.

Mike

[Former Member · Accepted solution]

The sample xml I provided is the result of two queries joining in xacute. One query is an Oracle table and the other is a SQL table. I do not have rights to the Oracle table, therefore I do not know the datatypes as of yesterday.

I now know the datatypes for the Oracle table through the xml file.

<Columns>
            <Column Description="STARTOFWEEK" MaxRange="1" MinRange="0" Name="STARTOFWEEK" SQLDataType="91" SourceColumn="STARTOFWEEK" />
            <Column Description="WK" MaxRange="1" MinRange="0" Name="WK" SQLDataType="12" SourceColumn="WK" />
            <Column Description="YEARNUMERIC" MaxRange="1" MinRange="0" Name="YEARNUMERIC" SQLDataType="12" SourceColumn="YEARNUMERIC" />
            <Column Description="DIVISION" MaxRange="1" MinRange="0" Name="DIVISION" SQLDataType="12" SourceColumn="DIVISION" />
            <Column Description="DEPT" MaxRange="1" MinRange="0" Name="DEPT" SQLDataType="1" SourceColumn="DEPT" />
            <Column Description="PRODUCTGROUPING" MaxRange="1" MinRange="0" Name="PRODUCTGROUPING" SQLDataType="1" SourceColumn="PRODUCTGROUPING" />
            <Column Description="QTY" MaxRange="1" MinRange="0" Name="QTY" SQLDataType="2" SourceColumn="QTY" />
        </Columns>

and my SQL table is

<Columns>
            <Column Description="STARTOFWEEK" MaxRange="1" MinRange="0" Name="STARTOFWEEK" SQLDataType="91" SourceColumn="STARTOFWEEK" />
            <Column Description="WK" MaxRange="1" MinRange="0" Name="WK" SQLDataType="12" SourceColumn="WK" />
            <Column Description="YEARNUMERIC" MaxRange="1" MinRange="0" Name="YEARNUMERIC" SQLDataType="12" SourceColumn="YEARNUMERIC" />
            <Column Description="DIVISION" MaxRange="1" MinRange="0" Name="DIVISION" SQLDataType="12" SourceColumn="DIVISION" />
            <Column Description="DEPT" MaxRange="1" MinRange="0" Name="DEPT" SQLDataType="12" SourceColumn="DEPT" />
            <Column Description="MATTYPE" MaxRange="1" MinRange="0" Name="MATTYPE" SQLDataType="12" SourceColumn="MATTYPE" />
            <Column Description="PRODUCTGROUPING" MaxRange="1" MinRange="0" Name="PRODUCTGROUPING" SQLDataType="1" SourceColumn="PRODUCTGROUPING" />
            <Column Description="QTY" MaxRange="1" MinRange="0" Name="QTY" SQLDataType="2" SourceColumn="QTY" />
        </Columns>

I notice now that my Dept field has a different datatype and may be causing the problem I have. Is it possible that since the join occurs on four fields and one of which is not the same datatype that it throws off the datatype of the results I first submitted in this thread?