Print Page - [Solved] Table Delivery - Setting 'Value If Null' to a variable

Title: [Solved] Table Delivery - Setting 'Value If Null' to a variable
Post by: c6lapsteel on 19 Apr 2006 04:19:30 AM

Hi All,

Does anyone know if it's possible to set 'Value If Null' to a value assigned to a variable in a Table Delivery?

Thanks,

Title: Re: Table Delivery - Setting 'Value If Null' to a variable
Post by: Opher on 22 Jan 2007 05:21:10 PM

I believe "Value If Null" is intended as a constant, like when you want to use -999 to indicate "unknown". If you want to use a variable, why not define a derivation in the datastream and make the assignment there if the column is null?

Good luck,
Opher

Title: Re: Table Delivery - Setting 'Value If Null' to a variable
Post by: rmcleod on 04 Feb 2007 04:14:35 PM

How about set a global environmental variable in the batch file that calls decisionstream

set null_value_key=999999

Then in the column definitions in the table delivery, put {$null_value_key} in the value if null box. If you are running multiple catalogues in sequence, the variable will persist throughout the whole session and you wont have to change it in multiple places.

Title: Re: Table Delivery - Setting 'Value If Null' to a variable
Post by: c6lapsteel on 16 Feb 2007 03:32:35 AM

Excellent suggestion - thanks for your input.

Regards

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: c6lapsteel on 19 Apr 2006 04:19:30 AM