Re: [U2] OCONV Extraction Question

2007-11-14 Thread Jeffrey Butera
> VAR1 = 'SAM':@VM:'TRUDY' > CRT OCONV(VAR1,'WHATEVER') > > What replaces WHATEVER, so that I can see the value "SAM"? I cannot find in > the documentation or remember for that matter how to extract a single value > using the OCONV function. CRT OCONV(VAR1<1,1>,'WHATEVER') -- Jeff Butera, Ph.D

Re: [U2] [UD] Possible causes of corrupt data on a UniData static file

2007-11-02 Thread Jeffrey Butera
> > Are there any known issues with UPDATE triggers that write to records that > have UPDATE triggers? As long as you don't get into a cycle where trigger A invokes B, B invokes C and then C invokes A. That turns into a nasty infinite loop fast. -- Jeff Butera, Ph.D. Administrative Systems H

Re: [U2] Unidata Manuals

2007-10-01 Thread Jeffrey Butera
> Appendix A "Unidata Configuration Parameters" in "Administering Unidata > on Unix" isn't what you're looking for? Yes Kathy, you found it. In my haste I performed a poor search and missed this. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "T

[U2] Unidata Manuals

2007-10-01 Thread Jeffrey Butera
Can anyone shed light on what manual(s) provide information about the various udtconfig variables? I've looked in both Administering Unidata on Unix as well as Installing and Licensing UniData with no luck. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-55

Re: [U2] Internal Cache in Unidata

2007-09-24 Thread Jeffrey Butera
> It's interesting to note that your second of three queries changes > drastically during the second invocation while the others remain the same. > Without knowing anything about your files or the dictionary items > involved, I'm going to guess that XCDD.DIV involves one or more file > translates.

Re: [U2] Internal Cache in Unidata

2007-09-24 Thread Jeffrey Butera
> What OS? How much RAM does your server have? Etc etc. > > What's the likelihood that the data was on disk when you first ran the > query, and was pulled into the OS cache as a result? Second time round, the > OS didn't bother to access the disk because it was all in cache ... Good point. Th

[U2] Internal Cache in Unidata

2007-09-24 Thread Jeffrey Butera
Can anyone speak factually about internal cache in Unidata? In short... I often look at performance and attempt to improve things by changing queries, using indicies, rewriting source and so on. In doing so I perform timing and consistently note that the second time a query is performed, it ex

[U2] Unidata PE

2007-09-06 Thread Jeffrey Butera
Where can I get Unidata PE for Linux? When I search on the IBM site and select the link: U2 Personal Editions and Trials (UniData 7.1.0 Personal Edition) Downloads I keep getting taking to System Builder 5.4.1 download - which I don't want. Anyone with a correct link? -- Jeff Butera, Ph.D. A

[U2] UniData 7.1 and ODBC

2007-08-06 Thread Jeffrey Butera
I'm having some basic trouble getting ODBC setup with Unidata. In "Developing UniData ODBC Applications" under "Before You Begin" it says: * Make sure the files you want to access in UniData are ODBC/SQL accesible. See "Using VSG and the Schema API" Yet in "Using VSG and the Schema API" under

[U2] Unidata 7.1 and ODBC

2007-08-03 Thread Jeffrey Butera
I'm trying to get unidata 7.1 setup for ODBC access. I've installed each of UniODBC, UniDK and VSG. When I attempt to access the UCI Config editor, I get: C:\IBM\UniDK\JRE2\jte\bin\classic name jvm The specified module does not exist. Of course 'jte' is a typo - it should be 'jre'. But I di

Re: [U2] Why MultiValue Associations ?

2007-08-02 Thread Jeffrey Butera
> What are the advantages of defining in the data dictionary mv associations? > > Does it mean that if I change or insert via a UniBasic writev command, that > all of the associated fields get a null character if the program does not > explictly specify a change? > > Are there any downsides to jus

[U2] Unidata ODBC

2007-07-13 Thread Jeffrey Butera
We may embark down the ODBC connectivity path with Unidata (7.1.8 on solaris 9). My understanding is that I need to get the UniData clients toolkit and, in particular: UniODBC, the UniDK developer's Toolkit, and the Visual Schema Generator. Can anyone confirm this, and how/where I obtain thes

Re: [U2] Can't get current working directory. ?

2007-06-21 Thread Jeffrey Butera
> Hi all, > > Earlier this week I set out to replace a test account with a fresh > copy of the live account (Unidata 6.1 on AIX 5.1). The Live account > had grown more then I had anticipated and I found myself with a > max'ed out "/test" file system. While preparing to restore from > tape, we fo

Re: [U2] Users of UniVerse

2007-04-27 Thread Jeffrey Butera
> Hundreds of Universities/Colleges (Datatel). Just for clarity: all Datatel clients use Unidata, not Universe. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Before I make music, I make a fire in my heart." Mstislav Rostr

[U2] UniData Overflowed Dynamic File

2007-04-19 Thread Jeffrey Butera
Interesting this thread appeared today. I too was going to post about a dynamic file on the Unidata (HPux) side of life. Here's what I see at the OS level: -rwxrwx--- 1 lpradm users 27377664 Apr 18 16:53 dat001 -rwxrwx--- 1 lpradm users 131825664 Apr 18 05:43 idx001 -rwxrw

Re: [U2] list files

2007-04-09 Thread Jeffrey Butera
> How about "HAFUP"? Hire a Fine Universe Professional. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Daddy, you're not fat - you're growing like me!" Catherine Butera --- u2-users mailing list u2-users@listserver.u2u

Re: [U2] Datatel (was OT:Employment)

2007-03-02 Thread Jeffrey Butera
> Let me get this straight, Datatel has kept the business logic in Unidata? > Is that what you are saying? I didn't know that. So they are using the > Unidata engine and other databases as the datastore? For now, yes this is the approach as they phase out of a "unidata only" world. > I wonder i

Re: [U2] OT:Employment

2007-03-02 Thread Jeffrey Butera
> Hence Datatel's movement to their "distributed" systems where the > business logic stays in UniData, but all the data is stored in Oracle > or SQLServer. or Unidata. You can currnetly use any of the three databases for the backend work, but all source code continues to run in Unidata (the "vir

Re: [U2] OT:Employment

2007-03-02 Thread Jeffrey Butera
> It may be depend on which software package works best for the college. > Then it would depend upon which database that software package uses. Datatel can run on any of Unidata, Oracle or MSSQL for the backend. So the application choice isn't the factor here with the choice in database. --

Re: [U2] OT:Employment

2007-03-02 Thread Jeffrey Butera
If I can add more fuel to the fire. A good friend who has been running Datatel on Unidata for 20+ years (one of Datatel's oldest clients) recently hired a new CIO. His first comment? Get off that "Mom and Pop" database and move to oracle. There's a lot of misunderstanding about MV databases b

Re: [U2] [UV] LIST.READU program

2007-01-04 Thread Jeffrey Butera
> On 1/3/07, Mike Pflugfelder <[EMAIL PROTECTED]> wrote: > > Does anyone have a program written that would give us better output for > > LIST.READU that they wouldn't mind sharing? We're having some problems > > with record locks on one of our systems and it would help a whole lot if > > I could d

Re: [U2] Unidata on Linux

2006-12-18 Thread Jeffrey Butera
> Does anyone know if Datatel Colleague R18 and Unidata can run on a Linux > platform? Yes, linux has been certified for more than a year. The only issue with linux is FACOD can't run - but that's a decision our lovely federal government made. Instead of FACOD you have to revert back to ED Exp

Re: [U2] Ok - who knows InterCall?

2006-11-02 Thread Jeffrey Butera
> Yes, yes, I know Why are we still using InterCall? - long story I'm still using it on Unidata and we're quite happy with it. > Is there (and if so where) logging for Intercall transactions/calls to > the host system? Not to my knowledge. I built logging into my application. -- Jeff

[U2] Unidata dynamic file tuning

2006-10-23 Thread Jeffrey Butera I'
I'm seeking advice on tuning a dynamic file in Unidata. In short, the file has a numeric (sequential) key and contains only about 10 small fields: date, time, user, etc and a single 'large' field: a block of text. The text can be anywhere from one sentence to pages in length, hence I know this

[U2] Slow ascii output

2006-10-20 Thread Jeffrey Butera
I'm going to ask yet another dumb question - Unidata 6.1.4 on Solaris (soon to be 7.1.x). I'm selecting a bunch of records and then outputting data from them into an ascii file in _HOLD_. If I open a sequential file, write the data line-by-line (WRITESEQF) and close the file, it takes about 5

[U2] Unidata on Solaris ?

2006-09-28 Thread Jeffrey Butera
I'm running Unidata on Solaris 9. How can I determine if unidata is running as a 32 or 64 bit application? -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "...our behavior matters more than the beliefs that we profess."

Re: [U2] Web-Base Terminal Emulation

2006-09-27 Thread Jeffrey Butera
On Wednesday 27 September 2006 11:21, Bob Woodward wrote: > I don't get it. I thought you were looking for a method to not have to > install software on the outside user's computer. Do these software > suggestions install on the server there by allowing the outside user to > only have to have a w

[U2] UniData and indexing

2006-09-20 Thread Jeffrey Butera
This may be a naive question, but I'll ask nonetheless... I'm on Unidata 6.1 (soon to be 7.1), if it matters. We have a slew of fields in various files indexed. My question is how indexing improves performance for LIKE and UNLIKE comparisons. I know indicies make EQ and NE queries much quicke

[U2] Unidata Caching

2006-05-03 Thread Jeffrey Butera
Can anyone shed insight on how/what Unidata does for caching? In short, I notice that when I perform some SELECTs or programs which read a handful of records, they often run faster after first execution - I'm assuming Unidata is caching. I was working on adding some caching to an application I'

Re: [U2] [UD] Trigger (singular)

2006-03-20 Thread Jeffrey Butera
On Thursday 16 March 2006 14:05, Bill Haskett wrote: > I'm almost done with triggers (thank goodness I only have a few to create). > It appears UniData only allows one trigger created on a file at a time. Is > this true? > > The documentation doesn't mention this at all. So, in order to get > mul

Re: [U2] Justification for removal of savedlists

2006-02-06 Thread Jeffrey Butera
On Monday 06 February 2006 09:51, [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] wrote: > > I wrote a small routine that will go through Savedlists, HOLD files, > > ST.PPROCES records, etc. and selectively delete the records that are no > > longer needed but I have been stopped by my VP. > > > > She

Re: [U2] Unidata XML

2006-02-06 Thread Jeffrey Butera
On Monday 06 February 2006 10:13, Don Verhagen wrote: > I found this out the hard way also. I believe the documentation is wrong > (for Unidata). Yes Don - the more we read, the more inconsistencies and typos we find. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED

[U2] XML Newbie with Unidata

2006-02-03 Thread Jeffrey Butera
I'm experienced with Unidata, but relatively new to XML. In short, I need to export a Unidata file to XML, and likewise later load XML data into said Unidata file. We're on Unidata 6.1.4 if that matters. For the sake of simplicity, we can assume all data fields in the Unidata file are single

Re: [U2] Is a dynamic array "empty" or not?

2006-02-01 Thread Jeffrey Butera
On Wednesday 01 February 2006 12:19, Wendy Smoak wrote: > I'm probably missing something obvious here... > What can I use to evaluate the "emptiness" of these arrays, so that 1 > and 2 are considered empty and 3 is not? > >TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM >TEST.2 = @VM:@AM:' ':@VM:' ':@VM:

Re: [U2] Dynamic Files

2006-02-01 Thread Jeffrey Butera
> > However, the few files I have moved to dynamic hashing are rediculous in > > size. I'm obviously setting some file parameters wrong, but would like > > insight from anyone who has good luck... > > > > The file STC.HIST as a dynamic file takes up 4.3Gig of disk space. It > > has around 944,000

Re: [U2] Dynamic Files

2006-02-01 Thread Jeffrey Butera
On Tuesday 31 January 2006 22:27, Timothy Snyder wrote: > > For the large file in its dynamic form, is most of the space consumed by > the dat* or the over* files? dat files - I know I'm wasting space. > If the former, you may just be wasting > space. If the latter, you have some file configura

Re: [U2] Unidata core dump

2006-01-20 Thread Jeffrey Butera
On Friday 20 January 2006 08:51, Baakkonen, Rodney A (Rod) 46K wrote: > Do have one record that is humongous? We accidentally got a record out in a > file that was 9 meg and we blew shared memory trying to manipulate it. Thanks to all for ideas. I finally copied the DICT from another account, ov

Re: [U2] FW: sudo

2006-01-13 Thread Jeffrey Butera
On Friday 13 January 2006 12:21, [EMAIL PROTECTED] wrote: > > > > # This file MUST be edited with the 'visudo' command as root. > > I've never seen that in the files I've edited. I don't edit it much and > have probably just gotten used to looking past most of the # lines. But, > learn something ne

Re: [U2] FW: sudo

2006-01-13 Thread Jeffrey Butera
On Friday 13 January 2006 10:19, [EMAIL PROTECTED] wrote: > I believe the visudo command is for SELinux versions so if SELinux isn't > install on the RH box, if that's what it is, then you don't have to worry > about it. Not true. visudo has been on every box I've ever used (RedHat, Fedora, Sola

Re: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread Jeffrey Butera
On Thursday 27 October 2005 05:55, John Jenkins wrote: > Alonzo > > This is not really a database issue but an application usage iseue, and a > BASIC program or (on Unix) a check in the ,profile shell script is exactly > the way to do this. We're on Unix and did this via the .profile route - works

Re: [U2] Unidata Pattern Lookups

2005-10-06 Thread Jeffrey Butera
On Thursday 06 October 2005 12:37, Gahan, Mick wrote: > Does quoting the pattern make a difference > > LIST H08.PS.VEHICLES WITH @ID LIKE "...4296XH" Bob hit the nail on the head: LIST H08.PS.VEHICLES WITH @ID LIKE "...'4296XH'" -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [

Re: [U2] Unidata Pattern Lookups

2005-10-06 Thread Jeffrey Butera
> We wrote a similar module and have the same problem with license plates > having what Unidata sees as patterns. If you enclose the string within > quotes it should work. We do: > > LIST H08.PS.VEHICLES WITH @ID LIKE "...'4296XH'..." Thanks Bob! -- Jeff Butera, Ph.D. Administrative Systems Ha

[U2] Unidata Pattern Lookups

2005-10-06 Thread Jeffrey Butera
We have an application I wrote which records parking stickers for the college. It saves data using the person's ID and license plate (with certain bad characters removed). However SELECTS against the file occasionally fail if the license plate string is interpreted by Unidata as a pattern. Fo

[U2] Parsing XML

2005-10-04 Thread Jeffrey Butera
I know there are native tools in Unidata to output XML datasets. However, can anyone shed light on tools (custom or native) to read/parse XML data? -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 --- u2-users mailing list u2-users@listserver.u2u

Re: [U2] Programming Metrics

2005-09-30 Thread Jeffrey Butera
On Friday 30 September 2005 12:16, Baakkonen, Rodney wrote: > I would like to put a plug in for using Basic profiling before putting a > program into production. I think it is a good tool for seeing where a > program really spends it time. And after review of the profile, you have a > good chance o

Re: [U2] Source Code Management

2005-09-29 Thread Jeffrey Butera
> What tool are you using for source code management? What are its > benefits and disadvantages? I'm specifically interested in version > controlpreferably Unix-based. If you have vendor information, please > provide that as well. > > In a previous life, I used something called sccs - I don't k

Re: [U2] PHP Options

2005-09-19 Thread Jeffrey Butera
> We have PHP pages which interact transparently w/ UniData, allowing > users to enter, retrieve, and modify data straight to/from UD through > web services and Java (Apache Tomcat + Axis). I can supply a writeup w/ > source code on how to do it -- contact me off list if you are interested. David

[U2] Dynamic files in Unidata

2005-08-24 Thread Jeffrey Butera
I have a few questions for those more comfortable with dynamic files in unidata. Currently I have a statically hashed file: File name = H08.CR.FF.TEXT Number of groups in file (modulo) = 13331 Static hashing, hash type = 0 Block size

[U2] Undefined Vars

2005-08-22 Thread Jeffrey Butera
On unidata I'm looking for a way to test if a variable has been defined or not. I'm aware of $DEFINE, $IFDEF, $IFNDEF and $UNDEFINE but they're not what I need. I have a subroutine and would like to check to see if one argument on entry is defined or not. -- Jeff Butera, Ph.D. Administrative

Re: [U2] HP PCL5/6 Code Book

2005-08-08 Thread Jeffrey Butera
Attached are manuals part I and II for PCL 5 from HP's site. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "...our behavior matters more than the beliefs that we profess." Elizabeth Deutsch Earle [demime 1.01d remov

Re: [U2] Include Vs Call - Software Maintenance

2005-05-19 Thread Jeffrey Butera
On Thursday 19 May 2005 09:58, Mark Johnson wrote: > > So are functions a kept secret in MV programming or has no-one had any > issues with them? I'd like to know so I could either get better with them > or ignore them and continue with subs. Functionally speaking, why would I use a function which

Re: [U2] UniData Indexes

2005-05-09 Thread Jeffrey Butera
On Monday 09 May 2005 10:34, Andy Squires wrote: > Hi all, > > Is there a way to get a list of all indexes on all files in a particular > account? The only way I thought to do this was to loop through a list of > all the files and do a LIST.INDEX command. Seems like there should be a > better way

Re: [U2] Creating Unidata Triggers

2005-05-05 Thread Jeffrey Butera
On Thursday 05 May 2005 14:44, Chuck Mongiovi wrote: > Exclusive access? .. You need to be the owner of the file .. Ding, ding - give Chuck the prize! It was a new file I had created earlier in the day and the ownership was wrong. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College

[U2] Creating Unidata Triggers

2005-05-05 Thread Jeffrey Butera
I've had plenty of luck creating unidata triggers in the past, but I'm now getting permission denied. I know from the docs the info about who can (and can't) create triggers. Can anyone shed light on where trigger info is stored under /usr/ud6x (or unishared), and if changing permission on fil

Re: [U2] +AFs-UD+AF0- Halting a Unidata process

2005-04-29 Thread Jeffrey Butera
> We are running UD 5.2.32 on Sun 5.9. Sometimes a '!kill [pid]' doesn't > halt a Unidata process. > > In your experience, would '!kill -15 [pid]' cause any Unidata problems like > file corruption, etc? It could indeed cause file corruption if the pid was in the middle of a WRITE. Regardless, th

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Jeffrey Butera
> Jeff.. Can't do attachments here. It the code reasonable length where you > can just included it in the body of an email? R.PH = GETREADU() P= -1 Y = 25 PRINT @(-1): MAX = COUNT(R.PH,@FM) + (R.PH #'') FOR CNT = 1 TO MAX Y += 1 IF Y > 21 THEN P += 1 IF P > 0 THEN

Re: [U2] Locks, releases and STATU() (oh my)

2005-04-14 Thread Jeffrey Butera
Attached is a small UD program that nicely formats the output from GETREADU. As most Datatel clients know, if you have a UD table buried down one (or more) directories, the output from LIST.READU is almost useless because it shows the relative pathname (which doesn't fit in 8 characters). The

[U2] UD guide on 6.1

2005-03-31 Thread Jeffrey Butera
Can anyone confirm if the issues with guide found on prior versions of Unidata have been rectified with 6.1? -- 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 binary and those that don'

Re: [U2] Triggers docs?

2005-03-11 Thread Jeffrey Butera
> The manual is a bit skimpy on triggers. Any supplemetal docs around? > > We're trying to track updates to a file; individual items have gone missing > lately. No SQL involvement at all. Sorry, can't comment on Universe. For unidata, here's some brief docs I wrote after digging. I found info i

Re: [U2] [UV] MASTER OFF

2005-02-23 Thread Jeffrey Butera
On Wednesday 23 February 2005 10:28, Drew Henderson wrote: > "man signal" (may have to use "man 7 signal" should tell you. > > It looks like "SIGILL", for "illegal instruction" > > Drew > > Stevenson, Charles wrote: > >I've found emperically > >kill -4 [pid] > >*seems* to nicely kill uv pocess

<    1   2