DSXchange

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

You said its a decimal field right, try 0.00 instead or whatever the prcision is, put that many zeros after the decimal. An arror in the dark

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.

The space is for the sign. For example, -3.3 and +3.5 are valid decimal numbers, as is 3.2.

ray.wurlod wrote:The space is for the sign. For example, -3.3 and +3.5 are valid decimal numbers, as is 3.2.

Many people are unaware of this fact. Maybe someone should put up a FAQ for this.

Technically it's an issue of SQL syntax, not a DataStage issue. Arguably it's an issue of (SQL) standards compliance.