Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How many UNIONs can i use in a single query?
Hi all, I have a rather long query selecting items out of various unconnected areas of the DB. I have a working query including 20 UNIONs but when I add the 21st I am presented with a syntax error DB Errorcode=-201 (standard general syntax code) each statement in isolation runs fine. Have i...- daYorkie
- Thread
- Replies: 2
- Forum: Informix solutions
-
Problem with Inline View / TABLE(MULTISET....
Hi, I have a query with two inline views which is returning the error: Error: Cannot obtain or set serial value. (State:S1000, Native Code: FFFFFD8E) Statement is being run from WinSql client using IBM Informix ODBC driver. SQL: select ACCT_ID, TOT_DEP, LIMIT_VALUE from TABLE(MULTISET...- daYorkie
- Thread
- Replies: 0
- Forum: Informix solutions
-
Inline View Equivalent in Informix
I'm new to Informix and I'm unable to get a working inline view as per OracleSql. I'm executing the following statement: SELECT A.ACCT_ID, A.BALANCE, A.SUM_AP, NEWPAY.SUMBALANCE FROM TACCT A, (SELECT ACCT_ID, SUM(AMOUNT) AS SUMBALANCE FROM TJRNL WHERE CR_DATE=CURRENT GROUP BY ACCT_ID) AS...- daYorkie
- Thread
- Replies: 5
- Forum: Informix solutions
