Re: [U2] Trick for PartFiles and Indices
In message [EMAIL PROTECTED], David A Barrett [EMAIL PROTECTED] writes We have a monster file that hit the 2GB mark way back when, so we divided it up in a distributed file. It continues to grow, and the keys are largely sequential with a partitioning algorithm that puts each block of one million records into a part. Currently the file grows at a pace of about one million records every 2 years, and it's a pain in the neck to add a new part because the ten indexes on it need to be rebuilt each time you add a new part. With 8 million records, it takes a good long time to rebuild all of the indices. The other thing about this is that I go through this operation only once each two years, so that I forget the finer details about fiddling with distributed files. So before I do it on our live system, I play around with a test file to figure it out. This is where I found something interesting. Actually, I think all this was in the manuals as long ago as Prime INFORMATION ... :-) As Karl said, each partfile is a file in and of itself, with its own indices. If you try and run an index-based command over a distributed file, it will only display and/or use the indices that exist in EVERY partfile. It certainly used to be (quite likely has changed now :-) that if you tried to SELECT the distributed file and the index existed in nine part-files but not the tenth, it would ignore the index *completely*. Bearing in mind that distributed files can be created easily with ED (provided that the partfiles already exist as partfiles), I think UV checks the partfiles when you access them (not looking up info from PARTFILES). So again as Karl says, if you just create the new partfile, index it, and add it, you won't upset the index status across the distributed file. Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Mark Shannon/Australia/IBM is out of the office.
I will be out of the office starting 26/10/2006 and will not return until 01/11/2006. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] New Account Setup - Copy VOC ?
In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Somewhere other than HOLD
Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] New Account Setup - Copy VOC ?
Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Somewhere other than HOLD
George Gallen wrote: Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. No way that I know of. But here's another workaround - rewrite the VOC entry to HOLD temporarily. Keep in mind that it's a kludge that would work only if you don't have multiple users writing to the HOLD file or if you need to write to the HOLD *and* to your other file during the same process. And I'm not sure if UV caches the pointer to HOLD or not, so you'd have to test. -- Allen Egerton, aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] New Account Setup - Copy VOC ?
Looks like the new VOC was incompletely copied from NEWACC, or someone has given NEWACC a severe haircut. Check these possibilities, lest you get bitten over and over. If your small VOC contains COPY and NEWACC, then it might be better to copy from there. You can use UVwrite to put an ED entry into your VOC. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Somewhere other than HOLD
We have people writing to hold all the time...(well not all the time, but you know, when you most need someone to NOT write to the file, that is when they will most likely do it!) George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen Egerton Sent: Thursday, October 26, 2006 1:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Somewhere other than HOLD No way that I know of. But here's another workaround - rewrite the VOC entry to HOLD temporarily. Keep in mind that it's a kludge that would work only if you don't have multiple users writing to the HOLD file or if you need to write to the HOLD *and* to your other file during the same process. And I'm not sure if UV caches the pointer to HOLD or not, so you'd have to test. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Somewhere other than HOLD
We do this here with the following. EXECUTE 'SETPTR ,132,60,4,0,1,BRIEF,FORM ACHFILE,NFMT,RETAIN,INFORM,BANNER UNIQUE ACH_RPT_':DATE() The form ACHFILE is the file we store this report in. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, October 26, 2006 10:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Somewhere other than HOLD Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. 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] Somewhere other than HOLD
This might be crossing the lines of the bizarre, but if you know your HOLD entry name, why not execute a OS-level command to put a symlink to it from another directory. The actual file doesn't move, but you have access to it from another directory. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] What Flavor UV ?
How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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] Somewhere other than HOLD
What I want to do is only have certain reports go to a specific file, so a web process can select from them. Rather than have the web process use the HOLD file which will have hundreds of other files (Yes, I could use a filter...). So the symlink won't help. I could also use a Q pointer from another account rather than use the symlink. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Thursday, October 26, 2006 1:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Somewhere other than HOLD This might be crossing the lines of the bizarre, but if you know your HOLD entry name, why not execute a OS-level command to put a symlink to it from another directory. The actual file doesn't move, but you have access to it from another directory. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] Somewhere other than HOLD
hmm. I've never used FORM xx with a directory. Does it require a special DEVICES entry? I'll have to play with this. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Thursday, October 26, 2006 1:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Somewhere other than HOLD We do this here with the following. EXECUTE 'SETPTR ,132,60,4,0,1,BRIEF,FORM ACHFILE,NFMT,RETAIN,INFORM,BANNER UNIQUE ACH_RPT_':DATE() The form ACHFILE is the file we store this report in. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What Flavor UV ?
Does .L RELLEVEL still work? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, October 26, 2006 2:15 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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/
[U2] [OT] - Texas Sales Tax
This is totally off topic and apologize for this. Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. Thanks in advance Marc Marc Caminiti Nashbar Direct, Inc IS Manager Bike Nashbar 330.533.1989, ext 336 6103 State Route 446 330.702.9733, fax Canfield, OH 44406 [EMAIL PROTECTED] http://www.nashbar.com Computers make very fast, very accurate mistakes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Somewhere other than HOLD
on further reading...now, I see what your saying. Your right...bizarre. h. Once I have the entry name (which we have a subroutine to do), I might as well just do the READ/WRITE to the new file. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Thursday, October 26, 2006 1:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Somewhere other than HOLD This might be crossing the lines of the bizarre, but if you know your HOLD entry name, why not execute a OS-level command to put a symlink to it from another directory. The actual file doesn't move, but you have access to it from another directory. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] What Flavor UV ?
ED VOC RELLEVEL Thanks Have a Great Day!! Sincerely, Deb Bruns Systems Analyst Sick, Inc. 6900 West 110th Street Minneapolis, MN 55438 USA Phone: 952.941.6780 Fax: 952.941.9287 Direct: 952.829.4842 http://www.sickusa.com This message and attachments are solely for the intended recipient and may contain confidential of privileged information. If you are not the intended recipient, any disclosure, copying, use or distribution is prohibited. If you have received this communication in error, please notify us by reply email and immediately and permanently delete this message and any attachments. Thank you. Brutzman, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/26/2006 01:15 PM Please respond to u2-users@listserver.u2ug.org To 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org cc Subject [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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] What Flavor UV ?
There is a SYSTEM() cell that will tell you. Do a HELP BASIC SYSTEM() and look for flavor and the write a Basic program to CRT SYSTEM(X). hth Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, October 26, 2006 1:15 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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/
[U2] [Ad] Free Web Developer
U2logic, a Colorado based tools and web developer, is announcing the release of its newly developed XLr8 Developer for Web programming. The XLr8 Developer is an Eclipse plug-in and part of U2logic's every growing tools available for the U2 databases. U2logic has taken an open source lightweight remote procedure call protocol called json-rpc and is used to communicate with U2 databases. The overhead for this software is minimal so that the communication with U2 database is anywhere from 30% to 700% faster than prior technology U2logic used from IBM. Json-rpc uses open source web server from Apache's Tomcat and can run on most every hardware and software platform. Currently, json-rpc is being ported to Microsoft's .Net platform. U2logic is calling this middleware U2Weblink. U2Weblink is currently available in a two user version at no cost and can be downloaded from www.u2logic.com. XLr8 Developer is part of XLr8 Editor, XLr8 Installer, XLr8 Resizer, and XLr8 Object Editor. These tools are downloaded with the XLr8 Editor and are currently available at no cost. U2logic Team --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What Flavor UV ?
At TCL enter - CT VOC RELLEVEL Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, October 26, 2006 11:15 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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 and any attachments are for the sole use of the intended recipient(s) and may contain privileged and confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail and destroy all copies of the original message. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What Flavor UV ?
Bill, From ECL/TCL do .RELLEVEL (DON'T FORGET THE DOT...) Cheers, Angelo Collazo System Administrator How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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] Somewhere other than HOLD
I am not exactly sure as this has been here for over 5 years and I've never had a need to look at it. The person who would know for sure, is on vacation this week. We have DEVICE called PRINT2FILE that uses a unix script. I'm pretty sure that is what drives it. Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, October 26, 2006 1:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Somewhere other than HOLD hmm. I've never used FORM xx with a directory. Does it require a special DEVICES entry? I'll have to play with this. Thanks George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Thursday, October 26, 2006 1:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Somewhere other than HOLD We do this here with the following. EXECUTE 'SETPTR ,132,60,4,0,1,BRIEF,FORM ACHFILE,NFMT,RETAIN,INFORM,BANNER UNIQUE ACH_RPT_':DATE() The form ACHFILE is the file we store this report in. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- 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] Somewhere other than HOLD
Don't know if this will help, but here is what I did to solve a similar problem in Unidata. The first step we took was to start using the BANNER UNIQUE (string) setptr option. Hopefully, that option is available in Universe. So, the setptr command would contain something like BANNER UNIQUE FRED or BANNER UNIQUE BARNEY. This causes the files in the _HOLD_ file to start with FRED or BARNEY. The rest of the _HOLD_ key is a sequential number, which is stored in the Dictionary of _HOLD_. The next step is to have a separate program that checks the _HOLD_ file every five minutes and takes some action, based on the filename. e.g., if it starts with FRED, do this. If it starts with BARNEY, do something else. Some other things that I tried, which did not work on Unidata, but may work on Universe: 1) Put a trigger on the _HOLD_ file. Unidata cannot do this, since _HOLD_ is a DIR type file. 2) Delete the _HOLD_ file and recreate it as a hashed file, which would allow a trigger to be used. Unidata really did not like this at all. hth Charlie Rubeor [EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/26/2006 11:49:59 AM: Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. 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] Somewhere other than HOLD
Or execute an OS command to move the file from HOLD to wherever you want it - then you don't actually have to open the other file Hth Colin Alfke Calgary Canada -Original Message- From: George Gallen on further reading...now, I see what your saying. Your right...bizarre. h. Once I have the entry name (which we have a subroutine to do), I might as well just do the READ/WRITE to the new file. George -Original Message- From: Kevin King This might be crossing the lines of the bizarre, but if you know your HOLD entry name, why not execute a OS-level command to put a symlink to it from another directory. The actual file doesn't move, but you have access to it from another directory. -Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What Flavor UV ? - Victory
Thanks George... .L RELLEVEL RELLEVEL 001 X 002 8.3.3.1 003 INFORMATION 004 INFORMATION.FORMAT Regards, --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, October 26, 2006 2:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What Flavor UV ? Does .L RELLEVEL still work? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, October 26, 2006 2:15 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] - Texas Sales Tax
Larry is right, logic has nothing to do with taxes. Strategically, I've found the best way to do tax calculations is to first assign codes to different tax types and then group these codes into a collection for a specific spot on a map (i.e. geocode). Certain areas will have city, county, state, transportation, education, or even just-for-the-sport-of-it tax types and the boundary of which tax types apply to a given area could be separated by a dirt road that doesn't even appear on a map. There are also tax rules for specific products being sold to specific areas or specific types of customers in specific areas and every combination of madness extended from there. Making matters worse, boundaries, tax rates, eligibility, exemptions, exceptions, etc. change at a moments notice. The coding of the calculation is itself not rocket science, but the collection of data to support those calculations is excessive even by government standards. For this reason products like Vertex that manage this mind-numbing minutae will always be needed in a country whose government severely obfuscates the obvious and then prosecutes for non-compliance. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] Terminal Cursor Control
I'm having one of those how do they do that moments. Several weeks ago we implemented the use of SYSTEM(4001)/SYSTEM(4002) to alter the UniVerse command prompt (as seen on the U2-Users Channel). As luck would have it we use vt220 emulation so in addition to being able to change the prompt I have made a ton of users very happy. They can now edit their command-line input using the arrow keys, etc., something we haven't been able to do since our migration to UniVerse from jBASE. Well, now I have embarked on a project to provide a secure command prompt to control access to commands, etc.. This of course means that anything I code will have to have the same command line editing functionality provided with the customized prompt or I will have to disappoint users a second time. (Something a smart IT professional should definitely avoid!) One behavior the custom prompt provides is for the backspace (destructive) and left arrow keys to wrap from the beginning of a second, or successive, line back to the prior input line. I have yet to discover how to accomplish that behavior in BASIC. CRT @(-9,1): successfully moves the cursor to the left until we reach column zero where it stops and will not wrap back up to the end of the line above. The UniVerse BASIC Commands Reference has this to say about @(-9)... --- Integer Equate Name Function Argument --- --- -- b9 IT$CUB Back space one character Number of characters to back space Back Space One Char @(IT$CUB) Moves the cursor one position to the left without deleting any data. For m greater than 0, the function @(IT$CUB, m) moves the cursor m positions to the left. In moving to the left, the cursor cannot move beyond the start of the line. --- I have perused a bunch of the source code in BP and APP.PROGS in the UV account to see if I could find any hints there but most everything is either based on INPUT @(X,Y) or raw character input using KEYIN(). I have no idea if the SYSTEM(4001/4002) input routine is implemented in BASIC or something else. Feels like I'm at a dead end. Anyone have any ideas? Thanks. Perry Taylor ZirMed 626 West Main St , 6th Floor b Louisville, KY 40202 www.zirmed.com http://www.zirmed.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] - Texas Sales Tax
Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. The software package we use has what they call tax jurisdictions. This makes the layered sales taxes like Texas easier. Each customer account can have up to 3 tax jurisdictions assigned. For example, one can be for the state portion, one for a county portion, a third for the city portion. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === A cynic is a person searching for an honest man with a stolen lantern. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Somewhere other than HOLD
a little too much for the small number of print jobs that will be affected. Looks like for now, I'll just create a subroutine that you pass the channel # and it will take it from there, first getting the setptr unique name, then moving it to the new file as well as removing the hold entry. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: Thursday, October 26, 2006 3:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Somewhere other than HOLD Don't know if this will help, but here is what I did to solve a similar problem in Unidata. The first step we took was to start using the BANNER UNIQUE (string) setptr option. Hopefully, that option is available in Universe. So, the setptr command would contain something like BANNER UNIQUE FRED or BANNER UNIQUE BARNEY. This causes the files in the _HOLD_ file to start with FRED or BARNEY. The rest of the _HOLD_ key is a sequential number, which is stored in the Dictionary of _HOLD_. The next step is to have a separate program that checks the _HOLD_ file every five minutes and takes some action, based on the filename. e.g., if it starts with FRED, do this. If it starts with BARNEY, do something else. Some other things that I tried, which did not work on Unidata, but may work on Universe: 1) Put a trigger on the _HOLD_ file. Unidata cannot do this, since _HOLD_ is a DIR type file. 2) Delete the _HOLD_ file and recreate it as a hashed file, which would allow a trigger to be used. Unidata really did not like this at all. hth Charlie Rubeor [EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/26/2006 11:49:59 AM: Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [OT] - Texas Sales Tax
you may want to talk to ROI, I believe they support the Vertex tax software www.roisyn.com Rich Caminiti, Marc wrote: This is totally off topic and apologize for this. Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. Thanks in advance Marc Marc Caminiti Nashbar Direct, Inc IS Manager Bike Nashbar 330.533.1989, ext 336 6103 State Route 446 330.702.9733, fax Canfield, OH 44406 [EMAIL PROTECTED] http://www.nashbar.com Computers make very fast, very accurate mistakes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Status of multiple active lists
Hi Folks, I need to be able to test for an active list when it's not cursor 0. In my program, I have an active list in 0 and I want to do another select to list 2. I then need to be able to find out if there was, indeed, records found for list 2 so I can do a save-list or whatever. Normally I'd use SYSTEM(11) but the documentation does not seem to specify which list it's reporting back for. I'd be happy if I could get a count of how many ID's are in list 2, too, but I can live without the count. TIA Bob Woodward Senior Programmer/Analyst Harbor Wholesale Grocery --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Status of multiple active lists
what does @SELECTED return? or does that only work with list 0? George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Thursday, October 26, 2006 4:14 PM To: U2-Users List Subject: [U2] Status of multiple active lists Hi Folks, I need to be able to test for an active list when it's not cursor 0. In my program, I have an active list in 0 and I want to do another select to list 2. I then need to be able to find out if there was, indeed, records found for list 2 so I can do a save-list or whatever. Normally I'd use SYSTEM(11) but the documentation does not seem to specify which list it's reporting back for. I'd be happy if I could get a count of how many ID's are in list 2, too, but I can live without the count. TIA Bob Woodward Senior Programmer/Analyst Harbor Wholesale Grocery --- 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] [OT] - Texas Sales Tax
There are probably lots of tax packages out there to do this. One that I was using (on a mainframe) was Vertex. I believe Vertex has software and databases for this. So, you basically call their routines with the proper parameters and they return the tax to you. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, October 26, 2006 2:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] - Texas Sales Tax This is totally off topic and apologize for this. Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. Thanks in advance Marc Marc Caminiti Nashbar Direct, Inc IS Manager Bike Nashbar 330.533.1989, ext 336 6103 State Route 446 330.702.9733, fax Canfield, OH 44406 [EMAIL PROTECTED] http://www.nashbar.com Computers make very fast, very accurate mistakes. --- 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] Status of multiple active lists
For lack of not knowing the right way. You could do something like; SELECT FILE SAVE.LIST TO 2 Sometime later do MERGE.LIST 2 UNION 2 TO 0 It should return the result of what is in select list 2. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, October 26, 2006 4:14 PM To: U2-Users List Subject: [U2] Status of multiple active lists Hi Folks, I need to be able to test for an active list when it's not cursor 0. In my program, I have an active list in 0 and I want to do another select to list 2. I then need to be able to find out if there was, indeed, records found for list 2 so I can do a save-list or whatever. Normally I'd use SYSTEM(11) but the documentation does not seem to specify which list it's reporting back for. I'd be happy if I could get a count of how many ID's are in list 2, too, but I can live without the count. TIA Bob Woodward Senior Programmer/Analyst Harbor Wholesale Grocery --- 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] [OT] - Texas Sales Tax
We interfaced to the Vertex package at a client in Tulsa, OK. The contact name was/is: Matt Dailey Account Executive, Tax Technology Vertex Inc. Where Taxation Meets Innovation T: 972.385.7409 F: 972.385.7219 M:972.567.5684 [EMAIL PROTECTED] Or Maybe Alice Carter Senior Training Coordinator Vertex Inc. Where Taxation Meets Innovation 1041 Old Cassatt Road Berwyn, PA 19312 Phone: 484.595.6224 Fax: 610.640.2761 [EMAIL PROTECTED] Website: www.vertexinc.com HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: Thursday, October 26, 2006 3:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] - Texas Sales Tax you may want to talk to ROI, I believe they support the Vertex tax software www.roisyn.com Rich Caminiti, Marc wrote: This is totally off topic and apologize for this. Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. Thanks in advance Marc Marc Caminiti Nashbar Direct, Inc IS Manager Bike Nashbar 330.533.1989, ext 336 6103 State Route 446 330.702.9733, fax Canfield, OH 44406 [EMAIL PROTECTED] http://www.nashbar.com Computers make very fast, very accurate mistakes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.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] Status of multiple active lists
SELECTINFO(n,1) will report whether Select List number n is active, and works in both UniData and UniVerse. SELECTINFO(n,3) will report the number of keys on Select List number n, but only in UniVerse. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Query calculating 120 days.
The point? Unnecessary additional complexity not affecting the outcome. :) My bad. Although I'm inclined to think that the fact the original poster is using a SQL query instead of a TCL query might be an indication that they are not in a position to be creating dictionary items. Oh, and I think Gordon's example is perfectly acceptable though not optimally self documenting. Remember that not everyone is living under your programing standards. Womack, Adrian wrote: A couple of points: Gordon's example: DATE()[EMAIL PROTECTED]6 should really be using a D-type named field instead of using @RECORDnn Jeff's example: DATE() - ICONV(*YOUR.DATE.FIELD.HERE*,D4/) - the date field should already be in internal format, so what's the point of the ICONV ? AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- == Jeff Schasny jschasnyATricochetDOTcom == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Terminal Cursor Control
From: Allen E. Elwood Sent: Thursday, October 26, 2006 2:38 PM ZIGGY=ZIGLIN Gotta respect someone who can pull off ZIGGY in a program. Not a commentary on right or wrong, I just found it interesting. I once interviewed at a place where the lead programmer named his variables using (c)rude terminology for intimate components of the female anatomy. Didn't take the job. Come to think of it, I didn't last 60 seconds after seeing that code. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Terminal Cursor Control
Feels like I'm at a dead end. Anyone have any ideas? Well... these sequences will move the cursor to a specific column on the current row. The examples exhibit moving the cursor to the left edge of the screen: PRINT CHAR(16):CHAR(0): PRINT @(-70,0): ...or... PRINT CHAR(8): ...goes left one char at a time (non-destructive on my terminals). If using wIntegrate: PRINT CHAR(27):CHAR(1):'Display at 0':CHAR(13): These sequences are non-destructive, so if your goal is to rub-out the char to the left, you'll either have to backup, then erase the current char (PRINT @(-22): might work for that), or back up, print a space, and backup again. Or, maybe someone will chime in with the 'right' way to do a destructive backup. I have a callable routine I could send to you, if you want (need your email). It is a fairly full-featured single line data entry with arrows, backspace, back/forward word, end, beginning etc. It might be overkill for your needs. Also, it has a dozen lines of wIntegrate-specific functionality which would have to be removed/replaced. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Terminal Cursor Control
One of those days. I was trying to think of a var to use, BUFFER seemed too dull, then the song 'Ziggy Stardust' came on. :) !!! It was just a playful moment. You can see all the rest of the vars, like UP, DOWN, etc. make plenty of sense, which was really important during dev. I also had a program that was to run every day one minute past Midnight. I was trying to figure out the name for that song when The Midnight Rider came onOUUUTO MUCH TO PASS UP! The name of the program became THE.MIDNIGHT.WRITER (Love puns) Oh yeah, did the victory dance big time. Female anatomy, phewwwman... I cannot imagine how fast he got fired the first time they hired a programess... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Thursday, October 26, 2006 15:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Terminal Cursor Control From: Allen E. Elwood Sent: Thursday, October 26, 2006 2:38 PM ZIGGY=ZIGLIN Gotta respect someone who can pull off ZIGGY in a program. Not a commentary on right or wrong, I just found it interesting. I once interviewed at a place where the lead programmer named his variables using (c)rude terminology for intimate components of the female anatomy. Didn't take the job. Come to think of it, I didn't last 60 seconds after seeing that code. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] Terminal Cursor Control
From: Allen E. Elwood Female anatomy, phewwwman... I cannot imagine how fast he got fired the first time they hired a programess... Not likely. His boss was a very nice lady who apparently had absolutely no control over what he did (for whatever reason, I didn't stay around long enough for details). Following the revelation I specifically mentioned to her how offensive that strategy was and she shrugged her shoulders and said oh well, what can you do? to which I shook her hand and thanked her for her time. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Somewhere other than HOLD
This may be more overhead than you want, but it's easy to use SETPTR mode 2 to print to a specific file 0001 * something you would do only once as part of installation 0002 EXECUTE 'CREATE-FILE ALT.HOLD 19' 0003 0004 PORT='HOLD':@USERNO ;* or something more unique like INVOICES 0005 ENTRYNAME=PORT ;* in case you want the file to have a different name from the PORT 0006 OPEN 'ALT.HOLD' TO ALT.HOLD ELSE STOP ;* your favorite error handling goes here 0007 HOLD.PATH=FILEINFO(ALT.HOLD,2) : '/' : ENTRYNAME 0008 WRITE '' ON ALT.HOLD,ENTRYNAME ;* the file needs to exist, and you want it to be empty to start 0009 0010 OPEN 'DEVICE' TO DEVICES ELSE STOP 0011 WRITE 'HOLD FOR PORT ':@USERNO : @AM : HOLD.PATH ON DEVICES,PORT 0012 0013 EXECUTE 'ASSIGN ':PORT:' TO LPTR 0' 0014 * the ASSIGN does an automatic SETPTR with default settings that you might want to change 0015 EXECUTE 'SETPTR 0,132,60,,,2,BRIEF' 0016 0017 * now print stuff. The assign also did an SP-OPEN, so everything goes to the same file 0018 EXECUTE BLOCK-PRINT HELLO 0019 EXECUTE LIST VOC LPTR 0020 EXECUTE BLOCK-PRINT GOODBYE 0021 0022 * and when you are done 0023 EXECUTE UNASSIGN :PORT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, October 26, 2006 11:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Somewhere other than HOLD Is there a way in UV to direct a printjob to another file besides HOLD using the SETPTR (more precisely the !SET.PTR command? I Just want to re-direct specific jobs, but keep HOLD My workaround is is READ/WRITE/DELETE the job from HOLD to where I want it after the job is completed. But I'd rather not have to open 2 more files if it can be done via the setptr. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. 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] Status of multiple active lists
Thanks Ray. I must have looked past that 3 times, at least. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Thursday, October 26, 2006 2:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Status of multiple active lists SELECTINFO(n,1) will report whether Select List number n is active, and works in both UniData and UniVerse. SELECTINFO(n,3) will report the number of keys on Select List number n, but only in UniVerse. --- 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] [OT] - Texas Sales Tax
Tom Dodds wrote: We interfaced to the Vertex package... There is a company called AdValorem which has an MV interface to Vertex, Taxware, and possibly other packages that specialize in identifying the right tax values among jurisdictions. See this link for contact info: http://www. removethisADVALOREM.us/index_files/Page508.htm The web pages look awful in IE6 but the info is readable. Someone please tell Stan - and tell him Tony sent you too. :) HTH Tony Gravagno Nebula RD TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/