| Author | 
		  Message
		 | 
		
		  | ptazbaz | 
		  
		    
			  
				 Posted: Thu Dec 05, 2002 12:49 pm    Post subject: [Solved]DELETE PERSON | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 23 May 2002 Posts: 29
  
  | 
		  
		    
			  
				Does anyone know of a way to do a mass delete on persons using a wildcard?  I have 300 persons defined with the prefix 'SUP_'. Is there a way I can say something like:
 
 
DELETE PERSON SUP_*
 
 
rather than having to write 300 delete statements.
 
 
Any input is much appreciated.
 
 
Regards,
 
 
Paul Tazbaz | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jmac | 
		  
		    
			  
				 Posted: Thu Dec 05, 2002 3:10 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC 
  | 
		  
		    
			  
				Paul:
 
 
I dont believe that can be done. _________________ John McDonald
 
RETIRED | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | educos | 
		  
		    
			  
				 Posted: Fri Jan 03, 2003 12:37 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 18 Jul 2001 Posts: 34 Location: Salt Lake City, UT 
  | 
		  
		    
			  
				Paul,
 
If you have the workflow staffing API (which I believe you do if you're using the User Admin facility), I think you should be able to delete these users programmatically, using a wildcard... _________________ Eric Ducos
 
 
EmeriCon, LLC.
 
Phone: (801) 789-4348
 
e-Mail: Eric.Ducos@EmeriCon.com
 
Website: www.EmeriCon.com | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | vennela | 
		  
		    
			  
				 Posted: Fri Jan 03, 2003 1:03 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 11 Aug 2002 Posts: 4055 Location: Hyderabad, India 
  | 
		  
		    
			  
				What is 
 
workflow staffing API 
 
and 
 
User Admin facility
 
 
Are these some kind of third party tools or are they native IBM MQWF APIs. 
 
 
---
 
Venny | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | praveenchhangani | 
		  
		    
			  
				 Posted: Fri Jan 03, 2003 1:05 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Disciple
 
 Joined: 20 Sep 2002 Posts: 192 Location: Chicago, IL 
  | 
		  
		    
			  
				Ptazbaz, Educos:
 
 
I agree with John in that there isn't perhaps a way to achieve this in workflow.  Think about from a different perspective though, even if there was such a utility or command, it would be almost a nightmare keeping your buildtime and runtime environment synchronized.
 
 
This is probably not a hard thing for IBM to come up with, but I think reasons like the above is why they don't do it.
 
 
Praveen _________________ Praveen K. Chhangani,
 
 
IBM Certified Solutions Designer - 
 
MQ Workflow 3.4. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | educos | 
		  
		    
			  
				 Posted: Fri Jan 03, 2003 1:19 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Apprentice
 
 Joined: 18 Jul 2001 Posts: 34 Location: Salt Lake City, UT 
  | 
		  
		    
			  
				Venny,
 
Yes, those are 3rd party tools. You can PM me if you'd like more info. _________________ Eric Ducos
 
 
EmeriCon, LLC.
 
Phone: (801) 789-4348
 
e-Mail: Eric.Ducos@EmeriCon.com
 
Website: www.EmeriCon.com | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | praveenchhangani | 
		  
		    
			  
				 Posted: Fri Jan 03, 2003 1:21 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Disciple
 
 Joined: 20 Sep 2002 Posts: 192 Location: Chicago, IL 
  | 
		  
		    
			  
				Folks,
 
    I forgot to mention that....if perhaps there is a neat way to achieve this and someone has indeed tried it successfully, please do let me know.
 
 
Thanks,Praveen _________________ Praveen K. Chhangani,
 
 
IBM Certified Solutions Designer - 
 
MQ Workflow 3.4. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |