I am using Powerbuilder DB Administrator (connect with IN7 Native driver) to retrieve a SQL statement. There are some starnge conditions, when I type "select * from employee" there will no rows return and the Informix console said I have an error 255. However, when I type "select emp_id from employee" then all rows returned.
I am very confused about this problems, anyone can help me?
I am using Powerbuilder 6.5 Build 444 and Informix 7.1 with AIX 6000.
You have a old version of PowerBuilder that had parsing issues with the PowerBuilder native driver. Check to see if you have the latest updates for PowerBuilder. There were SEVERAL, especially for version 6.x and Informix.