[Download-List] RE: repeating data question (by.exp)

[Keith Johnson]

PS:
Does anyone know how to use download BY.EXP but suppress the repeated
non-multivalue data?
Example:

 	PU.ADMIN	 	
Amy A. Mayer, IT staff	 	DG95	
Amy A. Mayer, IT staff	 	DG96	
Bev D. Hill	 	ST.ADMIN.CNIN	
Bev D. Hill	 	BUD.ADMIN.2	
Bev D. Hill	 	GL.ADMIN	
Bev D. Hill	 	AP.ADMIN	


Would look like this:
 	PU.ADMIN	 	
Amy A. Mayer, IT staff	 	DG95	
 	 	DG96	
Bev D. Hill	 	ST.ADMIN.CNIN	
 	 	BUD.ADMIN.2	
 	 	GL.ADMIN	
 	 	AP.ADMIN	

If it helps this is my base work...
SSELECT UT.OPERS BY SYS.USER.NAME WITH SYS.USER.CLASSES LIKE ...ADMIN...
OR WITH SYS.USER.CLASSES LIKE ''
DOWNLOAD UT.OPERS \
@ID COL.HDG "Datatel loginID"\
SYS.USER.NAME COL.HDG "User Name" \
EVAL "IF SYS.USER.CLASSES EQ '' THEN 'Power' ELSE ''" COL.HDG "Power
User; All Screens except Privileged (Admin)" \
BY.EXP SYS.USER.CLASSES SYS.USER.CLASSES \
HEADING FIELD.NAMES @DATE CONV "D4/" \
FILE _HOLD_ UT.OPERS.HTM FORMAT HTML OVERWRITING

Or this:

SSELECT UT.OPERS BY SYS.USER.NAME WITH SYS.USER.CLASSES LIKE ...ADMIN...
OR WITH SYS.USER.CLASSES LIKE ''
DOWNLOAD UT.OPERS \
@ID COL.HDG "Datatel loginID"\
SYS.USER.NAME COL.HDG "User Name" \
EVAL "IF SYS.USER.CLASSES EQ '' THEN 'Power' ELSE ''" COL.HDG "Power
User; All Screens except Privileged (Admin)" \
SYS.USER.CLASSES NUM.VALUES ALL\
HEADING FIELD.NAMES @DATE CONV "D4/" \
FILE _HOLD_ UT.OPERS.HTM FORMAT HTML OVERWRITING

Keith Johnson
UNIX Systems Administrator
Programmer / Analyst
Lewis-Clark State College
208.792.2510


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20031118/4515bed5/attachment.html>