RE: [U2] To Limit TCL Access Privilege

2005-10-27 Thread Ang Suan Yong
ohh ! yupp :) thanx > -Original Message- > From: Bruce Nichol [SMTP:[EMAIL PROTECTED] > Sent: Friday, 28 October, 2005 11:12 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] To Limit TCL Access Privilege > > At 10:31 28/10/05 +0800, you wrote: > > >Dear All > > > >

Re: [U2] To Limit TCL Access Privilege

2005-10-27 Thread Bruce Nichol
At 10:31 28/10/05 +0800, you wrote: Dear All I am trying to give some user to have privilege to access to uniVerse TCL level to do some listing but not using updating or deleting or files / data . Is there any idea to set such setting ? DELETE VOC ED DELETE VOC DELETE.FILE removes

[U2] To Limit TCL Access Privilege

2005-10-27 Thread Ang Suan Yong
Dear All I am trying to give some user to have privilege to access to uniVerse TCL level to do some listing but not using updating or deleting or files / data . Is there any idea to set such setting ? Thanks in Advance --- u2-users mailing list u2-users@listserver.u2ug.org To unsubsc

RE: [U2] Week of the year (UV)

2005-10-27 Thread Kevin King
But of course! :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill_H Sent: Thursday, October 27, 2005 4:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Week of the year (UV) Kevin: Sorry, I wasn't implying anything other than there is somew

RE: [U2] Week of the year (UV)

2005-10-27 Thread Bill_H
Kevin: Sorry, I wasn't implying anything other than there is somewhere where some have answered those questions. But you know how stardards are; everyone has one. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Thurs

RE: [U2][UV] UPS rate calculator

2005-10-27 Thread Paul Trebbien
We have a software product called 'Kourier Freight Control' that does all that online, it works in both the Windows and Unix environments. I support the DataFlo ERP package for most of our customers and have seen it there but do not know if our Freight Control product is being used on other ER

RE: [U2] Week of the year (UV)

2005-10-27 Thread Kevin King
Certainly the standard is applicable but only if the client is concerned about the definition of "week" according to ISO 8601. Some might, some might not. I was simply sharing some of the issues that have come up in the projects I've had for calculating the week number, of which I have had three

RE: [U2] [UD] how to find records with a " in the data

2005-10-27 Thread Rod Hills
I got the following to work under Universe 10.0.16- LIST VOC WITH F1 LIKE '0X"0X' Hope that helps Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson Sent: Thursday, October 27, 2005 12:21 PM To: u2-users@listserver.u2ug.org Subject:

RE: [U2] Week of the year (UV)

2005-10-27 Thread Bill_H
Kevin: Try looking in Google for "ISO 8601 week". It may help answer some of your questions. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Thursday, October 27, 2005 12:38 PM > To: u2-users@listserver.u2ug.org > Subject:

RE: [U2][UV] UPS rate calculator

2005-10-27 Thread Marilyn Hilb
Ditto. This is the same way we do it (other than we do the export after each shipment). I have worked with UPS now for two different companies to get an interface with their software. They worked very well with me and helped me accomplish my goals. Only side note I have to add, is I ended up

RE: [U2] Week of the year (UV)

2005-10-27 Thread Bill_H
Barry: This is what I use to meet the ISO Bill SUBROUTINE WEEKNO (DateIn, WeekOut) ** ** Notes: ** ** Passed Variables: **DateIn : Internal date representing week number desired **WeekOut : ISO 8601-formatted Week Number: ** ** ISO 8601 prescribes a format Wnn, where nn

RE: [U2] [UV] AIX COPY TO SAMBA DIRECTORY

2005-10-27 Thread Keith Johnson
Garry, I am not 100% on this but I think SAMBA does not really have anything to do with it. I have a VOC record that is named USR.LC.BIN Its data looks like so: F1 DIR F2 /usr/lc/bin/ F3 D_HOLD_ # I cheated here. Normally when you make a file/dir you make it in side of the db (and i

RE: [U2] Week of the year (UV)

2005-10-27 Thread Kevin King
Barry is right, the definition of "year" (beit "fiscal", "calendar" or some variant thereof) is one of several important facets of the problem that must be defined before formulating a solution. For some companies, January 1st is actually part of the last (52nd or 53rd) calendar week of the previ

RE: [U2] [UD] how to find records with a " in the data

2005-10-27 Thread Keith Johnson
Please post; I would like this information too. -Keith Johnson LCSC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko Sent: Wednesday, October 26, 2005 2:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] how to find records with a " i

RE: [U2] Week of the year (UV)

2005-10-27 Thread Barry Brevik
If I understand the question properly, I believe this will do it: PRINT INT(OCONV(DATE(),'DJ')/7) + OCONV((OCONV(DATE(),'DJ')/7:'')['.',2,1],"S;'1';'0'") ...but be aware that even though we think of a year as having 52 weeks, and a week is 7 days, 7 * 52 = 364. As far as I know, a year always

Re[2]: [U2][UV] UPS rate calculator

2005-10-27 Thread David Tod Sigafoos
Peter, thanks .. but as i noted we did the labeling bit (in universe). Worked well .. Thursday, October 27, 2005, 8:19:43 AM, you wrote: PG> I actually wrote the entire UPS host manifest system in Unidata. It is PG> integrated with our custom programs. We get a UPS label, Summary label, PG> tra

RE: [U2][UV] UPS rate calculator

2005-10-27 Thread George Gallen
I have found UPS tech support quite knowledgable in their software and integrating it with other software. We interface with World Ship using csv import/export tables and let the software do all the work, it imports the name and address and then exports the tracking numbers and amounts. We

RE: [U2][UV] UPS rate calculator

2005-10-27 Thread Brutzman, Bill
Consider contacting UPS tech support. I expect that there is a SQL/ODBC web thing with up-to-date rates etc. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] UPS rate calculator

2005-10-27 Thread George Gallen
One of the hardest things with UPS is they tack on extra charges at delivery time if it's a residence and you didn't know it, or if it's in a rural area where they don't normally travel to. So even if you get the rate the way you think it is, it could wind up being billed to you at a higher

Re: [U2][UV] UPS rate calculator

2005-10-27 Thread Peter Gonzalez
I actually wrote the entire UPS host manifest system in Unidata. It is integrated with our custom programs. We get a UPS label, Summary label, tracking details, summary reports and a file to send to UPS for billing. The only feature that we don't use is international service codes. We create o

RE: [U2] Week of the year (UV)

2005-10-27 Thread Louie Gouws
Howzit Bjorn Here is my program to do it: Louie *-- PROMPT '' 10* CRT 'Date to calc week number for : ':;INPUT DATE.INPUT ;* e.g 13/05/2005 IF DATE.INPUT='' THEN STOP *-- IDATE = ICONV(DATE.INPUT,'D') YEAR=OCONV(IDATE,'DY') MY.JULIAN.DATE=OCONV(IDATE,'DJ') *-- WEEK.NO=0 FIRS

Re: [U2][UV] UPS rate calculator

2005-10-27 Thread David Tod Sigafoos
JH> Has anyone directly integrated UPS's online shipping rate calculator JH> service and/or address verification with UV? Not the rate calculator but the USPS 'shipping label' process. It was pretty simple once we got on line and talked through our understanding of their documentation . -- DSi

Re: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread John Godzina
Jeffrey Butera wrote: On Thursday 27 October 2005 05:55, John Jenkins wrote: Alonzo This is not really a database issue but an application usage iseue, and a BASIC program or (on Unix) a check in the ,profile shell script is exactly the way to do this. We're on Unix and did this via

Re: [U2] non-uvBackup

2005-10-27 Thread Results
Jef, Exactly what I needed to know. I just diagnosed them with a disk controller failure and they may have to rebuild onto new disks. I'll see what their last good savevg looks like and see if we can't get a full uvbackup to cover the data issues. - Chuck Jef Lee wrote: Charles, Th

RE: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread Vance, Kathy
I am thinking a similar question. How do we know how many database connections opened by an application? Could we query a universe table or file to get the info of current active sessions? Thanks, Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of J

Re: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread Jeffrey Butera
On Thursday 27 October 2005 05:55, John Jenkins wrote: > Alonzo > > This is not really a database issue but an application usage iseue, and a > BASIC program or (on Unix) a check in the ,profile shell script is exactly > the way to do this. We're on Unix and did this via the .profile route - works

Re: [U2][UV] UPS rate calculator

2005-10-27 Thread Karjala Koponen
Is this something that can be done with the U2 SOAP API as written up by Nik Kesic of IBM at http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508kesic/ ? The link came from the U2UG site. Karjala >>> [EMAIL PROTECTED] 10/26/2005 7:35:49 PM >>> Has anyone directly integrated UP

RE: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread John Jenkins
Alonzo This is not really a database issue but an application usage iseue, and a BASIC program or (on Unix) a check in the ,profile shell script is exactly the way to do this. A BASIC program should work fine and I can't see why this is a problem - if you could post your source code we can take

Re: [U2] Week of the year (UV)

2005-10-27 Thread u2
[EMAIL PROTECTED] wrote: > Dows anybody know how to work out what week of the year you are in? Search the list archives - it's been discussed before. But if you need to know how, I'll give you a few tips. There's an oconv option which returns the "day of year" value, divide this by 7 to work out

[U2] UV How control number o concurrent sesions?

2005-10-27 Thread Augusto Alonso
Hi all. Someone knows how can i know the number of universe sessions a single user id has? Or even, there is some (hiden) parameter that allow limit the universe sessions a user can open simultaneusly? We have made a Basic program, but it not fit in all platforms. Any idea will be apreciated. R

[U2] Week of the year (UV)

2005-10-27 Thread Bjorn Behr
Dows anybody know how to work out what week of the year you are in? Regards Bjorn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/