Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread David Wolverton
It was definitely 'mapped' into our world. There are steps in the API that logically would never be used 'standalone', but as the underlying process broke the functions out as the underlying API did -- for example -- the PrepareXML must be followed by OpenXML -- why show that to us developers?!? W

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Hona, David
Hi Gregor Thanks for sharing your useful experiences and your blog. I found the same issue with U2 MQSeries API documentation too. Although, I guess when you are using such complex API's - it helps first to understand the underlying technology and concepts. Be it MQSeries or XML, etc. Otherwise

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Steve Romanow
Compared to something like lxml it seems rather clumsy and unmaintained. On 10/26/10, Gregor Scott wrote: > I actually like the XML handling built into UV. I have always been a > believer in using the intrinsic facilities of the database where possible to > maximise the performance of the process

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Gregor Scott
I actually like the XML handling built into UV. I have always been a believer in using the intrinsic facilities of the database where possible to maximise the performance of the process being automated. The XDOM API is a good example of this, and is a good fit for our requirements. My biggest is

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-10-26 Thread Leverett, Brendon
Experienced a similar thing a while back and decided to use NAP as well. Even went as far as changing the NAP depending on how long the period of inactivity has been. Sample code: LASTTIME = TIME() FOUND.CMD = @FALSE LOOP UNTIL FOUND.CMD DO ELAPSED =

Re: [U2] INPUTIF statement in Universe {Unclassified}

2010-10-26 Thread HENDERSON MIKE, MR
I.E., add the line with "NAP" in it. You may want to try different NAP intervals to work out the best balance between snappy user response and CPU usage. OK = 0 ; START.DT = DATE() ; START.TM = TIME(); TIME.OUT = 900 LOOP INPUTIF PSN TH

Re: [U2] INPUTIF statement in Universe

2010-10-26 Thread Dan McGrath
Hi Eric, We get around this by using an optimistic locking strategy if and only if there must be user input between the original record read and final record write. Depending on the usage of your system, this might prove to be a better solution? Regards, Dan -Original Message- From: u2-u

Re: [U2] INPUTIF statement in Universe

2010-10-26 Thread FFT2001
In a message dated 10/26/2010 11:58:58 AM Pacific Daylight Time, eric.rosenzw...@petco.com writes: > In testing, it's the INPUTIF statement that's utilizing the CPU, not the > timer calculation. > > Is there a better, less CPU intensive way to do this? > > Thanks in advance. >> > INPUTIF c

Re: [U2] PC setup for to use ODBC

2010-10-26 Thread Bill Brutzman
1. Rocket has a excellent manual on this. 2. Brian Leach has an outstanding write-up on this. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, October 26, 2010 2:22 PM To: U2 Users

[U2] INPUTIF statement in Universe

2010-10-26 Thread Eric Rosenzweig
We are on an IBM AIX 5.3 box with 32 CPU and 32GB of memory running Universe 10.2.4 As we've increased our user count I'm noticing several applications that use the INPUTIF statement coming to the top of CPU usage. We have users that go into a product record, lock it, and then leave their desk or

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Doug
Right Jerry! As a VAR I have to support XDOM API. It took me hours to figure out how to do it. Because the API was poorly documented and any examples I found made no sense at all. When I got my code running the client could not use it because the version of Universe did not work with XDOM even

Re: [U2] PC setup for to use ODBC

2010-10-26 Thread Buffington, Wyatt
We currently have it set up. But there some things you watch out for like file names and dictionary entries with embedded periods. Email me offline at wgbuffing...@hydro.mb.ca and I'll send you our documentation for the setup. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Kevin King
Brilliant article! Thanks for sharing. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] PC setup for to use ODBC

2010-10-26 Thread Oaks, Harold
A question for those who have done it- I want to set up ODBC access on user PCs to Universe files for several of my users. The Universe side is all set up. This, of course, requires the ODBC driver be installed on the user's PC when creating the ODBC data source. I have this driver on my persona

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Steve Romanow
On 10/26/2010 1:46 PM, Kevin King wrote: But all that aside, vendors need to put more attention into their products to make them useful and usable rather than simply another tick on a marketing checklist. This conversation is reminding me of a recent blog post I read. http://blog.garlicsim.org/

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread Kevin King
Let's be careful we're lobbing grenades at the right enemy. As I see things the conflict here isn't choosing vendor supplied solutions vs. open source, the problem is the vendor doing a poor job of making something that is usable and truly useful. There is a time and place for both vendor supplie

Re: [U2] Building XML using the UV XDOM API functions

2010-10-26 Thread jpb-u2ug
I'll have to disagree with you on this one Tony. As a vendor yourself you would of course think this way. As an end user of the product we would like it all to come from one source. This is the reason that Microsoft has got such a jump on everyone else, they will provide you with all of the tools a

Re: [U2] "too many values in sort"

2010-10-26 Thread Mecki Foerthmann
AFAIK SSELECT BY.EXP returns a select list with the record ID and the position in the multivalued attribute. At least on ADDS Mentor it did. I didn't use it for decades because I haven't had any need for such a list, and I haven't tried it on UD yet. So I don't think anything short of a Basic progr

Re: [U2] "too many values in sort"

2010-10-26 Thread Jacques G.
You can try saving your list of keys you want to sort and use Unix's sort program on that savedlist. Use the port number on your saved list to make sure it is unique. - Original Message From: Kevin King To: U2 Users List Sent: Mon, October 25, 2010 11:54:25 AM Subject: [U2] "too ma