Re: [U2] RE: [U2C] FW: Opening

2006-08-10 Thread jbutera
OK - we're going to be asked to move over to the U2 community pages, but... Is it In Like Flynn or In Like Flint? The phrase is 'In Like Flynn' as in Errol Flynn, the actor from the 1930's. http://www.imdb.com/name/nm0001224/bio He had a flambouyant style and was arrested and subsequently

RE: [U2] Backup Question

2006-05-17 Thread jbutera
Ron Sharcott wrote: One thing that we have been looking at is DBPAUSE. The problem being that anything running is left to finish. Not a good pause in my book. But the interesting suggestion is the fsclone command in UNIX. This has been reported to us that it could allow us to do an initial backu

Re: [U2] [UD] Triggers

2006-03-14 Thread jbutera
1) Can I create both an update and delete trigger on a file using the same BASIC program or do I need to create two separate programs? In D3 there's an internal function that indicates if the action is an add or delete. This allows a single program to be used for both an update and a delete. Y

Re: [U2] [UD] Determine path logged on users are in

2006-03-13 Thread jbutera
I'd like to allow some users to list all users logged onto their application (logged into their accounts) then give them the option to log them off. I'm not sure if this is possible in UniData. Any ideas would be appreciated. As always, thanks. :-) On Unix it's easy with fuser on the VOC fil

Re: [U2] Equivalent of CREATE.ACCOUNT and UV.ACCOUNT in unidata

2006-02-12 Thread jbutera
> Can anyone please tell me the equivalent commands for creating a new account > in UNIDATA. Also how to see the existing accounts in UNIDATA. > > I worked in Universe and the commands were CREATE.ACCOUNT. One file > UV.ACCOUNTS in UV account contains the list of accounts. Is there any > equivalent

RE: [U2] Unidata XML

2006-02-05 Thread jbutera
> Have you put the INCLUDE file related to xml at the beginning of the > program. Yes. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Hindsight alone is not wisdom." George W. Bush --- u2-users mailing list u2-users@listserver

Re: [U2] Unidata XML

2006-02-05 Thread jbutera
I originally wrote about a compilation error with: > >X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) >X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HANDLE) On Sun, 5 Feb 2006, Allen Egerton replied: > > The compiler is seeing what you're defining as functions as matri

RE: [U2] Unidata XML

2006-02-05 Thread jbutera
> Not sure if this is just the way it appears to me, or if it is a > difference between Universe and Unidata which I have not worked with, > but from what I can see you need to separate the lines of code. Yes, this was a cut/paste issue - they are indeed on separate lines in the source. > > X.XM

[U2] Unidata XML

2006-02-04 Thread jbutera
Can anyone shed light on why this simple example won't compile? It dies on the OpenXMLData line. X.XML.INPUT.FILE = '_XML_/test.xml' X.XML.EXT.RULE.FILE = '_XML_/test.ext' X.STATUS = PrepareXML(X.XML.INPUT.FILE, X.XML.HANDLE) X.STATUS = OpenXMLData(X.XML.HANDLE, X.XML.EXT.RULE.FILE, X.XML.DATA.HA

[U2] Unidata/XML Newbie

2006-02-02 Thread jbutera
I have a need to export a Unidata (6.1.4) file as XML and later populate data in the file from an XML document. For the sake of simplicity, let's assume that every field is single valued at the moment so the XML document is quite simple - no nested fields, etc. The only wrinkle in this is that th

[U2] Dynamic Files

2006-01-31 Thread jbutera
As someone who's not a newbie, but has some newbie questions from time to time... I need some decent info on Unidata dynamic files. I've got the IBM/U2 docs as well as a couple of Fitz & Long PDFs on file hashing. In short, we use static hashing on most files and have no trouble, resize weekly (

[U2] Unidata core dump

2006-01-19 Thread jbutera
I have a file (static hashed) in Unidata that I can read and write to without a hitch. If I access (read/write) any field in any record, things are good. However, if I list the entire contents of the file with: :LIST FILENAME ALL It core dumps at the same field regardless of which record(s) are

[U2] Unidata split/merge loads

2005-12-12 Thread jbutera
I'm seeking some advice from others on reasonable parameters for a KEYONLY dynamic hashed file on unidata. We use them, but I'd like others thoughts as I think we can get some better performance with more optimal choices for split and merge loads. In short, the file has a numeric, sequential key

[U2] Intercall Bug/Issue

2005-11-02 Thread jbutera
We've been using InterCall with Unidata for about 2 years now. However, the intercall API cannot invoke any subroutine with an INSERT statement. Can anyone comment if this is resolved in Unidata 7.1? It's a problem with 5.0 thru 6.1. Jeff Butera, Ph.D. Administrative Systems Hampshire College [

Re: [U2] Good Programming Practice Question.........

2005-09-27 Thread jbutera
> RETURN with a comment..that is an excellent suggestion. I'd argue that any END statement that's more than a handful (8-10) lines from the opening IF (or whatever) statement should have a comment. Here's an example (that's not long enough to satisfy my 'handful' argument above):

[U2] UniData certification

2005-09-22 Thread jbutera
Silly question - is there any reason IBM went from Unidata 6.1.x to 7.1.0? What happened to 7.0.x? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "...our behavior matters more than the beliefs that we profess." Elizabeth

Re[2]: [U2] Intercall - ic_opensession

2005-08-02 Thread jbutera
> yes, we have been using that for years in universe. My question was > more about the Unidata extension and what it brings? Sorry - I haven't ued the other alternative, so I can't comment on the difference. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-55

Re: [U2] Intercall - ic_opensession

2005-08-02 Thread jbutera
> The intercall definition ic_opensession is defined for opening a > session for a connection to U2 .. there is also a ic_unidata_session > and a ic_universe_session. > > The only difference I can see between the 3 is that ic_unidata_session > has a 7th parameter 'Unidata_Server'. Otherwise they a

Re: [U2] Unidata Indexing

2005-06-07 Thread jbutera
On Tue, 7 Jun 2005 [EMAIL PROTECTED] wrote: > I think we have to keep in mind what happens in the whole process. > While the select itself will process faster (provided you have not specified > NO.NULLS when creating the index), we have to ask what you're going to do next > with that list ? > > If

[U2] Unidata Indexing

2005-06-06 Thread jbutera
I've got a naive Unidata question, but figured I'd throw it out there anyway. In short, does indexing a field in a given file help performance when querying for an empty string? ie: SELECT MY_TABLE WITH MY_FIELD='' I've always assumed yes but would like to hear other's thoughts. Jeff Butera,

Re: [U2] Clarification on FOR...NEXT loops

2005-04-16 Thread jbutera
Taking advice from others on this list, I wrote a small program to compare the execution time of extracting 1 elements from an MV list using FOR/NEXT loop with <1,I> delimiters verus using LOOP/WHILE with REMOVE. I should note this was done on Unidata 6.0.3. All the previous comments are stil

RE: [U2] MvInternet - IBM Licensing Requirement

2005-04-14 Thread jbutera
Kevin wrote: > > But isn't that making an assumption that the connections are > persistent? With connection pooling on the web side, one could easily > balance 20-30 connections and still support 100 "nearly concurrent" > users. As long as the DB queries are efficient, the amount of time > in th

RE: [U2] UV Programmer/Analyst contract position

2005-03-06 Thread jbutera
> Yeah, but he didn't have to pay for a PHD :-) Like most in the sciences, I didn't pay for mine - I got paid to get it (peanuts, but enough to survive). Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "There are 10 kinds of people in the world: those t

RE: [U2] UV Programmer/Analyst contract position

2005-03-06 Thread jbutera
> My plumber chargers 60 an hour Sure, but he has to deal with raw sewage. I put up with other crap, but nothing that comes close. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "There are 10 kinds of people in the world: those that understand binar

Re: [U2] UV Programmer/Analyst contract position

2005-03-06 Thread jbutera
On Sat, 5 Mar 2005 [EMAIL PROTECTED] wrote: > > The job is listed at $54,600 - $66,000. I'm not sure of the benefits > > at the moment, but they're of course > > limited for contract positions, although they at least include holidays, > > vacation, and sick leave. > > > Isn't that pay range abou