Re: [U2] [uv]CREATE.FILE syntax for remote directories
CREATE.FILE, no. CREATE TABLE, yes. CREATE TABLE tablename DATA pathname DICT pathname ( column_definition_list and constraints ); --- 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...
What was the question? If I remember correctly it was about the best way to allocate sequential numbers for record ID's? Yes? Well here goes Start trasnactions Readu control record then record.ID = control record write record control record += 1 write control record end end transaction This seems to work for us. We do have loads of control records for generating ID and we never have any missing numbers. We have an internal audit department that goes around checking these things. Just had a quick check and there are 3140 users logged on to one of our systems and we don't have locking problems. Nice, neat and simple. If anything does go wrong then it is due to a major system problem, but we don't have them anymore!!! Les -Original Message- From: Bruce Nichol [mailto:[EMAIL PROTECTED] Sent: 14 June 2005 05:04 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... 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 options and then evolved in to SOX and auditors. Your offering came after that, so my (and, I assume, others) response was geared towards the latest level of the discussion. snip Now if you have something better, offer it up! The original poster wants options, so lend a hand instead of a finger. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Steve Johnson Sent: Monday, June 13, 2005 4:29 PM To: U2UG Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... 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 [snip] --- 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.0 - Release Date: 13/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/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.0 - Release Date: 13/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with @RECORD
Barry, @Record is primarily designed for interfacing with the query processor. As each record is processed, the id is written to @ID and the record body to @RECORD. You can then use these directly in I Descriptors when accessing specific functionality: E.g. MyPartKey 1 I Get the first two parts of the key 2 @ID[*,1,2] MyPartAddress 1 I Get last part of an address 2 @RECORD4,DCOUNT(@RECORD4,@VM) Etc. You can also use this in BASIC code if you want to run a ITYPE() function, along these lines: Read MyDictRec From MyDictFL, MyIDescriptor ... @ID = SomeId Read @Record From MyFL, @ID ... SomeValue = Itype(MyDictRec) Useful for dictionary driven routines e.g. export routines/screen runners etc. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: 14 June 2005 02:17 To: U2-users (E-mail) Subject: [U2] [UV] Help with @RECORD 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 'RECORD-ID' in 'A-VALID-FILENAME'. But having to directly reference @RECORD seems like it defeats the purpose of a 'default record'. Is there a RIGHT way to populate @RECORD? I've tried a number of ideas that did not work. It would also be cool if you could get TRANS() to populate @RECORD, but it does not seem to. Barry --- 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...
-Original Message- Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Come on, people. A request was made for options... Okay so here goes: Write a service application (e.g. Windows service app) in Delphi that maintains a table of sequence numbers. Ensure you use a critical section (semaphore or Mutex wrapper) to make the incrementing routine thread safe. Use the Socket API or SOAP API to request the next number from the service. Have a second routine to place a number back on the stack in the event of a rollback. .. Seriously, if you are going to use transactions I would guess the only way to avoid maintaining the key for the duration of the transaction (to go back to the original post) would be to take it out of the transaction space e.g. outside the database and provide the sort of pop/push sequencing already discussed in this thread. But then that might be overcomplicating matters.. :-) Brian --- 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...
Chuck, I've not worked with transactions, so I may be whizzing in the wind here. Could you call NEXT.AVAIL.ID before TRANSACTION START, and again after the transaction rollback, assuming you can detect if the transaction was rolled back? If the transaction committed, then no further action would be required. Charlie In a message dated 6/12/2005 3:46:58 PM Central Standard Time, [EMAIL PROTECTED] writes: 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/
[U2] [uv]CREATE.FILE syntax for remote directories
You can do a full-path CREATE.FILE with Unidata, but not with Universe. I have been hoping that might make it to the compatibility list. I didn't know you could do a UNIX command and get a uv-typed (perhaps hashed) file -- as Martin's suggestion. What I do is create it locally by EXECUTING CREATE.FILE, then EXECUTE a UNIX 'mv' to push it to the correct location and then write down the Fpointer. Susan Joslyn SJ+ Systems Associates, Inc. -- Date: Mon, 13 Jun 2005 10:41:58 +0200 From: Manu Fernandes [EMAIL PROTECTED] Subject: [U2] [uv]CREATE.FILE syntax for remote directories 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. -- Date: Mon, 13 Jun 2005 10:51:51 +0100 From: Martin Phillips [EMAIL PROTECTED] Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories 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 mkdbfile program) It is relatively easy to wrap a bit of Basic around this and build your own CREATE.PATH verb. 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/
RE: [U2] [UV] Help with @RECORD
@RECORD is used within basic in conjunction with the ITYPE function. If you wish to execute an I-Type dictionary entry within a Basic program and that I-Type accesses data, then the data must be present in the system variable @RECORD. You would have to open the file read the data item into @RECORD and then execute the I-Type. Help BASIC ITYPE for more and better explainations. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Monday, June 13, 2005 8:17 PM To: U2-users (E-mail) Subject: [U2] [UV] Help with @RECORD 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 'RECORD-ID' in 'A-VALID-FILENAME'. But having to directly reference @RECORD seems like it defeats the purpose of a 'default record'. Is there a RIGHT way to populate @RECORD? I've tried a number of ideas that did not work. It would also be cool if you could get TRANS() to populate @RECORD, but it does not seem to. Barry --- 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]CREATE.FILE syntax for remote directories
Susan, just an FYI, UniVerse does have a mkdbfile binary in the $uvhome/bin directory. I execute this to create sub-files from within my basic programs. I created a VOC entry for the binary: @ID = MKDBFILE @RECORD = V:@FM:mkdbfile:@FM:E:@FM:VF:@FM:@FM:PICK.FORMAT then From my BASIC program I can EXECUTE MKDBFILE /mp/MPLIVE/SY.WEBWORK/:@USERNO: 3 1301 4 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, June 14, 2005 7:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] [uv]CREATE.FILE syntax for remote directories You can do a full-path CREATE.FILE with Unidata, but not with Universe. I have been hoping that might make it to the compatibility list. I didn't know you could do a UNIX command and get a uv-typed (perhaps hashed) file -- as Martin's suggestion. What I do is create it locally by EXECUTING CREATE.FILE, then EXECUTE a UNIX 'mv' to push it to the correct location and then write down the Fpointer. Susan Joslyn SJ+ Systems Associates, Inc. -- Date: Mon, 13 Jun 2005 10:41:58 +0200 From: Manu Fernandes [EMAIL PROTECTED] Subject: [U2] [uv]CREATE.FILE syntax for remote directories 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. -- Date: Mon, 13 Jun 2005 10:51:51 +0100 From: Martin Phillips [EMAIL PROTECTED] Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories 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 mkdbfile program) It is relatively easy to wrap a bit of Basic around this and build your own CREATE.PATH verb. 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Spooler entry numbers in Universe (R%6)
We have process which normally produces reports in the evening, and assigns the resulting spooler entries to the user that launched the report via a chown. We have upgraded to version 10.1.6 on HP-UX 11i and now it seems that if the owner of a spooler is changed, the programs such as SP-EDIT can no longer see it. I think that when the spooler was modified to pad the spooler entry numbers on 6 digits instead of 5 it was also changed to take into account the owner of the spooler entry when it was created. Is there anyone here that can confirm ? __ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html --- 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...
Is the audit trail allowed to keep a sorted list of rollback numbers? Open a process Request a number ... If rollback Insert the number into the Rollback List Else save record Close process Or if the goal is to consume all sequential numbers. Open a process Request the lowest number from the Rollback List If none then Request a number ... If rollback Insert the number into the Rollback List Else save record Close process When audited, show the completed items and the rollback list for a complete set of numbers. David Morelli, UIS/Datatel Team -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, June 14, 2005 2:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... -Original Message- Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Come on, people. A request was made for options... Okay so here goes: Write a service application (e.g. Windows service app) in Delphi that maintains a table of sequence numbers. Ensure you use a critical section (semaphore or Mutex wrapper) to make the incrementing routine thread safe. Use the Socket API or SOAP API to request the next number from the service. Have a second routine to place a number back on the stack in the event of a rollback. .. Seriously, if you are going to use transactions I would guess the only way to avoid maintaining the key for the duration of the transaction (to go back to the original post) would be to take it out of the transaction space e.g. outside the database and provide the sort of pop/push sequencing already discussed in this thread. But then that might be overcomplicating matters.. :-) Brian --- 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] OFS experience anyone?
We have a situation where we will need to read/write to a DB2 database on AIX from UniData. Hopefully the new EDA facilities in version 7 will give us this but with this being new I'm a little concerned about whether to rely on it - as an alternative has anyone had any success with or thoughts to share about OFS? Regards, George Land Technical Director APT Solutions Limited www.aptsolutions.co.uk http://www.aptsolutions.co.uk --- 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...
Charlie: I wonder if the same issue (transactions don't release record locks until they're committed) applies to the LOCK/UNLOCK statement? Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 4:25 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/R... Chuck, I've not worked with transactions, so I may be whizzing in the wind here. Could you call NEXT.AVAIL.ID before TRANSACTION START, and again after the transaction rollback, assuming you can detect if the transaction was rolled back? If the transaction committed, then no further action would be required. Charlie In a message dated 6/12/2005 3:46:58 PM Central Standard Time, [EMAIL PROTECTED] writes: 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OFS experience anyone?
You could probably use BCI/ODBC. We had good luck writing to SQL server from unidata using BCI -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Tuesday, June 14, 2005 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] OFS experience anyone? We have a situation where we will need to read/write to a DB2 database on AIX from UniData. Hopefully the new EDA facilities in version 7 will give us this but with this being new I'm a little concerned about whether to rely on it - as an alternative has anyone had any success with or thoughts to share about OFS? Regards, George Land Technical Director APT Solutions Limited www.aptsolutions.co.uk http://www.aptsolutions.co.uk --- 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] Unidata in Fayetteville AR
Looking for Unidata Users in Fayetteville, AR area. Any out there. George R Smith Programmer / Analyst 479.684.3382 direct 479.684.3403 fax www.budgetext.com http://www.budgetext.com/ CONFIDENTIALITY NOTICE: The materials in this electronic mail transmission (including all attachments) are private and confidential and are the property of the sender. The information contained in the material is privileged and is intended only for the use of the named addressee(s). If you are not the intended addressee, be advised that any unauthorized disclosure, copying, distribution or the taking of any action in reliance on the contents of this material is strictly prohibited. If you received this electronic mail message in error, please immediately notify the sender by telephone at 888-869-0366 or send an electronic message to [EMAIL PROTECTED], and thereafter, destroy the electronic message immediately. [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVLICTOOL required often, why? {Unclassified}
Nothing specific then - worth checking if the sessions are REALLY getting closed at Windows level - check task manager. Otherwise - no real thoughts on this (nothing new there then ;-) Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
SV: [U2] [uv]CREATE.FILE syntax for remote directories
What would the syntax for a dynamic file look like ?? best regards from Denmark Claus Derlien -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] vegne af Lance Jahnke Sendt: 14. juni 2005 15:27 Til: u2-users@listserver.u2ug.org Emne: RE: [U2] [uv]CREATE.FILE syntax for remote directories Susan, just an FYI, UniVerse does have a mkdbfile binary in the $uvhome/bin directory. I execute this to create sub-files from within my basic programs. I created a VOC entry for the binary: @ID = MKDBFILE @RECORD = V:@FM:mkdbfile:@FM:E:@FM:VF:@FM:@FM:PICK.FORMAT then From my BASIC program I can EXECUTE MKDBFILE /mp/MPLIVE/SY.WEBWORK/:@USERNO: 3 1301 4 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] [UV] Help with @RECORD
Thanks for all the posts, everyone. I guess that clears it up. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ActiPro Syntax Editor control
I don't suppose anyone has a XML universe language specification for the ActiPro Syntax Editor control? Kieran. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/