View previous topic :: View next topic
|
Author |
Message |
GauravKudesiya Warnings : 1 New User
Joined: 11 Oct 2008 Posts: 74 Location: Chicago, IL
|
|
|
|
Hello All,
I am running a SQL through JCL.
I am getting SQLCODE = -904
Exact Error
Code: |
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLABLE RESOURCE. REASON 00C90085, TYPE OF
RESOURCE 00000230, AND RESOURCE NAME 4K
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -115 13172746 0 13231826 -959250432 14090279 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000' X'00C9E6D2' X'C6D30000' X'00D70027' SQL DIAGNOSTIC
INFORMATION |
The SQL is a complex SQL using 3 different tables
Code: |
SELECT DISTINCT PROD.TABLEA.BNF_ID
FROM PROD.TABLEA , PROD.TABLEB ,
PROD.TABLEC
WHERE NOT EXISTS
(SELECT 'X'
FROM PROD.TABLED
WHERE PROD.TABLED.BCO_BNF_ID = PROD.TABLEA.BNF_ID)
AND PROD.TABLEB.BPG_EXP_DT > CURRENT DATE
AND PROD.TABLEA.BNF_BEF_CLT_ID = PROD.TABLEC.CLT_ID
AND ( PROD.TABLEC.CLT_MOR_DIS_PCG_IN <> 1
OR PROD.TABLEC.CLT_PCS_DIS_PCG_IN <> 1
OR PROD.TABLEC.CLT_POS_DIS_PCG_IN <> 1)
AND PROD.TABLEC.CLT_TSF_IN = 1
WITH UR; |
Thanks in Advance!! |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
a join condition between tableB and (tableA or tableC ) might also help |
|
Back to top |
|
|
|