[U2] UniData to UniVerse Translation??
In UNIDATA, I can type this query: LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME WITH EVERY DOODAD # AAA (Unidata Flavor) This would show me the items where **no** value in the Multivalue DOODAD Attribute is AAA -- How do I achieve the same WITH EACH command work in UniVerse? When I type the command I get: RetrieVe: syntax error. Unexpected explicit item id. Token was EACH When I try LIST FILENAME WITH EVERY DOODAD # AAA -- it runs, but returns items that have AAA in them. I need to pull the UniVerse document from IBM's website, but thought I'd ask while it crawls down... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData to UniVerse Translation??
Hi David You probably want to look at BY.EXP and WHEN for dealing with multivalues in UniVerse Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData to UniVerse Translation??
Try: LIST FILENAME WITHOUT EVERY DOODADD = AAA This also allows you to list the excluded items, eg AAABBB HTH Brett David Wolverton [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... In UNIDATA, I can type this query: LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME WITH EVERY DOODAD # AAA (Unidata Flavor) This would show me the items where **no** value in the Multivalue DOODAD Attribute is AAA -- How do I achieve the same WITH EACH command work in UniVerse? When I type the command I get: RetrieVe: syntax error. Unexpected explicit item id. Token was EACH When I try LIST FILENAME WITH EVERY DOODAD # AAA -- it runs, but returns items that have AAA in them. I need to pull the UniVerse document from IBM's website, but thought I'd ask while it crawls down... David W. --- 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] Possible Employment
We may have an opportunity for a suitable U2 A/P to come and support our existing systems for 18 months or so and then be cross trained to .Net C# SQL and various other whizzy new technologies ahead of some major development work. Anyone interested (we are in Hampshire UK) email me ([EMAIL PROTECTED]) off list please We are only interested in people not agencies its an chance for someone if they would like it (subject to all the usual and management not changing their minds) Bob __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData to UniVerse Translation??
I believe the Prime Information version of UniVerse acts like you'd expect. The Pick version is like Prime Information with one hand tied behind its back. -- Louie Some cause happiness wherever they go; others whenever they go. - Oscar Wilde, 1854 - 1900 (from www.qotd.org) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] Over-coming EDitor shortcomings
Just to say my 2 pennies on that one - personally I much prefer Wintegrate to Accuterm - Accuterm from the word go feels like an old vb 5 product - the splash screen is straight out of the nineties, it all feels dare I say very American :o . Wintegrate seems to have a much more modern approach, look and feel and has some very exciting features released every year. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: 16 October 2007 00:33 To: u2-users@listserver.u2ug.org Subject: Re: Re[2]: [U2] Over-coming EDitor shortcomings What is WINE and is it a MV item or a non MV item. I use Accuterm as a wonderful cross-platform Windows-based Notepad style editor for Data/basic programs. Programs come alive when compared to over 25 years of EDIT or other 80x24 screen editors. Just being able to see 60 lines of code with color syntax highlighting is worth the price alone. The very popular MS commands are welcome. Oddly enough, WED is a derivative of the original MS EDIT that was very welcome compared to EDLIN. I am a strong proponent of WED and its Graphical development environment and it's a very good emulator. Please elaborate on your not knowing why anyone would use Accuterm. Those are pretty strong words against one of the most prevelant emulators in the MV world. I may have not used every emulator, especially the freeware ones that pop up on the internet. But I have worked with probably 10 emulators on MV-based systems and Accuterm kills them all, even Wintegrate. My 2 cents. Mark Johnson - Original Message - From: David Tod Sigafoos [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 15, 2007 1:43 PM Subject: Re[2]: [U2] Over-coming EDitor shortcomings MAJ, Does Accuterm work under WINE (though not sure why anyone would want to use Accuterm G) Monday, October 15, 2007, 6:07:04 AM, you wrote: SNIP MP I don't argue the stability or anything supporting the use of unix as a MP desktop OS. But in this case, it loses if it cannot use Accuterm. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- 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/
Re: [U2] [UV] Using VI instead of ED for EDIT-LIST
I create VOC pointers: PH for PH SL for SAVEDLISTS CO for COMO HO for HOLD On 10/11/07, Ron Hutchings [EMAIL PROTECTED] wrote: The sites I've been around someone creates a voc pointer to SAVEDLISTS named SVL or SLV to save keystrokes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Re[2]: [U2] Over-coming EDitor shortcomings
Have you tried Accuterm's WED (windows editor) or GED (Graphical design environment) or are you just comparing it as an emulator. I did a comparison between Accuterm Wintegrate 2 years ago for a client and Accuterm won hands down. Plus, despite the features winning, the price was phenomonal. $1000 for 50 licenses for Accuterm versus $200 each for Wintegrate. That's a factor of 10 times more expensive. My 20 cents. Mark Johnson - Original Message - From: Symeon Breen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, October 16, 2007 6:21 AM Subject: RE: Re[2]: [U2] Over-coming EDitor shortcomings Just to say my 2 pennies on that one - personally I much prefer Wintegrate to Accuterm - Accuterm from the word go feels like an old vb 5 product - the splash screen is straight out of the nineties, it all feels dare I say very American :o . Wintegrate seems to have a much more modern approach, look and feel and has some very exciting features released every year. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: 16 October 2007 00:33 To: u2-users@listserver.u2ug.org Subject: Re: Re[2]: [U2] Over-coming EDitor shortcomings What is WINE and is it a MV item or a non MV item. I use Accuterm as a wonderful cross-platform Windows-based Notepad style editor for Data/basic programs. Programs come alive when compared to over 25 years of EDIT or other 80x24 screen editors. Just being able to see 60 lines of code with color syntax highlighting is worth the price alone. The very popular MS commands are welcome. Oddly enough, WED is a derivative of the original MS EDIT that was very welcome compared to EDLIN. I am a strong proponent of WED and its Graphical development environment and it's a very good emulator. Please elaborate on your not knowing why anyone would use Accuterm. Those are pretty strong words against one of the most prevelant emulators in the MV world. I may have not used every emulator, especially the freeware ones that pop up on the internet. But I have worked with probably 10 emulators on MV-based systems and Accuterm kills them all, even Wintegrate. My 2 cents. Mark Johnson - Original Message - From: David Tod Sigafoos [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 15, 2007 1:43 PM Subject: Re[2]: [U2] Over-coming EDitor shortcomings MAJ, Does Accuterm work under WINE (though not sure why anyone would want to use Accuterm G) Monday, October 15, 2007, 6:07:04 AM, you wrote: SNIP MP I don't argue the stability or anything supporting the use of unix as a MP desktop OS. But in this case, it loses if it cannot use Accuterm. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Re[2]: [U2] Over-coming EDitor shortcomings
Is anyone using Accuterm in the Unidata environment (7.1)? I downloaded an evaluation. The terminal emulation works OK, but when I try to start the wED, I get this message At ECL the computer complains about FTTCL not being a verb. I emailed Accuterm support, but have gotten no response. Charles Shaffer Senior Analyst NTN-Bower Corporation David Tod Sigafoos [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2007 12:43 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re[2]: [U2] Over-coming EDitor shortcomings MAJ, Does Accuterm work under WINE (though not sure why anyone would want to use Accuterm G) Monday, October 15, 2007, 6:07:04 AM, you wrote: SNIP MP I don't argue the stability or anything supporting the use of unix as a MP desktop OS. But in this case, it loses if it cannot use Accuterm. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Using connection pooling with Uniobjects
Where I work, we have recently installed Universe 10.2.25 which is supposed to have the connection pooling functionnality for webservices. Is the connection pooling option just something to turn on in Universe options or must a new version of Uniobjects dll be used ? We use version 1.1.7073.0 with dot net 2003. If we need to use a new version of Uniobjects, will it work with the framework of dot net 2003 or is an upgrade to 2005 necessary ? Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV. http://tv.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Re[2]: [U2] Over-coming EDitor shortcomings
Praise the Lord there are plenty of emulators to choose from. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Over-coming EDitor shortcomings
This is shifting into a less technical zone, so I am going to ask you to move it to community. Also, *Please, Please, Please* remember to trim quotes when responding. Apparently people are filtering out messages from the moderator, because this topic won't die and people insist on including the entire posting history with each message. Maybe if it comes from somebody besides the moderator they'll see it. 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] UniData to UniVerse Translation??
David, LIST FILENAME WITHOUT DOODADD # AAA David Wolverton wrote: In UNIDATA, I can type this query: LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME WITH EVERY DOODAD # AAA (Unidata Flavor) This would show me the items where **no** value in the Multivalue DOODAD Attribute is AAA -- How do I achieve the same WITH EACH command work in UniVerse? When I type the command I get: RetrieVe: syntax error. Unexpected explicit item id. Token was EACH When I try LIST FILENAME WITH EVERY DOODAD # AAA -- it runs, but returns items that have AAA in them. I need to pull the UniVerse document from IBM's website, but thought I'd ask while it crawls down... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- - Charles Barouch [EMAIL PROTECTED] Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData to UniVerse Translation??
In UniData, I like using this statement for extraction: LIST FILENAME WITH NOT(DOODADD EQ AAA) There was something with negative extractions and that you need to watch out for (forgot - UniData 6.x???) but using the NOT statement cleared that problem. IDK how to this statement in UniVerse but try that. Also, the EVERY keyword (in UniData) means that every multivalve must have that same value. So if I say (in UniData): LIST FILENAME WITH EVERY DOODADD EQ AAA DOODADD THIS RECORD COUNTS: 001 AAA AAA AAA THIS RECORD WILL NOT COUNT 002 AAA AAA BBB AAA -- EVERY Syntax ...EVERY selection_criteria Description The UniQuery EVERY keyword retrieves only those records where every value exactly meets the selection_criteria. Without the EVERY keyword, UniQuery returns all values from a record if one or more values meet the selection_criteria. Note: UniQuery supports the EVERY keyword in ECLTYPE U only. In ECLTYPE P, use the EACH keyword. Bloomfield College David Wademan Senior DB Programmer / System Analyst [EMAIL PROTECTED] 467 Franklin Street ITS- Knox Hall 3rd Fl. Bloomfield, NJ 07003 tel: 973-748-9000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Tuesday, October 16, 2007 11:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData to UniVerse Translation?? David, LIST FILENAME WITHOUT DOODADD # AAA David Wolverton wrote: In UNIDATA, I can type this query: LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME WITH EVERY DOODAD # AAA (Unidata Flavor) This would show me the items where **no** value in the Multivalue DOODAD Attribute is AAA -- How do I achieve the same WITH EACH command work in UniVerse? When I type the command I get: RetrieVe: syntax error. Unexpected explicit item id. Token was EACH When I try LIST FILENAME WITH EVERY DOODAD # AAA -- it runs, but returns items that have AAA in them. I need to pull the UniVerse document from IBM's website, but thought I'd ask while it crawls down... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- - Charles Barouch [EMAIL PROTECTED] Consulting --- 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: Re[2]: [U2] Over-coming EDitor shortcomings
Charles, I have used Accuterm in 7.1 since its release and before that 6.1. It sounds like you did not get a good install. Make sure you have the latest install programs - my Accuterm version is 5.3.131. I think I download the latest when I first installed. Also, did you type BASICTYPE P at TCL - I mean ECL before you started your install. I am sure if you call Peter he will get you started quickly. Accuterm is the best - I and other developers I work with have used it for at least 15 years. george -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 9:00 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: Re[2]: [U2] Over-coming EDitor shortcomings Is anyone using Accuterm in the Unidata environment (7.1)? I downloaded an evaluation. The terminal emulation works OK, but when I try to start the wED, I get this message At ECL the computer complains about FTTCL not being a verb. I emailed Accuterm support, but have gotten no response. Charles Shaffer Senior Analyst NTN-Bower Corporation David Tod Sigafoos [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2007 12:43 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re[2]: [U2] Over-coming EDitor shortcomings MAJ, Does Accuterm work under WINE (though not sure why anyone would want to use Accuterm G) Monday, October 15, 2007, 6:07:04 AM, you wrote: SNIP MP I don't argue the stability or anything supporting the use of unix as a MP desktop OS. But in this case, it loses if it cannot use Accuterm. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif] --- 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] Over-coming EDitor shortcomings
Charles, There is software you have to install into UniData before WED or GED will work. Check the AccuTerm website for details. If you are still stuck, e-mail me and I'll get you the instructions. - Chuck [EMAIL PROTECTED] wrote: Is anyone using Accuterm in the Unidata environment (7.1)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Size of Key Question
_ From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 12:17 PM To: 'u2-users@listserver.u2ug.org' Subject: Size of Key Question Can someone comment on what effect if any the length of the key has on the speed of disk access? The software I am working with has one file with a complex key of 64 alpha-numeric characters and that file seems to be very slow no matter the modulo and sep or even file type I choose. This is in UV 10.2 Pick Flavor on AIX 5.3 Any insight would be appreciated. Thanks, Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] Over-coming EDitor shortcomings
The latest release is 5.3c (5.3.304), I just downloaded it Friday. Brenda -Original Message- From: George R Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 10:40 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: Re[2]: [U2] Over-coming EDitor shortcomings Charles, I have used Accuterm in 7.1 since its release and before that 6.1. It sounds like you did not get a good install. Make sure you have the latest install programs - my Accuterm version is 5.3.131. I think I download the latest when I first installed. Also, did you type BASICTYPE P at TCL - I mean ECL before you started your install. I am sure if you call Peter he will get you started quickly. Accuterm is the best - I and other developers I work with have used it for at least 15 years. george -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 9:00 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: Re[2]: [U2] Over-coming EDitor shortcomings Is anyone using Accuterm in the Unidata environment (7.1)? I downloaded an evaluation. The terminal emulation works OK, but when I try to start the wED, I get this message At ECL the computer complains about FTTCL not being a verb. I emailed Accuterm support, but have gotten no response. Charles Shaffer Senior Analyst NTN-Bower Corporation David Tod Sigafoos [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2007 12:43 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re[2]: [U2] Over-coming EDitor shortcomings MAJ, Does Accuterm work under WINE (though not sure why anyone would want to use Accuterm G) Monday, October 15, 2007, 6:07:04 AM, you wrote: SNIP MP I don't argue the stability or anything supporting the use of unix as a MP desktop OS. But in this case, it loses if it cannot use Accuterm. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif] --- 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/
RE: [U2] Size of Key Question
I wouldn't expect much difference in file access speed with long record keys versus short keys. What are you doing with the file that seems slow? -- i.e. random reads of individual records, updates, sequential selects and processing, etc. If the slowness is seen in an application program, are there other possibilities? Does the file have alternate keys or associated files that might be causing the slowness? Could locking be a bottleneck? Just for grins it would be interesting to see a FILE.STAT on the file. Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 12:17 PM To: 'u2-users@listserver.u2ug.org' Subject: Size of Key Question Can someone comment on what effect if any the length of the key has on the speed of disk access? The software I am working with has one file with a complex key of 64 alpha-numeric characters and that file seems to be very slow no matter the modulo and sep or even file type I choose. This is in UV 10.2 Pick Flavor on AIX 5.3 Any insight would be appreciated. Thanks, Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- 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] LIST DICT F11
I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Size of Key Question
Random reads and updates on a file with ~2 million records. I separated the reads and writes to a separate program that only does this processing to no avail. Topas shows 100% disk usage during this process and all other users are affected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Tuesday, October 16, 2007 1:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question I wouldn't expect much difference in file access speed with long record keys versus short keys. What are you doing with the file that seems slow? -- i.e. random reads of individual records, updates, sequential selects and processing, etc. If the slowness is seen in an application program, are there other possibilities? Does the file have alternate keys or associated files that might be causing the slowness? Could locking be a bottleneck? Just for grins it would be interesting to see a FILE.STAT on the file. Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 12:17 PM To: 'u2-users@listserver.u2ug.org' Subject: Size of Key Question Can someone comment on what effect if any the length of the key has on the speed of disk access? The software I am working with has one file with a complex key of 64 alpha-numeric characters and that file seems to be very slow no matter the modulo and sep or even file type I choose. This is in UV 10.2 Pick Flavor on AIX 5.3 Any insight would be appreciated. Thanks, Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- 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/
RE: [U2] LIST DICT F11
Is F11 in the VOC ? You may need to create it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 1:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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] LIST DICT F11
ED VOC Record name = F1 6 lines long. : SAVE F11 F11 filed in file VOC. : Q File name= VOC Record name = F11 6 lines long. : 0001: D : 0002: 1 : R 11 0002: 11 : FI F11 filed in file VOC. Brutzman, Bill wrote: I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST DICT F11
ED VOC F11 Brutzman, Bill wrote: I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Over-coming EDitor shortcomings
From what I can see this is technical discussion about interfacing with U2. -Original Message- From: Timothy Snyder [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Over-coming EDitor shortcomings This is shifting into a less technical zone, so I am going to ask you to move it to community. Also, *Please, Please, Please* remember to trim quotes when responding. Apparently people are filtering out messages from the moderator, because this topic won't die and people insist on including the entire posting history with each message. Maybe if it comes from somebody besides the moderator they'll see it. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT F11
Are you on Universe? If so, the F1 etc records need to exist in VOC (not DICT VOC - just VOC) to be accessible in all list commands. Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 10:23 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion.. Column. OutputDepth Name..NumberDefinition...Code Heading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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] LIST DICT F11
Good answer. F11 was NOT in the VOC. The others... F2 thru F10 were IN the VOC. Thanks. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of roy Sent: Tuesday, October 16, 2007 1:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] LIST DICT F11 Is F11 in the VOC ? You may need to create it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 1:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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/
Re: [U2] Size of Key Question
and the FILE.STAT? On 10/16/07, roy [EMAIL PROTECTED] wrote: Random reads and updates on a file with ~2 million records. I separated the reads and writes to a separate program that only does this processing to no avail. Topas shows 100% disk usage during this process and all other users are affected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Tuesday, October 16, 2007 1:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question I wouldn't expect much difference in file access speed with long record keys versus short keys. What are you doing with the file that seems slow? -- i.e. random reads of individual records, updates, sequential selects and processing, etc. If the slowness is seen in an application program, are there other possibilities? Does the file have alternate keys or associated files that might be causing the slowness? Could locking be a bottleneck? Just for grins it would be interesting to see a FILE.STAT on the file. Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 12:17 PM To: 'u2-users@listserver.u2ug.org' Subject: Size of Key Question Can someone comment on what effect if any the length of the key has on the speed of disk access? The software I am working with has one file with a complex key of 64 alpha-numeric characters and that file seems to be very slow no matter the modulo and sep or even file type I choose. This is in UV 10.2 Pick Flavor on AIX 5.3 Any insight would be appreciated. Thanks, Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- 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/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT F11
list EPT.XREF EVAL CONVERT(@FM,@VM,@RECORD) (unidata) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Tuesday, October 16, 2007 1:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] LIST DICT F11 Is F11 in the VOC ? You may need to create it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 1:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion.. Column. OutputDepth Name..NumberDefinition...Code Heading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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/
RE: [U2] LIST DICT F11
To see the data unformatted use LIST-ITEM EPT.XREF. -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 10:23 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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] LIST DICT F11
LIST.ITEM and SELECT * FROM can also be useful for qdirty. On 10/16/07, roy [EMAIL PROTECTED] wrote: Is F11 in the VOC ? You may need to create it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 1:23 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 I came across a labor data file which I can perform the command... LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 EPT.XREF. 1-82613 (Work.Order.ID) F1... 11231*215 (Date*Employee.ID) F2... 11236*349 F3... 11239*214 F4... 11240*214 F5... 11245*354 F6... 11246*214 F7... 10974*214 F8... 11247*354 F9... 11251*214 F10.. 11252*214 *--- -- If I try F11, F12, etc... LIST EPT.XREF F11 0 records listed. F11 not found. *--- --- The data dictionary is sparse... LIST DICT EPT.XREF yields... DICT EPT.XREF13:12:32 10-16-07 Page 1 Type Field.Field.FieldConversion..Column. OutputDepth Name..NumberDefinition...CodeHeading FormatAssoc.. @ID D0 EPT.XREF 10L S ID.LIST D1 ID.LIST 10L S ID.LIST.2 D2 ID.LIST 10L S 3 records listed. *--- -- It appears that this cross-reference file just appends work order numbers. In the dictionary, I can explicitly define the eleventh field and then see the data. Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- 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/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT F11
CT VOC F1 will show you the format of the items you need to add to the voc to create more of these for your needs. You could just write a small program to add a couple hundred of them and be done with it forever *=aee=* -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Tuesday, October 16, 2007 10:23 To: 'u2-users@listserver.u2ug.org' Subject: [U2] LIST DICT F11 snip Is there a way to list the data with with something like an F11 shortcut? Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ITYPE question
It MAY be the case that there are 'unexpected' data types, in one, possibly even two of our files. Occasionally (maybe 100 times per second), a PHANTOM executed ITYPE will cause a message to be written to the errlog, stating: Tue Oct 16 07:14:53 0 user name Program .ITYPE.: pc = 38, Message[040025] I especially like the 'pc = 38' part... which translated of course means 'nonnumeric where numeric required...' We can find these because we have other tools in place to associate an error with a time of execution, but is there a(n) easy way to see the errant EXECUTED TCL statement as an alternative to being taunted by the error message? -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Size of Key Question
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Tuesday, October 16, 2007 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Size of Key Question and the FILE.STAT? File name = SALES-HIST-BR1 File type = 18 Number of groups in file (modulo) = 317 Separation = 1 Number of records = 883026 Number of physical bytes= 1667799040 Number of data bytes= 150663032 Average number of records per group = 0.2943 Average number of bytes per group = 50.2207 Minimum number of records in a group= 0 Maximum number of records in a group= 7417 Average number of bytes per record = 170.6213 Minimum number of bytes in a record = 64 Maximum number of bytes in a record = 2644 Average number of fields per record = 25.6579 Minimum number of fields per record = 11 Maximum number of fields per record = 41 Groups 25% 50% 75%100%125%150%175%200% full 2855826 50132 31541 14753 1286253834611 24909 Press any key to continue... On 10/16/07, roy [EMAIL PROTECTED] wrote: Random reads and updates on a file with ~2 million records. I separated the reads and writes to a separate program that only does this processing to no avail. Topas shows 100% disk usage during this process and all other users are affected. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Over-coming EDitor shortcomings
From what I can see this is technical discussion about interfacing with U2. OK - granted. But what about over-quoting? People are reminded about this on a regular basis, and sometimes a special mention is made, as in this case. Still they continue to include the entire history. 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/
[U2] ReadListAsStringArray Returns Nothing
Using VB.NET (VS2005) with Uniobjects (IBMU2.UODOTNET) The following code works fine, except when the select returns a list with ONE item. * Public Function T4mGetSelectList(ByVal strCommand As String) As String() Dim ECMD As UniCommand = Nothing Dim slAP As UniSelectList = Nothing Try ' Select list ECMD = sess.CreateUniCommand() ECMD.Command = strCommand TO 0 ECMD.Execute() slAP = sess.CreateUniSelectList(0) -- This is where the problem occurs T4mGetSelectList = slAP.ReadListAsStringArray * When the select finds one item, the ReadListAsStringArray returns Nothing. When the select finds more than one item, the correct number of items is returned. This has been verified by comparing to ECL selects. Does ReadListAsStringArray have a problem with arrays of one? Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Over-coming EDitor shortcomings
Some of us work for a living glancing at the emails offering help if we can. In our haste we sometimes don't notice that the email has grown in size. This is also one reason that I don't like in-line remarks. If I don't see what they want at the top I delete it. Jerry -Original Message- From: Timothy Snyder [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 3:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Over-coming EDitor shortcomings From what I can see this is technical discussion about interfacing with U2. OK - granted. But what about over-quoting? People are reminded about this on a regular basis, and sometimes a special mention is made, as in this case. Still they continue to include the entire history. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Size of Key Question
In general, the main problem with large, compound keys is that said keys do not hash well; and by hash well I mean that they do not hash to proximate groups, as for example, sequential numeric keys would. There is read-ahead logic and RAM in your disk drive(s). There is read-ahead logic and RAM in your disk controller(s). There is read-ahead logic in the O/S. None of this works very well when records are randomly scattered throughout the file. If I used sequential, numeric keys, and I wanted all the records created yesterday, they would likely all be near each other on the physical disk. When I accessed the first one, the disk/controller/os will have pre-fetched many of the day's other records as well. That makes for speedy access. This is part of the reason why I think long, compound keys are a PITA and are to be avoided. Simple numeric keys will process quicker because they hash better, and are easier to type too. This is often the problem with intelligent keys; by embedding data in the key, you almost always make the key longer and the file hash poorly. IMO it makes way more sense to use simple numeric keys and create real attributes for the data you are tempted to build the key out of. I say this with 20/20 hindsight, as I have designed many systems with large files that use compound keys, every one of which I have come to regret. Roy, you could prove this by writing a program that reads every record in your original file and writes it out to a new file (with the same modulo sep as the original file) using a simple incrementing counter as the key. I will bet that the new file performs better than your original one does, even though it should have more attributes (necessary to accommodate the data values that were embedded in the key to the original file). My 0.02, /Scott Ballinger Pareto Corporation Edmonds, WA USA 206 713 6006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Timeout and the break key.
We are running UniData 7.1.10 on AIX 5.1. We set a TIMEOUT set for 1800 seconds in the LOGIN paragraph. If any user encounters a break condition, that condition seems to turn off the TIMEOUT requirements. We have attempted to use ONABORT to turn on the TIMEOUT but the re-setting does not seem to have any effect. We can disable the break key for the normal users and log them out if the hit an error conditions, but we want something to control the idle time associated with the developers as well. The developers need access to the break key. Has anyone else run into this situation and does anyone have a workaround? TIA Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Size of Key Question
This is a pretty ugly file! Here's what I see: 1) Modulo is way too big! 3 million groups for .9 million records; 1.6 GB physical space for 150 MB of data. Note the large number of empty groups in the 25% column at the bottom of the FILE.STAT report. Probably the modulo was pushed to TRY to make up for the really lousy hashing! More about this below in 2). 2) Lousy hashing distribution. Note 2.8 million empty and sparse groups in the 25% column; but at the same time 25,000 groups 200% + full. This isn't due to record size as the largest record is 2644 bytes. Note that the largest group has 7417 records - if all these were average size (Murphy says they aren't, though) that group would have 1.25 MB of data. Murphy also says that the most popular records live at the end of the largest group so there is your performance problem, quite likely -- tons of I/O required to get to the end of the large groups. What to do? Step 1 - See if another type will do a better job. Forget about HASH.HELP and forget about the key patterns documented for the various types -- yes, I know that type 18 should work best, but life isn't that simple. [AD] If you have FAST, use it. [/AD] If not, use HASH.AID to simulate the various types. In using HASH.AID I'd suggest picking a reasonable modulo, say around 200,001 or so. ** BIG NOTE ** This modulo choice is based on a separation of 4 which I'd recommend for a 2K data buffer -- if you want to stay with separation 1 use a modulo of 800,001 or so ** END BIG NOTE ** Before running HASH.AID clear the HASH.AID.FILE (CLEAR.FILE HASH.AID.FILE). Then use HASH.AID with your modulo and separation of choice and interate through all the available types -- syntax is HASH.AID SALES-HIST-BR1 and let it prompt you for the Type, Modulo and Separation; for Type enter 2,18,1 which is like FOR 1 TO 18, STEP 1. Don't bother reading the output, just enter N and let it scroll by. When it's all done use LIST HASH.AID.FILE to examine the results. Look for the type that yields the smallest Largest Group the fewest Oversize Groups and the closest together Smallest Group and Largest Group. If one of the types does a lot better than type 18 give it a try and see if it does better. Note that one flaw with HASH.AID is that it doesn't report empty groups (alas!). If you find a better type it may solve or help your problem. If not, Step 2 - Read the very helpful post by Scott Ballinger in which he notes that large, complex record keys sometimes don't hash well and could cause the sort of problem you are seeing. If none of the other file types do better than type 18 I'm afraid this is what you are facing. Were the file isolated the fix would be to move any important information carried by the record key into one or more fields and replace the compound record keys with sequential numeric, which as Scott notes, often hash more reliably. However, if the file is heavily embedded in the application software this might not be a trivial change to make! Hope this helps! Let us know how it turns out or if other questions arise... Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Tuesday, October 16, 2007 2:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question File name = SALES-HIST-BR1 File type = 18 Number of groups in file (modulo) = 317 Separation = 1 Number of records = 883026 Number of physical bytes= 1667799040 Number of data bytes= 150663032 Average number of records per group = 0.2943 Average number of bytes per group = 50.2207 Minimum number of records in a group= 0 Maximum number of records in a group= 7417 Average number of bytes per record = 170.6213 Minimum number of bytes in a record = 64 Maximum number of bytes in a record = 2644 Average number of fields per record = 25.6579 Minimum number of fields per record = 11 Maximum number of fields per record = 41 Groups 25% 50% 75%100%125%150%175%200% full 2855826 50132 31541 14753 1286253834611 24909 Press any key to continue... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Timeout and the break key.
Wow, that's bizarre. I was able to replicate it on 7.1.9 by logging on, setting the TIMEOUT, then starting SB+, then breaking, and the TIMEOUT is gone. However, if I login, set the timeout, do NOT start SB+, but then break and quit from TCL, the timeout is not lost. So next I wrote a quick 1-liner that does an input, ran it, broke it, and the timeout was cleared. So it apparently is not related to SB+. Very strange. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Size of Key Question
Yes (agreeing with Jeff on file sizing isn't a very reckless thing to do), except I'd stress this: don't use a seperation of 1. Go to 4, at least. If it turns out that a high percentage of the records are over 2K, then try a sep of 8. In certain cases, you may want to go to 16, but this isn't one of them. Never go above 16. Here's links to Mark Baldridge's series on the subject of file sizing. http://www.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-i.html http://www.ibm.com/developerworks/edu/dm-dw-dm-0603baldridge-i.html http://www.ibm.com/developerworks/edu/dm-dw-dm-0606baldridge-i.html http://www.ibm.com/developerworks/edu/dm-dw-dm-0611baldridge-i.html Registration is required, but free. Subject: RE: [U2] Size of Key Question Date: Tue, 16 Oct 2007 19:07:18 -0400 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org This is a pretty ugly file! Here's what I see: 1) Modulo is way too big! 3 million groups for .9 million records; 1.6 GB physical space for 150 MB of data. Note the large number of empty groups in the 25% column at the bottom of the FILE.STAT report. Probably the modulo was pushed to TRY to make up for the really lousy hashing! More about this below in 2). 2) Lousy hashing distribution. Note 2.8 million empty and sparse groups in the 25% column; but at the same time 25,000 groups 200% + full. This isn't due to record size as the largest record is 2644 bytes. Note that the largest group has 7417 records - if all these were average size (Murphy says they aren't, though) that group would have 1.25 MB of data. Murphy also says that the most popular records live at the end of the largest group so there is your performance problem, quite likely -- tons of I/O required to get to the end of the large groups. What to do? Step 1 - See if another type will do a better job. Forget about HASH.HELP and forget about the key patterns documented for the various types -- yes, I know that type 18 should work best, but life isn't that simple. [AD] If you have FAST, use it. [/AD] If not, use HASH.AID to simulate the various types. In using HASH.AID I'd suggest picking a reasonable modulo, say around 200,001 or so. ** BIG NOTE ** This modulo choice is based on a separation of 4 which I'd recommend for a 2K data buffer -- if you want to stay with separation 1 use a modulo of 800,001 or so ** END BIG NOTE ** Before running HASH.AID clear the HASH.AID.FILE (CLEAR.FILE HASH.AID.FILE). Then use HASH.AID with your modulo and separation of choice and interate through all the available types -- syntax is HASH.AID SALES-HIST-BR1 and let it prompt you for the Type, Modulo and Separation; for Type enter 2,18,1 which is like FOR 1 TO 18, STEP 1. Don't bother reading the output, just enter N and let it scroll by. When it's all done use LIST HASH.AID.FILE to examine the results. Look for the type that yields the smallest Largest Group the fewest Oversize Groups and the closest together Smallest Group and Largest Group. If one of the types does a lot better than type 18 give it a try and see if it does better. Note that one flaw with HASH.AID is that it doesn't report empty groups (alas!). If you find a better type it may solve or help your problem. If not, Step 2 - Read the very helpful post by Scott Ballinger in which he notes that large, complex record keys sometimes don't hash well and could cause the sort of problem you are seeing. If none of the other file types do better than type 18 I'm afraid this is what you are facing. Were the file isolated the fix would be to move any important information carried by the record key into one or more fields and replace the compound record keys with sequential numeric, which as Scott notes, often hash more reliably. However, if the file is heavily embedded in the application software this might not be a trivial change to make! Hope this helps! Let us know how it turns out or if other questions arise... Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roy Sent: Tuesday, October 16, 2007 2:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question File name = SALES-HIST-BR1 File type = 18 Number of groups in file (modulo) = 317 Separation = 1 Number of records = 883026 Number of physical bytes = 1667799040 Number of data bytes = 150663032 Average number of records per group = 0.2943 Average number of bytes per group = 50.2207 Minimum number of records in a group = 0 Maximum number of records in a group = 7417 Average number of bytes per record = 170.6213 Minimum number of bytes in a record = 64 Maximum number of bytes in a record = 2644 Average number of fields per record = 25.6579 Minimum number of fields per record = 11 Maximum number of fields per record = 41 Groups 25% 50% 75% 100% 125% 150% 175% 200% full 2855826 50132 31541 14753 12862 5383 4611 24909 Press any key to continue... --- u2-users mailing list
RE: [U2] Size of Key Question
Jeff F. will certainly have better critique, but it appears that the key structure and hash-algorithm aren't very well suited to each other. You have 883,026 records in 3,000,017 groups, and one of the groups has 7,417 records in it, so you have at least 2,124,407 empty groups. I believe every disk sold in the last 5 or more years reads at least 4 frames at a time, so a separation of 4 (or 8, etc.) will likely improve speed as well. The fact that you have over 8% of 883,026 records hashing to the same group looks like the primary problem. The usual hash algorithms tend to give the best spread of records when the last several bytes of the key have the widest range of values. How are the 64 byte keys composed? Kind Regards, Richard Lewis --- On Tue 10/16, roy [EMAIL PROTECTED] wrote: File name = SALES-HIST-BR1 File type = 18 Number of groups in file (modulo) = 317 Separation = 1 Number of records = 883026 Maximum number of records in a group = 7417 Average number of bytes per record = 170.6213 Minimum number of bytes in a record = 64 Maximum number of bytes in a record = 2644 ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Timeout and the break key.
We are not running SB+, I know shame :-) Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Tuesday, October 16, 2007 4:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Timeout and the break key. Wow, that's bizarre. I was able to replicate it on 7.1.9 by logging on, setting the TIMEOUT, then starting SB+, then breaking, and the TIMEOUT is gone. However, if I login, set the timeout, do NOT start SB+, but then break and quit from TCL, the timeout is not lost. So next I wrote a quick 1-liner that does an input, ran it, broke it, and the timeout was cleared. So it apparently is not related to SB+. Very strange. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Timeout and the break key.
Instead of ON.ABORT, have you experimented with ON.BREAK to reset it? Seems like its been quite a while since any TIMEOUT behavior issues have come across my desk. IIRC we use the signal handler for TIMEOUT, so may not be too hard to change the current behavior (though signals can be touchy). Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! Tom Dodds [EMAIL PROTECTED] m To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Timeout and the break key. 10/16/2007 04:20 PM Please respond to [EMAIL PROTECTED] er.u2ug.org We are running UniData 7.1.10 on AIX 5.1. We set a TIMEOUT set for 1800 seconds in the LOGIN paragraph. If any user encounters a break condition, that condition seems to turn off the TIMEOUT requirements. We have attempted to use ONABORT to turn on the TIMEOUT but the re-setting does not seem to have any effect. We can disable the break key for the normal users and log them out if the hit an error conditions, but we want something to control the idle time associated with the developers as well. The developers need access to the break key. Has anyone else run into this situation and does anyone have a workaround? TIA Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 18910473.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 18625542.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic14398.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Size of Key Question
Sounds like the file may be V E R Y poorly sized, as Jeff F suggested Was this process fast previously? What has happened on the system around the time it started to get slow? Are there any triggers on the file Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of roy Sent: Wednesday, 17 October 2007 3:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question Random reads and updates on a file with ~2 million records. I separated the reads and writes to a separate program that only does this processing to no avail. Topas shows 100% disk usage during this process and all other users are affected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Tuesday, October 16, 2007 1:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Size of Key Question I wouldn't expect much difference in file access speed with long record keys versus short keys. What are you doing with the file that seems slow? -- i.e. random reads of individual records, updates, sequential selects and processing, etc. If the slowness is seen in an application program, are there other possibilities? Does the file have alternate keys or associated files that might be causing the slowness? Could locking be a bottleneck? Just for grins it would be interesting to see a FILE.STAT on the file. Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 12:17 PM To: 'u2-users@listserver.u2ug.org' Subject: Size of Key Question Can someone comment on what effect if any the length of the key has on the speed of disk access? The software I am working with has one file with a complex key of 64 alpha-numeric characters and that file seems to be very slow no matter the modulo and sep or even file type I choose. This is in UV 10.2 Pick Flavor on AIX 5.3 Any insight would be appreciated. Thanks, Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
