MVSFORUMS.com :: View topic - Problem with the oracle query

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Quick Manuals

Profile

Problem with the oracle query - Error code 00904

MVSFORUMS.com Forum Index -> Database

View previous topic :: View next topic

Author

Message

Beswar
Beginner

Joined: 04 Feb 2003
Posts: 33
Topics: 15

Posted: Mon Feb 28, 2005 8:41 pm Post subject: Problem with the oracle query - Error code 00904

Code:

SELECT 'PAGE7 ' ||
CARRNM||'*'||
ABBR_TXT||'*'||
WSLR_NBR||'*'||
CITY_TXT||'*'||
STATE_CD||'*'||
LEGCY_SHPMT_ID||'*'||
ORD_NBRD||'*'||
EST_ARIVL_TSP
FROM
(SELECT
CARRNMM,
ABBR_TXT,
WSLR_NBR,
CITY_TXT,
STATE_CD,
LEGCY_SHPMT_ID,
ORD_NBRD,
EST_ARIVL_TSP
FROM
(SELECT DISTINCT
CARR.NM,
DP.ABBR_TXT AS LOC,
WHSE.WSLR_NBR,
BA.CITY_TXT,
BA.STATE_CD,
S.LEGCY_SHPMT_ID AS EDI_SHPMNT,
SD.ORD_NBRD,
SL.EST_ARIVL_TSP
FROM
SHPMT S,
SHPMT_LEG SL,
DISTR_PNT DP,
CARR,
SHPMT_LEG_DTL SD,
BUS_ADDR BA,
WHSE
WHERE
S.ID = SL.SHPMT_ID AND
CARR.BUS_ENTY_ID = S.CARR_ID AND
S.SHP_TSP IS NOT NULL AND
S.TYP = 'A' AND
((S.TRANS_ADVNTG_FLG = 'Y' AND
S.TNDR_RSPNSBLTY_CD IS NULL) OR
(S.TNDR_RSPNSBLTY_CD = 'D')) AND
S.ID = SD.SHPMT_ID AND
WHSE.BUS_ENTY_ID = BA.BUS_ENTY_ID AND
BA.STATE_CD <> '**' AND
SL.EST_ARIVL_TSP BETWEEN TO_DATE('&&','YYYYMMDD') AND
TO_DATE('&&','YYYYMMDD') AND
S.OUTBND_BEER_ORIG_BUS_ENTY_ID = DP.BUS_ENTY_ID AND
DP.TYP_CD IN ('BRWY', 'DC') AND
SL.ARIVL_TSP IS NULL AND
SL.SEQ_NBR = 1 AND
SL.OUTBND_BEER_DEST_BUS_ENTY_ID = WHSE.BUS_ENTY_ID AND
SL.OUTBND_BEER_DEST_SEQ_NBR = WHSE.SEQ_NBR
ORDER BY 2, 1));

kolusu
Site Admin

Joined: 26 Nov 2002
Posts: 12383
Topics: 75
Location: San Jose

Posted: Tue Mar 01, 2005 8:48 am Post subject:

Beswar,

Please follow the rules of the forum. Do not open more than 1 topic for the same question. This board primarly deals with mainframe related questions. However this site also hosts a link for Oracle Error Messages on the main page of mvsforums.

The main page of mvsforums can be accessed via

www.mvsforums.com

Now coming to the error message of 00904 , here is a detailed explanation of the error

Code:

ORA-00904 invalid column name

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Display posts from previous:

	MVSFORUMS.com Forum Index -> Database	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum