Value not specified for Virtual column
Article ID: KB0080717
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.7,All, , , |
Description
I am using the below snippet from CIS examples and encountering the " Value not specified for Virtual column " exception
SELECT
a.ProductID,
{ DECLARE a_prod_id INTEGER } a_prod_id,
a.ProductName,
b.ProductDescription
FROM
/shared/examples/ds_inventory/tutorial/products a INNER JOIN
/shared/examples/LookupProduct(a_prod_id) b
ON a.ProductID = a_prod_id
SELECT
a.ProductID,
{ DECLARE a_prod_id INTEGER } a_prod_id,
a.ProductName,
b.ProductDescription
FROM
/shared/examples/ds_inventory/tutorial/products a INNER JOIN
/shared/examples/LookupProduct(a_prod_id) b
ON a.ProductID = a_prod_id
Resolution
To resolve the issue, you have to modify the snippet by giving the DEFALUT value in the Declaration block in the SELECT Clause.
SELECT
a.ProductID,
{ DECLARE a_prod_id INTEGER DEFAULT 10 } a_prod_id,
a.ProductName,
b.ProductDescription
SELECT
a.ProductID,
{ DECLARE a_prod_id INTEGER DEFAULT 10 } a_prod_id,
a.ProductName,
b.ProductDescription
Issue/Introduction
I am encountering "Value not specified for Virtual column" error message for the procedure which has the Virtual columns
Feedback
Yes
No
Powered by
