[U2] [UD]Error Codes
Hi, we are trying to find a way to capture results from our nigthly batch runs to a log file. That log file is then read to trigger warnings or critical alarms. We'd like to use the RETURNING clause in the EXECUTE statement to capture output from the batch programs. I'll show an example to make things clear: CMD = RUN BP BED.TEST EXECUTE CMD RETURNING AN_ARRAY AN_ARRAY might then look like this: 388}BP/_BED.TEST}65~958}13~ I have come to the conclusion that 65 is the row number where the program crashes but the other fields doesen't tell me much(apart from the program name that is). Does anyone know where I can find information about this so that we can interpret the returning array. The documentation just tells me that: -Note- The error message numbers you capture with RETURNING will vary, depending upon which version of UniData you are running. We are on Unidata 5.2 on Solaris. Bjvrn Eklund --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Open Excel and Import a file or execute a command from a local PC
Ralph, 1. There are some reporting tools that will do this: mvQuery for one. 2. If you are using UniVerse 10, you can generate XML out of RetrieVe and SQL. Take a look at the TOXML ATTRIBUTES syntax. This goes to screen, but you can divert this to file using a paragraph to do a DIVERT.OUT ON filename itemname.xml TTY.OFF before you run the command. (Incidentally I've just done an article on this for the upcoming U2UG knowledge base.) 3. There are utilities that generate comma or tab delimited files. DOWNLOAD from Cedarville is often cited: otherwise I can send you a utility command I use. Another technique is to create a temporary dictionary item (e.g. an EVAL expression) with an expression that includes all the fields you need with commas between, and do a SELECT SAVING on that to generate the delimited data. 4. All of these (except the first option) generate the necessary data to a delimited file on the server. Getting that onto the PC depends on how you are set up: networked drives, terminal emulator to upload, or use VBA with UniObjects to pick up the file: the latter using the SequentialFile object. The final choice really depends on what you have installed and how you want to use it. 5. If you are using comma or tab delimited data, make sure that your first column doesn't say 'ID'. Excel will assume this is a SYLK file (ignoring the file extension) and will spit it out. 6. Finally, you could use UniOleDB/ODBC as an Excel data source, if you are willing to spend time setting up the account and don't mind waiting until the end of time for it to complete ... Regards, Brian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton Sent: 28 July 2005 00:06 To: u2-users@listserver.u2ug.org Subject: [U2] Open Excel and Import a file or execute a command from a local PC Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph - Start your day with Yahoo! - make it your home page --- 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] Text extraction.
Mark, I usually split the difference and use: NEW=ABC:REC[15,LEN(REC)] It will always exceed (NEW=ABC:REC[15,100] could theoretically truncate) but it rarely exceeds by a ridiculous amount. - Chuck Nothing Exceeds Like Excess Barouch Mark Johnson wrote: Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD]Error Codes
[EMAIL PROTECTED] wrote on Thu, 28 Jul 2005 09:04:08 +0200 We are trying to find a way to capture results from our nigthly batch runs to a log file. That log file is then read to trigger warnings or critical alarms. We'd like to use the RETURNING clause in the EXECUTE statement to capture output from the batch programs. You might want to use the CAPTURING clause as well, e.g. EXECUTE COMMAND CAPTURING CRT.TEXT RETURNING ERR.CODES The CAPTURING clause will return anything that would normally be sent to the terminal, including the human-readable error messages. Under UniData, the RETURNING clause includes any spooler entry numbers created as well as the error codes. --Tom Pellitieri Toledo, Ohio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.3 and Windows 2003 service pack 1
Tony, I have converted three sites to UniVerse 10.1.11 on Windows 2003 SP1 over the past month and have had no problem with the core UniVerse. However each time I am unable to create a tape device in UniAdmin for my migrations. I receive the message Unable to write device record to DEVICE. I have to from TCL manually create the device in DEVICE. UniAdmin shipping with UniVerse 10.1.11 is UniAdmin 1.3.1. I am only seeing this on 2003 server w/ Service Pack 1. Not exactly 10.1.3 but thought I would pass this info along. Paul H. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Caufield Sent: Wednesday, July 27, 2005 11:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.3 and Windows 2003 service pack 1 Has anybody installed service pack 1 for server 2003 on a box running 10.1.3 and if so did you have any issues. Thanks Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- 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] [UD]Error Codes
The RETURNING clause returns a multi-attributed array of error codes, one attribute for each error. The attributes themselves may be multivalued, depending on the error. The first value is the error code, as found in ERRMSG/ENGLISH.MSG. Any other values are data to be inserted in the error message. For example, using your example below, 388 is the ERRMSG ID. 388 is: Top of 388 in ERRMSG, 5 lines, 22 characters. *--: P 001: HIn 002: A 003: H at line 004: A 005: H Bottom. The 'A' in the ERRMSG item is where the other values are inserted. So your message would be: In BP/_BED.TEST at line 65 This tells you where the error occurred. The error code following 388 is the actual error. In your example below it is 958 with 13 being inserted in the message (index: 13 to one dimension matrix is out of range). Not all errors are preceded by 388, only those generated by UniBasic errors. Also, other error codes of an informational nature will be in the RETURNING array, such as 41 (n records selected to list n) if a SELECT command is executed, or 10043 (Added \@ID\, the default record for UniData to DICT filename) if a file is created. This is for UniData 6.1.10, though it also applied for 4.1.22 and 5.2.28. We're on HP-UX. HTH, Dean Dean Armbruster Ferguson Enterprises, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjvrn Eklund Sent: Thursday, July 28, 2005 3:04 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UD]Error Codes Hi, we are trying to find a way to capture results from our nigthly batch runs to a log file. That log file is then read to trigger warnings or critical alarms. We'd like to use the RETURNING clause in the EXECUTE statement to capture output from the batch programs. I'll show an example to make things clear: CMD = RUN BP BED.TEST EXECUTE CMD RETURNING AN_ARRAY AN_ARRAY might then look like this: 388}BP/_BED.TEST}65~958}13~ I have come to the conclusion that 65 is the row number where the program crashes but the other fields doesen't tell me much(apart from the program name that is). Does anyone know where I can find information about this so that we can interpret the returning array. The documentation just tells me that: -Note- The error message numbers you capture with RETURNING will vary, depending upon which version of UniData you are running. We are on Unidata 5.2 on Solaris. Bjvrn Eklund --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.3 and Windows 2003 service pack 1
Tony, UniVerse 10.1.3 is not certified for 2003 SP1. Don't know if you would have any problems but if you do you will not be on a supported platform. That is something to think about. I would suggest upgrading to 10.1.11 which is certified for 2003 SP1. If you experience any issues, you are top dead center on a supported platform. Ray -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Caufield Sent: Wednesday, July 27, 2005 11:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.3 and Windows 2003 service pack 1 Has anybody installed service pack 1 for server 2003 on a box running 10.1.3 and if so did you have any issues. Thanks Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV 10.1.3 and Windows 2003 service pack 1
Paul, Tony, The same thing happens on Win XP Pro, Win 2000 Server and Win 2000 Pro, and the solution is the same as you described for Win 2003. Also, once hacked into DEVICE, any changes (eg. block-size, for example) must also be hacked into DEVICE. Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Paul Hamrick [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, July 28, 2005 5:52 AM Subject: RE: [U2] UV 10.1.3 and Windows 2003 service pack 1 Tony, I have converted three sites to UniVerse 10.1.11 on Windows 2003 SP1 over the past month and have had no problem with the core UniVerse. However each time I am unable to create a tape device in UniAdmin for my migrations. I receive the message Unable to write device record to DEVICE. I have to from TCL manually create the device in DEVICE. UniAdmin shipping with UniVerse 10.1.11 is UniAdmin 1.3.1. I am only seeing this on 2003 server w/ Service Pack 1. Not exactly 10.1.3 but thought I would pass this info along. Paul H. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Caufield Sent: Wednesday, July 27, 2005 11:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.1.3 and Windows 2003 service pack 1 Has anybody installed service pack 1 for server 2003 on a box running 10.1.3 and if so did you have any issues. Thanks Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- 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] Open Excel and Import a file or execute a command from a local PC
Thanks David and everyone who responded. I'm trying to set it up so for the user it's transparent. So when they download the file Excel automatically opens it. Thanks again for the ideas. - Ralph David Scoggins [EMAIL PROTECTED] wrote: Ralph, You may be looking for something a little more elegant, but if you generate a comma delimited file and give it a .csv suffix, Excel will just open it. From there you can save as any of the various file types that Excel supports. As for executing a command - I presume you mean *on* the local PC - I believe both Accuterm or Wintegrate have this functionality. If you prefer a DIY approach, map a common drive between host PC, write a batch file that executes your commands to a known location, and then execute it using psexec (http://www.sysinternals.com/Utilities/PsExec.html). In fact, get the whole pstools toolkit while you're there - good stuff. -Original Message- From: Ralph Burton [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 4:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] Open Excel and Import a file or execute a command from a local PC Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? Any way to execute a command from a local PC workstation? Thanks, Ralph --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Bad Address for Breakpoint in Debugger
Hi all, Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Bad Address for Breakpoint in Debugger
... because it's in the middle of a loop? Pete Dick Technology Support www.epicor.com Tel.: +44 (0)1344 468220 Fax: +44 (0)1344 468055 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 28, 2005 4:21 PM To: u2-Users Subject: [U2] Bad Address for Breakpoint in Debugger Hi all, Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Bad Address for Breakpoint in Debugger
Any include files that would confuse the debuggers line numbering? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 July 2005 16:21 To: u2-Users Subject: [U2] Bad Address for Breakpoint in Debugger Hi all, Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- 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] pcl to pdf converter
I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Text extraction.
I used to do this thing that Chuck is advocating, but found that for very long strings, the LEN(..) function was expensive. So I always use 32200 for until the end and ensure that strings never go over this artificial 32K. (Of course, there are variations were such a thing to happen, but it doesn't happen at least in anything that I've designed.) Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Key Ally Sent: Thursday, July 28, 2005 2:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Text extraction. Mark, I usually split the difference and use: NEW=ABC:REC[15,LEN(REC)] It will always exceed (NEW=ABC:REC[15,100] could theoretically truncate) but it rarely exceeds by a ridiculous amount. - Chuck Nothing Exceeds Like Excess Barouch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] pcl to pdf converter
Check out http://www.synergetic-data.com/sdsi.cgi?p=unform we are on 2003 and we just setup a virtual printer that takes our text output and converts it to pcl for a printer or pdf for faxing, email or archiving. Great Guys! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Curt Sent: Thursday, July 28, 2005 9:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- 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] Bad Address for Breakpoint in Debugger
has the source changed since it was last compiled ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 28, 2005 11:21 AM To: u2-Users Subject: [U2] Bad Address for Breakpoint in Debugger Hi all, Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- 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] Text extraction.
On uniVerse to enable -1 as meaning till the end of the string use: $OPTIONS REAL.SUBSTR mysub=longstring[starpos,-1] If you want to disable the -1 as meaning till the end of string, use $OPTIONS -REAL.SUBSTR _ I reject your reality and substitute my own - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- --- 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] pcl to pdf converter
We use a product from Esker Software called VSI-FAX. It converts PCL to pdf on the fly and sends it to a fax machine or email address. It's quite powerful. I wonder if it's cheap. We already owned it when I started and with maintenance the upgrades are free so I've not seen the cost. Karl quote who=Curt I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Bad Address for Breakpoint in Debugger
VLIST the program and make sure source matches object Any include files that would confuse the debuggers line numbering? Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Text extraction.
Oh yes, I forgot to add that if you use the $OPTIONS REAL.SUBSTR you can also use other negative values as the second substring parameter, which then indicates that you want to start the substring extraction from your starting point but extract only until the Xth character from the end. For instance: 0001 $OPTIONS REAL.SUBSTR 0002 X=1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ 0003 PRINT A: :X[11,-1] 0004 PRINT B: :X[11,-5] will result in: A: ABCDEFGHIJKLMNOPQRSTUVWXYZ B: ABCDEFGHIJKLMNOPQRSTUV _ I reject your reality and substitute my own - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- --- 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] Bad Address for Breakpoint in Debugger
I don't know why, but sometimes I will get this message when I have other break points set. I usually just delete (D*) all other break points and then set the new one. HTH, James Hi all, Anyone see why I cannot set a breakpoint at line 60? SIS907: 59:IF BAL.LIST1,ARI.PTR # 0 THEN SIS907: 60: ARI.ID = ARI.LIST1,ARI.PTR SIS907: 61: MAT VARIABLES = SIS907: 62: READ ARI.RCD FROM ARI.FILE,ARI.ID ELSE ARI.RCD = :: 60B Bad address for breakpoint. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Text extraction.
You can still do the reality -1 option on UV reality flavor. I've suggested in the past (Ardent? Vmark? Who remembers?) to allow it on other flavors as well, to no avail. -Dianne Kevin King wrote: I used to do this thing that Chuck is advocating, but found that for very long strings, the LEN(..) function was expensive. So I always use 32200 for until the end and ensure that strings never go over this artificial 32K. (Of course, there are variations were such a thing to happen, but it doesn't happen at least in anything that I've designed.) Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Key Ally Sent: Thursday, July 28, 2005 2:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Text extraction. Mark, I usually split the difference and use: NEW=ABC:REC[15,LEN(REC)] It will always exceed (NEW=ABC:REC[15,100] could theoretically truncate) but it rarely exceeds by a ridiculous amount. - Chuck Nothing Exceeds Like Excess Barouch --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #754
Dear Bruce I have contacts to a Norwgian provider of an SMS Server you can install locally and integrate with whatever. We have not tried it with UD, but it should not be too difficult. You can contact me off list for further infomation Regards Bjorn Johannesen Travelsoft AS International House Center Boulevard DK-2300 Copenhagen S +45 70 22 09 12 [EMAIL PROTECTED] Date: Tue, 26 Jul 2005 15:47:02 -0700 From: Bruce Lunt [EMAIL PROTECTED] Subject: [U2] UD to SMS Hi All, A couple of months ago you all helped me with CALLHTTP and now I am back to ask for help with SMS. The CALLHTTP is working great, btw. We have a division in Malaysia that wants to be able to have their outside sales reps check on their monthly sales goals using cell-phones and/or pda's. The question I have for the U2 world is if this has been done already and if you can give me some guidelines on what to do and what not to do? We see this as either: 1. exporting the sales goals data to an external server that is accessible from the web 2. have the phone send a query to the Unidata system and then receive a reply with the individual's data, on demand. 3. any other ways to approach a solution to this problem, of course. :) The problem that I see with option 1 is that even though we may have some sales reps in the field that want to use the new remote query ability there could be many more that are just as happy without doing anything different from what they already have. If we off-load the data to a web-service then we either have to update everybody's data (possible security concerns) or mark the records of the sales reps that want to participate (still some security concerns) and off-load only the marked ones. Option 2 is more granular but do I have to worry about different protocols or standards used by the different phone services? I hope I have explained myself well enough. Oh yeah, can anyone recommend a good resource for the programming of SMS? Thanks for any and all assistance. Regards, Bruce Lunt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] pcl to pdf converter
A direct PCL to PS conversion is dirty and mangled. You may or may not get exactly the same results between the two on their respective hardware. Ghostscript is free and will do a good job, for a huge range of conversions on *nix or Windows. I highly recommend using it to get your initial design and testing done for the documents. If you want to pay for a shrink wrapped package, then make sure you know exactly what you are getting out of it. Send the vendor some sample PCL and have them e-mail you the PS/PDF results. A custom PCLPS filter is usually employed and everyone writes theirs differently. You may be surprised at the quality drop when you convert a raster based PCL document into a vector based EPS/PS/PDF document. I've been fighting that battle myself for years, converting our old PCL docs into PS/PDF. I've gotten most of our documents stored as HTML templates and EPS images now. html2ps converts them over to PS and I let ghostscript generate PDFs when I need an e-mail or portable file. Glen http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Curt Sent: Thursday, July 28, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- 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] Text extraction.
Glenn, I didn't know about that $OPTIONS setting! Thanks so much for pointing it out!! Too bad UV support didn't mention it to me ages ago when I had called them about it. -Dianne Glenn Herbert wrote: Oh yes, I forgot to add that if you use the $OPTIONS REAL.SUBSTR you can also use other negative values as the second substring parameter, which then indicates that you want to start the substring extraction from your starting point but extract only until the Xth character from the end. For instance: 0001 $OPTIONS REAL.SUBSTR 0002 X=1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ 0003 PRINT A: :X[11,-1] 0004 PRINT B: :X[11,-5] will result in: A: ABCDEFGHIJKLMNOPQRSTUVWXYZ B: ABCDEFGHIJKLMNOPQRSTUV _ I reject your reality and substitute my own - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct Some platforms (Reality, maybe?) had the -1 option on substring extractions; I thought that was clever. Too bad it never caught on, or if it did, I didn't notice. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] pcl to pdf converter
I'm just an U2 novice but I have a software print driver that sets up another printer on your PC that generates a PDF file as the output. The free version includes a screen advertisement that last approximately 7-10 seconds and then disappears. The paid version skips that step. Therefore you could try the free version and if it works purchase the paid version. The software is called PDF995. They have a suitcase of products that might also solve your issue. Let me know if you can't find it and would like more information. Good Luck HTH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Thursday, July 28, 2005 12:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] pcl to pdf converter A direct PCL to PS conversion is dirty and mangled. You may or may not get exactly the same results between the two on their respective hardware. Ghostscript is free and will do a good job, for a huge range of conversions on *nix or Windows. I highly recommend using it to get your initial design and testing done for the documents. If you want to pay for a shrink wrapped package, then make sure you know exactly what you are getting out of it. Send the vendor some sample PCL and have them e-mail you the PS/PDF results. A custom PCLPS filter is usually employed and everyone writes theirs differently. You may be surprised at the quality drop when you convert a raster based PCL document into a vector based EPS/PS/PDF document. I've been fighting that battle myself for years, converting our old PCL docs into PS/PDF. I've gotten most of our documents stored as HTML templates and EPS images now. html2ps converts them over to PS and I let ghostscript generate PDFs when I need an e-mail or portable file. Glen http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Curt Sent: Thursday, July 28, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 7/27/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 7/27/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Text extraction.
No. Because of how strings are implemented within universe, consisting of a structure containing a length value and a pointer to the string, a substring operation is simply an operation (nicely termed 'mid') that returns a new string structure with its pointer at your desired starting point, and setting the length to either the value you passed in or, if that exceeds the length of the original string minus your starting point plus 1, the length is set to that value. When that new string structure pointer is placed into the runtime variable table, memory is allocated and copy of the string is saved and a strlen done (or if NLS some equivilent), creating your new variable. By the way, a len() operation in universe is VERY fast, as it does not do a strlen() or any type of count operation; it simply returns the length value of the string structure set at definition time. Using a len() as the second parameter is probably microseconds faster since the subtraction +1 doesn't have to get done; IMO I don't think it makes much difference. _ I reject your reality and substitute my own - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct Is there any downside to having a very large number that exceeds the actual length of a string to indicate the balance of the string in the [] function. I see: NEW=ABC:REC[15,LEN(REC)-15] versus NEW=ABC:REC[15,100] Just curious. 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] [UD] Can a pgm tell what started it?
From within a UniBasic program, is there a way to determine what started it, i.e. a proc, a paragraph, or another UniBasic pgm? UniData 5.2 and 6.1 HP-UX Long story: When using COPY with a select list active, COPY will prompt get id's from select list:firstID(Y/N)?. The exception is: COPY will not prompt if executed from a proc. We need a program to act just like COPY. To do so, we need to emulate the above feature, but we need to know what the executing process is. We don't see any @variables or SYSTEM calls to help us. We've tried PROCREAD, but if the proc was more than 1 level away, i.e. the COPY executed by a program executed by a proc, the PROCREAD is true but COPY reacts as called from a program and issues the prompt. SYSTEM(49) doesn't show procs. @SENTENCE and @PARASENTENCE are inconclusive. AFAIK, there are no UDT.OPTIONS that affect how COPY operates. How can a program determine its caller's type? There must be a way, though it may be internal, since COPY can tell. TIA, Dean (sick and tired of Sarbanes-Oxley) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [JOBS] Systems Analyst Position
Ohio Dominican University in Columbus Ohio has an opening for a Systems Analyst position. ODU is a Colleague R17, Ben 5.1 site running Sun Solaris 8 and Unidata 6.0. Please see attached Job Description. We would like to fill this position as soon as possible. Please send cover letter, resume and three references to [EMAIL PROTECTED] Thank you, Terrie * Terrie Wronkiewiczvoice: 614.251.4669 Database Systems Administrator fax: 614.253.3453 Ohio Dominican University Datatel Coll R17, Ben 5.1 1216 Sunbury Road Solaris 8, Unidata 6.0 Columbus, OH 43219-2099 Envision 4.7.1.8 [EMAIL PROTECTED] EasySpooler 6.2.2 Life has loveliness to sell, all beautiful and splendid things, ... And children's faces looking up holding wonder like a cup. --Sara Teasdale * [demime 1.01d removed an attachment of type application/msword which had a name of System Analyst Job Desc.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] pcl to pdf converter
For our 'Kourier Publisher' product we use PCL2PDF from Visual Software (over in the UK) - Essentially, in a nutshell, our software 'hijacks' the output (reroutes to a hold file), sends that hold file through PCL2PDF, builds an email document (from text or html), attaches the pdf file, and then sends it to the email server. I maintain our existing Form Overlays and design new ones for customers and when I need to get approval or send a sample out I use CutePDF Writer which I acquired for free from their website. It's perfect for me to 'print' a file on my PC to my CutePDF printer driver (generates and saves the pdf doc) and then to email the pdf to the Salesrep or Customer. There are not any watermarks or anything on the free version from CutePDF. They do have versions and services they charge for. Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Curt Sent: Thursday, July 28, 2005 9:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- 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] pcl to pdf converter
Curt, We use Pcl2PDF from http://www.visual.co.uk heavily; it works perfectly on our PCL forms, it runs on multiple OS's, and it's priced reasonably. We evaluated many other converters before finding this one. Highly recommended. Jim Adrig Document Systems, Inc. The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. ~Stephen Hawking -Original Message- Date: Thu, 28 Jul 2005 12:08:08 -0400 From: Curt [EMAIL PROTECTED] Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [JOBS] Systems Analyst Position
Could you send a embedded plain text version of the job description? The list server doesn't let attachments through. Thanks, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 07/28/2005 04:40:06 PM: Ohio Dominican University in Columbus Ohio has an opening for a Systems Analyst position. ODU is a Colleague R17, Ben 5.1 site running Sun Solaris 8 and Unidata 6.0. Please see attached Job Description. We would like to fill this position as soon as possible. Please send cover letter, resume and three references to [EMAIL PROTECTED] Thank you, Terrie * Terrie Wronkiewiczvoice: 614.251.4669 Database Systems Administrator fax: 614.253.3453 Ohio Dominican University Datatel Coll R17, Ben 5.1 1216 Sunbury Road Solaris 8, Unidata 6.0 Columbus, OH 43219-2099 Envision 4.7.1.8 [EMAIL PROTECTED] EasySpooler 6.2.2 Life has loveliness to sell, all beautiful and splendid things, ... And children's faces looking up holding wonder like a cup. --Sara Teasdale * [demime 1.01d removed an attachment of type application/msword which had a name of System Analyst Job Desc.doc] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Timothy Snyder/Philadelphia/IBM is out of the office.
I will be out of the office starting 07/26/2005 and will not return until 08/01/2005. I will respond to your message as soon as possible. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Personal edition
Hi -- we are looking at decomissioning one of our unidata apps but we need to keep the data around for tax department access and occasional queries and reports Only 1 or 2 users. Would PE be a good tool for this? What sort of GUI query tools would be available? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Text extraction.
Mark, I know you usually look for cross platform solutions, so this may be a UVism but how about NEW=ABC:REC[15,-1] Then you have no constant limits to worry about. Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Text extraction.
Thanks. I'll try this and get back with the MCD and MvBase results. D3 didn't like it. Speaking of D3, I tried the REMOVE that was so popularly offered on this forum. The AP-Pro and D3 manuals identically suggest it but it didn't compile (BASIC or compile). I hate to venture into this arena but someone offered to use $OPTIONS EXT to get the REMOVE to work on D3. Without the $OPTIONS, it doesn't work. I found a caveat though: Program 1 X= ; FOR I=1 TO 20 ; XI=I ; NEXT I L=0 LOOP REMOVE A FROM X AT L SETTING D UNTIL D=0 DO PRINT X REPEAT prints 1-19. Program 2 X= ; FOR I=1 TO 20 ; XI=I ; NEXT I L=0 LOOP REMOVE A FROM X AT L SETTING D PRINT X UNTIL D=0 DO REPEAT prints 1-20 as expected. Apparently the value of D gets set to the terminator when it extracts the final value. I'll have to note this else I'll get expected results. Does this behave (misbehave) on u2 systems, ie be careful of the location of the UNTIL statement? Thanks. - Original Message - From: Craig Bennett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, July 28, 2005 7:40 PM Subject: Re: [U2] Text extraction. Mark, I know you usually look for cross platform solutions, so this may be a UVism but how about NEW=ABC:REC[15,-1] Then you have no constant limits to worry about. Craig --- 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] Text extraction.
Does this behave (misbehave) on u2 systems, ie be careful of the location of the UNTIL statement? Mark, that is the documented behaviour, it certainly isn't misbehaving. Yes, you have to be precise about when you terminate the loop, but surely a guy with your experience would always be precise about such things? BTW, is the AT clause something that D3 requires? UniData, UniVerse and jBASE certainly don't. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Personal edition
Goo'day, Last time I looked, not too recently, there was a modulo/separation maximum... And, probably more importantly, isn't u2 PE for private, ie, non-commercial use only?? Might be a spot of bother on both counts. At 11:17 29/07/05 +1200, you wrote: Hi -- we are looking at decomissioning one of our unidata apps but we need to keep the data around for tax department access and occasional queries and reports Only 1 or 2 users. Would PE be a good tool for this? What sort of GUI query tools would be available? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] REMOVE again. (was Text extraction.)
...use $OPTIONS EXT to get the REMOVE to work on D3... I recall Sequioa had REMOVE but the delimiter flag variable had different values. I think 1 meant end of array, for example. e.g. REMOVE A FROM X SETTING D D=1 meant you reached the end. --- Back to U2. 4 comments: 1. As a general rule, instead of testing at the bottom of the loop like this: LOOP REMOVE A FROM X AT L SETTING D PRINT X UNTIL D=0 DO REPEAT I generally prefer to init the flag at the top test immediately. That way, if X happens to be null, you don't do an iteration through the loop D = LEN( X ) ; * true/false (remember LEN() is very cheap) LOOP WHILE D REMOVE A FROM X SETTING D [do stuff with A] REPEAT 2. Establish a convention of ALWAYS resetting the remove pointer (via SETREM or X=X) either always before or always after each such loop. That way you don't step on or get stepped on by the next or previous code that happens to do a REMOVE on this variable. 3. Sometimes variable D as it appears above is called the remove pointer. But really the remove pointer is a hidden thing in memory telling UV/UD where the next datum t remove is. The variable D tells you what kind of delimiter was encountered: 0: end of string 1: item mark, 2: attribute mark etc. 4. Technique for building an ASSOCIATED output string keeping am,vm,sm lined up with the original array: OUT.ARRAY = '' D = LEN( IN.ARRAY ) LOOP WHILE D REMOVE A FROM IN.ARRAY SETTING D OUT = some function of( A ) OUT.ARRAY:= OUT WHILE D OUT.ARRAY:= CHAR( 256 - D ) --- ( See point 3, above ) REPEAT IN.ARRAY = IN.ARRAY ; * reset remove pointer. - cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/