Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

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

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

1 REPLY
Silver

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

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

130
Views
0
Helpful
1
Replies