RE: [U2] Universe/UniObjects and Visual Studio
Anthony there is a tutorial on using UniObjects with VB Express on the U2UG Knowledge Base. Check out : www.mvopen.org/cms and click the Knowledge Base link. Regards, Brian Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- 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] Old Dog, New Tricks
Or just use $OPTIONS EXTRA.DELIM. This ensures that an empty element is still added with the correct delimiter. Brian In message [EMAIL PROTECTED], Allen E. Elwood [EMAIL PROTECTED] writes You can always test, IF TEMP = '' THEN TEMP = NULL and likewise on the end that processes after the ARRAY is completed. 1~2~NULL~4~5~NULL~... on the receiving end would be IF ARRAYWHATEVER = NULL THEN ARRAYWHATEVER = If you're going to do that, use (I think) EREPLACE. I think it's that function, but there's certainly one to remove all occurrences of a particular text. The danger is that the letters NULL will be part of a value which then gets corrupted... I always did ARRAY := @FM : WHATEVER and then at the end did DEL ARRAY1 Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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] UNLOAD.FILE
Hi I tried UNLOAD.FILE with catalog command to export the database tables. But it didn't work. I am able to catalog the subroutines in the exiting account.Please help me in this regard to export the database table. Thanks, Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] User Creadted Tables and BP files
Hi I successfully created a table in Universe database (using CREATE TABLE Table Name.query as in SQL). In ORACLE all these database objects reside inside a particular schema. So in Universe database where are the user defined tables stored ? How can I see all the tables that are created by the users ? Similarly how can I see all the Universe BASIC programs (*.BP files) that are created by the users? Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone AIX 5.3 with UV 9.6 Upgrade C/C++ runtime to V8.0.0.4 ?
Hi Garry, Aside from JayJay's comments on the release notes, UniVerse 9.6 is not certified for AIX 5.3 , the first UniVerse release certified for AIX5.3 is 10.1.12, for reference please see the availability matrix at https://www.ibm.com/software/data/u2/support/u2techconnect/matrix.asp Regards, Jonathan Smith Advanced Support Engineer - U2 Advanced Technical Support IBM Certified Solutions Expert http://www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online DISCLAIMER:This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU [demime 1.01d removed an attachment of type image/gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[no subject]
Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Reports In Universe BASIC
Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re:[U2] Anyone AIX 5.3 with UV 9.6 Upgrade C/C++ runtime to V8.0.0.4 ?
Hi Garry, UniVerse 9.6 is not certified for AIX 5.3 , the first UniVerse release certified for AIX5.3 is 10.1.12, for reference please see the availability matrix at https://www.ibm.com/software/data/u2/support/u2techconnect/matrix.asp Regards, Jonathan Smith Advanced Support Engineer - U2 Advanced Technical Support IBM Certified Solutions Expert http://www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online DISCLAIMER:This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU [demime 1.01d removed an attachment of type image/gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] User Creadted Tables and BP files
Sanjeeb The uniVerse environment is subdivided into a number of logical areas called 'Accounts'. In practise an account is a specific O/S directory: any files created are physically resident in that directory (unless you do special things to move them). For example, the UniVerse directory (UV) is also an account. This is normally reserved for system files, and is not used for user files. There are two ways to create an account in UniVerse: 1. Create a new physical directory and run UniVerse in there. You can do this at the OS level by invoking the uv executable, or if you are running UniVerse on Windows you can specify the pathname when you TELNET in as an administrator. You will be asked to supply the account 'flavor' which is a set of emulations. As a new user, select 3 Pick flavor - it is the simplest. 2. Use the HOME keyword with the CREATE SCHEMA command. This creates the account as an SQL schema - as a note, all schemas are accounts but not all accounts are schemas. To list all the files in an account use the LISTF command. This only shows local files though - you can create logical pointers to files in other accounts called 'Q' pointers. There isn't a short command to list those: use LIST VOC WITH F1 LIKE Q... to get that listing. There is nothing to physically distinguish the program source files until you compile something in them. then a separate object file is created called filename.O. You can check for these in the listing. Hope this helps, Brian Hi I successfully created a table in Universe database (using CREATE TABLE Table Name.query as in SQL). In ORACLE all these database objects reside inside a particular schema. So in Universe database where are the user defined tables stored ? How can I see all the tables that are created by the users ? Similarly how can I see all the Universe BASIC programs (*.BP files) that are created by the users? Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] Re:
Sanjeeb, You can generate reports in many, many different ways. BASIC is just one set of options. You should first look at the ReTrieve language, which is a query language, like SQL, but with a much simpler syntax since the JOINs are built into the schema, not the query. As to BASIC, the PRINT command sends things to the designated output (printer or screen), and repeating information can be done with a simple loop. Your core structure will look something like this: FERR = '' OPEN 'AR' TO AR.FILE ELSE FERR:='AR;' IF FERR # '' THEN ABORT 201, FERR * DONE = 0 LOOP READNEXT AR.ID ELSE DONE = 1 UNTIL DONE DO READ AR.REC FROM AR.FILE, AR.ID THEN GOSUB REPORT.ON.ONE.RECORD END REPEAT * STOP * * Start of Subroutines * REPORT.ON.ONE.RECORD: * Put your report row building logic here RETURN This logic would pull one record at a time from your AR file, based on what ever list of records you have pre-selected, and do *whatever* your REPORT.ON.ONE.RECORD subroutine does. - Chuck Sanjeebkumar Sarangi wrote: Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Reports In Universe BASIC
Can't wait for the answers on this one. My submissions are: 1. External SSELECT then report formatting in Basic. 2. Parameters gathered in BASIC then report formatting in Basic. 3. Parameters gathered in BASIC then create an EXECUTEable TCL statement for the report. This thread should get interesting. Refer to last week's Anita and Marinko's newbie requests and this falls directly into it. My side bet is going to be how differently BREAK-ON's are handled with Basic. Also, the inclusion of secondary files, simultaneous report sections etc. This could get ugly. My 1 cent Mark Johnson - Original Message - From: Sanjeebkumar Sarangi [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 12, 2007 7:00 AM Subject: [U2] Reports In Universe BASIC Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] MVQuery Security Profiles issue
Has anyone had any problems implementing mvquery security profiles? I have set up a security profile to allow access to a specified subset of files, and attached users to that profile, but it seems as if the only thing it will look at to get the list of files to display is the MVQUERY_FILES VOC entry. Thanks, Dave. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Periodic Reminder
All, Please trim excess from your posts when responding. Just leave in the parts you are responding to, as a courtesy to the others on the list *especially* the digest readers. If you read this list through Indexfocus, Nabble, or any other replicator - and you would like to be able to participate - sign up directly with us. Here's all you need to know: To subscribe or resubscribe please visit http://listserver.u2ug.org/. - The Moderators Charles Barouch Larry Hiscock --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re:
UniBasic is the best way, by far. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Barouch Sent: Monday, March 12, 2007 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Re: Sanjeeb, You can generate reports in many, many different ways. BASIC is just one set of options. You should first look at the ReTrieve language, which is a query language, like SQL, but with a much simpler syntax since the JOINs are built into the schema, not the query. As to BASIC, the PRINT command sends things to the designated output (printer or screen), and repeating information can be done with a simple loop. Your core structure will look something like this: FERR = '' OPEN 'AR' TO AR.FILE ELSE FERR:='AR;' IF FERR # '' THEN ABORT 201, FERR * DONE = 0 LOOP READNEXT AR.ID ELSE DONE = 1 UNTIL DONE DO READ AR.REC FROM AR.FILE, AR.ID THEN GOSUB REPORT.ON.ONE.RECORD END REPEAT * STOP * * Start of Subroutines * REPORT.ON.ONE.RECORD: * Put your report row building logic here RETURN This logic would pull one record at a time from your AR file, based on what ever list of records you have pre-selected, and do *whatever* your REPORT.ON.ONE.RECORD subroutine does. - Chuck Sanjeebkumar Sarangi wrote: Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Reports In Universe BASIC
Here is a simple example. It uses two files: BOOK_AUTHORS and BOOK_TITLES. The BOOK_AUTHOR has a multivalued list of IDs for titles by that author. The program prints the author name followed by the titles in ascending order. It's an example from a developers course I run. You can download the demo files from my website: www.brianleach.co.uk. PROGRAM printauthor *-- * Name: printauthor * Description : Print author details * Author : Brian Leach * Project : * Module : GENERAL *-- * Notes * - *-- * Modification History * * * DateWho Version Description * --- --- --- *-- * Version Stamp * - *-- * Print an author summary including a list of titles * This version selects the author by name using a separate select list EQU AUTHOR.FULLNAME To 1 EQU AUTHOR.TITLES To 3 EQU TITLE.NAME To 1 EQU TITLE.ISBN To 8 EQU TITLE.PRICE To 9 Open BOOK_TITLES To BOOKTITLES Else Crt Cannot open the BOOK_TITLES File STOP End Open BOOK_AUTHORS To BOOKAUTHORS Else Crt Cannot open the BOOK_AUTHORS File STOP End Open BOOK_READERS To BOOKREADERS Else Crt Cannot open the BOOK_READERS File STOP End Prompt Crt Enter an author name : : Input AuthorName If AuthorName = Then STOP End Cmd = 'SELECT BOOK_AUTHORS WITH FULLNAME LIKE ...':AuthorName:'...' Execute Cmd, SELECT. AUTHORLIST Printer On Loop ReadNext AuthorId FROM AUTHORLIST Else Crt Enter an author id : : Input AuthorId End Until AuthorId = Do * first read the author details Read AuthorRec From BOOKAUTHORS, AuthorId Then Gosub PrintAuthor End Repeat Printer Off Printer Close RETURN *--- * PrintAuthor *--- PrintAuthor: Print Print Author Name : :AuthorRecAUTHOR.FULLNAME Print NumTitles = DCount(AuthorRecAUTHOR.TITLES,@VM) ; * Count number of values * create a set of display variables TitleIds = Titles = Prices = Units = ISBNs = * Build up the list of titles in order For I = 1 To NumTitles TitleId = AuthorRecAUTHOR.TITLES,I Read TitleRec From BOOKTITLES, TitleId Then Locate TitleRecTITLE.NAME In Titles BY AL Setting Pos Else Ins TitleRecTITLE.NAME before TitlesPos Ins TitleId Before TitleIdsPos Ins TitleRecTITLE.ISBN Before ISBNsPos Ins OConv(TitleRecTITLE.PRICE,MD2) Before PricesPos End End Next Print Id L.5: : Print Title L.40: : Print ISBN L.12: : Print Price R.7 Print * Now display the list For I = 1 To NumTitles Print TitleIdsI L#5: : Print TitlesI L#40: : Print ISBNsI L#12: : Print PricesI R#7 Next Return --- Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FTP
I do want to state that being able to watch packets or make modifications to them would mean that 'someone' would be sitting in a place where they would see ALL packets whizzing by - like the phone company, or part of the packet switching network world. And those people could screw with you daily as it is - why should FTP interest them?? I would be more worried about someone 'dumpster diving' for your data than modifying or grabbing the in-transit packets, so long as the user was not sitting in a Starbucks using an OpenWiFi connnection! Otherwise, I think that it may be just a *bit* or paranoia! ;-) But overall I agree FTP is terribly hard to 'automate' - if FTP is part of the requirements, it is almost always the part that changes ALL THE TIME. We frequently just produce the file, and have them learn the wonders of CuteFTP... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Sunday, March 11, 2007 10:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] FTP I see security has been mentioned a couple times but I hope that sinks in - FTP is not a secure protocol. Your EDI headers and detail are open for viewing. Seeing that you're in the trucking business someone might find it worth their time to watch your packets or maybe even make modifications in order to redirect or intercept shipments. No, not paranoia, it happens. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MVQuery Security Profiles issue
Dave The security profiles work fine for me. What platform are you using? AFAIR there is an issue with UniData on Windows reporting the group name rather than the user name, which affects the profiles. Brian Has anyone had any problems implementing mvquery security profiles? I have set up a security profile to allow access to a specified subset of files, and attached users to that profile, but it seems as if the only thing it will look at to get the list of files to display is the MVQUERY_FILES VOC entry. Thanks, Dave. --- 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] MVQuery Security Profiles issue
Dave we use this all the time its fine i spect our Brian will have the answer since he wrote it bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: 12 March 2007 13:02 To: u2-users@listserver.u2ug.org Subject: [U2] MVQuery Security Profiles issue Has anyone had any problems implementing mvquery security profiles? I have set up a security profile to allow access to a specified subset of files, and attached users to that profile, but it seems as if the only thing it will look at to get the list of files to display is the MVQUERY_FILES VOC entry. Thanks, Dave. --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Reports In Universe BASIC
Hi Once you have gotten the hang of the program to print something you will have more questions but this example will start you off Louie -- *-- sample to illustrate how a report will be printed using U-Basic *-- all bells and whistles to be added as soon as conceptual understanding *-- is there * * open the file you want to report on * OPEN 'MASTERFILE' TO FILE ELSE STOP * * build the 'tcl' sentence to select the file * SENT='SSELECT MASTERFILE BY SURNAME' EXECUTE SEN RETURNING NO.SELECTED * * if no items present then do whatever, like stop * IF NO.SELECTED = 0 THEN STOP * * loop thru the records EOF=0 LOOP READNEXT KEY ELSE EOF=1 UNTIL EOF DO READ REC FROM FILE,KEY THEN GOSUB PRINT.LINE END REPEAT STOP *-- *-- PRINT.LINE: *-- * rec1= the surname using 30 chars left justified * rec2= the name using 15 chars left justified * rec3= amount , converted to .00 and 10 chars right justified PRINTER ON LN=REC1 'L#30':REC2:'L#15':OCONV(REC3,'MD2') 'R#10' PRINT LN PRINTER OFF * RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: 12 March 2007 14:01 To: u2-users@listserver.u2ug.org Subject: [U2] Reports In Universe BASIC Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic files, big transactions
All, I have done some more digging and I'm now stuck at writing about 6k new records within one transaction. I don't know what I might be missing but depending on different variations I get a max of 5k or 6k and then a READU threshold reached error will break the transaction. Any more insights will be greatly appreciated. I have pasted info of my last test below. Regards, Andre Meij Innovate-IT DELETE.FILE TEST06 DELETEd TEST06, Type 30. DELETEd file D_TEST06, Type 3, Modulo 1. DELETEd file definition record TEST06 in the VOC file. CREATE.FILE TEST06 30 MINIMUM.MODULUS 1024 SEQ.NUM Creating file TEST06 as Type 30. Creating file D_TEST06 as Type 3, Modulo 1, Separation 2. Added @ID, the default record for RetrieVe, to D_TEST06. ANALYZE.FILE TEST06 File name .. TEST06 Pathname ... TEST06 File type .. DYNAMIC Hashing Algorithm .. SEQUENTIAL No. of groups (modulus) 1024 current ( minimum 1024 ) Large record size .. 1628 bytes Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 0% (actual) Total size . 2101248 bytes RUN BP test 15000 5 Starting writing 5 records READU threshold reached, lock on 11521224 denied! Completed writing 6223 records Error: WARNING, 'TEST06' record '11521224' locked, try again later. GROUP.STAT.DETAIL TEST06 Type description= Hashed, keys end in numbers. Bytes Record.id File= TEST06 Modulo= 1024 Sep= 4 Type= 30 32 11518037 32 11520098 32 11519718 32 11516722 32 11517008 -- 160 Bytes 5 Records in Group 1 32 11518036 32 11517009 32 11520099 32 11519719 32 11516723 -- 160 Bytes 5 Records in Group 2 32 11518038 32 11517011 32 11520096 32 11519716 32 11516720 LIST.READU (started before the end of the transaction after the READU error. Active Record Locks: Device Inode Netnode Userno LmodePid Login Id Item-ID. 22282244 12580680 115 RU 21074 ameij11515011 22282244 12580680 115 RU 21074 ameij11515033 22282244 12580680 115 RU 21074 ameij11515068 22282244 12580680 115 RU 21074 ameij11515102 22282244 12580680 115 RU 21074 ameij11515135 22282244 12580680 115 RU 21074 ameij11515146 22282244 12580680 115 RU 21074 ameij11515161 22282244 12580680 115 RU 21074 ameij11515179 22282244 12580680 115 RU 21074 ameij11515218 22282244 12580680 115 RU 21074 ameij11515235 22282244 12580680 115 RU 21074 ameij11515284 22282244 12580680 115 RU 21074 ameij11515298 22282244 12580680 115 RU 21074 ameij11515315 22282244 12580680 115 RU 21074 ameij11515334 22282244 12580680 115 RU 21074 ameij11515351 22282244 12580680 115 RU 21074 ameij11515364 22282244 12580680 115 RU 21074 ameij11515420 22282244 12580680 115 RU 21074 ameij11515453 22282244 12580680 115 RU 21074 ameij11515468 22282244 12580680 115 RU 21074 ameij11515477 22282244 12580680 115 RU 21074 ameij11515510 22282244 12580680 115 RU 21074 ameij11515548 22282244 12580680 115 RU 21074 ameij11515565 22282244 12580680 115 RU 21074 ameij11515579 22282244 12580680 115 RU 21074 ameij11515608 22282244 12580680 115 RU 21074 ameij11515627 22282244 12580680 115 RU 21074 ameij11515649 22282244 12580680 115 RU 21074 ameij11515685 22282244 12580680 115 RU 21074 ameij11515718 22282244 12580680 115 RU 21074 ameij11515751 22282244 12580680 115 RU 21074 ameij11515769 22282244 12580680 115 RU 21074 ameij11515791 22282244 12580680 115 RU 21074 ameij11515798 22282244 12580680 115 RU 21074 ameij11515824 22282244 12580680 115 RU 21074 ameij11515860 22282244 12580680 115 RU 21074 ameij11515893 22282244 12580680 115 RU 21074 ameij11515928 22282244 12580680 115 RU 21074 ameij11515945 22282244 12580680 115 RU 21074 ameij11515965 22282244 12580680 115 RU
RE: [U2] MVQuery Security Profiles issue
It sounds like he does. It's the Windows servers where this is a problem. Only one of them has complained about it. Are the security profiles used on joined files as well? As in, the file doesn't show up on the main list, but can be accessed if joined to from an accessible file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Monday, March 12, 2007 9:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MVQuery Security Profiles issue Dave we use this all the time its fine i spect our Brian will have the answer since he wrote it bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: 12 March 2007 13:02 To: u2-users@listserver.u2ug.org Subject: [U2] MVQuery Security Profiles issue Has anyone had any problems implementing mvquery security profiles? I have set up a security profile to allow access to a specified subset of files, and attached users to that profile, but it seems as if the only thing it will look at to get the list of files to display is the MVQUERY_FILES VOC entry. Thanks, Dave. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MVQuery Security Profiles issue
Dave, Are the security profiles used on joined files as well? As in, the file doesn't show up on the main list, but can be accessed if joined to from an accessible file. The security is deliberately not enforced directly on joins. This is by design - the security has two uses: one to secure and another to sanitize. There are sites who will allow files to be viewed indirectly, but don't want them cluttering up the user file list. With hindsight we should have separated 'visible' files from 'secured' files, but that's all in the past now. You CAN secure the join by using field level security on the joined file: this is applied through the join. For details see the Admin Guide page 32. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Monday, March 12, 2007 9:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] MVQuery Security Profiles issue Dave we use this all the time its fine i spect our Brian will have the answer since he wrote it bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: 12 March 2007 13:02 To: u2-users@listserver.u2ug.org Subject: [U2] MVQuery Security Profiles issue Has anyone had any problems implementing mvquery security profiles? I have set up a security profile to allow access to a specified subset of files, and attached users to that profile, but it seems as if the only thing it will look at to get the list of files to display is the MVQUERY_FILES VOC entry. Thanks, Dave. --- 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] UniObjects / Read Timeout
I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata BCI on AIX
Does anyone have Unidata BCI up and running on AIX 5.3, and if you do, what's involved in the original setup? We have a situation where we want to send some data out to a SQL database from a UniBASIC program and this seems to be a good way to make it happen. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out scheduled Connect! training courses at http://www.precisonline.com/train.html http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic files, big transactions
Andre, I am not quite sure what you are doing a transaction on, but even if you successfully configured a Universe system to handle transactions with that many elements simultaneously locked, I would guess that it is inefficient to grab that many locks at once. Your transaction is too (bloody) large! So I think that you may need to restructure your process somehow. The first question that I would have is are you doing a BASIC transaction or a SQL one? I am assuming that you are doing a BASIC one. Beyond that, you may need to NOT use a formal TRANSACTION, but rather keep track of the state of your update somewhere, and do WRITES outside of a TRANSACTION block. If you are just creating new records, and you ensure that the id is unique, you could save some thrashing by doing WRITES into a file without a previous READU. One scheme might be: READU the sequence counter record, increment by the number of detail records in the transaction. Create a transaction control record (TCR) in a file that you have created for this purpose. perhaps a usernumber together with time() could be used as an id. Include the range of detail ids in the TCR WRITE (and unlock) the sequence counter. Create the detail records in a work file (without using transactions, and possible without locking the records before writing) Update the TCR, indicating that the previous step completed Copy the records for the TCR's range from the work file to the production file, deleting them out of the work file. stamp the TCR as complete. --- This is somewhat crude and incomplete, but you get the idea. Out of curiosity, what kind of event has that many elements? Good luck! -Rick Nuckolls Lynden, Inc. On Mar 12, 2007, at 8:10 AM, Andre Meij wrote: All, I have done some more digging and I'm now stuck at writing about 6k new records within one transaction. I don't know what I might be missing but depending on different variations I get a max of 5k or 6k and then a READU threshold reached error will break the transaction. Any more insights will be greatly appreciated. I have pasted info of my last test below. Regards, Andre Meij Innovate-IT DELETE.FILE TEST06 DELETEd TEST06, Type 30. DELETEd file D_TEST06, Type 3, Modulo 1. DELETEd file definition record TEST06 in the VOC file. CREATE.FILE TEST06 30 MINIMUM.MODULUS 1024 SEQ.NUM Creating file TEST06 as Type 30. Creating file D_TEST06 as Type 3, Modulo 1, Separation 2. Added @ID, the default record for RetrieVe, to D_TEST06. ANALYZE.FILE TEST06 File name .. TEST06 Pathname ... TEST06 File type .. DYNAMIC Hashing Algorithm .. SEQUENTIAL No. of groups (modulus) 1024 current ( minimum 1024 ) Large record size .. 1628 bytes Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 0% (actual) Total size . 2101248 bytes RUN BP test 15000 5 Starting writing 5 records READU threshold reached, lock on 11521224 denied! Completed writing 6223 records Error: WARNING, 'TEST06' record '11521224' locked, try again later. GROUP.STAT.DETAIL TEST06 Type description= Hashed, keys end in numbers. Bytes Record.id File= TEST06 Modulo= 1024 Sep= 4 Type= 30 32 11518037 32 11520098 32 11519718 32 11516722 32 11517008 -- 160 Bytes 5 Records in Group 1 32 11518036 32 11517009 32 11520099 32 11519719 32 11516723 -- 160 Bytes 5 Records in Group 2 32 11518038 32 11517011 32 11520096 32 11519716 32 11516720 LIST.READU (started before the end of the transaction after the READU error. Active Record Locks: Device Inode Netnode Userno LmodePid Login Id Item-ID. 22282244 12580680 115 RU 21074 ameij 11515011 22282244 12580680 115 RU 21074 ameij 11515033 22282244 12580680 115 RU 21074 ameij 11515068 22282244 12580680 115 RU 21074 ameij 11515102 22282244 12580680 115 RU 21074 ameij 11515135 22282244 12580680 115 RU 21074 ameij 11515146 22282244 12580680 115 RU 21074 ameij 11515161 22282244 12580680 115 RU 21074 ameij 11515179 22282244 12580680 115 RU 21074 ameij 11515218 22282244 12580680 115 RU 21074 ameij 11515235 22282244 12580680 115 RU 21074 ameij 11515284 22282244 12580680 115 RU 21074 ameij 11515298 22282244 12580680 115 RU 21074 ameij 11515315 22282244 12580680 115 RU 21074 ameij 11515334 22282244 12580680 115 RU
RE: [U2] Reports In Universe BASIC
How about first some query questions written in basic regarding the options available, and then followed by an internal building of the headings so left parts are left justified, center parts are center justified, right parts are right justified, and then building query statement within the program and PERFORM'ing that? This is what I do for a MvBASE client and the results are really nice. Multiple options selected can be included as part of the headings, and it's easy as pie since I have variables that I just plop in the options selected and the programming does the auto-justification! This way I can do things normally only 'doable' in a program, but still let the query language do all the reporting work. Headings come out perfectly every time and the first time with no guessing. Different options selected which in a proc would throw the headings off, still come out perfect. SETUP.HEADINGS: RPT.HDNG= 'Report Title Goes Here' RPT.HDNG2 = OPTION.TEXT LINE.SIZE = 132 COMPANY = 'Client Name Goes Here' *#* GENERIC HEADINGS DO NOT MODIFY THIS CODE * IF NOT(MOD(LEN(COMPANY),2)) THEN COMPANY = ' ':COMPANY HALF.SIZE = INT(LINE.SIZE/2) OPEN '', 'SYSTEM' TO SYSTEM ELSE STOP CANNOT OPEN SYSTEM FILE LOGON = SYSTEM(19) PORT = SYSTEM(18) READ SYS.REC FROM SYSTEM, LOGON ELSE SYS.REC = '' IF SYS.REC1 = 'D' THEN LOGON.ACCOUNT = LOGON END ELSE LOGON.ACCOUNT = SYS.REC2 END * IDATE = DATE() TEMP = OCONV(IDATE,'DWA') DAY = TEMP[1,1]:OCONV(TEMP[2,10],'MCL') TIME = OCONV(TIME(),'MTH') DATE = OCONV(IDATE,'D2/') * SEC.1 = PGM.NAME:' ':TIME SEC.2 = COMPANY SEC.3 = 'Port ':PORT:' Acct ':LOGON.ACCOUNT[40]:' Page' L2SC1 = DAY:' ':DATE * SEC.1.LEN = LEN(SEC.1) SEC.2.LEN = INT(LEN(SEC.2)/2) SEC.3.LEN = LEN(SEC.3)+5 ; *Add five digits to account for space page # at eol * L2SC1.LEN = LEN(L2SC1) RPT1H.LEN = INT(LEN(RPT.HDNG1)/2) * HDNG.1= '' HDNG.1[1,SEC.1.LEN] = SEC.1 HDNG.1[HALF.SIZE - SEC.2.LEN] = SEC.2 HDNG.1[LINE.SIZE - SEC.3.LEN] = SEC.3 * HDNG.1 = HDNG.1[1,LINE.SIZE-5] * HDNG.2= '' HDNG.2[1,L2SC1.LEN] = L2SC1 HDNG.2[HALF.SIZE - RPT1H.LEN] = RPT.HDNG1 * HDNG.3 = SPACE(HALF.SIZE-LEN(RPT.HDNG2)/2):RPT.HDNG2 HDNG.4 = SPACE(HALF.SIZE-LEN(RPT.HDNG3)/2):RPT.HDNG3 HDNG.5 = SPACE(HALF.SIZE-LEN(RPT.HDNG4)/2):RPT.HDNG4 PAGE.CNT = 0 LINE.CNT = 99 * *#* END OF GENERIC HEADINGS * * Now make what would normally be headings in a program, into PICK headings HDNG.1 := ':'PL':' HDNG.2 := ':'L':' HDNG.3 := ':'L':' HEADINGS = HDNG.1:HDNG.2:HDNG.3 RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Monday, March 12, 2007 06:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reports In Universe BASIC Can't wait for the answers on this one. My submissions are: 1. External SSELECT then report formatting in Basic. 2. Parameters gathered in BASIC then report formatting in Basic. 3. Parameters gathered in BASIC then create an EXECUTEable TCL statement for the report. This thread should get interesting. Refer to last week's Anita and Marinko's newbie requests and this falls directly into it. My side bet is going to be how differently BREAK-ON's are handled with Basic. Also, the inclusion of secondary files, simultaneous report sections etc. This could get ugly. My 1 cent Mark Johnson - Original Message - From: Sanjeebkumar Sarangi [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 12, 2007 7:00 AM Subject: [U2] Reports In Universe BASIC Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/
[U2] Help with File Pointers
Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How much RAM is too much
All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
quote who=Susan Joslyn Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? pwd = print working directory. The account you are in is the results of pwd. This command is run at the OS level. You can also just type SH at TCL/ECL and the type cd ../.. and see where you find yourself. Likewise, paths can begin with @UDTHOME (and something similar on Universe?) You can type echo $UDTHOME to find out what the path is. Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? env|grep $PWD will give you the working directory of a session. I don't know if that helps, but I use it... Karl Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Susan UniVerse thankfully doesn't have the @ variable insertion. Remember that on Windows, forward and backward slashes can be generally used indiscrimiately, e.g. C:\data\myaccount/myfile Then of course there are symbolic links under UNIX, case insensitivity in Windows.. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 12 March 2007 19:35 To: u2-users@listserver.u2ug.org Subject: [U2] Help with File Pointers Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- 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] How much RAM is too much
Charles, We are running an IBM xSeries with dual Xeons 2.5ghz and 5gb memory with 105 users all Universe (Linux) real time system, lots of files(type30), lots of activity and our response time is exceptional. So, all I can say is that you probably need less than that. Actually, these days you can get a system similar to this for peanuts if you don't need to get fancy with the storage system. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 2:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Help with File Pointers
Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Karl, Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. Susan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:19 PM To: [EMAIL PROTECTED] Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers quote who=Susan Joslyn Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? If you SH out to a command prompt, then you can do cd line 2 on each F-Ptr minus the file itself. If you do this in 2 different command prompts, then type PWD in each, you'll see the exact path, and if it matches, then you are looking at the same file. This is one reason not to use relative file points to 'remote' files. It's better to use Q-pointers. I hope this is more clear that my previous feeble attempt. Karl Susan -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Try opening the two files, then comparing using FILEINFO(filename,2); this gives the path to file. -Original Message- Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. p://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How much RAM is too much
Chuck: A) Is this two different databases on one instance, or two separate instances? B) Just to clarify, the SQL database instances and the UV database instance will be on the same box? C) Which SQL database? D) What underlying OS? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Spam-Low] RE: [U2] Help with File Pointers
Susan, You can execute an ls -i for each path (ls -i ../../blahblah). This returns the inode for the file. If the inode is the same, the files are the same (one inode for each file). Lee H. Burstein President Dynamic Systems, Inc. 302-477-0180 Fax: 270-574-0180 www.dynamicsys.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 4:09 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: [Spam-Low] RE: [U2] Help with File Pointers Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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: Spam:RE: [U2] Help with File Pointers
In UniVerse use the UniBasic STATUS statement and use either the 10th or 20th field. - Original Message - From: Susan Joslyn [EMAIL PROTECTED] To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Sent: Monday, March 12, 2007 2:09 PM Subject: Spam:RE: [U2] Help with File Pointers Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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] How much RAM is too much
Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers. Of course I may need a mental reset, too. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Help with File Pointers
I like this answer even better!! I forget about FILEINFO! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: Monday, March 12, 2007 3:31 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: RE: [U2] Help with File Pointers Try opening the two files, then comparing using FILEINFO(filename,2); this gives the path to file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects / Read Timeout
You might want to take a look at the unirpcservices file on the server. This is a text file located in the unishared directory. The last entry on each line is a timeout value in 1/10th seconds. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: 12 March 2007 16:17 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects / Read Timeout I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. Thanks. --- 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] Help with File Pointers
If you have the current 'path' then .. is always the path before... So if you are sitting in c:\IBM\ACCOUNTS\TESTIT And the path in the VOC is to ..\..\bin You can 'peel back' on each .. to the layer before: So ..\..\bin would turn C:\IBM\ACCOUNTS\TESTIT into C:\IBM\bin You would count the number of ..s and chop that number of segments off the end of the current path... Two ..s peel off 2 segments. Then stick whatever is after the ..s on the end... As for the @UDTHOME and the like - you'd want to do a 'swap' to get those to work. And I'd likely 'fix' the path \ or / to be whichever you'd rather work with since they behave the same in UniData... DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 3:23 PM To: [EMAIL PROTECTED] Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers Karl, Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects / Read Timeout
Jeff Powell wrote: I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. If it looks like you're going to be pushing timeouts significantly then it might be best to approach this asynchronously. Send the selection to a phantom on the server, generate a list, then use the list to process items from the client. Don't just phantom off the selection. Have a program do the selection, then write a unique tickler item when the selection is done. Your UO code can read for this item for some period of time, provide entertainment for the user between pings (hourglass, progressbar, some other animation). You can control the timeout simply by stopping the server pings and asking the user what they want to do. I've done this for long running reports called from web clients. If it takes more than about 20 seconds, or if there is a flag manually set that indicates a given report will undoubtedly take more than 20 seconds, I don't make the user wait. I give them a page they can check to see if their report is complete. For very long reports you can send an email with a link when a report is complete, or your remote client interface can periodically check pending reports from menus or other places, so that you can inform the user on-screen when a previous request is ready. HTH TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
This: ../.. means the directory above the directory above the one I'm in right now, so by knowing where you are right now (pwd) you can fill in the complete path.and compare apples to apples Susan Joslyn wrote: Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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: [Spam-Low] RE: [U2] Help with File Pointers
Re: Susan, You can execute an ls -i for each path (ls -i ../../blahblah). This returns the inode for the file. If the inode is the same, the files are the same (one inode for each file). Lee H. Burstein Lee, this is on face value okay, but technically wrong; there is a chance that filea in file system x has the same inode as fileb in file system y share the same inode number. I wouldn't want to calculate those odds or chances, but ... Inode numbers are assigned per file system, I believe... Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Just to add one more possible complication to your scenario. Depending on the software or the UNIX admin people, you may need to worry about symbolic links at a UNIX level. For example, lets say you are in Unidata in the directory /usr/ud/ROD. In the VOC for this directory is a file called RODS.FILE, where the VOC entry looked like: 1. D 2. RODS.FILE 3. D_RODS.FILE It would appear that this file lived in the current directory where the VOC is. But at a UNIX level, there could be a symbolic links that says: lrwxrwxrwx 1 root udtgrp 34 Mar 6 20:18 ROD.FILE - /usr/ud/SUSAN/RODS.FILE So RODS.FILE is really lives in another directory called SUSAN. The person doing this should have changed the VOC pointer. But a lot of times UNIX (Unidata phobic) types will move the file to keep a file system from filling up and create a symbolic link to where it lives now. Just thought I would throw that scenario out there just in case you had not thought about it. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Help with File Pointers Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- 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] Help with File Pointers
The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How much RAM is too much
Kevin, The SQL is a pair of MSSQL databases, each on their own machines. The UV machine will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network and then process the SQL data into UV (via UniObjects). The O/S is XP pro. - Chuck Kevin King wrote: Chuck: A) Is this two different databases on one instance, or two separate instances? B) Just to clarify, the SQL database instances and the UV database instance will be on the same box? C) Which SQL database? D) What underlying OS? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How much RAM is too much
Chuck, I'd look building a custom box with a dual-CPU Opteron mainboard, a 64-bit (PCI-X) disk controller doing RAID10, and the quickest 4GB you can find. You can run a single dual-core Opteron to start with and see how the load is. Two dual-cores may be a waste to start with. You will have major growth capabilities by just plopping another CPU in. --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 5:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How much RAM is too much Bob, I can't change the SQL boxes or the network. The only place I can help myself is in the layout for the new box. The new box will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network. The thing is, I can say 2GB memory or 4GB memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck 64K Barouch Bob Woodward wrote: Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers. Of course I may need a mental reset, too. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Help with File Pointers
That's a pain. Have you dont the STATUS test to see if it points out the correct file path? I will guess it will produce the same results as FILEINFO, however am curious. We use nothing but Q-pointers for just this reason. This, however, brings me to what I think is an undocumented feature of uniVerse. In a past life, I setup and managed a test server for training clients. I found that uniVerse could operate very nicely without entering accounts into the UV.ACCOUNT file. In fact, if accounts were NOT entered into that system-wide file, uniVerse could be secured pretty nicely and the same product could be installed many times as long as one rule was followed: Each product installation had to be in the same directory. I.e. DBACCT where the database files are kept USRACCT where the users login to work ADMINACCT where the client admin controls whatever BPACCT where the source code the users run is kept If they were in /u1/TRAIN1 you could put another identical set in /u1/TRAIN2, etc. You would then create a login mechanism that allows users to login to a specific account depending on the classroom used, or some other criteria. Doing a LOGTO ADMINACCT from TRAIN1, for example, would work and never be confused with TRAIN2, etc. The admin (me in this case) could do CHDIR /u1/TRAIN2/ADMINACCT if wanted to change environments, however. Since the users can't get to TCL, and the menuing software used LOGTO, it wasn't a security risk in our case. Now then, not applicable to this issue, but maybe someone can use it some time, some where. Karl quote who=Susan Joslyn The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
You're back to this logic then... Count the number of .. and chop that number of elements off the end. Then stuff everything AFTER the last ..s onto the end. There are dozens of ways to do this that would blow up your logic -- I suspect you'll get to find them one by one. ;-) David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, March 12, 2007 3:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you have the current 'path' then .. is always the path before... So if you are sitting in c:\IBM\ACCOUNTS\TESTIT And the path in the VOC is to ..\..\bin You can 'peel back' on each .. to the layer before: So ..\..\bin would turn C:\IBM\ACCOUNTS\TESTIT into C:\IBM\bin You would count the number of ..s and chop that number of segments off the end of the current path... Two ..s peel off 2 segments. Then stick whatever is after the ..s on the end... As for the @UDTHOME and the like - you'd want to do a 'swap' to get those to work. And I'd likely 'fix' the path \ or / to be whichever you'd rather work with since they behave the same in UniData... DW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
Susan, I noticed that err..that other software...had problems with relative paths. With SB Installed (and maybe without) you can get the base path of the ACCOUNT that the VOC from DMACCOUNTS1. You can then work with what the VOC entry from the path ACCOUNT in the account. I think you're asking how to determine the full path even when you're not LOGGED to the ACCOUNT, correct? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/12/2007 at 5:18 pm, in message [EMAIL PROTECTED], Jeff Schasny [EMAIL PROTECTED] wrote: This: ../.. means the directory above the directory above the one I'm in right now, so by knowing where you are right now (pwd) you can fill in the complete path.and compare apples to apples Susan Joslyn wrote: Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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] Reports In Universe BASIC
Here we go with the wide variety of 'examples'. What is the sanity of PRINTER ON, then PRINT then PRINTER OFF? Should we not be teaching PRINTER ON once and PRINTER OFF at the end? I've only seen the redundant PRINTER ON, then PRINT then PRINTER OFF when the programmer didn't know of CRT and was providing some PRINT @(x,y):ID running dialog. Plus, the EOF=0 then EOF=1 concept is also pretty Jurrasic. Most MV implementations will support: LOOP WHILE READNEXT KEY DO or LOOP READNEXT KEY ELSE EXIT UNTIL 0 DO and avoid the extra 'flags' and statements. Also, LN is a function and should not be used as a variable. Compiles? Yes, In the future? Maybe. My 1 cent. Mark Johnson - Original Message - From: Louie Gouws [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 12, 2007 10:03 AM Subject: RE: [U2] Reports In Universe BASIC Hi Once you have gotten the hang of the program to print something you will have more questions but this example will start you off Louie -- *-- sample to illustrate how a report will be printed using U-Basic *-- all bells and whistles to be added as soon as conceptual understanding *-- is there * * open the file you want to report on * OPEN 'MASTERFILE' TO FILE ELSE STOP * * build the 'tcl' sentence to select the file * SENT='SSELECT MASTERFILE BY SURNAME' EXECUTE SEN RETURNING NO.SELECTED * * if no items present then do whatever, like stop * IF NO.SELECTED = 0 THEN STOP * * loop thru the records EOF=0 LOOP READNEXT KEY ELSE EOF=1 UNTIL EOF DO READ REC FROM FILE,KEY THEN GOSUB PRINT.LINE END REPEAT STOP *-- *-- PRINT.LINE: *-- * rec1= the surname using 30 chars left justified * rec2= the name using 15 chars left justified * rec3= amount , converted to .00 and 10 chars right justified PRINTER ON LN=REC1 'L#30':REC2:'L#15':OCONV(REC3,'MD2') 'R#10' PRINT LN PRINTER OFF * RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: 12 March 2007 14:01 To: u2-users@listserver.u2ug.org Subject: [U2] Reports In Universe BASIC Hi What type of report is generated in Universe Basic ? Can any one tell me how to write a program that will generate a report ? Please give me some example that will provide me a clear idea regarding reports generation in Universe Basic. --- 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] Help with File Pointers
It looks like !VOC.PATHNAME will work to return the fully qualified path of two VOC F file pointer entries. Here's what I did: ED BOBW.BP TEST.VOC.PATH 8 lines long. : P 0001: CALL !VOC.PATHNAME(,TESTFILE,VOC.PATH,STATUS) 0002: IF STATUS = 0 THEN 0003: PRINT TESTFILE PATH=:VOC.PATH 0004: END 0005: CALL !VOC.PATHNAME(,TESTFILE2,VOC.PATH2,STATUS) 0006: IF STATUS = 0 THEN 0007: PRINT TESTFILE2 PATH = :VOC.PATH2 0008: END Bottom at line 8. : Q ED VOC TESTFILE TESTFILE2 SELECTed record name = TESTFILE. 3 lines long. : P 0001: F 0002: TESTFILE 0003: D_TESTFILE Bottom at line 3. : N SELECTed record name = TESTFILE2. 3 lines long. : P 0001: F 0002: ..\DEVACCT\TESTFILE 0003: ..\DEVACCT\D_TESTFILE Bottom at line 3. : Q 03 RUN BOBW.BP TEST.VOC.PATH PM PATH=D:/data/adv/data/DEVACCT/TESTFILE PM2 PATH = D:/data/adv/data/DEVACCT/TESTFILE In both cases, I got the full path returned. This is on a Windows 2003 system using Universe 10.1.18. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How much RAM is too much
Bob, I can't change the SQL boxes or the network. The only place I can help myself is in the layout for the new box. The new box will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network. The thing is, I can say 2GB memory or 4GB memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck 64K Barouch Bob Woodward wrote: Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers. Of course I may need a mental reset, too. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #1538
Hi Everyone. On help with file pointers thanks to everyone who has pitched in. So far I'm no joy. FILEINFO doesn't return just a hard path. STATUS doesn't seem to return anything. Ls -I might do the trick on UNIX but I need a Windows solution, too (and first). I think I can do the peel back/parsing thing. Was hoping not to have to do that. Anybody got anything else? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Reports In Universe BASIC
Again, some quicker methods: 1. U50BB is supported on all platforms. Use it for the Port and Account and possibly the user-id. Put this stuff in an external sub called GET.PORT or GET.ACCT or GET.USER to not re-invent it every time. Plus, if you straddle platforms like I do, I can always use CALL GET.PORT(PORT) and only platform-ize it once. 2. The Date TIme stuff is overly fancy. Just use TIMEDATE() as it matches the 'T' part of the heading/footing string. Or use 'D'. 3. Your DAY= thing on line #3 should just be an MCT for mixed casing. 4. Does not Ud UV support the 'C' expression in headings/footings as well as the justification C#132? I miss it on D3. I'm a very experienced MV programmer and to have 57 lines of code devoted to headings is, IMHO, excessive. If the home-rule 'standard' were to have consistent headings, put this in a subroutine and just pass the titles to it. I hope every program doesn't start like this. No offense, but this is a lot to show for headings to a newbie. It may intimidate and he may believe that they all must be this busy. One thing that will come from these submitted program snippets is the review and suggestions for improvement. As I have traveled on perhaps 50-60 different MV systems in my career, I've certainly seen many code samples that I want to use again and many that I want to replace. I'm not the best but I feel that I can offer up pretty useful opinions on what is easy-to read and understand code. Respectfully, Mark Johnson - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 12, 2007 1:39 PM Subject: RE: [U2] Reports In Universe BASIC How about first some query questions written in basic regarding the options available, and then followed by an internal building of the headings so left parts are left justified, center parts are center justified, right parts are right justified, and then building query statement within the program and PERFORM'ing that? This is what I do for a MvBASE client and the results are really nice. Multiple options selected can be included as part of the headings, and it's easy as pie since I have variables that I just plop in the options selected and the programming does the auto-justification! This way I can do things normally only 'doable' in a program, but still let the query language do all the reporting work. Headings come out perfectly every time and the first time with no guessing. Different options selected which in a proc would throw the headings off, still come out perfect. SETUP.HEADINGS: RPT.HDNG= 'Report Title Goes Here' RPT.HDNG2 = OPTION.TEXT LINE.SIZE = 132 COMPANY = 'Client Name Goes Here' *#* GENERIC HEADINGS DO NOT MODIFY THIS CODE * IF NOT(MOD(LEN(COMPANY),2)) THEN COMPANY = ' ':COMPANY HALF.SIZE = INT(LINE.SIZE/2) OPEN '', 'SYSTEM' TO SYSTEM ELSE STOP CANNOT OPEN SYSTEM FILE LOGON = SYSTEM(19) PORT = SYSTEM(18) READ SYS.REC FROM SYSTEM, LOGON ELSE SYS.REC = '' IF SYS.REC1 = 'D' THEN LOGON.ACCOUNT = LOGON END ELSE LOGON.ACCOUNT = SYS.REC2 END * IDATE = DATE() TEMP = OCONV(IDATE,'DWA') DAY = TEMP[1,1]:OCONV(TEMP[2,10],'MCL') TIME = OCONV(TIME(),'MTH') DATE = OCONV(IDATE,'D2/') * SEC.1 = PGM.NAME:' ':TIME SEC.2 = COMPANY SEC.3 = 'Port ':PORT:' Acct ':LOGON.ACCOUNT[40]:' Page' L2SC1 = DAY:' ':DATE * SEC.1.LEN = LEN(SEC.1) SEC.2.LEN = INT(LEN(SEC.2)/2) SEC.3.LEN = LEN(SEC.3)+5 ; *Add five digits to account for space page # at eol * L2SC1.LEN = LEN(L2SC1) RPT1H.LEN = INT(LEN(RPT.HDNG1)/2) * HDNG.1= '' HDNG.1[1,SEC.1.LEN] = SEC.1 HDNG.1[HALF.SIZE - SEC.2.LEN] = SEC.2 HDNG.1[LINE.SIZE - SEC.3.LEN] = SEC.3 * HDNG.1 = HDNG.1[1,LINE.SIZE-5] * HDNG.2= '' HDNG.2[1,L2SC1.LEN] = L2SC1 HDNG.2[HALF.SIZE - RPT1H.LEN] = RPT.HDNG1 * HDNG.3 = SPACE(HALF.SIZE-LEN(RPT.HDNG2)/2):RPT.HDNG2 HDNG.4 = SPACE(HALF.SIZE-LEN(RPT.HDNG3)/2):RPT.HDNG3 HDNG.5 = SPACE(HALF.SIZE-LEN(RPT.HDNG4)/2):RPT.HDNG4 PAGE.CNT = 0 LINE.CNT = 99 * *#* END OF GENERIC HEADINGS * * Now make what would normally be headings in a program, into PICK headings HDNG.1 := ':'PL':' HDNG.2 := ':'L':' HDNG.3 := ':'L':' HEADINGS = HDNG.1:HDNG.2:HDNG.3 RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Monday, March 12, 2007 06:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reports In Universe BASIC Can't wait for the answers on this one. My submissions are: 1. External SSELECT then report formatting in Basic. 2. Parameters gathered in BASIC then report formatting in Basic. 3. Parameters gathered in BASIC then create an EXECUTEable TCL statement for the report. This thread should get interesting. Refer to last week's Anita
RE: [U2] How much RAM is too much
Okay. I see now. The real benefit would be putting more memory on the SQL boxes. The UV box won't be the bottleneck for your processing ability. It's going to be the slow network and the speed of the SQL systems. For UV, you'll probably get just as much out of 2 gigs as you will 4 gigs, or more. Delphi may benefit from more, I don't know. I would still try to get as fast a network card as you can in the off chance that they want to experiment later on, with the SQL servers. Just make sure it will automatically step down to whatever they are currently using. Of course a fast processor would be good, especially when they start thinking they can put additional applications/services on this new box. But it's hard to control that and almost inevitable no matter where you go. Anyway, that's my take on what I think is your situation. Take it with a grain of salt but I don't think I'm very far off, if at all. Hope that helps. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 2:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How much RAM is too much Bob, I can't change the SQL boxes or the network. The only place I can help myself is in the layout for the new box. The new box will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network. The thing is, I can say 2GB memory or 4GB memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck 64K Barouch Bob Woodward wrote: Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers. Of course I may need a mental reset, too. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] How much RAM is too much
Hi Chuck What version of SQL Server? Also are they running Windows 2003 or Windows 2000. Win2003 can make better use of memory than Win2000. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
FILEINFO always returns the correct fully resolved path (without any double dots) under Universe on Unix. Maybe this problem only affects Windows. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 13 March 2007 6:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
unclassified: [U2] How much RAM is too much
Chuck, If the UV box is running XP Pro, 2Gb is your upper RAM limit. The OS will take 3 Gb on the box but only address the first 2 Gb it finds. Run a dual core AMD processor with some nice fast SCSI HDD. RAID 10 is fast but expensive. A pair of large drives mirrored will do the trick if the DB doesn't grow too fast. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Tuesday, 13 March 2007 10:57 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] How much RAM is too much Bob, I can't change the SQL boxes or the network. The only place I can help myself is in the layout for the new box. The new box will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network. The thing is, I can say 2GB memory or 4GB memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck 64K Barouch Bob Woodward wrote: Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers. Of course I may need a mental reset, too. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects / Read Timeout
Tony, Great idea. I have the added luxury that the user will not interact with this program. My goal is to bounce the line items to a sql table during non-business hours then after some digestion serve that up to the user through standard sql queries to the now static data in the tables. I plan to look at this async approach. Perhaps write a scheduler job that will output to a saved list then set a flag or signal through a socket as Kevin King proposed. Thanks for your help. Jeff On Mon, 2007-03-12 at 14:02 -0700, Tony Gravagno wrote: Jeff Powell wrote: I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. If it looks like you're going to be pushing timeouts significantly then it might be best to approach this asynchronously. Send the selection to a phantom on the server, generate a list, then use the list to process items from the client. Don't just phantom off the selection. Have a program do the selection, then write a unique tickler item when the selection is done. Your UO code can read for this item for some period of time, provide entertainment for the user between pings (hourglass, progressbar, some other animation). You can control the timeout simply by stopping the server pings and asking the user what they want to do. I've done this for long running reports called from web clients. If it takes more than about 20 seconds, or if there is a flag manually set that indicates a given report will undoubtedly take more than 20 seconds, I don't make the user wait. I give them a page they can check to see if their report is complete. For very long reports you can send an email with a link when a report is complete, or your remote client interface can periodically check pending reports from menus or other places, so that you can inform the user on-screen when a previous request is ready. HTH TG@ removethisNebula-RnD.com --- 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] UniObjects / Read Timeout
Thanks Brian. It's set to six minutes (3600). That's the default. Can you tell me what the Max value is? By the way I didn't get this message until after 6 CDT. I think the list is slow today. Thanks again. On Mon, 2007-03-12 at 19:53 +, Brian Leach wrote: You might want to take a look at the unirpcservices file on the server. This is a text file located in the unishared directory. The last entry on each line is a timeout value in 1/10th seconds. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: 12 March 2007 16:17 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects / Read Timeout I am running a long select via UniQuery and I'm getting a timeout. Is there a parameter I can change to increase the timeout? This operation will be done during the server's low utilization period. I'm using uniobjects for java on a linux (rhel es4.5) server connecting to unidata on a rs/6000 aix 5.3. Thanks. --- 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] How much RAM is too much {Unclassified}
Chuck, You can say 2GB or 3GB, but unless you're using a 64-bit CPU (I think they all are, now) and a 64-bit O/S (which XP professional is not), you can't effectively use more than 3GB, even though the box will probably address 4GB (or even more) happily. A 32-bit O/S like Windows uses a 4GB address space, but the 'top' 1GB of the address space is reserved for the O/S itself. I think you can buy XP Pro 64-bit Edition, which would address as much RAM as you can stuff into the box, but I doubt it would buy you much extra throughput. Be a fun bench-mark, though! Two dual-core, CPUs would probably give you less memory contention than one quad-core. I'd configure the disks as one mirror pair for the O/S, UV software etc (C:\ drive), and another mirror pair, or RAID-5 set, for your data (D:\ drive). If you're using UV transaction logging, put that on a third set of disks (E:\ drive). Buy the fastest disks you can get (15,000 rpm), put them on the fastest hardware RAID controllers on the fastest I/O channels (PCI-X) you can configure, and install as much battery-backed cache on the controllers as you can. You say the SQL servers are on a 'slow' network. Any chance of setting up another network segment with Gigabit LAN cards and a cheap GB switch, just for this work? HTH Mike -Original Message- From: [EMAIL PROTECTED] Behalf Of Charles Barouch Sent: Monday, March 12, 2007 2:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How much RAM is too much [snip] The thing is, I can say 2GB memory or 4GB memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck 64K Barouch The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #1538
Hi Susan, When in Universe on windows, you can view the voc entry for UFD. Attribute three (3) will have the path. Of course you will need to strip out the DICT filename or extract it via FIELD(vocRec3,'\',1,COUNT(vocRec3,'\')). CT VOC UFD UFD 0001 F 0002 . 0003 C:\IBM\UV\D_UFD Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 13 March 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: U2 Users Digest V1 #1538 Hi Everyone. On help with file pointers thanks to everyone who has pitched in. So far I'm no joy. FILEINFO doesn't return just a hard path. STATUS doesn't seem to return anything. Ls -I might do the trick on UNIX but I need a Windows solution, too (and first). I think I can do the peel back/parsing thing. Was hoping not to have to do that. Anybody got anything else? Susan --- 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] Test - Please Disreguard
Hello U2 World Mark City of Salem Salem, Va --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
