473,406 Members | 2,849 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Can anyone figure out why I am getting the SQL 203 below ?

Can anyone figure out why I am getting the SQL 203 below ?

SELECT DISTINCT
SP.SPCLT_CD,
CASE CI.CORP_ENT_CD
WHEN 'IL1' THEN ' '
ELSE SP.PROV_TYP_CD
END AS XPROV_TYP_CD,
ST.PWN_STA_CD
FROM
TPSDB05.PAL_PFIN PP
INNER JOIN
TPSDB05.PWN_CI_PFIN CI
ON PP.PROV_ID = CI.PROV_ID
INNER JOIN
TPSDB05.PWN_SPCLT SP
ON CI.PROV_ID = SP.PROV_ID
AND CI.NWK_CD = SP.NWK_CD
AND CI.SUB_NWK_CD = SP.SUB_NWK_CD
AND CI.CORP_ENT_CD = SP.CORP_ENT_CD
INNER JOIN
TPSDB05.PWN_SPCLT SP
ON CI.PROV_ID = SP.PROV_ID
AND CI.NWK_CD = SP.NWK_CD
AND CI.SUB_NWK_CD = SP.SUB_NWK_CD
AND CI.CORP_ENT_CD = SP.CORP_ENT_CD
INNER JOIN
TPSDB05.PWN_STATUS ST
ON CI.PROV_ID = ST.PROV_ID
AND CI.NWK_CD = ST.NWK_CD
AND CI.SUB_NWK_CD = ST.SUB_NWK_CD
AND CI.CORP_ENT_CD = ST.CORP_ENT_CD
WHERE
PP.PROV_ID = 354664370 AND
CI.CORP_ENT_CD = 'OK1' AND
CI.NWK_CD IN
(SELECT CD_VAL
FROM TPSDB05.CODE_REF
WHERE CD_REF_NM = 'BRE03PCPA'
AND CORP_ENT_CD = 'OK1'
AND VLDT_IND = 'Y'
AND CD_EFDT <= '2006-08-21'
AND (CD_END_DT > '2006-08-21'

OR CD_END_DT IS NULL)) AND
CI.SUB_NWK_CD IN
(SELECT CD_VAL
FROM TPSDB05.CODE_RELSHP
WHERE CD_REF_NM = 'BREXTSUBN'
AND CORP_ENT_CD = 'OK1'
AND REL_CD_REF_NM = 'BREXTPCPA'
AND REL_CD_VAL = CI.NWK_CD
AND VLDT_IND = 'Y'
AND REL_CD_EFDT <= '2006-08-21'
AND (REL_CD_END_DT > '2006-08-21'
OR REL_CD_END_DT IS NULL)) AND
PP.ACTVN_DT <= '2006-08-21' AND
CI.VLDT_IND = 'Y' AND
CI.PWN_CI_PFIN_EFDT <= '2006-08-21' AND
( CI.PWN_CI_PFIN_END_DT IS NULL
OR CI.PWN_CI_PFIN_END_DT > '2006-08-21')
AND
SP.VLDT_IND = 'Y' AND
SP.SPCLT_CD IN
(SELECT CD_VAL
FROM TPSDB05.CODE_REF
WHERE CORP_ENT_CD = 'OK1'
AND CD_REF_NM = 'BRE03SPCLT'
AND VLDT_IND = 'Y'
AND CD_EFDT <= '2006-08-21'
AND (CD_END_DT > '2006-08-21'
OR CD_END_DT IS NULL)) AND
SP.PWN_SPCLT_EFDT <= '2006-08-21' AND
(SP.PWN_SPCLT_END_DT IS NULL
OR SP.PWN_SPCLT_END_DT > '2006-08-21')
AND
ST.VLDT_IND = 'Y' AND
ST.PWN_STA_EFDT <= '2006-08-21' AND
(ST.PWN_STA_END_DT IS NULL
OR ST.PWN_STA_END_DT > '2006-08-21');


DSNT404I SQLCODE = 203, WARNING: THE QUALIFIED COLUMN NAME SP.SPCLT_CD WAS
RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME
DSNT418I SQLSTATE = 01552 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 1 1108504850 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000001' X'42127112'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

SPCLT_CD XPROV_TYP_CD PWN_STA_CD
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
Aug 25 '06 #1
0 2114

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mike | last post by:
I got the code below from an earlier post but I can't get it to work (I get an error on the "for (i=0; i<a.length; i++)" line) Anyone have code that works for cookies with keys? > Anyone...
5
by: xperiencednoob | last post by:
I want a left-column menu bar and a right-column data area. The menu items (6 or so) are fixed-height and the space below them needs to expand. I've run into a strange situation only with IE6....
8
by: Brian Basquille | last post by:
Hello all, Bit of a change of pace now. As opposed to the typical questions regarding my Air Hockey game, am also working on a Photo Album which uses an Access Database to store information...
0
by: Paul King | last post by:
Hey everyone, I'd like to ask your advice, or at least the advice of all of you who are either interested in, or already involved in, creating income from the internet. I'm not exactly...
2
by: Jeff Brown | last post by:
OK i have came to the conclusion that since this app will be run on multiple computers that loading a complete database and then updating on exit is a moot point. I have tried several ideas...
7
by: ritesh | last post by:
Hi, I'm unable to figure out why initializing a pointer dosen't work this way - void func(int * x) { x = (int*)(malloc(sizeof(int*))); *x = 2; }
15
by: Pucca | last post by:
I'm getting an error when I tried to use this BerConverter class in my C# code. Even though the Interent doc says that it runs on Win2000 sp4, I just thgouth I'll double check. Does anyone know...
0
by: Steve | last post by:
I have a gridview which uses an objectdatasource for its select and delete. The delete command uses the function below. The delete itself works but the extra logic which requires parameters...
11
by: itgetsharder | last post by:
can anyone help me? code errors! -------------------------------------------------------------------------------- im creating a code for a printer. the question i am trying to answer is : ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.