IBM Support

SI42631 - OSP-DB-OTHER-INCORROUT QSYCUSRA API ALWAYS RETURNS USER IS A

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT QSYCUSRA API ALWAYS RETURNS USER IS A


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI42442   00/00    0000
CO   5770SS1  710  SI42443   00/00    0000
CO   5770SS1  710  SI41854   00/00    0000
CO   5770SS1  710  SI41354   00/00    0000
CO   5770SS1  710  SI40213   00/00    0000
CO   5770SS1  710  SI38521   00/00    0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
QSYCUSRA API always returns user is authorized when running a
field procedure.

CORRECTION FOR APAR SE46809 :
-----------------------------
One of the system *srvpgm objects (QQQSRVI2) was created with
the wrong usrprf setting resulting in adopting QSYS authority
when running a field procedure program through the CQE
interface.

CIRCUMVENTION FOR APAR SE46809 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI42530      OSP-DB-MSGMCH0601 from QQQVEXPL
   SI42444      OSP-DB Internal maintenance
   SI42444      OSP-DB-MSGSQL0901 SQL expression evaluator  returned when ca
   SI42444      OSP-DB Visual Explain misspelling of Temporary Sorted List i
   SI42347      OSP-DB-OTHER-F/QQQSVRTN MCH0601 QUERY WITH RAISE_ERROR.
   SI41942      OSP-DB-OTHER wrong Fieldproc error code returned
   SI41853      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41846      OSP-DB-OTHER-INCORROUT INCORRET NUMBER OF RECORDS ARE WRITTE
   SI41829      OSP-MSGMCH3406-PAR-940XDISK QUERY GENERATES A TEMP FILE THAT
   SI41603      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41554      OSP-DB Parameter marker extensions support - iteration 4
   SI41460      OSP-DB-OTHER remove extra CPF504D messages
   SI41357      OSP-DB Internal Maintenance
   SI41194      OSP-DB Internal Maintenance
   SI41015      OSP-DB-UNPRED Too many Final Calls for Final Call UDFs
   SI40769      OSP-DB-PERFM Improved Fieldproc Performance
   SI40749      OSP-DB-SQL Varchar_format & Timestamp_format additional Form
   SI40677      OSP-DB-PERFM Fieldproc performance
   SI40448      OSP-DB-SQL Months_Between Consider time when parameters are
   SI40368      OSP-DB-INCORROUT FieldProcs and Lobs when CQE
   SI40339      OSP-DB Parameter marker extensions support - iteration 2
   SI40333      OSP-DB-PERFM Fieldproc performance
   SI40212      OSP-DB Internal Maintenance for Database Monitor
   SI40212      OSP-DB Internal Maintenance
   SI40165      OSP-DB SQL Scalar UDF Inlining - iteration 1
   SI40051      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39964      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39792      OSP-DB-INCORROUT Visual Explain of V5R4 DBMON
   SI39125      OSP-DB-OTHER-F/QQQQEXIT-T/QQQQEXIT-MSGMCH1210 ERROR OCCURRED
   SI38307      OSP-DB-OTHER-F/QQQVALID-T/QSQRUN3-MSGCPD4367
   SI37868      OSP-DB-OTHER-INCORROUT VISUAL EXPLAIN FAILS WITH A MESSAGE M
   SI37392      OSP-DB-MSGCPF9810 Visual Explain
   SI39729      OSP-DB-MSGMCH3203 F/QQQOOOUPCL T/QQQOOOUPCL WHEN INVOKING UD
   SI39725      OSP-DB Parameter marker extensions support - iteration 1
   SI39628      OSP-DB Database monitor internal maintenance.
   SI39500      OSP-DB-SQL  TIMESTAMP_FORMAT  NNNNNN  left justify microseco
   SI39412      OSP-DB-INCORROUT UDF with VARBINARY parameter
   SI39271      OSP-DB-SQL Support BIDI CCSID to UTF or UCS2 translation lon
   SI39290      OSP-DB-MSGMCH1210 ALTER TABLE unexpected MCH1210 from QQINVF
   SI39124      OSP-DB-UNPRED unexpected MCH1201 in QSQRESET
   SI39078      OSP-DB Sequence objects used in a Merge query returns incorr
   SI39078      OSP-DB-OTHER-UNPRED DBMON AFFECTING ODBC & JDBC CONNECTIONS
   SI38971      OSP-DB Database monitor internal maintenance.
   SI38717      OSP-DB-INCORROUT Insert into XML Column with Fieldproc
   SI38704      OSP-DB Internal Maintenance for Database Monitor
   SI38650      OSP-DB Internal Maintenance for Database Monitor
   SI38515      OSP-DB-OTHER-F/QQQUDFHL-T/QSQRUN3-MSGCPF426A INVOKING UDFS T
   SI37925      OSP-DB-SQL   Update internal  service tool
   SI37896      OSP-DB-MSGCPD5036 for UDTF with XML output parameters
   SI37863      OSP-DB-OTHER-PERFM QQQSVRTN CREATING BUT NOT CLEANING UP MUT
   SI37803      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC8-MSGCPD4374
   SI37797      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0443 ENCOUNTED USING
   SI37639      OSP-DB-OTHER-F/EXSNDPM-T/QSQSTATS-MSGMCH3601 MSGMCH3601 F/EX
   SI37639      OSP-DB-MSGMCH1210 f/t QQQSVRTN/QQINVUDF/IMPLEMENTUDTFINSQE
   SI37639      OSP-DB-MSGSQL0204 SQL procedure not found
   SI37356      OSP-DB-MSGSQL0204 SQL procedure not found
   SI37241      OSP-DB Internal mainenance for database monitor
   SI37183      OSP-DB-MSGCPF9898 on Field Procedure error
   SI37152      OSP-DB Longer Schema Support
   SI37008      OSP-DB-MSGSQL0443 XSLTRANSFORM scalar function
   SI36798      OSP-DB-MSGMCH3402 t/QQQSVRTN for query with UDF and LOB loca
   SI36698      OSP-DB-INCORROUT Table function with LOB locator result para
   SI37081      OSP-DB Internal maintenance for database monitor

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE46809
Superseded by:......................View fix details for PTF SI75298
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1270710


IBM i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
16 April 2021