[U2] [uv]CREATE.FILE syntax for remote directories

2005-06-13 Thread Manu Fernandes
Hi all, Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? To have files created into other directory like the current. Thanks for any suggestions. Manu Fernandes Infodata S.`r.l. --- u2-users mailing list

Re: [U2] [uv]CREATE.FILE syntax for remote directories

2005-06-13 Thread Martin Phillips
Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? No but the underlying operating system level program that does the CREATE.FILE can do this. /usr/uv/bin/mkdbfile pathname type modulo separation (with the appropriate path on the

RE: [U2] UVLICTOOL required often, why? {Unclassified}

2005-06-13 Thread Andy Moore
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee

[U2] Kyle Maurer/GR/US/BRAIN is out of the office.

2005-06-13 Thread Maurer, Kyle
I will be out of the office starting 06/13/2005 and will not return until 06/17/2005. I will respond to your message when I return. If you need immediate assistance please contact the hotline. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

[U2] CONVERT and number mangling

2005-06-13 Thread u2
Can any of the internals gurus help? I'm reading a comma-separated list of long numbers into a variable, then converting it into a dynamic array with CONVERT ',' TO @FM. I'm then processing the numbers, only to discover they're now corrupted! An example from a few days ago was .014386, which

RE: [U2] access via disabled accounts (solution) - How?

2005-06-13 Thread Richard Taylor
Not if you are using stored procedures (U2 basic subroutines) to do the file manipulation. Passing the record to the subroutine provides one layer of removal from the client program. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F

RE: [U2] Stuart Boydell is on annual leave.

2005-06-13 Thread Marilyn Hilb
Can this person be dropped from the list? I don't mind the away messages when you get just ONE but after getting.. what.. 5 in 24 hours.. this is getting aggravating even to me. Thanks, Marilyn A. Hilb Value Part, Inc Direct: 847-918-6099 Fax: 847-367-1892 [EMAIL PROTECTED] www.valuepart.com

RE: [U2] Stuart Boydell is on annual leave.

2005-06-13 Thread Andy Moore
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee

RE: [U2] Stuart Boydell is on annual leave.

2005-06-13 Thread Simon Carter
Just be glad he's only off for the one week :^) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb Sent: 13 June 2005 15:33 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Stuart Boydell is on annual leave. Can this person be

RE: [U2] Stuart Boydell is on annual leave.

2005-06-13 Thread Andy Moore
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee

[U2] UD - ODBC driver not available to Windows

2005-06-13 Thread Martin Scholl
I installed the ODBC driver from the client CD on a Windows XP and Server 2003 system and the drivers are not listed in the ODBC connection administrator in Windows. What is happening here? It used to work fine that the driver would show up so that I could configure a DSN. Martin Scholl

RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-13 Thread Bob Woodward
But his comments have generated a modification idea to my earlier suggestion. If, before the TRANSACTION START command, you get a next available ID then use that as a root value, you can then create a sequential number with an internal sequential number. IE: ROOT.KEY='' LOOP UNTIL ROOT.KEY

Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-13 Thread Steve Johnson
But this would not keep those pesky auditors happy. In the following sequence, how could they know that item 1*4 was missing? 1*1 1*2 1*3 2*1 etc. Regards, Steve Johnson FXA Group Ltd Bangkok Original message from Bob Woodward on 6/14/2005 12:39 AM: But his comments have generated a

[U2] [UV] Help with @RECORD

2005-06-13 Thread Barry Brevik
UV 9.6.1.3 on W2K. What's the right way to use @RECORD? I can do- OPEN '','A-VALID-FILENAME' THEN NULL ...after which @STDFIL is populated with the file handle. Then, I can do- READ @RECORD FROM 'RECORD-ID' THEN NULL ...after which @RECORD is a dynamic array of whatever corresponds to

RE: [U2] [UV] Help with @RECORD

2005-06-13 Thread Kevin King
I wouldn't use it except in the case of SUBR(...) type dictionaries. Then it's the main record being accessed in the query so you don't need to open the file and read the record. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Monday,

RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-13 Thread Bob Woodward
You're right, it would. Depending on the requirements, you could very easily create a log file of just the ROOT.KEY values that were rolled back and force an entry of a reason code, time/date stamp, user information, all kinds of stuff, but I think this solution gives the original requestor an

RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-13 Thread Bob Woodward
Come on, people. A request was made for options. I guess I wasn't real clear on the use of the *0 possibility. Use 1*0 to store the number of sub key parts, or use just a record with the main key part and no subpart. The task was how to not hold up everyone else with a sequential key counter

Re: [U2] [UV] Help with @RECORD

2005-06-13 Thread Bruce Nichol
Goo'day, Barry AFAIK, @RECORD is the data of the record being processed by an I-type function. Therefore you don't have to OPEN the file, or READ the @RECORD, eg: DICT FNAME COST 0001 I 0002 @RECORD3 * @RECORD5 0003 MR2.. etc, etc or DICT FNAME ANOTHER.COST 0001 I 0002

RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...

2005-06-13 Thread Bruce Nichol
Goo'day, Bob, At 19:44 13/06/05 -0700, you wrote: Come on, people. A request was made for options. I guess I'm one of those to whom you are referring. Please accept my abject apologies. However, in my defence, and in defence of those others, I'll add that the discourse started with