[Info-ingres] ingres openAPI and ansidate extractions.

[Martin Bowes]

Hi All,

Using ingres OpenAPI to extract ansidates seems to be a problem.

As an example I'm using the query: SELECT ansidate('now'), char(ansidate('now'))

For each column in the select my program will attempt extraction into a C char[] type. In the first instance we set the extraction type of the first column to be IIAPI_DATE_TYPE and the second column to IIAPI_CHA_TYPE.

This happens...
Error detected in call to OpenAPI on connHandle '2B4B950'!
Status: -1
ErrorCode: 999
getColAPI(): Column 1 is an unsupported type (4), it can only be retrieved to an IIAPI_CHA_TYPE item!

So then I alter the program to use IIAPI_CHA_TYPE as indicated for the first column and rerun the program.
This happens...

Ansidate is: 'FF07011C'
char(ansidate) is: '2016-01-28'

Anyone got any ideas?

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20160128/8fd1b44b/attachment.html>