ALTER GROUP Not working in DQL Write Activity

Mostafa_Mohamed

I'm trying to add users to a goup i already created. itreyed to use write DQL activity but it giving me (DQL statement is not supported)

The below green ex working in the DA or using dqMan. but not working with the DQL write activity.

EX:

ALTER GROUP case ADD (select user_name from dm_user where user_name in (select c_enf_disp_assined_off from cma_enf_case_dis_doc where object_name ='2012-AUG-1033'))

ALTER GROUP ? ADD (select user_name from dm_user where user_name in (select c_enf_disp_assined_off from cma_enf_case_dis_doc where object_name =?))

Thanks,

Mostafa Fahmy

Error.jpg

Mostafa_Mohamed

Working now with the following:

update dm_group objects append users_names = (select user_name FROM dm_user where user_name in (select c_enf_disp_assined_off from cma_enf_case_dis_doc where object_name ='2012-AUG-1033')) where group_name = 'case'

"ALTER not supported in DQL Write"