RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread Dennis Bartlett
Alas! I have to return with my tail 'tween my legs! --- IBM P615 AIX 5.2 Universe 10.1.2 2 cpu --- Test Data : 500,000 invoice records, a trigger with a RE

RE: [U2] Trigger problem!

2004-09-01 Thread Dennis Bartlett
Funny that. My catalog verb is identical, but I think it is the actual wording of the statementthat is different.. I've been ICAT {file} {program name} where as you've been CAT {file} {*program name} {program name} -Original Message- From: John Reid [mailto:[EMAIL PROTECTE

RE: [U2] Unidata shared memory and catalogs

2004-09-01 Thread Ken Wallis
Tony Gravagno wrote: > Can I just turn off smm while I'm in development? How? No, you can't I'm afraid. Have you tried CATALOGing everything LOCAL DIRECT while you are in development? Or will that just not work with UniObjects? Cheers, Ken --- u2-users mailing list [EMAIL PROTECTED] To u

RE: [U2] Unidata with AccuTerm?

2004-09-01 Thread Kevin King
I'm no Wintegrate person, so I can't say what's happening there, but I have seen terminal types send an ASCII 127 (DEL) for a BS. To the terminal it looks perfectly normal but to the command interpreter it's totally whacked. What does PTERM -DISPLAY show? -Original Message- From: [EMAIL

RE: [U2] Unidata shared memory and catalogs

2004-09-01 Thread Kevin King
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno >I've tried the !NEWPCODE and !NEWVERSION ... Sorry, I missed that detail in my previous response. The problem I usually have w/ NEWPCODE is the syntax. You might try using FIBCDFN in the AE editor and see if that cause

RE: [U2] Unidata shared memory and catalogs

2004-09-01 Thread Kevin King
Have you checked out NEWPCODE instead of NEWVERSION? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Wednesday, September 01, 2004 9:10 PM To: [EMAIL PROTECTED] Subject: [U2] Unidata shared memory and catalogs Platform is Unidata 6.0

[U2] Unidata shared memory and catalogs

2004-09-01 Thread Tony Gravagno
Platform is Unidata 6.0 PE over WinXP. I've been having a hard time doing development on subroutines when the main calling programs are running on active processes. This isn't live code, it's all development, but I'm trying to avoid stop/restarting the main code every time I change a subroutine.

[U2] Unidata with AccuTerm?

2004-09-01 Thread Tony Gravagno
I've been having a heck of a time at ECL on Unidata PE 6.0 with AccuTerm 2k2 - all over WinXP Pro. I'm not sure of which terminal emulation is best, or even how to check/set the term type in Unidata. "term vt100" doesn't return a confirmation and "term" just returns "A,B,C,D" help with nothing ab

RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs

2004-09-01 Thread Martin Scholl
I've heard once that UniVerse goes down to char(246) as system delimiters. Don't know where it came from. (Probably this list) I would love to have the ability to access those values with the normal tools of Basic or UniObjects, but I guess this is one case where there show through. Martin Scholl

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Hanwell, David
But Debra, all you need is an "A" below the "B", on your (ahem, ahem), and then you'll have a TBA tattoo ("To Be Announced"). You can have a lucrative career doing commercials for TV Guide. "It was like experiencing a nuclear explosion in a very small place." - Loni Anderson, describing having sex

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Allen E. Elwood \(CA\)
LOL Or when you have to take your keyboard apart and dry it with the wife's blow-dryer because of the drool that accumulated during slumber. Gotta love those imprints on the face Ok, we'd better knock it off before IBM declares this thread dead! heh heh. -Original Message- From:

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Piers Angliss
" Relocation will not be considered - we are seeking a local candidate. " Does this mean "we don't pay relocation expenses" or that if I relocate to Denver at my own expense I won't be considered ? The latter seems a bit harsh - can you do that in the "land of the free" ? Or do you perhaps have

RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread Adrian Matthews
Strange. My trigger was the same; simple return with AFTER INSERT OR UPDATE OR DELETE. System load was very low as it was the development server I was uding. My basic program selected the whole file (70,000 records) then simply read each one and wrote each one so the trigger was called even though

[U2] Delete a Printer Universe

2004-09-01 Thread Anthony Dzikiewicz
Since I haven't done this in some time. I cant remember how to do this. I added a printer that I now wish to delete. I am using a dumb terminal to do this via the SYSADM.MENU menu. There appears to be menu options at the top File, Action, Help. I guess I need the magic keystroke for Action. Ho

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Debster
and when you have keyboard imprints on your forehead...it's really gone to far..I am still trying to get rid of the "T" on my forehead and the "B" on my nose. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glen B Sent: Wednesday, September 01, 2004 3:46 PM T

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Glen B
I think codingitis is the cause. Time to lay off the keyboard for a while, man. You know, semi-colons start to disappear after 6 hours of continuous coding. Any higher amount of time can cause strange things to happen. I remember starting during mid-day and missing night-time once, while program

RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs

2004-09-01 Thread Barry Brevik
>Problem: FMTS is supposed to FMT each field of a given dynamic array. >It appears to be wrong if source data in a field of the array contains CHAR(247). If you look at the DOCs for REMOVE (for example), it indicates that the lowest system delimiter is CHAR(248), and that is true with REMOVE. How

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Hanwell, David
Yes, but I understand Chuck's point. The Ad didn't say WHICH Denver, Colorado. Did they mean the one in Canada or the one in Mexico? "Faith is a bird singing in the darkness, anticipating the dawn." - Anonymous. David Hanwell ACE-INA, Information Technology 215.640.2212 [EMAIL PROTECTED]

RE: [U2] Trigger not intensive, it's what you do with trigger! Wa s RE: [U2] Dot Commands

2004-09-01 Thread John Reid
My with and without scores were 78 seconds and 80 seconds respectively. Yes, without took longer. It was 1000 updates, the same record set, and a simple RETURN after the parameters. The trigger was AFTER INSERT UPDATE DELETE. Maybe the INSERTS take longer or system load may have been radically diff

RE: [U2] Trigger problem!

2004-09-01 Thread John Reid
Our catalog verb looks like this: R.MIPAHC>CT VOC ICAT ICAT 0001 V 0002 CATALOG 0003 I 0004 BDGZ 0005 catalog 0006 INFORMATION.FORMAT If I use the regular catalog, it wants to place the item in the voc with *...* If the ICAT is used, it lands in GLOBAL.CATDIR as a single item like *GLOBAL.ROU

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Allen E. Elwood \(CA\)
Hi Rod, I too have had the 'pleasure' of F and A correlatives. Once upon a time, a nice man named Dick Pick, who created Pick basic, issued a challenge. He said that there was no way in native Pick to access the last value of a multivalued field and challenged anyone to find a way. Enter Me. 'A

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Ian McGowan
> From: Results [mailto:[EMAIL PROTECTED] > William, > Unless I missed it, there's no locational information in the > post, which makes > >Relocation will not be considered - we are seeking a local candidate. > difficult. I thought the same, but check the subject :-) Seems like a really great o

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Allen E. Elwood \(CA\)
Oh gosh, read the subject? Denver CO sounds like a location to me :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 10:59 To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer position Denver, Colorado

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread James Canale, Jr.
Charles, Take a look at the subject line - it appears to be in Denver. Regards, Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Wednesday, September 01, 2004 1:59 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer posit

RE: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Debster
Chuck Did you have nourishment today? Eat some carrots lately? Have your glasses on? ;-) It's in the subject line..."Denver" ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 1:59 PM To: [EMAIL PROTECTED] Su

[U2] Re: Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Jeff Schasny
Denver, Colorado isnt specific enough? Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Rod Hills
Allen, Universe does have I-descriptors, but the programmer was trying to build an F-correlative (from old PICK) to do the task. -- Rod Hills -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 9:40 AM To: [EMAIL PROTECTED] Subjec

Re: [U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread Results
William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL

RE: [U2] UV: FMT and FMTS processing of CHAR(247) differs

2004-09-01 Thread Adrian Matthews
Do you have NLS installed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aleksejs Truhans Sent: 01 September 2004 18:28 To: [EMAIL PROTECTED] Subject: [U2] UV: FMT and FMTS processing of CHAR(247) differs Dear All! Please, shed some light on the strang

[U2] UV: FMT and FMTS processing of CHAR(247) differs

2004-09-01 Thread Aleksejs Truhans
Dear All! Please, shed some light on the strange behaviour of UV BASIC FMTS function. Environment: UV 9.6.2.6 and 9.6.2.1 on HPUX 11i on PA-RISC 8xxx. Problem: FMTS is supposed to FMT each field of a given dynamic array. It appears to be wrong if source data in a field of the array contains CHAR(2

[U2] Universe 10 - SELECT Multivalue to Select List

2004-09-01 Thread Veenhof, Peter
Hi Does anyone know how I could run a SELECT to a list, but maintain multivalues on a single line? ie. Statement is SELECT CUSTOMER @ID ADDRESS My ADDRESS field is multivalued for two lines, so in the savedlist I see: RECID ADDRESSLINE1 ADDRESSLINE2 RECID ADDRESSLINE1 ADDRESSLINE2 RECID ADDRES

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Glenn Herbert
No. It has Itypes too, just that some of us love to code in a manner that pre-dates Itypes. And for the challenge too! ;-) Oh. Or we have existing stuff already coded to support. At 12:40 PM 9/1/2004, you wrote: Wow, in Unidata this would be an "I descriptor" that would just be SUM(WO.COMP.Q

RE: [U2] Universe file size limit

2004-09-01 Thread Aleksejs Truhans
Hello! We have had problems with big UV 64-bit files on HPUX11i PA-RISC. As far as I remember, it is UV version 9.6.2.1 or 9.6.1.smth, where a static hashed file bigger than 4GB could be killed by modifying a record (beyond the 4GB border?). That is, if one is just adding records to a file it is

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Allen E. Elwood \(CA\)
Wow, in Unidata this would be an "I descriptor" that would just be SUM(WO.COMP.QTY) in attr 2 of the dict. Guess UV doesn't have I desc's? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dianne Ackerman Sent: Wednesday, September 01, 2004 08:37 To: [EMAIL PR

[U2] Senior Pick Programmer position Denver, Colorado

2004-09-01 Thread William Lockwood
Trust Company of America, a leading provider of financial services nationwide, has an immediate opening for a Senior Multivalue Database Programmer / Analyst. The ideal candidate for this position will have broad knowledge of multi-value database architecture and management. You will work as a me

RE: [U2] Correlative referencing multi-value field in another fil e

2004-09-01 Thread Paul Trebbien
Hi Rod, I assist my customers who run both UniVerse and UniData in the Pick flavor and created the following dict item to SUM the values from another record: 0001: I (SQL)}}NUMERIC}Y}}} 0002: SUM(TRANS('WO-BOM',F0,3,'X')) 0003: MD4 0004: Test SUM 0005: 8R 0006: S 0007: WO List val

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Kryka, Richard
The translate returns MV data with spaces. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Wednesday, September 01

RE: [U2] [PICK] File handle opened?

2004-09-01 Thread Allen E. Elwood \(CA\)
Thanks Rick! This won't keep the program from going to debugger if someone did a FV="" but at least I can weed out probably 90% of the goofs. And since this subroutine is designed to be used by programmers, it won't be a huge problem, but I was just trying to make it bullet proof. Allen E. Elwoo

Re: Memo: Re: RE: [U2] Universe file size limit

2004-09-01 Thread Glenn Herbert
Well, I do know that the Internal data error message (at 9.6) is generated within the file handling subsystem when blink values are mucked up; interesting that no information pertaining to this type of error is displayed so one might postulate this isn't the issue. This message can also be gene

RE: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Mike Randall
My suggestion would be to use the Prime style I-descriptors instead of the cryptic Pick style correlative. With an I-descriptor you could simply SUM the field. If you could decipher what your correlative does (my guess is reading field 8 of the TWIP file), an appropriate I-descriptor could be

Re: [U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Dianne Ackerman
Yes, this is the way it works, unfortunately. What we ended up doing was to change att 8 in WO.COMP.QTY to F;0(TWIP;X;;8);(G0 1);0(TWIP;X;;8);(G1 1);0(TWIP;X;;8);(G2 1);.;+;+;+;+ etc -Dianne Rod Hills wrote: We are trying to do a very basic PICK technique of summing a multi-value field

Memo: Re: RE: [U2] Universe file size limit

2004-09-01 Thread asvin . dattani
Hi Glen, This is the output when we first ran across the problem: 0008 Program "FIS00200": Line 551, Internal data error. 0009 Program "FIS00200": Line 555, Internal data error. 0010 Program "FIS00200": Line 555, WRITE failure. Line 551 is a MATREADU from the file, and line 555 is a MATWRITE to

[U2] Correlative referencing multi-value field in another file

2004-09-01 Thread Rod Hills
We are trying to do a very basic PICK technique of summing a multi-value field in a F-type correlative. However, it appears uniVerse is not putting the multi-values onto it's "stack" as inividual values, but rather as one entry with the value markers replaced with blanks. Below are two dictionary

[U2] How import data from UniVerse into MS Access?

2004-09-01 Thread Jeff Schasny
The @select item should be a list of FIELD (i.e. dictionary entry) names not record ID's -original message- [snip] Below is the setup: >CT DICT BLAH @SELECT @SELECT 0001 PH 0002 INTO ALTER <- the records I want Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] ---

Re: Memo: RE: [U2] Universe file size limit

2004-09-01 Thread Glenn Herbert
I have a version of 9.6 (and beyond!) running here on an hp 11.11i with a few large files that exceed 4 gig (one is around 20 gig) with no problems; note that these files aren't exercised all that much as I don't really play around with this stuff much anymore. Additionally, we have a number of

Memo: RE: [U2] Universe file size limit

2004-09-01 Thread asvin . dattani
Hi, Thanks for all the responses. Ulimit, is set to unlimited so that shouldn't be the problem. Our unix support people cant find any other HPUX kernel parameter that would affect the maximum file size. Glen's recollection is correct - HPUX support file sizes up to 128 terabytes. It is looking i

Re: [U2] Memo: Universe file size limit

2004-09-01 Thread Glenn Herbert
If I remember correctly, when I was implementing the 64-bit file system in universe, the HPUX max file size was somewhere around 128 Terabytes, but I can't locate my notes from that far back to verify that number. It certainly sounds like something in the OS is stopping you, such as ulimit (as

RE: [U2] [PICK] File handle opened?

2004-09-01 Thread Alfke, Colin
IF ASSIGNED(file.var) then * Check for locks... END Works. You can also do NOT(ASSIGNED(file.var)) as well. This works on both "regular" and "file" variables. Hth Colin Alfke Calgary, Alberta -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 3

RE: [U2] Memo: Universe file size limit

2004-09-01 Thread Robert Paterson
I would check your ulimit settings. On both HP-UX 10.20 and 11 we have a setting of 4194303. Only problem with that is that IIRC this figure is in blocks - which would mean 2GB. Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (13

RE: [U2] Memo: Universe file size limit

2004-09-01 Thread Claus Derlien
> Surely if the standard Universe 32bit max file size is 2gb > (2147483648 Bytes) > > Then the 64bit would be 4gb (2147483648*2 Bytes) I guess more in the neighbourhood of 2^63 = 9223372036854775808 bytes but nevermind, the limit for a 32 bit system on 2gb is stupid as you could have used the

RE: [U2] Memo: Universe file size limit

2004-09-01 Thread Logan, David (SST - Adelaide)
Hi Bob, A 64bit file has a very large capacity. The 64 bit number is binary so every bit = 1 greater power of 2. Whereas 2,147,483,648 = 2^31 then 9,223,372,036,854,775,808 = 2^63. A very big number indeed. The reason it is 31 and 63 is that the leftmost bit generally signifies the sign of the num

RE: [U2] [PICK] File handle opened?

2004-09-01 Thread Rick Ramsey
I forgot to mention - the FILEVAR will be considered to be ASSIGNED=TRUE even if you've simply done a FILEVAR="" somewhere in the program. The key to this is never use the file handle variable name except for the ASSIGNED or the various file-handling verbs. Rick Ramsey Healthpac Cumputer Systems

RE: [U2] [PICK] File handle opened?

2004-09-01 Thread Rick Ramsey
I believe this will work for you in D3: IF ASSIGNED(FILEVAR) . . . where FILEVAR is the file handle variable used in the OPEN statement Rick Ramsey Healthpac Cumputer Systems Savannah, GA -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31,

RE: [U2] Memo: Universe file size limit

2004-09-01 Thread Bob Witney
Surely if the standard Universe 32bit max file size is 2gb (2147483648 Bytes) Then the 64bit would be 4gb (2147483648*2 Bytes) Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: 01 September 2004 11:46 To: [EMAIL PROTECTED] Subject: R

RE: [U2] Memo: Universe file size limit

2004-09-01 Thread Adrian Matthews
Unix limitation? Perhaps something needs tweaking there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 01 September 2004 10:18 To: [EMAIL PROTECTED] Subject: [U2] Memo: Universe file size limit Hi Everyone, HPUX 11i running Univ

[U2] Memo: Universe file size limit

2004-09-01 Thread asvin . dattani
Hi Everyone, HPUX 11i running Universe 9.6 - does anyone know if there is a 4GB file limit? We have 64 bit files on a 64 bit file system, but one of these files grew to over 4gb and blew up with an Internal Data Error on a BASIC write. I thought that 64 bit files were supposed to be vv large...