Hi,
In the source DRS, I am doing a UNION of 2 queries.In the first query, I have 3 decimal fields which are not there in the second query.So to compensate that in the second query, I placed 0 in their places.It works fine in Oracle.But in OS390, it fails giving the message
"An unexpected token ",0" was found following "". Expected tokens may include: ", FROM INTO". SQLSTATE=42601"
This will gets fixed if I make that 0 as a character value.Ex: if I place zero as '0'.But then my UNION won't be working properly.
Any suggestion on this is highly appreciated.
Thanks,
Poornima
Hi Guru,
Thanks for the idea.It works with some extension of that.In the selct query, I put a space after the comma and then put 0.0.
Ex:select x,y, 0.0 from a; where there is a space after the comma (which is there in the suffix of y).
Awkward.Right?
Thanks again
Poornima.