RE: [U2] Outputting XML to a file [uv]
David SORT filename field field TOXML [ELEMENTS] [WITHDTD] Or SELECT fieldlist FROM filename TOXML [ELEMENTS][WITHDTD] There is a short tutorial on using XML with Retrieve on the U2UG knowledge base. (www.mvopen.org/kb) I don't think your version of uv has the 'TO' keyword to capture XML, so use the DIVERT.OUT syntax in the tutorial. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman, David (SAAS) Sent: 07 January 2007 23:21 To: u2-users@listserver.u2ug.org Subject: [U2] Outputting XML to a file [uv] What's the best way of outputting XML to a file (uv 10.0.16, HP-UX) ? I may need to output a DTD, which Cedarville's Download doesn't do, and the uv manual says to send to HOLD or a COMO, but then the output file contains extraneous lines (blanks, and count of records listed) that need to be removed. Is there any better solution ?? Thanks, David Norman Senior Software Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * [EMAIL PROTECTED] --- 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] Outputting XML to a file [uv]
David Sorry, being dumb (bleary-eyed-Monday-morning). You're obviously using TOXML. So your choices are: A) If your version of uv supports it, use the TO keyword: SORT BOOK_TITLES TOXML ELEMENTS WITHDTD TO titles This will create XML titles.xml and XML titles.dtd B) If not, the closest I can get is: ED VOC PA 6 lines long. : p 0001: PA 0002: TERM dumb 0003: DIVERT.OUT ON UFD titles.xml TTY.OFF 0004: SORT BOOK_TITLES TOXML ELEMENTS COUNT.SUP NOPAGE 0005: DIVERT.OUT OFF TTY.ON 0006: TERM vt100 Bottom at line 6. The 'TERM dumb' is to stop it putting a clear screen into the titles.xml. BUT I can't get rid of the initial blank first line that way. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 08 January 2007 09:14 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Outputting XML to a file [uv] David SORT filename field field TOXML [ELEMENTS] [WITHDTD] Or SELECT fieldlist FROM filename TOXML [ELEMENTS][WITHDTD] There is a short tutorial on using XML with Retrieve on the U2UG knowledge base. (www.mvopen.org/kb) I don't think your version of uv has the 'TO' keyword to capture XML, so use the DIVERT.OUT syntax in the tutorial. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman, David (SAAS) Sent: 07 January 2007 23:21 To: u2-users@listserver.u2ug.org Subject: [U2] Outputting XML to a file [uv] What's the best way of outputting XML to a file (uv 10.0.16, HP-UX) ? I may need to output a DTD, which Cedarville's Download doesn't do, and the uv manual says to send to HOLD or a COMO, but then the output file contains extraneous lines (blanks, and count of records listed) that need to be removed. Is there any better solution ?? Thanks, David Norman Senior Software Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * [EMAIL PROTECTED] --- 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] IF Statement in PROCs
Hello, I want to check to see if 2 values in the PROC Buffer are equal, but if I use the line ; IF A1 = A2 GO 40 it assumes the A2 is just a string and wraps it in s. Is there a way of doing this? I'm using UniVerse and the PQN version of PROC. Many thanks. Mark This email is confidential, may also be privileged and is subject to the disclaimer at http://www.microgen.co.uk/email-disclaimer/en.html --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IF Statement in PROCs
Mark IF %1 = %2 G 40 Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Elliott Sent: 08 January 2007 11:48 To: u2-users@listserver.u2ug.org Subject: [U2] IF Statement in PROCs Hello, I want to check to see if 2 values in the PROC Buffer are equal, but if I use the line ; IF A1 = A2 GO 40 it assumes the A2 is just a string and wraps it in s. Is there a way of doing this? I'm using UniVerse and the PQN version of PROC. Many thanks. Mark __ __ This email is confidential, may also be privileged and is subject to the disclaimer at http://www.microgen.co.uk/email-disclaimer/en.html --- 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] IF Statement in PROCs
Doh! I should really know this, but have never needed to compare procbuffer values in the 16years of using Pick/UniVerse. Thanks, Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 08 January 2007 12:23 To: u2-users@listserver.u2ug.org Subject: RE: [U2] IF Statement in PROCs Mark IF %1 = %2 G 40 Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Elliott Sent: 08 January 2007 11:48 To: u2-users@listserver.u2ug.org Subject: [U2] IF Statement in PROCs Hello, I want to check to see if 2 values in the PROC Buffer are equal, but if I use the line ; IF A1 = A2 GO 40 it assumes the A2 is just a string and wraps it in s. Is there a way of doing this? I'm using UniVerse and the PQN version of PROC. Many thanks. Mark __ __ This email is confidential, may also be privileged and is subject to the disclaimer at http://www.microgen.co.uk/email-disclaimer/en.html --- 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/ This email was checked by MessageLabs before entering Microgen. This email is confidential, may also be privileged and is subject to the disclaimer at http://www.microgen.co.uk/email-disclaimer/en.html --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Blackberries MS Calendar
Here's the scenario. I'm using BLAT to send regular emails to any address. works fine. I can use the optional -attacht or -attach to attach a text or binary file and it works fine. A client wants their MV system to send MS Outlook/Calendar items to their salesperson's Blackberries. I reverse engineered an ICS file with its tags and data values. When I send the attachment to an email recipient that uses regular Outlook, ie a desktop, they can optionally press Accept on the attached file and it populates their Calendar properly. When I send the same attachment to a Blackberry, it doesn't show up as a calendar item, just as the simple email. It doesn't even show the attachment of which they could open and perhaps accept. Any suggestions within BLAT? I don't want to re-invent the wheel with SENDMAIL or other OS-Level email clients as I may have to spread this solution around my other MV (non-U2) clients. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SOAP and secured HTTP
No it doesn't - if you look at the other api's, that the soap one is built upon, i.e. the http and the socket ones, they both have a opensecure method that you use a security context with. What i have done to do soap on https is use the http api and formulate the soap request manually - not hard just a bit more xml to produce. Rgds Symeon. On 06/01/07, Jason Lin [EMAIL PROTECTED] wrote: Hi. I am currently testing the SOAP API and I noticed that if the web service URL is a secured connection (https), the program will wait indefinitely for response from the web server. On the other hand, if the web service URL uses regular HTTP connection, the SOAP API works just fine. The testing was done in Universe 10.1.2 on HP-UX B.11.00. Does anyone know if Universe's SOAP API works with secured HTTP connection? Thank you. -JL --- 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] IF Statement in PROCs
I don't know. These youngsters... To think I trained you, as well. grin Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Elliott Sent: 08 January 2007 13:34 To: u2-users@listserver.u2ug.org Subject: RE: [U2] IF Statement in PROCs Doh! I should really know this, but have never needed to compare procbuffer values in the 16years of using Pick/UniVerse. Thanks, Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 08 January 2007 12:23 To: u2-users@listserver.u2ug.org Subject: RE: [U2] IF Statement in PROCs Mark IF %1 = %2 G 40 Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Elliott Sent: 08 January 2007 11:48 To: u2-users@listserver.u2ug.org Subject: [U2] IF Statement in PROCs Hello, I want to check to see if 2 values in the PROC Buffer are equal, but if I use the line ; IF A1 = A2 GO 40 it assumes the A2 is just a string and wraps it in s. Is there a way of doing this? I'm using UniVerse and the PQN version of PROC. Many thanks. Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Outputting XML to a file [uv]
We had a similar problem with blank lines in the xml output. Please keep in mind that this is on Unidata 6.0, but we needed to adjust the term settings. The biggest clue will be where the blank lines are occurring. If they are popping up every 23 lines, then you have the same problem that we had. hth -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 800-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- Norman, David \(SAAS\) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/07/2007 06:20 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Outputting XML to a file [uv] What's the best way of outputting XML to a file (uv 10.0.16, HP-UX) ? I may need to output a DTD, which Cedarville's Download doesn't do, and the uv manual says to send to HOLD or a COMO, but then the output file contains extraneous lines (blanks, and count of records listed) that need to be removed. Is there any better solution ?? Thanks, David Norman Senior Software Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Data Replication
We have purchased two new HP boxes that we will be running UniVerse 10.2. We will also be utilizing UniVerse's Data Replication utility. We have had a superior consultant from IBM perform the initial setup. I have contacted IBM support twice and have not been able to get a clear and absolute answer. Question: I have a strong need to be able to (programmatically) query a given file and determine if said file is or is not set up for replication. There is a value in $fileinfo - FINFO$RECOVERYTYPE that implies that this may be what I am looking for, but I am not nearly certain. that it is. My question is two part. First, is the aforementioned value what I am looking for to determine of a file is set up (or not) for replication. If not, does anybody know if this information is retrievable and if so, where. As always, thank you for any help that can be given.. Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2 and Open Insight.
Go to the url below and take look at the press release for Revelation Software and IBM U2. Looks like a new, fully GUI front end to U2. Westwood, NJ - 8 January 2007: Revelation Software today introduced OpenInsight for IBM U2 and announced that under an agreement with IBM, Revelation Software will market and sell the IBM UniVerse and UniData Servers as part of its OpenInsight offering. http://www.revelation.com/Revelation.nsf/28eaa3bb5371386d85256dd6001f2c87/66 d0d9ce0920e2c38525725d0056f792?OpenDocument Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniODBC with ASP error
Hi all, I am working on CAS project that has an error I could not figure out. Does anyone experience call Datatel subroutine with error out on asp page? It bomb out on a S.EVALUATE.PROGRAM subroutine in Unibasic program. On my ASP pages it shows Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]Unidata lower level function error with fetch Best regards, Cody Wang Datatel Programmer Analyst Ohio Dominican University 1-614-251-4799 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Data Replication
Barry, I cannot speak for replication but I do believe that FINFO$RECOVERYTYPE is a flag indicating whether or not the file is recoverable from a transaction logging perspective. IOW.. 0 = transactions are not logged, 1 = transactions are logged. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Monday, January 08, 2007 3:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Data Replication We have purchased two new HP boxes that we will be running UniVerse 10.2. We will also be utilizing UniVerse's Data Replication utility. We have had a superior consultant from IBM perform the initial setup. I have contacted IBM support twice and have not been able to get a clear and absolute answer. Question: I have a strong need to be able to (programmatically) query a given file and determine if said file is or is not set up for replication. There is a value in $fileinfo - FINFO$RECOVERYTYPE that implies that this may be what I am looking for, but I am not nearly certain. that it is. My question is two part. First, is the aforementioned value what I am looking for to determine of a file is set up (or not) for replication. If not, does anybody know if this information is retrievable and if so, where. As always, thank you for any help that can be given.. Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 and Open Insight.
Oddly enough, this announcement was on C.D.P. early this morning. It contained the following two urls. http://www.revelation.com/Revelation.nsf/28eaa3bb5371386d85256dd6001f2c87/66d0d9ce0920e2c38525725d0056f792?OpenDocument and http://www.revelation.com/Revelation.nsf/1f484fef89cd63e1852569c900787d0e/7a9255479fdfc504852572590055da17?OpenDocument Ron White --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 and Open Insight.
Original Message Subject: [U2] U2 and Open Insight. From: Tom Dodds [EMAIL PROTECTED] Date: Mon, January 08, 2007 12:59 pm To: u2-users@listserver.u2ug.org Go to the url below and take look at the press release for Revelation Software and IBM U2. Looks like a new, fully GUI front end to U2. Westwood, NJ - 8 January 2007: Revelation Software today introduced OpenInsight for IBM U2 and announced that under an agreement with IBM, Revelation Software will market and sell the IBM UniVerse and UniData Servers as part of its OpenInsight offering. http://www.revelation.com/Revelation.nsf/28eaa3bb5371386d85256dd6001f2c87/66 d0d9ce0920e2c38525725d0056f792?OpenDocument The U2 connection is really brilliant. OI is 13 years old and matured quite nicely in the last 5 years. Its BASIC+ is very similar to universe basic and dictionaries are very Prime/I like. This is a much better solution than SBs or Accuterms window solutions (oh my). Even if you already have a 'windows' solution (and remember OI also works under linux seemlessly) OI is a good thing to check out .. if only to find out what you are missing G OI is my fav MV environment followed closely by uniVerse .. that being the case why am I on a longterm job with D3 sigh DTsig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] cODE39
I have a program that is reading the table listed below )code339) and printing code39 bar codes from these entries. It takes the SEQ of the character to be printed, extracts the data from the corresponding field of this table and the print a series of ESC characters and the result is a bar code. What I need is to fill in the upper case alpha characters. This table only has a *, 0-9 and B,C characters. Has anyone ever seen the code39 table below and do you have the upper case characters for that table? Thanks in advance for your help. TXT='*':TXT:'*' ; DC=LEN(TXT) FOR CC=1 TO DC N=SEQ(TXT[CC,1]) BNBR=CODE39N ; COLOR=1 FOR C=1 TO 10 WIDTH=FIELD(CODE39.WIDTHS,',',BNBR[C,1]) ; COLOR=NOT(COLOR) PRINT ESC:'*c180B': ; * height PRINT ESC:'*c':WIDTH:'A':; * width PRINT ESC:'*c':COLOR:'P':; * fill PRINT ESC:'*p+':WIDTH:'X': ; * move NEXT C NEXT CC RETURN This is code39 variable. 0042: 1211212111 : P35 0042: 1211212111 0043: 0044: 0045: 0046: 0047: 0048: 1112212111 0049: 211221 0050: 112221 0051: 212211 0052: 1112211121 0053: 211221 0054: 112221 0055: 1112112121 0056: 2112112111 0057: 1122112111 0058: 0059: 0060: 0061: 0062: 0063: 0064: 0065: 0066: 1121121121 0067: 212112 0068: 0069: 0070: 0071: 0072: 0073: 0074: 0075: 211221 Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SOAP and secured HTTP
On Mon, 8 Jan 2007, Symeon Breen wrote: No it doesn't - if you look at the other api's, that the soap one is built upon, i.e. the http and the socket ones, they both have a opensecure method that you use a security context with. What i have done to do soap on https is use the http api and formulate the soap request manually - not hard just a bit more xml to produce. Rgds Symeon. Thanks for the info. I will probably create my own SOAP subroutines with support for secured HTTP. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] cODE39
After a little search on Google, I found the following page: http://www.barcodeisland.com/code39.phtml Which includes a table with the entire Code39 character set and barcode (width) definitions. Your table appears to have a '1' at the end of every character, which I'm guessing represents the narrow intercharacter space required by Code39. Other than that your table of 1's and 2's seems to correspond to the N's and W's (for Narrow and Wide) included in the table on the above web page. Best Regards, Richard B Lewis Sr. Programmer/Analyst Nu Skin Enterprises ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/