[U2] Date comparison
We have been experiencing this quite a bit and am not sure why we are getting mis-comparisions. Below is a simplified example of our issue B$CHECK.855.SENT: 51: IF ST.DATE # THEN B$CHECK.855.SENT: 52: IF ST.DATE 12-31-11 THEN B$CHECK.855.SENT: 53:PRINT PL:Date is less than 12-31-11...: : ST.DATE/ STRING: T r L=8 `01-20-12' We have this issue with programs and with SELECT statements throughout. When you qualify a date for this year to a date from 2011 it screws up. Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.commailto:bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner [http://thinkbeforeprinting.org/struct/signature-1.gif] NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date comparison
Hi Barry, Unless I am mis-understanding your example, you appear to be doing this comparison using external format dates which is doomed to failure. They will be compared as simple character strings, left to right, until a difference is found. You need to do the comparison with an internal day number. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: Barry Rogen Sent: Tuesday, January 24, 2012 1:17 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Date comparison We have been experiencing this quite a bit and am not sure why we are getting mis-comparisions. Below is a simplified example of our issue B$CHECK.855.SENT: 51: IF ST.DATE # THEN B$CHECK.855.SENT: 52: IF ST.DATE 12-31-11 THEN B$CHECK.855.SENT: 53:PRINT PL:Date is less than 12-31-11...: : ST.DATE/ STRING: T r L=8 `01-20-12' We have this issue with programs and with SELECT statements throughout. When you qualify a date for this year to a date from 2011 it screws up. Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.commailto:bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner [http://thinkbeforeprinting.org/struct/signature-1.gif] NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date comparison
Isn't your 2nd line of code going to be doing a string comparison on the date, not a true date (number) comparison? I always do an internal format comparison of dates. If you need to do string comparisons, you d want them in -MM-DD format, but I advise against it. John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, January 24, 2012 8:18 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Date comparison We have been experiencing this quite a bit and am not sure why we are getting mis-comparisions. Below is a simplified example of our issue B$CHECK.855.SENT: 51: IF ST.DATE # THEN B$CHECK.855.SENT: 52: IF ST.DATE 12-31-11 THEN B$CHECK.855.SENT: 53:PRINT PL:Date is less than 12-31-11...: : ST.DATE/ STRING: T r L=8 `01-20-12' We have this issue with programs and with SELECT statements throughout. When you qualify a date for this year to a date from 2011 it screws up. Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.commailto:bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner [http://thinkbeforeprinting.org/struct/signature-1.gif] NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date comparison
Just adding the advice to make sure all your date dictionaries have Right Justified formats. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, January 24, 2012 6:18 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Date comparison We have been experiencing this quite a bit and am not sure why we are getting mis-comparisions. Below is a simplified example of our issue B$CHECK.855.SENT: 51: IF ST.DATE # THEN B$CHECK.855.SENT: 52: IF ST.DATE 12-31-11 THEN B$CHECK.855.SENT: 53:PRINT PL:Date is less than 12-31-11...: : ST.DATE/ STRING: T r L=8 `01-20-12' We have this issue with programs and with SELECT statements throughout. When you qualify a date for this year to a date from 2011 it screws up. Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.commailto:bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner [http://thinkbeforeprinting.org/struct/signature-1.gif] NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date comparison
The person who wrote that line of code must be executed. That's the only solution ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date comparison
You should always work with dates/times/numbers in internal format and only convert them to external format for display. Wherever ST.DATE came from, it should have been converted using ICONV: ST.DATE=ICONV(ST.DATE,D) and have a value of 16091 (assuming that the 12 means 2012 and not 1912). The comparison would be IF ST.DATE ICONV(12-31-2011,D) THEN The actual data stored in a file should be in internal format--never ever external. When using query LIST/SELECT, make sure the dictionary is right justified and has a date conversion: 0001 D 0002 1 0003 D4/ 0004 DATE 0005 10R or in a 10-line dict: 0001 A 0002 1 0003 date 0004 0005 0006 0007 D4/ 0008 0009 R 0010 10 If the date conversion is being done by an type expression instead of a conversion, or by a correlative on the 8th line of a 10-line dict instead of by a conversion on line 7, queries will likely not work. When you use a query like: SELECT INVOICE-FILE WITH DATE.DUE 01/01/2012 the query processor uses the conversion code to convert 01/01/2012 into internal format, and then compare against the internal data on file. If you don't have data in internal format, then this is just a string comparison, and 01/01/2012 is NOT equal to 01/01/12, and 02/01/2000 is great than 01/01/2012. On Jan 24, 2012, at 8:17 AM, Barry Rogen wrote: We have been experiencing this quite a bit and am not sure why we are getting mis-comparisions. Below is a simplified example of our issue B$CHECK.855.SENT: 51: IF ST.DATE # THEN B$CHECK.855.SENT: 52: IF ST.DATE 12-31-11 THEN B$CHECK.855.SENT: 53:PRINT PL:Date is less than 12-31-11...: : ST.DATE/ STRING: T r L=8 `01-20-12' We have this issue with programs and with SELECT statements throughout. When you qualify a date for this year to a date from 2011 it screws up. Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.commailto:bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner [http://thinkbeforeprinting.org/struct/signature-1.gif] NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FYI - Another UV shop going away...
Just FYI, Yesterday, Ochsner Health System (8 hospital plus ~40 clinics covering from New Orleans to Baton Rouge, LA.) announced that the in-house maintained Laboratory Information System will be replaced with SoftLab from Soft Computer Corp (softcomputer.com). The in-house system was originally a Pr1me then PI-Open, then Ardent to IBM to Rocket UniVerse system. The source was licensed from LabForce some 20 years ago and maintained and further enhanced in-house with things like automated faxing, connections to PHP/Apache, MS-SQL Sybase, some GUI (where it made sense), etc. Looks like I'll be moving into the Oracle on AIX world here shortly... Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FYI - Another UV shop going away...
Robert: Good luck. It's a shame management and IT can't seem to understand that the ROI for such a change will never approach zero from the west, and the only reason for such a change is to spend someone elses money to make an individual, or group of individuals, look intelligent. :-( Reminds me of many of us who can't figure out the economics of pricing; thus figure when the demand curve is shifted to the east, prices go down. Lord, protect others from our ignorance! :-) Bill - Original Message - *From:* ropor...@ochsner.org *To:* u2-users@listserver.u2ug.org *Date:* 1/24/2012 8:18 AM *Subject:* [U2] FYI - Another UV shop going away... Just FYI, Yesterday, Ochsner Health System (8 hospital plus ~40 clinics covering from New Orleans to Baton Rouge, LA.) announced that the in-house maintained Laboratory Information System will be replaced with SoftLab from Soft Computer Corp (softcomputer.com). The in-house system was originally a Pr1me then PI-Open, then Ardent to IBM to Rocket UniVerse system. The source was licensed from LabForce some 20 years ago and maintained and further enhanced in-house with things like automated faxing, connections to PHP/Apache, MS-SQL Sybase, some GUI (where it made sense), etc. Looks like I'll be moving into the Oracle on AIX world here shortly... Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FYI - Another UV shop going away...
I'm fighting the same stuff where I'm at. Although, we aren't that big of a chain, only a 300 user system or so. Its an automotive aftermarket supplier. They will spend a million to get Information at their fingertips, but, they won't buy something like MITS or just wait on one of us to write the code... Boggles my mind... I think we're all going to have to learn to be diplomats, salesmen, motivational speakers, etc. Just being a technical person (admin or developer), isn't good enough any more. On Tue, Jan 24, 2012 at 12:10 PM, Bill Haskett wphask...@advantos.netwrote: Robert: Good luck. It's a shame management and IT can't seem to understand that the ROI for such a change will never approach zero from the west, and the only reason for such a change is to spend someone elses money to make an individual, or group of individuals, look intelligent. :-( Reminds me of many of us who can't figure out the economics of pricing; thus figure when the demand curve is shifted to the east, prices go down. Lord, protect others from our ignorance! :-) Bill --**--** - Original Message - *From:* ropor...@ochsner.org *To:* u2-users@listserver.u2ug.org *Date:* 1/24/2012 8:18 AM *Subject:* [U2] FYI - Another UV shop going away... Just FYI, Yesterday, Ochsner Health System (8 hospital plus ~40 clinics covering from New Orleans to Baton Rouge, LA.) announced that the in-house maintained Laboratory Information System will be replaced with SoftLab from Soft Computer Corp (softcomputer.com). The in-house system was originally a Pr1me then PI-Open, then Ardent to IBM to Rocket UniVerse system. The source was licensed from LabForce some 20 years ago and maintained and further enhanced in-house with things like automated faxing, connections to PHP/Apache, MS-SQL Sybase, some GUI (where it made sense), etc. Looks like I'll be moving into the Oracle on AIX world here shortly... Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FYI - Another UV shop going away...
This is sad news. I was in on the initial implementation of the Lab Force LIS at Ochsner in New Orleans so many years ago. It was a very fun, challenging project - and I'm proud to see that the product has held out so well after all this time. Glenn Luedke is a very good friend of mine, even though we haven't worked together in years. he was my first boss/PM at Lab Force in 1985 (dating myself now). The last time we worked together was around 2000. I hope he is doing well. Bob Worley Coburn Supply Co -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Tuesday, January 24, 2012 10:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] FYI - Another UV shop going away... Just FYI, Yesterday, Ochsner Health System (8 hospital plus ~40 clinics covering from New Orleans to Baton Rouge, LA.) announced that the in-house maintained Laboratory Information System will be replaced with SoftLab from Soft Computer Corp (softcomputer.com). The in-house system was originally a Pr1me then PI-Open, then Ardent to IBM to Rocket UniVerse system. The source was licensed from LabForce some 20 years ago and maintained and further enhanced in-house with things like automated faxing, connections to PHP/Apache, MS-SQL Sybase, some GUI (where it made sense), etc. Looks like I'll be moving into the Oracle on AIX world here shortly... Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Install as root vs uvadm
I believe that there is an existing bug with the 11.3 version of Universe that installing as uvadm causes problems. Still waiting on a fix for this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bertrand, Ron Sent: Friday, January 20, 2012 2:38 PM To: 'U2 Users List' Subject: Re: [U2] [UV] Install as root vs uvadm We had multiple permission problems when we installed universe 11.3 as uvadm. Had to emergency re-install as root. Ron Bertrand | ANALYST,AP SYS 3 ISD, Group Health Cooperative PHONE 206-901-4519 CELL 206-605-9027 E-MAIL bertran...@ghc.org -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Friday, January 20, 2012 11:12 AM To: U2 Users List Subject: [U2] [UV] Install as root vs uvadm I'm getting ready to install UniVerse on a new server and am questioning my past decision to install as uvadm rather than root. I'm not sure that installing as uvadm has really been of any benefit. Anyone want to comment on your experiences using uvadm vs root? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users GHC Confidentiality Statement This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SQL Select and order by
Hi All, I have just started to use SQL queries in universe instead of Retrieve. When I perform a SQL select against a Universe file and save it to a SAVEDLISTS record each record is on a new field line and the column data is separated by text marks. For example if I have a file with the following data File: MYFILE @ID COL1COL2COL3 --- 1 ABC 123 Moo 2 DEF 456 Woof 3 HIG 789 Meow SELECT COL1, COL2, COL3 TO SLIST 1 FROM MYFILE; I would then get a saved list with 3 fields. ABC @TM 123 @TM Moo DEF @TM 546 @TM Woof HIG @TM 789 @TM Meow But if I add the ORDER BY to the end of my SQL query it does not use text markers SELECT COL1, COL2, COL3 TO SLIST 1 FROM MYFILE ORDER BY COL1; My saved list is then made up of 9 fields. ABC 123 Moo DEF 456 Woof HIG 789 Meow From reading the documentation I could not find anything specific about this. The closest thing I found was regarding multi column record id in SQL are separated by text marks. This makes it interesting when using SQL select statements in a Subroutine when using READNEXT. In the first example there are 3 rows and each READNEXT returns all the data you want separated by text markers. SQLCOM = SELECT COL1, COL2, COL3 TO SLIST 1 FROM MYFILE; EXECUTE SQLCOM SETTING NUMFOUND CAPTURING TRASH LOOP WHILE READNEXT REC.ROW FROM 1 CRT REC.ROW REPEAT In the second example there are 9 rows and each you have to call READNEXT 3 times to get all your column data for one record. SQLCOM = SELECT COL1, COL2, COL3 TO SLIST 1 FROM MYFILE ORDER BY COL1; EXECUTE SQLCOM SETTING NUMFOUND CAPTURING TRASH LOOP WHILE READNEXT REC.ROW FROM 1 CRT REC.ROW REPEAT Why does the ORDER BY statement change my SLIST? Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 E: adrian.ha...@itvision.com.au W: http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users