What naming conventions are you using (SQL or System Naming Conventions).
Do you always qualify your database objects?
Does it also not work when you qualify all your database objects?
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
gio.cot via MIDRANGE-L
Sent: Sunday, 9 April 2023 12:35
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: ACS: SQL Content assist problem
Hi all
I have problem with SQL Content assist inside ACS (Ctrl + spave or F4) to
list files or fields : some time works and some times not works;
here the joblog of job .. I have missing some PTF ?
Thanks in advance
5770SS1 V7R2M0 140418 Visual. work SYSA 09/04/23 12:18:41 CEST Page 1
Job Name. . . . . . . . : QZDASOINIT User . . . . . . : QUSER Number . .
. . . . . . . . . : 686230
Job Description. . . . . : QDFTSVR Library . . . . : QGPL
IDMSG TYPE GRAV DATE TIME FROM PGM INST LIBRARY TO PGM INST LIBRARY
CPF1124 Information 00 09/04/23 12:15:44,107466 QWTPIIPP QSYS 04C9 *EXT *N
Message . . . : Job
686230/QUSER/QZDASOINIT started 09/04/23 at
12:15:44 in QUSRWRK subsystem in
QSYS. Work entered into the system on
09/04/23 at 12:15:44..
CPIAD02 Information 00 04/09/23 12:15:46,747216 QZBSSECR QSYS *STMT QZBSSECR
QSYS *STMT
By user . . . . . . . . : QPGMR
From the form. . . . . . . . :
QZBSSECR
From the procedure. . . . . . :
QzbsCheckSwapResults__FiP17QzbsStrSrvRequestP1
2QzbsStdReplyP14QzbsReplyHdr_tPA10_cPcPiPsP16sockaddr_storageN27
Instruction . . . . . . . . : 315
To the form. . . . . . . . . :
QZBSSECR
To the procedure . . . . . . :
QzbsCheckSwapResults__FiP17QzbsStrSrvRequestP1
2QzbsStdReplyP14QzbsReplyHdr_tPA10_cPcPiPsP16sockaddr_storageN27
Instruction . . . . . . . . : 315
Message . . . : User QPGMR from client
10.253.10.2 connected to the server.
Cause . . . : User profile QPGMR from
client 10.253.10.2 is currently
attached to this server job. The
client name can be a del name
TCP/IP remote system, a dotted
decimal IP address, the name
localhost or an IPv6 address.
SQL799C Information 10 04/09/23 12:15:47,777445 QZDASRV QSYS *STMT QZDASRV
QSYS *STMT
By user . . . . . . . . : QPGMR
From the form. . . . . . . . :
QZDACMDP
From the procedure. . . . . . :
CP_SET_ATTRCODE
Instruction . . . . . . . . : 21484
To the form. . . . . . . . . :
QZDACMDP
To the procedure . . . . . . :
CP_SET_ATTRCODE
Instruction . . . . . . . . : 21484
Message . . . : The following special
registers have been set:
CLIENT_ACCTNG: Windows
10;SSL=false;admin_user=false, CLIENT_APPLNAME: IBM i
Access Client Solutions - Run SQL
Scripts, CLIENT_PROGRAMID:
file:/C:/Program%20Files/IBM%20ACS/acsbundle.jar | Version: 1.1.9.1 | ID
build: 2171 | 2022-11-07 09:09:38,
CLIENT_USERID: a.cotoloni,
CLIENT_WRKSTNNAME: MYNAMEC-PC
Cause . . . : This message is issued
when all special logs
of the client are updated.
CPF9812 Exit 40 09/04/23 12:15:49,092625 QLIROHDL QSYS 0127 EX_CASQL2 IJRN
*STMT
By user . . . . . . . . : QPGMR
To the form. . . . . . . . . :EXEXIT
To the procedure . . . . . . :EXEXIT
Instruction . . . . . . . . : 10873
Message . . . : VALUES file not found
in library *LIBL.
Cause . . . : The file or library
name is incorrect. If the name
of the library was not specified,
the file could be in one
library not contained in the library
list. Correction. . :
Correct the file or library name or
add the library name
library to the library list. Repeat
the request.
CPF2101 Issue 40 09/04/23 12:16:21,668923 QUSROBJD QSYS
01E9 EX_CASQL2 IJRN *STMT
By user . . . . . . . . : QPGMR
To the form. . . . . . . . . :EXEXIT
To the procedure . . . . . . :EXEXIT
Instruction . . . . . . . . : 10873
Message . . . : SQLLIB object type is
not valid.
5770SS1 V7R2M0 140418 Visual. SYSA job 09/04/23 12:18:41 CEST Page 2
Job Name. . . . . . . . : QZDASOINIT User . . . . . . : QUSER Number . .
. . . . . . . . . : 686230
Job Description. . . . . : QDFTSVR Library . . . . : QGPL
IDMSG TYPE GRAV DATE TIME FROM PGM INST LIBRARY TO PGM INST LIBRARY
Cause . . . : Object type SQLLIB is
not a valid external object type.
Possible causes for this error are:
-- The value specified for a
object type parameter is not a
recognized object type. -- Yes is
An internal system error has
occurred. Correction. . : Correct the
object type to a valid external
object type and repurpose
the operation. The correct format
for specifying an external object type
includes an asterisk as the first
character, followed by up to six
characters. For a list of valid
external object types, see
the CL Reference topic in the
Information Center, at
http://www.ibm.com/systems/i/infocenter/. If a type was not specified
of object on an external interface,
such as a command or an API (application
program interface), there is no
recovery. No fixes.
Report the problem (ANZPRB command).
CPF503E Sender Copy 30 09/04/23 12:16:28,245556 QDBIOERRQO QSYS *STMT
QDBIOERRQO QSYS *STMT
By user . . . . . . . . : QPGMR
From the form. . . . . . . .
:QDBIOERRQO
From the procedure. . . . . . :
SEND_MESSAGE
Instruction . . . . . . . . : 4218
To the form. . . . . . . . .
:QDBIOERRQO
To the procedure . . . . . . :
SEND_MESSAGE
Instruction . . . . . . . . : 4218
Message . . . : User defined function
error on member
SYSTABLES.
Cause . . . : An error occurred while
calling the function
DELIMIT_NAME user-defined in library
QSYS2. The error is
occurred when calling the associated
external program or del
service program QDBSSUDF2 in library
QSYS, entry point
program or external name QSQDELNAM,
specific name QSQDELNAM. The error is
checked against SYSTABLES member
SYSTABLES file in library QSYS2. The
error code is 1. The error codes and
their meanings follow: 1
-- External program or service
program returned SQLSTATE
22546. The returned text message is:
INPUT NAME IS NULL OR AN EMPTY
STRING . 2 -- The external program
failed before
completion. 3 -- The database timed
out che
awaited the return of the program.
The timeout value
used by the database was 0 minutes
and 30 seconds. 4 -- The external program
no longer exists or could not be
found. 5 -- One of the input parameters
of the function reported a data
matching error. from 6 to 26 --
See the previous message in the job
log. For a
external program,
the entry point of the displayed program will be *N.
Correction. . : For error codes 1
and 2, determine the cause
of the error from SQLSTATE or a
previously listed message. For the
error code 3, increase the time
limit using
QAQQINI file setting or determine
the reason why the
external program or the service
program was not returned in the
allotted time. For error code 4,
make sure the program or
the service program exist for the
duration of the query. For the code
error 5, determine the cause of the
data mismatch. For the
error codes 6 to 26, see previous
message in
job registration. See the DB2 for i
SQL programming topic in
Database category in the IBM i
Information Center documentation,
at
http://www.ibm.com/systems/i/infocenter/ for more
5770SS1 V7R2M0 140418 Visual. SYSA job 09/04/23 12:18:41 CEST Page 3
Job Name. . . . . . . . : QZDASOINIT User . . . . . . : QUSER Number . .
. . . . . . . . . : 686230
Job Description. . . . . : QDFTSVR Library . . . . : QGPL
IDMSG TYPE GRAV DATE TIME FROM PGM INST LIBRARY TO PGM INST LIBRARY
information about user-defined
functions. To reply to messages,
the possible choices are . . . . . .
. . . :C -- The request is cancelled.
I -- The request is ignored.
CPF503E Report 30 04/09/23 12:16:28,245585 QDBIOERRQO QSYS *STMT QSQRUN2
QSYS *STMT
By user . . . . . . . . : QPGMR
From the form. . . . . . . .
:QDBIOERRQO
From the procedure. . . . . . :
SEND_MESSAGE
Instruction . . . . . . . . : 4218
To the form. . . . . . . . . :
QSQFETCH
To the procedure . . . . . . :
F_GETBLK
Instruction . . . . . . . . : 20788
Message . . . : User defined function
error on member
SYSTABLES.
Cause . . . : An error occurred while
calling the function
DELIMIT_NAME user-defined in library
QSYS2. The error is
occurred when calling the associated
external program or del
service program QDBSSUDF2 in library
QSYS, entry point
program or external name QSQDELNAM,
specific name QSQDELNAM. The error is
checked against SYSTABLES member
SYSTABLES file in library QSYS2. The
error code is 1. The error codes and
their meanings follow: 1
-- External program or service
program returned SQLSTATE
22546. The returned text message is:
INPUT NAME IS NULL OR AN EMPTY
STRING . 2 -- The external program
failed before
completion. 3 -- The database timed
out che
awaited the return of the program.
The timeout value
used by the database was 0 minutes
and 30 seconds. 4 -- The external program
no longer exists or could not be
found. 5 -- One of the input parameters
of the function reported a data
matching error. from 6 to 26 --
See the previous message in the job
log. For a
external program, the entry point of
the displayed program will be *N.
Correction. . : For error codes 1
and 2, determine the cause
of the error from SQLSTATE or a previously listed message. For the
error code 3, increase the time
limit using
QAQQINI file setting or determine
the reason why the
external program or the service
program was not returned in the
allotted time. For error code 4,
make sure the program or
the service program exist for the
duration of the query. For the code
error 5, determine the cause of the
data mismatch. For the
error codes 6 to 26, see previous
message in
job registration. See the DB2 for i
SQL programming topic in
Database category in the IBM i
Information Center documentation,
at
http://www.ibm.com/systems/i/infocenter/ for more
information about user-defined
functions. To reply to messages,
the possible choices are . . . . . .
. . . :C -- The request is cancelled.
I -- The request is ignored.
SQL0443 Diagnostics 30 09/04/23 12:16:28,245769 QSQRUN2 QSYS *STMT QSQRUN2
QSYS *STMT
By user . . . . . . . . : QPGMR
From the form. . . . . . . . :
QSQFETCH
From the procedure. . . . . . :
CK_DEBUG
Instruction . . . . . . . . : 23859
To the form. . . . . . . . . :
QSQFETCH
To the procedure . . . . . . :
CK_DEBUG
5770SS1 V7R2M0 140418 Visual. SYSA job 09/04/23 12:18:41 CEST Page 4
Job Name. . . . . . . . : QZDASOINIT User . . . . . . : QUSER Number . .
. . . . . . . . . : 686230
Job Description. . . . . : QDFTSVR Library . . . . : QGPL
IDMSG TYPE GRAV DATE TIME FROM PGM INST LIBRARY TO PGM INST LIBRARY
Instruction . . . . . . . . : 23859
Message . . . : The trigger program or
an external routine has detected a
mistake.
Cause . . . : A trigger program, an
external procedure, or a function
external were encountered and an
error was returned to the SQL. If it is
An error occurred in a trigger
program, the trigger was on the table
QDBSSUDF2 in schema QSYS. If the
error occurred in a procedure
external or function, the external
name is QDBSSUDF2 in schema QSYS. The text
associated is INPUT NAME IS NULL OR
AN EMPTY STRING. If there has been a
error in a trigger program, the
associated text is the type of program
triggers. If the error occurred in
an external function, the text
associated is the text of the error
message returned by the function
external. Correction. . : Refer to
the job record
for more information about the
detected error. Correct the error
and repeat the request.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
midrange.com
