How to handle <Null> fields on on Set Enterprise Data Step

[jjia]

Hi all,

For the IPCC, if the external SQL database's field is <Null>, although there is no error on Getting DB step, on Set Enterprise Data step will go to "Failed" branch. But if I changed the field from <Null> to Space, then the Set Enterprise Data Step will be successful.

Dose anyone knows how to handle the <Null> field on set Enterprise data step other than we replace all these <Null> fields

to Space fields?

Thanks,

Joe

[yogeswar]

Hi Joe,

Very late response... Not sure if you have found a solution for the same.

When the field value in database is null, the same can be checked and can a default value can be set in the select query.

Consider a table : EMPDET

Fields - EMPNO as string

EMPNAME as string

Assume you have a record with EMPNO as 1000 and EMPNAME as null(empty in DB).

The following query will set empty space value for EMPNAME if its value is NULL. The same can be assigned to enterprise variable without checking for null value.

Select isnull(EMPNAME,' ')EMPNAME from EMPDET where EMPNO='1000'

use the above query in the SQL tab of DBRead step.

Hope it helps.

Regards

Yogi