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
handling nulls from dataset
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
Re: handling nulls from dataset
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, " ")