Re: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Mecki Foerthmann
You can SELECT dynamic arrays too. This is a BASIC SELECT not the executed TCL verb! The beauty is it works only on attribute marks, so it should even return multi-valued strings. I use this technique to go through large multi-valued attributes too. I just assign the attribute to an array, conv

RE: [U2] Automatic Invoice - PO Matching Software

2008-11-18 Thread Les Hewkin
Forgot to mention we use 1mage for our image storage. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 17 November

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Anthony Youngman
If you're going to do it that way, I wouldn't bother with putting the @VMs back (or may the @SM's too, depending on what you're doing. Get CUST.NUM and CUST.DESC from your modified IN.LINE as follows ... CUST.NUM = FIELD( IN.LINE, CHAR(9), 1, 1) CUST.DESC = FIELD( IN.LINE, CHAR(9), 1, 1) Cheers

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Symeon Breen
>> So the client browser requests a page from the IIS server and the IIS >> server requests myPage.php from the U2 server which causes the PHP >> processor on the U2 server to make the exec call to the UniBasic program. >> How do you normally make the page request from IIS? Using whatever progr

Re: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Mecki Foerthmann
Well, in that case you will have to convert the VMs first to something else like suggested in other posts. CONVERT or SWAP are fast even on large arrays. I've actually never tried SELECT and READNEXT with multi-valued attributes before. And isn't there another syntax of the REMOVE command like

Re: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread MAJ Programming
This may have been offered but I didn't see it in the replies: If you have half an idea on the max num of atts, try using DIM X(30) or some large number and simply FOR.NEXT your way thru until you get to a logical end like a null value. I digest EDI records often in the neighborhood of 200,00

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Charles_Shaffer
>> Using whatever programming language you run to power your iis web site >> asp/asp.net/php etc. Or your iis web server dishes up static html which has >> a script it in that contacts the u2 server via ajax. . I appreciate your patience. I'm relatively new to AJAX. I am interested in finding

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Andy Baum
Look at MATPARSE A11 = DCOUNT(IN.TAB,@AM) DIM RECS(A11) MATPARSE RECS FROM IN.TAB, @AM FOR A1 = 1 TO A11 CUST.NUM = RECS(A1)<1,1> CUST.DESC = RECS(A1)<1,2> NEXT A1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Laansma Sent: 17 November 2008

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Dave Laansma
All right! Well, after evaluating the overwhelming response to this seemingly simple question, I have experimented and decided on the following approach. Embracing the risk of opening myself up to scrutiny of fellow professionals with both greater and lesser wisdom than myself, this is the path I

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Symeon Breen
Sorry - in reply to your statement "I am interested in finding a way to get to the U2 data more directly than we do currently" Then perhaps what you should do is use the u2 web services module to write and deploy a simple webservice that runs a basic subroutine, and you then code your XMLHttpReques

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Symeon Breen
Hi Any javascript will run in the browser and not on the server. What the javascript calls using XMLHttpRequest will exist on a server somewhere. XMLHttpRequest is the javascript DOM API that is the keystone of AJAX. You probably use that now to contact a webservice written in asp.net that then

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread David Wolverton
As I recall, you will get IN.FIELD when MARK is set to '0' - showing it is the 'last item' in the group. You will want to add that on I think -- I don't have a way to confirm this -- but I thought if you got a 0 or 1, the 'remove' still had something in it to 'share' -- See my example from yesterd

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Israel, John R.
My 2 cents: I only use FOR/NEXT loops if I am dealing with data that I know is small. Technically, LOOP/REMOVE are faster, but for something small I just keep it simple. I would think the LOOP/REMOVE or basic SELECT would both be very fast. The SELECT has the advantage of not needing to test th

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Charles_Shaffer
Symeon, Thanks. I'll check it out. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread George Gallen
But is it much faster than what you had to start with? Since both methods work, one might not be any better than the other. Although if your planning on using the HUB.REMOVE from multiple programs, then that course if most likely the best for your need. George > -Original Message- > From:

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Charles_Shaffer
That is similar to what we are doing now, wxcept the web server is Linux so I use XMLHttpRequests to call a PHP module that calls a Java routine that uses Uniobjects for Java to get the results from Unidata. An open source product called JavaBridge is used to allow php to call Java. Works well

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Tony G
> From: Charles_Shaffer > I am interested in finding a way to get to the U2 data > more directly than we do currently, which is using a > Java Bridge and Uniobjects for Java. Charles, you may be interested in mvExec. It will execute any command or program on any MV system from anywhere in your

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Charles_Shaffer
I still like the SELECT approach. It can be used on dynamic arrays and doesn't even need to wait to finish to make elements available. I tried using dynamic arrays one time and the speed was awful. Ever since, I use SELECT lists whenever possible. A MAT array might be faster since it is mor

[U2] Speeding up processing through large dynamic table [ U2U comment]

2008-11-18 Thread Wally Terhune
Dave: You wrote: U2UG in Atlanta was very good. Still room for improvement, but that will come as it evolves. 1) I trust you provided detailed feedback to the U2 marketing folks so we can make the right improvements for next year. If not - I'm happy to forward your thoughts along. 2) I am awar

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Charles_Shaffer
Thanks Tony. I'll check it out. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Pentaho/ETL Tools

2008-11-18 Thread Louie Bergsagel
I saw a fairly impressive webinar from Kore Technologies the other day, but they port UniVerse to Microsoft SQL, so I don't know if you'd be interested in them. It seemed like they had a pretty clean interface. http://www.koretech.com/kore_integrator.asp [EMAIL PROTECTED] We also use MITS, but it

[U2] {UD} SAVEDLISTS list expansion

2008-11-18 Thread Dean.Armbruster
Is there any way to expand the number of items stored in a SAVEDLISTS list? We've hit our system's limit on savedlists size. The limits of 1000 sublist files and 34,815 bytes per sublist are not enough to hold some of our savedlists. Is there any way to expand the sublist file range from 3 to 4

RE: [U2] Setting return code when a Universe process terminates

2008-11-18 Thread Charles_Shaffer
Tony Said: >> Charles, you may be interested in mvExec. mvNet looks interesting, but we use Linux for all of our web servers. I could see it being useful for direct access from a Windows desktop though. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@

RE: [U2] Speeding up processing through large dynamic table

2008-11-18 Thread Boydell, Stuart
That behaviour could be fixed by converting VM to SM which select/readnext leaves alone... Still pretty quick. I just did a test using the code below on an 85000 att array and it took .086 seconds on a low spec dev machine. convert @vm to @sm in IN.TAB select IN.TAB loop while readnext IN

RE: [U2] Unix nfiles & phantoms

2008-11-18 Thread John Jenkins
Phantoms (and also Connection Pool licenses) are still concurrent UniVerse sessions - so in calculating any system-wide parameters for the Operating System you should account for all processes including PHANTOM and CP usage. If you use VERY large numbers of PHANTOMS this is something you need to

[U2] Counting records

2008-11-18 Thread T Stokes
I am trying to remember a Universe function that returns the number of records in a file. Something like this. OPEN 'SOMEFILE' TO SOMEFILE ELSE STOP 201,"SOMEFILE" NUM.OF.RECORDS = UNKNOWNFUNCTION(SOMEFILE) -- View this message in context: http://www.nabble.com/Counting-records-tp20569376p20569

Re: [U2] {UD} SAVEDLISTS list expansion

2008-11-18 Thread Wally Terhune
hmm... per the readme - the following should have been fixed at 7.1.3. Testcase?? Issue 8594 - Problem Description UniData -- When the SAVE.LIST command created an item in the. _SAVEDLISTS_ directory that contained more than 10,000 parts, for example list001, list002, and so forth, a GET.LIST co