MVSFORUMS.com :: View topic

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Quick Manuals

Profile

DB2 Query

MVSFORUMS.com Forum Index -> Database

View previous topic :: View next topic

Author

Message

valeti_sashi
Beginner

Joined: 11 May 2005
Posts: 12
Topics: 7
Location: Chennai, India

Posted: Tue Oct 03, 2006 8:34 am Post subject: DB2 Query

Hi,

I am geting error in the following query. can any one tell if the syntax is correct.

Query:

Code:

SELECT SUBSTR(TS.PRNT_GRP_MNEM,1,1) 00000001
,SUBSTR(TS.PRNT_GRP_MNEM,2) 00000002
,TS.I_TRAN_CDE_GRP 00000003
,TS.GRP_NME 00000004
,TS.I_SORT_SEQ 00000005
,(SELECT I_SORT_SEQ 00000007
FROM TST.FIR_TRAN_CDE_GRP PS 00000008
WHERE PS.I_TRAN_CDE_GRP = TS.I_TRAN_CDE_GRP) AS COL1 00000009
FROM TST.FIR_TRAN_CDE_GRP TS 00000010
WHERE SUBSTR(GRP_PURP_TYP,1,2) = 'IL' 00000011
AND SUBSTR(GRP_PURP_TYP,3,5) = 'PRO' 00000012
-- AND TR.C_TRAN_RPTG_CHGD = TC.I_TRAN_CDE 00000013
-- AND TC._I_TRAN_CDE = '10318' 00000014
; 00000015
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "I_SORT_SEQ". SOME SYMBOLS THAT
MIGHT BE LEGAL ARE: + ) -
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 377 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000179' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+

_________________
Regards,
Sashidhar

kolusu
Site Admin

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

Posted: Tue Oct 03, 2006 8:57 am Post subject:

valeti_sashi,

your query syntax is not correct. Try this query

Code:

SELECT SUBSTR(TS.PRNT_GRP_MNEM,1,1)
,SUBSTR(TS.PRNT_GRP_MNEM,2)
,TS.I_TRAN_CDE_GRP
,TS.GRP_NME
,TS.I_SORT_SEQ
FROM TST.FIR_TRAN_CDE_GRP TS
,(SELECT I_SORT_SEQ
FROM TST.FIR_TRAN_CDE_GRP PS
WHERE PS.I_TRAN_CDE_GRP = TS.I_TRAN_CDE_GRP) AS COL1
WHERE SUBSTR(GRP_PURP_TYP,1,2) = 'IL'
AND SUBSTR(GRP_PURP_TYP,3,5) = 'PRO'
-- AND TR.C_TRAN_RPTG_CHGD = TC.I_TRAN_CDE
-- AND TC._I_TRAN_CDE = '10318'
;

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