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?
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 :-)