Re: [U2] Variable Interpolation

2012-08-23 Thread Mitchell, Stewart
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, includ

Re: [U2] Unusual code

2012-03-14 Thread Mitchell, Stewart
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

Re: [U2] Update the VOC after upgrade?

2012-01-30 Thread Mitchell, Stewart
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 Me

[U2] Solid State Drives (SSD) and Universe

2011-12-18 Thread Mitchell, Stewart
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

[U2] [SB+][UV] SB.WELCOME

2011-12-13 Thread Mitchell, Stewart
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 scre

[U2] Test Post

2011-12-13 Thread Mitchell, Stewart
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. __

Re: [U2] attempting XML.TODB

2011-06-02 Thread Mitchell, Stewart
...@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

Re: [U2] attempting XML.TODB

2011-06-02 Thread Mitchell, Stewart
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 you

Re: [U2] Why should we NOT upgrade to UV11.1.1 ?

2011-05-19 Thread Mitchell, Stewart
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 Aus

[U2][UV] Performance Improvement Hpux 11.23 & 11.31 (Itianium)

2008-11-13 Thread Mitchell, Stewart
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 s

[U2] [UV] Automated Testing

2007-03-21 Thread Mitchell, Stewart
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 a

RE: [U2][UV] XML Extraction

2007-01-03 Thread Mitchell, Stewart
h 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&#

[U2][UV] XML Extraction

2007-01-02 Thread Mitchell, Stewart
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) http://www.ibm.com/U2-xml";>

RE: [U2] [UV] FAST Running while system in use

2006-04-21 Thread Mitchell, Stewart
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

[U2] [UV] FAST Running while system in use

2006-04-21 Thread Mitchell, Stewart
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) with

RE: [U2] SYS.MESSAGE file being corrupted

2006-02-07 Thread Mitchell, Stewart
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

[U2] [UV] ODBC Drivers

2005-10-26 Thread Mitchell, Stewart
Hi All, Does anyone know of any ODBC drivers suitable for conenction to Universe from and Oracle running on linux / unix. I know about the Universe ODBC driver and have installed it on our windows platforms and all is working fairly well. However, we have a requirement to extract Universe data fr

RE: [U2] Remove Scenario

2005-08-11 Thread Mitchell, Stewart
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:[EM

RE: [U2] RE: Field Count from a Seq File

2005-06-22 Thread Mitchell, Stewart
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]

RE: [U2] [UV] SETREM & REMOVE (bug in SETREM)

2005-06-10 Thread Mitchell, Stewart
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)

RE: [U2] [UV] reference a variable indirectly?

2005-04-12 Thread Mitchell, Stewart
Barry, Try EQU LOTNO LIT "VAR.NAMES<2>" Rgds, Stewart -Original Message- From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED] Sent: Wednesday, 13 April 2005 9:07 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] reference a variable indirectly? You could probably use the EQUATE st

RE: [U2] [UV] Distributed SELECTs for distributed (Type27) files

2005-03-22 Thread Mitchell, Stewart
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.u

RE: [U2] UV to Web interface

2005-02-14 Thread Mitchell, Stewart
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

RE: [U2] [UV] RAID debugger

2005-02-02 Thread Mitchell, Stewart
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.

RE: [U2] Unclassified Performance, Shared Memory & Tuning on a UV / Windows system

2005-01-19 Thread Mitchell, Stewart
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 & Tuni

RE: [U2] UV quiz

2004-12-01 Thread Mitchell, Stewart
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 asc

[U2] TEST

2004-09-16 Thread Mitchell, Stewart
--- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] how to assign dimensioned array to a matrix?

2004-06-08 Thread Mitchell, Stewart
Stuart, You could use matbuild. ie matbuild rec.arrary from rec using @am rec.array = lower(rec.array) mat rec.store(pos) = rec.array Regards, Stewart -Original Message- From: Mitchell, Stewart Sent: Wednesday, 9 June 2004 15:01 To: '[EMAIL PROT

RE: [U2] how to assign dimensioned array to a matrix?

2004-06-08 Thread Mitchell, Stewart
Stuart, You could use matbuild. ie matbuild rec.arrary from rec using @vm mat rec.store(pos) = rec.array Regards, Stewart -Original Message- From: Stuart Boydell [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 June 2004 14:21 To: U2-Users Subject: [U2] how to assign dimensioned