RE: [U2] default sort order
I see that you can edit DICT.DICT with some response on this but you can do like I do here: :AE VOC DW.DICT Top of DW.DICT in VOC, 3 lines, 616 characters. 001: PA 002: * David Wademan custom DICT lookup for 132 character mode * 003: LIST DICT I2,FILENAME ID.SUP DBL.SPC @ID FMT 32L TYP LOC FMT 50L CONV FMT 6L MNAME FORMAT FMT 4L COL.HDG FMT SM F MT 3L COL.HDG SM ASSOC BY TYP BY LOC BY @ID C3,ARG3 C4,ARG4 C5,ARG5 C6,ARG6 C7,ARG7 C8,ARG8 C9,ARG9 C10,ARG10 C11,ARG11 C12,ARG12 C13,ARG13 C14,ARG14 C15,ARG15 C16,ARG16 C17,ARG17 C18,ARG18 C19,ARG19 C20,ARG20 C21,ARG21 C22,ARG22 C23,ARG23 C24,ARG24 C25,ARG25 C26,ARG26 C27,ARG27 C28,ARG28 C29,ARG29 C30,ARG30 Then you can type: DW.DICT MY.FILE.NAME -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, May 19, 2009 9:32 PM To: u2-users@listserver.u2ug.org Subject: [U2] default sort order Where is it in Unidata that you can enter a record named @ that will affect the default sort order of the Dictionary for a file? I thought it was MD, but that is not effective. What I thought worked is you could make a record like so: @ 1: PH 2: BY @ID I know I have used it before, but I cannot find it now. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] default sort order
DAVID WADEMAN wrote: I see that you can edit DICT.DICT with some response on this but you can do like I do here: :AE VOC DW.DICT Top of DW.DICT in VOC, 3 lines, 616 characters. 001: PA 002: * David Wademan custom DICT lookup for 132 character mode * 003: LIST DICT I2,FILENAME ID.SUP DBL.SPC @ID FMT 32L TYP LOC FMT 50L CONV FMT 6L MNAME FORMAT FMT 4L COL.HDG FMT SM F MT 3L COL.HDG SM ASSOC BY TYP BY LOC BY @ID C3,ARG3 C4,ARG4 C5,ARG5 C6,ARG6 C7,ARG7 C8,ARG8 C9,ARG9 C10,ARG10 C11,ARG11 C12,ARG12 C13,ARG13 C14,ARG14 C15,ARG15 C16,ARG16 C17,ARG17 C18,ARG18 C19,ARG19 C20,ARG20 C21,ARG21 C22,ARG22 C23,ARG23 C24,ARG24 C25,ARG25 C26,ARG26 C27,ARG27 C28,ARG28 C29,ARG29 C30,ARG30 Then you can type: DW.DICT MY.FILE.NAME That is pretty cool. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] default sort order
I'm on UV not UD but I checked and what I needed to do was: @ 001: PH 002: (space)BY @ID I needed the first BY, so don't get rid of it. But do put in a preceeding space. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, May 20, 2009 9:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] default sort order get rid of the first BY, it is assumed. (just include the field names) @ 001: PH 002: LAST-NAME BY NAME BY @ID @ 001: PH 002: @ID -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, May 19, 2009 10:43 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] default sort order Ron Hutchings wrote: ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] default sort order
Where is it in Unidata that you can enter a record named @ that will affect the default sort order of the Dictionary for a file? I thought it was MD, but that is not effective. What I thought worked is you could make a record like so: @ 1: PH 2: BY @ID I know I have used it before, but I cannot find it now. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] default sort order
ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Date: Tue, 19 May 2009 21:31:31 -0400 From: slestak...@gmail.com To: u2-users@listserver.u2ug.org Subject: [U2] default sort order Where is it in Unidata that you can enter a record named @ that will affect the default sort order of the Dictionary for a file? I thought it was MD, but that is not effective. What I thought worked is you could make a record like so: @ 1: PH 2: BY @ID I know I have used it before, but I cannot find it now. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Insert movie times and more without leaving Hotmail.. http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutoria l_QuickAdd1_052009 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] default sort order
Ron Hutchings wrote: ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] default sort order
If you're talking about LIST DICT filename and getting the dictionary items listed by @ID (instead of the default field number order) then you need to edit the @-phrase in DICT.DICT - see the long LIST DICT.DICT thread from a couple of days ago for more details. You'll find that an @ phrase already exists in DICT.DICT (the default one in Universe includes BY FIELD.NO). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, 20 May 2009 10:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] default sort order Ron Hutchings wrote: ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] default sort order
Womack, Adrian wrote: If you're talking about LIST DICT filename and getting the dictionary items listed by @ID (instead of the default field number order) then you need to edit the @-phrase in DICT.DICT - see the long LIST DICT.DICT thread from a couple of days ago for more details. You'll find that an @ phrase already exists in DICT.DICT (the default one in Universe includes BY FIELD.NO). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, 20 May 2009 10:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] default sort order Ron Hutchings wrote: ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ That thread from last week is what actually jarred my memory to look for this again. We use SB+ sp we have a ton of BI in the dictionaries so sorting the DICTS is what I am after. I tried editing DICT.DICT with AE, but it reported that FI has been disabled. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] default sort order
Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. Are you running with ECLTYPE P? Try it with ECLTYPE U. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] default sort order
That would most likely because you only have read privileges for DICT.DICT as your current user. (Or DICT.DICT is read-only, whatever is applicable) That thread from last week is what actually jarred my memory to look for this again. We use SB+ sp we have a ton of BI in the dictionaries so sorting the DICTS is what I am after. I tried editing DICT.DICT with AE, but it reported that FI has been disabled. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] default sort order
Timothy Snyder wrote: Are you running with ECLTYPE P? Try it with ECLTYPE U. Yes, we are using a Pick flavored account. I will try tomorrow --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
