Re: [U2] WITH Clause

2008-01-24 Thread Martin Phillips
Hi Charles, Can parenthesis be used to group WITH statements? I am modifying a humongous SORT statement with many WITH clauses and would like to group them. If so, what are the rules? WITH (COND1 OR COND2) AND WITH (COND3 OR COND4) ? (WITH COND1 OR WITH COND2) AND (WITH COND3 OR WITH COND4)

Re: [U2] WITH Clause

2008-01-24 Thread Charles_Shaffer
Thanks Martin. That works perfectly. This was on Unidata in U mode. Charles Shaffer Senior Analyst NTN-Bower Corporation Martin Phillips [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2008 02:21 AM Please respond to u2-users To: u2-users@listserver.u2ug.org cc:

[U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread john reid
I just saw this today, and although i am certain that everyone must know it already, i am including it. For itypes that call subroutines, where the subroutines open lots of files, put a named common in the subroutine that contains what amounts to dimensioned arrays that hold the file vars. Put a

[U2] Execute Windows Script

2008-01-24 Thread Amy Raisanen
My goal is to run a Universe program that creates a Windows batch file and then executes it. I create the batch file using WRITESEQ and that works great, but how can I execute that windows batch file from within my program? I've tried using the EXECUTE = DOS call batchfile.bat but, that just

Re: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Scott Ballinger
Hi John, As you surmised, this is not a new trick. Here is my version: SUBROUTINE OPEN.FILE.SUB(FILENAME,FILEVAR,ERROR) * open filename to filevar, keep opened files in named common * 01-20-01 asb COMMON /OPEN.FILE.SUB/ FILENAMES,FILEVARS(1000) IF ASSIGNED(FILENAMES) ELSE FILENAMES = END

Re: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Kevin King
This is good stuff. However, two things to keep in mind. The name of the common block must be unique so that it doesn't inadvertently collide with other programs. Named common stays alive your entire login session so if you use the same name with different configurations you could break

RE: [U2] Execute Windows Script

2008-01-24 Thread Brian Leach
Hi Amy Try DOS /C path_to_your_batchfile.bat Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Raisanen Sent: 24 January 2008 16:10 To: u2-users@listserver.u2ug.org Subject: [U2] Execute Windows Script My goal is to run a Universe

Re: [U2] Execute Windows Script

2008-01-24 Thread Ed Clark
For universe: EXECUTE DOS /C BATCHFILE.BAT for unidata: PCPERFORM batchfile.bat On Jan 24, 2008, at 11:09 AM, Amy Raisanen wrote: My goal is to run a Universe program that creates a Windows batch file and then executes it. I create the batch file using WRITESEQ and that works great, but how

RE: [U2] Execute Windows Script

2008-01-24 Thread Brutzman, Bill
What Terminal Emulator is in use? What OS is UV hosted on? If the OS is Unix and the client is Windows, IBM's wIntegrate product (~$200) would be needed. I expect that AccuTerm would work. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Amy

RE: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread David Murray
Hi all, UniVerse and SB+ also have this technique built in. UniVerse is via the OPEN.FILE.B in the APP.PROGS file (uv account) and SB+ via the SB.FILEVAR.S subroutine. I had written an article regarding the UniVerse routines: http://u2blog.org/2007/11/05/appprogs-open-tools/ Cheers, David

RE: [U2] Execute Windows Script

2008-01-24 Thread Amy Raisanen
Works like a charm. Thanks! Amy Raisanen Systems Analyst RAM Mutual Insurance Company (218) 879-3321 Ext. 175 Visit RAM online at www.rammutual.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, January 24, 2008 10:52 AM To:

[U2] [UD] problem calling program from shell script

2008-01-24 Thread bradley . schrag
I'm in the process of automating various vendor processes by calling them from a shell script which can be run by a scheduler. I've done a couple single-threaded processes this way and it works fine. But I'm having difficulty with a multi-threaded process. At least it seems that

Re: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread john reid
Thanks all... john On 1/24/08, David Murray [EMAIL PROTECTED] wrote: Hi all, UniVerse and SB+ also have this technique built in. UniVerse is via the OPEN.FILE.B in the APP.PROGS file (uv account) and SB+ via the SB.FILEVAR.S subroutine. I had written an article regarding the UniVerse

Re: [U2] Execute Windows Script

2008-01-24 Thread john reid
what would be an example of a windows batch file, that one would want to run? Maybe a small example, like what the batch file would look like, would be great. It sounds interesting. john On 1/24/08, Amy Raisanen [EMAIL PROTECTED] wrote: My goal is to run a Universe program that creates a Windows

RE: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Bernard Lubin
As the common block remains alive for the duration of your login, you will also need to take into account cross-logging across multiple accounts. If you have multiple accounts, then you will need to reset the common block whenever you logto another account. Alternatively, you could build some

Re: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], Kevin King [EMAIL PROTECTED] writes The performance gains by this technique can be immense, especially on UV (that seems to have a little more overhead than UD in opening files). Regardless of the platform, the less code executed in each iteration, the more

RE: [U2] Execute Windows Script

2008-01-24 Thread John Jenkins
Windows prefers scripting language nowadays to BAT files. There is an article in the IBM Knowledge Base I think in building these for some specific activities. You could use it as the equivalent of the Unix at job queue I am sure. Something like: MYCMD.VBS -- Set ShellQueue =

RE: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread John Jenkins
Yes Pr1me had a few other tricks as well. One useful item was that any Pr1ME Information client session only ever had ONE remote process when accessing over Pr1menet, and the process was kept alive as long as you had an active remote lock. As a result, the overheads of starting a remote process

RE: [U2] [UV] Selection help

2008-01-24 Thread Ray Wurlod
How about using SQL? SELECT DISTINCT CODE TO SLIST 0 FROM UNNEST filename ON CODE; (Sorry, don't have the original post open, can't remember the file name.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] XMAP Question

2008-01-24 Thread Steve Long
Hi all - I am having an issue getting an XMAP to work when parsing a soap return. The return is coming from a 3rd party and I do not have the option to change what they send. I used the XDOMLocate and honed the returned XML to what I need to parse, and its similar to this: Items xmlns=

RE: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Ray Wurlod
Are you saying that this technique won't work till version 20.1 is released? =8^D --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe 20.1 itype perf enhancer

2008-01-24 Thread Ross Ferris
I believe the technique is only REQUIRED on versions prior to 20.1! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, 25 January 2008 1:15 PM To:

RE: [U2] XMAP Question

2008-01-24 Thread John Jenkins
I've re-parsed the document to show the hierarchy more easily - if you use a proportional font it may get jigged about again (we'll see): Items xmlns= itemNumber123456/itemNumber itemNumbers convNumber convNumber2586