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

[Waldie, Shawn]

In this case, you may want to explore the MV.ORIENTATION VERTICAL
option.
 
-----Original Message-----
From: Keith Johnson [mailto:KJohnson at lcsc.edu] 
Sent: Tuesday, November 18, 2003 3:00 PM
To: download-list at cedarville.edu
Subject: [Download-List] RE: repeating data question (by.exp)



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/5d722398/attachment.html>