Hi All,
When I try to do an UNLOAD on my database, I get this...
-ERROR- Column BP1 exists as both a computed and non-computed column. ( 195)
You must rename the non-computed column before you can do an UNLOAD.
When I try to find which table(s) have the offending column(s) I get this....
R>list column BP1
Column Name Table Name Attributes
------------------ ------------------ ---------------------------------------
BP1 VITALS0 Type : TEXT 12
Compute:
((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1)))
VITALS1 Type : TEXT 12
Compute:
((CTXT(SYSTOLIC1))+'/'+(CTXT(DIASTOLIC1)))
Looking at the above, I see 2 identical definitions for the column called BP1.
Why is the UNLOAD failing?
Mike
