Re: [U2] Resize Question
Thank you very much! That has helped a lot and I can now see the data in the UV command line :) If possible, I am now hoping to be able to expose this imported data to ODBC so I can work with it in PHP, etc. But I am again finding problems I cannot find an answer for in the help docs or searching the list archive. First, I created a PICK account using the U2UG guide mentioned. I then used HS.ADMIN option 3 to "Activate access to files in an account" which went well and showed it as an activated account. I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files from the live UniVerse server to my account as well as my test table ZIP (ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on the command line using SELECT COUNT(*) FROM ZIP and the like. However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE, and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN option 3 again on the account and for most things it said: Could not open file FILENAME. STATUS() = -2 "FILENAME" was not written into File Information Cache. For the file I copied over, ZIP, it said: ZIP's dictionary has no @ phrase or @SELECT phrase. "ZIP" was written into File Information Cache but may not behave as desired. This is a little confusing as I thought D_ZIP was the dictionary file and SELECT works on the command line. After this, I checked ODBC and saw the 3 above and one more table called UVMD. I am not sure what this was so I got it but it appears to be a system table of some sort. Thanks again for any tips on how to properly setup/expose this file/table to ODBC! Andrew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, February 01, 2010 11:55 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname to the index into the file header. You will need to remove this using the SET.INDEX command thus: SET.INDEX filename TO NULL Next, the file size: The D_ZIP is the dictionary file. If you haven't fnuxi'd this, the modulus in the file header will be in the wrong byte order, so the reported modulus (16777216) is garbage. You will need to fnuxi D_ZIP as well. Incidentally - Download the free daily admin guide from the U2UG website (under the Learner Pack) for more details: here is a top level view - The modulus is one of the two components of sizing a file, and refers to the number of groups (pages) in the file. As it says, in personal edition there is a limit to this value. This number is independent of the actual data stored since a) it is the space reserved, so part may be empty, and b) you can make the size of each group (page) - also known as the separation - larger to store the data, it just makes the file less performant (and affects things like locking). To change the modulus and separation, look at the RESIZE command (HELP RESIZE). Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 01 February 2010 4:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Resize Question I'd like to preface this by saying I am a UniVerse newbie. Ideally, I am trying to import some data into a personal edition UniVerse database but I am having some trouble. One example is a ZIP code lookup called ZIP. First, I copied the files in from a UNIX system to a Windows install of Personal Edition. Not ideal but not sure if it's a deal-breaker as yet so I'm moving on... Then, I did fnuxi VOC and fnuxi ZIP. VOC was fine but on ZIP I got a warning the secondary indices are defined in a unix location and if necessary, use SET.INDEX to update file header to correct locations. I am not sure how to use SET.INDEX so I have not done anything with that. Now I go to UniVerse and get "Your VOC is out of date. Update to current release (Y/N)? If I select Yes, I get an error about &TEMP& being in my VOC file but unable to create it. I believe this is because I do not have all the data copied over from the live UniVerse server, so I select No and get "Unable to open the operating system file "OC.O/LOGON.TESTER" where TESTER is the account name logging on. That gives me a prompt so I can do ANALYZE.FILE ZIP and I see the file type is 18, modulo is 4507 and separation is 1. There are 44,098 records. Then I try a "SELECT ST FROM ZIP" to get the states and I get an error saying "File "D_ZIP" has modulo 16777216 which is > 10007. Please resize it to modulo <= 10007 in order to use it in Personal Edition." I have tried running RESIZE of various file types, modulo, and separation, but I still get the error on D_ZIP every time. I have no idea how to get D_ZIP down to <= 10007 or if it is even po
Re: [U2] HP Unix "who am i"
One place I worked, the users called that "whammy". > Date: Tue, 2 Feb 2010 09:41:40 -0500 > From: bro...@pny.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] HP Unix "who am i" > > > Congrats on finding the solution to that tough problem > > Barry Rogen > PNY Technologies, Inc. > Senior Programmer/Analyst > (973) 515 - 9700 ext 5327 > bro...@pny.com > - > We are continually faced with great opportunities > brilliantly disguised as insoluble problems. > John W Gardner > > Before printing please think about your environmental responsibility > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M Hunter > Sent: Tuesday, February 02, 2010 9:35 AM > To: 'U2 Users List' > Subject: Re: [U2] HP Unix "who am i" > > Found the problem to be with the peek shell running on the new hp 3600 > b.111.31 ia64. It works only under the korn shell. So changed the users to > start in the korn shell and then exec the peek shell and everything works. > > Thanks for the information everyone. > > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M > Hunter > Sent: Wednesday, January 27, 2010 9:46 PM > To: 'U2 Users List' > Subject: Re: [U2] HP Unix "who am i" > > Did this and it still does not work > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor > Sent: Tuesday, January 26, 2010 9:04 AM > To: 'U2 Users List' > Subject: Re: [U2] HP Unix "who am i" > > Another long shot, but this was in the hp knowledge base. I had to cut and > paste the article, so please forgive any formatting issues. > > --- > > > > Title: HP-UX 11.23 ssh: who(1) -m option fails to display as expected > Document ID: emr_na-c00996974-3 > Submitted Date: 2007-04-17 20:01:19.0 > Last Modified Date: 2008-06-30 17:49:48.0 > > You may provide feedback ( > http://www11.itrc.hp.com/service/help/askQuestion.do ) on this document > HP-UX 11.23 ssh: who(1) -m option fails to display as expected > PROBLEM > With HPUX 11.23 a "who -Rm" added to .profile fails > to display as expected. For example, from the debug: > > + + who -Rm > + cut -d: -f1 > + sed -n s/^.*(\(.*\))$/\1/p > DISPLAY=:0.0 > > > CONFIGURATION > Operating System - HP-UX > Version - 11.23 > Subsystem - ssh A.03.x > > RESOLUTION > This problem has been identified as a timing issue in > multiple versions of ssh A.03.x on HP-UX 11.23 and has > been isolated to the -m option. Other versions of HP-UX > appear to be unaffected. A fix is planned. > > The addition of a sleep(1) command has been found to > work around this issue. For example: > > sleep 6 > who -Rm > > > ALT KEYWORDS > ssh > "who -Rm" > "who -m" > > ___ > 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 _ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. http://clk.atdmt.com/GBL/go/201469229/direct/01/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] HP Unix "who am i"
Congrats on finding the solution to that tough problem Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M Hunter Sent: Tuesday, February 02, 2010 9:35 AM To: 'U2 Users List' Subject: Re: [U2] HP Unix "who am i" Found the problem to be with the peek shell running on the new hp 3600 b.111.31 ia64. It works only under the korn shell. So changed the users to start in the korn shell and then exec the peek shell and everything works. Thanks for the information everyone. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M Hunter Sent: Wednesday, January 27, 2010 9:46 PM To: 'U2 Users List' Subject: Re: [U2] HP Unix "who am i" Did this and it still does not work -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Tuesday, January 26, 2010 9:04 AM To: 'U2 Users List' Subject: Re: [U2] HP Unix "who am i" Another long shot, but this was in the hp knowledge base. I had to cut and paste the article, so please forgive any formatting issues. --- Title: HP-UX 11.23 ssh: who(1) -m option fails to display as expected Document ID: emr_na-c00996974-3 Submitted Date: 2007-04-17 20:01:19.0 Last Modified Date: 2008-06-30 17:49:48.0 You may provide feedback ( http://www11.itrc.hp.com/service/help/askQuestion.do ) on this document HP-UX 11.23 ssh: who(1) -m option fails to display as expected PROBLEM With HPUX 11.23 a "who -Rm" added to .profile fails to display as expected. For example, from the debug: + + who -Rm + cut -d: -f1 + sed -n s/^.*(\(.*\))$/\1/p DISPLAY=:0.0 CONFIGURATION Operating System - HP-UX Version - 11.23 Subsystem - ssh A.03.x RESOLUTION This problem has been identified as a timing issue in multiple versions of ssh A.03.x on HP-UX 11.23 and has been isolated to the -m option. Other versions of HP-UX appear to be unaffected. A fix is planned. The addition of a sleep(1) command has been found to work around this issue. For example: sleep 6 who -Rm ALT KEYWORDS ssh "who -Rm" "who -m" ___ 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] HP Unix "who am i"
Found the problem to be with the peek shell running on the new hp 3600 b.111.31 ia64. It works only under the korn shell. So changed the users to start in the korn shell and then exec the peek shell and everything works. Thanks for the information everyone. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleene M Hunter Sent: Wednesday, January 27, 2010 9:46 PM To: 'U2 Users List' Subject: Re: [U2] HP Unix "who am i" Did this and it still does not work -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Tuesday, January 26, 2010 9:04 AM To: 'U2 Users List' Subject: Re: [U2] HP Unix "who am i" Another long shot, but this was in the hp knowledge base. I had to cut and paste the article, so please forgive any formatting issues. --- Title: HP-UX 11.23 ssh: who(1) -m option fails to display as expected Document ID: emr_na-c00996974-3 Submitted Date: 2007-04-17 20:01:19.0 Last Modified Date: 2008-06-30 17:49:48.0 You may provide feedback ( http://www11.itrc.hp.com/service/help/askQuestion.do ) on this document HP-UX 11.23 ssh: who(1) -m option fails to display as expected PROBLEM With HPUX 11.23 a "who -Rm" added to .profile fails to display as expected. For example, from the debug: + + who -Rm + cut -d: -f1 + sed -n s/^.*(\(.*\))$/\1/p DISPLAY=:0.0 CONFIGURATION Operating System - HP-UX Version - 11.23 Subsystem - ssh A.03.x RESOLUTION This problem has been identified as a timing issue in multiple versions of ssh A.03.x on HP-UX 11.23 and has been isolated to the -m option. Other versions of HP-UX appear to be unaffected. A fix is planned. The addition of a sleep(1) command has been found to work around this issue. For example: sleep 6 who -Rm ALT KEYWORDS ssh "who -Rm" "who -m" ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] table of mv-handling functions
Thanks, Rick & Kate. Got it. For the record, "ABSS" is missing from that list. And the vector equivalent of "MATCH" is not listed. It's a bit of an anomaly because "MATCHES" with an S was already defined as a synonym for MATCH operator. So there is only a subroutine version, not a function form of the vector equivalent: CALL !MATCHES( result.mv, string.mv, pattern.mv ) <==> result = ( string, pattern ) On 2/1/2010 1:02 PM, Rick Nuckolls wrote: I should have said "sysdesc.pdf". On Feb 1, 2010, at 9:50 AM, Charles Stevenson wrote: There is (used to be?) a very nice table of all the multivalue-handling functions, lining them up with their single-value equIvalents. It looks/looked something like: MV-handler function Single-valued equivalent --- CATS( X, Y ) ( X : Y ) GTS( X,Y ) ( X GT Y ) IFS( X, Y, X ) ( IF X THEN Y ELSE Z ) OCONVS( X, Y ) OCONV( X, Y ) ...and so on... I think it had a nice description of the overarching common syntax& functionality, including how REUSE() works. I can't find said chart. I need it for some newbies. This may be going all the way back to PI, not universe. I don't see it in UV10.3 docs. Can anyone tell me where it is? The brain addles, cds ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users