DSXchange

Posted: **Mon Nov 12, 2007 3:43 pm**

Hi,

I am extracting the data from oracle where a column QT is defined as integer.i am transferring the data from oracle stage to dataset.I am using modify stage in between. the column QT is nullable and i need to handle null values with blankspace.i tried using

QT=handle_null(QT, " ")

job shoes error saying it is a bad literal.Is there any way i can handle null values from QT (integer) and replace with blank spaces by using modify stage.

Thanks

Posted: **Mon Nov 12, 2007 4:17 pm**

dsdev_123 wrote:Hi,

I am extracting the data from oracle where a column QT is defined as integer.i am transferring the data from oracle stage to dataset.I am using modify stage in between. the column QT is nullable and i need to handle null values with blankspace.i tried using

QT=handle_null(QT, " ")

job shoes error saying it is a bad literal.Is there any way i can handle null values from QT (integer) and replace with blank spaces by using modify stage.

Thanks

I guess there is some mistake in the syntax the way handle_null function has been used.

It should be

Code: Select all


  QT:integer=handle_null(QT, " ")

DSXchange

handling nulls from dataset

handling nulls from dataset

Re: handling nulls from dataset