[U2] Herve Balestrieri/France/IBM est absent ce Lundi 06/02/2006 et sera de retour Mardi 07/02/2006. In english : is out of office today Tuesday February 6th. I will be back on Thrusday February 7th
I will be out of the office starting 06/02/2006 and will not return until 07/02/2006. Pour les clients accidant au Support Technique des produits IBM U2, veuillez renvoyer votre message sur : [EMAIL PROTECTED] Merci For non-french speaking customers : If your IBM U2 products Technical Support centre is France, please re-send messages to : [EMAIL PROTECTED] Otherwise, IBM U2 products Technical Support in UK/EMEA email is : [EMAIL PROTECTED] Support Technique IBM - Produits U2 IBM Data Management Solutions Tel.: N0 VERT International 00 800 2535 2535 (France et Belgique) +44 208 844 3076 (autres pays/other countries) Fax: +33 (0) 49 31 45 58 Web: http://www.ibm.com/software/u2/ IBM Centre de Support Technique IBM Produits U2 7630 - 04S03 Immeuble Marne La Vallie 1 1, Place Jean-Baptiste Climent 93881 Noisy-le-Grand Cedex France e-mail Support Technique IBM U2 : [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata SQL Joins
Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Has anyone tried the UNIOLEB driver? -- View this message in context: http://www.nabble.com/Unidata-SQL-Joins-t1068436.html#a2779239 Sent from the U2 - Users forum at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata SQL Joins
Hi Craig, Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Perhaps this link would be of some help: http://www.crystalsoftware.com.au/datapipe/odbc_vendors.html Has anyone tried the UNIOLEB driver? Not personally, but we do most of our extractions from Unidata using Datastage (formerly by Ascential Software; now IBM owns, develops, supports, and sells the product) and import to MSSQL or Oracle for our apps that require SQL such as BusinessObjects. HTH, Andy -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Simple OT question
With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata SQL Joins
On 2/6/06, craig.cauchi (sent by Nabble.com) [EMAIL PROTECTED] wrote: Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? I researched this about five years ago and kept somewhat up to date through UniData 6.1. I was looking for read-only (which I suspect is also the case for you, but just if you are doing read/write, then this is irrelevant). At the time I was determining whether to work with Safari drivers given that we were using Safari for reporting and they now had such drivers, so there were more components in the decision than if starting without their product, but I ended up recommending the Safari ODBC drivers from asg.com for a number of reasons. I no longer have my research details since it was for another company, but recall two issues as star joins (multiple one to many) and a significant issue related to when virtual fields were computed. Both of these contributed to better performance than UniData ODBC. Cheers! --dawn -- Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Simple OT question
For use in USA check the NEMA standards - in many industries connectors of this type (20 amps and less) would be referred to as a Female Parallel Blade U-Ground connector. Again, check NEMA and UL (Underwriter's Laboratories) for more specific terminology. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, February 05, 2006 7:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Simple OT question With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Justification for removal of savedlists
I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Fifty don't hurt. My brother-in-law did it just yesterday! I had to buy a new shredder for all the AARP mailings, though. :-) -- Dave Walker The only reason some people get lost in thought is because it's unfamiliar territory. Paul Fix -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:07 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV I-descriptor OK... so in a few months I'll be 50+ so I will be the OLD 'FNG', with still a lot to learn. I did keep Ron P's solution and I will try it out on some of our files where we have a G/L# in Field 2 and the dollar amount in Field 3. That's why I love this users group postings. Always some great solutions. -Original Message- From: phil walker [SMTP:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 3:03 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2] UV I-descriptor Garry, Sorry to burst your bubble ;-). But I don't think he was looking for a hardcoded answer. Your solution would work for the example he gave but I am sure he wants a more generic solution which would 'locate' the value of the 4th '*' delimited field in the FILE 1 @ID in field 5 of the FILE 2 record and then return the value from the corresponding position in field 9. Cheers, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, 4 February 2006 11:31 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV I-descriptor Finally a question I can answer. Oh boy I am not a newbie anymore. File1 dictionary item: Field(TRANS(FILE2,FIELD(@ID,'*',2),9,'X'),VM,3) so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th element and then the 3rd position value. * Learning Universe for me as a newbie was challenging but the most difficult part of my job is trying to decipher the application design, since we are not provided with any technical documentation. Or our software vendor just does not have any good documentation and relies on a few core old timers to make changes and provide an oral history of the design. Questions like how is an AP Check disbursement tracked/indexed back to the Vendor Invoice go un-answered. So we have a TEST account where we reverse engineer the code. -Original Message- From: Bob Woodward [SMTP:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 12:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV I-descriptor Hi Peoples, I've got a question on coding an I-descriptor in a UV-Pick account. From file1 with a key of CO*PRODNO*WHS*UOM, I need to pull from file2 a conversion value. File2's key is PRODNO with a multi-valued field of UOM and an associated field of CONV.VAL. My problem comes in that LOCATE is not valid in an I-DESC formula. I know I can make a basic program and call it but I prefer to have this totally self contained within the DICT entry. Example data is: FILE1 @ID = 01*11223344*W1*EA FILE2 @ID = 11223344 5 = CS^SP^EA 9 = 1^2^12 I'm needing to get 12 back to the I-DESC in FILE1, again, hopefully without having to resort to a called basic program. TIA BobW --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
[EMAIL PROTECTED] wrote: I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Savedlists should never be re-used. By their very nature they are ephemeral. If a program created them, they should be recreated every time. If a user created them, they should be recreated every time. Pretty much the same holds true of the hold file. And ime, a full hold file can noticeably impact system performance - okay we're running on Windows, but when I filled the hold file with temporary files, I regularly got user complaints. Tell your VP you'll back SAVEDLISTS, HOLD to CD before you clean them up, and no you should not get any complaints because those files were *designed* as temporary work areas, not as data storage places. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata XML
I found this out the hard way also. I believe the documentation is wrong (for Unidata). Thanks, -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 2/5/2006 at 3:33 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I originally wrote about a compilation error with: X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: The compiler is seeing what you're defining as functions as matrixes. Which means that you've got a more basic problem 'cause you're not trying to use matrixes. You need to somehow define the subroutines/functions you're trying to use. Funny solution here - In Unidata 6.1.4, I have to enter these function names in uppsercase to compile cleanly (although the document indicates these are case-sensitive). After uppercasing everything, it compiles cleanly. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- 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] Justification for removal of savedlists
SAVEDLISTS is usually a directory file. Depending on your OS, putting a lot of files in a directory can be very innefficient. Records in HOLD can be very large, so disk space could be a good argument there. On the other hand, deleting saved lists can be problematic: are you sure no one wants that list anymore? Are you sure that that list you identified as being old and are about to delete hasn't just been re-written by a program reusing the name? I don't think the list verbs do a lot with locking. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer Sent: Monday, February 06, 2006 9:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- 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.375 / Virus Database: 267.15.2/251 - Release Date: 2/4/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 2/4/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple OT question
Mark, I asked our PC techs here and they tell me it's referred to as a Square-D (pronounced Square Dee) connector. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM: With every computer (and other) connector having a 'name', ie cat-5,db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Justification for removal of savedlists
We would run out of disk space if we did not clean this stuff up. We have a
UNIX file system just for SAVEDLISTS, _PH_ and _HOLD_ items. That way if the
file system does fill up, it will not cause file corruption on Unidata
files. We run a UNIX 'find /mccdata/spool -mtime +15 -exec rm {}\;'. So we
only keep 15 days of these types of data around on our production machine.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill Pizer
Sent: Monday, February 06, 2006 8:33 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Justification for removal of savedlists
I wrote a small routine that will go through Savedlists, HOLD files,
ST.PPROCES records, etc. and selectively delete the records that are no
longer needed but I have been stopped by my VP.
She wants justification for the process. I don't have the knowledge to be
able to give her what she wants. I've tried the following arguments with no
luck:
Savedlists can be outdated as soon as they are created.
Taking up too much server room.
Any one have any others to try?
- Bill Pizer
---
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] Justification for removal of savedlists
Try Savedlists do not contain data. They are collections of record keys selected for processing as a group (reports, postings, etc.), and deleting them does not change or delete the actual data. The records pointed to by the keys still exist as-is in their original files/tables. Keeping them does not add value to the system, as the records represented by the keys in the saved list may no longer exist in the file, or may have been updated since the saved list was created.. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer Sent: Monday, February 06, 2006 8:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- 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] Justification for removal of savedlists
I'm torn on the issue. On one hand I completely agree with Wol (though I need to look up the word ephemeral just to be sure). Saved lists should be created each time they're needed - MOST of the time. There are other perfectly valid reasons why one program might create a list for another program to consume at some later moment. It's all a matter of how the app is designed to use the lists. On the other hand, I have to give some creedence to the caution of the VP. You certainly don't want to be removing items from the saved lists file while folks might be using them. Especially with Unidata, where the list is fragged into a whole bunch of smaller records, you could really damage the list if you happened to remove part of a list while the rest of the list were being created. A two-phase strategy might be the best course of action. Backup the items to some temporary place and then a week later roll those out when you backup the current crop of files. Over time when nobody needs those items you'll be able to skip that step, but until then, caution should be the order of the day to keep everyone comfortable. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Chuck, Thanks for extending the usefulness of that i-descr. I tend to favor i-descr's without @n references so that they can be used as a reference in another i-descr. The @n references and semicolons sure make it more readable, but you are then limited to replicating the logic in another i-descr rather than just referencing the original one. But that may be what Bob's actually looking for, trying to limit reuse of the logic...? --Ron P. snip Now let's generalize it a bit. Suppose the final answer is a string instead of numeric. You can replace the outer 02: SUM(MULS(...)) with o2: CONVERT(@VM,'',IFS(...,'') as follows: snip Of course, we're still left with the problem of maintainability. Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Simple OT question
SQUARE D is a manufacturer of electrical components like transformers. http://www.networkcable.com/cables/powercords.cfm?ToggleId=1 I think you are looking for IEC-320-C13? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Monday, February 06, 2006 10:31 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: [U2] Simple OT question Mark, I asked our PC techs here and they tell me it's referred to as a Square-D (pronounced Square Dee) connector. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM: With every computer (and other) connector having a 'name', ie cat-5,db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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] Alan Mendelson Dies
I have just been told of the sudden and unexpected death of Alan Mendelson, VP at The Media Services Group, and formerly my co-worker at Unidata, Inc. He was a man of uncommon intelligence and wit. He was a man of uncommon kindness and warmth. Ben __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata XML
On Monday 06 February 2006 10:13, Don Verhagen wrote: I found this out the hard way also. I believe the documentation is wrong (for Unidata). Yes Don - the more we read, the more inconsistencies and typos we find. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
On Monday 06 February 2006 09:51, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Savedlists should never be re-used. By their very nature they are ephemeral. The above statement is application specific and not always true, particularly colleges running Unidata (Datatel). Yes, we do purge _HOLD_ and other things out but savedlists are generally held. Many institutions (for research purposes) may used savedlists for cohort tracking across many semesters or years. In these situations you *cannot* recreate the savedlist everytime as you have to ensure the group you initially select is the same group used months/years later - savedlists give you an easy method to acheive this (whereas the various data fields you may query against are constantly changing). With the myraid of reports colleges need (both internal and federally mandated IPEDS, etc) savedlists provide an extremely useful tool. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
SAVEDLISTS is a directory file. Searching a directory requires (on average) that you examine half the items in the directory before you find the one you want. Given a large directory, this can be very slow. (I once saw an example of a SAVEDLISTS directory with 275000 items in it!!) If this is UniVerse, also check that the STACKWRITE record in your VOC says X OFF If it is at its default of ON, you save a command stack every time you log out. These are saved with a name of S.username.userno. The theory is that when you log back in, the system can reload your stack and you carry on as though you had not gone home. This was fine in the days of async comms lines where you got the same user number each time you logged in. With modern networks this is not true. The command stack you recover is yours but potentially from ages ago and hence totally useless. If you have, say, 100 users each with a unique user name, given long enough you will have 1 totally useless command stack records killing performance of select list access. Scale this up to larger systems and the results are fascinating! [ Perhaps it's about time IBM reworked this feature. I have been telling people to turn it off the the last ten years or so ]. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Justification for removal of savedlists
I wrote a small routine that will go through Savedlists, One must be wary, as some VARs use SAVEDLISTS for storing permanent data. For example, one of Epicor's applications saves an index of all user-created report definitions in SAVEDLISTS. If you were to delete this file (which I have done), all user-created reports evaporate. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
quote who=Jeffrey Butera On Monday 06 February 2006 09:51, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Savedlists should never be re-used. By their very nature they are ephemeral. The above statement is application specific and not always true, particularly colleges running Unidata (Datatel). Yes, we do purge _HOLD_ and other things out but savedlists are generally held. Many institutions (for research purposes) may used savedlists for cohort tracking across many semesters or years. In these situations you *cannot* recreate the savedlist everytime as you have to ensure the group you initially select is the same group used months/years later - savedlists give you an easy method to acheive this (whereas the various data fields you may query against are constantly changing). With the myraid of reports colleges need (both internal and federally mandated IPEDS, etc) savedlists provide an extremely useful tool. This is a case of poor programming practice. With QSELECT, and the nature of the SAVEDLISTS file (similar in design to /tmp), any select list that needs to be re-used should NOT be kept in SAVEDLISTS. There should be another file created and used for this purpose. The 2 reasons for this are: 1. cleaning out SAVEDLISTS doesn't develop into a 'political' issue, and 2. The file used instead can be a hashed file, thus eliminating the headaches of having a directory holding large numbers of records, such as the need to tune the inode kernel parameter(s). My $0.02 (USD) Karl -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
While this may be true it is a poor design. The savedlists, hold, ph, and como directories are traditionally temporary directories. If you must save these lists then you should store them as you do other data in a file of a different name. If you need the select list in a processes in the future you can then copy it back or use a qselect. - Original Message - From: Jeffrey Butera [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Sent: Monday, February 06, 2006 10:10 AM Subject: Re: [U2] Justification for removal of savedlists On Monday 06 February 2006 09:51, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Savedlists should never be re-used. By their very nature they are ephemeral. The above statement is application specific and not always true, particularly colleges running Unidata (Datatel). Yes, we do purge _HOLD_ and other things out but savedlists are generally held. Many institutions (for research purposes) may used savedlists for cohort tracking across many semesters or years. In these situations you *cannot* recreate the savedlist everytime as you have to ensure the group you initially select is the same group used months/years later - savedlists give you an easy method to acheive this (whereas the various data fields you may query against are constantly changing). With the myraid of reports colleges need (both internal and federally mandated IPEDS, etc) savedlists provide an extremely useful tool. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- 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] Justification for removal of savedlists
I personally purge my saved-lists periodically and do not rely on saved-lists for permanent storage. For permanent storage I've created a program that saves the records from a select to a hashed file as one item with the file, date time saved as well as a comment as to the reason that I'm saving the records. The first field is the comment with each original record a field with the @id concatenated to the lowered data. The IDs to the archive records are stored in a control record. I have a restore program that displays the stored records displaying the file name, date, time and comment. I can select to delete the archived records or to restore the original records to the original file or any other file. These were very simple programs to write, but if anyone is interested in the concept, I will email you copies. Mel Maresh Senior IT Developer NextiraOne, LLC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Simple OT question
AC Power cord, female. ;-) Actually, cat-5 is the name of the CABLE, not the connectors. The connectors that go on cat5, cat5e and cat6 cables are called RJ-45. db9 and db25 come in both male and female, as do AC power cords ;-) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, February 05, 2006 5:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Simple OT question With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Alan Mendelson Dies
Ben, Condolences. Losing friends is always tough. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 Ben Rosenberg wrote: | I have just been told of the sudden and unexpected death of Alan Mendelson, VP at The Media Services Group, and formerly my co-worker at Unidata, Inc. | | He was a man of uncommon intelligence and wit. | He was a man of uncommon kindness and warmth. | | Ben --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
I have cured this problem by turning off the stackwrite and have a log on process that loads the stack by the users ID and saves the stack to the users ID when they exit. That way they always have the same stack no matter how they log in. - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:46 AM Subject: Re: [U2] Justification for removal of savedlists SAVEDLISTS is a directory file. Searching a directory requires (on average) that you examine half the items in the directory before you find the one you want. Given a large directory, this can be very slow. (I once saw an example of a SAVEDLISTS directory with 275000 items in it!!) If this is UniVerse, also check that the STACKWRITE record in your VOC says X OFF If it is at its default of ON, you save a command stack every time you log out. These are saved with a name of S.username.userno. The theory is that when you log back in, the system can reload your stack and you carry on as though you had not gone home. This was fine in the days of async comms lines where you got the same user number each time you logged in. With modern networks this is not true. The command stack you recover is yours but potentially from ages ago and hence totally useless. If you have, say, 100 users each with a unique user name, given long enough you will have 1 totally useless command stack records killing performance of select list access. Scale this up to larger systems and the results are fascinating! [ Perhaps it's about time IBM reworked this feature. I have been telling people to turn it off the the last ten years or so ]. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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] Simple OT question
To answer directly the connector is an IEC320 BizMach connector. See http://www.boltproducts.com/heyco/iec-cordset-components.html for details. Roy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Monday, February 06, 2006 1:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Simple OT question AC Power cord, female. ;-) Actually, cat-5 is the name of the CABLE, not the connectors. The connectors that go on cat5, cat5e and cat6 cables are called RJ-45. db9 and db25 come in both male and female, as do AC power cords ;-) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, February 05, 2006 5:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Simple OT question With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Simple OT question
Evidently, it's a C-14 inlet socket: http://en.wikipedia.org/wiki/IEC_60320_C13 which lies terribly often, but links to: http://www.accesscomms.com.au/iec320.htm and the images.google.com gives you: http://images.google.com/images?svnum=10hl=ensafe=offq=c14 +inletspell=1 Mike Doyle Unix Administrator / Developer AMO Recoveries, Inc. On Sun, 2006-02-05 at 08:40 -0500, Mark Johnson wrote: With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Unidata XML
There are some notes in the latest readme for the HTTP functions which explains the proper casing in the different versions. My guess is that the XML functions have the same problem - different cases in different versions. The last couple of examples I've seen from IBM using these have all come with the statement that you have to compile them with the -I option. Hth Colin Alfke Calgary, Canada -Original Message- From: jbutera I originally wrote about a compilation error with: X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: The compiler is seeing what you're defining as functions as matrixes. Which means that you've got a more basic problem 'cause you're not trying to use matrixes. You need to somehow define the subroutines/functions you're trying to use. Funny solution here - In Unidata 6.1.4, I have to enter these function names in uppsercase to compile cleanly (although the document indicates these are case-sensitive). After uppercasing everything, it compiles cleanly. Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
- Original Message - From: Martin Phillips [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:46 AM Subject: Re: [U2] Justification for removal of savedlists ... If this is UniVerse, also check that the STACKWRITE record in your VOC says X OFF Anybody know the UniData equivalent to this? I've been digging around and can't find anything. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Simple OT question
Or what we refer to in the UK as a 'kettle lead' Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Doyle Sent: 06 February 2006 19:30 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple OT question Evidently, it's a C-14 inlet socket: http://en.wikipedia.org/wiki/IEC_60320_C13 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
Hi Raymond, If this is UniVerse, also check that the STACKWRITE record in your VOC says X OFF Anybody know the UniData equivalent to this? I've been digging around and can't find anything. The problem doesn't occur on Unidata which adopts a far more sane approach to saving command stacks. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
At 20:29 + 2006/02/06, Martin Phillips wrote: The problem doesn't occur on Unidata which adopts a far more sane approach to saving command stacks. True, but unfortunately, it's not perfect. We've had troubles at a client site where the command stack gets so full, the user core dumps as soon as UDT is started. Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)| .=. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata XML
Well, so U2 is having the same problems with casing the rest of us do when interfacing with outside systems. It never ceases to amaze me that some believe Help, HELP, and help __SHOULDN'T__ mean the same thing. I can always tell I'm accessing a unix web server when I try to access a directory, under the root directory, and I type the case of that directory incorrectly. e.g. http://www.consumerreports.org/Cro/Home.htm doesn't work while http://www.consumerreports.org/cro/home.htm does. This particular problem doesn't exist on Windows servers and I was caught by it when my son was trying to track down some information for his homework. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 06, 2006 11:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata XML There are some notes in the latest readme for the HTTP functions which explains the proper casing in the different versions. My guess is that the XML functions have the same problem - different cases in different versions. The last couple of examples I've seen from IBM using these have all come with the statement that you have to compile them with the -I option. Hth Colin Alfke Calgary, Canada -Original Message- From: jbutera I originally wrote about a compilation error with: X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: The compiler is seeing what you're defining as functions as matrixes. Which means that you've got a more basic problem 'cause you're not trying to use matrixes. You need to somehow define the subroutines/functions you're trying to use. Funny solution here - In Unidata 6.1.4, I have to enter these function names in uppsercase to compile cleanly (although the document indicates these are case-sensitive). After uppercasing everything, it compiles cleanly. Jeff Butera, Ph.D. --- 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] Passed argument in Subroutines
I was converting a few programs from D3 to UD and noticed the following: BILL 001 InValue = Test 002 CALL BILL.SUBR (InValue, InValue) 003 END BILL.SUBR 001 SUBROUTINE BILL.SUBR (RtnValue, InValue) 002 CRT InValue before-: : InValue 003 RtnValue = '' 004 CRT InValue after--: : InValue 005 RETURN 006 END The value of InValue, in the subroutine, is changed when the variable RtnValue is assigned a value. :RUN BP BILL InValue before-: Test InValue after--: This seems to indicate that there's a relationship between the variable InValue in the calling program and the subroutine; in the subroutine when RtnValue is initialized the variable InValue is also initialized. I'd have thought it's the positions that are important (since there must be the number of arguments must equal in both the calling and the called programs), not necessarily the variable names. Have I figured this out right, and is this correct? As I remember, the passed arguements in subroutines: 1) don't have to be the same name, and 2) are managed solely within the subroutine. Per the UniData documentation: SUBROUTINE Syntax SUBROUTINE sub.name[(argument1 [, argument2] ...)] Description If you pass arguments, the number of arguments in the CALL statement and the SUBROUTINE statement must match, although variable names do not need to be the same. Changes made to arguments in the subroutine retain their new values when UniData exits the subroutine and control reverts to the calling program. Naturally, I resolve the program by changing the code to pass different variables, as arguments, to the called subroutine. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passed argument in Subroutines
The arguments are passed by reference - so both RtnValue and InValue are pointing to the SAME variable in the calling routine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, 7 February 2006 7:14 AM To: u2-users@listserver.u2ug.org Subject: [U2] Passed argument in Subroutines I was converting a few programs from D3 to UD and noticed the following: BILL 001 InValue = Test 002 CALL BILL.SUBR (InValue, InValue) 003 END BILL.SUBR 001 SUBROUTINE BILL.SUBR (RtnValue, InValue) 002 CRT InValue before-: : InValue 003 RtnValue = '' 004 CRT InValue after--: : InValue 005 RETURN 006 END The value of InValue, in the subroutine, is changed when the variable RtnValue is assigned a value. :RUN BP BILL InValue before-: Test InValue after--: This seems to indicate that there's a relationship between the variable InValue in the calling program and the subroutine; in the subroutine when RtnValue is initialized the variable InValue is also initialized. I'd have thought it's the positions that are important (since there must be the number of arguments must equal in both the calling and the called programs), not necessarily the variable names. Have I figured this out right, and is this correct? As I remember, the passed arguements in subroutines: 1) don't have to be the same name, and 2) are managed solely within the subroutine. Per the UniData documentation: SUBROUTINE Syntax SUBROUTINE sub.name[(argument1 [, argument2] ...)] Description If you pass arguments, the number of arguments in the CALL statement and the SUBROUTINE statement must match, although variable names do not need to be the same. Changes made to arguments in the subroutine retain their new values when UniData exits the subroutine and control reverts to the calling program. Naturally, I resolve the program by changing the code to pass different variables, as arguments, to the called subroutine. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passed argument in Subroutines {Unclassified}
Bill, From the UV Basic Reference Manual (v10.0) page 11-121 The actual values of arguments are not passed to the subroutine. Instead, a pointer to the location of each argument is passed. Passing a pointer instead of the values is more efficient when many values need to be passed to the subroutine. This method of passing arguments is called passing by reference; passing actual values is called passing by value. All scalar and matrix variables are passed to subroutines by reference. If you want to pass variables by value, enclose them in parentheses. When data is passed by value, the contents of the variable in the main program do not change as a result of manipulations to the data in the subroutine. When data is passed by reference, the memory location of the variable is changed by manipulations in both the main program and the subroutines. Constants are passed to subroutines by value. Maybe D3 has the opposite default? HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, 7 February 2006 12:14 To: u2-users@listserver.u2ug.org Subject: [U2] Passed argument in Subroutines I was converting a few programs from D3 to UD and noticed the following: [snip] Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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] Justification for removal of savedlists
On Behalf Of Bill Pizer I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: I'd go with the savedlists files are functionally equivalent to the \temp directory in Windows. It needs to be cleaned up periodically. I agree with the others and make sure that the entries are older than a certain date before removing them...just in case. - jmh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple OT question
Gracias. It sorta looks liek a square D, despite it being a brand name. - Original Message - From: Gordon J Glorfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:31 AM Subject: Re: [U2] Simple OT question Mark, I asked our PC techs here and they tell me it's referred to as a Square-D (pronounced Square Dee) connector. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM: With every computer (and other) connector having a 'name', ie cat-5,db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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] Unidata SQL Joins
Andy, I just contacted DataMystic, the folks at Crystal Software, and they have updated the page you referenced. It still listed GA Express and Ardent. Now it lists Fusionware and IBM. Thanks for pointing me to it so I could suggest the changes to them. Andy Pflueger wrote: Is there a more efficent driver for extracting data from Unidata via SQL/ODBC? Perhaps this link would be of some help: http://www.crystalsoftware.com.au/datapipe/odbc_vendors.html -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple OT question
Granted, it's RJ-45 or RJ-11 or RJ-12 depending on the number of wires. I was just curious as we were discussing connector names for a few minutes and came up with easily over 50 (audio, video, A/C of course computers). The Square-D was the one that stumped us. Thanks. - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 1:03 PM Subject: RE: [U2] Simple OT question AC Power cord, female. ;-) Actually, cat-5 is the name of the CABLE, not the connectors. The connectors that go on cat5, cat5e and cat6 cables are called RJ-45. db9 and db25 come in both male and female, as do AC power cords ;-) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, February 05, 2006 5:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Simple OT question With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Justification for removal of savedlists
I've seen instances of 'permanent' save lists but I've converted them to control records in a separate files. I like Microdata's date time stamp of their lists. UD/UV certainly have these in the unix level. I wish D3 had some because when looking only at the pointer-file, you really can't tell when they're made. And hunting down their source is not that easy with both SAVE-LIST, WRITELIST and writing directly to the POINTER-FILE. My 1 cent. - Original Message - From: Pingilley, Ron [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:38 AM Subject: RE: [U2] Justification for removal of savedlists Try Savedlists do not contain data. They are collections of record keys selected for processing as a group (reports, postings, etc.), and deleting them does not change or delete the actual data. The records pointed to by the keys still exist as-is in their original files/tables. Keeping them does not add value to the system, as the records represented by the keys in the saved list may no longer exist in the file, or may have been updated since the saved list was created.. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer Sent: Monday, February 06, 2006 8:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- 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] UniVerse Sys Admin (UV904) - Sydney, Australia
Sorry about the short notice. If anyone's interested and available there is a UV904 class happening next week (16-20 Feb 2006) in Sydney, Australia. For more details - or to book! - contact Amy Hertslet ([EMAIL PROTECTED]) or telephone (02) 9460 0666. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passed argument in Subroutines {Unclassified}
Mike, et al:
Many thanks for enlightening me. :-)
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
HENDERSON MIKE, MR
Sent: Monday, February 06, 2006 4:50 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Passed argument in Subroutines {Unclassified}
Bill,
From the UV Basic Reference Manual (v10.0) page 11-121
The actual values of arguments are not passed to the subroutine.
Instead, a pointer to the location of each argument is
passed. Passing a pointer instead of the values is more
efficient when many values need to be passed to the
subroutine. This method of passing arguments is called
passing by reference; passing actual values is called passing
by value.
All scalar and matrix variables are passed to subroutines by
reference.
If you want to pass variables by value, enclose them in parentheses.
When data is passed by value, the contents of the variable in
the main program do not change as a result of manipulations
to the data in the subroutine. When data is passed by
reference, the memory location of the variable is changed by
manipulations in both the main program and the subroutines.
Constants are passed to subroutines by value.
Maybe D3 has the opposite default?
HTH
Mike
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Bill Haskett
Sent: Tuesday, 7 February 2006 12:14
To: u2-users@listserver.u2ug.org
Subject: [U2] Passed argument in Subroutines
I was converting a few programs from D3 to UD and noticed the
following:
[snip]
Bill Haskett
Advantos Systems, Inc.
www.advantos.net
(760)944-5570 (CA)
(360)923-4838 (WA)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Justification for removal of savedlists
The best reason I know of to save SAVE.LISTs is to have a record of the data selected for a particular report or download (such as to SQL) so if there are any questions, the selected records can be easily re-selected verified. I usually name the SAVE.LIST the same as my program, with a month and year suffix, such as SIMULATOR.REVENUE.BUILD.2006.02 so I can easily identify both the program and the period in question. If the SAVELIST file is getting too full, it would be easy enough to have a separate directory like SAVE.HIST and a simple routine to get SAVE.LISTsfrom the history file. -- Louie Bergsagel On 2/5/06, Mark Johnson [EMAIL PROTECTED] wrote: I've seen instances of 'permanent' save lists but I've converted them to control records in a separate files. I like Microdata's date time stamp of their lists. UD/UV certainly have these in the unix level. I wish D3 had some because when looking only at the pointer-file, you really can't tell when they're made. And hunting down their source is not that easy with both SAVE-LIST, WRITELIST and writing directly to the POINTER-FILE. My 1 cent. - Original Message - From: Pingilley, Ron [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:38 AM Subject: RE: [U2] Justification for removal of savedlists Try Savedlists do not contain data. They are collections of record keys selected for processing as a group (reports, postings, etc.), and deleting them does not change or delete the actual data. The records pointed to by the keys still exist as-is in their original files/tables. Keeping them does not add value to the system, as the records represented by the keys in the saved list may no longer exist in the file, or may have been updated since the saved list was created.. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer Sent: Monday, February 06, 2006 8:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- 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/
