Hello,
I am on creating a new Logical file (View) using the ISeries Windows
Navigator for DB2/400 V8. It is based on SQL Query. when the physical
files in SQL Query are updated, the View fails and does not execute
anymore, I get "SQL system error" But if i just run SQL Query through
SQL editor it works fine. I am not sure whats wrong.
Please help.
SQL statement the Logical created on
====================================
SELECT
TMPF.*,
JP.POSITION_ID AS POSITIONID,
JP.POSITION_TITLE AS POSITION
FROM TRNWORK.TRNMTVIEW TMPF
LEFT OUTER JOIN TRNWORK.JOBPOSVIEW JP
ON TMPF.POSITION_ID = JP.POSITION_ID
==========================================
Error : when i try to open the View
SQL system error.
Message ID: SQL0901
Cause . . . . . : An SQL system error has occurred. The current SQL
statement cannot be completed successfully. The error will not prevent
other SQL statements from being processed. Previous messages may
indicate that there is a problem with the SQL statement and SQL did not
correctly diagnose the error. The previous message identifier was
CPF4204. Internal error type 3107 has occurred. If precompiling,
processing will not continue beyond this statement.
Recovery . . . : See the previous messages to determine if there is a
problem with the SQL statement. To view the messages, use the DSPJOBLOG
command if running interactively, or the WRKJOB command to view the
output of a precompile. An application program receiving this return
code may attempt further SQL statements. Correct any errors and try the
request again.