Re: [U2] Variable Interpolation
In Universe you can do the following at tcl, LIST MD 'MD' EVAL OCONV(DATE()+20,'D4') FMT 12R COUNT.SUP COL.HDR.SUPP HDR.SUP ID.SUP LIST MD 'MD' EVAL 3 * 4 FMT 12R COUNT.SUP COL.HDR.SUPP HDR.SUP ID.SUP EVAL allows any valid code that you would normal put into an itype dictionary, including variable storage to a degree using @1, @2, etc... LIST MD 'MD' EVAL 2;4;@1 * @2;OCONV(@3 * 1.3,'MD20,') FMT 12R COUNT.SUP COL.HDR.SUPP HDR.SUP ID.SUP Regards, Stewart Mitchell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Friday, 24 August 2012 1:42 PM To: U2 Users List Subject: Re: [U2] Variable Interpolation I wrote one myself. There is some capability with one of the conv commands but it is limited to 255character. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, 24 August 2012 1:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Variable Interpolation From: jjuser Does UniBasic have a way to do variable interpolation (without writing to a file, compiling it as a program, and calling it)? Do you mean something like this? VAL = 0 CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) CRT VAL ; * 4 That would be Awesome! I don't believe any of the MV platforms do that because I've been looking for it for 15 years. It can be simulated in various ways, but you did limit the scope of the challenge. I think you're trying to avoid this?: CODE = \ CRT DATE()+20\ EXECUTE PGEN :CODE CAPTURING OUT * OUT is 16327 In this case the PGEN program reads from TCL, writes, compiles, runs, and that output gets captured. But at least the mechanism for performing that task is abstracted from this client/application code. Cache' allows you to enter code at TCL and then execute it without saving/compiling. That can also be simulated in U2. I don't think I've ever seen anyone else ask for it here - certainly no one willing to pay for it. ;) Out of curiosity, what's your application for this? And please correct the above if I've misunderstood the question. T ___ 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 Effective October 2011 Symbion Pharmacy Services has changed its name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unusual code
What is this 1]2 and 1,1 doing ? that is the correct syntax for a multi-value locate statement, 1]2 is part of the multi-value array. Why do I need this? That for you to work out. What is this doing? The only valid value for the variable ANSWER are blank (no value) or Y or N or 1 or 2. Where blank (no value) or Y or 1 equal to Yes the problem codes are correct. If you don’t like it change it, it's only software, just be sure to get the right result. Regards, Stewart Mitchell Business Systems Manager Symbion IT Symbion Pty Ltd Tel: +61 8 8408 3685 Mob: +61 421 612 672 Email: stewart.mitch...@symbion.com.au Building D, 75 Hardys Road I Underdale SA 5032 I Australia -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 15 March 2012 10:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unusual code In my 25 years in Pick I have never seen a construction like this to test for Y or N or whatever it's doing. What is this doing? What is this 1]2 and 1,1 doing ? Why do I need this? 0297: CHECK: PRINT @(0,17): Are the problem codes correct (Y/N)? : 0298: INPUT ANSWER 0299: LOCATE ANSWER IN '²Y²N²1²2'1,1 SETTING TEST ELSE PRINT BELL 0300: LOCATE ANSWER IN '²Y²1'1,1 SETTING TEST ELSE 0301: PRINT @(0,13):CLEAR.REST.SCREEN ; GOTO ENTER.PROBLEM.CODES ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Effective October 2011 Symbion Pharmacy Services has changed its name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
The VOC is just a file like any other file in UV. 1. Update at least one account. 2. Create a Q pointer to the VOC in another account 3. Copy the updated records. ** The trick is understand what has been changed in the VOC during an update (step 1) ** Regards, Stewart Mitchell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, 31 January 2012 5:48 AM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Effective October 2011 Symbion Pharmacy Services has changed its name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Solid State Drives (SSD) and Universe
Hi All, I am interested in the groups opinion on using SSDs with Universe. My reading leads me to believe there are significant performance improves for I/O and more specifically random reads in the magnitude of 3,000% (30 times) faster. Does anyone current use SSDs? Regards, Stewart Mitchell Business Systems Manager Symbion IT Symbion Pty Ltd Effective October 2011 Symbion Pharmacy Services has changed it's name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Test Post
Please ignore Stew Effective October 2011 Symbion Pharmacy Services has changed it's name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [SB+][UV] SB.WELCOME
Hi All, I am in the process of moving some accounts form SB+ 5.0.4 TO SB+ 6.1.1 and on logon the system no longer displays the contents of SB.WELCOME record. I only get the standard SB+ login screen. An interesting twist, is that if I escape all the way out of SB+ it then displays the login screen as described in the SB.WELCOME record. Maybe I have missed something, any ideas / clues would be gratefully received. Regards, Stewart Mitchell Business Systems Manager Symbion IT Effective October 2011 Symbion Pharmacy Services has changed it's name to Symbion. My email address has changed from @symbionpharmacy.com to @symbion.com.au. The company's ABN (25 000 875 034) remains the same. This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] attempting XML.TODB
Hi Henry, Suspect you have not setup the shared library path. In your .profile (we set this in the default .profile but can be done at the user level) you require the following SHLIB_PATH=/usr/opt/uv/bin export SHLIB_PATH If universe in not installed as shown in the example above substitute your uv installed path. Regards, Stewart Mitchell Business Systems Manager Symbion Pharmacy Services Tel: +61 8 8408 3685 Mob: +61 421 612 672 Email: stewart.mitch...@symbionpharmacy.com Building D, 75 Hardys Road I Underdale SA 5032 I Australia -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ho, Henry Sent: Friday, 3 June 2011 1:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] attempting XML.TODB My first try at using XML.TODB But I'm getting this error: :XML.TODB SCHOOL.XML SCHOOL.MAP In /usr/ud72/sys/CTLG/x/XMLTODB at line 34 Can't load /usr/ud72/bin/libxml.so: libxslt4c.so.110: cannot open shared object file: No such file or directory error message: I know I'm missing a dependency but I can't find 'libxslt4c.so.110' anywhere on the web. i have 'libxslt' installed, but have no idea what 'libxslt4c' is. Thanks, -henry *** Henry Ho Purchasing Department UC Hastings College of the Law 200 McAllister St. San Francisco CA 94102 tel 415.565.4605 fax 415.565.4606 www.uchastings.edu please take our Purchasing Services Survey http://www.surveymonkey.com/s/PL6KS2S ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] attempting XML.TODB
Hi Henry, Just realized that you are using Unidata. I only have experience with Universe on this issue but I suspect it will be the same, below is what I believe to be the correct setting for Unidata. SHLIB_PATH=/usr/ud72/bin/ export SHLIB_PATH Regards, Stewart Mitchell Business Systems Manager Symbion Pharmacy Services Tel: +61 8 8408 3685 Mob: +61 421 612 672 Email: stewart.mitch...@symbionpharmacy.com Building D, 75 Hardys Road I Underdale SA 5032 I Australia -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mitchell, Stewart Sent: Friday, 3 June 2011 7:29 AM To: U2 Users List Subject: Re: [U2] attempting XML.TODB Hi Henry, Suspect you have not setup the shared library path. In your .profile (we set this in the default .profile but can be done at the user level) you require the following SHLIB_PATH=/usr/opt/uv/bin export SHLIB_PATH If universe in not installed as shown in the example above substitute your uv installed path. Regards, Stewart Mitchell Business Systems Manager Symbion Pharmacy Services Tel: +61 8 8408 3685 Mob: +61 421 612 672 Email: stewart.mitch...@symbionpharmacy.com Building D, 75 Hardys Road I Underdale SA 5032 I Australia -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ho, Henry Sent: Friday, 3 June 2011 1:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] attempting XML.TODB My first try at using XML.TODB But I'm getting this error: :XML.TODB SCHOOL.XML SCHOOL.MAP In /usr/ud72/sys/CTLG/x/XMLTODB at line 34 Can't load /usr/ud72/bin/libxml.so: libxslt4c.so.110: cannot open shared object file: No such file or directory error message: I know I'm missing a dependency but I can't find 'libxslt4c.so.110' anywhere on the web. i have 'libxslt' installed, but have no idea what 'libxslt4c' is. Thanks, -henry *** Henry Ho Purchasing Department UC Hastings College of the Law 200 McAllister St. San Francisco CA 94102 tel 415.565.4605 fax 415.565.4606 www.uchastings.edu please take our Purchasing Services Survey http://www.surveymonkey.com/s/PL6KS2S ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ 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] Why should we NOT upgrade to UV11.1.1 ?
What year would that be, must be USA time as 19th is a Thursday here in oz. Regards, Stewart Mitchell Business Systems Manager Symbion Pharmacy Services Tel: +61 8 8408 3685 Mob: +61 421 612 672 Email: stewart.mitch...@symbionpharmacy.com Building D, 75 Hardys Road I Underdale SA 5032 I Australia -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Witney Sent: Thursday, 19 May 2011 4:30 PM To: U2 Users List Subject: Re: [U2] Why should we NOT upgrade to UV11.1.1 ? I am upgrading here on Sunday 19th May, second attempt as one of the files provided via Rocket (unishared.load/ucisdk/UCI.a) was unreadable the first time we tried. I'll let the list know how it goes Bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 19 May 2011 03:01 To: U2 Users List Subject: [U2] Why should we NOT upgrade to UV11.1.1 ? UV11.1 has been available for AIX for 7 month; for Linux only 3.. I don't know how widely used it is yet. I have not seen a rash of complaints about 11.1. We are currently on 10.2.10 / Windows and contemplating migrating to Linux. UV choices are: 10.3.9 11.1.1. We do not have a burning need for any new 11.1 functionality. The main motivation would be to be able to put off future upgrades longer by making this jump bigger. Linux choices are RedHat or SuSE. Your thoughts? Any warnings or endorsements re. UV version /or Linux choices would be much appreciated. Chuck Stevenson Tolt Service Group ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2][UV] Performance Improvement Hpux 11.23 11.31 (Itianium)
Hi All, We have been doing some performance testing on HP-UX 11.23 11.31 and I though I would share some of our findings. Our systems: Tru64 V5.1bUV 10.0.8 (Current production system being replace with HP Itianium). HP-UX B.11.31 UV 10.2.11 (New production machine, RX6600 and an EVA4400 san) Our first simple test SELECT SM.ORDERS, we captured the following timings (approximate timings shown); Tru64 V51b 8 minutes HP-UX B.11.31 24 minutes (no tuning) (big problem). After discussing this issue with HP their labs found the following. Forward Sequential I/O of a large file took about 60 seconds, Backward sequential I/O of the same large file was greater than 30 minutes (test was stopped). After changing the file system to use Enhanced Read Ahead, the backward sequential I/O completed about 4 minutes. What does this mean for universe? Generally speaking, most universe files would contain overflow frames. This means when you select the file the whole file is processed using forward sequential I/O until you get to a group that is in overflow. To process a frame that is in an overflow state, universe must search forward to past the end of the primary groups to the secondary buffers where the overflow frames are stored. To get back to the original primary frame universe must perform a backward sequential I/O. Based on what we now know about HP-UX when read ahead is to its normal method HP-UX does not do backward read ahead, big problem. Once we changed our file system on HP-UX to use enhanced read ahead the time to process the command SELECT SM.ORDERS was about 5 minutes, now faster than our current system :) (great performance outcome). So how do you go about change the read ahead? This is a fairly simple process Tune the file system to use enhanced read_ahead (sometimes called fancy read ahead) As super user; # vxtunefs -o read_ahead=2 /mount point Note: To make the change persistent across reboots, create or add an entry to the /etc/vx/tunefstab file The entry should look something like this: /dev/vgXX/lvolYY read_ahead=2 We also got further improvement by changing in the file system block size from 1k to 8k. When you change the block size you will lose all your data and it must be recovered via tape etc... If you are not proficient with HP-UX it might be best to discuss this with your HP-UX System Admin and/or HP, the beauty of this is that it is a per mount point config option and not a system wide option. This of course means that if you run more than just universe on you Itanium system you could make these changes for just for the mount points being used by universe. We have also tested this on HP-UX B.11.23 and got similar improvements in performance. The above is not advice but simply our findings and therefore you must do your own testing before making any changes to your production systems. This information has already been shared with IBM via Meier Business System (MBS) Australia Regards, Stewart Mitchell ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Automated Testing
Hi All, We are currently looking for a tool to assist with automated testing for universe software written using SB+. So any help or suggestions would be greatly appreciated. Kind Regards, Stewart Mitchell ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] XML Extraction
Many Thanks Symeon Change the extraction file as shown below and all works just fine. Previously I was creating the xpath as path=ORDERS/@CUSTOMER/text(), dropped the /text() as indicated and good as gold. ORDER.EXT (file) ?xml version = 1.0? U2xml-extraction xmlns:U2xml=http://www.ibm.com/U2-xml; U2xml:file_extraction start=/ROOT dictionary = null = EMPTY / U2xml:field_extraction field=Customer path=ORDERS/@CUSTOMER / /U2xml-extraction ?xml version=1.0? !DOCTYPE ROOT[ !ELEMENT ROOT ( ORDERS* ) !ELEMENT ORDERS EMPTY !ATTLIST ORDERS CUSTOMER CDATA #REQUIRED ] ROOT ORDERS CUSTOMER = 9688455/ /ROOT Stewart Mitchell Manager, Business Systems Symbion Pharmacy Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Thursday, 4 January 2007 5:12 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] XML Extraction Hi Stewart the xpath notation would be ORDERS/@CUSTOMER to take the CUSTOMER attribute of the ORDERS element. On 03/01/07, Mitchell, Stewart [EMAIL PROTECTED] wrote: Hi All, Does anyone how to extract data from an xml file using attributes. This works for elements but I don't know the syntax for attributes and I found the manual unclear. Element based xml ORDER.EXT (file) ?xml version = 1.0? U2xml-extraction xmlns:U2xml=http://www.ibm.com/U2-xml; U2xml:file_extraction start=/ROOT dictionary = null = EMPTY / U2xml:field_extraction field=Customer path=ORDERS/CUSTOMER/text() / /U2xml-extraction ORDER.XML (file) ?xml version=1.0? !DOCTYPE ROOT[ !ELEMENT ROOT ( ORDERS* ) !ELEMENT ORDERS(Customer+) !ELEMENT Customer (#PCDATA) ] ROOT ORDERS CUSTOMER9688455/CUSTOMER /ROOT End of element based xml If the ORDER.XML file is constructed as shown below what is the syntax for the extraction file ORDER.EXT Attributed based xml ?xml version=1.0? !DOCTYPE ROOT[ !ELEMENT ROOT ( ORDERS* ) !ELEMENT ORDERS EMPTY !ATTLIST ORDERS CUSTOMER CDATA #REQUIRED ] ROOT ORDERS CUSTOMER = 9688455/ /ROOT TIA Stewart ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- 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/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] XML Extraction
Hi All, Does anyone how to extract data from an xml file using attributes. This works for elements but I don't know the syntax for attributes and I found the manual unclear. Element based xml ORDER.EXT (file) ?xml version = 1.0? U2xml-extraction xmlns:U2xml=http://www.ibm.com/U2-xml; U2xml:file_extraction start=/ROOT dictionary = null = EMPTY / U2xml:field_extraction field=Customer path=ORDERS/CUSTOMER/text() / /U2xml-extraction ORDER.XML (file) ?xml version=1.0? !DOCTYPE ROOT[ !ELEMENT ROOT ( ORDERS* ) !ELEMENT ORDERS(Customer+) !ELEMENT Customer (#PCDATA) ] ROOT ORDERS CUSTOMER9688455/CUSTOMER /ROOT End of element based xml If the ORDER.XML file is constructed as shown below what is the syntax for the extraction file ORDER.EXT Attributed based xml ?xml version=1.0? !DOCTYPE ROOT[ !ELEMENT ROOT ( ORDERS* ) !ELEMENT ORDERS EMPTY !ATTLIST ORDERS CUSTOMER CDATA #REQUIRED ] ROOT ORDERS CUSTOMER = 9688455/ /ROOT TIA Stewart ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] FAST Running while system in use
Hi All, We currently use FAST for the resizing of files and part of the process is collecting file stats for the purpose of calculating new file sizes, separation etc. I was wondering if running the stats collection process can be run whilst the system is being used (files being updated etc) without causing any issues? I had a strange issue today when one of our program files could not be opened and this caused a background process (phantom) to crash. On inspection I could open the file there were no permission problems. I restarted the phantom all worked just fine. However, I noticed that our Database Admins where running one of the FAST processes and thus my question above. All replies gratefully accepted. Kind Regards, Stewart Mitchell Manager, Business Systems Symbion Pharmacy IT Phone: 08 8408 3685 Mobile: 0421 612 672 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] There are 10 kinds of people in the world: those that understand binary and those that don't. Various ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] FAST Running while system in use
Hi Debster, Thanks for your suggestions. We are very happy with FAST and given we have well over twenty thousand files to maintain over 9 servers, FAST is definitely the way to go. Sure I could write my own but I am not in the tools business and FAST does an excellent job. The files were not being resized at the time and the point about gathering stats on files that being updated is valid. However, we resize all files on a six weekly cycle and the small change that is made during the stats collection period would not be significant. But if the file is being locked during stats collection that would be a major issue and would have resulted in the failure experience. Again many thanks for your input, Stewart -Original Message- From: Debster [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 April 2006 13:12 To: Mitchell, Stewart Subject: RE: [U2] [UV] FAST Running while system in use A resize function will lock a file And why collect stats when a file is active? I had looked at FAST but given the recent nightmare I have just lived through I am not so sure I would want to just allow an application to run and act on the results. Besides it's really easy enough to write a program to select a rotating set of files you like to monitor, have it run HASH-HELP and capture the data to a file. This allows you the ability to inspect the results. On more than one occasion lately I have run across HASH-HELP results returning an incorrect file type. (I also think I was a victim of Mark's Berkley Bug...except the sep was 8 not 4) Another option is to run a complete set of file stats weekly selecting your top files in need of resizing from the results within STAT-FILE and performing the calculation yourself within a program How many others remember having to hand calculate these with a set of file stats in front of you? Seems to be of the same era as remembering the sequence of keys to hit to open an unresponsive tape drive on a mentor system Or using the trick of blowing the tape leader into place when using the 12 inch tapes...rut-roh that sounded kinda kinky! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mitchell, Stewart Sent: Friday, April 21, 2006 10:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] FAST Running while system in use Hi All, We currently use FAST for the resizing of files and part of the process is collecting file stats for the purpose of calculating new file sizes, separation etc. I was wondering if running the stats collection process can be run whilst the system is being used (files being updated etc) without causing any issues? I had a strange issue today when one of our program files could not be opened and this caused a background process (phantom) to crash. On inspection I could open the file there were no permission problems. I restarted the phantom all worked just fine. However, I noticed that our Database Admins where running one of the FAST processes and thus my question above. All replies gratefully accepted. Kind Regards, Stewart Mitchell Manager, Business Systems Symbion Pharmacy IT Phone: 08 8408 3685 Mobile: 0421 612 672 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] There are 10 kinds of people in the world: those that understand binary and those that don't. Various ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SYS.MESSAGE file being corrupted
JAK, Further to BobW's post, do you have INCLUDE statements in the program with in-line comments attached ie $INCLUDE INC.FILE INC.RECORD ;* Comment here As this will corrupt the line numbers, that is you need to add the number of include lines with in-line comments to the line number reported to get to the correct line. Regards, Stew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, 8 February 2006 10:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SYS.MESSAGE file being corrupted I've not run into this before but from what you have listed, I'd be looking at what file the write attempt is being performed on. If it's not the SYS.MESSAGE file, which it probably is not, then I'd be looking at how the file open's are being done. I'd suspect the file handle variable being used on line 317 and 382 is no longer the file you think it is. Something to check for, anyway. You might be able to do a display of the file handle variable in the ON.ABORT segment of your program. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, February 07, 2006 2:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] SYS.MESSAGE file being corrupted Has anyone experienced the above and have an explanation I have seen some postings at indexinfocus but no resolution. There doesnt appear to be any 3rd part software involved and the application software doesnt ever reference this file but its occurred 3 times in the last 3 months. The quick fix was to make the file read only. A few days later i start getting errors messages from an edi update program initiated via a script complaining that... Program *SOE.SCHAGE: Line 382, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE attempt on read-only file. Program *SOE.SCHAGE: Line 317, WRITE failure. program executes ON.ABORT I cant reproduce this error and the same update can be run from the menu immediatiatly after the error without a problem. I have started adding in ON ERROR and LOCKED options on the file writes to capture a STATUS() but no results as yet. Have also physically moved the file but made no difference. Plus there was mention of problems of high pid numbers but i dont think this is likely Any suggestions appreciated jak --- 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/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Remove Scenario
Hi Mark, I seem to remember something about an internal point that is maintained for field marks @AM and not value markers @VM. I believe you will get some improvement by trying INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE Regards, Stewart -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, 12 August 2005 13:56 To: u2-users@listserver.u2ug.org Subject: [U2] Remove Scenario Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. One client's application is written in The Programmer's Helper (TPH) which MATREADS and has EQUATES assigning variables like INVNO.TABLE TO CUST(40) etc. The program is written with INVNO.TABLE1,X style extracts everywhere. There are probably 15 mv'd fields with the suffix TABLE and their mv counters are in sync. Prior to using REMOVE (it had an issue on D3), I MATREAD in a BIG(30) array which breezed through the high item count of 155,000 records.(REMOVE took 8 seconds, BIG took around 12 and took over 9 minutes). Here's the rub. This is a Cash Reciept application where the BIG array is one customer's invoices. The load-in process jogs through the BIG array and for those items with a non-zero balance, it creates these 15 TABLE variables. Trouble is, if there's 155,000 total records for this 1 customer, 100,000 may have a balance of zero leaving 50,000 to be handled in the application. So while REMOVE is a great way to extract from BIG as a dynamic array and MATREAD is great for extracting from a DIM array, what would be the best way to build these 15 separately named TABLE variables. The original program (sans REMOVE) looked like this: C=DCOUNT(BIG,CHAR(254)) FOR I=1 TO C ID=BIGI READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN INV.TABLE1,-1=ID AAA.TABLE1,-1=SOMETHING ELSE BBB.TABLE1,-1=SOMETHING ELSE CCC.TABLE1,-1=SOMETHING ELSE MMM.TABLE1,-1=SOMETHING ELSE END END NEXT I So while REMOVE is a great extractor for these 150,000 fields, what is a great inserter for these 15 TABLE variables. In essence, the BAL # 0 is 50,000 records. I tried MV=MV+1 INV.TABLE1,MV=ID etc and got a minor improvement. I tried INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE etc and got a slightly better improvement. In either case, you could see the progressive (exponential) delay as it performs these 50,000 (x 15) TABLE actions. I tried using my DIM BIG(30) where the dim element number was the insertable MV and I used the dynamic array concept on each dimensioned array element. Thus: MV=0 ; L=0 LOOP REMOVE ID FROM XREF AT L SETTING D READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN MV=MV+1 BIG(MV)1=ID BIG(MV)2=SOMETHING ELSE BIG(MV)3=SOMETHING ELSE BIG(MV)15=SOMETHING ELSE END END UNTIL D=0 DO ; REPEAT and it took only 8 seconds. Cool. So now I have a dimensioned BIG array with 50,000 elements each having 15 attributes. Because the infidel TABLE variables are scattered throughout this generated 1,500 line program, I don't want to search and replace them all with their BIG(MV)12 equivilents unless I really have to. Eventually, I have to take these mv'd TABLE variables and writev (sic) them onto the data file. MATBUILD doesn't seem to work with 2 dimensioned dimensioned arrays nor with elements containing attributes or values. It only likes the elements being simple variables. If this were a report program I would kick it off on a phantom and be done with it. Since it's a user oriented Cash Receipts program, the user literally waits 5-9 minutes while a single customer 'loads'. Of course, the larger more important customers are handled more frequently, thus more headaches. So the question is whether there is an INSERT or append function with the magic of REMOVE. Thanks for any insights. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Field Count from a Seq File
Jim, Using READ will work fine until you try it on a very large sequential file and then you will run into Memory Exceed issues. Sometimes this will cause a Layer type 11 fault and crash your session. Regards, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 22 June 2005 23:30 To: u2-users@listserver.u2ug.org Subject: [U2] RE: Field Count from a Seq File Thanks for all the suggestions. I felt most comfortable with doing a quick OPEN, a READ, followed by a DCOUNT(REC,@FM) then a CLOSE F.FILE prior to the OPENSEQ. The reason for this approach is that I wanted to know if the number of READSEQ's needed to read the file would be greater than one, prior to attempting a second READSEQ. Jim - Forwarded by James Ronan/IIG/Prudential on 06/22/2005 09:53 AM - James Ronan Systems To: Phone Number: 732-946-5744 u2-users@listserver.u2ug.org Fax Number: 732-946-5444cc: Subject: Field Count from a Seq File Tuesday June 21, 2005 03:37 PM I hope someone can show me an easy way to get the number of lines from a sequential file - without looping through the file. I am running UV 10.x on a AIX box. I open the file using an OPENSEQ command and I am looping through the record using a READSEQ command. Either immediately after the OPENSEQ or after the first READSEQ, I would like to know if there is more then 1 line in the file. I know that prior to doing the OPENSEQ, I could open the file, read the record and then DCOUNT(RECORD,@FM) to get the number of fields, close the file and then do a sequential open and read. I am hoping that there is a system variable or something that I can use after the OPENSEQ. Looping through the record is not a viable option. Thanks Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SETREM REMOVE (bug in SETREM)
A quick test on uv 10.0.8 And results was A A A A A A As expected. Regards, Stewart -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Friday, 10 June 2005 15:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] SETREM REMOVE (bug in SETREM) What happens if you use different SETTING variables? Maybe setting DUMMY when removing from B(1) interferes with the REMOVE from A. From your example it appears to be REMOVE that's not working properly rather than SETREM. - Original Message - From: Womack, Adrian [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] SETREM REMOVE (bug in SETREM) Date: Fri, 10 Jun 2005 09:05:28 +0800 Here's a simple example: DIM B(2) A = A:@VM:B:@VM:C B(1) = A FOR X = 1 TO 3 SETREM 0 ON A SETREM 0 ON B(1) REMOVE A1 FROM A SETTING DUMMY REMOVE B1 FROM B(1) SETTING DUMMY CRT A1,B1 NEXT X END And this is the output... A A A B A C snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Distributed SELECTs for distributed (Type27) files
Chuck, Each part file can be a type 30 (dynamic file). So you can just about get away with your original subject line. Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Wednesday, 23 March 2005 14:41 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Distributed SELECTs for distributed (Type27) files From: Dan Fitzgerald Subject: Re: [U2] [UV] Distributed SELECTs for distributed (Type30) files I'm a bit confused by the subject line, though. Type 30 or distributed? In UV, type 30 is dynamic. I'm trying to think of a clever excuse for why I called distributed files Type30. Can't. It's Type27. Type30 are dynamically hashed files. Oh well, I only missed it by 2. Thanks for catching that, Dan. Anyways... Assuming a clean accurate PARTFILES (often not a good assumption, I never trust it. and here's where it costs you a little something), you can use that to determine how many parts there are currently. The more accurate way is to query the dist file header (IIRC, it's an mv attribute returned by SYSTEM). STATUS statement: STATUS FSTAT FROM file.var THEN ... ELSE ... From UV10 Basic pg 11-694: Field Stored Value.. Description... 24 Part numbers of part files Multivalued list. If file is a belonging to a distributed part file, this field contains the filepart number, and field 25 is empty. 25 Pathnames of part files Multivalued list. If file is a part belonging to a distributed file, this field is empty. file 26 Filenames of part files Multivalued list. If file is a part belonging to a distributed file, this field is empty. file Of course, the partfiles need not be defined in the VOC for a distributed file to be valid. But the VOC pointers would be needed for this proposed distributed select, so one would have to come up with one's own convention. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV to Web interface
Does require each user to have UniObjects loaded on their PCs or is UniObjects only loaded on the web server? TIA Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 15 February 2005 9:44 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to Web interface Provided you have UniDK and provided your web server will understand ASP pages, I've posted Vance's code to the pickwiki here http://www.pickwiki.com/cgi-bin/wiki.pl?SimpleASP with a few extra comments. Later on (within the month) I will post some other code to do various things, that build on this hopefully. Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] RAID debugger
Mike, The line numbers get messed up in RAID if you have an inline comment after the include. This buggers the line numbers $INCLUDE ARINCLUDE AR.MASTER ;*In line comment and this doesn't $INCLUDE ARINCLUDE AR.MASTER Get rid of the in line comment and the line numbers will be correct. Regards, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Farrant Sent: Thursday, 3 February 2005 1:28 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] RAID debugger Talking of debuggers, can anyone remind me how the $INCLUDE s can mess up the line numbers displayed within the RAID debugger. I had a solution to this once which I seem to remember had something to do with the configuration or placement of the $INCLUDE lines in the source code. I look forward to any response Thanks Mike Farrant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unclassified Performance, Shared Memory Tuning on a UV / Windows system
Is connection pooling a feature of UniObjects.net TIA, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins Sent: Thursday, 20 January 2005 9:31 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unclassified Performance, Shared Memory Tuning on a UV / Windows system Ideally you would use one of: 1. RedBack 2. SOAP/XML 3. UniObjects with connection pooling (e.g. .NET) Each of these has their benefits depending on the weighting of your client workload. Loading programs into the shared memory segment (SHM.TO.LOAD) has a benefit for frequently invoked programs - However ODBC is probably making straight database retrievals and would not benefit from this unless you use lots of virtuals or triggers (if updating). UniObjects would however benefit if you are using subroutine calls. It is worth noting that ODBC got a lot faster at 10.1 - it was a combination of a side effect of some other changes (welcome even so) and some intentional changes. For UniObjects connection pooling is probably the best thing you can do. Hope this helps JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: 19 January 2005 22:19 To: u2-users@listserver.u2ug.org Subject: [U2] Unclassified Performance, Shared Memory Tuning on a UV / Windows system -Original Message- From:MACK ANDREW, F/S Sent:Thursday, 20 January 2005 10:41 To: HENDERSON MIKE, MR Subject: What uses Printer Memory Segments? HI all, We are running UV 10.0.15 on Win 2003. Currently we have an increasing number of calls to our DB from external Web applications and data loading into a warehouse via Microsoft DTS. The web applications use VB6 COM Components and UniObjects to run UniBasic programs to access and update the DB from input by users on a web page. The DTS processes use ODBC to connect to the DB and to suck data down to a SQL Server data warehouse. What I would like to know is does an ODBC connection make use of a Printer Memory Segment? And would these and/or the UniObjects connections (1000's a day) benefit from loading the programs used into Catalog Shared Memory? I have had a good look through the user guides and haven't found anything specific, only mention of users (presumably interactive ones, although that is also not specified). Currently the load is small enough that it would be difficult to measure benefit, but we could quickly expand the amount of work each connection does and I would like to be a bit proactive in this, if possible. Cheers. F/S Andrew Mack Deputy Systems Administrator Atlas Systems New Zealand Defence Force 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/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV quiz
Jerry, I would suggest if the date was the 1st of the month the first locate statement would not find the value as this performs a string comparison as it assumes AL ascending left justified. ie 1 and 01 are not equivalent stings However, the second locate statement would find the value as AR ascending right justified will perform a numerical comparison and in this case 1 and 01 are equivalent values. Regards, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Sent: Thursday, 2 December 2004 9:17 To: [EMAIL PROTECTED] Subject: [U2] UV quiz Try this one A = '1' DAY = OCONV(DATE(),'DD') CRT A:' ':DAY LOCATE DAY IN A1 SETTING MV THEN CRT 'FOUND' END ELSE CRT 'DID NOT FIND' END LOCATE(DAY,A,1;MV;'AR') THEN CRT 'FOUND' END ELSE CRT 'NOT FOUND' END END Jerry Banker --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] TEST
--- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/