dyelar
New Member
I've tried about 3 dozen different combinations to translate the following statement into SQL.
output to _user.d.
for each trading._user where trading._user._userid = "itdba":
export trading._user .
I've been able to do the following to get a user listing, but I can't figure out how to specify the userid.
select * from pub."_user";
I get a variety of errors when I try different where clauses, but I've not been able to get any different combination of referencing pub or trading to work out the appropriate reference userid. I can provide error messages, if needed, but can anyone provide me some pointers?
Thank you for any help provided.
This is under Progress 10.1C, if that proves to be important.
output to _user.d.
for each trading._user where trading._user._userid = "itdba":
export trading._user .
I've been able to do the following to get a user listing, but I can't figure out how to specify the userid.
select * from pub."_user";
I get a variety of errors when I try different where clauses, but I've not been able to get any different combination of referencing pub or trading to work out the appropriate reference userid. I can provide error messages, if needed, but can anyone provide me some pointers?
Thank you for any help provided.
This is under Progress 10.1C, if that proves to be important.