Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
FYI. I took the liberty of forwarding this to the U2UG Enhancements Committee. -- Regards, Clif On Jun 15, 2005, at 10:01 PM, Steve Johnson wrote: This would be a very worthwhile enhancement IMO. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe LIST.READU and change in inode number of file
Hi, In continuation with the locking issues I have some more questions as follows, The output of LIST.READU is as follows, Device Inode Netnode Userno Lmode Pid LoginId Item-ID., 34485434 99640 50360 107 RU 15176 appsadmGGB101031 34485434 10391 050360 107 RU 15176 appsadmGGB101031 The above two entries are exactly same in nature except for the Inode number of file on which the lock is obtained. Surprisingly the same record is locked twice by same process and almost at same point of time one after another. Does this mean that universe internally changes the inode number of the type 30 files and reallocates new inode number to same file? How to control such LOCKs in universe which is not released because of change in inode number of file? Is there any way to preventing such locks which are obtained at system level? TIA. Regards, Deepak *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe LIST.READU and change in inode number of file
Hi, In continuation with the locking issues I have some more questions as follows, The output of LIST.READU is as follows, Device Inode Netnode Userno Lmode Pid LoginId Item-ID., 34485434 99640 50360 107 RU 15176 appsadmGGB101031 34485434 10391 050360 107 RU 15176 appsadmGGB101031 The above two entries are exactly same in nature except for the Inode number of file on which the lock is obtained. Surprisingly the same record is locked twice by same process and almost at same point of time one after another. Does this mean that universe internally changes the inode number of the type 30 files and reallocates new inode number to same file? How to control such LOCKs in universe which is not released because of change in inode number of file? Is there any way to preventing such locks which are obtained at system level? TIA. Regards, Deepak *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reg output of LIST.READU
From: shuchi bhandari i had another query reagrding the output of LIST.READU command. On running the command, we got multiple lines of records that were exactly similar i.e. all the parameters inncluding the inode number; process id and Item id were the same. Is this a case of multiple locking of the same databse file by the same process? Can someone explain. I am assming UV, not UD. 1. Are these READL locks and not READU locks? There can be multiple READLs on the same record. They will show up as either RL or RU under the Lmode column. 2. Are the Record IDs too long to fit the screen and they differ only in the rightmost bytes where you can't see them? 3. Does LIST.READU INTERNAL show the IDs different than the others? 4. I assume the Device column is also the same. (It would be a little strange that inodes would happen to match on files across 2 file-systems, files that happen to share the same ID scheme.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reg output of LIST.READU
it's UV. All the locks are RU i.e READU locks. The record ids are not too long have confirmed it with LIST.READU INTERNAL command also. They are the same. Yes the device ids are also the same. From: Stevenson, Charles [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] Reg output of LIST.READU Date: Thu, 16 Jun 2005 02:43:03 -0400 From: shuchi bhandari i had another query reagrding the output of LIST.READU command. On running the command, we got multiple lines of records that were exactly similar i.e. all the parameters inncluding the inode number; process id and Item id were the same. Is this a case of multiple locking of the same databse file by the same process? Can someone explain. I am assming UV, not UD. 1. Are these READL locks and not READU locks? There can be multiple READLs on the same record. They will show up as either RL or RU under the Lmode column. 2. Are the Record IDs too long to fit the screen and they differ only in the rightmost bytes where you can't see them? 3. Does LIST.READU INTERNAL show the IDs different than the others? 4. I assume the Device column is also the same. (It would be a little strange that inodes would happen to match on files across 2 file-systems, files that happen to share the same ID scheme.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Claim your space online! http://www.msn.co.in/spaces Share your world for free! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe LIST.READU and change in inode number of file
It is very hard for any application program on UNIX to change the inode associated with a file. Have you identified the filenames associated with these two inode numbers? I strongly suspect that the application is locking records in two different files at the same time. A master record and a detail record perhaps? Many applications use the same key to different files. Best Regards, Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Deepak Subhash Jadhav Sent: Thursday, 16 June 2005 4:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe LIST.READU and change in inode number of file Hi, In continuation with the locking issues I have some more questions as follows, The output of LIST.READU is as follows, Device Inode Netnode Userno Lmode Pid LoginId Item-ID., 34485434 99640 50360 107 RU 15176 appsadmGGB101031 34485434 10391 050360 107 RU 15176 appsadmGGB101031 The above two entries are exactly same in nature except for the Inode number of file on which the lock is obtained. Surprisingly the same record is locked twice by same process and almost at same point of time one after another. Does this mean that universe internally changes the inode number of the type 30 files and reallocates new inode number to same file? How to control such LOCKs in universe which is not released because of change in inode number of file? Is there any way to preventing such locks which are obtained at system level? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv]CREATE.FILE syntax for remote directories
They (IBM) paid US$11 for Ascential. And that's not a binary number!! Are you and Dave going to moonlight as U2 engineers again?!! :D - Original Message - From: Glenn Herbert [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] [uv]CREATE.FILE syntax for remote directories Date: Wed, 15 Jun 2005 12:19:29 -0400 And yes, I am now in the employ of IBM, which acquired Ascential and DataStage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, New Zealan d
Wellington in winter?!! Brr-rr-rr!!! --- 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/ROLLBACK
I cant say that I have experience with this. In our GET.KEY subroutines, we do a READU, check to see if the key exists and if not, increment the sequential key, write back to the control file and recordlocku the file we are generating the key for (along with checking the len() of the key and other particulars - barcoding, field widths on reports,screens, etc...) I was thinking if you did something similar, but use a READVL then others might not be locked out of the control file while the transaction is in place ? It was just a thought. If you have a properly structured GET.KEY routine and all of your programs check to see if the records exists before writing, then this should work without stepping on existing records. We dont use transaction logging here, so this may make no sense at all. Just throwing out an idea. I dont know if READVL is allowed in a transaction. Maybe not, then bad idea. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 11:45 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/ROLLBACK From: Anthony Dzikiewicz So, what if you change the READVU to a READVL ? I don't understand what READL buys me. (Not arguing, just looking to understand.) I thought you need a READU in order to do the write within the transaction. By the way, I've only been working with ISOMODE 1, if that matters. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Auditors and sequential numbers
When I was involved in a audit he wanted proof of missing invoice numbers. 15 years ago. I kinda laughed we didn't have the proof at that time, and from then forward we kept the printed 'voided' invoice (for invoices that printed incorrectly) in the numerical paper file. But as a programmer I know it would take me nothing at all to simply duplicate a voided invoice. And even in times when the printer jammed... we had no choice but to fake the missing invoice numbers. Really seemed pointless to me. He wouldn't take the printed sales journal with the missing numbers on it for proof, he wanted a paper invoice with the number on it and void written on it. This was a system where we did the data entry for the invoice, (batch) printed the invoices, CHECKED them manually, voided any that were wrong and THEN ran the update. Ah.. the good ole days. ~Marilyn -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 12:49 AM To: u2-users@listserver.u2ug.org Subject:Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... I just can't keep quiet any more. Any auditor who depends on a non-information content, sequentially assigned, record counters as an audit trail ought to be flogged and sent back to Auditing For Dummies. If your auditor demands that, I'd suspect they are a paper-based bean counter, not an Information Systems Auditor. -- Regards, Clif Member ISACA www.isaca.org ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jun 15, 2005, at 8:47 PM, Stevenson, Charles wrote: Missing sequential numbers isn't important to me, but it's a good point for general discussion. cds From: Bruce Nichol This is all well and good if the commit goes ahead, but if rollback is the action, don't you lose a supposedly sequential root key into the vapours? Never to be seen again? That'd make an auditor go spare. 61,62,63,65,66... Hang on! Where's 64? Stop the presses! Everybody down and look for 64... --- 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] mvBASE to Unidata via virtual tape file
Anyone had experience with moving from mvBASE to Unidata via the VTF (virtual tape file) backup method provided by mvBASE ? FYI: the vtf is basically a tape file written to disk. mvBASE uses the same 'file-save', 'account-save', 't-dump' commands to tape as well as to VTFs. Thanks in advance, Steve Trimble Computerized Data Management, Inc. PO Box 3473 Fayetteville, AR 72702 (479) 521-5670 9:00am - 6:00pm CST [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] TRANS vs T-correlative: caching last record
Barry, Could you post your test program? thx, cds -Original Message- From: Barry Brevik for UniVerse, TRANS() ( aka XLATE() ) will cache a record behind the scenes so that a 2nd I-descriptor that TRANS()s to the same record Please excuse me for butting in. That is very interesting, as I just did some testing that indicates that when TRANS() is used in a basic program, performance (when compared to READing the record) is degraded when a second field in the same record is TRANS'd. This is on UV 9.6.1.3 on W2K. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] TRANS vs T-correlative: caching last record
for UniVerse, TRANS() ( aka XLATE() ) will cache a record behind the scenes so that a 2nd I-descriptor that TRANS()s to the same record Please excuse me for butting in. That is very interesting, as I just did some testing that indicates that when TRANS() is used in a basic program, performance (when compared to READing the record) is degraded when a second field in the same record is TRANS'd. This is on UV 9.6.1.3 on W2K. The TRANS cache only operates in the query processor, not Basic programs. (I keep plugging the Internals course. This is one of the things you would have learned about!) Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Using httpout / UV based webserver / images?
Right now, I use apache as my webserver, and it integrates with our UV apps fairly well. I considered to increase it's speed to rewrite using callhttp and write a basic webserver, no problem, for text. But how do I send images (binary information) that might contain xFF's? Right now, apache handles that end without question. What are some of the methods used to write binary data using callhttp? George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] TRANS vs T-correlative: caching last record
Martin, Thanks for that: The TRANS cache only operates in the query processor, not Basic programs. Would you be willing to tackle any of these other questions? : - Is T-correlative smart enough to do the same caching as TRANS()? - The caching is only 1 record 1 file deep, just one single filerecord combo gets cached, right? - Does T-correlative use the same underlying code as TRANS()? I would guess T-corrs resolve to TRANS() under the covers. - Compare UD other MV_DBMSs to UV: Do any of themcache records like UV's TRANS()? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] mvBASE to Unidata via virtual tape file
quote who=CDMI Anyone had experience with moving from mvBASE to Unidata via the VTF (virtual tape file) backup method provided by mvBASE ? FYI: the vtf is basically a tape file written to disk. mvBASE uses the same 'file-save', 'account-save', 't-dump' commands to tape as well as to VTFs. What about ftping the vtf to the other system, then using the Unix dd command to write the file to tape. I've done this with systems in the past and had success after monkeying around with block sizes, etc... I offer this assuming you are on Unix. If not, you could install CygWin on the WIN Server. HTH, Karl Thanks in advance, Steve Trimble Computerized Data Management, Inc. PO Box 3473 Fayetteville, AR 72702 (479) 521-5670 9:00am - 6:00pm CST [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] TRANS vs T-correlative: caching last record
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Using httpout / UV based webserver / images?
In a message dated 6/16/2005 10:56:07 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Right now, I use apache as my webserver, and it integrates with our UV apps fairly well. But what do you use *between* Apache and the UV apps? Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using httpout / UV based webserver / images?
The cgi writes the environment varibles to a file using the PID as the ID, then waits for that PID to appear in another file, which it sends the contents of that back through the browser. On the UV side, I have a phantom that monitors the first file for any new ID's (PIDS) which it then looks at (one of the environment/http varibles tells what function it is), and tosses it off to the appropriate program, which does it thing, and creates HTTP output which it writes back tothe second file (using the PID) for the cgi to give back to the user. the cgi knows nothing of UV, just that it writes a file, and reads a file. and UV knows nothing of the cgi, just it gets data and writes creates data. One nice feature, is that the UV and the webserver could be on two different machines, as long as they can share two directories (files), one for cgi output, and the other for cgi input. (good for security, if the webserver is hacked, the UV server is not). It works, but sometimes is a little slow. So I considered eliminating the apache side, and puting the server function in UV as well. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 16, 2005 2:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using httpout / UV based webserver / images? In a message dated 6/16/2005 10:56:07 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Right now, I use apache as my webserver, and it integrates with our UV apps fairly well. But what do you use *between* Apache and the UV apps? Will Johnson --- 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] [UV] TRANS vs T-correlative: caching last record
Always good to get answers from both Glenn Martin. I thank you both. But combining the 2 answers : - Is T-correlative smart enough to do the same caching as TRANS()? {glenn} A T-correlative calls TRANS under the covers. The t-correlative is parsed and then calls trans() to do all the work. and The TRANS cache only operates in the query processor, not Basic programs. I'm still left wondering if T-correlatives do caching. If TRANS() caches only for RetrieVe and not Basic, is the caching happening (a) inside TRANS() (it knows whether its coming from retrieve or basic) or (b) by RetrieVe itself, in a layer above TRANS()? If (a), then I would expect T-correlatives to cache just like TRANS() If (b), then probably not. - cds --- 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/R...
Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... From: Bill Haskett I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? No, those are independent of transactions. So could they be leveraged for the question posed here? . . . I don't see it. cds --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Charles: No, you guys aren't the only ones. This is a pretty miserable hole in the mvDbms functionality. However, since we've been writing this stuff for years the routines are already built to solve our problems. I just didn't know TRANSACTION bracketing was going to break them. Unknowns like this are the reason we haven't implemented transactions, as we haven't been eager to rework some core functions in our application. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Would this be a worthwhile enhancement request through U2UG? Are Ken and I the only ones whining about this: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Pdf Software Upgrade
Craig, We are finally done testing the new PDF software on Windows (thanks to your sending the trial). I want to install the new rev on our Linux server. I wanted to run the procedure by you. If you could check me on this I would appreciate it. 1. Delete the current CROSSPDF account I tried doing a PDF.INSTALLER -U as a test and it complains and doesn't get the job done So, I am opting for this instead 2. ReCreate the directory for the software (/pos/crosspdf)and create a Universe account there 3. Create the 2 files needed PDFINST, PDFINST.O 4. Unzip the software into the respective files 5. Get into Universe, run PDF.INSTALLER I am assuming that at this point I am done ? We have added a file in our main account called ADOBEFONTS, which contain some extra fonts that we had purchased. Do these have to be recompiled ? If so, then my next step would be to kick off the COMPILE.FONTS job to do that. Now am I done ? Thanks Anthony By the way, the new printer is a Xerox X4500DX. We create the PDF's and send directly to the printer via 'lp' command. No converting to postscript first. It works very nice. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using httpout / UV based webserver / images?
I did something like this a few years ago (on unix). Inetd was configured to run uv httpd in response to hits on port 80, where httpd was a basic program that read and wrote to standard io using socket calls (this was before universe included socket functions, so I had some simple GCI code that implemented socket send and receives, more or less copying the functionality of GET and SEND). There was no problem at all with binary data. So a basic program read the HTTP request and served either files from unix or items from hashed files, or requests with cgi-bin in the path ran subroutines with output directed back to the client. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, June 16, 2005 1:47 PM To: Ardent List Subject: [U2] Using httpout / UV based webserver / images? Right now, I use apache as my webserver, and it integrates with our UV apps fairly well. I considered to increase it's speed to rewrite using callhttp and write a basic webserver, no problem, for text. But how do I send images (binary information) that might contain xFF's? Right now, apache handles that end without question. What are some of the methods used to write binary data using callhttp? George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Clif: Since I've been in both the accounting and information systems fields for over 25 years, I can't say as I understand the term ...non-information content, sequentially assigned, record counter. I'm sure it doesn't mean what I think it does as I've found sequential counters to be an invaluable tool in a number of auditing scenarios. However, it's always possible I could use a good flogging. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, June 15, 2005 10:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... I just can't keep quiet any more. Any auditor who depends on a non-information content, sequentially assigned, record counters as an audit trail ought to be flogged and sent back to Auditing For Dummies. If your auditor demands that, I'd suspect they are a paper-based bean counter, not an Information Systems Auditor. -- Regards, Clif Member ISACA www.isaca.org ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jun 15, 2005, at 8:47 PM, Stevenson, Charles wrote: Missing sequential numbers isn't important to me, but it's a good point for general discussion. cds From: Bruce Nichol This is all well and good if the commit goes ahead, but if rollback is the action, don't you lose a supposedly sequential root key into the vapours? Never to be seen again? That'd make an auditor go spare. 61,62,63,65,66... Hang on! Where's 64? Stop the presses! Everybody down and look for 64... --- 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] Pdf Software Upgrade
What is the new PDF software? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Thursday, June 16, 2005 3:18 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pdf Software Upgrade Craig, We are finally done testing the new PDF software on Windows (thanks to your sending the trial). I want to install the new rev on our Linux server. I wanted to run the procedure by you. If you could check me on this I would appreciate it. 1. Delete the current CROSSPDF account I tried doing a PDF.INSTALLER -U as a test and it complains and doesn't get the job done So, I am opting for this instead 2. ReCreate the directory for the software (/pos/crosspdf)and create a Universe account there 3. Create the 2 files needed PDFINST, PDFINST.O 4. Unzip the software into the respective files 5. Get into Universe, run PDF.INSTALLER I am assuming that at this point I am done ? We have added a file in our main account called ADOBEFONTS, which contain some extra fonts that we had purchased. Do these have to be recompiled ? If so, then my next step would be to kick off the COMPILE.FONTS job to do that. Now am I done ? Thanks Anthony By the way, the new printer is a Xerox X4500DX. We create the PDF's and send directly to the printer via 'lp' command. No converting to postscript first. It works very nice. --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
I would think the key phrase is non-information content. Sequential numbers that have meaning, such as check numbers, would not, in my mind, fall under this category. Sequential numbers used for assigning ids to people, however, would likely fall into this category. Of course, a lot of it depends on the organization's use of that number, as to whether it is informational or not. Drew Bill Haskett wrote: Clif: Since I've been in both the accounting and information systems fields for over 25 years, I can't say as I understand the term ...non-information content, sequentially assigned, record counter. I'm sure it doesn't mean what I think it does as I've found sequential counters to be an invaluable tool in a number of auditing scenarios. However, it's always possible I could use a good flogging. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, June 15, 2005 10:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... I just can't keep quiet any more. Any auditor who depends on a non-information content, sequentially assigned, record counters as an audit trail ought to be flogged and sent back to Auditing For Dummies. If your auditor demands that, I'd suspect they are a paper-based bean counter, not an Information Systems Auditor. -- Regards, Clif bscribe please visit http://listserver.u2ug.org/ -- -- Drew Henderson There are two types of people - Dir. for Computer Center Operations those who do the work and those [EMAIL PROTECTED] who take the credit. Try to be in the first group, there is 110 Ginger Hall less competition. Morehead State University Indira Ghandi Morehead, KY 40351 Phone: 606/783-2445 Fax: 606/783-5078 -- --- 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...
Well, you raise a point, but not the one I think you intend. Transactions should be designed to be active for the minimum span of time to avoid the bottleneck mentioned. I would think very carefully about any transaction the cached a large group of updates for a long period of time, say all postings of a select list of transaction. Instead I would put the transaction inside the loop unless there was a very good reason to be able to back out the entire batch of selected updates. In either case the assignment of a sequential id from a control record is, in and of itself, a data change that should be cached. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Sunday, June 12, 2005 4:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Charlie, I don't see how that addresses the TRANSACTION problem. If the call to your NEXT.AVAIL.ID routine happens after TRANSACTION START, the id control item will not be updated nor will its lock be released until TRANSACTION COMMIT (or rollback) is executed, even though the NEXT.AVAIL.ID routine says to write and release it. This is a potential bottleneck if other concurrent processes are wanting to do the same, waiting for that control item. cds --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
If more people care, they whould weigh in. Clif moved it into the U2UG Enhancement committee's queue. I'm on that committee so I'll take it up there, but the more voices the better. -Original Message- From: Bill Haskett Charles: No, you guys aren't the only ones. This is a pretty miserable hole in the mvDbms functionality. However, since we've been writing this stuff for years the routines are already built to solve our problems. I just didn't know TRANSACTION bracketing was going to break them. Unknowns like this are the reason we haven't implemented transactions, as we haven't been eager to rework some core functions in our application. Bill Would this be a worthwhile enhancement request through U2UG? Are Ken and I the only ones whining about this: --- 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/R...
I don't think that will work, because the WRITEV is still inside the transaction. As a matter of fact, I think it will error out if there is no explicit readu preceding it. That might be isolation-level-dependent, but I don't think so. LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
FW: [U2] [UV] TRANS vs T-correlative: caching last record
Glenn seems to have trouble posting. I got this answer off-list and I haven't seen it show up yet on-list, so let me forward it to the rest of you: From: Glenn Herbert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 12:12 PM To: Stevenson, Charles Subject: RE: [U2] [UV] TRANS vs T-correlative: caching last record The answer is (a) inside TRANS() (it knows whether its coming from retrieve or basic). If you are curious why we use the trans mechanism within BASIC but never cache files or records, I believe it was done because within BASIC you can readily modify a record whereas with query you cannot, and it was deemed that you would always want the current state of the record. Hence, within BASIC you must ALWAYS retrieve the record off of disk first. Hence the perceived (and actual) slowness. PS. I have NO IDEA what is causing the extraneous email with Lynx in it. If anyone has any ideas why this happens (since I use Domino Notes w/Outlook Client) I would be greatly appreciative (email me off the group). From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles [EMAIL PROTECTED] Sent: Thursday, June 16, 2005 2:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] TRANS vs T-correlative: caching last record Always good to get answers from both Glenn Martin. I thank you both. But combining the 2 answers : - Is T-correlative smart enough to do the same caching as TRANS()? {glenn} A T-correlative calls TRANS under the covers. The t-correlative is parsed and then calls trans() to do all the work. and The TRANS cache only operates in the query processor, not Basic programs. I'm still left wondering if T-correlatives do caching. If TRANS() caches only for RetrieVe and not Basic, is the caching happening (a) inside TRANS() (it knows whether its coming from retrieve or basic) or (b) by RetrieVe itself, in a layer above TRANS()? If (a), then I would expect T-correlatives to cache just like TRANS() If (b), then probably not. - cds --- 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] Pdf Software Upgrade
Bill, What is the new PDF software? I don't think Anthony meant that message to go to the list, he is testing a new version of our PDF suite for U2. AD The CROSS PDF Suite allows you to generate PDF documents direct from U2 Windows/Unix/Linux. Quick conversion for existing reports and field based templates for new documents. You can also use our mail utilities to send the documents straight to a user's inbox. www.cross.net.au/pdf.asp /AD Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Using httpout / UV based webserver / images?
George, do you, or would you be willing to, have your code up on the pickwiki ? Will Johnson Fast Forward Technologies -Original Message- From: George Gallen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thu, 16 Jun 2005 14:42:41 -0400 Subject: RE: [U2] Using httpout / UV based webserver / images? The cgi writes the environment varibles to a file using the PID as the ID, then waits for that PID to appear in another file, which it sends the contents of that back through the browser. On the UV side, I have a phantom that monitors the first file for any new ID's (PIDS) which it then looks at (one of the environment/http varibles tells what function it is), and tosses it off to the appropriate program, which does it thing, and creates HTTP output which it writes back tothe second file (using the PID) for the cgi to give back to the user. the cgi knows nothing of UV, just that it writes a file, and reads a file. and UV knows nothing of the cgi, just it gets data and writes creates data. One nice feature, is that the UV and the webserver could be on two different machines, as long as they can share two directories (files), one for cgi output, and the other for cgi input. (good for security, if the webserver is hacked, the UV server is not). It works, but sometimes is a little slow. So I considered eliminating the apache side, and puting the server function in UV as well. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 16, 2005 2:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using httpout / UV based webserver / images? In a message dated 6/16/2005 10:56:07 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Right now, I use apache as my webserver, and it integrates with our UV apps fairly well. But what do you use *between* Apache and the UV apps? Will Johnson --- 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] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us how you can protect your children's future with a family trust from Public Trust. Call 0800 505 405 to request your free copy of our family trust guide. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
... and frequent earthquakes (somewhat like SF), and horizontal rain (SF would LERV some rain!), and wind straight from Antarctica. But, yes, it's a great place, made more so by some of the folks who live and work there. Don't be put off. - Original Message - From: Sara Burns [EMAIL PROTECTED] To: U2 List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Subject: Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d Date: Fri, 17 Jun 2005 12:18:39 +1200 Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
Goo'day, Sara, slightly windy??? What the blazes would windy be??? A Force 10 gale??? At 12:18 17/06/05 +1200, you wrote: Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us how you can protect your children's future with a family trust from Public Trust. Call 0800 505 405 to request your free copy of our family trust guide. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/05 --- 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/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, June 16, 2005 11:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... From: Bill Haskett I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? No, those are independent of transactions. So could they be leveraged for the question posed here? . . . I don't see it. cds --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, June 16, 2005 11:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... From: Bill Haskett I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? No, those are independent of transactions. So could they be leveraged for the question posed here? . . . I don't see it. cds --- 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] Pdf Software Upgrade
Sorry all ! This was intended to go straight to Craig Bennett. When I sent this, I just replied to am email in my inbox and I thought it was something that he had sent me directly and not the group. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, June 16, 2005 3:52 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Pdf Software Upgrade What is the new PDF software? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Thursday, June 16, 2005 3:18 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pdf Software Upgrade Craig, We are finally done testing the new PDF software on Windows (thanks to your sending the trial). I want to install the new rev on our Linux server. I wanted to run the procedure by you. If you could check me on this I would appreciate it. 1. Delete the current CROSSPDF account I tried doing a PDF.INSTALLER -U as a test and it complains and doesn't get the job done So, I am opting for this instead 2. ReCreate the directory for the software (/pos/crosspdf)and create a Universe account there 3. Create the 2 files needed PDFINST, PDFINST.O 4. Unzip the software into the respective files 5. Get into Universe, run PDF.INSTALLER I am assuming that at this point I am done ? We have added a file in our main account called ADOBEFONTS, which contain some extra fonts that we had purchased. Do these have to be recompiled ? If so, then my next step would be to kick off the COMPILE.FONTS job to do that. Now am I done ? Thanks Anthony By the way, the new printer is a Xerox X4500DX. We create the PDF's and send directly to the printer via 'lp' command. No converting to postscript first. It works very nice. --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, June 16, 2005 11:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... From: Bill Haskett I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? No, those are independent of transactions. So could they be leveraged for the question posed here? . . . I don't see it. cds --- 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] AD: UniVerse Analyst/Programmer Required - Wellington, New Zealand
As a West Islander who has enjoyed visits to Wellington on a number of occasions (though none recently I'm sad to say), I'd just like to express the viewpoint that Wellington in summer is lovely. In winter, I'm sure it has nice moments and I do recall encountering some of them, but it has some fairly evil ones too, and if I recall correctly, they can last a while ... Cheers, Ken Ray Wurlod wrote: ... and frequent earthquakes (somewhat like SF), and horizontal rain (SF would LERV some rain!), and wind straight from Antarctica. But, yes, it's a great place, made more so by some of the folks who live and work there. Don't be put off. - Original Message - From: Sara Burns [EMAIL PROTECTED] Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 and .NET
Mark Make sure you have the LATEST version of the UniObjects .NET dll - there were significant performance improvements If in doubt about the version you have (1.1.1.0) please contact your friendly local IBM support provider. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: 15 June 2005 16:47 To: u2-users@listserver.u2ug.org Subject: [U2] U2 and .NET I'm in the preliminary stages of looking at exposing our UniVerse database to the .NET framework. Initially for some read only type web-based inquiries and MS Reporting services, but I think .NET would position us well for other applications as well. It seems to me that there are at least three choices: UniObjects for .NET, Bluefinity's mv.NET and RainingData's data provider for .NET. And naturally I'm clueless about which choice would be better. I'd be intersted in the thoughts/experiences of list members who have used any or all of the above products. Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- 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] Reg output of LIST.READU
Version and platform? Having some thoughts ... JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shuchi bhandari Sent: 16 June 2005 06:34 To: u2-users@listserver.u2ug.org Subject: [U2] Reg output of LIST.READU i had another query reagrding the output of LIST.READU command. On running the command, we got multiple lines of records that were exactly similar i.e. all the parameters inncluding the inode number; process id and Item id were the same. Is this a case of multiple locking of the same databse file by the same process? Can someone explain. Thanks in advance _ Cant have enough of SRK? http://server1.msn.co.in/sp05/iifa/ Help him bag the award. --- 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] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
If slight frost equates to slightly windy, I expect Wellington is now encased in a block of ice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Friday, 17 June 2005 10:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us how you can protect your children's future with a family trust from Public Trust. Call 0800 505 405 to request your free copy of our family trust guide. --- 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] Pdf Software Upgrade
looks like that email was not for the list! :-) It's 'just' the excellent pdf creator software from CROSS :-)) we use it at my job to make payments for unemployed people, and since we need all outgoing documents to be stored in our document handling system, we bought the CROSS pdf package to convert all printjobs to pdf files.. We go into production monday morning, so the big test will be next weeks payments :-)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, June 16, 2005 9:52 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Pdf Software Upgrade What is the new PDF software? --Bill 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] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
Let's all move to Wellington... er move to U2-Community. This has moved way off-topic. Charles Barouch, Moderator To join U2-Community visit http://listserver.u2ug.org/, enter your e-mail address, and 'browse all' lists to maintain your access. Kieran Clulow wrote: If slight frost equates to slightly windy, I expect Wellington is now encased in a block of ice. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
They may not have pollution but they do have politicians - some might say the same thing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kieran Clulow Sent: Friday, 17 June 2005 5:15 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d If slight frost equates to slightly windy, I expect Wellington is now encased in a block of ice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Friday, 17 June 2005 10:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us how you can protect your children's future with a family trust from Public Trust. Call 0800 505 405 to request your free copy of our family trust guide. --- 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] [UV] TRANS vs T-correlative: caching last record
If my memory serves, there are separate caches for Tfile correlatives and TRANS(). The Tfile cache holds three entries, the TRANS cache eleven. And, yes, this is in the Internals course. :wink: --- 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/R...
Charles: But this doesn't solve the problem of missing sequence numbers if the TRANSACTION doesn't commit. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, June 16, 2005 11:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... Charles: I'm thinking of instead of a: READVU SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 do something like: LOCK 50 READV SeqNo FROM FILENAME.FV, 'CTRL', 1 ELSE SeqNo = 0 . ...test for existence and get the next unique value ...update record WRITEV SeqNo ON FILENAME.FV, 'CTRL', 1 UNLOCK 50 Then make sure this is either an include or a subroutine used by everything that needs a particular unique sequence no. In this case, everyone gets the momentary lock they need and transaction bracketing doesn't break the locking mechanism. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Wednesday, June 15, 2005 8:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... From: Bill Haskett I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? No, those are independent of transactions. So could they be leveraged for the question posed here? . . . I don't see it. cds --- 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/