Fetching Account Info from DBC.DBQLRules

Database

Fetching Account Info from DBC.DBQLRules

The column account in DBC.DBQLRules is defined as 

CAST(TRANSLATE(DBQLRuleTbl.AccountString USING UNICODE_TO_LOCALE WITH ERROR) AS CHAR(30))

I am able to see different accounts from DBC.DBQLRules by doing a select * on the view, but if I try to select a particular account related information using the following command I am not able to get any row:

SEL * FROM DBC.DBQLRules WHERE Account='$R...&S&D&H';(Name of the specific account).

Is there any extra condition that needs to be put with the equality comparison to get the selected rows in the output of the query?

Please help.

Tags (2)
2 REPLIES
N/A

Re: Fetching Account Info from DBC.DBQLRules

You need to use AccountString instead of Account.

ACCOUNT is a built-in function, which returns your current accountstring.

Another common error is DATABASE vs. DatabaseName :-)

Re: Fetching Account Info from DBC.DBQLRules

Thanks Dieter:),it worked!!