I am trying to pass several userid values in a hold file to a field in DBA security in a master file. I know ways to pass one value or multiple values in a string. But, I am trying to pass several values in a hold file. I will highly appreciate if anyone have any suggestions or a sample code?

Here is the sample I am trying to accomplish

DBA=MRADMINISTRATOR, $
USER=DEVELOPER, $
ACCESS=R, RESTRICT=VALUE, NAME=SPM_PROJECTS, VALUE=USRID IN UIDHOLD, $

This message has been edited. Last edited by: Kerry,

You could create a report that happens to be in the DBA file format. Then use the

ON TABLE HOLD AS myfile FORMAT WP

to put in a file. You will have to code a filedef.

The "report" might have to make use of HEADING SUBHEAD SUBFOOT and FOOTING and maybe a little mcguyver to get the syntax right.

I have done one that starts with a FOCUS master file and generates the DDL for an SQL table and the load statements.

This message has been edited. Last edited by: Jim Morrow,

I could solve this issue. The hold file should be passed to the master file as follows.

DBA=MRADMINISTRATOR, $
USER=DEVELOPER, $
ACCESS=R, RESTRICT=VALUE, NAME=SPM_PROJECTS, VALUE=USRID EQ (UIDHOLD), $

The hold file UIDHOLD can have multiple values.