Re: [U2] Trick for PartFiles and Indices

2006-10-26 Thread Anthony W. Youngman
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

[U2] Mark Shannon/Australia/IBM is out of the office.

2006-10-26 Thread Mark Shannon
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 ?

2006-10-26 Thread Brutzman, Bill
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

[U2] Somewhere other than HOLD

2006-10-26 Thread George Gallen
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

Re: [U2] New Account Setup - Copy VOC ?

2006-10-26 Thread Ron White
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.

Re: [U2] Somewhere other than HOLD

2006-10-26 Thread Allen Egerton
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

Re: [U2] New Account Setup - Copy VOC ?

2006-10-26 Thread Ray Wurlod
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread George Gallen
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread Brenda Price
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread 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 [EMAIL PROTECTED]

[U2] What Flavor UV ?

2006-10-26 Thread Brutzman, Bill
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 -

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread George Gallen
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread George Gallen
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:

RE: [U2] What Flavor UV ?

2006-10-26 Thread George Gallen
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

[U2] [OT] - Texas Sales Tax

2006-10-26 Thread Caminiti, Marc
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.

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: [U2] What Flavor UV ?

2006-10-26 Thread Deb Bruns
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

RE: [U2] What Flavor UV ?

2006-10-26 Thread Tom Dodds
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

[U2] [Ad] Free Web Developer

2006-10-26 Thread D Averch
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

RE: [U2] What Flavor UV ?

2006-10-26 Thread Rod Hills
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

RE: [U2] What Flavor UV ?

2006-10-26 Thread Angelo Collazo
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:

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread Brenda Price
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

Re: [U2] Somewhere other than HOLD

2006-10-26 Thread Charlie Rubeor
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread colin.alfke
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.

RE: [U2] What Flavor UV ? - Victory

2006-10-26 Thread Brutzman, Bill
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

RE: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Kevin King
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,

[U2][UV] Terminal Cursor Control

2006-10-26 Thread Perry Taylor
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

RE: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Norman Morgan
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread George Gallen
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

Re: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Richard A. Wilson
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

[U2] Status of multiple active lists

2006-10-26 Thread Bob Woodward
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

RE: [U2] Status of multiple active lists

2006-10-26 Thread George Gallen
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,

RE: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Anthony Dzikiewicz
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

RE: [U2] Status of multiple active lists

2006-10-26 Thread Anthony Dzikiewicz
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

RE: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Tom Dodds
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

RE: [U2] Status of multiple active lists

2006-10-26 Thread Ray Wurlod
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

Re: [U2] Query calculating 120 days.

2006-10-26 Thread Jeff Schasny
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

RE: [U2][UV] Terminal Cursor Control

2006-10-26 Thread Kevin King
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

RE: [U2][UV] Terminal Cursor Control

2006-10-26 Thread Barry Brevik
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

RE: [U2][UV] Terminal Cursor Control

2006-10-26 Thread Allen E. Elwood
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

RE: [U2][UV] Terminal Cursor Control

2006-10-26 Thread Kevin King
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

RE: [U2] Somewhere other than HOLD

2006-10-26 Thread u2
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

RE: [U2] Status of multiple active lists

2006-10-26 Thread Bob Woodward
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

RE: [U2] [OT] - Texas Sales Tax

2006-10-26 Thread Tony Gravagno
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.