RE: 'SELECT USER' from IDS.2000 error -9971

Two things.... Check the systables record layout, IDS is not SE and If this is a huge problem, then you have a really long road ahead. The changes between 4.2 and 7.3 are large, deep and require lots of testing and code rework. If you think this problem is huge!!!!! Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Alistair Weatherill [mailto:NOSPAM-alistair@teleflorist.co.uk] Sent: Tuesday, January 30, 2001 6:57 AM To: informix-list@iiug.org Subject: 'SELECT USER' from IDS.2000 error -9971 Help!!!! Please..... I'm migrating my DB from SE to IDS.2000, and my 4gl from 4.2 to 7.3 and have hit a huge problem. I've got a simple library function that returns the user login id: ... define l_user char(10) select user into l_user from systables where tabid = 1 ... This works fine in 4.x and SE, but produces the following error in 7.3 and IDS.2000: 4gl run-time error number -9971 unknown error message -9971 The on-line documentation gives the error as: -9971 Cannot determine the return types of a query or return types are inconsistent. The database server cannot determine the data type for one or more of the values that the query is to return. Check the specification of the data type for each return value, correct any errors in the specification, and retry the query. More interestingly, if you type is the select stmt in isql or dbaccess it works: select user from systables where tabid = 1 returns: (expression) informix Ummmm, what's my problem???? Or is it just me? Thanks Alistair