[U2] LIST DICT FILE Depth and Assoc
Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST DICT FILE Depth and Assoc
Goo'day, John, At 15:42 16/05/06 +1000, you wrote: Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end Can't really remember ... I've slept since I last heard about it but hasn't it got something to do with the controlling/dependant attributes of a dict item (Attr 4 5) If it is UV that you're playing with, why don't you just create a D- or I-type item to replicate the A-type?Silly question? jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST DICT FILE Depth and Assoc
You can use attribute 4 and 5 of the dictionary (UV System Description pdf pp5-20 for complete details) or use the Retrieve keywords MULTIVALUE and SINGLEVALUE at TCL to override default behaviours. Cheers, Stuart __ Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] php and udt
Hi - has anyone got experiance or ideas of using php to access unidata data and unibasic routines - this would be on linux ? I know there used to be a perl DBI but that was for udt v 4.0 so I presume it does not work now. I have a few ideas but want to know if someone has been there before. Thanks Symeon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] php and udt
Yes, we have. If You are interested, please contact me off-line. Symeon Breen wrote: Hi - has anyone got experiance or ideas of using php to access unidata data and unibasic routines - this would be on linux ? I know there used to be a perl DBI but that was for udt v 4.0 so I presume it does not work now. I have a few ideas but want to know if someone has been there before. Thanks Symeon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Lembit Pirn 7+7 Software Mustamde tee 4 Tallinn 10621 Estonia phone: +372 6566 232 GSM: +372 5028707 e-mail: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] php and udt
Just a couple of thoughts: 1. AFAIR there is a module in PHP that can instantiate Java classes - I remember JayJay did an article on using PHP with RedBack that exposed RedBack Objects through Java. You might be able to do something similar using UOJ if you haven't got RedBack. 2. Alternatively, you might want to hang fire a short time until the new Web Services are out of beta. I haven't tried them with PHP yet (making a mental note to do so) but if they are SOAP compatible I would expect them to work with the PHP NuSOAP libraries. That might be a smarter and simpler route. 3. I wrote a web services library myself for U2 which I did test with NuSOAP, but put it on ice when I heard about the IBM one.. But should that fail to deliver... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: 16 May 2006 10:38 To: u2-users@listserver.u2ug.org Subject: [U2] php and udt Hi - has anyone got experiance or ideas of using php to access unidata data and unibasic routines - this would be on linux ? I know there used to be a perl DBI but that was for udt v 4.0 so I presume it does not work now. I have a few ideas but want to know if someone has been there before. Thanks Symeon --- 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] linux odbc to ASG-Infoserver?
Hi, The web interface for list archives ( http://www.indexinfocus.com/) appears broken, so I apologize in advance if this question has been asked and answered. At the suggestion of Datatel, inc., we are starting to explore ASG software to connect and report from our Datatel UniData database. We are using ASG-Safari InfoServer to run on top of our Sun UniData Datatel repository. ASG provides plenty of Windows/PC tools to use to connect to this InfoServer; they appear to be custom-odbc based. A report-writer, an odbc driver for Windows. We are optimistic about these aspects of the product. However, they do not appear to provide a Linux driver that we know of. We are hoping to connect a Linux web server (apache, php, unixodbc driver manager) to our InfoServer via ODBC. Has anyone tried this before? Otherwise, does anyone have suggestions for Linux ODBC client drivers for unidata? Thank you very much for any suggestions. Gare Calhoun Antioch College http://www.antioch-college.edu Antioch University http://www.antioch.edu email: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Multiple Data Files
I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config parameter {Unclassified}
Another data point: HP BL-20 blade, two 'HYPErthreading' Intel Xeon CPUs (looks like 4 CPUs to O/S) Sort ~3.8GB distributed file with ~1.6M records by @ID (@ID is multi-character alphanumeric value, e.g. Z996894|13787) (File has four parts: 1.0GB, 1.2GB, 1.5GB 100MB is size partitioned on 2nd part of @ID) Only user on system Two runs in each pass, reboot between passes Pass 1 UVTSORT = 0 1st run 10:15 2nd run 09:45 Pass 2 Re-boot, then UVTSORT = 1 1st run 10:02 (2.3% faster) 2nd run 09:48 (0.5% slower) Thanks again to Andy Mack for actually doing the work! On this hardware and O/S, multi-threading sort is neither significantly faster nor significantly slower than non-multi-threading? Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Multiple Data Files
The concept of multi-files is simply to provide multiple data repositories that all share the same dictionary. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Tuesday, May 16, 2006 3:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple Data Files I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- 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] Multiple Data Files
Hi Ron, The most common reason for using multiple data files is to share a common dictionary. Some examples: Customers (main data file) Customers,temp (sample data loads, testing, etc) Customers,archive (old customer records) Etc. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Tuesday, May 16, 2006 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple Data Files I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- 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] Multiple Data Files
If you are meaning multiple data record structures inside of a single file then for me, it's a lot more manageable to keep things like control records in a single file/table than to have many files/tables with only one or a few records/rows. If this is not what you mean then your question has me totally confused. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Tuesday, May 16, 2006 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple Data Files I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- 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] Upgrading to UV10.1.x - UVTSORT Config parameter
HENDERSON MIKE, MR wrote: Another data point: HP BL-20 blade, two 'HYPErthreading' Intel Xeon CPUs (looks like 4 CPUs to O/S) ... On this hardware and O/S, multi-threading sort is neither significantly faster nor significantly slower than non-multi-threading? One other test you might want to try is running the sort both ways with hyperthreading turned off in the BIOS. I read an article last fall about how Intel's hyperthreading significantly degrades the performance of MS SQL Server, and it makes sense that other databases would also suffer. The problem is the result of two threads sharing single L1 and L2 CPU caches. If the threads are owned by completely different processes, chances are they'll be throwing out the entire cache with every clock cycle. Essentially like having no cache at all. Here's the article: http://news.com.com/Does+hyperthreading+hurt+server+performance/2100-1006_3-5965435.html -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST DICT FILE Depth and Assoc
Stuart, if you make either on of these S, LIST DICT still displays the depth and assoc as M not S On what does it base this decision. It looks like Universe assumes all A types are inherently multivalue. jak - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 16, 2006 5:30 PM Subject: RE: [U2] LIST DICT FILE Depth and Assoc You can use attribute 4 and 5 of the dictionary (UV System Description pdf pp5-20 for complete details) or use the Retrieve keywords MULTIVALUE and SINGLEVALUE at TCL to override default behaviours. Cheers, Stuart __ Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Multiple Data Files
Control files tend to be a hodge-podge of miscellaneous counters and other 'control' values. There tends not to be a DICT of a CONTROL file as the data is pretty inconsistent. Multiple Data Levels are pretty useful as otherwise indicated. Only drawback is when deleting the file, all the data levels go bye-bye and you may not want all to be deleted and thus manage separately. Multiple data structures within one data file is pretty much a pain in the ass. The Results Distribution system has the PRODUCT file containing 2 separate files structures, the Product Master record with the generic description, classes, weights etc and the many Warehouse records showing the on-hands and other transactional information per warehouse. I've been dealing with Results for over 20 years and I truly wish it weren't written that way. I worked with a stolen version of Results called IDS that separated it and was a lot cleaner. I worked briefly with another stolen version called SHIMS and it was combined. The trouble is that rarely are you wanting all Master and Warehouse records at once. You're either selecting Master or Warehouse records and every English request must contain AND WITH WHSE or AND WITH NO WHSE to differentiate between them. Add to the Basic selects having to separate and it's not been a good idea. I'm just sharing my opinion on primary combined files. One application, SAS for HVAC Servicing, has all of the pesky files like STATES, Salesman, Technicians, Vehicles, Tax Codes etc in one file with the primary key having a prefix of ST, SM, TE, VE, TX etc. Since that app has a whole lot of transactional data files, having these static files in one 'file' sorta makes sense. My 2 sense. Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 16, 2006 7:04 PM Subject: RE: [U2] Multiple Data Files If you are meaning multiple data record structures inside of a single file then for me, it's a lot more manageable to keep things like control records in a single file/table than to have many files/tables with only one or a few records/rows. If this is not what you mean then your question has me totally confused. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Tuesday, May 16, 2006 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple Data Files I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- 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 FILE Depth and Assoc
Dictionaries do not control the contents of data files, so there's no real way to to determine if an attribute contains multi-values or not. Generally, MV databases are multi-value self aware. This does not apply to UniData (except for conversion codes). By this I mean if you LIST SOMEFILE SOMEFIELD you will get output that will look like: SOMEFILE.. SOMEFIELD. 1 14016 14017 14018 2 14019 ...where records in the file have multi-values in the SOMEFIELD attribute. If you place a conversion code, like D2/, in attribute 7 or 8 of an A or S type dictionary, the conversion will execute on each value: SOMEFILE.. SOMEFIELD. 1 05/16/2006 05/17/2006 05/18/2006 2 05/19/2006 For reasons I won't get into here, conversion codes are normally placed into attribute 7 of an A or S type dictionary (attribute 3 of D or I/V type dictionaries). D or I/V type dictionaries do contain a loose definition of whether an attribute is multi-value or not. Attribute 6 of this type of dictionary contains that information. In UniData, in order for multi-value processing to occur in UniQuery, this attribute __MUST__ be defined as multi-valued. Still, however, the database does not require it. The use of attribute 4 and 5 of an A or S type dictionary defines a multi-value association. For instance, if an A/P invoice record exists it usually has two attributes defined as G/L account#s and associated amounts. In this case you could define an association in these types of dictionaries as D;.. and C;.., where .. is the appropriate associated attribute number. One of these is controlling and one is dependent. This concept doesn't really exist in UV and UD, except in these types of attributes (UV only). So, if you're using a front-end tool you can define an A or S type dictionary as multi-value by putting an M or S in attribute 11 of the dictionary then tell your tool to look there. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, May 16, 2006 4:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] LIST DICT FILE Depth and Assoc Stuart, If you make either one of these S, LIST DICT still displays the depth and assoc as M not S On what does it base this decision. It looks like Universe assumes all A types are inherently multivalue. jak - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 16, 2006 5:30 PM Subject: RE: [U2] LIST DICT FILE Depth and Assoc You can use attribute 4 and 5 of the dictionary (UV System Description pdf pp5-20 for complete details) or use the Retrieve keywords MULTIVALUE and SINGLEVALUE at TCL to override default behaviours. Cheers, Stuart Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M. Knowing this can be useful when combining dict items with a WHEN via a front end. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config parameter
This just in from another UniVerse person in my part of the world... Windows cannot multiprocess. Try it and you'll see. I tested a quad xeon, processor 2 ran at 50%, processor 3 at 10%, and processor 4 was idle. That was 4 phantoms running all sorting. An artificial situation, but nonetheless proving the point. Longhorn will perhaps cure this, for me I'll stick to Linux (work fine with 4000 processors). However incidental, was we turned off UVTSORT last night, and all of the mysterious SIGKILL errors vanished (this was usually killing uvpset - which I had replaced with a do nothing program). We are worried: how many people are running a p570 which 50 LPARS. Sometimes ps cannot see a process that is known to be running. IBM themselves have asked why are doing this (using LPARS in production). 5 LPARS using Universe (one with 500 users), others running god-knows-you-name-it: DB2, Oracle and other shit. We were getting SIGKILL every night, usually uvpset, but also sh, clear.file and spool, last night was clear for the first time since we moved to the p570. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Upgrading to UV10.1.x - UVTSORT Config parameter
Hi Ray Windows cannot multiprocess. Try it and you'll see. I tested a quad xeon, Which version of windows were they using? I was under the impression that a number of these issues had been improved in W2003, although I have not had a chance to explore this. I believe that there are better management facilities for multiprocessors in the datacenter version, not sure whether that is of advantage. Regards David Jordan Managing Consultant [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST DICT FILE Depth and Assoc
Bill, thanks for that but i dont think i will be adding to field 11, too many dict items. I could always set up alternative dictionarys but would rather not have to do this. jak - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 17, 2006 12:07 PM Subject: RE: [U2] LIST DICT FILE Depth and Assoc Dictionaries do not control the contents of data files, so there's no real way to to determine if an attribute contains multi-values or not. Generally, MV databases are multi-value self aware. This does not apply to UniData (except for conversion codes). By this I mean if you LIST SOMEFILE SOMEFIELD you will get output that will look like: SOMEFILE.. SOMEFIELD. 1 14016 14017 14018 2 14019 ...where records in the file have multi-values in the SOMEFIELD attribute. If you place a conversion code, like D2/, in attribute 7 or 8 of an A or S type dictionary, the conversion will execute on each value: SOMEFILE.. SOMEFIELD. 1 05/16/2006 05/17/2006 05/18/2006 2 05/19/2006 For reasons I won't get into here, conversion codes are normally placed into attribute 7 of an A or S type dictionary (attribute 3 of D or I/V type dictionaries). D or I/V type dictionaries do contain a loose definition of whether an attribute is multi-value or not. Attribute 6 of this type of dictionary contains that information. In UniData, in order for multi-value processing to occur in UniQuery, this attribute __MUST__ be defined as multi-valued. Still, however, the database does not require it. The use of attribute 4 and 5 of an A or S type dictionary defines a multi-value association. For instance, if an A/P invoice record exists it usually has two attributes defined as G/L account#s and associated amounts. In this case you could define an association in these types of dictionaries as D;.. and C;.., where .. is the appropriate associated attribute number. One of these is controlling and one is dependent. This concept doesn't really exist in UV and UD, except in these types of attributes (UV only). So, if you're using a front-end tool you can define an A or S type dictionary as multi-value by putting an M or S in attribute 11 of the dictionary then tell your tool to look there. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, May 16, 2006 4:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] LIST DICT FILE Depth and Assoc Stuart, If you make either one of these S, LIST DICT still displays the depth and assoc as M not S On what does it base this decision. It looks like Universe assumes all A types are inherently multivalue. jak - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 16, 2006 5:30 PM Subject: RE: [U2] LIST DICT FILE Depth and Assoc You can use attribute 4 and 5 of the dictionary (UV System Description pdf pp5-20 for complete details) or use the Retrieve keywords MULTIVALUE and SINGLEVALUE at TCL to override default behaviours. Cheers, Stuart Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M. Knowing this can be useful when combining dict items with a WHEN via a front end. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.0/341 - Release Date: 16/05/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/