Re: [U2] [UD] BASIC Code Failing
Hi Brian That's a good idea to do what you have done and do in mvStamp... I guess what I'm also look at is that the use of MD5 checksums (for example) is a 'well known/accepted and platform independent' mechanism to verify files are 'as they should be'. Hence, in theory you quickly detect changes that have occurred to the object, source and catalog version in simple independent way without even referencing back a source control system. Plus in UV BASIC you now have the ENCODE and ENCRYPT functions to help you check/secure your code - if you so desire - post-implementation. Here's simple compilation comparison before and after...obviously you can extend it to the source changes in catdir, etc. $ openssl md5 /my/PROGRAMS/BP.O/test123 MD5(/my/PROGRAMS/BP.O/test123)= 7e3743a1ac709cca2f9e1dd034e19048 $ nbasic BP test123 Compiling: Source = '/my/PROGRAMS/BP/test123, Object = '/my/PROGRAMS/BP.O/test123 *** Compilation Complete. $ openssl md5 /my/PROGRAMS/BP.O/test123 MD5(/my/PROGRAMS/BP.O/test123)= 080524f5d4da1c363298e2e538d3cf49 $ openssl md5 `cat /.uvhome`/catdir/'*test123 MD5(/usr/ibm/uv/catdir/*test123)= 05b3b02a4369915e448af6837160ac8f $ Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, 1 August 2013 11:13 PM To: 'U2 Users List' Subject: Re: [U2] [UD] BASIC Code Failing Dale The stamp I use assigns a dummy variable using strings that contain searchable keys. That means when the code is compiled these strings end up unaltered in the object code string table, so that they can be easily found and extracted. For example: VERDATA='' VERDATA := 'Version=001000136;' VERDATA := 'VerBeta=;' VERDATA := 'VerDate=16637;' VERDATA := 'VerProd=mvPDF;' VERDATA := 'VerTM=mvPDF;' VERDATA := 'VerCopy=2013 Brian Leach Consulting Limited;' VERDATA := 'VerCo=Brian Leach Consulting Limited;' VERDATA := 'VerDesc=Produce a PDF Document by merging data;' VERDATA := 'CatName=PDF.MERGE;' VERDATA := 'VerModule=GENERAL;' VERDATA := 'VerModVer=002003022;' VERDATA := 'VerHist=19 JUL 13 1.0.136 Release 2.3.22;' A useful addition is that I have a I Descriptor that returns this, so I can list the source or object file and rip out these details: LIST pdf.bp.O PDF.MERGE 01:02:24pm 01 Aug 2013 PAGE1 pdf.bp.O.. Version.. Version Description... Module Version PDF.MERGE 1.0.136 Produce a PDF Document by merging data 2.3.22 I did put some free code on my website to do this - look for mvStamp. As for cutting or build scripts, these refer to anything that builds your software.. every site should have something to do this, to ensure a smooth and automated transition from test to live or for deployment. In my case, the build process usually consists of a script written in vbscript (WSH) that runs the various client side builds (for Delphi, C# etc.) then uses UniObjects to execute a server side cutting paragraph passing the new version number. This typically updates the version stamps, recompiles everything, handles any platform builds (most of my stuff runs on UniVerse, UniData, QM and D3), updates a README document from my task system, adds them all into revision control, then calls mvInstaller to build the release package. Then control passes back to the vbscript to assemble the setup (InstallShield or visual studio) and zip the resulting setup ready for upload. I did think about kicking off all the unit tests as well but I prefer to do that after a test installation. All of which took some setting up to begin with but has saved enormous amounts of time and agony since. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: 01 August 2013 12:27 To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing Brian, Is the stamp just VERSION = 123 ,? Could you explain what you mean by cutting routines, I've either never heard that term or my old timers is kicking in. dale On 08/01/2013 06:09 AM, Brian Leach wrote: David I add version stamps to my code that compile into the object code, so at least I can easily check that the source and object (including that in catdir) matches what I expect. That's at least a small and easy step in the right direction, though that doesn't rule out changes that don't update the stamp of course. The stamps are always updated by my cutting routines and then the items are then added to source control as part of the cut... If you did something similar you can always diff what you've got against your source code control system rather than reinventing the
[U2] Fwd: Re: What is true
On UV, if you want to see if parentheses make a difference, write similar lines with without, compile, VLIST to decomiple the object to a readable form. It reads like assembler, but you have the source line with it so it's really really easy to figure out what it's doing. Building on Tom Tony's examples: CT CDS.BP PAREN.TEST PAREN.TEST 0001IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' ;* Test 1 0002IF A THEN CRT 'TRUE' ELSE CRT 'FALSE' 0003 0004CALL FOO( X, Y, Z ) ;* Test 2 0005CALL FOO( X, Y, (Z) ) 0006CRT Z 0007 0008X = Y = 3 ;* Test 3 0009 END VLIST CDS.BP PAREN.TEST 1:IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' ;* Test 1 1 0 : 2DE testfw A 00014: 1 8 : 046 crtcrlfTRUE 1 E : 0C2 jump 0001A: 1 00014 : 046 crtcrlfFALSE 2:IF A THEN CRT 'TRUE' ELSE CRT 'FALSE' 2 0001A : 2DE testfw A 00030: 2 00024 : 046 crtcrlfTRUE 2 0002A : 0C2 jump 00036: 2 00030 : 046 crtcrlfFALSE 3: 4:CALL FOO( X, Y, Z ) ;* Test 2 4 00036 : 01E call FOO X Y Z 5:CALL FOO( X, Y, (Z) ) 5 00042 : 0F8 move Z = _T 5 00048 : 01E call FOO X Y _T 6:CRT Z 6 00054 : 046 crtcrlfZ 7: 8:X = Y = 3 ;* Test 3 8 0005A : 06E eq Y 3 = X 9: END 9 00062 : 190 stop Test 1:Lines 1 2 compile exactly the same. parens didn't matter. Test 2: It doesn't take a genius to see that _T is some sort of temporary variable that the compiler created. Enclosing in parentheses is a way to pass by value instead of by address. Z will remain unchanged by CALL FOO(X,Y,(Z)), since _T is what's really passed back forth, then ignored upon return. Original Message Subject:Re: [U2] What is true Date: Thu, 1 Aug 2013 10:51:49 -0400 From: Tom Whitmore tewhitm...@ratex.com Reply-To: U2 Users List u2-users@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Here is a simple program I wrote and ran on UV 11.1.9. It would be interesting to hear if UD behaves the same way. 0001: A='' 0002: CRT 'A = ':QUOTE(A):' ': 0003: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0004: A=0 0005: CRT 'A = ':QUOTE(A):' ': 0006: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0007: A='HELLO' 0008: CRT 'A = ':QUOTE(A):' ': 0009: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0010: A=1 0011: CRT 'A = ':QUOTE(A):' ': 0012: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' The results are: A = FALSE A = 0 FALSE A = HELLO TRUE A = 1 TRUE Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Swain Sent: Thursday, August 01, 2013 8:24 AM To: U2 Users List Subject: Re: [U2] What is true This is not true as when A='HELLO' IF (A) returns true. You use the parenthesis to set a Boolean variable, i.e BRITISH = (COUNTRY = 'ENGLAND' OR COUNTRY = 'WALES') etc the var BRITISH is set to 1 when the conditions inside the parenthesis are met, otherwise BRITISH is set to 0 Jim Swain - Developer Telephone: +44 (0) 1295 701 810 | Fax: +44 (0) 1295 701 819 www.zafire.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] BASIC Code Failing
If you were to copy your source code to another location and then compile and compare the object, would the two objects be the same? -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Aug 1, 2013 4:10 am Subject: Re: [U2] [UD] BASIC Code Failing David I add version stamps to my code that compile into the object code, so at least I can easily check that the source and object (including that in catdir) matches what I expect. That's at least a small and easy step in the right direction, though that doesn't rule out changes that don't update the stamp of course. The stamps are always updated by my cutting routines and then the items are then added to source control as part of the cut... If you did something similar you can always diff what you've got against your source code control system rather than reinventing the wheel. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: 01 August 2013 10:49 To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing In UV we're had similar strange problems with seemingly unchanged source/object code - not work as per normal and things going amiss for no good reason...once we found the object code in BP and the catalog space were mismatched and simply re-catalog'd it. Another time we re-compiled a program - as it was always invoked via RUN BP PROGNAME... in both instances the problem seem to go away. This was in a controlled product environment so it's in highly unlikely someone could of or would've changed the code... In UV you can do a VCATALOG to verify the BASIC object to what is actually catalogued... All of these issues made me wonder if our implementation routines need to have a more robust. More robust in terms of storing some control information for both pre/post verification - hence being able to detect 'unauthorised changes' through the various stages. This could include calculating and storing (say) MD5 (etc) hashes on the source and object to cross verify changes. Hence, make it more easy to detect object or source changes outside the authorised/control deployment process... without having to go through every single file and comparing to tape or disk backups, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 31 July 2013 6:06 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing John: That's an interesting thought. We do backups of the application account every night, so I do have the last 10 days object code in a backup (plus the last four months weekly backups). I'll look at this the next time it happens. Thanks, Bill Untitled Page - Original Message - *From:* jhes...@momtex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/30/2013 11:01 AM *Subject:* Re: [U2] [UD] BASIC Code Failing I would also consider the possibility of data corruption at the hardware level. Granted, I would expect that you'd also occasionally find anomalies within your source code and data files if this were the case, but I don't know how your filesystems are set up. If the object code has become corrupt, that would explain why recompiling fixes the problem. The newly created object code will be stored on a new location in the filesystem. Fortunately this possibility is very easy to test for. Just make a copy of your application account on alternate storage and wait for the problem to recur. When it does, open the live object file and your backup copy in an editor with diff capability (Notepad++ is a good one) and see if they still match. -John ** 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org
[U2] Copy File to SharePoint
We are running HPUX w/ UniData 7.2. We also have a Windows box running SharePoint. In MANY situations, we have built an export file in a UNIX directory (like a tab-delimited txt file), then used Samba to copy the file from the UNIX box to a networked drive. This does not work with a box running SharePoint because the directories shown on the SharePoint box are not real directories. They are simply renderings of a Sequel query (or something like that - not my area of expertise). Thus, Samba cannot connect to one of these fake SharePoint directories. Has anyone figured out a way to take a file from UNIX and copy it into SharePoint? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What is true
To me the purpose is that -- it helps when reading the code If more effort is spent on the next programmer understanding what your code is doing that is time well worth spent -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Aug 1, 2013 11:16 am Subject: Re: [U2] What is true Hi again, I have been on a site where they insisted that A = B = C should be written as A = B EQ C to emphasise that the second operator is a relational test. Personally, I use A = (B = C) even though the brackets serve no purpose. It just helps when reading the code. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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] XML or JSON converter for Unibasic
I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Copy File to SharePoint
John: Consider using Adobe ColdFusion as the middleware between UniData and SharePoint. (A free developer version of) CF could be installed on the Windows box... or almost anywhere. There is an article Integrating ColdFusion applications with Microsoft SharePoint using ColdFusion. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 2, 2013 11:45 AM To: U2 Users List Subject: [U2] Copy File to SharePoint We are running HPUX w/ UniData 7.2. We also have a Windows box running SharePoint. In MANY situations, we have built an export file in a UNIX directory (like a tab-delimited txt file), then used Samba to copy the file from the UNIX box to a networked drive. This does not work with a box running SharePoint because the directories shown on the SharePoint box are not real directories. They are simply renderings of a Sequel query (or something like that - not my area of expertise). Thus, Samba cannot connect to one of these fake SharePoint directories. Has anyone figured out a way to take a file from UNIX and copy it into SharePoint? 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] XML or JSON converter for Unibasic
My preferred solution is to use a middle tier web service in C#, that exposes method calls for either XML or JSON (automatic, just depends on the content-type in the request). Then you can call that from anything that expects JSON or SOAP. But that's only because I began doing that long before restful web services got built into the product. Or bypass PHP and use mvScript if you can live with IIS. Brian -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: 02 August 2013 17:12 To: U2 Users List Subject: [U2] XML or JSON converter for Unibasic I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Pick flavor in U2 personal edition
I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML or JSON converter for Unibasic
We use UNIX on our web and database servers, so the mvScript wouldn't help in our case. I would like to learn more about the built-in restful services you mentioned. That is built-in to Unidata? We are at 7.2. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 08/02/2013 11:41 AM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org My preferred solution is to use a middle tier web service in C#, that exposes method calls for either XML or JSON (automatic, just depends on the content-type in the request). Then you can call that from anything that expects JSON or SOAP. But that's only because I began doing that long before restful web services got built into the product. Or bypass PHP and use mvScript if you can live with IIS. Brian -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: 02 August 2013 17:12 To: U2 Users List Subject: [U2] XML or JSON converter for Unibasic I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 was Virus checked by UTM 9. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
If you loaded Unidata -the command is ECLTYPE P for the pick-flavored query parser. ECLTYPE U for the regular parser. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Friday, August 02, 2013 12:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pick flavor in U2 personal edition I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML or JSON converter for Unibasic
JSON is far more lightweight vs XML. Also if you upgrade to 7.3 Unidata, the built-in JSON library (called UDO) is very easy to use. This would be my recommendation. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Aug 2, 2013 at 12:59 PM, charles_shaf...@ntn-bower.com wrote: We use UNIX on our web and database servers, so the mvScript wouldn't help in our case. I would like to learn more about the built-in restful services you mentioned. That is built-in to Unidata? We are at 7.2. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 08/02/2013 11:41 AM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org My preferred solution is to use a middle tier web service in C#, that exposes method calls for either XML or JSON (automatic, just depends on the content-type in the request). Then you can call that from anything that expects JSON or SOAP. But that's only because I began doing that long before restful web services got built into the product. Or bypass PHP and use mvScript if you can live with IIS. Brian -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: 02 August 2013 17:12 To: U2 Users List Subject: [U2] XML or JSON converter for Unibasic I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 was Virus checked by UTM 9. http://www.astaro.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] Pick flavor in U2 personal edition
With Universe you will be prompted for the account flavor when you create an account Eric Armstrong wrote: I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- 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
Re: [U2] Pick flavor in U2 personal edition
Hi Eric, You can set it at TCL using the command: ECLTYPE P (Typing ECLTYPE at the prompt will display its current setting) Alternatively create a new VOC entry called LOGIN, in the account you intend to work in and this will be ran each time you logon... LOGIN: PA TERM sterm TERM 79 UDT.OPTIONS 4 ON UDT.OPTIONS 9 ON UDT.OPTIONS 24 ON UDT.OPTIONS 29 ON UDT.OPTIONS 34 ON UDT.OPTIONS 43 ON UDT.OPTIONS 48 ON UDT.OPTIONS 78 ON UDT.OPTIONS 86 ON UDT.OPTIONS 97 ON UDT.OPTIONS 98 ON UDT.OPTIONS 109 ON ECLTYPE P BASICTYPE P SORT.TYPE 1 FLOAT.PRECISION 2 (Change TERM sterm to your preferred terminal emulation i.e. TERM vt100 and UDT.OPTIONS as you see fit.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: 02 August 2013 17:53 To: u2-users@listserver.u2ug.org Subject: [U2] Pick flavor in U2 personal edition I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the 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
Re: [U2] Pick flavor in U2 personal edition
Hi Eric, Forgot to mention - We are running Unidata 7.2 on Windows. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norrie Steele Sent: 02 August 2013 18:33 To: 'U2 Users List' Subject: Re: [U2] Pick flavor in U2 personal edition Hi Eric, You can set it at TCL using the command: ECLTYPE P (Typing ECLTYPE at the prompt will display its current setting) Alternatively create a new VOC entry called LOGIN, in the account you intend to work in and this will be ran each time you logon... LOGIN: PA TERM sterm TERM 79 UDT.OPTIONS 4 ON UDT.OPTIONS 9 ON UDT.OPTIONS 24 ON UDT.OPTIONS 29 ON UDT.OPTIONS 34 ON UDT.OPTIONS 43 ON UDT.OPTIONS 48 ON UDT.OPTIONS 78 ON UDT.OPTIONS 86 ON UDT.OPTIONS 97 ON UDT.OPTIONS 98 ON UDT.OPTIONS 109 ON ECLTYPE P BASICTYPE P SORT.TYPE 1 FLOAT.PRECISION 2 (Change TERM sterm to your preferred terminal emulation i.e. TERM vt100 and UDT.OPTIONS as you see fit.) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: 02 August 2013 17:53 To: u2-users@listserver.u2ug.org Subject: [U2] Pick flavor in U2 personal edition I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the 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
Re: [U2] XML or JSON converter for Unibasic
I do this sort of thing all the time. I'm also curious to know if a Uni-query can be rendered directly as XML or JSON. I know QM can render as XML with a simple modifier on the command-line, thought U2 could do this too. JSON is a different animal and I'm not aware of any decent JSON builders for any MV environment - they're all proprietary and unpublished except for the new one in Unidata. The real problem with all of these XML/JSON solutions is that the output we get from our reports is 2-dimensional columns and rows - a curious anomaly after all of these years, considering how much we pride ourselves on being multi-dimensional. XML and JSON aren't of much use with flat data. Coding a 2D export to XML or JSON is trivial. Where this gets complex is in nested relationships, XML and JSON excel in representation of multi-dimensional data, and again, none of the MV platforms have rushed to provide decent rendering in this area. (Except maybe TigerLogic which has built a rich XML server around the D3 core, like DataStage was built around Universe.) In plain terms, a U2 report will have something like: ORD# SHIP.ADDR SHIP.CITY ... ORD# SHIP.ADDR SHIP.CITY ... That's 2D. But when you're passing data to another environment, it expects 3D: order id123/id shipto addr.../addr city.../city /shipto /order JSON is exactly the same as XML in structure, just different in syntax. Part of the problem is that the output here needs to use names which are acceptable in XML/JSON tags. That might come from the dict item, probably not unless you have custom dict items just for this. The way this is usually done is with metadata stored in the dict item or somewhere else. So you'll have a dict item named ORD#, the description might say Order ID but the node name will be id. Note above that I'm using id123/id. But that could have been done like this: order id=123 The issue here is that there is no schema definition that defines whether you use elements (unique nodes) or attributes (id=123) within elements. Hardcoded general-purpose solutions will work for your internal purposes but they won't work as a general solution for exchanging data with other entities. And let's not even get into namespaces. In summary, the above explains why it's tough to have a general-purpose solution for rendering query output as XML or JSON. A lot of other metadata is required in order to describe what the document will look like. The only recourse we have is to use the XML hooks provided in the DBMS, to hard-code on a case-by-case basis, or to export and let some external tool do the formatting ... but in all cases you still need to provide metadata or none of these tools will know whether to use id or ordnum, or whether to use elements or attributes. All of that said, the nature of my business is to create solutions to problems like this. I'll be happy to do so for any company that associates value with such solutions. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv/nebulaware From: Charles_Shaffer I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
From: Eric Armstrong I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? If I care about the flavor I'll use UniAdmin to create accounts - or whatever they call that thing now that takes 10 minutes to start up on a system with no other activity. ;) HTH T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Trigger are useful to find programs that update files incorrectly. When this happens, I create a trigger that will create a sequential file with the content of SYSTEM(9001) on Universe in order to identify the chain of calling programs. From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, August 1, 2013 5:32 AM Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ 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
Re: [U2] XML or JSON converter for Unibasic
7.3 has a built-in JSON library. That's what I was looking for. Thanks Charles Shaffer Senior Analyst NTN-Bower Corporation From: Aaron Titus ati...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 08/02/2013 12:14 PM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org JSON is far more lightweight vs XML. Also if you upgrade to 7.3 Unidata, the built-in JSON library (called UDO) is very easy to use. This would be my recommendation. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Aug 2, 2013 at 12:59 PM, charles_shaf...@ntn-bower.com wrote: We use UNIX on our web and database servers, so the mvScript wouldn't help in our case. I would like to learn more about the built-in restful services you mentioned. That is built-in to Unidata? We are at 7.2. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 08/02/2013 11:41 AM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org My preferred solution is to use a middle tier web service in C#, that exposes method calls for either XML or JSON (automatic, just depends on the content-type in the request). Then you can call that from anything that expects JSON or SOAP. But that's only because I began doing that long before restful web services got built into the product. Or bypass PHP and use mvScript if you can live with IIS. Brian -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: 02 August 2013 17:12 To: U2 Users List Subject: [U2] XML or JSON converter for Unibasic I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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 was Virus checked by UTM 9. http://www.astaro.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 was Virus checked by UTM 9. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Anti-fraud software
Hi Jerry, Depending on what you specifically mean by anti-fraud. Many companies come to me/PRC for the IT controls to detect / prevent change, guarding software and data. Is that the sort of thing you mean? Please feel free to contact me and we can talk about it. Or - if this is not what you are trying to get to, please explain! Thanks, Susan Joslyn sjos...@sjplus.com PRC - IT Governance for U2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML or JSON converter for Unibasic
Very good advice. I did know that XML support was built-in to Unidata, and apparently JSON support is included in the newest version of Unidata. I guess I am leaning towards JSON because as Aaron Titus pointed out, it is more lightweight than XML. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org, Date: 08/02/2013 01:05 PM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org I do this sort of thing all the time. I'm also curious to know if a Uni-query can be rendered directly as XML or JSON. I know QM can render as XML with a simple modifier on the command-line, thought U2 could do this too. JSON is a different animal and I'm not aware of any decent JSON builders for any MV environment - they're all proprietary and unpublished except for the new one in Unidata. The real problem with all of these XML/JSON solutions is that the output we get from our reports is 2-dimensional columns and rows - a curious anomaly after all of these years, considering how much we pride ourselves on being multi-dimensional. XML and JSON aren't of much use with flat data. Coding a 2D export to XML or JSON is trivial. Where this gets complex is in nested relationships, XML and JSON excel in representation of multi-dimensional data, and again, none of the MV platforms have rushed to provide decent rendering in this area. (Except maybe TigerLogic which has built a rich XML server around the D3 core, like DataStage was built around Universe.) In plain terms, a U2 report will have something like: ORD# SHIP.ADDR SHIP.CITY ... ORD# SHIP.ADDR SHIP.CITY ... That's 2D. But when you're passing data to another environment, it expects 3D: order id123/id shipto addr.../addr city.../city /shipto /order JSON is exactly the same as XML in structure, just different in syntax. Part of the problem is that the output here needs to use names which are acceptable in XML/JSON tags. That might come from the dict item, probably not unless you have custom dict items just for this. The way this is usually done is with metadata stored in the dict item or somewhere else. So you'll have a dict item named ORD#, the description might say Order ID but the node name will be id. Note above that I'm using id123/id. But that could have been done like this: order id=123 The issue here is that there is no schema definition that defines whether you use elements (unique nodes) or attributes (id=123) within elements. Hardcoded general-purpose solutions will work for your internal purposes but they won't work as a general solution for exchanging data with other entities. And let's not even get into namespaces. In summary, the above explains why it's tough to have a general-purpose solution for rendering query output as XML or JSON. A lot of other metadata is required in order to describe what the document will look like. The only recourse we have is to use the XML hooks provided in the DBMS, to hard-code on a case-by-case basis, or to export and let some external tool do the formatting ... but in all cases you still need to provide metadata or none of these tools will know whether to use id or ordnum, or whether to use elements or attributes. All of that said, the nature of my business is to create solutions to problems like this. I'll be happy to do so for any company that associates value with such solutions. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv/nebulaware From: Charles_Shaffer I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Virus checked by UTM 9. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
Thanks to all who responded. I am using Universe 11.1.12 I currently have only one acct, C:\U2\UvPe. I don't see UniAdmin anywhere. Where would I find it and/or where do I get it? Thanks in advance, Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
Eric see https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/103/newinstall.pdf When you Create an Account it asks for the flavor, or at least allows you to specify the flavor. -Original Message- From: Eric Armstrong earmstr...@lobelfinancial.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Aug 2, 2013 1:19 pm Subject: Re: [U2] Pick flavor in U2 personal edition Thanks to all who responded. I am using Universe 11.1.12 I currently have only one acct, C:\U2\UvPe. I don't see UniAdmin anywhere. Where would I find it and/or where do I get it? Thanks in advance, Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the 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
Re: [U2] Pick flavor in U2 personal edition
XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/try-now Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Friday, August 02, 2013 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Thanks to all who responded. I am using Universe 11.1.12 I currently have only one acct, C:\U2\UvPe. I don't see UniAdmin anywhere. Where would I find it and/or where do I get it? Thanks in advance, Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the 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
Re: [U2] XML or JSON converter for Unibasic
Charles, if you're not on 7.3 the built-in JSON parser isn't going to help much. In that case, I may be able to help you out. We move lots of JSON between Unidata and our Red Leaf web portal. On Fri, Aug 2, 2013 at 1:19 PM, charles_shaf...@ntn-bower.com wrote: Very good advice. I did know that XML support was built-in to Unidata, and apparently JSON support is included in the newest version of Unidata. I guess I am leaning towards JSON because as Aaron Titus pointed out, it is more lightweight than XML. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org, Date: 08/02/2013 01:05 PM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org I do this sort of thing all the time. I'm also curious to know if a Uni-query can be rendered directly as XML or JSON. I know QM can render as XML with a simple modifier on the command-line, thought U2 could do this too. JSON is a different animal and I'm not aware of any decent JSON builders for any MV environment - they're all proprietary and unpublished except for the new one in Unidata. The real problem with all of these XML/JSON solutions is that the output we get from our reports is 2-dimensional columns and rows - a curious anomaly after all of these years, considering how much we pride ourselves on being multi-dimensional. XML and JSON aren't of much use with flat data. Coding a 2D export to XML or JSON is trivial. Where this gets complex is in nested relationships, XML and JSON excel in representation of multi-dimensional data, and again, none of the MV platforms have rushed to provide decent rendering in this area. (Except maybe TigerLogic which has built a rich XML server around the D3 core, like DataStage was built around Universe.) In plain terms, a U2 report will have something like: ORD# SHIP.ADDR SHIP.CITY ... ORD# SHIP.ADDR SHIP.CITY ... That's 2D. But when you're passing data to another environment, it expects 3D: order id123/id shipto addr.../addr city.../city /shipto /order JSON is exactly the same as XML in structure, just different in syntax. Part of the problem is that the output here needs to use names which are acceptable in XML/JSON tags. That might come from the dict item, probably not unless you have custom dict items just for this. The way this is usually done is with metadata stored in the dict item or somewhere else. So you'll have a dict item named ORD#, the description might say Order ID but the node name will be id. Note above that I'm using id123/id. But that could have been done like this: order id=123 The issue here is that there is no schema definition that defines whether you use elements (unique nodes) or attributes (id=123) within elements. Hardcoded general-purpose solutions will work for your internal purposes but they won't work as a general solution for exchanging data with other entities. And let's not even get into namespaces. In summary, the above explains why it's tough to have a general-purpose solution for rendering query output as XML or JSON. A lot of other metadata is required in order to describe what the document will look like. The only recourse we have is to use the XML hooks provided in the DBMS, to hard-code on a case-by-case basis, or to export and let some external tool do the formatting ... but in all cases you still need to provide metadata or none of these tools will know whether to use id or ordnum, or whether to use elements or attributes. All of that said, the nature of my business is to create solutions to problems like this. I'll be happy to do so for any company that associates value with such solutions. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://bitbucket.org/foss4mv/nebulaware From: Charles_Shaffer I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] What is true
Or as we say it here: The way you write code today will determine the words used to describe you six months from now. On Fri, Aug 2, 2013 at 10:00 AM, Wjhonson wjhon...@aol.com wrote: To me the purpose is that -- it helps when reading the code If more effort is spent on the next programmer understanding what your code is doing that is time well worth spent -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Aug 1, 2013 11:16 am Subject: Re: [U2] What is true Hi again, I have been on a site where they insisted that A = B = C should be written as A = B EQ C to emphasise that the second operator is a relational test. Personally, I use A = (B = C) even though the brackets serve no purpose. It just helps when reading the code. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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
