Select Sub Query in Select Clause giving error

[ashishg77]

Hi
I have some business requirement for which i need to format some query which will be something like this

SELECT B.D_INCDNT
,B.L_INCDNT_TYP
,( SELECT A.I_PO FROM P.PQDCLSA A
WHERE A.I_INCDNT = B.I_INCDNT ) I_PO
FROM P.PQDCLSM B
WHERE B.I_INCDNT = '0700100';

When I run this sample query it gives me following error

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "A". 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 234 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'000000EA' X'00000000' SQL DIAGNOSTIC INFORMATION

I am using DB2 on mainframe.

Any help on this will be great.

Thanks in Advance.

[frozenmist]

Hi
I have some business requirement for which i need to format some query which will be something like this

SELECT B.D_INCDNT
,B.L_INCDNT_TYP
,( SELECT A.I_PO FROM P.PQDCLSA A
WHERE A.I_INCDNT = B.I_INCDNT ) I_PO
FROM P.PQDCLSM B
WHERE B.I_INCDNT = '0700100';

When I run this sample query it gives me following error

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "A". 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 234 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'000000EA' X'00000000' SQL DIAGNOSTIC INFORMATION

I am using DB2 on mainframe.

Any help on this will be great.

Thanks in Advance.

You may not be able to use the correlated query in the select...try using a join...

[chandu031]

Hi
I have some business requirement for which i need to format some query which will be something like this

SELECT B.D_INCDNT
,B.L_INCDNT_TYP
,( SELECT A.I_PO FROM P.PQDCLSA A
WHERE A.I_INCDNT = B.I_INCDNT ) I_PO
FROM P.PQDCLSM B
WHERE B.I_INCDNT = '0700100';

When I run this sample query it gives me following error

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "A". 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 234 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'000000EA' X'00000000' SQL DIAGNOSTIC INFORMATION

I am using DB2 on mainframe.

Any help on this will be great.

Thanks in Advance.

Hi,

On the contrary you can use corelated subselect within a Select statement.
I assume P here is your schema name?

[frozenmist]

Thanx Chandu... Ya I tried out the query too... It works...i dont see any error...
I ran the same query ... it didnt give any syntax errors as you had specified. If you still have the problem please do reply. I will also try...
Cheers