Re: [U2] ODBC - Not finding the MV fields.
Chris: 1. For things here, I usually create a new DICTionary... copy the old DICT to the new DICT... and strip out NAME and other DICT columns not needed by ODBC... in the new DICT. 2. A @SELECT of type PH is needed where the Phrase needs to specify the chosen fields... in the new DICT 3. LOGTO HS.ADMIN. 4. Launch HS.ADMIN. 5. Run 6... Update File Info Cache in an account. 6. I hope that this helps. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, February 13, 2014 4:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC - Not finding the MV fields. We're running UniVerse 11.x and we've had ODBC setup for a while but recently started to use it more. The single-value fields work just fine, but on some of the Multi-Value fields (only certain tables) we can get the ODCB to work in excel by manually entering the SQL command but they don't show in Microsoft Query. So the issue is that we don't see it in the Microsoft Query window, or even in Access (for certain tables). Is there anyway to debug why the MV on some tables work, but others don't? Is there a way to list the tables that ODBC recognizes? I tried using Dr. DeeBee and it wasn't much help since I didn't get a log after running it. Any help is appreciated, thanks. Chris ___ 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] ODBC - Not finding the MV fields.
Chris: 1. The legacy dictionaries here tend to have overhead not needed by ODBC. 2. Only after experiencing some difficult ODBC problems here... and trying to simplify the problem... did I realize that some traditional DICT characteristics are problematic to ODBC. 3. While having two dictionaries for the same data is not my first choice... 4. When it works... it is a beautiful thing. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Friday, February 14, 2014 12:55 PM To: U2 Users List Subject: Re: [U2] ODBC - Not finding the MV fields. Bill, Not sure why you would do those 6 steps, when running HS.UPDATE.FILEINFO from a command line or program will do the same thing (reset the cache w the updated tables). I like to limit the amount of dictionary entries I have. Chris From: bi...@hkmetalcraft.com To: u2-users@listserver.u2ug.org Date: Fri, 14 Feb 2014 12:37:29 -0500 Subject: Re: [U2] ODBC - Not finding the MV fields. Chris: 1. For things here, I usually create a new DICTionary... copy the old DICT to the new DICT... and strip out NAME and other DICT columns not needed by ODBC... in the new DICT. 2. A @SELECT of type PH is needed where the Phrase needs to specify the chosen fields... in the new DICT 3. LOGTO HS.ADMIN. 4. Launch HS.ADMIN. 5. Run 6... Update File Info Cache in an account. 6. I hope that this helps. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, February 13, 2014 4:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC - Not finding the MV fields. We're running UniVerse 11.x and we've had ODBC setup for a while but recently started to use it more. The single-value fields work just fine, but on some of the Multi-Value fields (only certain tables) we can get the ODCB to work in excel by manually entering the SQL command but they don't show in Microsoft Query. So the issue is that we don't see it in the Microsoft Query window, or even in Access (for certain tables). Is there anyway to debug why the MV on some tables work, but others don't? Is there a way to list the tables that ODBC recognizes? I tried using Dr. DeeBee and it wasn't much help since I didn't get a log after running it. Any help is appreciated, thanks. Chris ___ 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] Report Generation
Consider mvQuery, CoreVu (from Rocket). I have been dabbling with Kendo UI and ColdFusion. --Bill Consider also an HT -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: Thursday, January 16, 2014 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. 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] Report Writer
We have a new General Manager here. He is interested in report writers for end users... I suppose like Crystal Reports... but that can handle MultiValue. While I am looking into Rocket's CoreVu... I am wondering what else is out there... --Bill ___ 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?
I have been writing uniBasic code in camelCase for a few years now. To me... there are major obvious readability advantages. Trying to convince other programmers of the merits seems to be an upHump battle. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, December 20, 2013 2:02 PM 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] BASIC code - upper, lower, CamelCase, what say you?
When using Rocket's BDT... upper-casing the commands is redundant since the editor automatically changes the color of this text to red. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, December 20, 2013 2:32 PM To: U2 Users List Subject: Re: [U2] BASIC code - upper, lower, CamelCase, what say you? This is really what got my thought-process flowing on this subject. I saw this code on github after the Rocket Software Whats New in 11.2 webinar: https://github.com/RocketSoftware/u2-servers-lab/blob/master/UniVerse-11.2/L ocal/BP/LocalMain PROGRAM LocalMain ** Let's have a quick look at local scoping CRT Calling the local SUBROUTINE CALL Main(@SENTENCE) ;* This will call Main() below, rather than an external subroutine CRT Back from the local SUBROUTINE END SUBROUTINE Main(Args) CRT Running inside the local SUBROUTINE CRT Args: :Args FOR Counter = 1 TO 3 CALL InnerLoop(Counter) NEXT Counter RETURN SUBROUTINE InnerLoop(OutsideCounter) * Notice this won't affect Main()'s 'Counter' variable due to scoping FOR Counter = 1 TO OutsideCounter CRT *: NEXT Counter CRT RETURN ___ 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] UniVerse Install on HP-Ux
Peter: Thanks... I will try this... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Sunday, December 15, 2013 5:35 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Install on HP-Ux How about making a copy of the cd/dvd to an iso and installing from that? Somewhere in *nix land where it's easier to mount and use the cd... # dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000 transport the resulting ISO to your HPUX machine # mount -F lofs /some/dir/to/uv.iso /tmp/mount You should then be able to cd to /tmp/mount and run the cpio command as root (or uvadm?) and follow the install instructions for hpux. # cpio -ivcBdum uv.load ./STARTUP # ./uv.load -longnames HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Saturday, 14 December 2013 10:49 To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. 2. There is this cpio command. 3. Is it necessary to install from a CD or DVD? 4. I would rather install from FTP'd files. 5. Mounting the media is a hassle... so is CDFS on a DVD. 6. Suggestions would be appreciated. --Bill ___ 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 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT Sluggish
Aaron: In line with Doug's suggestion... I created a tech support case with Rocket. BDT has a command prompt -clean launch option... that fixed it right away. Rocket also had some additional server-side troubleshooting measures that I did not try since step one corrected the problem. I suppose that I contact Rocket maybe once a year. As usual... I found Rocket's response to be... first rate. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Tuesday, December 3, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] BDT Sluggish Hello Bill, I use the BDT all day, every day, and I've never experienced this behavior, even over remote connections. I leave the syntax checking turned on all the time, and still I do not have any sluggishness or delayed behavior. I am wondering if you could be more specific as to exactly how you are using the BDT, as this may make a big difference. What specific task are you doing when you press a key and the delay appears? Is this in the resource view, or when editing a basic program, or editing file data? Finally it would be worth pointing out that the BDT is built on the Eclipse IDE, which is a notoriously heavy java program. I typically see the eclipse java process consuming over 500mb of memory even when idle. You would want to make sure that as a result of this you are not causing your computer to page the application. This may be happening if you have a lot of other applications open and not enough RAM. -Aaron On Thu, Nov 21, 2013 at 4:32 PM, Doug Averch dave...@gmail.com wrote: Hi Bill: I did notice a delay when you type in a program. BDT has a very long pause between characters. It has something to do with how the implemented their on the fly compiler. You will have to submit a issue with them. Hopefully, they will get it resolved in a few months or so. Regards, Doug www.u2logic.com/tools.html XLr8Editor for Universe and Unidata programmers On Thu, Nov 21, 2013 at 2:17 PM, Bill Brutzman bi...@hkmetalcraft.com wrote: 1. I just downloaded the latest Oct2013. 2. As with the earlier BDT release... each time I press a key... it takes two seconds to appear on the screen. 3. My PC that I am using BDT is Windows Pro 8.1... and the latest Symantec EndPoint Protect AntiVirus. 4. Suggestions would be appreciated. --Bill ___ 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
1. We use ColdFusion... as middleware. 2. I think of UniVerse as the back-end database. 3. Consider other middleware options... ASP.net, PHP, Java, TomCat, Spring, Ruby, Node.JS...etc. 4. I suppose a browser client app doing REST could maybe be workable. 5. Although bashing the middleman has become a sacred cow... now the middleman rocks and rules. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, October 30, 2013 3:01 PM 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] [OT] Interview Questions
I spent the last year or so... reading a lot of Ayn Rand. One of her key followers... the author Dr. Leonard Peikoff... wrote a book that I like called The DIM Hypothesis. DIM divides heads into three groups... [1] disintegrative [2] Integrative [3] misIntegrative. Writing code is all about reason and logic. Thus... I suppose that almost everybody on this list is mostly an I. On the other hand... most people do not write code. Consider MeetUp.com as a way to find the right stuff. Len's vanity California license plate reads DIMWIT. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData to SharePoint
John: I expect that MiddleWare would be needed. My first choice would be... 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: Thursday, August 15, 2013 10:09 AM To: U2 Users List Subject: [U2] UniData to SharePoint I have had E-mail gremlins lately, so I apologize in advance for asking this question again. We use UniData on an HPUX box. We also have SharePoint running on a Windows box. In that past, we have used Samba to push exports from UniData/HPUX to Windows servers, but SharePoint adds a wrinkle to this because what LOOKS like a folder on the SharePoint box from any other Windows box, is actually the results of SharePoint returning files based on a sequel query. Since it is not a REAL folder, I cannot use Samba to copy to that location. Has anyone figured out how to execute a UNIX command or UniData command to copy a file into a SharePoint database? 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
[U2] SQL Joins
I am wondering if anyone actually uses joins. We use UniVerse here. Bread and butter here is UniBasic... getting U2 data via reads of U2 tables. My problem with UniVerse SQL Joins has been twofold... [1] getting them to work [2] slow speeds for modestly-sized tables. Perhaps I need tips and tricks. I did a 3-table inner join in MySQL the other day... it was fast as lightning. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] KeyPressed
With Dynamic Connect... and UniBasic... I need a screen that continuously displays time... as we have an inspection screen where press operators enter fresh data each hour. Something like... loop call *timeOfDay call *displayOtherStuff input thisKey, -1 until (thisKey = '1') sleep repeat gosub secondScreen The trouble with this thing is... when a key is pressed... it wants to display the key on asubsequent screen. I tried...inputclear... but it is not doing what I want. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] KeyPressed
Tom: Thanks for writing... but... Once I put in Input junk, 1: The loop waits for a user input and thus stops updating time. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, August 9, 2013 4:19 PM To: U2 Users List Subject: Re: [U2] KeyPressed I do agree that INPUTCLEAR should work but since it doesn't, try CLEARDATA. Your example seems to be missing something that may help clarify things but another thought is: loop call *timeOfDay call *displayOtherStuff input thisKey, -1 input junk,1: until (thisKey = '1') sleep repeat gosub secondScreen The input junk,1 will take the first character entered and discard it but it will clear the buffer, Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, August 09, 2013 4:04 PM To: 'U2 Users List' Subject: [U2] KeyPressed With Dynamic Connect... and UniBasic... I need a screen that continuously displays time... as we have an inspection screen where press operators enter fresh data each hour. Something like... loop call *timeOfDay call *displayOtherStuff input thisKey, -1 until (thisKey = '1') sleep repeat gosub secondScreen The trouble with this thing is... when a key is pressed... it wants to display the key on asubsequent screen. I tried...inputclear... but it is not doing what I want. Suggestions would be appreciated. --Bill ___ 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] KeyPressed
Thanks to those who responded... especially Will... I could not get the hush to behave With a Tiger note on inputIF before I saw Ian's and Allen's response... I whipped up the following. --Bill include BP BASELINE.R9 *--- --- gosub mainLoop go theEnd *--- --- *--- --- mainLoop: call *HEADER.CLEAR.R1 *crt @(-1) crt @(0, 1) : ' ' crt @(0, 2) : ' | |' crt @(0, 3) : ' | HotKey | ' : Red : ' KeyBoard.Test ' : Grn crt @(0, 4) : ' |__|' crt @(0, 8) : ' Press Any Key ' : loop timeNow = time() timeNowF = oconv(timeNow, 'MTS') crt @(4,6) : timeNowF INPUTIF @(4,10) keyFlag, -1 THEN typeAheadEmpty = 1 ELSE typeAheadEmpty = 0 until typeAheadEmpty do sleep repeat gosub secondScreen return *--- --- secondScreen: call *HEADER.CLEAR.R1 *crt @(-1) crt Red : 'first keyFlag ' : Grn : keyFlag crt crt ' [#] [X] ' : inputclear input ans, 1 ans = upcase(ans) crt '__' crt crt ans sleep begin case case ans = 'X' ; go theEnd case 1 ; go secondScreen end case return *--- --- theEnd: call *HEADER.CLEAR.R1 *crt @(-1) END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, August 9, 2013 4:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] KeyPressed Bill you need to check the typeahead buffer to see if there is any key to process You can use the INPUTIF command, if the type ahead buffer is empty it will take the ELSE clause You can then do this in a loop with a time display as you wished Also look at the INPUT JUNK, -1 which will look at the typeahead buffer as well -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Aug 9, 2013 1:22 pm Subject: Re: [U2] KeyPressed Tom: Thanks for writing... but... Once I put in Input junk, 1: The loop waits for a user input and thus stops updating time. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, August 9, 2013 4:19 PM To: U2 Users List Subject: Re: [U2] KeyPressed I do agree that INPUTCLEAR should work but since it doesn't, try CLEARDATA. Your example seems to be missing something that may help clarify things but another thought is: loop call *timeOfDay call *displayOtherStuff input thisKey, -1 input junk,1: until (thisKey = '1') sleep repeat gosub secondScreen The input junk,1 will take the first character entered and discard it but it will clear the buffer, Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, August 09, 2013 4:04 PM To: 'U2 Users List' Subject: [U2] KeyPressed With Dynamic Connect... and UniBasic... I need a screen that continuously displays time... as we have an inspection screen where press operators enter fresh data each hour. Something like... loop call *timeOfDay call *displayOtherStuff input thisKey, -1 until (thisKey = '1') sleep repeat gosub secondScreen The trouble with this thing is... when a key is pressed... it wants to display the key on asubsequent screen. I tried...inputclear... but it is not doing what I want. Suggestions would be appreciated. --Bill ___ 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
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] UML mapping tool for MV (UniVerse)
I have some heartburn with the words optional and purely below. To me, it is like saying that Daniel Webster was just a door-to-door encyclopedia salesman. U2 data dictionaries are key tool. Why would someone climb on to a Rocket... to explore the UniVerse... without a map... of the data? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Monday, July 15, 2013 8:40 PM To: U2 Users List Subject: Re: [U2] UML mapping tool for MV (UniVerse) Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lynette LeDoux Sent: Tuesday, 16 July 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] UML mapping tool for MV (UniVerse) Hello all. The call has come to locate possible data modelling tools (UML) that could potentially would connect to our UniVerse system. Ideas? L2 (Lynette LeDoux) -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: Monday, July 15, 2013 2:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 51, Issue 13 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: Mobile phones (Symeon Breen) 2. Re: [ANN] FOSS4MV - Free Open Source Software for the MVDB world (Daniel McGrath) 3. SORT reports line length, change right margin? (randyleesmith) 4. Re: SORT reports line length, change right margin? (Anthonys Lists) 5. Re: SORT reports line length, change right margin? (Don Robinson) 6. Re: Mobile phones (Bill Haskett) 7. Re: SORT reports line length, change right margin? (randyleesmith) 8. Re: SORT reports line length, change right margin? (Bill Haskett) 9. Re: SORT reports line length, change right margin? (Wols Lists) 10. Re: SORT reports line length, change right margin? (randyleesmith) 11. Re: SORT reports line length, change right margin? (Wols Lists) 12. Re: SORT reports line length, change right margin? (randyleesmith) 13. Re: SORT reports line length, change right margin? (Wols Lists) -- Message: 1 Date: Mon, 15 Jul 2013 13:20:14 +0100 From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Mobile phones Message-ID: 004d01ce8155$a9f67e30$fde37a90$@gmail.com Content-Type: text/plain; charset=us-ascii Thanks everyone for your information. -- Message: 2 Date: Mon, 15 Jul 2013 14:25:42 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] [ANN] FOSS4MV - Free Open Source Software for the MVDB world Message-ID: 61ef3a8534e14d709dffdc5bd2f27...@den-vm-mbx3.rocketsoftware.com Content-Type: text/plain; charset=iso-8859-1 Thanks Tony Kevin! Unhappy to see we both ended up on different platforms (GitHub BitBucket) which means people would need to learn 2 different sites, but ecstatic to see we both ended up using Git which means people really only need to learn 1 tool chain to be able to work with both. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street? ?? Suite 1100? ??? Denver, CO 80237 ?? USA T: +1 720 475 8098 ? E: dmcgr...@rocketsoftware.com ? W: u2.rocketsoftware.com -Original Message- From:
Re: [U2] Any advantages to UV on 64-bit OS?
1. I just ordered an upgrade from UV 10.3.6 to 11.1.1 for HP-Ux Itanium 11.23. 2. The reason for upgrading is mostly to start using the new REST functionality in UV 11. 3. I have some concerns about JDBC working especially with ColdFusion. 4. Some months ago I could not get my Windows 8 64-bit ColdFusion v10 to connect to UV 10.3.6. 5. Our production CF server is... ColdFusion v9 on a 32-bit Windows 2008 Server. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Thursday, July 11, 2013 5:36 PM To: U2 User Group List Subject: [U2] Any advantages to UV on 64-bit OS? Hi all, I'm planning to upgrade our UV installation later this year primarily due to the age of the hardware (it's just over 5 years old). We aren't having any serious performance problems. We're currently running UV 10.2.7 on RedHat EL 5.1 32-bit and typically max out around 100 concurrent users. Since I probably won't upgrade again for another 5 years, I'd like to make the upgrade as future-proof as possible. Because UV is still a 32-bit app, though, I'm wondering if there is any real-world benefit to switching to 64-bit RedHat when I upgrade. I know the 64-bit kernel will remove the 4GB memory ceiling, but AFAIK, there is also a special 32-bit kernel for that. We also link UV to MS SQL via a 3rd party ODBC driver and accept JDBC and UOJ connections. I have to make sure that functionality isn't broken, and I recall someone recently posting that a 64-bit OS broke ODBC for them. Is anyone else successfully using ODBC, JDBC, and UOJ with 64-bit linux? Can anyone point out any advantages to running UV on a 64-bit OS? Thanks, John ___ 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] UniVerse LPTR
Wol: Thanks... that helps a lot. Most of our programs are UniBasic and users get to choose a destination... screen, laser, or greenBar. For some of the legacy script reports... it is a big deal to rewrite them in UniBasic... or problematic to launch these scripts from UniBasic. I do not know how to handle the problem of more than two levels of nested quotes. From the script, cranking in an LPTR1 or calling a UniBasic sub... on a script-by-script basis... is a more flexible fix than the brute force system-wide SETPTR.DEFAULT approach. --Bill Brutzman -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, July 8, 2013 6:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse LPTR On 08/07/13 21:19, Bill Brutzman wrote: Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. Do your users mess about at all with their printer settings? Will they get upset if this script starts messing about with their printer? If you want this printout coming out on the same printer regardless of user, I'd do a SETPTR 1... followed by a LPTR 1 Our rule was always the user's default printer is on unit 0, and it's the one closest to their desk. Any other printer or unit was fair game for the programmer as required. Not knowing your setup, my immediate reaction would be is tampering with the printer going to mess up stuff I don't know about, hence my preference for picking any unit OTHER than 0, and messing about with that. Cheers, Wol --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ 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] UniVerse LPTR
Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ 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] UniVerse LPTR
Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ 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
Mecki: While the old-fashioned approach is decent, it appears that there would be the fallout of having to manually mop-up the dead rows. To me... a more robust way is to... have the CF middleware read the Seiki data... CF clean the old SQL rows... CF would call the new Rocket REST tool to call a UniBasic sub to write the data to the UD Avante table. The CF handler might be less than a dozen lines of HTML-like tags... or CF script. Upon doing this... there would likely be other data translation apps that would come to mind... like integrating Avante with other ODBC... United Parcel Service, employee time clock, shop floor equipment etc. Likewise, I expect that ASP.net could do most all of the CF part. Of course, the main idea here is that a server would be running agents (services). The latest CF 10 has TomCat built-in. I got turned on to The Zen of REST by the author Scott Davis at a Philadelphia Emerging Technologies conference. Slick Willy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Saturday, June 8, 2013 3:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work Bill, What I try to achieve is converting production data collected by Seiki software into labour bookings on our Avante ERP system. Currently operators use Seiki on the machine and also book the jobs on a separate screen to update ERP. So I have one application writing to a SQL Server table and I want to run a phantom on UD that picks up changes on that table and updates several UD files using existing business logic when it finds any. That way the operator doesn't have to enter labour bookings and make mistakes any more. I also want to remove the rows from the SQL Server table once they are marked as completed operations and update SQL Server with changes of the production schedule to produce loading lists on the machines. How can a browser or Coldfusion help me with that? If I really wanted a browser based front end I would most likely use Designbais or SBXA since I don't see the point and don't have the time trying to learn yet another new language (or a whole bunch of them) just for that. I think I'll just go the old fashioned way and run a SSIS package on SQL server that checks for changes on the table and writes these to a Samba share on the UD server as a Tab delimited text file and also updates the tables Seiki uses for loading lists. Then my phantom can pick up those changed rows every minute or so and update my files. I just wanted a more elegant solution and and see if and how the UD tools work. Mecki On 07/06/2013 23:02, Bill Brutzman wrote: Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ 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
Mecki: Consider using Adobe's ColdFusion as middleware... possibly with the new U2 REST tool. View = HTML Middle = CF, U2 ReST DataBase = U2, SQL A cool thing about U2 Rest is that... it is fairly easy to leverage existing UniBasic code... especially Subs. Rocket has an outstanding three-part video on how to do AJAX and ReST. ColdFusion has many desirable features. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, June 7, 2013 9:54 AM 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] How do I get the U2 Metadata Manager to work
Mecki: While it may be counter-intuitive that ColdFusion is very hot... The compelling gravity in the entire web UniVerse is the idea is the idea browser front end. As CF was originally tag-based... if a programmer knows any HTML... that same programmer already knows much CF. Where CF shines is middleware to connect to databases... and rapid application development. It is worth it to go to adobe.com and check out CF. A related impossibility is that the CF community is even more gung-ho that the U2 community. Who knew? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniObjects Java Packages
I am trying to get an example program to work with Eclipse IDE. When trying to... import asjava.uniobjects.*; import asjava.uniclientlibs.*; I get errors. I tried several things without any luck. Help with how to configure the asjava folder in packages would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hibernate and UniVerse
Dan: Thanks... I expect to approach this Hibernate thing by first going back to getting Java to work with UV + CF. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, April 1, 2013 1:43 PM To: U2 Users List Subject: Re: [U2] Hibernate and UniVerse Every relational database uses its own custom 'flavor' of SQL (after all, that's what standards are for, right?). To handle these differences, Hibernate uses the concept of 'dialects' so it knows what keywords are valid for that type of database. UniVerse is not one of the stock dialects available, so you will have to create a custom dialect to support it. On the positive side, this will allow you to register keywords such as SAMPLE, SAMPLED and UNNEST that are unique to UniVerse. I can't offer you much more help than to point you to some starting points: http://keyurj.blogspot.com/2012/12/creating-custom-dialect-in-hibernate.html http://www.systemmobile.com/?p=177 Hope it helps, 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 William Brutzman Sent: Monday, April 01, 2013 11:13 AM To: U2 Users List Subject: [U2] Hibernate and UniVerse When trying to do ORM (Object Relational Mapping) with ColdFusion... I am getting an error message... Hibernate Dialect must be explicity set for dataBase: Universe. Tips and tricks on Hibernate configuration settings would be appreciated. --Bill ___ 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] List..
Sathya: While I agree that there are several ways... I would rather live in a brick house than a grass hut. --Bill open 'FILE' to fFile else null execute clearselect ALL execute SELECT FILE equate true to 1, false to 0 * done = false loop readnext fileID else done = true until done do read rFile from fFile, fileID else null thisItem = rFile1 thisItem6 = thisItem[1,6] crt thisItem6 repeat * theEnd: END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, March 26, 2013 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] List.. Hi all,.. I have a small issue in listing a file. When I use LIST FILENAME, the data comes like 123456*001 123456*001. I would like to display the data as 123456 123456 Can someone please help me in doing this? TIA, Sathya V. ___ 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] Apparent Data Problem
I am having trouble with my RR Recent Receivers UniBasic app running on UniVerse 10 ? on HP-Ux 11i v2. The app buzzes through receivers file RCVR and then hangs up on this one. The RCVR file is approx. 15-MB. I tried deleting records but the same symptom recurs. I resized the file in the SandBox from 7577 to 8511 leaving type and separation the same and then the app yields the same error without returning any data at all. Also... how can I tell what version of UV is installed now? Help would be appreciated. --Bill 3.19.13 10R19 072220 M10857300530 222 ** 16516þ16516þN10091þ1þ124þ745240þ0þ60100þ16515þ124.0þ300468300468þþ1þ 1240 3.20.13 10R19 07 N10091 300468 124 ** 16517þ16517þM10762þ1þ13173þ8891775þ0þ6750þ16511þ13173.0þ303253303253 3.21.13 10R11 072232 M1076230325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 3.21.13 10R11 072232 M10762 30325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 313: open 'RCVR' to fRcvrelse null 314: 315: read rRcvr from fRcvr, rcvrID else rRcvr = '' 316:AP.Invoice.ID = rRcvr20,1 crt '** ' : rRcvr crt __ HASH.HELP RCVR File RCVR Type= 4 Modulo= 7577 Sep= 4 11:23:59am 21 Mar 2013 PAGE 1 Of the 34559 total keys in this file: 0 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 11024 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 23472 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 63 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their right-most eight bytes. The smallest modulo you should consider for this file is 8511. The smallest separation you should consider for this file is 1. The best type to choose for this file is probably type 2. ed RCVR 10R11*072232 22 lines long. : P 0001: 16517 0002: 16517 0003: M10762 0004: 1 0005: 13173 0006: 8891775 0007: 0 0008: 6750 0009: 16511 0010: 13173.0 0011: 303253 0012: 0013: 0014: 0015: 303253 0016: 0017: 0018: 0019: 0020: 0021: 2ü2ü2 0022: 43990ü43890ü43850 Bottom at line 22. : ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Apparent Data Problem
Thanks to Dan and Allen for writing but... fixTool found no error. My next step would be to reboot the server but... I did that yesterday... cleanly... to install a new server keyboard sharing switch. I suppose that I have to create a case with Rocket tech support. --Bill ed VOC RELLEVEL 0001: X 0002: 10.3.6 0003: INFORMATION 0004: INFORMATION.FORMAT 0005: 10.3.6 # ./bin/fixtool -file RCVR -filepath /u2/SANDBOX/ -fix Filename: RCVR Start Diagnostics. 0 Errors found in physical structure. 0 Errors found in file header. 0 Errors found in groups. 0 Errors found in filesp. 0 Errors found in miscellaneous chains. 0 Orphaned buffers found in file. 34555 records processed. No errors were found. Fixtool Completed. # -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, March 21, 2013 1:05 PM To: U2 Users List Subject: Re: [U2] Apparent Data Problem To tell the version of UniVerse edit the VOC RELLEVEL and it will display the version on attribute2 To the file for corruption I would recommend running the unix command fixtool supplied by Rocket. fixtool -helpwill show you all the options and syntax 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. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, March 21, 2013 11:56 AM To: 'U2 Users List' Subject: [U2] Apparent Data Problem I am having trouble with my RR Recent Receivers UniBasic app running on UniVerse 10 ? on HP-Ux 11i v2. The app buzzes through receivers file RCVR and then hangs up on this one. The RCVR file is approx. 15-MB. I tried deleting records but the same symptom recurs. I resized the file in the SandBox from 7577 to 8511 leaving type and separation the same and then the app yields the same error without returning any data at all. Also... how can I tell what version of UV is installed now? Help would be appreciated. --Bill 3.19.13 10R19 072220 M10857300530 222 ** 16516þ16516þN10091þ1þ124þ745240þ0þ60100þ16515þ124.0þ300468300468þþ1þ 1240 3.20.13 10R19 07 N10091 300468 124 ** 16517þ16517þM10762þ1þ13173þ8891775þ0þ6750þ16511þ13173.0þ303253303253 3.21.13 10R11 072232 M1076230325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 3.21.13 10R11 072232 M10762 30325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 313: open 'RCVR' to fRcvrelse null 314: 315: read rRcvr from fRcvr, rcvrID else rRcvr = '' 316:AP.Invoice.ID = rRcvr20,1 crt '** ' : rRcvr crt __ HASH.HELP RCVR File RCVR Type= 4 Modulo= 7577 Sep= 4 11:23:59am 21 Mar 2013 PAGE 1 Of the 34559 total keys in this file: 0 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 11024 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 23472 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 63 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their right-most eight bytes. The smallest modulo you should consider for this file is 8511. The smallest separation you should consider for this file is 1. The best type to choose for this file is probably type 2. ed RCVR 10R11*072232 22 lines long. : P 0001: 16517 0002: 16517 0003: M10762 0004: 1 0005: 13173 0006: 8891775 0007: 0 0008: 6750 0009: 16511 0010: 13173.0 0011: 303253 0012: 0013: 0014: 0015: 303253 0016: 0017: 0018: 0019: 0020: 0021: 2ü2ü2 0022: 43990ü43890ü43850 Bottom at line 22
Re: [U2] Apparent Data Problem
GS: I answered these questions in a subsequent post. I am opening the file ok... the record was whacked. I now merely validate the record ID before continuing in the program. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, March 21, 2013 6:53 PM To: U2 Users List Subject: Re: [U2] Apparent Data Problem Bill, If I read the error message correctly the problem is to do with opening the file not reading the record. Are you really opening the file for each record read? Are you sure you are in the account where the RCVR file exists - i.e. does the code cross-log at all? Regards, Gregor -Original Message- snip __ 3.19.13 10R19 072220 M10857300530 222 ** 16516þ16516þN10091þ1þ124þ745240þ0þ60100þ16515þ124.0þ300468300468þþ1þ 1240 3.20.13 10R19 07 N10091 300468 124 ** 16517þ16517þM10762þ1þ13173þ8891775þ0þ6750þ16511þ13173.0þ303253303253 3.21.13 10R11 072232 M1076230325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC 3.21.13 10R11 072232 M10762 30325313,173 Program RECENT.RECEIVERS.R11: Line 313, Improper data type. File 0 not found in VOC ___ 313: open 'RCVR' to fRcvrelse null 314: 315: read rRcvr from fRcvr, rcvrID else rRcvr = '' 316:AP.Invoice.ID = rRcvr20,1 crt '** ' : rRcvr crt 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
Re: [U2] {BDT] Commenting A Block Of Code
Victory... Thanks Ross... for the best answer. Thanks also to Troy, Charles, Brian, Bobby, Dave, Will, Wol, Symeon, Peter, and John-Boy... for responding. I am shocked... that I did not see anything from Doug. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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
Re: [U2] BDT - formatting basic code
Googling... eclipse text format... yielded... among other things... http://www.wikihow.com/Change-the-Default-Format-Settings-in-Eclipse --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Wednesday, December 19, 2012 12:57 PM To: U2 Users List Subject: [U2] BDT - formatting basic code We finally upgraded Universe to 11.1.9 on AIX, so i am now starting to use BDT (Basic Developer Toolkit) on a daily basis. Does anyone know of a way to specify how the code editor formats? Ctrl-Shift-F removes leading spaces, then indents lines using tab char(9) instead of spaces. Example: FORMAT results from TCL EDitor: 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: IF SI=12 THEN 0005: CRT 'HELLO' 0006: END ELSE 0007: GOSUB DO.SOMETHING 0008: END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016:END Bottom at line 16. Format (Ctrl-Shift-F) results in BDT 0001: S='' 0002: X=9 0003: FOR I = 1 TO X 0004: ^009IF SI=12 THEN 0005: ^009^009CRT 'HELLO' 0006: ^009END ELSE 0007: ^009^009GOSUB DO.SOMETHING 0008: ^009END 0009: NEXT I 0010: RETURN 0011: 0012: DO.SOMETHING: 0013: R2='D2' 0014: RETURN 0015: 0016: END Bottom at line 16. ___ 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] SQL Data Type Column
In the Rocket U2 Basic Developer ToolKit... how do I get the SQL data column to show? I have this column (and data field) on my main PC. When I installed BDT on another Windows machine... I am having trouble finding how to make this column (and field) appear. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
Barry: My foray with ColdFusion has led to doing some UniVerse SQL things. As I struggle to get the machine to do what I think I want... I have found that it is less about the backend database and more about the middleware. Even though I tend to buy quite a lot of books... I have found the fastest SQL results by Googling. While I like the writings of author Larry Ullman... especially MySQL, Visual QuickStart Guide 2nd Edition, PeachPit Press... this book is not a silver bullet. The Rocket U2 SQL manuals are very worthwhile. I like the Dummies books. I have found that, although there are differences between, Oracle, SyBase, MS-SQL, Postgres, MySQL... my sense is that it is perhaps 98% overlap. A handy tool that I use with MySQL is HeidiSQL. Probably the best book is somewhere in the Oracle space. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Wednesday, November 07, 2012 9:45 AM 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] [OT] Sql Query
Barry: Also... check out Lynda.com --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Sql Query
While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max out at like... three tables. In UniBasic... it is easy to traverse tables. Suggestions would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, November 07, 2012 10:03 AM Subject: 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.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL Views
Wol: The idea to do views is a big help and much appreciated. In UniVerse... to do views appears to require a schema. Thus, I need to get up-to-speed on SQL Schemas in UniVerse. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, November 07, 2012 1:54 PM Subject: Re: [U2] [OT] Sql Query On 07/11/12 16:31, Bill Brutzman wrote: While the given link is key... a bit of frustration that I have had with SQL is that... often I have data in more than two tables... following the first select list... there could be data in six or more tables. The joins that I have tried seem to max out at like... three tables. In UniBasic... it is easy to traverse tables. Suggestions would be appreciated. --Bill A hint for both you and Barry ... ASSUMEing your back-end database has a half-way decent query optimiser, try creating views that match what you would expect to put in a MV FILE. Then do your selects against those views. The query optimiser should do all the hard work of building up a good query, stripping out redundant accesses, etc etc. But that way, you can make SQL behave a bit like MV until you've got to grips with it. You know my feelings :-) MV makes a far better relational back-end than a relational database, but you do have to design that back-end properly otherwise what comes out is ... Cheers, Wol ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another Job Ad
Check out www.YouRockGuitar.com. It is a digital guitar with an electronic fretboard (having no strings there). Among other features, It is intended to be played by righties with just the left hand on the fretboard... called shredding. I have a YouRock and I like it but so far... Carnegie Hall has not called me to schedule a performance. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Consuming Web Services
How about... [Browser] - |ColdFusion] - [UniVerse] |__| - [Other SQL] --Bill -Original Message- Sent: Wednesday, October 03, 2012 4:56 PM 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
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
Re: [U2] Scrub HangUp Fixed
David: On the back of a Sopranos T-Shirt... it indicates... Know Your Role. On the front... there is a smoking gun. Of course, U2 is not open-sourced... my goal role is merely that of a pragmatic customer. As Rocket monitors this list to a greater or lesser extent... that is Rocket's business decision. As potentates here in the US have indicated that corporations are people and that as citizens we are united... Thus, perhaps it makes sense that tech support fixes are for the good of a corporate humanity and... Consider listening to the new wave album by Devo... Duty Now For the Future. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 30, 2012 12:13 PM ... For the good of humanity, it's the duty of every person on the list to raise stinks to Rocket on stupid system behavior like this It's probably not that hard to fix and will avoid the NEXT person from having to live the trauma. And then we can get back to reminiscing about RQM - the true reason for the list;-) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Fix OutCome
David: I am glad to learn now that UV 11 has some major new OBDC things. Yesterday... I just released my third HTML app (runs on both mobile + desktop) that uses ColdFusion to grab UniVerse data to hydrate and launch pdf forms in the user's browser. The apps/forms... [1] Purchase Order [2] Invoice [3] Part Inspection... were whipped up with Adobe's (LiveCycle) Designer. I can now do one (or two) form apps like this in one day. I have not aware of any other technology out there that can do this. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, August 31, 2012 8:15 AM Subject: Re: [U2] Scrub HangUp Fixed Bill, You make good and valid points. :) To all question posters in general (not directed a Bill): The better the quality of the problem definition and context = the better the quality of the response. As I sometimes jokingly tell my users: All answers are free, but correct answers are cost money. However, dumb and puzzled looks are at no extra charge! I agree, it is difficult to justify the expense of any course - let alone finding the time to attend - even if it is a webinar-style course. Send your suggestion directly to Rocket about posting on that site. They won't know unless you do that. It sounds like you should upgrade to UV11.x to get the most out of ODBC 3.0 compliance and any other bug fixes in UV. Any reason you really need to use ColdFusion? Can some other tool do what you want? Have you turned-on server-side and client-side debugging to pinpoint your issue? Yes, I fumbled across the Dictionary clean-up webinar myself - after seeing an invite to another for U2 .NET Toolkit held the other day. Kind regards, David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub HangUp Fixed
David: 0. Thanks so much for writing. 1. Yes... same problem on the same file... now fixed. 2. I have read both the Rocket ODBC and JDBC documentation exhaustively... and found these manuals to be rather excellent. 3. I have also had trouble with getting the Rocket JDBC driver to work with Adobe's new release of ColdFusion 10. It is like I have to again write a little Java program to troubleshoot the connection string thing. We may be forced to upgrade our version of UV. 4. Much as I would like to attend all the Rocket UV courses... I find these courses to be pricey and involve serious days and travel. 5. I would like to see Rocket move the courses to Lynda.com or do something similar to Lynda. 6. I am delighted to learn about the seminar... I registered for it. I am surprised that I did not learn about it except through this back door. 7. This list being something of a forum... as I understand it... posts on newbie, intermediate, and advanced questions are all welcome. If the question is directly answerable via an official Rocket manual... then the originator risks suffering the punishment of embarrassment from the respondent who... from some point of view... is following in the traditions of the late William F. Buckley, Jr. 8. The speed of the u2ug forum responses in of course invaluable. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, August 29, 2012 8:32 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html Same problem/solution? I kindly suggest that you go on a Rocket UV course to help work out how to get the best from UV. Plus the UV ODBC documentation is quite detailed on the use of HS.SCRUB. So I assume you're followed it's correct used - before you posted this request for help. BTW check this out Rocket U2 Webinar coming soon: http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 29 August 2012 6:16 AM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ** 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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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] Scrub Hangs Up
The HS.Scrub option... report only option also hangs. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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] Scrub Hangs Up
port.status There are currently 6 uniVerse sessions; 5 interactive, 1 phantom Pid User name. Who. Port name. Last command processed... 25149 brutzy12 /dev/pts/tb LOGTO HS.ADMIN 26413 brutzy16 /dev/pts/te LOGTO HS.ADMIN 26541 brutzy17 /dev/pts/tf LOGTO HS.ADMIN 26559 brutzy20 /dev/pts/tj port.status 13303 color 29 /dev/pts/tq CLEARSELECT ALL [ SHIP.STATUS.LONG.R69 @ 0xA24 ] Pid User name. Printer Segment Last command processed 26538 brutzy 0xACEB9856 *HS.OLEDBINFO -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Port.status ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.commailto:d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 3:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto: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] Scrub Hangs Up
More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
It looks like the D_INVOICE (dictionary file) is corrupted. Unfortunately... this dictionary is rather large. I would rather not retype the whole dictionary from scratch and copy it back. The Unix rights to the file look righteous... 777. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
1. INVOICE is an ordinary UV file. 2. I can see the INVOICE dictionary via... LIST DICT INVOICE... and also via BDT... so yes this D_INVOICE dictionary exists and is readable. 3. D_INVOICE appears to be corrupted (whacked) in a subtle way. 4. My sense is that I have to retype the D_INVOICE dictionary from scratch and do a copy back and rename trick. 5. If there is a faster way... I am open to consider it. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, August 28, 2012 6:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up On 28/08/12 23:39, Bill Brutzman wrote: More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. Hmmm Something's seriously screwy here - your last post said that INVOICE was a local F pointer. Does the dictionary even exist? Is it readable? Any of this would bring HS.SCRUB crashing down ... 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] Scrub Hangs Up
Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Rich Thanks for writing... 1. I believe that HS.SCRUB just creates SQL data types in like fields 7 and 8 of the dictionary file. 2. Yes It should be COPY FROM DICT INVOICE TO DICT INVOICE_TEST ALL... This now works... I tried it but... HS.ADMIN hangs up the same way with INVOICE_TEST. 3. I started to write a little rehydrate program... to read the DICT entries from one file and copy the DICT entries to a new clean file. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Wilson Sent: Tuesday, August 28, 2012 7:25 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Just in case I'm not missing something does HS.SCRUB create voc entries for each dictionary? normally there is no voc item for D_anything and shouldnt the copy be COPY FROM DICT INVOICE TO whereever ALL rICH On 8/28/2012 7:21 PM, Bill Brutzman wrote: Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ 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] Scrub Hangs Up
Will: Yes... you are right... Richard Wilson picked up on my typing bug in an earlier post. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:11 PM Subject: Re: [U2] Scrub Hangs Up What are you trying to copy from the Dict of D_INVOICE instead of the Dict of INVOICE ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Again correct... from an earlier post... There was never any VOC entry called D_INVOICE. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up Delete the VOC entry called D_INVOICE No such entry should exist ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
I can copy the file... and I can copy the DICT... no problem now. The problem is that HS.SCRUB hangs. --Bill __ UniVerse Server Administration 1. List activated accounts 2. Show UniVerse ODBC Config configuration for an account 3. Activate access to files in an account 4. Deactivate access to files in an account 5. Run HS.SCRUB on a File/Table 6. Update File Information Cache in an account Which would you like? ( 1 - 6 ) ? 01 ED VOC HS.SCRUB 4 lines long. 0001: Verb - Check and optionally repair SQL-related dictionary/data inconsistencies in a table or file 0002: *HS.SCRUB 0003: B 0004: N __ ed VOC INVOICE 3 lines long. 0001: F 0002: INVOICE 0003: D_INVOICE Bottom at line 3. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up Can you please then regive us once more the exact VOC command you're executing and COPY to this email exactly the VOC entry for the INVOICE file -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 5:12 pm Subject: Re: [U2] Scrub Hangs Up It looks like the D_INVOICE (dictionary file) is corrupted. Unfortunately... this dictionary is rather large. I would rather not retype the whole dictionary from scratch and copy it back. The Unix rights to the file look righteous... 777. --Bill ___ 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] Scrub Hangs Up
In my new little rehydrate program... Several of the dictionary fields that show up in BDT and LIST DICT INVOICE... do not appear. --Bill _ *R1 Bill Brutzman Aug.2012 open 'DICT', 'INVOICE' to fDictSource else null include B.BP BASELINE.R10 crt @(0) dArray = '' *-- Main.Program: gosub firstLoop gosub secondLoop go theEnd *-- *-- firstScreen: crt @(0) call *HEADER.CLEAR.R1 crt crt crt crt ' ' crt ' /\ ' crt ' \ Dict.Hydrate / ' crt ' \__/ ' crt crt crt crt crt ' [G] Go ' crt crt ' [X] eXit' crt ' ': input Ans.Rep, 1 Ans.Rep = upcase(Ans.Rep) begin case case Ans.Rep = 'G' ; null case Ans.Rep = 'X' ; go theEnd case 1 ; crt @(-1) ; sleep ; go firstScreen end case return *-- firstLoop: call *HEADER.CLEAR.R1 crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt Grn : ' Hydrating...' : hush on execute clearselect ALL execute 'SELECT DICT INVOICE' hush off call *HEADER.CLEAR.R1 crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt Red : ' Hydrating...' : Grn : crt crt done = false loop readnext dictID else done = true until done do read rDict from fDictSource, dictID else rDict = '' type = rDict1 field = rDict2 item3 = rDict3 item4 = rDict4 item5 = rDict5 sm= rDict6 crtStr = dictID 'L#20' : ' ' crtStr := type 'L#10' : ' ' crtStr := field 'L#10' : ' ' crtStr := item3 'L#10' : ' ' crtStr := item4 'L#10' : ' ' crtStr := item5 'L#10' : ' ' crtStr := sm 'L#10' crt crtStr begin case case type = 'D' ; gosub sortDrecords * case 1 ; dArray-1 = thisRecord end case thisRecord = '' thisRecord := field : VM thisRecord := dictID : VM thisRecord := type : VM thisRecord := item3 : VM thisRecord := item4 : VM thisRecord := item5 : VM thisRecord := sm repeat crt crt ' [] ' : *input Ans crt crt return *-- sortDrecords: locate thisRecord in dArray1 by 'AR' setting posn else null insthisRecord before dArrayposn return *-- secondLoop: totalNbrDictItems = dcount(dArray, AM) for thisCount = 1 to totalNbrDictItems newField = dArraythisCount,1 newID = dArraythisCount,2 newType = dArraythisCount,3 newField3 = dArraythisCount,4 newField4 = dArraythisCount,5 newField5 = dArraythisCount,6 newsm = dArraythisCount,7 newStr = Red newStr := thisCount 'R#3' : ' ' : Grn newStr := newField 'L#10' : ' ' newStr := newID 'L#20' : ' ' newStr := newType 'L#10' : ' ' newStr := newField3 'L#10' : ' ' newStr := newField4 'L#10' : ' ' newStr := newField5 'L#10' : ' ' newStr := newsm 'L#10' crt newStr next thisCount crt crt ' [] ' : input Ans, 1 return *-- writeNewDict: * call *SUB.LOCK.AND.WRITE.R1(R.JPL, 'JPL', Today) return *-- theEnd: call *HEADER.CLEAR.R1 END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Array Types
I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Web TimeLine
Consider checking out... http://www.EvolutionOfTheWeb.com Via the http://www.nyCoders.org mailing list. This chart reminds me of the one that Dawn Wolthuis has available via http://www.tincat-group.com/mv/familytree.html. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reasons to continue with Software vendor support
We here have yearly UniVerse support with Rocket. The cost is modest. We are using HP-Ux. The Rocket support gets us the database upgrades and once or twice we have had database upgrade issues that Rocket handled rather well. If we were to drop support... last time that I checked... it was twice the price to get back on. For us here, our Rocket support is something of an insurance policy. If Epicor is dropping ManFact support... it sounds like Epicor would be merely marking-up Rocket's U2 services. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DICT Whacked in VOC
DICT got messed up when I was trying to copy a dictionary... when trying to recover a file. Now... list DICT SOH 0 records listed. DICT not found. ED VOC DICT New record. : Q ED DICT SOH Unable to open DICT, not a file in VOC. File name= I did not yet try to stop and restart UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DICT Whacked
ReBooting HP-Ux did NOT fix the problem. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DICT Whacked in VOC
Thanks to Susan, David, and Will. I did a LOGTO SAVEBOX.. a somewhat arbitrary account here ED VOC DICT 0001: K 0002: 20 LOGTO METAL ED VOC DICT ... and I just inserted these two keyword lines back in to my main METAL account... and Victory. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Unix File Recovery
Will: Thanks for writing. Just before I received this message, I did something close to this... I copied the entire account to my SandBox and then it worked. -Bill How about Create a new ACCOUNT Restore the file to this new account Q point at it, from the account in which you really want to use it I am having trouble trying to restore a year-end file to a new file name. The file is saved to my Windows7 PC... The UniVerse host is running on hp-ux. I tried to FileZilla FTP the file back using binary enconding. I tried to create a new file and dictionary from the UV command prompt and then opy the file and dictionary over. I tried creating a new file in UniVerse and sizing the file like the known orking files. When I try to do a UVFIXFILE... an error indicating file truncation results. I am now trying ASCII encoding. I was able to get something like this to work in the past. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Unix File Recovery
Wol: Thanks. One trouble with using FileZilla is having to remember to check that pesky option for ASCII vs binary. It appears I need a new and improved backup and recovery scheme. I like the Linux box idea. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 20, 2012 6:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Unix File Recovery On 20/06/12 22:28, Bill Brutzman wrote: I am having trouble trying to restore a year-end file to a new file name. The file is saved to my Windows7 PC... The UniVerse host is running on hp-ux. How did you save it to the PC? I tried to FileZilla FTP the file back using binary enconding. This could be your problem - if you didn't binary it to the PC, it could be corrupt on the PC - in which case you're in trouble... I tried to create a new file and dictionary from the UV command prompt and then copy the file and dictionary over. I tried creating a new file in UniVerse and sizing the file like the known working files. UV doesn't care about that sort of thing - it should just work When I try to do a UVFIXFILE... an error indicating file truncation results. And this doesn't sound healthy at all. I am now trying ASCII encoding. I was able to get something like this to work in the past. Suggestions would be appreciated. Have you got a backup from the hp box? Do you have the year-end file still sitting somewhere on the hp box? Disk is cheap nowadays. If you're worried about expensive hp disks, just get a cheap pc, stuff a couple of terabyte disks in it, and run linux on it. Back up the hp box over the network with rsync or something cleverer that'll do incremental snapshots. 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
[U2] UV Unix File Recovery
I am having trouble trying to restore a year-end file to a new file name. The file is saved to my Windows7 PC... The UniVerse host is running on hp-ux. I tried to FileZilla FTP the file back using binary enconding. I tried to create a new file and dictionary from the UV command prompt and then copy the file and dictionary over. I tried creating a new file in UniVerse and sizing the file like the known working files. When I try to do a UVFIXFILE... an error indicating file truncation results. I am now trying ASCII encoding. I was able to get something like this to work in the past. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 accounting software question
To me, this is a question for the accounting department there. Corporate accountants that I know favor Oracle financials... for their functionality, reporting, and ease of use. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trim trailing attributes off records
I would write a little uniBasic program... to cleanse, purify, and rehydrate... testing it first in a sandbox. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, May 10, 2012 6:13 PM Subject: [U2] Trim trailing attributes off records Given that you have a file with thousands of records, each with dozens of trailing attributes which are empty. How can you pick up the file and drop it back down with all those empties trimmed off? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Fleshing it out makes it easier to read and maintain. thisYear = oconv(today, 'DY2') thisMonth = oconv(today, 'DM') thisDate = oconv(today, 'DD') yyMMdd = thisYear : thisMonth : thisDate 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. --Bill -Original Message- From: u2-users-bounces On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 7:52 PM YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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
Re: [U2] The CONTINUE statement
1. I do not see a continue statement in the UniVerse manual. 2. There is the exit command... used to break out of a loop... when a certain condition is satisfied. 3 The point of the original post is not clear to me. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 26, 2012 5:12 PM 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] The CONTINUE statement
- || || MoreEnd Help List Commands || - || |+- The CONTINUE statement is a loop-controlling statement. For syntax details, see the FOR statement and the LOOP statement. So what... ? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 26, 2012 5:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] The CONTINUE statement at TCL type HELP BASIC CONTINUE -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:26 pm Subject: Re: [U2] The CONTINUE statement 1. I do not see a continue statement in the UniVerse manual. . There is the exit command... used to break out of a loop... when a certain ondition is satisfied. The point of the original post is not clear to me. --Bill -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Thursday, April 26, 2012 5:12 PM o: u2-users@listserver.u2ug.org ubject: [U2] The CONTINUE statement OR I = 1 TO X do something IF some condition THEN CONTINUE do something else EXT I versus FOR I = 1 TO X do something IF NOT(some condition) THEN do something else EXT I __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] The CONTINUE statement
1. I never used the words... no idea. 2. I must have had some idea as I mentioned the exit statement. 3. the fightin' Irish... they do not know what they want... but they are ready to fight ya for it. 4. Please consider... stating the point. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 26, 2012 5:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] The CONTINUE statement You said you had no idea what it was. How are you going to respond to the point, without knowing what the code actually does? -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 26, 2012 2:36 pm Subject: Re: [U2] The CONTINUE statement - || || MoreEnd Help List Commands || - || |+- The CONTINUE statement is a loop-controlling statement. For syntax details, ee the FOR statement and the LOOP statement. So what... ? --Bill -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Thursday, April 26, 2012 5:27 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] The CONTINUE statement t TCL type HELP BASIC CONTINUE -Original Message- rom: Bill Brutzman bi...@hkmetalcraft.com o: U2 Users List u2-users@listserver.u2ug.org ent: Thu, Apr 26, 2012 2:26 pm ubject: Re: [U2] The CONTINUE statement . I do not see a continue statement in the UniVerse manual. There is the exit command... used to break out of a loop... when a certain ndition is satisfied. The point of the original post is not clear to me. -Bill Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of Wjhonson nt: Thursday, April 26, 2012 5:12 PM : u2-users@listserver.u2ug.org bject: [U2] The CONTINUE statement OR I = 1 TO X do something IF some condition THEN CONTINUE do something else XT I ersus OR I = 1 TO X do something IF NOT(some condition) THEN do something else XT I _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] The CONTINUE statement
I have always admired Peter Norton's gift for writing with clarity. If a valid definition of the word obvious... is... easy to see... It was not apparent to me... that there were two code snippets being compared to each other. Thus, I would LIKE to apologize... but I am NOT going to do so. I will however start watching more videos of the Amazing Kreskin so as to help me with dialogue on this list. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UniOLEDB driver 64-bit windows and installers (take 50 or something)
John:
1. There are some third-party ODBC tools available.
2. I do something like this now with Adobe's ColdFusion... a free developer
version of CF is available for download from Adobe.
3. Rocket has some tech manuals that cover this area.
4. When I was troubleshooting this with CF, I wrote a little Java connection
string test program.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl
Sent: Monday, April 23, 2012 5:44 PM
To: U2 Users List
Subject: [U2] [UV] UniOLEDB driver 64-bit windows and installers (take 50 or
something)
Greetings all,
I've been parsing through the posts I've seen in the group and online,
and I'd love to get to a point where there's a conflict, but no such luck for
me I'm afraid. Our issue seems a little different and I'm hoping someone has
seen this recently. I have a single UniVerse server (10.1) it's running
Windows Server 2008, and had (as of this weekend) SQL Server 2008 on it as
well; both were setup as 32-bit. This weekend I tried to move all my SQL
Server to a new box which is still SQL Server 2008, but the Server itself is
64-bit and Windows Server 2008 R2. To make a medium story shorter I cannot get
IBM.UniOLE to show up as a Provider in SQL Server, I had it working pretty
darn well on my old box and was quite happy. Unfortunately no matter what I do
with installs (I have tried older, newer, 32-bit and 64-bit drivers) I just
cannot get it to work.
So during my debugging and disassembling of this poor process I've
made, I noticed that the Registry says the following:
Key:
HKEY_CLASSES_ROOT
Wow6432Node\CLSID\{DB14F292-CA54-11D1-BEB8-0060973B624E}\InprocServer32
ValueName: (Default)
Value: C:\Windows\SysWow64\UniOLEDB.dll
I have no such file, I've looked w/ /a etc, so it's not just hidden.
In fact, a quick search revealed no file w/ that name ANYWHERE on the HD. Now
I was able to determine that the .msi package has a nested structure and the
file _3C788511D64D4D17B7955EB0B3E14A56 really is the DLL in question, but...
I would rather do this the correct way and no brute force something into place.
Could there be something I'm missing or do not understand about the UniOLEDB
64-bit installer?
Thank you everyone,
---
John J. Wahl
Employee Owner
Programmer / Analyst
Tel: (888) 465-6737 Ext. 120
Fax: (330) 342-3896
Email: jw...@joseph.com -- farm me I dare you ;)
Web: http://www.Joseph.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] Case 1
Case 1 DOES mean otherwise... in a bloat-free way... such as... Begin case Case x 10 ; gosub subY Case 1; gosub subZ Endcase --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, April 20, 2012 12:11 PM I wouldn't say that's an extra worthless test. I think what it is telling us is that CASE 1 does not mean otherwise in a traditional sense. It really does mean IF @TRUE or IF 1=1 Which is a bit suprising that the compiler would have been written that way, but it does make a kind of sense. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statement with only two cases... or for that matter... one case
The case statement has a huge advantage in what really matters... human readability... that is the point. From readability follows... reliability, maintainability, and testability... better, cleaner, safer software. An irony is that while the if statement... is the cornerstone of all computing... the if is also a problematic and mostly obsolete construct. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 3:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Case Statement with only two cases Is there a point in code like this BEGIN CASE CASE A = TEST; GOSUB DO.SOMETHING CASE 1; GOSUB DO.SOMETHING.ELSE END CASE versus this IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE Personally I see no advantage in making this a CASE Does the rest of the *Universe* agree with me? ___ 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] Case Statement with only two cases... or for that matter... one case
1.Problematic... [a] I run into sloppy if statements often... it is sometimes difficult for me to infer what the programmer was trying to accomplish. I would like to see If XX then Gosub YY End else Gosub ZZ End I often see shortcuts and fragmented if statements. Some languages require a semicolon to specify the end of a line. Some languages use curly braces to specify the beginning and end of say a function [b] This problem gets exacerbated with nested if statements. 2. Obsolete... I look forward to the day when programmers start to realize that... for the reasons cited... and others... that IF statements are bad programming practice perhaps one notch above the goto statement. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 4:57 PM Subject: Re: [U2] Case Statement with only two cases... or for that matter... one case Explain more what you mean by saying the if is problematic and obsolete ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statement with only two cases... or for that matter... one case
The initial example was close to a good start... something like... If XX then gosub YY else gosub ZZ Replaced by Begin case Case XX ; gosub YY Case 1 ; gosub ZZ End case Except that now... note that readability is enhanced by [1] indenting... so as to align text and [2] using mixed-case and camelCase typography. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 5:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Case Statement with only two cases... or for that matter... one case Give an example of, with what you would replace the If Then Else ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statements
The case statement is like... a free upgrade to a Cadillac. The if statement is like... a horse and buggy. I am not saying that day is better than night but... The last time that I checked... Rocket Software was not looking to open a sales office in Amish country. --Bill -Original Message- Sent: Thursday, April 19, 2012 5:44 PM Subject: Re: [U2] Case Statement That's like saying that Mercury's are being replaced by Ford's.same difference ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Statement
In many areas of life, including writing code, less is more. Less code in this case is... more dog work. Framing the case statement as bloat, for me, is a mischaracterization... usually it is the cat that is bloated. In this case, I like to think that I have seen the light... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 19, 2012 7:50 PM Subject: Re: [U2] Case Statement Replacing one line with four lines... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] COMMON Size MisMatch
... in subroutine named XYZ.R1. While I would like to pass parameters back-and-forth invoking bona fide external subroutines using commands such as... CALL *MY.SUB.R2(param1, param2, errorString) ...I have a few big old legacy programs with nasty COMMON tentacles. How can I make these pesky COMMON messages go away? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] COMMON Size MisMatch
Eating my own dog food... I cranked CLEARCOMMON into the LOGTO SandBox and LOGTO LIVE paragraph commands. --Bill From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Don_Bausili at hcsc.net Sent: Thursday, July 16, 2009 10:17 AM To: u2-users at listserver.u2ug.org Subject: [U2] Fw: COMMON misMatch Since all common variables are cleared when you exit UniVerse, and eliminates the error, is it possible your user used a LOGTO command to switch environments that have different versions of the subroutine HOP.R87? We had both a Test and a Prod environment on the same box, and experienced problems when enhanced code in Test was being staged for promotion into Prod. Executing a program in Test that had changes to its COMMON, and then logging into Prod resulted in the size mismatch error when running the unchanged program. Our solution was to insert CLEARCOMMON in the LOGIN paragraphs. Don - Forwarded by Don Bausili/OK/HCSC on 07/16/2009 09:09 AM - Brutzman, Bill BillB at hkMetalCraft.com Sent by: u2-users-bounces at listserver.u2ug.org 07/15/2009 06:55 PM Please respond to U2 Users List u2-users at listserver.u2ug.org To U2 Users List u2-users at listserver.u2ug.org cc Subject Re: [U2] COMMON misMatch A user here obtained an error message... COMMON size mismatch in subroutine HOP.R87. Upon logging out and then logging back in again... The HOP program was able to launch without this error. Help with a diagnosis and more reliable cure would be appreciated. This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2. --Bill ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312) 653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Previous message: [U2] Fw: COMMON misMatch Next message: [U2] Universe Retrieve Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] More information about the U2-Users -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, April 12, 2012 2:40 PM To: U2 Users List Subject: [U2] COMMON Size MisMatch ... in subroutine named XYZ.R1. While I would like to pass parameters back-and-forth invoking bona fide external subroutines using commands such as... CALL *MY.SUB.R2(param1, param2, errorString) ...I have a few big old legacy programs with nasty COMMON tentacles. How can I make these pesky COMMON messages go away? --Bill ___ 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] COMMON Size MisMatch
I presume that the following is workable... Comments are welcome. To LogTo the SandBox it is now just... ED VOC LLS 0001: PA 0002: CLEARCOMMON 0003: LOGTO SANDBOX 0004: WHO ED VOC LOGIN 0001: PA 0003: PTERM -ECHO DELAY 0005: BREAK ON 0007: CLEARCOMMON 0009: HK.RESET.PRINTER 0011: RUN MT.BP GET.STACK.LOGNAME 0013: LOGIN.CONTROL 0015: PTERM CASE NOINVERT 0016: RUN B.USER TERMINAL.SETUP.R0 0018: IF @LOGNAME = 'root'THEN GO TCL 0019: IF @LOGNAME = 'brutzy' THEN GO TCL 0020: IF @LOGNAME = 'raymond' THEN GO TCL 0022: MM 0024: TCL: Bottom at line 24. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 12, 2012 3:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] COMMON Size MisMatch If you *do* use CLEARCOMMON you have to be alert to gremlins as well. LOGTO is not expecting to have to reinitialize the system and so probably doesn't. You need to review what the Login process is doing as well. You may end up wiping out control information such as the user's port, name, login time, functions they can and can't do, menu access, default printer, and so on and so forth. All depends on how complex the login processor has become at your site. Some sites don't do a darn thing. Some have thousands of lines of code at Login. Some of which set common (read environment) variables, that you *don't want* to clear, or at least that you want to reset if you do clear them. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 12, 2012 11:52 am Subject: Re: [U2] COMMON Size MisMatch Eating my own dog food... I cranked CLEARCOMMON into the LOGTO SandBox and OGTO LIVE paragraph commands. --Bill From: u2-users-bounces at listserver.u2ug.org mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of on_Bausili at hcsc.net ent: Thursday, July 16, 2009 10:17 AM o: u2-users at listserver.u2ug.org ubject: [U2] Fw: COMMON misMatch Since all common variables are cleared when you exit UniVerse, and liminates the error, is it possible your user used a LOGTO command to witch environments that have different versions of the subroutine OP.R87? We had both a Test and a Prod environment on the same box, and xperienced problems when enhanced code in Test was being staged for romotion into Prod. Executing a program in Test that had changes to ts COMMON, and then logging into Prod resulted in the size mismatch rror when running the unchanged program. Our solution was to insert CLEARCOMMON in the LOGIN paragraphs. Don Forwarded by Don Bausili/OK/HCSC on 07/16/2009 09:09 AM - Brutzman, Bill BillB at hkMetalCraft.com Sent by: 2-users-bounces at listserver.u2ug.org 7/15/2009 06:55 PM lease respond to U2 Users List u2-users at listserver.u2ug.org o U2 Users List u2-users at listserver.u2ug.org c Subject e: [U2] COMMON misMatch A user here obtained an error message... COMMON size mismatch in subroutine HOP.R87. Upon logging out and then logging back in again... The HOP program was ble to launch without this error. Help with a diagnosis and more reliable cure would be appreciated. This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2. --Bill ___ 2-Users mailing list 2-Users at listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this communication is confidential, rivate, roprietary, or otherwise privileged and is intended only for the use of he addressee. Unauthorized use, disclosure, distribution or copying is trictly prohibited and may be unlawful. If you have received this ommunication in error, please notify the sender immediately at (312) 53-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in klahoma; or (972)766-6900 in Texas. __ 2-Users mailing list 2-Users at listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users revious message: [U2] Fw: COMMON misMatch ext message: [U2] Universe Retrieve essages sorted by: [ date ] [ thread ] [ subject ] [ author ] ore information about the U2-Users -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Bill Brutzman ent: Thursday, April 12, 2012 2:40 PM o: U2 Users List ubject: [U2] COMMON Size MisMatch ... in subroutine named XYZ.R1. While I would like to pass parameters back-and-forth invoking bona fide external ubroutines using commands such as... CALL *MY.SUB.R2(param1, param2, rrorString) ...I have a few big old legacy programs with nasty COMMON tentacles. How can I make these pesky COMMON messages go away? --Bill __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] COMMON Size MisMatch
Will: Your commentary on this matter is very much appreciated. As long as this new fix works... I expect to defer further investigation. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 12, 2012 4:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] COMMON Size MisMatch Look inside those routines, and determine that they are agnostic about you coming from LOGIN vs LOGTO Perhaps I'm the sole person in history to have coded things that are wise about the distinction -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 12, 2012 12:46 pm Subject: Re: [U2] COMMON Size MisMatch I presume that the following is workable... Comments are welcome. To LogTo the SandBox it is now just... ED VOC LLS 001: PA 002: CLEARCOMMON 003: LOGTO SANDBOX 004: WHO ED VOC LOGIN 001: PA 003: PTERM -ECHO DELAY 005: BREAK ON 007: CLEARCOMMON 009: HK.RESET.PRINTER 011: RUN MT.BP GET.STACK.LOGNAME 013: LOGIN.CONTROL 015: PTERM CASE NOINVERT 016: RUN B.USER TERMINAL.SETUP.R0 018: IF @LOGNAME = 'root'THEN GO TCL 019: IF @LOGNAME = 'brutzy' THEN GO TCL 020: IF @LOGNAME = 'raymond' THEN GO TCL 022: MM 024: TCL: ottom at line 24. --Bill -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Thursday, April 12, 2012 3:08 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] COMMON Size MisMatch f you *do* use CLEARCOMMON you have to be alert to gremlins as well. OGTO is not expecting to have to reinitialize the system and so probably oesn't. ou need to review what the Login process is doing as well. ou may end up wiping out control information such as the user's port, name, ogin time, functions they can and can't do, menu access, default printer, and o on and so forth. All depends on how complex the login processor has become at your site. ome sites don't do a darn thing. Some have thousands of lines of code at ogin. Some of which set common (read environment) variables, that you *don't ant* to clear, or at least that you want to reset if you do clear them. -Original Message- rom: Bill Brutzman bi...@hkmetalcraft.com o: U2 Users List u2-users@listserver.u2ug.org ent: Thu, Apr 12, 2012 11:52 am ubject: Re: [U2] COMMON Size MisMatch ating my own dog food... I cranked CLEARCOMMON into the LOGTO SandBox and GTO LIVE paragraph commands. -Bill rom: u2-users-bounces at listserver.u2ug.org mailto:u2-users-bounces at istserver.u2ug.org] On Behalf Of on_Bausili at hcsc.net nt: Thursday, July 16, 2009 10:17 AM : u2-users at listserver.u2ug.org bject: [U2] Fw: COMMON misMatch ince all common variables are cleared when you exit UniVerse, and liminates the rror, is it possible your user used a LOGTO command to witch environments that ave different versions of the subroutine OP.R87? e had both a Test and a Prod environment on the same box, and xperienced roblems when enhanced code in Test was being staged for romotion into Prod. xecuting a program in Test that had changes to ts COMMON, and then logging into rod resulted in the size mismatch rror when running the unchanged program. ur solution was to insert CLEARCOMMON in the LOGIN paragraphs. on --- Forwarded by Don Bausili/OK/HCSC on 07/16/2009 09:09 AM - Brutzman, ill BillB at hkMetalCraft.com Sent by: -users-bounces at listserver.u2ug.org /15/2009 06:55 PM ease respond to 2 Users List u2-users at listserver.u2ug.org o 2 Users List u2-users at listserver.u2ug.org c Subject : [U2] COMMON misMatch A user here obtained an error message... COMMON size mismatch in subroutine HOP.R87. pon logging out and then logging back in again... The HOP program was ble to aunch without this error. elp with a diagnosis and more reliable cure would be appreciated. his user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2. -Bill __ -Users mailing list -Users at listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users he information contained in this communication is confidential, rivate, oprietary, or otherwise privileged and is intended only for the use of he ddressee. Unauthorized use, disclosure, distribution or copying is trictly rohibited and may be unlawful. If you have received this ommunication in rror, please notify the sender immediately at (312) 3-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in klahoma; or 972)766-6900 in Texas. _ -Users mailing list -Users at listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users evious message: [U2] Fw: COMMON misMatch ext message: [U2] Universe Retrieve ssages sorted by: [ date ] [ thread ] [ subject ] [ author ] ore information bout the U2-Users -Original Message- om
Re: [U2] New U2 BDT - V3
There is a Rocket BDT manual available for download. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Thursday, March 15, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 I would like to live in this tool all day long. I have experimented with BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about it. I'm having to be able to be productive quickly, so I find myself reverting back to WED when I have to get something done quick. It would be helpful if there is an online tutorial, so I could transition to BDT full time. ? (I'm only interesting in learning about BDT, not any other alterative EDIs at this time, thanks) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, March 12, 2012 2:46 PM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 The new BDT is version 3.0.0. Considering that I live in this tool almost all day long, I appreciate Rocket's updating it very much indeed. --Bill ___ 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] New U2 BDT
I was glad to learn about the new BDT. The BDT install was painless and BDT seems to work well. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT - V3
The new BDT is version 3.0.0. Considering that I live in this tool almost all day long, I appreciate Rocket's updating it very much indeed. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Monday, March 12, 2012 2:56 PM To: U2 Users List Subject: Re: [U2] New U2 BDT Is the new BDT newer than version 1.2.4 ?? that's what I have had over a year... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, March 12, 2012 1:06 PM To: U2 Users List Subject: Re: [U2] New U2 BDT I was glad to learn about the new BDT. The BDT install was painless and BDT seems to work well. --Bill ___ 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] New U2 BDT
What got me going with BDT was... I was developing in Flex. Adobe had two ways to do Flex via Flash Builder. At first I ran Flash Builder as an Eclipse plug-in. There were some quirks with the plug in and after several months of use, I switched over to the canned build, that is, Adobe's bona fide Flash Builder launched from a desktop icon. Right about then Rocket released the first BDT. Of course, Eclipse is an industry standard. While the learning curve for first-time Eclipse back then users was frustrating... that hundreds of companies... among them Rocket, Adobe and u2Logic... build tools using Eclipse... there is hardly any controversy. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, March 12, 2012 3:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New U2 BDT Bill I'd like to know what particular ability made you want to use BDT -Original Message- From: Bobby Worley bwor...@coburns.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Mar 12, 2012 11:56 am Subject: Re: [U2] New U2 BDT Is the new BDT newer than version 1.2.4 ?? that's what I have had ver a year... -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman ent: Monday, March 12, 2012 1:06 PM o: U2 Users List ubject: Re: [U2] New U2 BDT I was glad to learn about the new BDT. The BDT install was painless and BDT seems to work well. --Bill __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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] New U2 BDT
Bill: Consider opening a tech support incident with Rocket. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, March 12, 2012 4:01 PM Subject: Re: [U2] New U2 BDT Bill: I'm glad you love the tool. I may too, but wonder why I can't open it, get access to a 'Q' pointer from one account to the program files in another account, and edit the program. I also wondered why I couldn't edit a dictionary item nor why the connection timed out, which crashed my session. Then again, I've been known to require a much too simple environment, accessing multiple accounts and records. :-) Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-value explode in AE
Will: Consider trying... EV... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, February 24, 2012 3:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multi-value explode in AE What's that AE command to view or edit a multivalued attribute ___ 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] Building an Excel File
John: Perhaps the easiest way to do this is with Adobe's ColdFusion. To get started... the developer version of ColdFusion is free. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, February 06, 2012 4:40 PM To: 'U2 Users List' Subject: [U2] Building an Excel File We are running UniData on a UNIX platform. We create tab-delimited txt files (and tab delimited txt files with xls extensions) all the time that users open with Excel. Many of these jobs are run in the middle of the night or in a trigger program. In all cases, there is no direct user interaction building these files. We also have some XML files that are coded so that Excel opens them with formatting, colors, filters, etc. Unfortunately, our BB users and iPhone users can not open these files up in a meaningful way. Is there a way to build a TRUE Excel file without any user intervention from UniData or UNIX? John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ 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] [U2} Job Opportunity
Location:Springfield, MA Full Time salary range : DOEk/Yearly ROCKET SOFTWARE UniVerse development with 5 year experience PowerBuilder 6 UNIX Application Support Daya Shashtri 630-246-6039 d...@enterprisesolutioninc.com www.enterprisesolutioninc.com G-Talk: daya.esi YM: shashtri_2k6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Update the VOC after upgrade?
John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- 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
Re: [U2] Update the VOC after upgrade?
Yes... that is the right way to read my first response. It is not clear to me if that approach is workable... it was merely a possible angle. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, January 30, 2012 4:49 PM To: 'U2 Users List' Subject: Re: [U2] Update the VOC after upgrade? I think he means to 'include' the 'update' to the VOC as part of each accounts LOGIN script?? Am I reading that right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 3:37 PM To: U2 Users List Subject: Re: [U2] Update the VOC after upgrade? You mean in the main UV account? I'm not following... On Mon, Jan 30, 2012 at 3:59 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: John: Consider the script at ED VOC LOGIN --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, January 30, 2012 2:18 PM To: U2 Users List Subject: [U2] Update the VOC after upgrade? Anyone know of a way to NOT have to login to every account I have to update the VOC after a Universe upgrade? For example, I would like to run something from TCL, or from unix/linux that I could make loop through the UV.ACCOUNTS file and update the VOC's. Any ideas? -- 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 -- 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value 101 ?
It is not clear to me why Passing By Value is worth anything. I am surprised that this thread has led to so many responses... most... I did not read. From here... having a variable with a name... and calling an external subroutine... is all the bread and butter that I would ever need. myGuzInTa = '' myGuzOutA = '' errorFlag = '' Call *SUB.MY.THING.R1(myGuzInTa, myGuzOutA, errorFlag) Begin case Case myGuzOutA = '' ; gosub xx Case 1 ; gosub yy Endcase Putting a thingy-poo in double parens seems to be at odds with good programming practice. Perhaps I am missing something... I promise to try to read clarifying responses... --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date Problem
Revision control would say to create a new include file with its own revision ID... and then include the new include file in the program that needs it... perhaps in subsequent programs. --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, January 20, 2012 12:36 PM To: 'U2 Users List' Cc: Conway, Bruce; Majors, Larry Subject: [U2] Date Problem I have an INCLUDE that I use in ALL programs I touch. It simply does a bunch of assigning of variables so that I can use them as needed. One of these assignments is: TODAY = @DATE I have 1 program in 1 account that is consistently returning: 16066 (which is 12/26/11). This program is initiated via a Redback call but so are many many others. In the pgm that is failing, immediately after my INCLUDE, I just added code to write the following to disk: TODAY DATE() @DATE Both TODAY and @DATE ALWAYS return 16066 for this 1 program, but no others. The same program is working correctly in other accounts, and the value of TODAY is correct in EVERY other program I have ever used. Does anyone have a clue? I could replace @DATE with DATE() in my INCLUDE, but to do my due diligence, I should recompile EVERY program that uses the INCLUDE (and that is NOT going to happen). John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ 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] Brilliant? or not?
From the perspective of writing scenario-proof code...I live in a world of case statements... Begin case Case s1 s2 ; sMax = s1 Case 1 ; sMax = s2 Endcase --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, January 13, 2012 12:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Brilliant? or not? What's wrong with IF S1 S2 THEN SMAX = S1 ELSE SMAX = S2? Definitely more readable! If it was hard to write then it should be hard to read, I guess. On 13/01/2012 17:41, Wjhonson wrote: SMAX = (S1 S2) * S1 + (S2= S1) * S2 ? ___ 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] Line Printer Control
We still use a greenbar printer to print checks. Via a UniBasic program, I am trying to send an alignment pattern to the printer before starting the check run. The trouble is that it always does a form feed after the alignment pattern. I have been diddling with toggling options in... execute 'SETPTR 0,132,60,2,0,1,NHEAD,BRIEF,NFMT,NOEJECT,NODEFAULT,NOFORMFEED, AT PR0' PRINTER OFF PRINTER CLOSE Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
