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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: daYorkie
  • Content: Threads
  • Order by date
  1. daYorkie

    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...
  2. daYorkie

    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...
  3. daYorkie

    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...

Part and Inventory Search

Back
Top