Hey Ronan,
Thanks for the revert, i am already trying the same with canonical tables.
But in that as well i am facing one issue in which i am unable to add new users to existing group by using the attached code.
ERROR: The method is not directed at a repository. (The Reposid parameter is blank.)
/* Specify connection options. Use an unrestricted user ID. Port 8561 */
options metaserver=XXXXXX
metaport=8561
metauser="sas"
metapass="XXXXXXX"
metarepository="Foundation";
/* Initialize the macro variables that create canonical tables. */
%mduimpc();
/* Create the person table. */
data &persontbla;
%definepersoncols;
infile datalines delimiter=',' missover;
input keyid name description title;
datalines;
P00111,ichelle Harrell,Mgr of Operations,Sr. Mgr
P00121,red Granite,NE Region Acct. Rep.,Account Rep II
P00131,rian Davis,Accounting System Developer,Senior Programmer
;
/* Create the grpmems table. */
data &idgrpmemstbla;
%defineidgrpmemscols;
infile datalines delimiter=',' missover;
input grpkeyid memkeyid;
datalines;
A5A86HMO.A500001O,P00111
A5A86HMO.A500001O,P00131
;
/* Create the authdomain table. */
data &authdomtbla;
%defineauthdomcols;
infile datalines delimiter=',' missover;
input keyid authDomName;
datalines;
A5A86HMO.AR000001,DefaultAuth
;
/* Create the logins table. */
data &logintbla;
%definelogincols;
infile datalines delimiter=',' missover;
input keyid userid password authdomkeyid;
datalines;
P00111,IDBIBANK.AD\114901, ,A5A86HMO.AR000001
P00121,IDBIBANK.AD\114902, ,A5A86HMO.AR000001
P00131,IDBIBANK.AD\114903, ,A5A86HMO.AR000001
;
/* Load the information from the work library into the metadata server. */
%mduimplb();
Thanks,
Kaushal Solanki