Re: ODBC returns SQL error

[James Turnbull <jamest@xxxxxxxxxxxxxxx>]

Gary Feinstein wrote:

> Is anyone familiar with this error I am recieving from an ODBC call from
> MS Excel?
>
> SQL0104 - Token * was not valid.  Valid tokens: (<Identifier>).

There is also a PTF related to this problem (at least for Release 320).

                                                                            
James
Turnbull

AS/Tech Consulting

Technical Document

 PTF#:
                     SF43508 - OS/400 - HOST SERVERS
 Licensed Program:
                     5763SS1
 APAR Fixed:
                     SA66291
 Release:
                     320


Abstract

OSP-HOSTSERVERS-CA400WINOPT SQL0104 RECEIVED WHEN DOING A FI

Pre/Co-Requisite PTF / Fix List


REQ  LICENSED      PTF/FIX
TYPE PROGRAM  REL  NUMBER   LICENSED PROGRAM DESCRIPTION
---- -------- ---  -------  -----------------------------------------------
CO   5763SS1  320  SF30062  OS/400 - HOST SERVERS
CO   5763SS1  320  SF30061  OS/400 - HOST SERVERS

APAR Error Description / Circumvention


DESCRIPTION OF PROBLEM FIXED FOR APAR SA66291 :
-----------------------------------------------
    When a customer uses file transfer and specifies 'transfer to
    file' with incorrect syntax, the PC hangs and does not report
    any error messages.  If the file is transferred to the display,
    an error message is shown and the customer can cancel back to
    the transfer menu.  The only way to end a transfer request on
    the PC is to CLT-ALT-DEL and end that task.  On the 400 the
    transfer job, either QZDASOINIT or QZDAINIT must be ended
    manually.
    This error has only been reported with customers who are using
    SP SF40828.
    Following messages received in the joblog:
    SQL0104 - Tokens not valid
    CPC1125 - Immediate end job request QZDAINIT
    CPF1164 - Ended abnormally with 50


CORRECTION FOR APAR SA66291 :
-----------------------------

   When the SQL0104 error occurs, the client and the server are
   getting out of sync, and causing the PC to hang.


CIRCUMVENTION FOR APAR SA66291 :
--------------------------------

   None.

Activation Instructions


   None.

Special Instructions


   To apply this PTF immediately, the QSERVER subsystem's
   database server prestarted jobs should not be active.
   To ensure this issue the requests:

       QSYS/ENDPJ SBS(QSERVER) PGM(QIWS/QZDAINIT) OPTION(*IMMED)
   and
       QSYS/ENDPJ SBS(QSERVER) PGM(QIWS/QZDASOINIT) OPTION(*IMMED)

   If the above commands fail with CPF0922, nothing more needs
   to be done.

   To re-enable the function use:

       QSYS/STRPJ SBS(QSERVER) PGM(QIWS/QZDAINIT)
   and
       QSYS/STRPJ SBS(QSERVER) PGM(QIWS/QZDASOINIT)

   ********************************************************************
   THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
   PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
   IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
   ********************************************************************

   SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SF42840 :
   =================================================

   To apply this PTF immediately, the QSERVER subsystem's
   database prestarted jobs for ODBC should not be active.
   To ensure this issue the requests:

       QSYS/ENDPJ SBS(QSERVER) PGM(QIWS/QZDAINIT) OPTION(*IMMED)
   and
       QSYS/ENDPJ SBS(QSERVER) PGM(QIWS/QZDASOINIT) OPTION(*IMMED)

   If the above commands fail with CPF0922, nothing more needs
   to be done.

   To re-enable the function use:

       QSYS/STRPJ SBS(QSERVER) PGM(QIWS/QZDAINIT)
   and
       QSYS/STRPJ SBS(QSERVER) PGM(QIWS/QZDASOINIT)

Default Instructions


   THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.

Supersedes


PTF/FIX NO(S).  APAR TITLE LINE
--------------  -----------------------------------------------------------
   SF42840      OSP-HOSTSERVERS-MSGPWS0001 AFTER CALLING STORED PROCEDURE
   SF42840      CA400WINOPT-DBACCESS-INCORROUT WHEN TRANSFERRING A FILE WITH
   SF42051      OSP-HOSTSERVERS CURSOR NAME VERIFIED ON RESULTS SET FETCH
   SF42051      OSP-HOSTSERVERS SPECIAL COLUMNS DATA TYPE VALUE INCORRECT
   SF42051      OSP-HOSTSERVERS-MSGCPF1854 IN QZDACMDP AT X'0979'
   SF42051      OSP-HOSTSERVERS-MSGMCH3601-F/QZDASQL-T/QZDASQL
   SF42051      OSP-HOSTSERVERS-ODBC ERRORS USING SETCURSOR AND DRDA CONNECT
   SF42051      CA400WINOPT- FILE TRANSFER HANGS AFTER SELECTING A EMPTY LIB
   SF41227      OSP-HOSTSERVER-MSGMCH3601 ON SECOND TRANSFER OF FILE
   SF41227      CA400WINOPT-MSGCWBDB0052 DURING DATA TRANSFER BROWSE OF MEMB
   SF38338      OSP-HOSTSERVERS-MSGMCH3601-F/QZDASQL-T/QZDASQL ODBC SQL SELE
   SF38338      OSP-HOSTSERVERS-MSGSQL0904 RC7 RESOURCE LIMIT EXCEEDED ON
   SF38338      OSP-HOSTSERVER INDICATE WHICH FUNCTIONS ARE NOT SUPPORTED
   SF38338      OSP-HOSTSERVERS-CA400WINOPT-QIBM_QZDA_SQL1 EXIT POINT CAUSES
   SF38338      OSP-HOSTSERVERS-ODBC SQLSTATISTICS UNIQUE INDEX
   SF38338      OSP-HOSTSERVER MEMBER SPECIFIED ON DATA TRANSFER RECEIVES ER
   SF37769      OSP-HOSTSERVERS-PCSXFR-INCORROUT EXTRA RESPONSES TO STREAM F
   SF37142      OSP-HOSTSERVER FILE TRANSFER TEMPORARY STORAGE USED INCREASE
   SF37142      OSP-HOSTSERVERS-ODBC ERRORS ATTEMPTING A DRDA CONNECTION TO
   SF35007      OSP-HOSTSERVER DATABASE SERVER NOT HANDLING ALL CCSIDS
   SF35007      OSP-HOSTSERVER ODBC - NLSS SUPPORT WITH EXTENDED DYNAMIC
   SF35007      OSP-HOSTSERVER FETCH DATA SIZE LARGER THAN 16MEG CAUSES LOOP
   SF35007      OSP-HOSTSERVER INCORRECT NUMBER OF RESPONSES TO STREAM FETCH
   SF35007      CA400WIN-INCORROUT NO DATA FOUND IF USING ROWSET SIZE EQUAL
   SF35007      OSP-HOSTSERVER FILE TRANSFER DOWNLOADS CAUSING CONVERSION ER
   SF34326      OSP-HOSTSERVERS-MSGMCH1210 RETRIEVE FILE ATTRIBUTE
   SF34326      OSP-HOSTSERVER RECEIVER OVERLOAD ERROR WHEN MORE THAN 32K
   SF34326      OSP-HOSTSERVER ERROR WHEN USING FILE TRANSFER THROUGH QCMN
   SF34326      OSP-HOSTSERVER DATABASE SERVER CHANGES JOB CCSID INCORRECTLY
   SF34326      OSP-HOSTSERVERS-PCSXFR-MSGMCH3601_CA FOR WIN95 WHEN UNDERSCO
   SF32589      OSP-HOSTSERVER CONVERSION OF BACKSLASH CHAR. IN DBCS ENV
   SF32589      OSP-HOSTSERVERS-MSGSQL0501 MSGMCH3601 AFTER PREPARING STATEM
   SF32589      OSP-HOSTSERVER-MSGCPF5076 WHEN ENDING COMM USING ICF FILES
   SF31916      OSP-HOSTSERVER SQLPRIMARYKEYS RETURNED NO RESULTS
   SF31916      OSP-HOSTSERVER UNABLE TO UPDATE AS/400 DB FILE USING ODBC/MS
   SF31089      OSP-HOSTSERVER BROWSE WITH UNAUTHORIZED LIBRARY
   SF31089      OSP-HOSTSERVER NOT ACCEPTING *USRLIBL ON 4 CATALOG REQUESTS
   SF31089      OSP-HOSTSERVER LIBRARY NAME GETTING CHANGED ON THE HOST
   SF31089      OSP-HOSTSERVER RECEIVED SQL_ERROR FROM SQLMORERESULTS
   SF31089      OSP-HOSTSERVER NO ERROR MESSAGE IF BAD FIELD ON JOIN
   SF31089      OSP-HOSTSERVER SELECT LIST NOT DISPLAYING AFTER ERROR
   SF31089      CA400WIN-DBCS-ODBC-MSGPWS0003 CANNOT USE ODBC FOR SECONDARY
   SF30575      OSP-HOSTSERVER WIN95 FILE XFER-CAN'T BROWSE/WIN16 DB ACCESS
   SF30391      OSP-HOSTSERVER STREAM FETCH OF SMALL FILES
   SF30391      OSP-HOSTSERVER RECEIVING A FILE MORE THAN ONCE
   SF29578      HOSTSERVERS CODE CHANGES FOR FILE MODIFICATIONS
   SF29578      OSP-HOSTSERVER INVALID CONDITIONS RETURN 0 FOR DATA FID/PARM
   SF29578      OSP-HOSTSERVER UNEXPECTED END OF STREAM FETCH
   SF29578      OSP-HOSTSERVER INVALID DATA RETURNED ON MORESTREAMDATA
   SF29578      OSP-HOSTSERVER DYNAMIC STREAM FETCH FAILS FOR ONE FIELD
   SF29578      OSP-HOSTSERVER BLOCK INSERT FOR ONE ROW FAILS W/ MSGSQL0313
   SF29578      OSP-HOSTSERVER OS/2 RETRIEVE INDEX RETURNS COLUMN COUNT 0
   SF29578      OSP-HOSTSERVER OS/2 RETV.LIB INFO RETURNS NULL FOR QTEMP DSC

Summary Information

System................. AS/400
Models................. *ALL
Release................ V3R2M0
Recompile.............. N
Library................ QIWS
MRI Feature............ NONE



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---