Dbaccess showing field headers when no rows found

[Monte Heeren]

Just upgraded Informix form 9.3 to 9.4.
Dbaccess is displaying field headers when no rows were found for a query.

Select * from hr_empmstr
where fname = "abc"

This query will return all field names and then display "no rows found".
Under 9.3 Informix, the display would just show "no rows found". Is there a way to stop displaying field headers when no rows were found?

Monte Heeren

[Steven E. Protter]

Shalom Monte,

We had the same help desk call this morning at work and I caught it. I didn't have a clue. The answer was the Informix db was corrupt and we had to restore from backup.

That probably trashed the upgrade.

Sorry.

SEP

[Steve Lewis · Accepted solution]

Yes, this is what you get in 9.40. We have exactly the same. Thank goodness it doesn't include SQL unloads.

I think IBM call it an on-demand sales feature ;-) It tells you what you don't get and confuses you when you think you got a row full of nulls.

The other problem I found is that when you select table info, then columns, then immediately select a different table without coming out of info, it will display the columns for the first table still. I think they fixed that one in IDS10.x

[Monte Heeren]

Thank you for the reply Steven Protter and
Steve Lewis.

I guess we'll have to live with it this way.


Monte.