RE: [U2] RE: English phrases
No, they don't... PA LIST MASTER _ BY ATTR1 _ BREAK.ON ATTR1 _ ATTR2 _ TOTAL ATTR3 _ HEADING this is the best heading you ever saw 'D'PAGE 'PLL' _ ID.SUP _ DET.SUP _ LPTR Works a bomb! (provided of course you have a file called MASTER with dict items ATTR1, ATTR2, ATTR3, AND ATTR3 is numeric ;-) Oh, yeah - put a space before each '_' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: 24 July 2008 07:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: English phrases Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
I can see that there can be better sorting methods out there, and possible faster. I see some places that uses c sort and locate methods for uses 1+ records and using bubble method could be fatal to the system. At most we used this subroutine couple times a year for certain applications and if that for under 1000 records. At times, we just used BY @ID or @I-TYPE for sorting. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Friday, July 25, 2008 10:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Basic SORT() Function not avail in UniVerse? Given my age, I've used many manual sort methods (including bubble) years and years ago. Ever since I could LOCATE with the optional sorting parameter, I've never put a bubble sort in MV programs. VB and QB yes. MV, No. My 2 cents. Mark Johnson - Original Message - From: DAVID WADEMAN [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, July 22, 2008 12:59 PM Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CAPTURING TOXML
I'm on Unidata and XMLEXECUTE is available. Do you use Javascript on the browser side to process the XML? Also do you send a DTD or XSD file with the XML? Sarah Burns said: You may like to investigate XMLEXECUTE() which allows you to get around a lot of your difficulties. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Data Editor
I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Green Software - Green Business
The definition of a bureaucrat is one who photocopies their documents before shredding them. A former employer of mine used to have me print inventory lists every Friday; about 400 pages times about 30 users. Decollating four-part carbon paper was a riot. Talk about a carbon footprint! I finally convinced the boss that giving 30 people terminals with an inventory display (updated in real-time) was cheaper and more useful than all that printing. I still had to print one copy for each branch in case the computer (or more often, a phone line) went down. -- Louie On Fri, Jul 25, 2008 at 4:28 PM, Jeff Powell [EMAIL PROTECTED] wrote: ... We are trying to go paperless. We print thousands of sheets of paper, then scan and shred them once we're done writing on them. ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Data Editor
Honestly, I have always just used the native editor (ED or AE). For things in Unix dirs, I have mapped netwok drives to key places to my PC, then I use and Window editor that strikes my fancy. Note that AE has some nice features like exploding multi-value into fields for viewing/editing. -- Sent using BlackBerry - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Mon Jul 28 15:46:43 2008 Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- 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] XML result
Has anyone seen this error when trying to view an XML file from Unidata in IE7? Cannot view XML input using XSL style sheet The content of the XML result looks reasonable to me. (As if I would know). ?xml version=1.0? xsd:schema xmlns:xsd=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified xsd:annotation xsd:documentation xml:lang=en account: /NTN/DATA/PRODUCTION command: SORT PURCHASE-ORDER_MA BY MGR_NAME BY E_A_ACCTN BY CREATE_DATE WITH (DATE_RCVD = '7/1/08' AND DATE_RCVD = '7/31/08') OR WITH (CREATE_DATE = '7/1/08' AND CREATE_DATE = '7/31/08') AND WITH PO_NUM = '041043*025' PO_NUM MGR_NAME E_A_ACCTN ID.SUP TOXML WITHSCHEMA /xsd:documentation /xsd:annotation xsd:element name=ROOT xsd:complexType xsd:sequence xsd:element ref=PURCHASE-ORDER_MA minOccurs=0 maxOccurs=unbounded/ /xsd:sequence /xsd:complexType /xsd:element xsd:element name=PURCHASE-ORDER_MA xsd:complexType xsd:attribute name=PO_NUM type=xsd:string/ xsd:attribute name=MGR_NAME type=xsd:string/ xsd:attribute name=E_A_ACCTN type=xsd:string/ /xsd:complexType /xsd:element /xsd:schema ?xml version=1.0? ROOT xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; PURCHASE-ORDER_MA PO_NUM = 041043*025 MGR_NAME = ATS E_A_ACCTN = 3.759510603.899.00/ /ROOT Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Data Editor
Hi Bill, I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. We have an editor that is very much like the EDFS editor of Prime Information and PI/open. It's not free but neither is it expensive at US$100 for a permanent unlimited licence for multiple servers at a single location. Our users claim some fairly big productivity improvements compared to use of AE. The UPDATE.RECORD tool might be of interest too. Visit www.ladybridge.com and follow the links for the SED editor in the UniVerse Toolkit. An evaluation copy is available. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor
That is using a WinXP or Vista client connecting to data on a HP-Ux back-end. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Monday, July 28, 2008 3:47 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- 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] Data Editor AD
Bill, AD Both we, and most of our customers, use Accuterm from Accusoft Enterprises - www.asent.com. Accuterm runs on a telnet or ssh connection and includes a windows editor (eg. Notepad) for ease of use. A 30-day eval. copy is available from their web site. It can be purchased directly from Peter Schellenbach at Accusoft or from us or any other Accuterm Reseller on a single-user or a site license basis. Please let me know of you would like any additional information. /AD hth, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, July 28, 2008 12:46 PM Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- 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] CAPTURING TOXML
Following on from Mike Henderson's post... Maybe the best idea is to use GETXMLSUB itself as your subroutine call. It handles the case where the XMLExecute function returns a fail status, but a subsequent XMLGetError function doesn't have an error code by assigning a new error code of 80120 and an errmsg of query/sql syntax error. It has 6 arguments documented in the code as follows - 006: * argument count 6 007: * 008: * input 1 CMD the LIST/SELECT command used to generate xml doc 009: * input 2 options: any dynamic array like string to store options for the TOXML 010: * command 011: * output 3 XMLSTR, result xml document 012: * output 4 XSDSTR, result xsd schema 013: * output 5 RTNCODE. 014: * output errmsg if RTNCODE 0 Regards, Keith --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] XML result
Are there intentionally 2 documents in the same file? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Editor AD
shameless plug I can attest to the value of Accuterm's editor. The part I liked most is that if the session was lost due to TCP/IP problems accuterm automatically kept a backup copy right up to the very last keystroke before the session went out. It also has a very nifty screen generator that creates a windows screen for data entry. I never got around to using it but I have a friend that has done some wonderful stuff with it. And it has other useful stuff like being able to save color schemes with different names so you can have one session with one color in one account and a different color in another account so you always know by color validation what account you're in. IMNSHO, the best bank for the buck in the marketplace! /shameless plug And no, I'm not paid to say the above :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Taylor Sent: Monday, July 28, 2008 14:06 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Data Editor AD Bill, AD Both we, and most of our customers, use Accuterm from Accusoft Enterprises - www.asent.com. Accuterm runs on a telnet or ssh connection and includes a windows editor (eg. Notepad) for ease of use. A 30-day eval. copy is available from their web site. It can be purchased directly from Peter Schellenbach at Accusoft or from us or any other Accuterm Reseller on a single-user or a site license basis. Please let me know of you would like any additional information. /AD hth, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, July 28, 2008 12:46 PM Subject: [U2] Data Editor I expect that there are some tools to view and edit UniVerse data that would work on HP-Ux 11i v2. I need to know what is available, both free and not free. --Bill --- 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] Data Editor
Could we get links to multivalue vendors (who wish them) on the U2UG Knowledge Base page or somewhere? It is a crying shame that all these nifty multivalue tools are out there, and one only stumbles across them in miscellaneous posts. Also multivalue software packages. We have users with thousands of hours (millions?) of experience in the multivalue world, and we seem to be intent on keeping it all a secret. -- Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CAPTURING TOXML {unclassified}
Mike beat me to it. The reason that the call is case sensitive is because that's how it's cataloged in VOC. No problem making a copy of the verb in VOC with an all upper-case name. And, yes, FOUR arguments. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/