Re: [U2] Web services at 11.x
Both consuming web services (soap and otherwise) from within uv and serving as a web service have been in uv for years and years. Consuming is done within data basic - see the extensions manuals. Serving is done either using uniobject.net/java and creating a .net or java webservice (my preference), or using the u2 web services tool. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 13 May 2014 18:11 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to create ASP.NET Web API (Http service/RESTFul) using multi-value .NET Provider and multi-value Visual Studio Add-ins? Consume using HTML5/JavaScript/MVVM/Knockout.js/Json
Removed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of rajank Sent: 03 May 2014 13:32 To: u2-users@listserver.u2ug.org Subject: [U2] How to create ASP.NET Web API (Http service/RESTFul) using multi-value .NET Provider and multi-value Visual Studio Add-ins? Consume using HTML5/JavaScript/MVVM/Knockout.js/Json Please read: http://stackoverflow.com/questions/23434946/how-to-create-asp-net-web-api-ht tp-service-restful-using-multi-value-net-prov http://stackoverflow.com/questions/23434946/how-to-create-asp-net-web-api-h ttp-service-restful-using-multi-value-net-prov http://stackoverflow.com/questions/23434946/how-to-create-asp-net-web-api-ht tp-service-restful-using-multi-value-net-prov Regards, Rajan Kumar -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/How-to-create-ASP-NET-Web-A PI-Http-service-RESTFul-using-multi-value-NET-Provider-and-multi-value-Vin-t p43003.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
The only approach I would consider is via a web service , either hosted on iis or apache, with a uniobjects connection behind it - either uo.net or uo.java. web servers are designed to accept multiple hits, queue them up , offload to threads etc. why reinvent the wheel. One of my companies does adserving and we serve upwards of 20million ads per day using this approach with a .net webservice using uo.net to communicate to a udt host. Hi Everyone, A project that I m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the
Re: [U2] XMAPOpen core dump
I find the most common reason for a core dump when dealing with xml is the lang settings and encoding of the files. make sure they match - I note the xml is utf-8 - firstly check it is indeed utf-8 and there are no upper ascii (above 127) in there. Also make sure you have a lang setting that matches utf-8 lang=c wont work. hth On 4 February 2014 14:44, Bob Little b...@marketamerica.com wrote: I'm testing some XML stuff locally on UV PE 11.2 and I've run into a problem I can't figure out. I hope someone else knows what's going on here and has a work-around. I'm running this test on CentOS 6.5 with UniVerse PE 11.2. I get a core dump as soon as I attempt the XMAPOpen. It appears to only happen when the ColumnMap Node begins with a comma. The same data, map and code works without problem on an AIX machine. MAP ... ?xml version=1.0 encoding=UTF-8? !-- DOCTYPE U2XMAP SYSTEM U2UXMAP.DTD -- U2XMAP Version=1.0 Name=XMAP1 TABLECLASSMAP MapName=M1 StartNode=/RESPONSE TableName=WEATHER ColumnMap Node=/HOME/text() Column=@ID / ColumnMap Node=/FOREIGN/text() Column=FOREIGN / ColumnMap Node=/UNITS,text() Column=UNITS / ColumnMap Node=/NUMBER,text() Column=NUMBER / ColumnMap Node=,INFO,DATE/text() Column=DATE / ColumnMap Node=,INFO,CITY/text() Column=CITY / ColumnMap Node=,INFO,TEMP/text() Column=TEMP / /TABLECLASSMAP /U2XMAP XML DATA... RESPONSE HOMEUSA/HOME FOREIGNTWN/FOREIGN UNITSF/UNITS NUMBER1/NUMBER INFO DATESun, 02 Feb 2014 19:00:00 GMT/DATE CITYTaipei/CITY TEMP40/TEMP /INFO HOMEUSA/HOME FOREIGNCAN/FOREIGN UNITSF/UNITS NUMBER2/NUMBER INFO DATESun, 02 Feb 2014 19:00:00 GMT/DATE CITYToronto/CITY TEMP35/TEMP /INFO /RESPONSE CODE... INCLUDE UNIVERSE.INCLUDE XML.H open 'XML' to xml.file else stop xml.id = temps.xml map.id = temps.map read xml.rec from xml.file,xml.id else crt Can't read :xml.id: from XML file stop end convert @am to '' in xml.rec ERR1=XDOMOpen(xml.rec,XML.FROM.STRING,DOMH) IF ERR1 # XML.SUCCESS THEN crt Can't do XDOMOpen() RETURN END ERR1=XMAPOpen(xml.rec, XML.FROM.STRING, map.id, XML.FROM.FILE, XMAPhandle) IF ERR1 # XML.SUCCESS THEN crt XMAPOpen failed RETURN END This is the top part of the resulting stack dump: *** glibc detected *** /usr/uv/bin/uv: free(): invalid pointer: 0x0031423e *** === Backtrace: = /lib/libc.so.6[0x98de31] /usr/lib/libstdc++.so.6(_ZdlPv+0x22)[0x7dee552] /usr/uv/bin/libu2xml.so(_ZN6U2XMAP10readrecordEP4XMAPPKN11xercesc_3_17DOMNodeE+0x555)[0x304a3d] /usr/uv/bin/libu2xml.so(_ZN6U2XMAP12xmaptorecordEP4XMAPPKN11xercesc_3_17DOMNodeE+0x68)[0x304b84] /usr/uv/bin/libu2xml.so(_ZN6U2XMAP10GenXRecordEv+0x31)[0x304cd5] /usr/uv/bin/libu2xml.so(U2_XMAPOpen+0xfc)[0x2fc29e] /usr/uv/bin/uv[0x847215e] /usr/uv/bin/uv[0x83128d4] /usr/uv/bin/uv[0x81e3a46] /usr/uv/bin/uv[0x81e6620] /usr/uv/bin/uv[0x812d188] /usr/uv/bin/uv[0x8063a1d] /usr/uv/bin/uv[0x81b1a78] /usr/uv/bin/uv[0x805f7a2] /usr/uv/bin/uv[0x804f397] /usr/uv/bin/uv[0x804d475] /lib/libc.so.6(__libc_start_main+0xe6)[0x933d26] /usr/uv/bin/uv[0x804c831] bob little applications architect independent contractor market america, inc. 1302 pleasant ridge rd. greensboro, nc 27409 Phone: 336-698-4367 Cell: 248-675-5515 Skype: boblittle904 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UO.Net unable to login
Can you telnet to the host system on port 31438 from the same client ? Is the client local to the host network, or is there some NAT device in between ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: 25 January 2014 14:55 To: 'U2 Users List' Subject: Re: [U2] UO.Net unable to login Yes, I use the IP address and the Extensible Admin tool connects fine. I will try the old uniobjects next. Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 301-924-5537 301-613-9572 (Cell) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Saturday, January 25, 2014 5:25 AM To: 'U2 Users List' Subject: Re: [U2] UO.Net unable to login Are you using an ip address or a domain name to connect with in txtHost.Text ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: 24 January 2014 22:27 To: u2-users@listserver.u2ug.org Subject: [U2] UO.Net unable to login I am trying to log into a Unix/linux Universe server with Visual Studio 2010 and UO.Net version 2.2.4.7409. I am getting ErrorCode 81011: The host name is not valid. But I can connect with the Extensive Administration tool into the database. So the connection parameters work. Here my connection line: uniSession = UniObjects.OpenSession(txtHost.Text, txtUser.Text, txtPassword.Text, txtAccount.Text, uvcs); With the error this: SocketException caught!!!SystemThis is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server[IBM U2][UODOTNET - UNIRPC][ErrorCode=81011] The host name is not valid, or the host is not responding Source: UniRPCConnection Class Method: Void set_Host(System.String) at IBMU2.UODOTNET.UniRPCConnection.set_Host(String value)\r\n at IBMU2.UODOTNET.UniSession.Connect() I can connect fine to my own Linux/UniVerse system. But this is at a client's site. I am stymied. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/UO-Net-unable-to-login-tp42 541.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
Not this one again -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: 20 December 2013 19:02 To: U2 Users List Subject: [U2] BASIC code - upper, lower, CamelCase, what say you? First off - Merry Christmas and Happy New Year to all. I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for our DesignBais application, and since I'll be starting with a blank code template instead of modifying existing code, and I thought 'hey why not join the 21st century' and make the code look more mainstream, and readable. (falling back on our last TEXMUG presentation by Clif Oliver on refactoring). And considering Universe 11.2 now supports local subroutines and functions, I should make the code look and behave more object-like. Does anyone know of a set of rules or guidelines on how to do this?Just experimenting briefly, Universe BASIC compiler will allow any mix of cases for keywords, but variables are case sensitive. Example: ED BP TEST ABC=1 Abc=2 abc=3 PRINT ABC Print Abc pRiNt abc stop end RUN TEST 1 2 3 So, how are developers mixed case in their code these day? Do keywords, local variables, common variable, equates follow a standard method? thanks in advance, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Tech Alert *TURN YOUR GADGETS OFF* before you get hacked
The exploit is not against any old gadget , it has to be an insecure one in the first place in order to enable an exploit. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Elwood RR Sent: 17 December 2013 03:13 To: U2 Users List Subject: Re: [U2] Tech Alert *TURN YOUR GADGETS OFF* before you get hacked no, but i follow all standard practices to avoid infection, and this was my first virus at home had a few at work when someone opened an invoice, that wasn't really an invoice, clicked on the attachment and the entire company was infected in seconds... norton was unable to remove it, so i loaded up microsoft security essentials which deleted the infected backup .dll and automagically downloaded a new one from the net for the system32 directory and the backup to that. *nice* On 12/16/2013 6:29 PM, Bob Rasmussen wrote: Allen, do you have any evidence that gadgets were the way you got infected? This article: http://www.microsoft.com/security/pc-security/gadgets.aspx seems to suggest that with proper and up-to-date anti-malware software, gadgets are no more dangerous than other installable programs. On Mon, 16 Dec 2013, Allen Elwood RR wrote: Tech Alert *TURN YOUR GADGETS OFF* before you get hacked http://technet.microsoft.com/en-us/security/dn261332 :shock: hacker's found a way to get inside your gadgets and take control of your computer this explains how i got hacked last month - my computer was acting odd and really slow - the hard drive was thrashing like crazy and i knew something wasn't right so i walked to the wireless router and pulled the power cord. did a full disk virus scan and had a couple of really nasty trojans and 250+ spyware apps all active at the same time. wonder WHY it was so slow! :lol: they also got my password to my roadrunner email and started blasting spam, i started getting mail delivery failures, put 2+2=5 together and changed my password. after that i immediately got a spam - kinda like a nanner nanner we got you thing. gadgets off now. i miss them already. the clock gadget disappeared and i started looking around to see what was up and found this alert by Microsoft you know, you'd a thunk maybe they'd let us know??? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Very OT] XP File Dialog Box
Windows 8 is great. You don't have to have the tiles, just use desktop mode, tis the same as windows 7 but better. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 12 December 2013 20:17 To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box Windows 8 suks Anyone give any good points that makes Windows 8 worthwhile? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, December 12, 2013 3:13 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box If you plan to go to Windows 7, you better move fast. Microsoft announced that the company discontinued the distribution of retail copies of Windows 7 at the end of October 2013. Microsoft had previously listed that date as October 31, 2014, but changed that information. http://www.foxnews.com/tech/2013/12/10/microsoft-ends-windows-7-retail-sales -directs-consumers-to-windows-8/ JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Basic parsing xml with XDOM commands
I have found in the past the handling of namespaces in both the XDOM commands and the EXT files, is not well documented, and does not always work how I expect. So I usually preprocess any such XML files with xsltproc to remove the namespaces - an example xsl to do this is xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xsl:output method=xml version=1.0 encoding=UTF-8 indent=yes/ !-- keep comments -- xsl:template match=comment() xsl:copy xsl:apply-templates/ /xsl:copy /xsl:template xsl:template match=* !-- remove element prefix -- xsl:element name={local-name()} !-- process attributes -- xsl:for-each select=@* !-- remove attribute prefix -- xsl:attribute name={local-name()} xsl:value-of select=./ /xsl:attribute /xsl:for-each xsl:apply-templates/ /xsl:element /xsl:template /xsl:stylesheet -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 06 November 2013 02:01 To: U2 Users List Subject: [U2] UV Basic parsing xml with XDOM commands Hi Everyone, Thought I'd post a solution to a task I've been working on in the hope it will assist someone else with similar requirements. Thanks also to those who've previously posted on this as I found the following to be most helpful as well: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg18895.html https://gdoesu2.wordpress.com/tag/xdomlocate/ http://listserver.u2ug.org/pipermail/u2-users/2010-September/004713.html http://www.mvdeveloper.com/kb/docs/kb10.pdf I had to parse some xml returned via a soap request to an IIS server: ?xml version=1.0? s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; s:Body SuggestResponse xmlns=http://tempuri.org/; SuggestResult xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category. Contracts xmlns:i=http://www.w3.org/2001/XMLSchema-instance; a:CategoryGroupSome group data/a:CategoryGroup a:CategoryNameSome name data/a:CategoryName /SuggestResult /SuggestResponse /s:Body /s:Envelope There are only ever 2 value nodes returned if the soap query is successful with the SuggestResult node containing 'i:nil=true' if the query is not successful. e.g. SuggestResult i:nil=true ... / The xml contains a default namespace and after much searching and trial and error I discovered I needed to use the following xpathString and nsMAP parameters in the XDOMLocate function: Notes re the XDOMLocate function. I found the UV11.1 Basic Commands Reference and Basic Extensions documents for XDOMLocate to be scarce on detail for the following: * Each additional namespace in the string must also be space delimited. * The double quotes enclosing the http url must be removed for each namespace defined in the nsMAP parameter. The description given has double quotes in the wrong places. e.g. if you have s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; then the namespace you need to specify is nsMAP = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/' code xpathStr = '/s:Envelope/s:Body' nsMAP = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/ ' nsMAP := 'xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category. Contracts ' nsMAP := 'xmlns=http://tempuri.org/ ' nsMAP := 'xmlns:i=http://www.w3.org/2001/XMLSchema-instance' OK = XDOMOpen( RespData, XML.FROM.STRING, hDOM ) if OK = XML.SUCCESS then crt 'XML document opened' OK = XDOMLocate( hDOM, xpathStr, nsMAP, hRoot ) if OK = XML.SUCCESS then crt 'Found ':xpathStr OK = XDOMGetNodeName( hRoot, NodeName ) crt 'Root node=':NodeName OK = XDOMLocateNode( hRoot, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hParent ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hParent, NodeName ) crt 'Parent node = ':NodeName ;* 'SuggestResponse' OK = XDOMLocateNode( hParent, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hChild ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hChild, NodeName ) crt 'Child node = ':NodeName ;* 'SuggestResult' OK = XDOMLocateNode( hChild, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hValueNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hValueNode, NodeName ) crt 'Value node1 = ':NodeName ;* 'a:CategoryGroup' OK = XDOMLocateNode(hValueNode, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.TEXT.NODE, hTextNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeValue(hTextNode, Value ) crt 'Payload1 = ':Value ;* 'Some group data' end else gosub ShowError end end OK = XDOMLocateNode( hChild,
Re: [U2] Ref: Web Services at Universe 11.n
Sound advice from Ian there - I see many people getting unstuck when using web services through many layers of abstraction, basically because they don't understand what a web service is what http is etc. I would recommend learning about WSDL, XML, HTTP and try a few things out in different ways. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: 31 October 2013 22:09 To: U2 Users List Subject: Re: [U2] Ref: Web Services at Universe 11.n One suggestion is to divide and conquer - break your problem into two pieces. Before trying to make outbound requests from the HP server, use something like SoapUI and get a handle on WSDL's and XML etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, October 31, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] Ref: Web Services at Universe 11.n Hi Rudy: We're not using any web services at present - but we'd like to. (Basically I'm a beginner at this and trying to learn what is possible.) We need to interface our current jail system with a new RMS that is coming in, and the vendors of it prefer web services interfaces. So that's why. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
That is interesting Richard. I only have experience in udt with this, and if I set logging with protocolLogging(sym.log, ON, 10)I get the full http conversation. Maybe there is a difference in UV ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 22:43 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n Yes, as I said, I've tested with curl and it works perfectly. The problem I have is not being able to clearly/cleanly see the raw text being sent by the uv functions, in order to determine the difference in what curl sends (success) and what the uv functions send (failure). There may be certain idiosyncratic parsing involved in the service I am trying to consume, but I have no control over that. With curl I can see the entire conversation if the logging is set correctly. With the uv functions, even with the highest logging level, it doesn't appear that the logging is actually that complete and exact. I have never had the impression that it was. I would love to be able to do it all in uv, but I only have control over half of the conversation, and with the uv functions, I seem to have a bit less than half. Richard On Wed, Oct 30, 2013 at 2:12 PM, Symeon Breen syme...@gmail.com wrote: That means you where probably missing a header. http is just a text conversation, if the same headers are passed as passed with curl it will work. You can test using curl, or even better with telnet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 20:03 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
The unibasic extensions have had sockets, http requests and soap (each built on the former) for many years - look it up in the manuals. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 30 October 2013 19:01 To: u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web Services at Universe 11.n
That means you where probably missing a header. http is just a text conversation, if the same headers are passed as passed with curl it will work. You can test using curl, or even better with telnet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: 30 October 2013 20:03 To: U2 Users List Subject: Re: [U2] Web Services at Universe 11.n I've recently been tasked with accessing a webservice, and couldn't get a valid response from the webservice. It kept not recognizing the headers that were sent, and with the maximum logging set on the uv side, it looked like everything was being sent just fine, but the webservice still failed it. I switched to using curl, and it all worked perfectly. Richard Lewis On Wed, Oct 30, 2013 at 1:00 PM, Oaks, Harold harold.o...@clark.wa.govwrote: I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Support Ticket Software
The secure server at force.com , e.g. secure.force.com ? which would be salesforce - and they do have ticketing software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 23 October 2013 03:55 To: U2 Users List Subject: [U2] [OT] Support Ticket Software My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mobile phones
Thanks everyone for your information. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Mobile phones
Hi I have an application that is based in the UK, one of the things it does is allow entry of a phone number, I then determine if this is a mobile (cell phone) and send a text (easy in the uk as all mobiles begin with 07) We are embarking upon our first US client (well existing uk customer with a US presence) so my question is - how with US phone numbers can I determine if it is a cell phone ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Who was Infinitivity?
http://web.archive.org/web/20021219211542/http://www.pixiuscorp.com/press/pi xius_inf.php -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Sent: 25 June 2013 00:01 To: U2 Users List Subject: Re: [U2] Who was Infinitivity? If you go to www.archive.org and type in the URL, you have to go back to 2005 to see an entry. I clicked on it for 2005, and was redirected to http://www.pixiussoftware.com/mvinternet.php You might give them a holler or try different URLs and different years and dates to come up with an archived version of their website. Hope this helps, Thanks, Robert Norman logo ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (951) 541-1668 i...@keyway.net mailto:i...@keyway.net http://users.keyway.net/~ice/ http://users.keyway.net/%7Eice/ Affordable CUBS programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC. On 6/17/2013 7:47 AM, Ed Clark wrote: Rang a bell, so I went searching. I'm looking at the may/jun 2001 issue of Spectrum. Full page ad on page 3, a company named infinetivity that was selling a number of products including pick fusion web integration for pick. They also had a web hosting service. They mention a lot of urls: pickauthority.com pickfusion.com pick2oracle.com pickdevelopment.com pickwebhosting.com pickapplications.com pickstudio.com pickveteran.com pickmaestro.com pickgod.com and www.infinetivity.com and a phone number 1-800-555-6442 (a 555 number? hmmm). Some of the urls have been interestingly re-used. None of them point to anything multivalue-related. I'm pretty sure I downloaded their free evaluation version at one point. On Jun 13, 2013, at 12:33 PM, Wjhonson wjhon...@aol.com wrote: Seeing in another thread the name BlueFinity reminded me of an old unresolved question. Many years ago (ten? eight?) I got a brochure from an outfit called Infinitivity, and they were hocking a web-to-Pick connection tool. When I try to find details today about that outfit I can't. Anyone have a bit of history about this company ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History of Prime Information
PI/Open I think that was -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: 12 June 2013 13:09 To: U2 Users List Subject: Re: [U2] History of Prime Information I can add that I think VMark rewrote Prime Information in C which really boosted the performance. I think they called it Prime Info or something like that. Dale On 06/12/2013 03:31 AM, Brett Callacher wrote: I think it is a hard task for anyone to remember all this - gets complicated. This may help: http://www.tincat-group.com/mv/familytree.html Larry Hiscocklar...@wcs-corp.com wrote in message news:009e01ce42f0$092cac70$1b860550$@wcs-corp.com... If I recall correctly (and I may not ;-), Ardent was the company behind UniData. Ardent and VMark merged (or Ardent acquired VMark -- I'm not 100% clear on the details), and retained the Ardent name. Ardent was subsequently acquired by Informix, which was acquired by IBM, which later sold the U2 division to Rocket Software. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Taylor Sent: Friday, April 26, 2013 6:13 PM To: U2 Users List Subject: Re: [U2] History of Prime Information If I'm not mistaken, there was another company in between Vmark and IBM. I believe (and there may have been some smoke and mirrors in all this) that Informatics acquired Ardent and then assigned the CEO of Ardent as the President of Informatics, or something like that, to run both Ardent and Informatics. And then later, IBM acquired Informatics for their database and just inherited Vardent almost by accident. Then, I believe that IBM acquired Unidata and formed the U2 product group. Certainly someone (Suzie) at Rocket could clarify this and perhaps publish an document for historical purposes to document this history completely and accurately. Dave Taylor Sysmark Information Systems, Inc. Prime Computer out of Natick Massachusetts went out of business. One of their products was PR1ME INFORMATION. They were acquired by another computer, Computervision (Thank you Mark, I'd forgotten the name). The product PRIME INFORMATION was acquired by VMark. Vmark was later acquired by Ardent Software. I don't remember if there were any companies in between Ardent and IBM, and while this was going on, there was a separate history happening for Unidata. Net upshot was that IBM acquired both Universe and Unidata, and branded them as U2. Source - my memory, (such as it is). I started playing with PR1ME INFORMATION on a PR1ME 450-II back in 1978. I bought disk drives, controllers, and tape units off and on throughout the years from Computronix, specifically from Randy Styka, which is where I came into this conversation. On 4/26/2013 4:18 PM, Wjhonson wrote: so explain that better and whats the source? -Original Message- From: Allen Egertonaeger...@pobox.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:58 pm Subject: Re: [U2] TCL input and response logging (AD) I didn't say vmark acquired prime. I said they acquired prime information. (Allen - Sent from my paperweight) On Apr 26, 2013, at 3:07 PM, Wjhonsonwjhon...@aol.com wrote: That idea doesn't seem right Allen. I can't find any reference to Vmark acquiring Prime, after Prime's bankruptcy. One reference says that the Prime assets all went to ComputerVision, but it's just a blog Anyone have a newspaper article link ? -Original Message- From: Wjhonsonwjhon...@aol.com To: u2-usersu2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:58 am Subject: Re: [U2] TCL input and response logging (AD) I'll have to update the wiki poo pea a pages Who is the woman in this picture? http://en.wikipedia.org/wiki/File:Prime9950_kean.jpg -Original Message- From: Allen Egertonaeger...@pobox.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:31 am Subject: Re: [U2] TCL input and response logging (AD) Prime Information was a product running as an application on PRIMOS. It was acquired by Vmark and subsequently by Advent if memory serves me correctly. IBM acquired Universe and Unidata and subsequently sold them to Rocket. (Allen - Sent from my paperweight) On Apr 26, 2013, at 1:40 PM, Wjhonsonwjhon...@aol.com wrote: I don't think Universe was ever Prime. -Original Message- From: Allen Egertonaeger...@pobox.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Thu, Apr 25, 2013 5:06 pm Subject: Re: [U2] TCL input and response logging (AD) On 4/25/2013 5:36 PM, Randy Styka wrote: Hi! It's been a long time since I posted here but our company, Computronics, has sold a product called PEEK for Unix systems since 1993.
Re: [U2] How do I get the U2 Metadata Manager to work
Sorry - having tla troubles - I mean bci - I use it on 64bit redhat to read/write to a mysql db, using a standard mysql lib And I mean eda - I am not an expert - but I did think you can use it to read and write to/from an external source. I ti snot just for replication, tho that is one use of it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 20:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work This is really all new for me, so you have to excuse my ignorance. What is EDT? I know EDA but that is for writing data to SQL Server but not for reading from it. At least that's what it says in the documentation. Doesn't that use replication? I also have BDT working on 64 bit Linux but how does that help me? And if you actually have BCI working on 64 bit Linux, which ODBC driver did you use? Are there any 'gotchas' when installing it? In that regard I am totally at the mercy of our sys admin since he is the only one who installs anything on Linux. He installed a 64 bit ODBC driver and from a Linux shell he can connect to the SQL Server box I want to connect to with no problem. I followed the documentation in setting up BCI but when I try to use CONNECT in a Basic program I always get a memory error. On 07/06/2013 15:57, Symeon Breen wrote: Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I get the U2 Metadata Manager to work
Hi - I have udt 7.1 on redhat 64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 07 June 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is only for connecting from SQL Server to U2 so no good for what I want to do. On 07/06/2013 09:39, Symeon Breen wrote: And I am still looking for a way to read data from a relational database in a Basic program. This has been around for years Mecki - look up the bci functions like SQLPrepare etc. Or there is the new EDA function as well. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today!
Good stuff -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 03 June 2013 21:59 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! If you haven't seen it already, U2 got dual mentions today in top ranks. First: The UniData and UniVerse databases from Rocket Software have been listed for the first time in the database ranking site DB-Engines, making 45/169 (top 27%) on debut. http://db-engines.com/en/ranking Second: Rocket has been listed in the 'DBTA 100: The Companies That Matter Most in Data' with a big mention of the U2 databases from our CEO, Andy Youniss. http://www.dbta.com/Articles/Editorial/Trends-and-Applications/View-from-the -Top-Rocket-Software-89919.aspx http://www.dbta.com/Articles/Editorial/News-Flashes/DBTA-100-The-Companies-T hat-Matter-Most-in-Data-89876.aspx Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2242 / Virus Database: 3184/5881 - Release Date: 06/03/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UniObjects.Net vs Thrid-party Products
Uniobjects.Net is the base requirement. MV.NET builds on this and gives you a heap more (tho infact you can use it without uniobjects.net) So it depends if you want simple connectivity to the DB to do commands and subroutine calls, for which uniobject.net would suffice, or if you want any of the other fancy stuff on top that MV.NET will give you ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 28 May 2013 00:45 To: U2-Users List Subject: [U2] [UV] UniObjects.Net vs Thrid-party Products I'm investigating the pros and cons to using UniObjects.Net vs third-party products such as MV.Net, etc. Anyone care to chime in with your experiences? Thanks. Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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 http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 demos and sample code now on Github
A great start - I can see some interesting stuff on there over the next couple of years. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 21 May 2013 17:52 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] U2 demos and sample code now on Github I thought I should share this with you all. It's been in the works for a while and still a 'work in progress'. Let us know what you think. http://blog.rocketsoftware.com/2013/05/u2-samples-now-on-github/ Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: [1] job on LinkedIn
If the employer will sponsor your application it is pretty much a formality (providing you pass security checks that is) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 06 May 2013 17:51 To: u2-users@listserver.u2ug.org Subject: [U2] Fwd: [1] job on LinkedIn Bracknell, looks like its about 20 miles from London (as the crow flies) The job doesn't *state* that you need a work visa, but I assume you would ? Is it difficult to get a permit to work in Britain? -Original Message- From: Rocket Software Group Members group-dige...@linkedin.com To: Will Johnson wjhon...@aol.com Sent: Mon, May 6, 2013 9:42 am Subject: [1] job on LinkedIn Rocket Software May 6, 2013 Job Discussions (1) Epicor Software is looking for Application Support Analyst. Posted by Sharon Small, Recruiter at Epicor Software Corp LikeFlag Stop inappropriate content the moment it is posted. Send me an email for each new discussion Do you know anybody that might like this group? Invite others to join You are receiving Group Digest emails. Unsubscribe. This email was intended for Will Johnson (Pick / Universe BASIC I.T. Analyst at City of Redwood City). Learn why we included this. 2013, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5801 - Release Date: 05/05/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AES Encryption Of CC Numbers
Also If you are on linux you may be able to shell out to openssl to encrypt a string. You would probably need to use the -a switch to base64 encode the output. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 03 May 2013 10:44 To: 'U2 Users List' Subject: Re: [U2] AES Encryption Of CC Numbers Hi Gary Sadly the Basic ENCRYPT() function only does DES and RCn encryption. You should look at the Automatic Data Encryption features in the database itself - these are described in the security manual. That includes AES encryption, but you need to do careful planning and impact assessments before switching on ADE - it is not trivial and has ramifications. Otherwise you are probably looking at GCI or a service call to handle the encryption/decryption. Which product (UniVerse or UniData) and which platform (Windows/*nix) are you on? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gary Heiman Sent: 03 May 2013 06:37 To: u2-users@listserver.u2ug.org Subject: [U2] AES Encryption Of CC Numbers Hi folks - I'm new to this community, but aged in Multivalue Experience. Forgive me if this was aswered previously, but does anybody know of an algorithm in MV Basic to Encrypt/DeCrypt Credit Card Numbers based on one of the industry standards AES ? Thanks in advance ! Gary -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Thursday, May 02, 2013 12:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 49, Issue 2 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. Re: Would anyone else like a change to *HS.UPDFINFO? (Allen Bell) 2. Re: Would anyone else like a change to *HS.UPDFINFO? (Brian Whitehorn) 3. Re: Would anyone else like a change to *HS.UPDFINFO? (Gregor Scott) 4. Re: Would anyone else like a change to *HS.UPDFINFO? (Bill Haskett) 5. Re: Would anyone else like a change to *HS.UPDFINFO? (Brian Whitehorn) 6. Re: History of Prime Information (Anthonys Lists) 7. Re: History of Prime Information (Wjhonson) -- Message: 1 Date: Wed, 01 May 2013 15:15:54 -0500 From: Allen Bell apb...@psiwav.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: 518177fa.40...@psiwav.com Content-Type: text/plain; charset=ISO-8859-1; format=flowed I vote yes. Drives me crazy how it works AB On 5/1/2013 10:56 AM, Jeff Schasny wrote: That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. Gregor Scott wrote: I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support active select lists so that only the files I want built into the .hs_fileinfo cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included). Support inform me that I seem to be the only person interested in such a change, so I thought I would at least ask the question of the U2 community. Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to support select lists, or have a new command created that deals with select lists? Thanks Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message: 2 Date: Thu, 2 May 2013 09:04:21 +1000 From: Brian Whitehorn brian.whiteh...@tollgroup.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? Message-ID: 8B2F56DD2EABE24F998D2EF72FAE066F02A1147A@EXMDOV02.tollgroup.local Content-Type: text/plain; charset=us-ascii +1 Dan, perhaps something along the lines of uservoice (www.uservoice.com) where votes and feedback can be collated might add additional value, this being a good example. Regards, Brian. -Original Message- From:
Re: [U2] [way ot] - Electronic Button Purshers?
I love this conversation - great to see some really geeky stuff going on in the MV community :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 03 May 2013 17:20 To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? OK. Nevermind, I got what you mean. Not pull as push/pull, but rather remove. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 03, 2013 12:18 PM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? ?? not sure what you mean by pull the button? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Friday, May 03, 2013 12:12 PM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? Having a Pi and using it to actuate a solenoid to push a button is like going back into the dark ages with the star ship enterprise. Pull the button and wire in a solid state relay. - Original Message - From: Robert Frailey rfrai...@utahmed.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, May 03, 2013 10:07 AM Subject: Re: [U2] [way ot] - Electronic Button Purshers? magnetic solenoid and a return spring - Original Message - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] db listings
I have come across a few people recently who use this site to look at DB popularity - should U2 (and other MV systems be on there) http://db-engines.com/en/ranking/multivalue+dbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] revision control with git/github
Not with Git but with others, there are a variety of ways. One simple way of doing this is to have an automated process run at night that commits all changes back to the repository from your BP file (or whatever it is) The benefit is then you can browse the repo, and look to see when code has been changed (granularity by day), even find a line in a piece of code and find it was changed on a particular day. - Pretty useful when you are tracing why something used to work last month .. What this would not give is person , time of change, reason for change. You can further enhance this by getting the programmers a simple TCL command to commit a change they have done to a piece of code straight away and with a reason, maybe if they are changing a commonly changed piece of code, that way you get better granularity than your day, and also get a user and reason for change. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: 30 April 2013 15:14 To: U2 Users List Subject: Re: [U2] revision control with git/github Oops. Hit send a little too soon. I am curious to know if anyone has implemented revision control with git or github for Unibasic programs, and system builder objects. If so, how did you do it? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Apr 30, 2013 at 10:12 AM, Aaron Titus ati...@fwdco.com wrote: I am curious to know if *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5784 - Release Date: 04/29/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History of Prime Information
I think prime and vmark had done business together hence why the purchase - I remember back in 92/93 when we had a pair of prime 1920's (I think) running prime information, we then got a new prime unix box, that was actually a rebadged MIPS running Riscos, they said at the time that PI+ the new version of Information for unix was not quite ready but they would supply universe version 1 for free while they finished it off. Going from prime information to uv v1 was like taking a backward step, and we found a load of bugs in uv, esp with the locking tables, and deadlocks etc. Anyway we eventually got PI+ but I think it was just after that that Prime went out of business, we also used the CAD software, so we took the computervision CAD and ended up with PI+ but supplied by universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 27 April 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information On 27/04/13 05:26, Wjhonson wrote: Okay but let's just talk about 1990-1993 How did Computer Vision exactly get its hands on Prime Information ? This happened *before* the final bankruptcy of Prime? Or did somehow Prime sell or spin off Computer Vision with Prime Information as well? iirc they didn't. Computer Vision did a sort of reverse buyout, taking Prime's CAD business with it. INFORMATION was sold to Vmark, and the hardware business was sold to ?Pericom? That might be why Pr1mos has ended up in copyright limbo. There was a White Knight involved in this, so I'm guessing that the breakup and sale was along the lines of PI to Vmark, software to Computer Vision, and hardware and support to this other company. With the result that it wasn't clearly specified who got the copyrights to Pr1mos and now nobody can do much with it because they don't know who actually owns it... Enquiring minds want to know Well, I might not be much good at enlightening, but I was around as a customer when it all happened ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5776 - Release Date: 04/26/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to send an HTML formatted email.
No body to this email. Sending an email is just a smtp conversation - if you are on linux you can do this easily using mutt/mail/sendmail I have various examples. On windows , you could just do a socket to the smtp server, or use some library, loads of options, - I would recommend you read about the smtp protocol - it is very easy, you can send emails using telnet and just pass the appropriate commands to the smtp server, so it is equally easy within databasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ferrara, Mike Sent: 26 April 2013 15:18 To: U2-Users@listserver.u2ug.org Subject: [U2] How to send an HTML formatted email. Notice: This e-mail is intended solely for use of the individual or entity to which it is addressed and may contain information that is proprietary, privileged, company confidential and/or exempt from disclosure under applicable law. If the reader is not the intended recipient or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If this communication has been transmitted from a U.S. location it may also contain data subject to the International Traffic in Arms Regulations or U.S. Export Administration Regulations and cannot be disseminated, distributed or copied to foreign nationals, residing in the U.S. or abroad, without the prior approval of the U.S. Department of State or appropriate export licensing authority. If you have received this communication in error, please notify the sender by reply e-mail or collect telephone call and delete or destroy all copies of this email message, any physical copies made of this e-mail message and/or any file attachment(s). - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5773 - Release Date: 04/25/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Refactoring Tools
Python ? ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 22 April 2013 18:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Refactoring Tools If by refactoring you mean A tool which will read the BASIC code and translate it into Python Than no, no such animal exists. -Original Message- From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Apr 22, 2013 10:20 am Subject: Re: [U2] Refactoring Tools I remember Cliff Oliver talking about this once. Not sure, if he had any tools available... Wish I had more info available. On Sun, Apr 21, 2013 at 8:26 AM, Brian Leach br...@brianleach.co.uk wrote: Hi All I'm doing some intensive work with a large UniVerse site to assist them in migrating their 20 year old code base and working practices to full Agile, XP and TDD. They are really enthusiastic in embracing the modern world and making good progress, but there is a huge amount of legacy code to be cleaned up and test harnessed. So before I spend time possibly reinventing the wheel, does anyone know of any good refactoring tools for UniVerse Basic? Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5765 - Release Date: 04/22/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Creating a Soap Request
The post header in http is a relative url so that is not the problem - have you set the Soap action correctly ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 16 April 2013 07:14 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV Creating a Soap Request Hi Everyone, Recently I had some success getting a secure version of this to work etc. but now they want to change it to non-SSL so am trying to get plain old http to work. Using this example as a starting point: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api I've managed to (I think) translate the example above with our URL and soap action etc. but I have a question regarding the UV SOAPCreateRequest and hope someone may be able to assist. The URL I specify in SOAPCreateRequest is http://our-dev.domain.com/apps/jobs/Services/Job.svc However in the log file I get: 04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request: POST /apps/jobs/Services/Job.svc HTTP/1.1 Date: Tue, 16 Apr 2013 05:05:16 GMT Host: our-dev.domain.com SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole User-Agent: IBM UniVerse 11.x Content-Type: text/xml; charset=utf-8 Content-Length: 1670 The POST seems to be missing the first part of the URL and with the response being a 400 bad request I'm wondering if there's anything I can do to force the complete URL? In particular is there a SOAP command that I'm missing? Briefly I do the following in this order: Ret = setHTTPDefault( VERSION , 1.1 ) Ret = SOAPSetDefault( VERSION , 1.2 ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) The return codes from above are: setHTTPDefault result = 0 SOAPSetDefault result = 0 SOAPCreateRequest result = 0 SOAPSetRequestContent result = 0 SOAPSubmitRequest result = 0 The SoapStatus from SOAPSubmitRequest above is: Response status : 400-Bad Request The RespHeaders returned from SOAPSubmitRequest above is: Response headers : Cache-Control-private-Server-Microsoft-IIS/7.5-X-Powered-By-4.0.30319-X-Powe red-By-ASP.NET-Date-Tue, 16 Apr 2013 05:46:06 GMT-Content-Length-0 To me the soap action seems good and the xml in the payload looks ok too so it has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3. Reckon I must be missing something above so looking at the basic ref manual but it does not indicate if any of the soap commands therein and the above have other dependencies/pre-requisites and in what order they should occur. I guess a prior soap knowledge is expected but I'm just starting to get into this so if anyone can assist that'd be really helpful thanks. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2240 / Virus Database: 2641/5746 - Release Date: 04/15/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
We process and store most of our info in utf-8 - this includes multiple European languages, not currently Chinese tho but that should not be an issue if it is encoded in utf-8. We also use uniobjects.net with this data no problem. Well I say no problem - you do have to make sure your lang settings are correct, and that you know in your code if you are dealing with utf-8 encoded data or not - otherwise you can get tied up. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 05 April 2013 03:49 To: U2 Users List Subject: [U2] c#/uniobject/chinese/spanish characters hi all, anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
Also if you are running u2 on linux the iconv utility (not the u2 ICONV, linux iconv) is essential when dealing with different character encodings. But there are a few undocumented features on here called //TRANSLIT and //IGNORE that it is worth googleing about. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 05 April 2013 08:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] c#/uniobject/chinese/spanish characters Doug, I wrote a couple short extension methods which convert from Arabic to UTF-16 and back. The pattern goes like this: - Get input from GUI - Convert from known code page to utf-16, in this case that's windows-1256 - Save the data into MV ... it's just text and doesn't get munged on the wire To display in GUI: - Read the text from MV - Convert back from utf-16 to original code-page - Display in GUI I believe you would just substitute a different code page for other languages - obviously it must be the same language going in both directions, this isn't Bablefish. ;) It works great for platforms that have no I18N or other language support. This dealer in Amman Jordan has 40 old mvBase systems in the field that are now adopting a GUI based on mv.NET and this small bit of code. I don't think you can sort or select on this kind of data in MV. Although once it was in the DBMS, I think we were able to see everything great with AccuTerm in a character interface. It works in D3 too. I didn't try any others. U2 might support a better storage mechanism, so let's see what others say. But I'll be happy to provide the C# code that does the translation. Just email me. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: doug chanco Subject: [U2] c#/uniobject/chinese/spanish characters anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you print a .pdf from inside a Unix Box
http://xtricks.blogspot.co.uk/2007/04/print-pdf-from-command-line.html perhaps ?using acroread which is available for hpux 11 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: 04 April 2013 16:54 To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
Marketing has always been about multiple ways to do predominantly the same thing you have a newspaper campaign, poster campaign, radio, tv, cpc ads, web banners, cold calling etc, these are just some more. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 28 March 2013 21:55 To: U2 Users List Subject: Re: [U2] Social Networks for MV The biggest issue I have this all of this social media craze (emperor's new clothes) is the time it takes to manage multiple ways to do predominately the same thing. Although with enough resources, these marketing avenues are manageable, for small businesses, there aren't enough resources in house. In addition, to outsource requires tremendous luck in the selection process. Secondly, the level of self-absorption in these social media outlets is so monumental, what can I say? It's like talking with someone who spends the entire time preening themselves in from me. Just a thought, or two... :-) Bill Untitled Page - Original Message - *From:* robert.hou...@fwic.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/28/2013 2:14 PM *Subject:* Re: [U2] Social Networks for MV Here's another article about social media. While it addresses more consumer facing data, you can easily see how some B2B companies can take advantage of the same concepts: http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-har d-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egd e_43707_member_222896835 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-19-13 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV From: Robert Houben And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html Oh dear, you seem to have provoked yet another blog. :) http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html Summary: It's not just the individual services. Each of us has different roles in life. Pinterest might not appeal to us as MV people but it might appeal to the companies we support who wish to use it for marketing. And while you might not want to tweet about your MV epiphanies, in the broad landscape of social media there are many APIs (web services) for extracting data into your MV system, and publishing data from your MV system. As professionals and business people, ignoring this can be a strategic mistake. Thanks for the ongoing inspiration. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compressing PDFs
As others have said *nix comes with its own zip compressor. However I have also installed 7zip on our redhat linux box - no problems and we use it every day, I don't remember any dependencies I think it was just an rpm install. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 28 March 2013 12:55 To: U2 Users List Subject: [U2] Compressing PDFs HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [uv] Phantom question
Just a tip - one of my servers has an account per customer, and so has 2000+ accounts, when phantoms run in here i always put the customer number on the end of the command e.g. PHANTOM programToRun 695the @sentance is not used, but it shows up when I list processes so I can identify what account a phantom is running in. Also if you are on linux if you look in /proc/{pid}/fd it list all the file handles the process {pid} has open, so you can work it out from there. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 27 March 2013 17:59 To: U2 Users List Subject: [U2] [uv] Phantom question I see several phantoms running with I do a PORT.STATUS Question is - is it possible to determine which Account they are running in? I have several accounts and not sure where they are actually running. They launch with the BRIEF option, so no output in PH TIA, Mark Uv 10.2 RH Linux ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi What oconv are you using, and have you an example of how it is being displayed ? Rgds Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 07:30 To: u2-users@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2240 / Virus Database: 2641/5694 - Release Date: 03/21/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] XDOMOpen returning -1
Is this the latest version of UV - also is this on linux or Windows ? One thing to check is character encoding - if your lang settings are not utf-8 but the xml contains utf-8 you can get memory errors. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: 20 March 2013 17:12 To: U2 Users List Subject: Re: [U2] [UV] XDOMOpen returning -1 Hello, On a new installation of UV I'm the following command returns a -1: XDOMOpen( xmlData, XML.FROM.STRING, hDOM ) Any idea what causes this ? I encountered the same error 5-6 years ago but forgot how it was originally solved. Can it be due to insufficient memory ? Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
Every company I am involved in has a facebook/linkedin/twitter account and we keep them updated regularly - it is essential in modern business marketing to do this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 15 March 2013 22:12 To: u2-users@listserver.u2ug.org Subject: [U2] Social Networks for MV I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2240 / Virus Database: 2641/5677 - Release Date: 03/15/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
I am in the UK - I do tend to find Europe a couple of years in advance of the us when it comes to marketing models, certainly in the web and social marketing space. All these companies are b2b, but they are young dynamic companies - for instance one company I am involved in (founder/shareholder/cto) does online restaurant booking systems, we target some of the medium and larger aspirational restaurant chains, all of whom are staffed and run by people who are very into social media, dining is a big social event in Europe people tweet/facebook about their dining experience, starting from when they book to how the actual event went. Social media is integral to how our customers market themselves and we have to be in that space as well. As for privacy - pardon my French but it think the whole thing is a load of bollocks. Are people really so egotistical to think that there is someone at facebook sifting through the billions of hits they get per day to find out exactly what you are up to . I am also involved in another company (again founder/shareholder/cto) that does internet advertising, we have many of the largest uk newspaper and magazine sites and place tens of millions of ads per day, we place cookies and track usage - but in no way are we interested in any one individual it is just trends and totals, even if we did somehow manage to choose someone, what exactly would we find out that was so exciting and worthy to spend hours of effort on. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Wyatt Sent: 16 March 2013 19:26 To: 'U2 Users List' Subject: Re: [U2] Social Networks for MV Symeon, I'm curious whether these companies are retail, manufacturing, services, or ??? I'm also curious whether their presence there is driven by you, or driven by their business model? Not knowing geographically where you are, please pardon my references to U.S. retail stores. I'm not prone to visit Walmart or Best Buy because they have a Facebook presence, or because they have coupons advertised there-in. IF (and that is a big IF) they have the product I seek at a price I'm willing to pay, I'll visit the store; I'm not a coupon/rebate shopper. I'm not going to join Facebook or Twitter to follow the local news or television personalities, Amazon, my favorite deodorant, my preferred shampoo, and the like. I'm not planning on joining Facebook or Twitter to follow Rocket Software or their staff. Part of why I will not is due to my privacy and security concerns, and the abuses taken by these sites. Sure, you can try to harden your presence there, but, in the end, the appearance of control and hardening is weakened by the site usage agreements they change next month. Vendors that I am involved with have my E-mail address; I figure if there is something I need to know, they'll tell me directly; if not, it will be posted on their web site. I don't have the time to visit a half-dozen (or more) places to get reliable and authoritative information regarding product news, staff updates, information for a problem I'm trying to solve, and so-on. The more places I have to look, the more time I have lost, and I question the accuracy or relevancy of whatever I seek when I find it on a social site and nowhere else. So I'm interested in what is driving the socialization of the commercialization process - is it a fit for all companies? Is it a fit for those companies wanting name recognition, or in the retail space wanting to attract more sales? What drove the companies with which you are involved go the socialization route? Having done it for one of the companies, did you drive it for the others? How do you gauge the success (or failure) of your presence there? How did you balance the desire (may be need, but...) to be on these web sites with the security and privacy concerns the company may have had? Bob Wyatt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Saturday, March 16, 2013 6:31 AM To: 'U2 Users List' Subject: Re: [U2] Social Networks for MV Every company I am involved in has a facebook/linkedin/twitter account and we keep them updated regularly - it is essential in modern business marketing to do this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 15 March 2013 22:12 To: u2-users@listserver.u2ug.org Subject: [U2] Social Networks for MV I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue
Re: [U2] Using the PUT method in an HTTP connection in UniBasic
Use the *nix curl command - it can do any verb and any payload. Or just use the sockets api - http is just a simple socket conversation. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jim.sto...@esc.edu Sent: 11 March 2013 20:21 To: U2 Users List Subject: [U2] Using the PUT method in an HTTP connection in UniBasic Hello everyone, We have been playing around with the UniBasic commands createRequest and submitRequest for use with some web services provided by our external vendors. Unfortunately, one of the web services requires updates to existing data records to be submitted using the PUT method, instead of POST. According to the UniBasic Commands Reference for both UniData 7.2 and 7.3, the PUT method appears to not be supported for the createRequest command. That struck me as a little odd, so just to be sure, we tried it and couldn't get it to work. Does anyone know of an alternative way to create http requests in UniBasic that would support the PUT method? We have UniData 7.2 running on HP-UX. Most of my programming experience is on other platforms, typically on Windows, so my normal solution to this problem would be to make use of Microsoft's WinHTTP object (or one of its equivalent siblings) to handle the http request. Is there a way to do something equivalent to that in UniBasic on HP-UX? Thanks in advance for any suggestions you can give me! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] bdt in juno
That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 07 March 2013 15:23 To: U2 Users List Subject: Re: [U2] bdt in juno Hi Symeon: I have installed BDT as a plug-in on Juno SR2. I found no problems with it even when using our XLr8 plug-ins. I like it better than the stand alone because I can use a java 1.7 instead of 1.6 and I can use current Eclipse 4.1 instead of 3.5. Regards, Doug www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] bdt in juno
URL please of the update site ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: 08 March 2013 16:47 To: U2 Users List Subject: Re: [U2] bdt in juno I did this yesterday using the eclipse software update installation site that rocket has. There is a webinar on rocket's web site that explains exactly how to to it. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 7:57 AM, Symeon Breen syme...@gmail.com wrote: That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 07 March 2013 15:23 To: U2 Users List Subject: Re: [U2] bdt in juno Hi Symeon: I have installed BDT as a plug-in on Juno SR2. I found no problems with it even when using our XLr8 plug-ins. I like it better than the stand alone because I can use a java 1.7 instead of 1.6 and I can use current Eclipse 4.1 instead of 3.5. Regards, Doug www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] bdt in juno
Found it at http://updates.rocketsoftware.com/u2/ -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 08 March 2013 17:13 To: 'U2 Users List' Subject: RE: [U2] bdt in juno URL please of the update site ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: 08 March 2013 16:47 To: U2 Users List Subject: Re: [U2] bdt in juno I did this yesterday using the eclipse software update installation site that rocket has. There is a webinar on rocket's web site that explains exactly how to to it. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 7:57 AM, Symeon Breen syme...@gmail.com wrote: That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 07 March 2013 15:23 To: U2 Users List Subject: Re: [U2] bdt in juno Hi Symeon: I have installed BDT as a plug-in on Juno SR2. I found no problems with it even when using our XLr8 plug-ins. I like it better than the stand alone because I can use a java 1.7 instead of 1.6 and I can use current Eclipse 4.1 instead of 3.5. Regards, Doug www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] bdt in juno
Just wondering - Has anyone been successful in adding the bdt perspective to juno ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
I seem to remember when we used such things that the costs in the uk where pretty similar. Wintegrate also did some emulations that accuterm did not and we needed those, but the other problem I have with Accuterm is that it is very American (not being rude here) so it has some funny (to us Europeans) way of doing things, and always looks very old fashioned. Each to their own I guess -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 25 February 2013 20:14 To: U2 Users List Subject: Re: [U2] UV full screen editor Symeon: That may be true these days, but wIntegrate has always been significantly more expensive than AccuTerm, and AccuTerm always worked better with Linux and SSH (rather than using SSL like wIntegrate does/did). Also, AccuTerm's licensing was significantly easier to manage (we still have clients struggling with the old site-licensing of wIntegrate). Nowadays, however, we use UniObjects to connect to our servers and run our application. Even now, I still use AccuTerm mostly, and VS2010 (which I mostly dislike - but that's just the environment). I've tried xLr8, BST, Brian's but there's always something that just trips me up each and every day with these packages. Every time I get one of these set up and running, something changes or something I do on a common basis is just very difficult to accomplish. :-( Bill Untitled Page - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/25/2013 10:56 AM *Subject:* Re: [U2] UV full screen editor Also If you want an editor integrated into your terminal emulator I have always found wintegrate to be the best solution out there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
Yeah we got them to do some bespoke emulation work for the old videotext terminals as used by the travel viewdata network. We actually went live with this using wintegrate 98's activeX functionality and a beta version of ie 5 and the original redback v1, to provide a browser based travel solution that could script into the viewdata network and scrape out booking data. Happy days ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 26 February 2013 10:30 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV full screen editor On 26/02/13 08:38, Symeon Breen wrote: I seem to remember when we used such things that the costs in the uk where pretty similar. Wintegrate also did some emulations that accuterm did not and we needed those, but the other problem I have with Accuterm is that it is very American (not being rude here) so it has some funny (to us Europeans) way of doing things, and always looks very old fashioned. Each to their own I guess The thing with wIntegrate for us was emulation too - pretty much every emulator we tried failed somewhere. With wIntegrate it was easy to get at the definition files and re-define the client end to match the server - the VT emulation in particular bit us hard. The current official PT emulation is mostly my hard work :-) I doubt they've done anything to it since they replaced the original bare-bones version with mine back in the days of v3. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
On the UV clients CD in the eclipse based tools there is the Basic Development toolkit (BDT) this will probably give you most of what you want. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nirvan Wijesekera Sent: 25 February 2013 14:04 To: u2-users@listserver.u2ug.org Subject: [U2] UV full screen editor Hello all, I'm new to this forum, so apologies if this topic has been brought up before. Can anyone recommend a decent full-screen editor for Universe? I require it for editing source code as well as modifying data files. Seems like most of them can do one or the other, but not both. We do not run System Builder, so is there anything else available? We are trying to move away from the native UV line editor. Many thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
Also If you want an editor integrated into your terminal emulator I have always found wintegrate to be the best solution out there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Hi - the first port of call is to enable the protocol logging E.G. err=protocolLogging(SoapTest.log,ON,10) You can then look at the log for errors Does The https end point you are using allow self certification authentication? If not you may need to do a bit more work on certificates. Restful webservices are nothing magical, it is still just a http(s) endpoint , the difference is you normally send more info in the path as well as post data, and you use the http verbs - Seriously I would encourage you to read up about http so you understand what is going on underneath - it is pretty simple its only a text conversation over a socket, you can do http conversations via telnet, or use a tool outside of uv like curl/wget on linux or wfetch on windows just to see what headers are being passed etc. Also if you want -I can email you my simple https post sub I use with endpoints that allow self cert -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 20 February 2013 07:57 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV: Consuming https service from within UVBasic using SOAP Hi Everyone, Think I'm suffering a bit from old dog new trick syndrome... Been reading up on and playing with the Soap functions in UV basic but can't seem to get any joy with https url that I've been supplied to use. Was wondering if anyone might have some advice? In particular I've been playing with the code examples here: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api/soap-api Also came across this in which I recognised some of the list members: http://comments.gmane.org/gmane.comp.db.u2.general/67904 Upgrading to UV11.1.9 may well be a better choice with availability of Dynamic Objects for JSON but we're stuck with 10.3.4 for a good while yet due to other constraints. Code: Ret = SoapCreateRequest(URL , SoapAction , SoapReq) vs Ret = SoapCreateSecureRequest(URL , SoapAction , SoapReq , SecHandle) For the https url I tried using the SoapCreateSecureRequest but when I compile I get a variable unassigned for the 3rd SoapReq parameter. Is our UV version the issue here? Another thought I had was that the security_handle variable is somehow affecting the other variables. Using the SoapCreateRequest function the program compiles OK with no errors (the 3rd SoapReq parameter is assigned OK however I get an error 2 - network subsystem failure for the https url. If I point at the http url then I at least get a 404 not found. I can also telnet from the host to both ports 80 and 443 no worries so comms appear OK. The project is required to fire off DB events into our new workflow system hence my focus in this direction. Have also read about just writing a message to a pipe etc and other intermediate solutions as per the above but it'd be real nice if I can get this working via soap. Oh and one other question please. Is it possible to have a UV basic program communicate with or consume / use a restful http service? I may have my wires crossed here so please set me straight. I've seen examples of (and we currently use) a web front end accessing a UV db but not the other way around. Many thanks in advance for your time. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2238 / Virus Database: 2639/5616 - Release Date: 02/19/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] FREE pick date conversion android app [/AD]
Unless you are using a tool that gives a cross platform environment - why bother ? if you are writing for android do it in Java -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 14 February 2013 08:51 To: 'U2 Users List' Subject: Re: [U2] [AD] FREE pick date conversion android app [/AD] Now there really IS an app for it ... :) PS if you want a VB-like way of building apps, also check out NS Basic. Simple and cool. (Neither of which are the first things to spring to mind about Titanium, which I use... the results are blistering but I always feel I'm running up-hill avoiding potholes) Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2238 / Virus Database: 2639/5602 - Release Date: 02/13/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: Quick Question on u2 toolkit for .net
One for the better and better ? On Thu, Feb 14, 2013 at 12:17 PM, rajank rku...@rs.com wrote: Thank you for asking this question. In this Release, we do not support edit/compile subroutine feature in VS2010/VS2012. We have tool called BDT that does the same thing. But I agree it is nice to have this functionality in VS2010/VS2012. However you can do the following with U2 Subroutine (Business Logic): . Now UO.NET is embedded in U2 Toolkit for .NET. You do not need to use 'IBM' namespace. You can use 'U2.Data.Client.UO' to achieve UO.NET functionalities. . We have developed UO.NET 6/7 years ago using VS2005, .NET Framework 2.0, CLR 2.0, 32-bit. Since then there is no upgrade. . U2 Toolkit for .NET's UO.NET is compiled with VS2010, .NET Framework 4.0, CLR 4.0, 32-bit, 64-bit. . Using U2 Toolkit for .NET, you can mix ADO.NET and UO.NETfunctionalities in your application such as webservice. . U2 Toolkit for .NET's New Subroutine features allows to load multi-value dynamic arrays into .NET Objects such as DataSet/DataTable. Now we provide MV_To_DataTable() and DataTable_To_MV() API for U2 Subroutines. . oData ( http://www.odata.org/ http://www.odata.org/ ) is industry trend. It allows you to develop Windows Store App, Windows 8 Metro Style App, Windows Phone, and Windows Surface etc. U2 Toolkit for .NET and its LINQ to Entity/U2Subroutine capabilities are very helpful to achieve these tasks. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Quick-Question-on-u2- toolkit-for-net-tp39922p39927.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2238 / Virus Database: 2639/5603 - Release Date: 02/14/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Quick Question on u2 toolkit for .net
I am currently not really interested in most of this - we just simply connect to u2 using uo.net to do subroutine calls and produce webservices from this. However my question is, does this toolkit allow you to edit and compile U2 basic programs within visual studio ? Now that would be handy. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Large File Operations Kill Linux
Ext3 and 132Gb ram all sounds good RHEL 5 always uses kernel 2.6.18there may be patches available as Brian says so going through redhat support is the best bet, it is after all what you pay for, otherwise you would just have centos. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 04 February 2013 21:15 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Large File Operations Kill Linux On 04/02/13 21:05, Dan Fitzgerald wrote: What's the value in /proc/sys/vm/swappiness? How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in linux terms) kernel. Are you on RedHat support? This is a problem with the linux kernel that was addressed recently, iirc. Large amounts of io from a single process can swamp the queue, and the latest kernels have it fixed. If you've got RH support, see if you can find out if that's been backported into your kernel. Cheers, Wol From: perry.tay...@zirmed.com To: u2-users@listserver.u2ug.org Date: Mon, 4 Feb 2013 20:53:13 + Subject: Re: [U2] [UV] Large File Operations Kill Linux We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, February 04, 2013 9:23 AM To: 'U2 Users List' Subject: Re: [U2] [UV] Large File Operations Kill Linux A few questions - What linux version/distro are you on and what type of file system, and how much ram do you have -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 04 February 2013 15:57 To: U2-Users List Subject: [U2] [UV] Large File Operations Kill Linux Looking for some ideas on how to keep Linux from becoming largely unresponsive when creating large files. What happens is as the new file is being created the I/O buffer cache quickly fills up with dirty buffers. Until the kernel can flush these out to disk there is no avail buffers for I/O operations from other processes. . The most troubling manifestation of this is the transaction logging check point daemon gets *way* behind putting us as risk if we were to have a failure of some kind. I have tried using ionice and renice to slow the file creation down as much as possible. This help a little but is still a big problem. Any ideas how to get CREATE.FILE/RESIZE to play nice on Linux? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2238 / Virus Database: 2639/5581 - Release Date: 02/04/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Large File Operations Kill Linux
A few questions - What linux version/distro are you on and what type of file system, and how much ram do you have -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 04 February 2013 15:57 To: U2-Users List Subject: [U2] [UV] Large File Operations Kill Linux Looking for some ideas on how to keep Linux from becoming largely unresponsive when creating large files. What happens is as the new file is being created the I/O buffer cache quickly fills up with dirty buffers. Until the kernel can flush these out to disk there is no avail buffers for I/O operations from other processes. . The most troubling manifestation of this is the transaction logging check point daemon gets *way* behind putting us as risk if we were to have a failure of some kind. I have tried using ionice and renice to slow the file creation down as much as possible. This help a little but is still a big problem. Any ideas how to get CREATE.FILE/RESIZE to play nice on Linux? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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 http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web service
There are loads of examples on the web, esp loads in msdn. It being a u2 web service makes no difference at all it is just a web service that you are consuming. You just need to make sure you understand if it is restful or soap. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: 16 January 2013 21:07 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Web service Hello list, I ve been banging my head against the wall but getting nowhere trying to find a good example of of a c# program consuming a web service. Specifically, I need an example of a c# program consuming a UV web service. We have a few web services in UV that are consumed by a Seibel app. I would like to write the same thing in C# using vs 2010. Does anyone have an example in C# that they could send me or provide a link to a good working example? thx, rudy Are you a fan of SAGE? Show us at www.facebook.com/SAGEPublicationshttp://www.facebook.com/SAGEPublications. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2638/5537 - Release Date: 01/16/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] {BDT] Commenting A Block Of Code
The big question is which editor ? Winted, Unidebugger, BDT , etc ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 10 January 2013 01:25 To: U2 Users List Subject: [U2] {BDT] Commenting A Block Of Code Rather than going line-by-line... is there a way... or a trick to highlighting several lines of code... And commenting out all of these lines in aggregate? I have a legacy program whose code is no longer compliant... that I am trying to isolate. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] {BDT] Commenting A Block Of Code
My apologies - I did not spot that -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: 10 January 2013 15:28 To: U2 Users List Subject: Re: [U2] {BDT] Commenting A Block Of Code The OP (bill) included {BDT] in the subject line so he is asking about Basic Developer Toolkit. the Ctrl-/ answer is correct. On Thu, Jan 10, 2013 at 2:49 AM, Symeon Breen syme...@gmail.com wrote: The big question is which editor ? Winted, Unidebugger, BDT , etc ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 10 January 2013 01:25 To: U2 Users List Subject: [U2] {BDT] Commenting A Block Of Code Rather than going line-by-line... is there a way... or a trick to highlighting several lines of code... And commenting out all of these lines in aggregate? I have a legacy program whose code is no longer compliant... that I am trying to isolate. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2637/5522 - Release Date: 01/09/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Secrets was Vinnie Smith
If you have to migrate your data from your old system to your new system I don't think it matters at all that the databases the systems use are the same, the formats of the data will be so different you are going to have to do an export and import anyway. I sell my products into their verticals based upon their functionality. Most of my customers don't know that it runs on unidata, the ones that do ask never make a comment as it is not the reason they are buying software , what they need is a solution to their business problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 19 December 2012 22:41 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Secrets was Vinnie Smith Then you're not understanding me. I am not speaking at all of sites that use home-built systems. I am speaking of vendors, who sell application abc, to *others*, and yet their advertising is squelched by all the noise. If I have a client who is say a video rental store (they do still exist) and their existing software company has vanished, the owner is most likely to say, gee let's look at what's available in the market to move our data to. If I can say, here is another company, also making software for your exact same vertical, and luckily, they use the exact same database that is an advantage to me, and the client both. I can't do that today, because unlike some other databases, their doesn't seem to be any such resource to list who has what app for sale in the MV world. -Original Message- From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Dec 19, 2012 1:53 pm Subject: Re: [U2] Secrets was Vinnie Smith Hi Will What you are raising is the issue of internal customised U2 sites which are a dying breed. The new market is applications where people buy the applications, not the database. Vendors see no benefit from advertising that they use U2 where they get no financial benefit and they could disadvantage themselves. Even Oracle based packages are talking less about Oracle. If a site is Microsoft SQL Server, why get yourself knocked off the list. The trend is such that Oracle is buying ERP tools to sell, because people no longer make decisions on Databases. SAP is moving the customer to their purchased Sybase database. The market is all moving towards applications as the decision making process. George and I advertise that we run on U2 product, but many of the ISVs don't see any benefit. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2637/5470 - Release Date: 12/19/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wally Terhune
Congratulations, I have enjoyed your posts over the years, enjoy your retirement. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 13 December 2012 22:04 To: U2 Users List Subject: [U2] Wally Terhune Congratulations on your upcoming retirement. Thanks for all the support you have given us over the years for us Unidata guys. Your breadth of knowledge will surely be missed. Enjoy retirement, -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5456 - Release Date: 12/13/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Toolkit for .NET and Windows PowerShell - how?
Stackoverflow is for people to ask questions, and the community to answer - I think the moderators will not like you raising and answering your own questions... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of rajank Sent: 04 December 2012 22:17 To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Toolkit for .NET and Windows PowerShell - how? Please visit the above link (stackoverflow). There is an answer (*ADO.NET *way and *UO.NET *way). See screen shot and PowerShell script. If you have more question, you can ask U2 Support Team. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/U2-Toolkit-for-NET-and-Wind ows-PowerShell-how-tp39376p39378.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5436 - Release Date: 12/04/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uniobjects.net
Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects.net
Ahh yes - upto about 200 ish -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 14:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects.net For me the key is in how many is a number of records? On Mon, 3 Dec 2012 14:48:45 -, Symeon Breen wrote: Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects.net
I could use a basic subroutine, but in order for it to return a couple of hundred records, it would have to either delimit the records somehow or generate an xml or json string, and I just wanted to see if there was a better/more standard way of doing this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 15:07 To: U2 Users List Subject: Re: [U2] uniobjects.net If the supposed access time for these records is rather quick, 200 records is a relatively small record set. Although there are technically more elegant ways of doing this, why cant you just stick with your proven basic subroutine call? On Mon, 3 Dec 2012 14:59:43 -, Symeon Breen wrote: Ahh yes - upto about 200 ish -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 14:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects.net For me the key is in how many is a number of records? On Mon, 3 Dec 2012 14:48:45 -, Symeon Breen wrote: Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects.net
Pretty much the options I had thought - although on the json front I have used System.Web.Script.Serialization.JavaScriptSerializer for json serial and deserial isation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: 03 December 2012 16:15 To: 'U2 Users List' Subject: Re: [U2] uniobjects.net Simeon There isn't a single standard, it depends on a) how easy it is to generate the data in the first place and b) what you want to do with it after.. Going UniXML gives you the option to generate a dataset which is easy for binding but has large overheads, or more usefully to grab the content into an XDocument and parse it into Listsomething_useful using LINQ whilst preserving the structure: the latter gives you more flexibility and you don't need to normalize or navigate the parent/child relations created in a dataset if you have multivalued data. Of course you don't have to use UniXML to bring back XML for LINQ - you can bring that back in a subroutine argument, having generated it directly in BASIC. If you create a template for your XML document and for the row and just use the CHANGE() function to populate placeholders, that's often quicker than calling out to the XML features in the database - just make sure you handle the escapes. Ditto JSON, but unless you're calling from a web service consuming context there isn't really the tooling exposed in .NET to then do anything useful with it (there is a LINQ provider for JSON but it converts it into XML behind the scenes before parsing). If you want to work raw returning data from a subroutine, you can delimit your records with char(255) and simply split() them on the client into an array and possibly ListT.AddRange(array). But you would still then have to do the work of interpreting the individual record contents after separating them. All of which is an answer that is no answer.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 03 December 2012 15:55 To: 'U2 Users List' Subject: Re: [U2] uniobjects.net I could use a basic subroutine, but in order for it to return a couple of hundred records, it would have to either delimit the records somehow or generate an xml or json string, and I just wanted to see if there was a better/more standard way of doing this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 15:07 To: U2 Users List Subject: Re: [U2] uniobjects.net If the supposed access time for these records is rather quick, 200 records is a relatively small record set. Although there are technically more elegant ways of doing this, why cant you just stick with your proven basic subroutine call? On Mon, 3 Dec 2012 14:59:43 -, Symeon Breen wrote: Ahh yes - upto about 200 ish -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 14:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects.net For me the key is in how many is a number of records? On Mon, 3 Dec 2012 14:48:45 -, Symeon Breen wrote: Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman
Re: [U2] [OT] Sql Query
I would advise that you learn about joins firste.g. http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.h tml -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: 07 November 2012 14:45 To: 'U2 Users List' Subject: [U2] [OT] Sql Query Our environment here is changing considerably and the focus is more and more inclusive of Sql database(s). My knowledge of Sql extends slightly past the ability to spell it. If I could get some suggestions on some good venues to learn the query language for this new database, it would be appreciated. There are so many books and venues out there, it is difficult to separate the good from the bad from the ugly. TIA, Barry Rogen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is the LMODE column helpful for something?
Thread hijack ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Sent: 06 November 2012 17:58 To: U2 Users List Subject: Re: [U2] Is the LMODE column helpful for something? I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman On 11/6/2012 9:36 AM, Wjhonson wrote: In my lock table there is a column called Lmode it has a two digit number and also RU which I guess means Read Update although I haven't tested other types of locking. What is this two-digit number and can it be useful to me for something? It's not unique across users, and also one user can have several simultaneous values. What is it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper
Renice ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 15 October 2012 19:41 To: u2-users@listserver.u2ug.org Subject: [U2] Chap Up, Chap Down, Chap chap chap the chapper Does anyone know what exactly the Chap Up and Chap Down do, as far as the underlying system settings? Can I see how Chap is currently *set* on my process or some other process? Does the setting of Chap appears somewhere, that I can view, either in Universe, or in Windows (or Unix) ? Can you Chap down multiple times and will this actually do something? If I Chap down on my process, not as admin, can I then Chap up on my process and still not need to be admin? These are burning questions and the kitchen's on fire. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2441/5333 - Release Date: 10/15/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Consuming Web Services
But we all know U2 is much more than a DB, in fact it is also much less than a DB. The concept of having the DB just do DB stuff works fine for SQL server and MySQL where the DB itself actually does a lot in terms of the data, and the clients, written in .NET, C, Python Java etc do all the business logic. For these stored procedures do exist but are usually kept to a minimum and certainly only for data interaction. The U2 databases are actually quite stupid, they store and retrieve data from tables in a (hopefully) quick and efficient manner, but they certainly don't do any of the clever stuff you find inside Sql server like map reduce, caching, indexing etc. The clever bits are what we do in the unibasic code. So I firmly believe there IS a case for the clever Unibasic code we write to access data over http, read in xml and to then process all of these different data streams. Yeah sure there are things which in theory are easier to do outside It does not mean you should always do things outside of unibasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 03 October 2012 23:48 To: U2 Users List Subject: Re: [U2] Consuming Web Services Tony and Ben are right on... Invoking Stephen Colbert's concept of... The Word... the word is... MiddleWare. As legacy U2 was ahead of its time... by building-in middleware technologies... it is easy to lose sight of what belongs where. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, October 03, 2012 6:31 PM Subject: Re: [U2] Consuming web services I do the same as Ben but with .NET: -- Local U2 .NET client web service Remote server Pick is a database server, not a communications protocol end-point. We simply should not be doing direct comms from this platform anymore, given the huge number of mainstream options. This is coming from someone who has written all of the bi-directional comms interfaces to/from MV with sockets and cURL and plugins and anything else I could create - because (in the 90's) people said it wasn't possible and because I figured it would be kewl just to do it. It _is_ all technically possible, but that doesn't mean it makes good business sense: Doing things like this in BASIC creates a maintenance hassle later. It leaves the environment subject to DBMS-specific issues that often aren't addressed for quite a long time. Using mainstream tools vastly increases the resources available for getting help and solving problems. So these days I get MV to push a query or data payload out to a middle-tier that uses the latest communications methods available. The request goes out, the response comes back, it all just works - that That should be our bottom line here. HTH T From: Ben Souther We use a middle layer written in Java. Jeff Schasny wrote: I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Consuming Web Services
I know - but you have to set it up against specific attributes and it creates a fairly standard index for the specified attributes in hand, you do that on sql as well, but it does its own indexing to make row retrieval optimised, has its own referential integrity rules around that etc. It's quite a different beast altogether. I am not saying it is better, but it does a lot more inside than U2 does. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 04 October 2012 09:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Consuming Web Services The U2 database does do indexing. -Original Message- From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Oct 4, 2012 12:56 am Subject: Re: [U2] Consuming Web Services But we all know U2 is much more than a DB, in fact it is also much less than a DB. The concept of having the DB just do DB stuff works fine for SQL server and MySQL where the DB itself actually does a lot in terms of the data, and the clients, written in .NET, C, Python Java etc do all the business logic. For these stored procedures do exist but are usually kept to a minimum and certainly only for data interaction. The U2 databases are actually quite stupid, they store and retrieve data from tables in a (hopefully) quick and efficient manner, but they certainly don't do any of the clever stuff you find inside Sql server like map reduce, caching, indexing etc. The clever bits are what we do in the unibasic code. So I firmly believe there IS a case for the clever Unibasic code we write to access data over http, read in xml and to then process all of these different data streams. Yeah sure there are things which in theory are easier to do outside It does not mean you should always do things outside of unibasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 03 October 2012 23:48 To: U2 Users List Subject: Re: [U2] Consuming Web Services Tony and Ben are right on... Invoking Stephen Colbert's concept of... The Word... the word is... MiddleWare. As legacy U2 was ahead of its time... by building-in middleware technologies... it is easy to lose sight of what belongs where. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, October 03, 2012 6:31 PM Subject: Re: [U2] Consuming web services I do the same as Ben but with .NET: -- Local U2 .NET client web service Remote server Pick is a database server, not a communications protocol end-point. We simply should not be doing direct comms from this platform anymore, given the huge number of mainstream options. This is coming from someone who has written all of the bi-directional comms interfaces to/from MV with sockets and cURL and plugins and anything else I could create - because (in the 90's) people said it wasn't possible and because I figured it would be kewl just to do it. It _is_ all technically possible, but that doesn't mean it makes good business sense: Doing things like this in BASIC creates a maintenance hassle later. It leaves the environment subject to DBMS-specific issues that often aren't addressed for quite a long time. Using mainstream tools vastly increases the resources available for getting help and solving problems. So these days I get MV to push a query or data payload out to a middle-tier that uses the latest communications methods available. The request goes out, the response comes back, it all just works - that That should be our bottom line here. HTH T From: Ben Souther We use a middle layer written in Java. Jeff Schasny wrote: I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Consuming Web Services
Ok so perhaps there is this and that. My point is a database like SQL server is architected in a very different manner to U2 - it is the actual central sqlserver.exe process that does the majority of the work, it accesses the tables and presents them to the api, its caching often used data, it obeys the schema, transaction, referential, indexing rules, it map reduces collations and totals, it looks after security, pools, licencing a whole plethora of things. Thereis a lot more out of the box inside SQL server than there is from U2 (again not saying it is better, just different) The central U2 processes look after licencing, locks, shared memory subroutines and a few other things. It is the udt or uvsh client process in which your databasic runs that has built into it the DB access code this is the key difference I feel, and hence why I feel clever unibasic code has a right to do clever things with sockets and xml etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 04 October 2012 09:20 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Consuming Web Services A U2 Table *can* also have referential integrity, it's an option. And SQL Table don't force referential integrity, you can turn that off :) -Original Message- From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Oct 4, 2012 1:17 am Subject: Re: [U2] Consuming Web Services I know - but you have to set it up against specific attributes and it creates a fairly standard index for the specified attributes in hand, you do that on sql as well, but it does its own indexing to make row retrieval optimised, has its own referential integrity rules around that etc. It's quite a different beast altogether. I am not saying it is better, but it does a lot more inside than U2 does. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 04 October 2012 09:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Consuming Web Services The U2 database does do indexing. -Original Message- From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Oct 4, 2012 12:56 am Subject: Re: [U2] Consuming Web Services But we all know U2 is much more than a DB, in fact it is also much less than a DB. The concept of having the DB just do DB stuff works fine for SQL server and MySQL where the DB itself actually does a lot in terms of the data, and the clients, written in .NET, C, Python Java etc do all the business logic. For these stored procedures do exist but are usually kept to a minimum and certainly only for data interaction. The U2 databases are actually quite stupid, they store and retrieve data from tables in a (hopefully) quick and efficient manner, but they certainly don't do any of the clever stuff you find inside Sql server like map reduce, caching, indexing etc. The clever bits are what we do in the unibasic code. So I firmly believe there IS a case for the clever Unibasic code we write to access data over http, read in xml and to then process all of these different data streams. Yeah sure there are things which in theory are easier to do outside It does not mean you should always do things outside of unibasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 03 October 2012 23:48 To: U2 Users List Subject: Re: [U2] Consuming Web Services Tony and Ben are right on... Invoking Stephen Colbert's concept of... The Word... the word is... MiddleWare. As legacy U2 was ahead of its time... by building-in middleware technologies... it is easy to lose sight of what belongs where. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, October 03, 2012 6:31 PM Subject: Re: [U2] Consuming web services I do the same as Ben but with .NET: -- Local U2 .NET client web service Remote server Pick is a database server, not a communications protocol end-point. We simply should not be doing direct comms from this platform anymore, given the huge number of mainstream options. This is coming from someone who has written all of the bi-directional comms interfaces to/from MV with sockets and cURL and plugins and anything else I could create - because (in the 90's) people said it wasn't possible and because I figured it would be kewl just to do it. It _is_ all technically possible, but that doesn't mean it makes good business sense: Doing things like this in BASIC creates a maintenance hassle later. It leaves the environment subject to DBMS-specific issues that often aren't addressed for quite a long time. Using mainstream tools vastly increases the resources
Re: [U2] Consuming Web Services
I was not trying to say sql server is better or worse than U2 just Different - hence supporting my argument that xml and socket calls are OK in unibasic -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 04 October 2012 10:20 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Consuming Web Services On 04/10/12 09:43, Symeon Breen wrote: Ok so perhaps there is this and that. My point is a database like SQL server is architected in a very different manner to U2 But that's why U2 is superior :-) - it is the actual central sqlserver.exe process that does the majority of the work, it accesses the tables and presents them to the api, its caching often used data, Which U2 actually does far better - (a) it leaves it to the OS, and (b) with a disk hit rate approaching 100% it doesn't need the cache that often (that's badly put, but I know what I mean :-) it obeys the schema, transaction, referential, indexing rules, it map reduces collations and totals, it looks after security, pools, licencing a whole plethora of things. Thereis a lot more out of the box inside SQL server than there is from U2 (again not saying it is better, just different) That's what gets me - U2 is often assumed to be inferior because it doesn't have the things SQL databases have, when the reality is it doesn't have them because it doesn't need them! The central U2 processes look after licencing, locks, shared memory subroutines and a few other things. It is the udt or uvsh client process in which your databasic runs that has built into it the DB access code this is the key difference I feel, and hence why I feel clever unibasic code has a right to do clever things with sockets and xml etc. But it would be nice if more of these things (even if written in BASIC, which is a *good* thing) actually came out of the box with U2. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Consuming web services
createRequest setRequestHeader addRequestParameter SubmitRequest All unibasic functions for working with http -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 03 October 2012 21:56 To: U2-Users@listserver.u2ug.org Subject: [U2] Consuming web services I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
Oracle and sql server both use map reduce internally when doing collations and totals. However they work differently to U2 in that they have one big process that runs queries from the clients. This process can then cache, multithread and map reduce. U2 is differently architected in that the client process (uv or udt process) actually do the work and the central udt processes are fairly slim. These client processes are single threaded. To do any multi threading/multi processing is part of the application rather than inherent in the database. One option is to make u2 a hadoop supported data store, you could then mapreduce across multiple instances using whatever hadoop supporting toolset you wanted. However map reduce and hadoop are pretty horrible things. Even Google have moved away from it with Caffiene etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 01 October 2012 21:05 To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Determining number of users licensed
Not on UD -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 12 September 2012 21:59 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Determining number of users licensed I thought system(36) shows the number of licenses -Original Message- From: Kevin King ke...@precisonline.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Sep 12, 2012 1:38 pm Subject: Re: [U2] [UD] Determining number of users licensed Can you parse it out of the listusers OS command? On Wed, Sep 12, 2012 at 2:24 PM, dean.armbrus...@ferguson.com wrote: Is there a way to programmatically determine the number of licensed users allowed? SYSTEM(514) reports the number of non-phantom users currently logged in, which is essentially the number of licenses in use. I want to compare that against the number of users allowed in a monitoring program. I want to know if we're close to the limit before we run out. The number of licenses varies by server. Colleagues have suggested using grep on udtconfig for NUSERS, but that is not the same thing. Since we generally have 100-200 phantom processes, we sometimes configure to a size larger than the license limit to have room for those phantom processes. UniData 7.3.1 HPUX 11.31 Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.comhttp://www.wolseley.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2437/5264 - Release Date: 09/12/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] insert data
What have you tried ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of unidata7 Sent: 29 July 2012 14:55 To: u2-users@listserver.u2ug.org Subject: [U2] insert data How do you insert data into a UniData database? Can it be done with a flat file? :confused: -- View this message in context: http://old.nabble.com/insert-data-tp34226994p34226994.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2197 / Virus Database: 2437/5161 - Release Date: 07/28/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects running as?
The rpc deamon will run as root, but when it spawns a udt process to fulfil your uniobjects process it will spawn it as the user you use in the uniobjects session. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of douglas chanco Sent: 24 July 2012 15:25 To: U2 Users List Subject: [U2] uniobjects running as? hey everyone, does anyone happen to know what user the uniobjects connection is running as? I would think root, but that doesn't seem to be correct as when I run a subversion command as root it works fine but when I run it from a uniobjects connection (via c# calling a pick subroutine) I get prompted to accept a self signed certificate (yeah yeah I know..) anyway I accepted it from the command line (so I don't get prompted anymore) as a specific user and as root (this is all proof of concept test, so if it pans out I will get a valid certificate). I am going to modify the pick subroutine to try and figure out what user is calling the pick subroutine as well as modify my shell script with expect so that it {A}ccepts the certificate but I thought I would ask the guru's on here (you know who you are!) in case expect gives me fits thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2197 / Virus Database: 2437/5150 - Release Date: 07/23/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
No - all you need is listuser - it lists ALL users licences, phantom,udcs, tty etc - it also gives a total licence count at the top which is an absolute total including device licencing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2012 19:53 To: U2 Users List Subject: Re: [U2] Monitoring connections on Unidata Symeon. Listuser shows rpc connections. The tty shows as udcs, if it is using a uniobjects.net pooled connection, the type is pooled, otherwise it is udt Is total license usage, the listuser plus the udcs connections? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5114 - Release Date: 07/06/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
listuser ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2012 14:54 To: U2 Users List Subject: [U2] Monitoring connections on Unidata Is there a way to monitor the number of RPC connections being used at any given time on Unidata 7.1/Redhat 3? We are not using device licensing. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring connections on Unidata
Listuser shows rpc connections. The tty shows as udcs, if it is using a uniobjects.net pooled connection, the type is pooled, otherwise it is udt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2012 16:34 To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Monitoring connections on Unidata What about connections coming from client applications? UniCall, UniObjects, etc. Do they use up licenses also? Charles Shaffer Senior Analyst NTN-Bower Corporation From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 07/06/2012 10:18 AM Subject:Re: [U2] Monitoring connections on Unidata Sent by:u2-users-boun...@listserver.u2ug.org listuser ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 06 July 2012 14:54 To: U2 Users List Subject: [U2] Monitoring connections on Unidata Is there a way to monitor the number of RPC connections being used at any given time on Unidata 7.1/Redhat 3? We are not using device licensing. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2195 / Virus Database: 2437/5112 - Release Date: 07/05/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release
Real programmers edit .ini files ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 04 July 2012 00:24 To: U2 Users List Subject: Re: [U2] Running XLr8 Tools inside U2 DBTools new Eclipse release I think my point go lost in all of the words. Rocket is delivering Eclipse plug-ins that are not first class. BDT has the menu item File-Switch Workspace, but the others Eclipse products have been stripped of features. Sure I can change the u2admin.ini to reference another work space. Did I jump back to 1990's to do Windows ini files configurations? I guess must have and did not remember the trip. I'm trying and I hope others as well to spread the word that the U2 world has progressed from TCL/ECL and AE/ED world to first class tools. I'm not saying that these new tools won't have bugs or things that can be enhanced. I'm saying if you strip out the standard features that make these tools first class, then all us using them are getting short changed. Regards, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2193 / Virus Database: 2437/5108 - Release Date: 07/03/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on?
From experimentation on unidata on linux, if you execute something with capturing it creates an entry in _PH_ of Z_{pid} the pid is zero filled to 8 digits e.g. _PH_/Z_00022141 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: 26 June 2012 15:01 To: 'U2 Users List' Subject: Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on? How about creating a COMMON variable that the program can set before executing the command with a CAPTURING clause? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Friday, June 22, 2012 6:49 AM To: U2 Users List Subject: Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on? UniData Looks like there is no easy solution. Messages are shown in a generic subroutine and I do not want to do a lot of IO or CPU time to determine if CAPTURING is on. The subroutine is called thousands of times a day for a user. For the few times this has happened over the years, I guess I will just fix the problems when they come up. Thanks everyone for their input. Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Thursday, June 21, 2012 5:22 PM To: U2 Users List Subject: Re: [U2] Is there any way to tell if I am in an EXECUTE level andCAPTURING is turned on? universe or unidata? I don't have a full answer either way, but I seem to recall that unidata holds CAPTURING output in a temporary file. Maybe that file can be checked for. On Jun 21, 2012, at 10:08 AM, Doug Farmer wrote: I just had a situation where a program was printing an error message and waiting for the user to respond by pressing Enter. But, the program was being executed by another program using the CAPTURING option. Is there any way someone knows of to tell if the CAPTURING option is on? If so, I can write the error message to a log file instead of displaying it and waiting for a response. I looked at all the SYSTEM(xx) options and do not see anything there. Thanks in Advance Doug 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/ZHJSQLX+SpPTndxI!oX7Us7Qlo!t9IHt4WE2DA5Hj !kWNSr8qrt6LXg6vr6+3RaGatMIqsrnApW1yubdBaCdqw== to report this email as spam. 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. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2180 / Virus Database: 2437/5093 - Release Date: 06/25/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] U2 Dynamic Object API
I won't be there - where can I get more information on U2 Dynamic Objects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: 28 May 2012 13:51 To: U2 Users List Subject: Re: [U2] U2 Dynamic Object API There is a U2 University session on this - coming up June 26-8 at Carden Park, Cheshire: U2 Dynamic Objects - Hello JSON! Do you want to call a RESTful Web service and quickly deal with the data it brings back? Come learn how to use the new U2 Basic functionality to easily handle web services data in JSON (JavaScript Object Notation) format. Come learn about the interesting features in the new U2 Dynamic Objects (UDO) API in Basic and see how easy it is to consume web services. Wally Terhune Technical Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Sunday, May 27, 2012 11:41 PM To: U2 Users List Subject: [U2] U2 Dynamic Object API I was just working my way through the patchlist.txt for UV11.1.9, where I encountered an unexpected gem: U2 Dynamic Object API. To quote the full entry in the doc: UNV-5606 Beginning at UniVerse 11.1.9, the U2 Dynamic Object API is introduced as an emerging technology. U2 Dynamic Object API provides an object structure in UniVerse. It is based on JSON (JavaScript Object Notation), a lightweight text-based data interchange format. The details of the API are in Chapter 1 of the UniData 7.3 New Features manual (http://tinyurl.com/6q6hov8). Has anyone worked with this API yet and have any feedback/insights they care to share? Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/5026 - Release Date: 05/27/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Dynamic Object API
Ok - so that kinda sounds good, I think ;) . I know where you are coming from, I too have also written heaps of stuff to generate and parse json, tho tbh I would normally do such logic (or certainly the parsing) in a middle tier like a .net webservice layer, and pass back to databasic. Generating json in databasic is very easy, parsing it is the more complex bit. Then again I only realy create json data if I have some javascript that is going to use it, no great point otherwise, except it is more compact than xml, and more complex than csv. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 28 May 2012 18:10 To: U2 Users List Subject: Re: [U2] U2 Dynamic Object API I've been using JSON for many years now. I've written UniBasic code to build JSON in many of our Web applications and our middle-ware. I have written parser in UniBasic that can read JSON arrays and give you results. I was looking very excitedly to not having to maintain my code UniBasic code and have a function that can read and write JSON. I went to U2 University this year. I was at the session that discussed UDO. I had read the documentation several times and was unable to make heads or tails out using this technology. Dan, who taught the session in Denver, had several examples that got me going. However, his examples were very simplistic and did apply to the real world so I still had a lot of work to do. After spending more hours than I care to mention, I have working code. I've time tested my code against the UDO function on Unidata 7.3 and Universe 11.1.9. I found Rocket U2 code is just a touch faster than mine. This did not surprise me in that they could build it into the run engine. The hardest part of UDO is realizing when you write it yourself you can mix objects and arrays without being explicit. Not so with UDO. UDO allows you to mix and match objects and arrays but you must set them up as separate handles. Hopefully that helps, Doug www.u2logic.com/applications.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/5026 - Release Date: 05/27/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SHA256 digest possible?
The Digest function looks to only allow MD5 or SHA1, SHA256 is SHA2 but digest does not appear to support that. I am not sure what the ENCRYPT function allows. The manual says there is a list of ciphers in the Unibasic Extensions manual, but I cannot find any listing of those in there Otherwise, if you are on linux you could use sha256sum e.g echo -n string to digest | sha256sum -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael McGlothlin Sent: 23 May 2012 22:04 To: U2 Users List Subject: [U2] SHA256 digest possible? Not an expert in U2 so this could be stupid.. I'm using DIGEST and OCONV to produce a hex digest of plain-text passwords as users enter them. Passwords created through external sources are SHA256 so I was wondering if there is a way to get that to happen in UniBasic? PRSLT = DIGEST('sha1',PWD,1,PDIGEST) PHASH = OCONV(PDIGEST, 'MX0C') Michael McGlothlin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/5017 - Release Date: 05/23/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] training material on LOCKS
But locking is very different in the Sql server world, and much of it is done by the server itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 11 May 2012 17:22 To: U2 Users List Subject: Re: [U2] training material on LOCKS Brian You are too generous, I am stunned at how few SQL developers understand locking. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4990 - Release Date: 05/10/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: Feed Engine
What type of feed ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 10 May 2012 17:05 To: U2 Users List Subject: [U2] Regarding: Feed Engine Hi, Can any one of you explain how to run a feed engine with older than a particular date. Thank you, Satya ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4988 - Release Date: 05/09/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] training material on LOCKS
I think the problem is much of this topic is dependent on the Database being discussed. E.g this http://www.sqlteam.com/article/introduction-to-locking-in-sql-server is a fairly good description of sql server locking, but is largely irrelevant to U2. If anything were to be written that was completely generic it would probably be in the realms of computer science and database theory and be too theoretical to be of any practical use. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 09 May 2012 14:45 To: U2 Users List Subject: [U2] training material on LOCKS Even though It is a foundational concept for any multi-user database management, several times in my career I have come across seasoned MV programmers who do not understand the basics of readu locks (let alone related topics like file locks, deadlocks, group locks, L-locks, transactions, optimistic/pessimistic, lock table, monitoring configuring.) Has anyone ever put that specific material into some kind of training module? An article in Spectrum? Infocus? A conference session? TIA for any leads, cds ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4986 - Release Date: 05/08/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command that turns off default command stacker
Hi Satya Firstly please start a new conversation if you want, rather than replying to something on a different topic. As far as information, your unidata installation media should contain a clients cd that has all the documentation and development tools you will need. If you require further training, I am sure the VAR you bought the database from will be only too happy to help. Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 07 May 2012 18:19 To: U2 Users List Subject: Re: [U2] Command that turns off default command stacker Hi to every one, I am heart fully Thank to one and all for sharing important information including with me may i know the some logic of the pick basic 7.3 version can u guys forward some material based on unidata please Thank you, Satya On Mon, May 7, 2012 at 10:22 PM, George Gallen ggal...@wyanokegroup.comwrote: Idk, What happens on the second entry into Finish? If there wasn't a gosub to start with? Will it just error out, or just drop out of the program? I haven't tried it, just my 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 07, 2012 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that turns off default command stacker Finish... return to finish Isn't this an infinite loop? FINISH: RETURN TO FINISH END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *satya king** software professional* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4983 - Release Date: 05/07/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command that turns off default command stacker
Try http://www.rocketsoftware.com/u2 and take a look around. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 08 May 2012 15:16 To: U2 Users List Subject: Re: [U2] Command that turns off default command stacker Hi Symeon Can you give the detail information about the difference between Unidata Universe Thank you, Satya. On Tue, May 8, 2012 at 5:18 PM, Symeon Breen syme...@gmail.com wrote: Hi Satya Firstly please start a new conversation if you want, rather than replying to something on a different topic. As far as information, your unidata installation media should contain a clients cd that has all the documentation and development tools you will need. If you require further training, I am sure the VAR you bought the database from will be only too happy to help. Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 07 May 2012 18:19 To: U2 Users List Subject: Re: [U2] Command that turns off default command stacker Hi to every one, I am heart fully Thank to one and all for sharing important information including with me may i know the some logic of the pick basic 7.3 version can u guys forward some material based on unidata please Thank you, Satya On Mon, May 7, 2012 at 10:22 PM, George Gallen ggal...@wyanokegroup.comwrote: Idk, What happens on the second entry into Finish? If there wasn't a gosub to start with? Will it just error out, or just drop out of the program? I haven't tried it, just my 2c -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 07, 2012 12:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that turns off default command stacker Finish... return to finish Isn't this an infinite loop? FINISH: RETURN TO FINISH END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4983 - Release Date: 05/07/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *satya king** software professional* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2425/4984 - Release Date: 05/07/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hi
Hello Satya and welcome to the group. Rgds Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: 03 May 2012 16:00 To: u2-users@listserver.u2ug.org Subject: [U2] Hi Hi This satya ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2411/4974 - Release Date: 05/02/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] READU vs READ
Have you been able to do any os level tools to see what the utilisation of resources is. E.g. on linux, vmstat, top, iostat will show you if it is a diskio or cpu bottleneck. If it is diskio (i.e. high wait on io times) then you may need to upgrade the disks or add more ram so you have more data in cache. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: 01 May 2012 02:58 To: U2 Users List Subject: Re: [U2] READU vs READ Oh ... you're good ... I ALMOST pasted it ... I know better that to put even FICTITIOUS code on this board ... unless I'm just trying to rile things up about the OS. |-) I do appreciate all of the input. Thank y'all for the info. I'll see what I can do. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, April 30, 2012 9:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] READU vs READ why not post the relevant code you are using to do the field updates perhaps we can see some inefficiency in the way you're grabbing and updating fields you said the records were sizeable and that raises my eyebrow (just one) -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Apr 30, 2012 6:38 pm Subject: Re: [U2] READU vs READ No indexes and no triggers. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Monday, April 30, 2012 9:22 PM To: U2 Users List Subject: Re: [U2] READU vs READ Add to the mix indexes and triggers. They can both add to the time needed to update just one record. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, 1 May 2012 11:12 AM To: U2 Users List Subject: Re: [U2] READU vs READ Inefficient file sizing and disk I/O are your possible issues with slowness. You might be able to address the first at your desk, the latter may require a purchase order. How old is your hardware? We recently upgraded to a virtual server and just using more current technology hard drives we doubled all of our disk I/O from what we had 5 or 6 years ago. CPU speed increased as well, but that was not as suprising. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, April 30, 2012 6:01 PM To: U2 Users List Subject: Re: [U2] READU vs READ Yes, using SELECT and READNEXT. These are sizable records. The logic is very straight forward, just updating several multi-valued fields in each record (month end). 500,000 have been updated and I'm 2:45:00 into the process. _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1EE0zigg55/70gcZxRJUITQXy3UHcVFYT/ 0.002 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended
Re: [U2] The CONTINUE statement
Personally I am a big fan of both CONTINUE and EXIT ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 26 April 2012 22:12 To: u2-users@listserver.u2ug.org Subject: [U2] The CONTINUE statement FOR I = 1 TO X do something IF some condition THEN CONTINUE do something else NEXT I versus FOR I = 1 TO X do something IF NOT(some condition) THEN do something else NEXT I ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2411/4960 - Release Date: 04/26/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On 2 - neither java or c# (or vb.net) are functional (f# is) - and the whole closure/lambda thing - should we introduce that to databasic ?? ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 26 April 2012 17:37 To: U2 Users List Subject: Re: [U2] YYMMDD easy way? 1. SLoC = Source Lines of Code. Complaining about code bloat reminds me of the king in the Amadeus movie complaining about... too many notes. 2. Just like when .Net came out and many VB programmers moaned about the horrors of object-oriented programming... there is some fresh angst forthcoming with the new closure functionality in Java 8. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, April 26, 2012 10:57 AM Subject: Re: [U2] YYMMDD easy way? Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. / I'm not sure what you're trying to say (brain in molasses mode today). Charlie ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2411/4960 - Release Date: 04/26/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
Out of interest, how big is this file and how many records ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 25 April 2012 21:30 To: 'U2 Users List'; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even
Re: [U2] Huge Dynamic Unidata file
That's is pretty big, my personal experience with big files on udt was up to about 60Gig - we did use memresize no problems - but had to set the TMPPATH to another drive. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 26 April 2012 12:00 To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file Indexes and all, 91 G with about 75 million records. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 26, 2012 4:08 AM To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file Out of interest, how big is this file and how many records ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 25 April 2012 21:30 To: 'U2 Users List'; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs
Re: [U2] Huge Dynamic Unidata file
You are of course right - in my defence it was a few years ago ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 26 April 2012 12:21 To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I thought TMPPATH was not valid for Dynamic files: ?? The TMPPATH option is invalid if any DYNAMIC options are specified (or if the starting file is dynamic and no file type options are specified). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 26, 2012 6:18 AM To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file That's is pretty big, my personal experience with big files on udt was up to about 60Gig - we did use memresize no problems - but had to set the TMPPATH to another drive. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 26 April 2012 12:00 To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file Indexes and all, 91 G with about 75 million records. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 26, 2012 4:08 AM To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file Out of interest, how big is this file and how many records ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 25 April 2012 21:30 To: 'U2 Users List'; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have