@FALSE/@TRUE Problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
lfong
Premium Member
Premium Member
Posts: 42
Joined: Fri Sep 09, 2005 7:48 am

Post by lfong »

The error is: XML Error: A derivation Constant node contains an unsupported UVAtVar - '@False'.

The Constraint is:
StgBranch = @TRUE or StgAcct = @TRUE or StgValidDate = @TRUE or StgSeqCd = @TRUE or StgTranCd = @TRUE or StgAmt = @TRUE or StgTraceNo = @TRUE or StgSrcBnk = @TRUE or StgPostCd = @TRUE or StgCBACd = @TRUE or StgItemCd = @TRUE or StgOnlineFlg = @TRUE or StgBrToBrFlg = @TRUE or StgAdvFlg = @TRUE

The derivation for target column is:
if StgBranch = @False then 'XXXXXXX'

I did a check of the definition of the source fields for the IsValid check. They are all defined as decimal.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

lfong wrote:The derivation for target column is:
if StgBranch = @False then 'XXXXXXX'
System Variables must be all upper case. @False does not exist, but @FALSE does and should work more better. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply