RE: [U2] Custom Functions
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak Sent: Wednesday, June 22, 2005 8:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Custom Functions --- snip --- We consider subroutines fairly expensive in terms of system resources, and tend to just use GOSUB within most programs. But coming from the Java/OO world, the global variables are *killing* me. And I'm partial to the nested parenthesis notation as well. I always thought that if you have a globally catalogued subroutine and use it like this: MY.SUB = '*MY.SUB' CALL @MY.SUB(parm1,parm2...) What happens under the hood, must be that the compiled subroutine is loaded into a variable, and that variable is either placed somewhere on the stack or another area, and the way a function works is the same way, just with another syntax.. ?? that would take the exact same amount of clock cycles to reach the subroutine as a call to a function would A function is also 'just' a loaded subroutine, so in effect the runtime does a longjump to the routine.. Am i totally wrong on this ?? best regards from 'melted down' denmark Claus Derlien Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Just going a bit off topic but. we had a batch process that processed lots of data and I mean lots, but it didn't have any transaction boundaries. Someone was asked to add them. So what did they do? yes you got it. At the start of the routine they started a transactions and at the end of the routine they ended the transactions. Guess what? the lock table filled up and the whole thing fell over. The fun you have with transactions is endless :-) Les -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: 22 June 2005 18:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... From: Les Hewkin What would you call a really big transaction? A transaction should encompass all updates that should happen (or be abandoned) as a group in order to insure logical data integrity at the application layer. Let me use an example, keeping the preceding statement in mind. (Please don't belabour the details. This is just to get the broad idea.) Suppose out in the real world, a car gets repaired. This is one chunk of work that the customer typically signs off on and pays as a whole. In a database application representing this bit of reality, at some point there is a work order that needs to be posted. Maybe - ~maybe~if you design it right - pieces of it can be posted as separate transactions in an attempt to keep transactions as small as possible, but to completely post the work order: - multiple parts each need to be moved from, inventory to car. - associated double entry journal entries need to happen to keep accountants happy. - some low-stock condition might trigger automatic re-order of some parts. (one could argue this is separate, but depending on how it is programmed this may end up nested in this Transaction) - some parts might be consignment and vendor info needs to be updated. - serial numbered parts might require special treatment. - mechanic's (plural?) hours need to be recorded in timekeeping system. - associated accounting journal entries. - Invoice needs to be created. - customer info updated. - maybe immediate payment: associated accounting updates. - Car history needs updating (let's say this is a regular customer we track his cars) - warranty or rebate info needs to be sent or queued for auto manufacturer. - more accounting journal entries? - Multiple user-defined cross-reference files (if/when native indexing not used) Under normal circumstances all that happens as one big lump (at least your business user hopes so. But one can imagine scenarios where part of the repair is in dispute, the customer agreed to part of the work, or is unhappy, etc. ) so normally a given repair is either Open or Closed. One might program it so that this post is one TRANSACTION, maybe with nested TRANSACTIONs within it. These would be really big transactions. There may be a lot of processing that happens between TRANSACTION START and COMMIT. Anywhere along the line some abnormality might cause a TRANSACTION ABORT. All of these would have to happen as a unit, or be rejected as a unit in order for the DB (at an application level) to remain self-consistent. If one were smart, one could invent stand-alone partial posts where one transaction involved one part or one labour entry, etc.. But even in those cases, each transaction would have to update part, or labor info, the repair record, and accompanying accounting journal entries all as one unit to maintain application integrity. These would still be big if not really big transactions. In either case, each transaction would involve multiple updates to files. More than one file /or record may involve sequential ids. Going into the transaction one might not know all that will be needed. Pessimistic and optimistic locking methods changes what one knows as a transaction begins. If you place a readu lock as soon as you read the record, then do the processing and decision making within the transaction, the transaction takes longer and locks remain set longer. If you do the processing first, then you know the updates required before you TRANSACTION START and re-read, placing readu locks, and compare what you expected with what you got. Almost all applications have one central document (like the repair order above) that everything revolves around. It usually defines the relationships to most of the other major entities in the db. There are usually updates that involve that central document and the entities connected to it. Those updates usually have to happen as a group, one logical transaction, for the sake of application data integrity. This is the sort of thing I was thinking about when I posed the question of how to control sequential ids, releasing that control ASAP within big transactions. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This
[U2] Write error in UniAdmin
The last two installations I have received the following errors when attempting to create a device under Devices in UniAdmin 1.3.1. The error is Unable to write device record to DEVICE. This is UniVerse 10.1.11 for Windows. Platform: Windows 2003 Server Standard I have logged in both a local administrator and domain administrator account and get the error. Any ideas? Paul Hamrick Access Software 2610 SE Willoughby Blvd. Willoughby Business Park Stuart, FL 34994 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 772-463-4588 Ext. 15 http://www.airpax.com/ www.airpax.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Write error in UniAdmin
The last two installations I have received the following errors when attempting to create a device under Devices in UniAdmin 1.3.1. The error is Unable to write device record to DEVICE. This is UniVerse 10.1.11 for Windows. Platform: Windows 2003 Server Standard I have logged in both a local administrator and domain administrator account and get the error. Thoughts? Paul Hamrick Access Software 2610 SE Willoughby Blvd. Willoughby Business Park Stuart, FL 34994 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 772-463-4588 Ext. 15 http://www.airpax.com/ www.airpax.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
In my opinion... NO : Retrofitting TRANSACTIONs into existing programs would be a nightmare. YES: Definitely use them when writing a new application from scratch and even a new sub-system enhancement if it is pretty much self-contained with limited, well-defined interfaces that write into the parent system. NO : I would caution against writing them into new programs that are enhancements to existing (sub-)systems. cds From: Les Hewkin we had a batch process that processed lots of data and I mean lots, but it didn't have any transaction boundaries. Someone was asked to add them. So what did they do? yes you got it. At the start of the routine they started a transactions and at the end of the routine they ended the transactions. Guess what? the lock table filled up and the whole thing fell over. The fun you have with transactions is endless :-) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Custom Functions
From: Ray Wurlod [EMAIL PROTECTED] Try using the SUBR() function, as I mentioned in another post. Ouch. Granted my function opens a file and [currently, for debug] prints to the screen, but attempting to call it with SUBR from an I-Descriptor caused... '25945 Bus error' and left the session unresponsive. Leaving aside the I-Descriptor issue for a moment... Is there a way for it a function to assume that the last file opened is the one I want to use? I thought there might be an @FILE or something, the way there is @ID and you can have a 'default' file for READ. http://www.pickwiki.com/cgi-bin/wiki.pl?TreeTraversal I thought of opening the file in the calling program, and passing a file handle instead of the filename. But I need this to work when called [indirectly] from UOJ also, and historically I've seen 'Error 30102' if I attempt to pass file handles around in any code called from UOJ. Advice on how to improve this would be gratefully accepted [see code in Wiki link above]. While the first one isn't TOO bad... there's a companion function that finds all of the children of a particular node, and it calls the first function to look back up the tree for any child that has multiple parents. In that case I open the same file over, and over and over. Thanks, Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Wendy; I tend not to use a FUNCTION unless I really need it for the syntax. It helps me to remember that even when calling a function you can change any of the passed variables - not just the return variable (just like a subroutine). For some reason I didn't think a function could do that, I'm not sure if I saw that in the documentation or was just the way I thought it should work. In any case, I don't know how to give it a default file to use. If you call it from UniQuery you have the @ID and @RECORD variables to use but nothing really for a file. What I did - that made a HUGE difference - was to put the filevar into named common. Since the program could be called from multiple accounts I also put the path into common as well. E.g.: SUBROUTINE TESTSUB(RET_DATA, FILENAME, ID, FIELDNUM) COMMON /TESTSUB/ PATH, FILEVAR RET_DATA = '' IF UNASSIGNED(PATH) THEN PATH = 'Some path that will not exist on any system' IF PATH # @PATH THEN OPEN FILENAME TO FILEVAR THEN PATH = @PATH END ELSE RETURN END END READV RET_DATA FROM FILEVAR, ID, FIELDNUM ELSE RET_DATA = '' RETURN This will help if you call it from UniQuery or multiple times from another subroutine; I'm not sure how well it will work if you called it multiple times from UniObjects. Colin Alfke From Calgary, AB where I can't believe we've been flooded for a week -Original Message- From: Wendy Smoak From: Ray Wurlod [EMAIL PROTECTED] Try using the SUBR() function, as I mentioned in another post. Ouch. Granted my function opens a file and [currently, for debug] prints to the screen, but attempting to call it with SUBR from an I-Descriptor caused... '25945 Bus error' and left the session unresponsive. Leaving aside the I-Descriptor issue for a moment... Is there a way for it a function to assume that the last file opened is the one I want to use? I thought there might be an @FILE or something, the way there is @ID and you can have a 'default' file for READ. http://www.pickwiki.com/cgi-bin/wiki.pl?TreeTraversal I thought of opening the file in the calling program, and passing a file handle instead of the filename. But I need this to work when called [indirectly] from UOJ also, and historically I've seen 'Error 30102' if I attempt to pass file handles around in any code called from UOJ. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Parsippany
There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
So would I -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, June 23, 2005 2:58 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Parsippany There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
Nestle Waters North America uses UniVersethey are based in Greenwich, CT but distribute water (Poland Spring, Deer Park, etc.) everywhere -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, June 23, 2005 2:58 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Parsippany There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
I've never seen this asterisk thing on the front of a cataloged program. I've never had to do that in UniData. I can call a SUBROUTINE fine from a Virtual attribute no problem - and not asterisk. Could it have something to do with the fact that we run BASICTYPE 'p' and ECLTYPE 'p'? -Original Message- From: gerry-u2ug [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
I used to work for Matheson Gas Co. that used Epicor on HP900 with UD. They are based in Parsippany, NJ. I haven't worked with them for many years so I can't say for sure if they are still running the same systems. Bruce Lunt From: Brutzman, Bill [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: [U2] Parsippany Date: Thu, 23 Jun 2005 14:57:46 -0400 There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
I'm just interested to know who uses multi-value in the north-eastern US -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roger Glenfield Sent: Thursday, June 23, 2005 4:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Parsippany The epicor job listing? -Rog John Varney wrote: So would I There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Ouch. Granted my function opens a file and [currently, for debug] prints to the screen, but attempting to call it with SUBR from an I-Descriptor caused... '25945 Bus error' and left the session unresponsive. I don't get the example as posted - seems like F.FILE doesn't get saved anywhere between calls. Shouldn't it be: FUNCTION A51.ULTIMATE.PARENT( ID, FILENAME, F.FILE, FIELD.NUM ) snip ** IF NOT(FILEINFO(F.FILE,0)) THEN CRT 'Opening file' OPEN FILENAME TO F.FILE ELSE RETURN -2 END ELSE CRT 'Using existing file handle' END Instead? Seems like your choices are passing around the file handle as a parameter, sticking it in named common or one of the @user variables. Ian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
Wow, wouldn't we all love to get a list like that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Thursday, June 23, 2005 4:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Parsippany I'm just interested to know who uses multi-value in the north-eastern US -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roger Glenfield Sent: Thursday, June 23, 2005 4:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Parsippany The epicor job listing? -Rog John Varney wrote: So would I There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsippany
They are running Epicor's Avante software. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Lunt Sent: Thursday, June 23, 2005 1:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Parsippany I used to work for Matheson Gas Co. that used Epicor on HP900 with UD. They are based in Parsippany, NJ. I haven't worked with them for many years so I can't say for sure if they are still running the same systems. Bruce Lunt From: Brutzman, Bill [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: [U2] Parsippany Date: Thu, 23 Jun 2005 14:57:46 -0400 There seems to be a [water?] company in Parsippany NJ using U2. I would like to know who they are. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 973.471.9666 .fax www.hkMetalCraft.com http://www.hkMetalCraft.com [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
I think it's a universe/unidata difference. I get the segmentation fault running unidata in ecl type U as well. Here's some interesting info and an ugly hack--in unidata. Apparently, the keywords SUBROUTINE and FUNCTION are interchangable as far as BASIC is concerned, so create a subroutine SUBROUTINE MYHACK(A,B) A=B*2 ;* note that we both assign the result to a parameter AND return the result RETURN A Then you can call it as a function with PROGRAM HACKTEST DEFFUN MYHACK(A,B) CRT MYHACK('',2);* --- there's the hack. You need that placeholder parameter Or use it as a subroutine: PROGRAM HACK2 CALL MYHACK(A,2) CRT A Or from a virtual attribute: I SUBR('MYHACK',EXTRACT(@RECORD,1,0,0)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 4:09 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Custom Functions I've never seen this asterisk thing on the front of a cataloged program. I've never had to do that in UniData. I can call a SUBROUTINE fine from a Virtual attribute no problem - and not asterisk. Could it have something to do with the fact that we run BASICTYPE 'p' and ECLTYPE 'p'? -Original Message- From: gerry-u2ug [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Interesting. But you NEED that extra parameter? I tried DEFFUNing a SUBROUTINE that has only 1 parameters and could not get it to work. If your FUNCTION sets any of the parameters, you can CALL It from UniBasic -- and you don't have to DEFFUN it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 5:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions I think it's a universe/unidata difference. I get the segmentation fault running unidata in ecl type U as well. Here's some interesting info and an ugly hack--in unidata. Apparently, the keywords SUBROUTINE and FUNCTION are interchangable as far as BASIC is concerned, so create a subroutine SUBROUTINE MYHACK(A,B) A=B*2 ;* note that we both assign the result to a parameter AND return the result RETURN A Then you can call it as a function with PROGRAM HACKTEST DEFFUN MYHACK(A,B) CRT MYHACK('',2);* --- there's the hack. You need that placeholder parameter Or use it as a subroutine: PROGRAM HACK2 CALL MYHACK(A,2) CRT A Or from a virtual attribute: I SUBR('MYHACK',EXTRACT(@RECORD,1,0,0)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 4:09 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Custom Functions I've never seen this asterisk thing on the front of a cataloged program. I've never had to do that in UniData. I can call a SUBROUTINE fine from a Virtual attribute no problem - and not asterisk. Could it have something to do with the fact that we run BASICTYPE 'p' and ECLTYPE 'p'? -Original Message- From: gerry-u2ug [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Write error in UniAdmin
Are you trying to add a tape device? If so you need to manually edit the DEVICES file. -Original Message- From: Paul Hamrick [mailto:[EMAIL PROTECTED] Sent: Thursday, 23 June 2005 10:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Write error in UniAdmin The last two installations I have received the following errors when attempting to create a device under Devices in UniAdmin 1.3.1. The error is Unable to write device record to DEVICE. This is UniVerse 10.1.11 for Windows. Platform: Windows 2003 Server Standard I have logged in both a local administrator and domain administrator account and get the error. Any ideas? Paul Hamrick Access Software 2610 SE Willoughby Blvd. Willoughby Business Park Stuart, FL 34994 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 772-463-4588 Ext. 15 http://www.airpax.com/ www.airpax.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
gerry-u2ug wrote: globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 As others have mentioned, its a difference between UniData and UniVerse. On UniData you *CAN* use an asterisk before a SUBROUTINE name to identify it as globally cataloged, but there is no need to and no benefit gained from doing it. [EMAIL PROTECTED] wrote: Here's some interesting info and an ugly hack--in unidata. Apparently, the keywords SUBROUTINE and FUNCTION are interchangeable as far as BASIC is concerned, so create a subroutine SUBROUTINE MYHACK(A,B) A=B*2 ;* note that we both assign the result to a parameter AND return the result RETURN A Then you can call it as a function with PROGRAM HACKTEST DEFFUN MYHACK(A,B) CRT MYHACK('',2);* --- there's the hack. You need that placeholder parameter Or use it as a subroutine: PROGRAM HACK2 CALL MYHACK(A,2) CRT A Or from a virtual attribute: I SUBR('MYHACK',EXTRACT(@RECORD,1,0,0)) That's quite interesting Ed. Does it behave the same if you code MYHACK as 'FUNCTION MYHACK(A,B)'? Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
That could have been simply overcome by locking the file instead of individual records. I have done very large transaction boundaries for a specific type of system and they worked very well. Saves a lot of leg work and programming to manually create a recovery process for a major batch updated. Regards David Jordan Someone was asked to add them. So what did they do? yes you got it. At the start of the routine they started a transactions and at the end of the routine they ended the transactions. Guess what? the lock table filled up and the whole thing fell over. The fun you have with transactions is endless :-) Les --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Connection Refused downloading PE
After answering all those questions, I finally made it to the place where I could download UD 6.1 PE and the download applet reports http://service2.boulder.ibm.com:7618 Connection Refused . The 'clients' .zip file is downloading over HTTP with no problems, but it looks like it's coming from a different place. I'll try again tomorrow, meanwhile I figured I'd at least mention it in the hopes that someone from IBM might be able to check on it. Thank you! -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/