Re: [U2] Licensing
Not sure if I read DW's message correctly, but we have device licensing here and it works as follows; 1 device license means from 1 IP/device you can login to a maximum 10 uv sessions (thus only using 1 license) So 10 device licenses (10 individual IP's) equates to maximum number of 100 sessions . And can you mix your licenses on one machine?? Regards, Jeff Marcos -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 6:38 AM To: 'U2 Users List' Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing You have to BUY device licensing for this to be true... If you device license 3 devices - and connect 4 sessions from one IP, you will end up using TWO seats - one for the first 3 sessions, and then 1 for every session thereafter. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, October 21, 2010 2:32 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing On Thu, 21 Oct 2010, charles_shaf...@ntn-bower.com wrote: I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. Note that (unless something changed recently) your licensing actually is based on number of users, not sessions. If you have a terminal emulator that can handle this, properly configured, one user on one machine with 5 open sessions will consume only one license. Our Anzio emulators can do this. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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 The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 271 7600 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Universe Triggers
From our testing a couple of years back (using version 10.2), we found triggers to be very very very slow compared to indexes. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa Sent: Wednesday, 8 October 2008 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Triggers We are getting ready to implement triggers on a universe system running under Windows Server 2003. I created a trigger and tested it out and it appears to do exactly what we need. My question is are there any gotchas or issues we should be concerned about with triggers? Are there any performance issues that anyone has seen related to triggers? Thanks, Mike Roosa --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 279 2555 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse? results
David, thanks for the little challenge. I took your code you suggested to try and created the below program: Please feel free to comment or improve the code. Unfortunately I don't have all day to refine (wish I could though). Due to company policy, I can't at this point in time release any code produced at this company other than the test code below. You'll see in the results that Recordsc-Sort uv-Sort 1,0000:010:06 10,000 0:010:22 20,000 0:011:19 50,000 0:01 8:34 999,99920 (gave up after 25 minutes) Plus you really start to see the speed improvement when you also have to sort fields that have dependant attributes. Ps. We run IBM P series with lots of memory and cpu Final comment from Phil a colleague here: What this points to is the need for IBM to develop an inbuilt high speed multivalue sort function call that uses faster methods then 'LOCATE' and 'INSERT'. Can we put this on the wishlist ~~ PROGRAM TST.SORT * $INCLUDE SYINCLUDE COMMON * PROMPT scrPos = 3 CRT @(-1):@(3,scrPos):*** START *** scrPos += 2 CRT @(3,scrPos):Number of ids : INPUT NUM IF NOT(NUM) OR NUM 1 THEN STOP END * scrPos += 2 CRT @(3,scrPos):Start Time for RND function : :TIMEDATE() EVALNUM = NUM * 100 VARIDS = '' FOR X = 1 TO NUM VARIDS := @VM:RND(EVALNUM) NEXT X VARIDS = DELETE(VARIDS,1,1,0) ;* first MV entry is null * scrPos += 2 CRT @(3,scrPos):Time taken so far after RND build : :OCONV(((DATE()[EMAIL PROTECTED])*8400)+(TIME()[EMAIL PROTECTED]),MTS) * GOSUB RESORT.C * scrPos += 2 CRT @(3,scrPos):Time taken so far after C version sort : :OCONV(((DATE()[EMAIL PROTECTED])*8400)+(TIME()[EMAIL PROTECTED]),MTS) * SortBy = 'DR' InArray = VARIDS AllowDups = @TRUE OutArray = '' GOSUB RESORT.U2: * scrPos += 2 CRT @(3,scrPos):Time taken so far after U2 version sort : :OCONV(((DATE()[EMAIL PROTECTED])*8400)+(TIME()[EMAIL PROTECTED]),MTS) CRT CRT *** END *** * RETURN * * RESORT.C: * RECORD = VARIDS scrPos += 2 CRT @(3,scrPos):Start sort function (C) version -- # of VM's :COUNT(RECORD1,@VM) PARAM = DR,1 CALL REORDER * RETURN * * RESORT.U2: * scrPos += 2 CRT @(3,scrPos):Start sort U2 version -- # of VM's :COUNT(InArray,@VM) If SortBy = then SortBy = AL *OutArray = Remove(InArray, MoreItems) *ArrayDelim = @RM:@AM:@VM:@SM:@TM[MoreItems, 1] * LOOP Item = Remove(InArray, MoreItems) Locate Item in OutArray by SortBy setting Pos then If AllowDups then Ins Item before OutArrayPos End else Ins Item before OutArrayPos End While MoreItems Do Repeat * * SWAP @AM, ArrayDelim in OutArray * RETURN * ~ Test results: 1. *** START *** Number of ids 99 Start Time for RND function : 09:57:08 24 JUL 2008 Time taken so far after RND build : 00:00:10 Start sort function (C) version -- # of VM's 98 Time taken so far after C version sort : 00:00:30 Start sort U2 version -- # of VM's 98 Break: Option (A,C,L,Q,?) =A DEV TIME 10:22:11 24 JUL 2008 DEV 2. *** START *** Number of ids 1000 Start Time for RND function : 10:29:36 24 JUL 2008 Time taken so far after RND build : 00:00:05 Start sort function (C) version -- # of VM's 999 Time taken so far after C version sort : 00:00:05 Start sort U2 version -- # of VM's 999 Time taken so far after U2 version sort : 00:00:06 *** END *** 3. *** START *** Number of ids 1 Start Time for RND function : 10:30:07 24 JUL 2008 Time taken so far after RND build : 00:00:04 Start sort function (C) version -- # of VM's Time taken so far after C version sort : 00:00:04 Start sort U2 version -- # of VM's Time taken so far after U2 version sort : 00:00:22 *** END *** 4. *** START *** Number of ids 2 Start Time for RND function : 10:53:51 24 JUL 2008 Time taken so far after RND build : 00:00:07 Start sort function (C) version -- # of VM's 1 Time taken so far after C version sort : 00:00:07 Start sort U2 version -- # of VM's 1 Time taken so far after U2 version sort : 00:01:26 *** END *** 5. *** START *** Number of ids 5 Start Time for RND function : 10:56:26 24 JUL 2008 Time taken so far after RND build : 00:00:03 Start sort function (C) version -- # of VM's 4 Time taken so far after C version sort : 00:00:04 Start sort U2 version -- # of VM's 4 Time taken so far after U2 version sort : 00:08:38 *** END *** The information contained in this email and any attached files are strictly private and confidential. This email should
RE: [U2] Basic SORT() Function not avail in UniVerse?
We had the same issue back in the 90's. So a clever guy (Ed) that worked with us wrote a small C program (on Unix) to do the sort. This also included controlling/dependants fields. Any universe program could call it, passing in the variables and returned the items sorted. Speed is incredible. To this day it's still used and blitzes any universe program methods in sorting large arrays. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 23 July 2008 6:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Hey, and don't forget to do a speed test. You know, because LOCATE is coded as part of the OS it just *might* be faster than bubble or speed sort options. In fact, this was a topic on this list about 3 or 4 years ago and someone doing the speed test concluded LOCATE was in fact faster. And no I don't remember who it was, or have a link to the thread (sorry) :-) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:26 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 279 2555 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV basic assignment error ?
Hi Scott, You need to initialise Y to null at the start too. Y = Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Tuesday, 11 September 2007 11:35 AM To: u2-users@listserver.u2ug.org; Dana Moore Subject: [U2] UV basic assignment error ? Here is a weird UV error condition that I just spent way too long debugging: CT BP SB SB 0001 X = 0002 IF X EQ THEN X = Y 0003 PRINT ONE 0004 PRINT TWO 0005 PRINT THREE 0006 PRINT X 0007 Y = A RUN BP SB ONE TWO THREE Program SB: Line 6, Variable X previously undefined. Empty string used. Why does the run-time error happen in line 6 instead of line 2? This is _not_ what I was expecting. In D3: :run bp sb [B10] in program sb, Line 2: Variable has not been assigned a value; zero used. ONE TWO THREE 0 I like the way D3 reports this better. Is this a normal, known UV thing? Perhaps this is just the first time I have ever tripped over it... /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sacred Licence Seat - A Challenge
Why don't you investigate device licensing? This allows users to have up to 10 connections per device while only taking up one licence. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee Sent: Friday, 17 August 2007 12:23 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: [U2] Sacred Licence Seat - A Challenge Does anyone have a way to set one licence seat as sacred? There are 15 users in the organization and 20 licences for UniVerse. But users will open more than one session if they can. We need one licence always available for when an internet connection is made. How do we keep one unused? Is there a UniVerse setting that prevents a seat from being taken locally? Has someone out there done this? Would you like to share the technique? Any suggestions? Jeffrey Lee 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 7000F: (08) 9315 7088 W: http://www.itvision.com.au 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 To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] List of ERP suppliers
Hi all, Can anyone suggest a very good ERP solution running on universe? Regards, Jeff Marcos --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Off topic: PCI Compliance
Hi Baker, We too are looking at being PCI complaint. We have a Universe DB with SB+ and running telnet sessions on the client side. We're being told that the credit card data must be separated from the application onto another database behind another firewall. This adds the complexity of communicating with another database (non u2 product). Encrypting the data was just not enough. This is certainly turning into another Y2K (like) money spinner... Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, 27 April 2007 2:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Off topic: PCI Compliance As Bob noted, the DSS is a global initiative by the major card brands. It is huge, and produces negligible ROI for all your effort, except it protects your brand name, which is no small thing. At least 1/2 of your effort is going to be other than in-house coding. a) Reviewing / Re-writing business processes/procedures in light of the standard. (Which will precipitate other code mods, not directly involved in your PCI implementation) b) Network scanning - initially and at regular intervals. c) Attack simulation - test your defenses. d) Response planning - in the event of successful penetration And if you are a service provider, the ante is even higher (if you process payment card transactions directly with banks, for others). Although the deadline has passed, there are more non-compliant merchants and suppliers than the PCI Council can bludgeon effectively. That, according to what our compliance officer is reading. However, this default mercy would naturally evaporate the second someone penetrates your data security. (Fine$) As for the encryption piece - it is reportedly easier with UV 10.2 but I still have questions about key management. Maybe someone who is on 10.2 or the UniData version that has 'Data-at-Rest' encryption at the database level, can respond and explain how it works, and fulfills the PCI DSS requirements. GPG provides the DES3 minimum requirement, and coming/expected AES requirement. The UniVerse ENCRYPT and ENCODE functions (10.0 or higher) are pretty good. Encrypt will do DES3 but won't handle key certificates. I have a simple workaround for outstanding IBM issue 8088. But these were only designed for 'Data-in-motion', not at rest. HTH, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Thursday, April 26, 2007 9:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Off topic: PCI Compliance No we are looking at PCI DSS too The Issuers are trying to get it in globally I have a full spec if you would like it Main problem we can see is the encryption, rest of it is pretty straightforward -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: 26 April 2007 15:32 To: u2-users@listserver.u2ug.org Subject: [U2] Off topic: PCI Compliance Just wondering with any other companies are trying to deal with PCI compliance and if this is only limited to the US. Brenda --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ 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 To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #1538
Hi Susan, When in Universe on windows, you can view the voc entry for UFD. Attribute three (3) will have the path. Of course you will need to strip out the DICT filename or extract it via FIELD(vocRec3,'\',1,COUNT(vocRec3,'\')). CT VOC UFD UFD 0001 F 0002 . 0003 C:\IBM\UV\D_UFD Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 13 March 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: U2 Users Digest V1 #1538 Hi Everyone. On help with file pointers thanks to everyone who has pitched in. So far I'm no joy. FILEINFO doesn't return just a hard path. STATUS doesn't seem to return anything. Ls -I might do the trick on UNIX but I need a Windows solution, too (and first). I think I can do the peel back/parsing thing. Was hoping not to have to do that. Anybody got anything else? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2 user group in Australia. Is ther one?
Hi all, Is anyone aware of a scheduled U2 user group meeting in Sydney or even Australia? Is there a need for one? Regards, Jeff Marcos * Phone: +612 9335 0104 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] XML Extraction
Try using the 1. PrepareXML(XML/:XML.KEY,XML_HANDLE) 2. OpenXMLData(XML_HANDLE,XML.EXT,XML_DATA_HANDLE) 3. ReadXMLData(XML_DATA_HANDLE,rec) 4. CloseXMLData(XML_DATA_HANDLE) 5. ReleaseXML(XML_HANDLE) XML.EXT = the extraction map Rec = the extracted data Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: Wednesday, 3 January 2007 2:32 PM To: 'u2-users@listserver.u2ug.org' Subject: [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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.0.7 - System(9001) and transactions
Hey Stuart, Guess what, it still happens in version 10.1.22 of universe. I'm using UO and in a normal basic program we retrieve the contents of system(9001) when an error occurs. I believe this is a bug. Regards, Jeff Marcos * Phone: +612 9335 0104 * Fax: +612 9335 0753 * Email: [EMAIL PROTECTED] -- Date: Wed, 20 Dec 2006 22:49:25 +1100 From: Boydell, Stuart [EMAIL PROTECTED] Subject: [U2] [UV] 10.0.7 - System(9001) and transactions Not sure if anyone else has come across this but I just found out that under certain circumstances, calling system(9001) will hang a process. As it's almost time for the Feast of Saturnalia I thought I'd share. I have a file that has a file trigger - this is just an audit stamp of when, who and a system(9001) stack-trace that writes into an audit file. This works fine for most circumstances except when it is updated from (in our case) UniObjects. This is all complicated as the UO process runs in an update transaction, which calls a trigger that also runs in an update transaction so tracking it down was Fun. I had to amend the audit trigger program to make it run without hanging by adding the following exception... *// EXCEPT uvcs - hangs transaction as at UV 10.0.7 if @tty # 'uvcs' then auditRec := @am:lower(system(9001)) I haven't had time to try this for any other circumstances or versions of UV but hope it helps someone. Merry King Cole to one and every. Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Storing images on U2 database via UODOTNET
Thank you all for the information. I just wished I knew all the system() variables. I'm sure it's been asked before, but is there a complete list for all the system() variables and their operations? I'm aware of a number of them but system(1017) was a new one... For information on examples and ideas for .NET see http://www.codeproject.com/ http://www.codeproject.com/csharp/imageresize.asp Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Veenhof Sent: Wednesday, 20 December 2006 12:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Storing images on U2 database via UODOTNET Hi, Just about to attempt this process from .NET using UODOTNET, anyone have any advice off the bat, any concerns I should have? Thanks, Pete From: [EMAIL PROTECTED] on behalf of Uffe Toft Sent: Mon 18/12/2006 8:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] Storing images on U2 database. Hi Jeff, I'll recommend a Dynamic UniVerse file (TYPE 30) for storing binary data like images. Most likely all records will be stored as large records giving almost direct assess. It performs fine and there is no practical limits in the total size or the no. of records to be stored in a 64BIT file. Alternatively, you could for administrative reasons spread the images in more 32BIT files each holding maybe 2GB. The internal format of Dynamic files makes it also a protected way of storing READONLY images. Using TYPE 1 or 19 files will slow down the OS system, if you have hundreds of thousands or millions of images You will need a TYPE 1or 19 file as a temporary place for moving binary files to and from the Dynamic file. Any UniVerse reads and writes to the TYPE 1 or 19 file must by binary. E.g.: READ IMAGE.RECORD FROM F.DYNAMIC.FILE, IMAGE.ID ELSE END ASSIGN SYSTEM(1017) TO 1 ;* binary on WRITE IMAGE.RECORD TO F.TYPE19_FILE, IMAGE.ID ASSIGN SYSTEM(1017) TO 0 ;* binary off The method may be different in UniData. Regards, Uffe Toft Steria Denmark [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Storing images on U2 database.
Hi all, Has anyone had experience with storing images (gif, tiff, bmp or jpg) files on Universe database? If so, how or what documents describe this feature? Thanks in advance. Regards, Jeff Marcos Corporate Express Aust. Ltd Masterpack (ERP) Technical Lead (BIS) * Phone: +612 9335 0104 * Fax: +612 9335 0753 h Support: +612 9335 0501 * Email: [EMAIL PROTECTED] * Web site: www.ce.com.au http://www.ce.com.au/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Record Deletion in Universe (on behalf of Greg Ritchie)
Hi Does anyone know of any means of determining precisely when a record deletion is in progress at universe level (returning information similar to the STATUS function)? We have a file where an index is used for data field validation and it is picking up some but not all fields as failing validation when the record is being deleted. We've attempted to use Triggers Indexes on the same file and later found this caused problems. Not sure if it's relevant but we are an (old version) SB+ site. Thanks in advance. Regards Greg Ritchie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do you find out about file operation within an index?
Hi Phil, Thanks again. Here's the trigger code. Not sure what you meant by 'log' file. MY.TRIGGER 0001 SUBROUTINE MY.TRIGGER( TRIGGER.NAME, SCHEMA, FILE, EVENT, TIME, NEWREC.ID, NEWREC, OLDREC.ID, OLDREC, ASSOC, ASSOC.EVENT, COUNT, CHAIN, CASCADE ) 0002 ** 0003 * define a trigger for testing reasons 0004 * 0005 ** 0006 $INCLUDE SYINCLUDE COMMON 0007 COMMON/SQLTRIG/ AUDITFV 0008 * 0009 NEWREC2 = OK 0010 RETURN Here's the executing program. 0001 PROGRAM TEST.TRIG 0002 * 0003 $INCLUDE SYINCLUDE COMMON 0004 * 0005 OPEN '','JUNK.TRIG' TO JUNK.TRIG ELSE STOP 201, 'JUNK.TRIG' 0006 * 0007 RECORD = 5 0008 ID = 1 0009 * 0010 CRT OCONV( TIME(), MTHS ) 0011 START.TIME = TIME() 0012 FOR X = 1 TO 5000 0013 IF NOT(MOD(X, 1000)) THEN CRT X 0014 WRITE RECORD TO JUNK.TRIG,ID 0015 NEXT X 0016 END.TIME = TIME() 0017 CRT OCONV( TIME(), MTHS ) 0018 * 0019 DIFF = END.TIME - START.TIME 0020 PRINT DIFF: :OCONV( DIFF, MTS ) 0021 * 0022 RETURN Results. Without Trigger RUN BP TEST.TRIG 05:00:24pm 1000 2000 3000 4000 5000 05:00:24pm DIFF: 00:00:00 With Trigger RUN BP TEST.TRIG 05:02:07pm 1000 2000 3000 4000 5000 05:02:34pm DIFF: 00:00:27 Comments welcomed :) Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: Thursday, 11 May 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you find out about file operation within an index? Jeff, I cannot see how you can do it any quicker? The only thing you could hope for is that IBM look at how they call they trigger subroutine, (while they are fixing the issue with the debugger - my personal battle...:-) ), as whatever basic code you come up with to capture the information will be the same as what you put in the trigger. The advantage of the trigger is that you are assured that it will be executed Maybe you can check your code to see how efficient it is in doing writes. Hopefully it is only doing the write once, and not repeatedly doing the writes or writevs. as this will indeed cause the trigger to fire more than once. The other thing to do with the trigger code is to open the 'log' file variable into common, and be very efficient in what you are doing... Do not take this as a criticism of your code, as without seeing it, noone could say. But as the code is going to be called every time the database does a write or a delete then it needs to be efficient. Cheers, Phil. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Marcos Sent: Thursday, 11 May 2006 12:31 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] How do you find out about file operation within an index? Thanks for the feed back Phil, but triggers are too slow. We ran a very simple test and found with triggers, it took 27 seconds to update 5000 records. Without a trigger it took 1 second... Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
[U2] How do you find out about file operation within an index?
Hello all, I'm wondering if there is a way to identify, within a file index, what type of file operation has occurred. Example; we have a program in an index to do some checks. We would also like to find out, what the user is doing; delete, write, read, readu, etc,... Using triggers is not an option, because it just way too slow... Unless someone could tell how to speed up triggers. Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse + PERL
This is great Kevin. There is a whole new world to explore Regards, Jeff Marcos This e-mail is for the use of the intended recipient(s) only. If you have received in error, please notify the sender immediately and delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. Corporate Express checks all outgoing mail and accepts no liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Sproule Sent: Thursday, 4 May 2006 12:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse + PERL You can also use Win32::OLE to connect to UV. This script counts the VOC: #!/perl/bin/perl.exe -w use Win32::OLE; my ($err, $result, $cmd); use constant UV_SESSION_OBJECT = 'UniObjects.unioaifctrl'; # name of UniObject session object $uv = Win32::OLE-new(UV_SESSION_OBJECT) or die Cannot get session object: $!\n; $uv-LetProperty('UserName','kevin'); $uv-LetProperty('Password','password'); $uv-LetProperty('HostName','192.168.246.139'); $uv-LetProperty('AccountPath', 'KEVIN'); $uv-Connect; # open connection to sever if (! $uv-IsActive) { # check status print Not Connected: $uv-{Error}\n; exit; } print Connected\n; $cmd = 'COUNT VOC'; $uv-Command-LetProperty('Text', $cmd); $uv-Command-Exec; $err = $uv-Command-{'CommandStatus'}; print $uv-Command-{'Response'}; $uv-Disconnect; # close connection to server Date: Tue, 2 May 2006 18:35:48 +0800 From: Ang Suan Yong [EMAIL PROTECTED] Subject: [U2] UniVerse + PERL Dear All Is it possible to use Perl connect to UniVerse backend to run some UV Command , like CREATE FILE , SELECT FILE? Current im trying using DBD::ODBC , the uv connection is find but statement execution failed . any idea ?? use DBD::ODBC; my $db = DBI-connect('dbi:ODBC:UVSOURCE',userid,password) || die(Connection failed) ; my $cmd=SELECT * FROM VOC; ; my $stmt= $db-prepare($cmd); Error Shown as below : DBD::ODBC::db prepare failed: [IBM][UVODBC][2700828] Error ID = 23 , Severity: ERROR Facility: DBCAPERR - Line 1, column 15 (around VOC): SQL statement referenced a nonexistent table or view. Thanks Regards Kevin Sproule Sr. Technical Consultant AFS Technologies, Inc. 2141 E. Highland Ave. Suite 100 Phoenix, AZ 85016 Office 602-522-8181 | Mobile 602-549-0470 | Email [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Problem with JDBC and basic programs
Hi all, We're experimenting with the Uni JDBC software and have come across an issue. *** java.sql.SQLException: Program CREATE.MP.LOG: Line 36, FATAL: The locks necessary for database operations at the current isolation level (2) are not held by this process. *** The program mentioned (in the error) is initiated via a file index. We were just trying to write to a file (using Java JDBC) which contains an index, that calls a program CREATE.MP.LOG. The program works fine in basic code both interactively and phantoms. The program contains OPEN's, READ's and initialisation of variables in a common block. I believe the line in question is an OPEN statement. Its difficulty to tell due to a high number of includes in the code. Line 36 doesn't necessarily mean line 36. Line 36 refers to (via VLIST) a complete section of code in the include. Universe Version : 10.1.14 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Fw: More U2 programming hints
I must agree that a BASIC SELECT is quicker but... Don't you run the risk of missing groups (in the read function) in this type of select? If users are updating this file they could insert data into a group which you may already passed. You would only use this type of select when no one is updating this file. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Mark Johnson Sent: Thursday, 6 October 2005 10:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Fw: More U2 programming hints I can't see how a BASIC SELECT can be slower than EXECUTE SELECT. It doesn't have to go through to get 'xxx items selected' before it processes the first one. I also don't believe the mechanical difference once it begins, ie 'find the next group' etc. Wouldn't you think that this at least spares the actual hashing as it is navigating through the file sequentially. I would really like to see a great proof program against BASIC SELECT. I often replace EXECUTE SELECT with a BASIC SELECT over the years *because* it has always ran faster, regardless of platform. I've had many opportunities to be proven wrong. I've tested every replacement and have always reported an improvement. Thanks. MarkJohnson - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, October 04, 2005 5:45 PM Subject: RE: [U2] Fw: More U2 programming hints This is the way it was explained to me way back in '88. The internal select is slower on the whole file, but immediate in response. It works the same as LIST. If I list a file with 2,000,000 records I get immediate response. If I want to process an entire file, then external select is slower on response, i.e. I have to wait for 2 million records to be selected before processing begins, but is quicker in processing all records. The internal is slower due to the system having to stop what it's doing, find the next group, break out the individual ID's from that group, and then return it to the program - over and over again as it makes it's way through the file. hth! Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Tuesday, October 04, 2005 14:24 To: u2-users@listserver.u2ug.org Cc: Louis Windsor Subject: RE: [U2] Fw: More U2 programming hints This is a bit disconcerting. BASIC SELECT should be faster than EXECUTE SELECT... Maybe the smart people can weigh in on this: From: Louis Windsor A few years ago we used the BASIC SELECT FILE as opposed to the EXECUTE SELECT FILE. We updated UniVerse (don't ask from what version to what version as I don't remember) and overnight ALL our programs ran five or six times longer. Completely contrary to my experience and counter-intuitive, too. We were told (by VMark) that the BASIC SELECT now selected each group but it could be optioned to work the old way. Hmmm, do I vaguely, hazily remember something about that? Maybe on this list? Maybe in release notes? No uvconfig option jumps out at me. I don't think flavor would matter, or $OPTIONS [-]VAR.SELECT. $OPTIONS FSELECT would slow the BASIC SELECT down to approximately the same as EXECUTE SELECT..., but not make it slower. Louis, do you, perchance, use $OPTIONS FSELECT? Maybe buried in a $include file common to every program? I wrote a conversion program to change ALL BASIC SELECTs to executed SELECTs in the source and recompiled and that is the way we have done it ever since. I don't know if things are different now but we have grown to prefer EXECUTEd selects as selection criteria can be included. Louis, can you run a simple benchmark and see if this is still true? Or show us an example of your own? INTERNAL: OPEN [really big file] TO F ELSE STOP CRT 'I1', TIMEDATE(), SYSTEM(9) SELECT F CRT 'I2', TIMEDATE(), SYSTEM(9) LOOP WHILE READNEXT ID READ REC FROM F, ID ELSE NULL REPEAT CRT 'I3', TIMEDATE(), SYSTEM(9) EXECUTED: OPEN [really big file] TO F ELSE STOP CRT 'E1', TIMEDATE(), SYSTEM(9) EXECUTE SELECT [really big file] CRT 'E2', TIMEDATE(), SYSTEM(9) LOOP WHILE READNEXT ID READ REC FROM F, ID ELSE NULL REPEAT CRT 'E3', TIMEDATE(), SYSTEM(9) (Run each a couple times, to allow for i/o differences in loading data buffer cache.) There should be virtually no elapsed time between I1:I2 above, but long elapsed time between E1:E2. I expect I2:I3 to approximately equal E2:E3. Let me explain why this is counter-intuitive. Normally, the BASIC SELECT statement itself does not actually do any select on the file. It merely sets
RE: [U2] U2 XML
Hi Bob, I execute the following command and trap the output. LIST filename key CLIENTID ORIGTRXREF INTERFACE TOXML ELEMENTS XMLMAPPING xmlfilename.map (I And here's my test extraction: _ Program * STATUS=PrepareXML(XML/xmlfile.xml,filename_XML) IF STATUS=XML.ERROR THEN STATUS = XMLError(errmsg) PRINT error message :errmsg STOP Error when preparing XML document END STATUS = OpenXMLData(FILENAME_XML,'FILENAME.ext',FILENAME_XML_DATA) IF STATUS = XML.ERROR THEN STOP Error when opening the XML document. END IF STATUS = XML.INVALID.HANDLE THEN STOP Error: Invalid parameter passed. END MOREDATA=1 LOOP WHILE (MOREDATA=1) STATUS=ReadXMLData(FILENAME_XML_DATA,rec) IF STATUS = XML.ERROR THEN STOP Error when preparing the XML document. END ELSE IF STATUS = XML.EOF THEN MOREDATA = 0 END REPEAT * CRT _ Starting response ___ STATUS = CloseXMLData(FILENAME_XML_DATA) STATUS = ReleaseXML(FILENAME_XML) cntr = 0 LOOP REMOVE line FROM rec SETTING ATTB2 cntr += 1 PRINT cntr: - :line WHILE ATTB2 DO REPEAT CRT _ End of response ___ * RETURN _ Regards, Jeff Marcos BIS - Corporate Express Aust. Ltd -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 June 2004 12:22 AM To: [EMAIL PROTECTED] Subject: RE: [U2] U2 XML Many thanks to all who responded, except IBM who have been about as useful as a 3 legged ferret! Jeff Where does the U2XMAP file fit in, I understand what a U2XMAP has in it but how do I key the file so that it can pick up from my .ext ?, it seems to need it Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Marcos Sent: 15 June 2004 01:56 To: '[EMAIL PROTECTED]' Subject: RE: [U2] U2 XML Hi Bob, Just recently I started working with XML in universe, using the same routines as you and have no problem with creating and reading in XML. The only difference I found was the use of the following line in the .ext is in XML. I don't mention this at all. 0002: U2xml-extraction xmlns:U2xml=xsi:schemaLocation=http://www.opentravel.org/OTA/2003/05 OTA_PingRQ.xsd Here's a sample of my .map in XML Map to a XML file: 0001 U2xml root=ceXML/ 0002 U2xml record=PaymentRequest/ 0003 U2xml file=FILENAME 0004 field=CLIENTID 0005 map-to=ClientID 0006 treated-as=element 0007 / 0008 U2xml file=FILENAME 0009 field=ORIGTRXREF 0010 map-to=OriginalTransactionReference 0011 treated-as=element 0012 / 0013 U2xml file=FILENAME 0014 field=INTERFACE 0015 map-to=Interface 0016 treated-as=element 0017 / Here's a sample of my .ext in XML To extract: 0001 U2xml_extraction 0002 file_extraction start = /Payment dictionary = VOC/ 0003 field_extraction field = USERID path = PaymentHeader,UserID/text() / 0004 field_extraction field = UNIQUEID path = PaymentHeader,UniqueID/text() / 0005 /U2xml_extraction regards, Jeff Marcos -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 June 2004 9:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2] U2 XML Hi Bob There are many using xml to inteface to U2. Some are doing it through RedBack, or they created their own parsers before u2 implemented one or they are using the client such as .Net or java to parse xml. There are a few who use the U2 interface, but maybe away from the office at the moment. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Monday, 14 June 2004 11:45 PM To: [EMAIL PROTECTED] Subject: [U2] U2 XML Hiya: I send an email last week asking for help on an xml to U2 problem we have. Since not a lot of response came back we are now wondering if any of you are using xml to interface into U2 We are beginning to feel like pathfinders Yeas or nays appreciated Bob __ 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 [EMAIL PROTECTED
RE: [U2] U2 XML
Hi Bob, Just recently I started working with XML in universe, using the same routines as you and have no problem with creating and reading in XML. The only difference I found was the use of the following line in the .ext is in XML. I don't mention this at all. 0002: U2xml-extraction xmlns:U2xml=xsi:schemaLocation=http://www.opentravel.org/OTA/2003/05 OTA_PingRQ.xsd Here's a sample of my .map in XML Map to a XML file: 0001 U2xml root=ceXML/ 0002 U2xml record=PaymentRequest/ 0003 U2xml file=AR.CC.CHARGE 0004 field=CLIENTID 0005 map-to=ClientID 0006 treated-as=element 0007 / 0008 U2xml file=AR.CC.CHARGE 0009 field=ORIGTRXREF 0010 map-to=OriginalTransactionReference 0011 treated-as=element 0012 / 0013 U2xml file=AR.CC.CHARGE 0014 field=INTERFACE 0015 map-to=Interface 0016 treated-as=element 0017 / Here's a sample of my .ext in XML To extract: 0001 U2xml_extraction 0002 file_extraction start = /Payment dictionary = VOC/ 0003 field_extraction field = USERID path = PaymentHeader,UserID/text() / 0004 field_extraction field = UNIQUEID path = PaymentHeader,UniqueID/text() / 0005 /U2xml_extraction regards, Jeff Marcos -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 June 2004 9:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2] U2 XML Hi Bob There are many using xml to inteface to U2. Some are doing it through RedBack, or they created their own parsers before u2 implemented one or they are using the client such as .Net or java to parse xml. There are a few who use the U2 interface, but maybe away from the office at the moment. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Monday, 14 June 2004 11:45 PM To: [EMAIL PROTECTED] Subject: [U2] U2 XML Hiya: I send an email last week asking for help on an xml to U2 problem we have. Since not a lot of response came back we are now wondering if any of you are using xml to interface into U2 We are beginning to feel like pathfinders Yeas or nays appreciated Bob __ 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 [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Problem with xml within UV
Thank you all for the information. I have since discovered the problem and how to rectify it. For those who are interested, I found that when creating Field Definition in SB+ they create an A type field definition, these cannot be used. When producing XML in UV, the dictionary type must be a D type. And field 6 describes whether the attribute is S (Single valued) or M (Multi-valued). Since SB+ created the field, this option was never set. I hope I explain my self. Thanks again. Jeff Marcos BIS - Corporate Express Aust. Ltd -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 May 2004 4:45 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Problem with xml within UV There is no problem producing XML from a program in UV (obviously?) , but I can't speak to the inbuilt UV facilities. Our Visage product uses a universal driver routine that allows us to produce XML, delimited files such. I also note that a number of people on this list use the DOWNLOAD product from Cedarville University ... search the archives you should find a link (the beauty of a program, rather than inbuilt facilities that are rigid, is that it can always be tweaked to match the situation at hand Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jeff Marcos Sent: Tuesday, 18 May 2004 10:23 AM To: '[EMAIL PROTECTED]' Subject: [U2] Problem with xml within UV SNIP Does this mean UV has a limitation? Has anyone produced XML within the UV environment (program or retrieve)? Am I missing something here? We're running universe 10.0.14 on AIX. I'm starting to believe that UV cannot do what it says it can do... Regards, Jeff Marcos BIS - Corporate Express Aust. Ltd --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] Problem with xmlExecute()
Hi all, In the UniVerse Basic Extensions pdf, it makes reference to XMLEXECUTE() (see section 5-8 Version 10.1 September, 2003), but do you think I could find any documentation on this command. Has anyone found this command in any documentation or even better still used it? I'm trying to produce XML documents within a basic program. We're running universe 10.0.14 on AIX. Thanks in advance, Jeff Marcos BIS - Corporate Express Aust. Ltd ph:(02) 9335 0585 fax: (02) 9335 0753 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users