SEO

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.

Endif wrote:
> 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.
>

Are there any previous messages? If so, can you post the message ID(s)
and the message text?

--
Karl Hanson