Cast funtion - Local processing error

[cognosun]

For a calculation, I need to convert null to integer.

I'm doing this using cast(null,integer), it worked fine before, but all of a sudden it's giving me warning that the query requires local processing.

Is there any workaround for the same, currently we are on default processing and we don't want to enable local processing.

Many thanks in advance.

[BigChris]

You could try using the coalesce function...

[cognosun]

Hi Chris,

Can you please help me with the equivalent coalesce syntax , for cast(null,integer)

Many thanks in advance.

[BigChris]

From memory, it's something like coalesce([YourField],0) ... that assumes that you want to put a zero in place of the NULL.

[Lynn]

Or else try whatever your database syntax is for the cast function. For example, on DB2 it would be:

Code Select Expand


cast ( null as integer )


[cognosun]

cast, coalesce, to_number.....nothing is working :-)