[U2] PhantomID, Unidata on Solaris
Hi, is there a nice way to capture the process ID for a phantom process? I would like to get the name of the file created in the _PH_ catalog when I start the phantom. TIA Bjvrn Eklund --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PhantomID, Unidata on Solaris
You can do it from basic 0001: CMD = 'PHANTOM bjorn' 0002: EXECUTE CMD CAPTURING RESULT RESULT will hold Phantom process started with process ID 442606. Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bjvrn Eklund Sent: 24 August 2004 10:19 To: [EMAIL PROTECTED] Subject: [U2] PhantomID, Unidata on Solaris Hi, is there a nice way to capture the process ID for a phantom process? I would like to get the name of the file created in the _PH_ catalog when I start the phantom. TIA Bjvrn Eklund --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
I believe the SAVING UNIQUE operating on a multivalued field treats the request as a BY.EXP request...thus giving you the value marks. You might want to try BSELECT to get just the individual keys: SELECT PERSON.ST 3152749 BSELECT PERSON.ST PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 [EMAIL PROTECTED] 8/23/2004 3:26:54 PM Hi all, Not a regular here but I was hoping someone could enlighten me with this interesting 'feature' of UNIDATA... If I issue a select statement using saving unique on a mv field of pointers, then edit the SAVEDLISTS file to check the IDs, I see something like this... SELECT PERSON.ST 3152749 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 AE SAVEDLISTS X.1000 001: 8654y1y1 002: 9490y2y1 003: 9491y3y1 (where 'y' is the value marker) Why is there y1y1, y2y1, y3y1 appended at the end of each ID? I'm guessing it has to do with the saving unique feature or something? To continue with the issue... SELECT PERSON.ST 3152750 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.2 001: 1443y1y1 002: 2904y2y1 003: 5128y3y1 004: 6743y4y1 LIST.ALGEBRA X.3 = X.1 + X.2 the system returns: SIZE OF X.1 IS 3 SIZE OF X.2 IS 4 SIZE OF X.3 IS 7 result is stored in 'X.3' GET.LIST X.3 21 records retrieved to list 0. LIST ROOM.ASSIGNMENTS 1443 2904 5128 6743 4 8654 9490 9491 8 records listed Enter CR to print non exist record ids 1 1 2 1 3 1 1 1 1 2 1 3 The LIST.ALGEBRA isn't ignoring what comes after the IDs and creates a savedlists with every value delimited by the value marker. I was expecting a total of 7 records (as indicated by LIST.ALGEBRA), when I do the GET.LIST X.3 there are 21 records. So first, what is the extraneous information at the end of each ID in the SAVEDLISTS? If I use a BSELECT instead I do not get this extra info. I am merely seeking more information with this whole thing... I was unaware that 'extra' information is stored when doing a SAVING UNIQUE and that using savedlists created with SAVING UNIQUE within LIST.ALGEBRA causes problems... or am I doing something wrong? I haven't found any documentation that denotes the above mentionned issue. Thanks for any feedback, Phil -- Philippe Parent - [EMAIL PROTECTED] Programmer Analyst, Administrative Information Services (ITS) University of New Brunswick PO Box 4400, Fredericton, NB, Canada, E3B 5A3 Phone (506) 453 3563 - Fax (506) 453 3590 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ Dave Rotman Director of Computer Services Cedarville University 251 N. Main Street Cedarville, OH 45314 [EMAIL PROTECTED] voice 937-766-7905 fax 937-766-8819 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
SV: [U2] PhantomID, Unidata on Solaris
Thank you Bob and Piers, the capture part works in this scenario and the ksh script with another problem I have. Great list this! Bjvrn Eklund -Ursprungligt meddelande- Fren: Piers Angliss [mailto:[EMAIL PROTECTED] Skickat: den 24 augusti 2004 12:41 Till: [EMAIL PROTECTED] Dmne: RE: [U2] PhantomID, Unidata on Solaris Bjorn, It depends how you start the Phantom. I have a shell script kicked off by cron every hour which maintains a rolling logfile of each invocation and where the details are held. Note this runs under Korn shell and it's not Solaris but the principle should be sound The script looks like udt !eof /dev/null 2 $LOGFILE PHANTOM RUN BP whatever QUIT !eof The output recorded in $LOGFILE (value varies) looks like PHANTOM process 6474 started. COMO file is '_PH_/f80064441403_6474'. Process 6474 completed at 11:30:04 on 24 AUG 2004 HTH, if you'd like more info contact me offline Piers --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Personal Edition
Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
it looks like PST.ROOM.ASSIGNMENT is multivalued and used for other things other then just storing the room# ??? what does the dict PST.ROOM.ASSIGNMENTS look like ? is it defining the entire attribute ? if you just want the 1'st value, create a dict item defining it and select saving unique new dict item This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
Date: 23 Aug 2004 16:26:54 -0300 From: Philippe Parent [EMAIL PROTECTED] ... (where 'y' is the value marker) Why is there y1y1, y2y1, y3y1 appended at the end of each ID? I'm guessing it has to do with the saving unique feature or something? ... So first, what is the extraneous information at the end of each ID in the SAVEDLISTS? ... The extra data is the attribute and value marks where the values were extracted. You can easily eliminate them by doing an EDIT-LIST (AE) and use the commands BD9/^253 followed by a C9/^253// If the data you're collecting are record IDs in a file, you can also select that file to get rid of the extra data. I suppose there's a good reason to keep the source info, but I wish there was a UDT.OPTION to turn it off... --Tom Pellitieri Century Equipment Toledo, OH --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Personal Edition
Dana I have the zips locally I will send them to your personal email Do you have a limit mailbox size ? Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: 24 August 2004 13:30 To: [EMAIL PROTECTED] Subject: [U2] Unidata Personal Edition Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .ex e
Jef, Thanks! That worked, however, the size of the .exe went from 28K to 16K when I compiled to P-Code. Does this mean the app will run slower? Faster? The Same? Thanks Ed -Original Message- From: Jef Lee [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 9:30 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe You may be experiencing a problem we had with VB6 in the executable. Try setting your project compilation to P-code. It makes a difference to the way the values are assigned to the dynamic arrays. Jef... IT Vision Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153 Tel: (08) 9315 7000 Fax: (08) 9315 7088 P O Box 881, Canning Bridge, WA 6153 A.C.N. 068 914 867 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Tuesday, August 24, 2004 2:32 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe The issue is why does it work fine in design mode and blow up when it's an executable? It looks like the + sign is acting like a plus sign in design mode, but acting like an ampersand ( string-concatenation) when run as an .exe. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 1:23 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe Have you tried a CInt around the dArray.Value(2,1). I'm guessing that the dynamic array object stores everything as strings or variants. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 23 August 2004 17:18 To: '[EMAIL PROTECTED]' Subject: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe Please give me your advice. For example: - Dim iNumber as Integer Dim dArray As UniDynArray Set dArray = New UniDynArray 10: dArray.Value(1,1) = Some String 40: dArray.Value(2,1) = 50 70: dArray.Value(2,1) = dArray.Value(2,1) + 25 90: iNumber = dArray.Value(2,1) -- This is a silly example, but it illustrates the problem that I am experiencing. Then I run this in the design environment, it runs fine. When I create an .exe and run it, it bombs on line 90 with an Type Mismatch error (error 13). What am I doing wrong? Has anyone else experienced this? UniData 5.2 UniObjects 5.2 VB 6.0 SP5 uniobjects.dll (236KB) is version 3.1.3.1084 (product version 3.1.2) and is dated 12/11/2001 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata Personal Edition
I just went thru the steps myself to test. PE download seems to be functioning fine at the moment. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Dana Baron [EMAIL PROTECTED] m To Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata Personal Edition 08/24/2004 06:29 AM Please respond to u2-users Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic06017.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Personal Edition
Thanks Wally and Bob, I tried it again today and it worked. (I swear it didn't work (twice) last Friday). Anyway, I have it now. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Tuesday, August 24, 2004 9:45 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Unidata Personal Edition I just went thru the steps myself to test. PE download seems to be functioning fine at the moment. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Dana Baron [EMAIL PROTECTED] m To Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata Personal Edition 08/24/2004 06:29 AM Please respond to u2-users Hi, This should be a simple question: how do I download UDPE? I went to the IBM website where I was informed that I could download UDPE, but I found no link and no instructions. On the TechConnect site I found a form to fill out to download UDPE. I filled out the form - twice - and still I did not get a link or instructions for download. I followed this up with a question in the Feedback area. I got a reply: Someone will get back to you shortly. That was five days ago. Hopefully someone on this list can point me in the right direction. Thanks Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic06017.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
Yeah, the BSELECT works, I'm using it as an alternative... I just like to ensure to remove duplicates too which is why I was using SAVING UNIQUE. I was just wondering why the value marks... And the thing is that its only when using LIST.ALGEBRA that I found a problem with this. If you just do a plain LIST on the table from the active select list you don't get this problem when using SAVING UNIQUE. ps/ Another way to get rid of the value marks is to do the following... SELECT PERSON.ST 3152750 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SELECT ROOM.ASSIGNMENTS * this removes the extra data SAVE.LIST X.1 fascinating stuff... Thanks for all the feedback, Phil On Tue, 2004-08-24 at 09:03, David L. Rotman wrote: I believe the SAVING UNIQUE operating on a multivalued field treats the request as a BY.EXP request...thus giving you the value marks. You might want to try BSELECT to get just the individual keys: SELECT PERSON.ST 3152749 BSELECT PERSON.ST PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 [EMAIL PROTECTED] 8/23/2004 3:26:54 PM Hi all, Not a regular here but I was hoping someone could enlighten me with this interesting 'feature' of UNIDATA... If I issue a select statement using saving unique on a mv field of pointers, then edit the SAVEDLISTS file to check the IDs, I see something like this... SELECT PERSON.ST 3152749 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.1 AE SAVEDLISTS X.1000 001: 8654y1y1 002: 9490y2y1 003: 9491y3y1 (where 'y' is the value marker) Why is there y1y1, y2y1, y3y1 appended at the end of each ID? I'm guessing it has to do with the saving unique feature or something? To continue with the issue... SELECT PERSON.ST 3152750 SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST X.2 001: 1443y1y1 002: 2904y2y1 003: 5128y3y1 004: 6743y4y1 LIST.ALGEBRA X.3 = X.1 + X.2 the system returns: SIZE OF X.1 IS 3 SIZE OF X.2 IS 4 SIZE OF X.3 IS 7 result is stored in 'X.3' GET.LIST X.3 21 records retrieved to list 0. LIST ROOM.ASSIGNMENTS 1443 2904 5128 6743 4 8654 9490 9491 8 records listed Enter CR to print non exist record ids 1 1 2 1 3 1 1 1 1 2 1 3 The LIST.ALGEBRA isn't ignoring what comes after the IDs and creates a savedlists with every value delimited by the value marker. I was expecting a total of 7 records (as indicated by LIST.ALGEBRA), when I do the GET.LIST X.3 there are 21 records. So first, what is the extraneous information at the end of each ID in the SAVEDLISTS? If I use a BSELECT instead I do not get this extra info. I am merely seeking more information with this whole thing... I was unaware that 'extra' information is stored when doing a SAVING UNIQUE and that using savedlists created with SAVING UNIQUE within LIST.ALGEBRA causes problems... or am I doing something wrong? I haven't found any documentation that denotes the above mentionned issue. Thanks for any feedback, Phil -- Philippe Parent - [EMAIL PROTECTED] Programmer Analyst, Administrative Information Services (ITS) University of New Brunswick PO Box 4400, Fredericton, NB, Canada, E3B 5A3 Phone (506) 453 3563 - Fax (506) 453 3590 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
I love learning new things! I had never thought that MV ID were treated this way by a savedlists. I can duplicate Philippe's results as he is using a common UniData application. PST.ROOM.ASSIGNMENTS is a MV field. SELECT PERSON.ST '0044560' SELECT PERSON.ST SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP000 001: 1606}2}1 002: 31}1}1 003: 3604}3}1 As Tom said doing a selection on the file the secondary IDs point to will strip the extra values. GET.LIST DWM.TEMP SELECT ROOM.ASSIGNMENT SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP 001: 1606 002: 31 003: 3604 Two more things I learned A: SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP000 001: 0044560}2}1 002: 0044560}1}1 003: 0044560}3}1 B: SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS LIST ROOM.ASSIGNMENT Gives an error message, Unable to find dictionary item for 35 SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS So, where does the savedlist store the information that the records stored in the list are associated with the field PST.ROOM.ASSIGNMENTS? David Morelli, UIS/Datatel Team -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 5:55 AM To: [EMAIL PROTECTED] Subject: Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA Date: 23 Aug 2004 16:26:54 -0300 From: Philippe Parent [EMAIL PROTECTED] ... (where 'y' is the value marker) Why is there y1y1, y2y1, y3y1 appended at the end of each ID? I'm guessing it has to do with the saving unique feature or something? ... So first, what is the extraneous information at the end of each ID in the SAVEDLISTS? ... The extra data is the attribute and value marks where the values were extracted. You can easily eliminate them by doing an EDIT-LIST (AE) and use the commands BD9/^253 followed by a C9/^253// If the data you're collecting are record IDs in a file, you can also select that file to get rid of the extra data. I suppose there's a good reason to keep the source info, but I wish there was a UDT.OPTION to turn it off... --Tom Pellitieri Century Equipment Toledo, OH --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] File Types...
I'm now working some with UniVerse - the mystical side of the U2 family... I never knew how easy we have it in UniData!! I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - you have to have 3 LIKES to (AAA..., ...AAA..., ...AAA) to do the same it appears... COPY is really wicked - and don't start me on the editor - at least this version of UV has a beta AE, otherwise I'd be seriously lost!! But that's not what I'm here for I've just gone through two different UV documents - both of which tell me I need to choose a type from 2 to 18 for a Hashed File, but neither tells me WHAT 2 through 18 do or why I need to choose one or the other of those 17 types... I need to create a small (5 record) code file -- each record will be 50 bytes max. It doesn't really matter what type I choose, really, but I thought this would be a good time to learn the UV 'File Types' - but I can't find where they are documented!! Been through: Administering UniVerse, Version 10.1 (G251-1905-00) UniVerse System Description V 10.1 (G251-1927-00) These are some seriously big books to never even touch what the different types do or mean!! Thanks for any pointers to the right docs - I hate spending 5 minutes downloading a doc, scouring it and then finding nothing! David Wolverton --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DIR Function
Hi Al, Are you getting a Unidata error message? If so, which one? There's the UniBasic DIR function and the Windows-level dir command, which work quite differently. The UniBasic DIR function works file-by-file, so it expects you to specify the full path to _HOLD_ and the hold file name. Simon from tcosoftware posted this great code snippet on July 29th: For a Unidata specific version of this use FILEINFO() and DIR() ie: OPEN _HOLD_ TO fp ELSE xxx FILE.PATH=FILEINFO(fp,2):/:HOLD.ITEM ;* forward slash is OK on NT DATE.MODIFIED=DIR(FILE.PATH)2 I just got Simon's example to work beautifully with _HOLD_ on UD 5.1 on Unix. Although his comment says the forward slash is OK on NT, you may need to change the forward slash in the FILE.PATH= line to a backslash \. Otherwise, I'll bet you'll have both kinds of slashes in your full path, which might give indigestion to the DIR function. From TCL, HELP DIR has more info and another helpful example. I think Wendy's referring to the Windows-level dir command, which you could use to retrieve the file names of all the hold entries in _HOLD_. Again, you'll need to specify the full path which is returned by the FILEINFO( ) function, or find it in attribute 2 of VOC _HOLD_. From a Windows command prompt, dir /? | more will describe all the options. Hope this helps, Tom [EMAIL PROTECTED] 08/23/04 7:23 PM Al DeWitt [How to find] the Date Modified of a W2K UniData file. Folks responded to use the DIR command. It worked great except it won't work for files in the _HOLD_ folder. snip I don't recall the original thread so I may be off base, but if you're just looking for the last modified file within _HOLD_, you can use switches with DIR to sort the files. DIR /OD will give you all the files in date order, oldest first. Look at the date of the last file listed, and that's the equivalent of when the _HOLD_ file was modified. HELP DIR for more info, you can reverse the order, for example. - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] File Types...
Horses to courses really. I like the flexibility to be able to specify where my AAA reside in a string. Copy and the editor are very Prime INFORMATION like which as everyone knows was the best Pick like system :). The information about file types is on page 6-35 of the Universe 10.1 system description manual (sysdesc.pdf). Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 24 August 2004 17:02 To: [EMAIL PROTECTED] Subject: [U2] [UV] File Types... I'm now working some with UniVerse - the mystical side of the U2 family... I never knew how easy we have it in UniData!! I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - you have to have 3 LIKES to (AAA..., ...AAA..., ...AAA) to do the same it appears... COPY is really wicked - and don't start me on the editor - at least this version of UV has a beta AE, otherwise I'd be seriously lost!! But that's not what I'm here for I've just gone through two different UV documents - both of which tell me I need to choose a type from 2 to 18 for a Hashed File, but neither tells me WHAT 2 through 18 do or why I need to choose one or the other of those 17 types... I need to create a small (5 record) code file -- each record will be 50 bytes max. It doesn't really matter what type I choose, really, but I thought this would be a good time to learn the UV 'File Types' - but I can't find where they are documented!! Been through: Administering UniVerse, Version 10.1 (G251-1905-00) UniVerse System Description V 10.1 (G251-1927-00) These are some seriously big books to never even touch what the different types do or mean!! Thanks for any pointers to the right docs - I hate spending 5 minutes downloading a doc, scouring it and then finding nothing! David Wolverton --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] The Learning Curve Continues!!
I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] The Learning Curve Continues!!
EVERY is a keyword in Universe that will do what you want. From HELP EVERY. | |Use in a selection expression to select a record only if every | |value in a multivalued field meets the specified condition. | |EVERY must be used with the WITH keyword. For example: | | | | LIST INVENTORY WITH EVERY ITEM EQ 'PAPER' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 24 August 2004 17:29 To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] The Learning Curve Continues!!
1) Quotes work fine with LIKE. Try LIST VOC WITH @ID LIKE ...X... to see the result. 2) File Types and reasons for them (2 through 8) - easiest way to get quick list of the intent of each file type is to type CREATE.FILE XXX and type ? for help at the File Type prompt. 3) EVERY is listed in the VOC as a K-type, meaning it is a keyword. If you type HELP EVERY at TCL, you do get a help entry for this keyword. May I suggest that the two flavors are different, that each has its strengths and weaknesses, and the one you're learning always seems worse than the one you know. ;^) -- James -Original Message- From: David Wolverton [EMAIL PROTECTED] Sent: Aug 24, 2004 9:29 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA
Disregard if this doesn't answer the pertinent question. To save all unique pointers to ROOM.ASSIGNMENT from PST.ROOM.ASSIGNMENTS: SELECT PERSON.ST BY.EXP PST.ROOM.ASSIGNMENTS SELECT PERSON.ST REQUIRE.SELECT SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST UNIQUE.ROOM.ASSIGNMENT.IDS This should produce a SAVEDLISTS record with one ROOM.ASSIGNMENT.ID per attribute. -Original Message- From: Philippe Parent [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 9:48 AM To: [EMAIL PROTECTED] Subject: RE: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA I checked the dict and AE'd a few records and it only contains ROOM.ASSIGNMENT IDs. The saving unique seems to be placing the extra info... Phil --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: [UV] File Types...
If you visit my website and take a look at the article entitled: *File types _http://members.aol.com/_ht_a/mbtpublish/mmf27.html_ (http://members.aol.com/_ht_a/mbtpublish/mmf27.html) you might find something of interest If you want to add, elaborate any entries at any of my websites, or make any suggestions for information that you would like to see there, please email me directly Regards Malcolm Bull If you have difficulty reaching my by email at AOL, please try: [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) Remember the websites: + Books training courses for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtraining/index.html_ (http://members.aol.com/_ht_a/mbtraining/index.html) + Our series of MB-Master Self-Tuition Courses for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtraining/mbslist.html_ (http://member s.aol.com/_ht_a/mbtraining/mbslist.html) + Our This is ... series of Books for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtraining/thisis.html_ (http://members.aol.com/_ht_a/mbtraining/thisis.html) + PDF versions of our Books MB-Master Self-Tuition courses for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtraining/pdf.html_ (http://members.aol.com/_ht_a/mbtraining/pdf.html) + MB-Cyclopfdia for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtpublish/index.html_ (http://members.aol.com/_ht_a/mbtpublish/index.html) + MB-OnLine Publications for users of Pick MultiValue systems: _http://members.aol.com/_ht_a/mbtexts/index.html_ (http://members.aol.com/_ht_a/mbtexts/index.html) + Our SB+ Reference Pages: _http://members.aol.com/_ht_a/mbtpublish/sbplus.html_ (http://members.aol.com/_ht_a/mbtpublish/sbplus.html) + The general Directory to our Training Consultancy services: _http://members.aol.com/_ht_a/mbtraining/directry.html_ (http://members.aol.com/_ht_a/mbtraining/directry.html) + Request a No-Obligations Quotation for our Training Products Publications: _http://members.aol.com/_ht_a/mbtraining/proform.html_ (http://members.aol.com/_ht_a/mbtraining/proform.html) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] The Learning Curve Continues!!
SELECT FILE WITH EVERY MULTIVALUE.ATTB UNLIKE ...DOG... - Original Message - From: David Wolverton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 12:29 pm Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File Types...
SELECT FILE WITH A LIKE ...AAA... - Original Message - From: David Wolverton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 12:02 pm Subject: [U2] [UV] File Types... I'm now working some with UniVerse - the mystical side of the U2 family... I never knew how easy we have it in UniData!! I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - you have to have 3 LIKES to (AAA..., ...AAA..., ...AAA) to do the same it appears... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Clearing a Sequential File:
I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Accuterm Email
Note that using MS Outlook 2003 this may not work. Microsoft has secured the ability of using scripts or the MS outlook objects to blindly send emails form a client's PC. It WILL prompt the user that a 3rd party application is attempting to use Outlook and if the program is reading the address book at all. The user needs to click a Yes on the message box to allow the email to be sent. It's nice that MS is finally clamping down on security issues such as these, but it makes our lives a little harder. Using CDO to access the target mail server directly and deliver the mail is still the best option, however it requires a guaranteed connection to the internet from the originating PC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, August 20, 2004 8:04 AM To: [EMAIL PROTECTED] Subject: [U2] Accuterm Email To all who care or replied to my questions about Wintegrate and/or Accuterm automatic email. Accuterm does have automatic email. In fact, they have 3. Like the Wintegrate program WIN.MLSEND, Accuterm has AT.SEND.EMAIL.OUTLOOK, AT.SEND.EMAIL.COA and AT.SEND.EMAIL.MAPI all available from their website. Basically these programs generate a VB script that Accuterm 2002 processes using the local email client. I used the MAPI version because this client has a mixed bag of Outlook and Outlook express. I cut and pasted their code, compiled and away it goes. The site is www.asent.com/email_white_paper.htm or www.asent/email_white_paper2.htm If I have the sites wrong, start at www.asent.com and find them under support. Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File Types...
David Wolverton wrote: I'm now working some with UniVerse - the mystical side of the U2 family... I never knew how easy we have it in UniData!! I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - you have to have 3 LIKES to (AAA..., ...AAA..., ...AAA) to do the same it appears... That's not really true. In universe I can say SELECT FILE WITH A LIKE ...AAA... and it finds all three AAA123 123AAA456 123AAA all with the one statement. -Dianne --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Clearing a Sequential File:
In Universe there is a command called WEOFSEQ which will do that. (HELP BASIC WEOFSEQ) -Dianne Ron Moore wrote: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Dianne Ackerman Director, Application Development Support Aptron Corporation 973/822-0700, ext. 105 FAX 973/822-3234 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Clearing a Sequential File
A sequential file within the program bycan by truncating the file before writing to it. This is accomplished by using the WEOFSEQ filevariable statement after the OPENSEQ and before the first WRITESEQ. Hope that helps! -- James --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] The Learning Curve Continues!!
Ya know I don't know what I was typing before to get the error --- but I type the EVERY command now (after a nice lunch) and it works just like it does in UniData... I suspect the issue is my attitude!! I probably made a simple typo and immediately ASSumed it was a difference in UniVerse versus UniData... Be gentle with me while I make this transition... I'm sure I will make several stupid posts between now and NerdNirvana... :-) David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, August 24, 2004 11:43 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] The Learning Curve Continues!! EVERY is a keyword in Universe that will do what you want. From HELP EVERY. | |Use in a selection expression to select a record only if every | |value in a multivalued field meets the specified condition. | |EVERY must be used with the WITH keyword. For example: | | | | LIST INVENTORY WITH EVERY ITEM EQ 'PAPER' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 24 August 2004 17:29 To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
There are a number of approaches to this. If you're on a *nix platform, you could rm and touch the file you want and that'll create the null file. On Windows you can do a similar thing, but of course the OS verbs are different. I use a cross-platform approach that doesn't use OS verbs at all. First, open the directory file as a regular file. Use DELETE to remove the old item. Then, when writing to the file, on the first output just WRITE it to the DIR file under the sequential name. Then open the sequential item and WRITESEQ to it thereafter. This is a bit more complicated than other approaches, but if you WRITE '' ON dirfile,name at the start (which is the most common variant of the technique) you'll get a blank first line. If you don't mind that blank first line, then that may be an easier way to go. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Clearing a Sequential File:
Maybe this isn't correct, but I usually just do the following command (Unix): echo '' SEQFILE Karl On Tue, 2004-08-24 at 11:40, Ron Moore wrote: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Clearing a Sequential File:
weofseq - Original Message - From: Ron Moore [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 01:40 pm Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Security
Look at OpenSSL. You can use the -a switch to base64 encode/decode the binary encrypted blob. I'm using that right now for DES3 credit card data on D3. http://picksource.com/modules.php?name=Newsfile=articlesid=97mode=thread; order=1thold=0 Glen aka PickCoder http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Gisi Sent: Tuesday, August 24, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: [U2] Data Security I understand from IBM that there is a problem storing Encrypted data in a Unidata database because some of the Encrytpion characters are in conflict with our restrictive characters Multi-values ,Sub-values and others. So how is this issue being resolved in the user community? Please feel free to email me directly since I am aware this is a sensitive subject. I have an urgent need of a resolution . --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Security
READ and WRITE will still work with all chars. The problem you would have would be that you will not be able to access any of the data via dynamic record methods. In other words, instead of saying REC5,1 which would access the 1st value of attr 5, you'll need to find the length of the record and proceed byte by byte looking for a byte or bit sequence that will indicate you've found the end of a field and then pull that out with REC[STARTING.BYTE,NUMBER.OF.BYTES.TO.PULL] or something like that. I've had to do this with COBOL records sent to me from another server in the past. Loads of fun. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Gisi Sent: Tuesday, August 24, 2004 10:38 To: [EMAIL PROTECTED] Subject: [U2] Data Security I understand from IBM that there is a problem storing Encrypted data in a Unidata database because some of the Encrytpion characters are in conflict with our restrictive characters Multi-values ,Sub-values and others. So how is this issue being resolved in the user community? Please feel free to email me directly since I am aware this is a sensitive subject. I have an urgent need of a resolution . --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
Thanks Dianne, works like a charm. Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Tuesday, August 24, 2004 1:53 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Clearing a Sequential File: In Universe there is a command called WEOFSEQ which will do that. (HELP BASIC WEOFSEQ) -Dianne Ron Moore wrote: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Dianne Ackerman Director, Application Development Support Aptron Corporation 973/822-0700, ext. 105 FAX 973/822-3234 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV on HP-Ux, Itanium 2
UnOfficial good news... IBM has certified UV on... HP/UX 11.23 aka 11i v2. --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
If you do a WEOFSEQ after all your WRITESEQs, the file will be truncated at that point. Something like this: OPENSEQ 'path/filename' TO F.SEQ ... * pointer is at beginning of file LOOP WHILE STUFF.TO.WRITE DO WRITESEQ STUFF.TO.WRITE ON F.SEQ ELSE ... REPEAT WEOFSEQ F.SEQ ... This insures that even if what you're writing this time is fewer 'lines' than last time, the file will not contain any leftovers at the end. Richard B. Lewis Sr. Software Engineer Dynix r l e w i s at d y n I x dot c o m www.dynix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
Sequential and dynamic access are defined by the way the file is opened. So you can always do a : EXECUTE 'CLEAR-FILE GODZILLA' before opening the file and it will be clear. I've done this in U2 - don't know about UV or native Pick. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 10:41 To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Clearing a Sequential File:
I like, OPENSEQ 'whatever,'recid' TO SEQFILE THEN WEOFSEQ SEQFILE END Bruce M Neylon Health Care Management Group Ron Moore [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/24/2004 01:40 PM Please respond to u2-users To: [EMAIL PROTECTED] cc: Subject:[U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
Thanks for the idea, Kevin. I'll keep that in mind for future work. Unfortunately, I can't live with the blank line. Some specs get 'set in stone' early in the project. Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Tuesday, August 24, 2004 2:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Clearing a Sequential File: There are a number of approaches to this. If you're on a *nix platform, you could rm and touch the file you want and that'll create the null file. On Windows you can do a similar thing, but of course the OS verbs are different. I use a cross-platform approach that doesn't use OS verbs at all. First, open the directory file as a regular file. Use DELETE to remove the old item. Then, when writing to the file, on the first output just WRITE it to the DIR file under the sequential name. Then open the sequential item and WRITESEQ to it thereafter. This is a bit more complicated than other approaches, but if you WRITE '' ON dirfile,name at the start (which is the most common variant of the technique) you'll get a blank first line. If you don't mind that blank first line, then that may be an easier way to go. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV]Print Error
I am using uniVerse on Unix and having a problem appearing suddenly. Program PRINT.REPORT: Line 147, Queuing disabled for requested printer. I am just trying to print a variable, after PRINTER ON. PRINTER ON PRINT variable PRINTER OFF How should I resolve it?? Wade. _ Express yourself with cool new emoticons http://www.msn.co.uk/specials/myemo --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File Types...
You might also want to search the list archives at www.indexinfocus.com. Ben Rosenberg posted some interesting observations about file types just a week or two ago along with a technique to quickly test them against your particular key space. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Aug 24, 2004, at 9:51, David Wolverton wrote: Thanks muchly!! I'll go there directly. And it's just like anything - the curve is at the steepest when you're at the bottom of it!! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Clearing a Sequential File:
I tested the WEOFSEQ on UD6 and it works real well, but I seem to remember on earlier versions of Unidata you had to have the record there before you could OPENSEQ. Or perhaps this was UV? I just tested this and on my UD6 you can OPENSEQ a non-existant item and it creates the new record, so you wouldn't have to go through all these hoops if you're UD6. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 1:31 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Clearing a Sequential File: Thanks for the idea, Kevin. I'll keep that in mind for future work. Unfortunately, I can't live with the blank line. Some specs get 'set in stone' early in the project. Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Tuesday, August 24, 2004 2:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Clearing a Sequential File: There are a number of approaches to this. If you're on a *nix platform, you could rm and touch the file you want and that'll create the null file. On Windows you can do a similar thing, but of course the OS verbs are different. I use a cross-platform approach that doesn't use OS verbs at all. First, open the directory file as a regular file. Use DELETE to remove the old item. Then, when writing to the file, on the first output just WRITE it to the DIR file under the sequential name. Then open the sequential item and WRITESEQ to it thereafter. This is a bit more complicated than other approaches, but if you WRITE '' ON dirfile,name at the start (which is the most common variant of the technique) you'll get a blank first line. If you don't mind that blank first line, then that may be an easier way to go. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Moore Sent: Tuesday, August 24, 2004 11:41 AM To: [EMAIL PROTECTED] Subject: [U2] Clearing a Sequential File: I am able to OPENSEQ and WRITESEQ for a sequential file, and need to clear the records or data before writing to this file. I have tried CLEAR and CLEARFILE, but may not have the correct syntax. How do I go about this? TIA, as always. Ron --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV on HP-Ux, Itanium 2
This was not a certification of an existing binary, but a new port on a new platform. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Brutzman, Bill [EMAIL PROTECTED] ft.comTo Sent by: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED] stserver.u2ug.org cc Subject 08/24/2004 12:57 [U2] UV on HP-Ux, Itanium 2 PM Please respond to u2-users UnOfficial good news... IBM has certified UV on... HP/UX 11.23 aka 11i v2. --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic05340.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File Types...
David, I'm now working some with UniVerse - the mystical side of the U2 family... I never knew how easy we have it in UniData!! I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - you have to have 3 LIKES to (AAA..., ...AAA..., ...AAA) to do the same it appears... COPY is really wicked - and don't start me on the editor - at least this version of UV has a beta AE, otherwise I'd be seriously lost!! The [X] syntax works as you'd expect in Reality flavoured accounts. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Data Security
Robert, UniVerse 10.x has a base64 encoding/decoding function built in. And OCONV code MX0C will convert to a hex string (faster but less space efficient). If you are careful in how you read the data in the first place and you then encode it before writing it should be no different to any other binary data. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .ex e
I don't think ours suffered from speed issues. It was so long ago and we did what we had to to keep the project alive. The problem you had arises from accessing a dynamic array value more than once in a statement. If you are in your application's infancy, you can use local variable. Instead of: dynarray1.value(1,1) = dynarray1.value(1,1) + dynarray2.value(1,3) use: var1 = dynarray1.value(1,1) var2 = dynarray2.value(1,3) dynarray1.value(1,1) = var1 + var2 Then you can keep the non-pcode version and control of the compilation optimisation. Jef... IT Vision Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153 Tel: (08) 9315 7000 Fax: (08) 9315 7088 P O Box 881, Canning Bridge, WA 6153 A.C.N. 068 914 867 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] File Types...
Try ...'AAA'... David, I can say SELECT FILE WITH A = [AAA] and will find AAA whether at the start, middle or end... That LIKE ...AAA... won't do the same - --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] File Types...
You need the single quote if you have something that has a space in it otherwise you don't. I suspect this was the problem David was having Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Darlaston Sent: Wednesday, 25 August 2004 1:32 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] File Types... You don't need quotes, either single or double. Just use SELECT FILE WITH A LIKE ...AAA... I prefer LIKE to [AAA] because you can also do things like SELECT FILE WITH A LIKE ...AAA...BBB... and get all records with AAA followed be some unspecified characters followed by BBB anywhere in field A. Bob Darlaston. - --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] The Learning Curve Continues!!
In a message dated 8/24/2004 9:36:20 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Not exactly. You can use quotes but you have to be careful about things that trigger MATCHES. So if you say LIST NAME LIKE ...3N... i think it will try to find any string with three numerics. Or maybe it will if you say LIST NAME LIKE ...3N... one or the other, I just can't recall. Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/