RE: set.term.type,Redhat 8.0, UV 10.0.9
Check your UV terminfo files ... (and possibly your unix/linux ones too). There's almost certainly a setup string in their you need to tweak. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Richmond Sent: 16 February 2004 20:29 To: u2 Subject: set.term.type,Redhat 8.0, UV 10.0.9 Hi All, We are in the process of migrating fron HPUX 10.20, UV 9.4.1.1 to Redhat 8.0, UV 10.0.9. We are having a problem with Universe SET.TERM.TYPE command. When we do 'SET.TERM.TYPE VT320 the terminal emulator (QVT 5.2) switches the number pad from numeric to application' mode. This does not happen on our current system. Has anyone else experienced this problem? If so, What did you do to remedy this? Thanks, Steve -- Steve Richmond Associate Director of Computer Applications Morehead State University 606-783-5236 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Enabling ODBC for non-SQL file
Did you run HS.UPDATE.FILEINFO? Have you put the correct SQL type definitions in fields 8? Did HS.UPDATE.FILEINFO actually work correctly! THAT'S A BIGGIE! I've shoved a little article on pickwiki you might want to look at - multivaluedatabasesuniverseodbcaccess Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 17 February 2004 01:11 To: U2 Users Discussion List Subject: Re: Enabling ODBC for non-SQL file Thanks, I went through the options on the HS.ADMIN menu, including HS.SCRUB and the HS_FILE_ACCESS file was created. For some reason it excluded the file I need from HS_FILE_ACCESS though, even though I added an @SELECT dictionary item. If I run CONVERT.SQL against the file (not using my live data file), I can then see it via ODBC in Excel, but the dict items don't work correctly. Is it safe to manually add a record for the non-SQL file to HS_FILE_ACCESS? Thanks, John Jeff Schasny wrote: First create an @SELECT item in the dictionarys of the files you are aiming at. Then logto HS.ADMIN and issue the HS.ADMIN command from TCL. Select Option #3 to activate access to files in an account. Whenever you change an @SELECT Item or want to add access to another file you can run HS.UPDATE.FILEINFO in the account rather than going back to the HS.ADMIN account and running option #4 (Update File Information Cache in an account). -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 3:34 PM To: U2 Users Discussion List Subject: UV: Enabling ODBC for non-SQL file I'm trying to enable ODBC access to a standard UV non-SQL file and have found the following in the ODBC manual: To make UniVerse files accessible to ODBC applications, you must run the ODBC file access utility in the account. However, they don't bother to say what this ODBC file access utility is called. I've tried listing the VOC LIKE ...HS... and ...MENU... but can't find anything relevant. Are they referring to HS.UPDATE.FILEINFO? TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
COMO: Help on How to use COMO?
I want to log all errors in a record of COMO without displaying them on screen? How should I intiallize como and how can I pass this error message to that record, E.g. WRITEU D.FILE TO F.FILE,K.ID LOCKED PRINT ERROR::K.ID: record locked by user :STATUS():, please stand-by ELSE PRINT ERROR:Failed to write in :FILE: with ID=:K.ID I want to store this error message in a record of COMO file regards Amit Bhutani -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Using OpenOffice with UniVerse/Unidata - request for U2 users to be involved
Thanks to Farrel for responding to my plea and for the contact details of other users. I don't think this is a good move...MS-Office is bloatware, and as MS patents it's XML formats (the Patent Office is so stoopid! Tomorrow, I will patent Air, and start charging everyone on Earth usage fees!), many may move away from it, if only for interoperablity sake. But that's just my personal opinions. This is crazy; IBM may believe that OOo does'nt meet users requirements but that does'nt gel with our experience. I'm faced by UniVerse customers who want to get away from Microsoft, read about IBMs commitment to Linux, which I don't for a minute doubt, but I cannot offer an alternative to MS Office where the users need to use reporting tools similar to MSQuery because ODBC drivers from IBM for U2 products on Linux are not available and the JDBC does'nt quite work with OOo. To get around this, we're still using StarOffice 5.2 which supports ODBC 2.0, but only on Windows PCs. Firstly, the performance of OOo is really good and we have not been able to match it with MS Office on a thin-client platform. At a customer site we have successfully migrated 45 users onto a single Intel-based server running Linux and OpenOffice for thin-client based users. This includes those users who have the RTC syndrome (resistance to change) like the executive secretaries and personal assistants. Whatever functionality may be missing in OOo that is in MS Office is obviously not used. This includes receiving and sending MS Office documents (Excel, Word, Powerpoint) to the corporate head-office who have inplemented MS Office. The server also acts as the browser server for 20 users, print and file services for the other 35 Windows users who are still to be converted and telnet server for the 45 users who access UniVerse applications running on IBM pSeries 615 from their low-end P1 133 Mhz PC-based thin clients. Secondly, You can already run MSOffice as well as IE6 on Linux under Wine and can install it easily with crossover from Codeweavers, and the performance in a thinclient environment is reasonable but does not compare to OOo on Linux - we've tried MS Office/IE; it works. We've even installed Dynamic Connect on Linux with some success. The third issue is the cost of implementing,upgrading,licensing MS Office. A thin client solution using MS tools (Win2000/RTS licences,MS Office licences etc) is horrendous; but porting MS Office to Linux will only eliminate the OS/RTS level licencing but you'll still have to pay good money for MS Office. The point is that there is an excellent alternative and IBM could make the implementation of U2 products more cost-effective for users by ensuring that the interfaces (ODBC,JDBC etc) actually work with non-MS systems, for example what about supporting Lotus Approach - is'nt it still their product. If IBM support MSOffice on Linux will the client tools, UniDK etc,. for the U2 products be ported to Linux as well - probably not at a guess, which pretty much leaves the U2 community committed to an MS desktop environment. What about the porting of UniVerse/UniData to Linux on the pSeries. Ian Stuart -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COMO: Help on How to use COMO?
If you type HELP COMO at TCL, it'll tell you ... Or I'll tell you :-) From within your program (or wherever) do an EXECUTE COMO ON PROGOUTPUT HUSH This will create a PROGOUTPUT record in the COMO file that you can then access with the editor or whatever you want. To turn off the como, just do EXECUTE COMO OFF Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amit Bhutani Sent: 17 February 2004 13:07 To: U2 Users Discussion List Subject: COMO: Help on How to use COMO? I want to log all errors in a record of COMO without displaying them on screen? How should I intiallize como and how can I pass this error message to that record, E.g. WRITEU D.FILE TO F.FILE,K.ID LOCKED PRINT ERROR::K.ID: record locked by user :STATUS():, please stand-by ELSE PRINT ERROR:Failed to write in :FILE: with ID=:K.ID I want to store this error message in a record of COMO file regards Amit Bhutani -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: COUNT modifying unix timestamp
Actually, it was added in during release 7.x of uniVerse to support the SQL optimizer. The optimizer used the count to make a determination on how long it would take to perform certain SQL operations such as outer-joins, etc, and spit out a warning message something like It will take 4307 hours to perform this operation. Do you want to continue?. At first, only an unqualified COUNT command (i.e. COUNT FILE) would update this field, but sometime in early 8.x releases, I added the code into uvbackup/uvrestore so that it would also update this field. That was quite a few years ago so I don't have the exact timeframes, but there ya go Glenn At 04:54 AM 02/17/2004, Martin Phillips wrote: Apologies if I missed anyone already giving this explanation... The other thing, of course, which timestamp? Date modified, or date accessed? Are you sure your client isn't looking at the wrong one? UniVerse file system revision 12 which came in at release 9.5 includes a count of records in the file header for use by uvbackup and uvrestore. This is updated by COUNT and by uvbackup itself (perhaps other places too). Maybe it's time for another plug for the UniVerse Internals course where these things get discussed??? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniVerse and Backup Exec
I am running: UniVerse 10.0.17 Windows 2000 SP 4 Veritas Backup Exec: Media Server Admin. Console: Ver 9.00 Rev 4454 My Application Event Log has been showing an unusually high number of UniVerse errors. Since I am an end user I can't go directly to IBM and must go through my VAR. I placed a call with my VAR and sent them a text copy of my application event log. The response was that IBM said I should uninstall Backup Exec because they have had 250 calls where the problem with UniVerse was resolved after removing Veritas Backup Exec. I am stuck between a rock and a hard place now. IBM says I should uninstall my backup software. The administrator that is responsible for backup systems for our corporation is resistant to allowing me to do this, however. He says that we will not uninstall Backup Exec unless IBM can tell us specifically what the incompatibility is between it and UniVerse. The main reasons for his stance are that the event log errors are all labeled UniVerse errors (none are labeled as Backup Exec errors) and the errors occur around the clock, not just when Backup Exec is running. I had asked my VAR to request specifics regarding the incompatibility issue from IBM but either they or IBM must have figured that the numbers spoke for themselves because I was not given a reason. (or possibly they don't know the reason) Can anyone out there help me? Does anybody know what the incompatibilities are between Veritas Backup Exec and UniVerse? I tend to lean towards following IBM's recommendations but just in case... Has anyone found a way to run the two where application event errors do not occur? I also requested a recommendation of other backup software from them and was not given one. If anyone has a recommendation of UV compatible backup software that I can run on Windows, I'd appreciate it. Thanks in advance for any help you can offer! Gwen Buck Gaska Tape Inc. [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV - NLS
I am attempting to install and activate NLS on a UniVerse system, 10.0.19 on an HP-UX 11.0 box. We just recent upgraded from 9.6.1.14 to 10 by recommendation from IBM. They said 10.x was a better ground to work from for NLS. My problems is activating NLS - changing NLSMODE in 'uvconfig' to '1'. When I do make that change... uvregen and uv.rc stop work fine. When I uv.rc start, I get the message Unable to get National Language Support shared memory segment I have unistalled and re-installed NLS multiple times. I (with the help of IBM) have gone through the uvconfig and HP kernel setting for a problem - no problems found. Lo though I have tried, I can not get to activate NLS without the error message Unable to get National Language Support shared memory segment IBM seems to be totally befuddled, stymied and confused by this, Any assistance, thoughts would be appreciated. Thanks very much Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - NLS
Barry, Sounds like the NMEMOFF value is not correct. What are yourDMEMOFF, PMEMOFF, CMEMOFF and NMEMOFF values? At 09:34 AM 02/17/2004, you wrote: I am attempting to install and activate NLS on a UniVerse system, 10.0.19 on an HP-UX 11.0 box. We just recent upgraded from 9.6.1.14 to 10 by recommendation from IBM. They said 10.x was a better ground to work from for NLS. My problems is activating NLS - changing NLSMODE in 'uvconfig' to '1'. When I do make that change... uvregen and uv.rc stop work fine. When I uv.rc start, I get the message Unable to get National Language Support shared memory segment I have unistalled and re-installed NLS multiple times. I (with the help of IBM) have gone through the uvconfig and HP kernel setting for a problem - no problems found. Lo though I have tried, I can not get to activate NLS without the error message Unable to get National Language Support shared memory segment IBM seems to be totally befuddled, stymied and confused by this, Any assistance, thoughts would be appreciated. Thanks very much Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - NLS
I am at a loss to find these parameters to give you an answer. I have scoured uvconfig and the HP kernel for these setting and come up empty. Could you clue me where to find these settings. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, February 17, 2004 9:47 AM To: U2 Users Discussion List Subject: Re: UV - NLS Barry, Sounds like the NMEMOFF value is not correct. What are yourDMEMOFF, PMEMOFF, CMEMOFF and NMEMOFF values? At 09:34 AM 02/17/2004, you wrote: I am attempting to install and activate NLS on a UniVerse system, 10.0.19 on an HP-UX 11.0 box. We just recent upgraded from 9.6.1.14 to 10 by recommendation from IBM. They said 10.x was a better ground to work from for NLS. My problems is activating NLS - changing NLSMODE in 'uvconfig' to '1'. When I do make that change... uvregen and uv.rc stop work fine. When I uv.rc start, I get the message Unable to get National Language Support shared memory segment I have unistalled and re-installed NLS multiple times. I (with the help of IBM) have gone through the uvconfig and HP kernel setting for a problem - no problems found. Lo though I have tried, I can not get to activate NLS without the error message Unable to get National Language Support shared memory segment IBM seems to be totally befuddled, stymied and confused by this, Any assistance, thoughts would be appreciated. Thanks very much Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - NLS
Oh RIGHT!! DUH!!! I am very sorry that I made this error. I had forgotten that those values are hardbaked at compile time into universe and can't be changed onsite. In any case, the problem appears to be that the shmget system op is failing for some reason or other. Also, check that no existing 0xACEE segment exists (i'm sure this has been done). At 10:03 AM 02/17/2004, you wrote: I am at a loss to find these parameters to give you an answer. I have scoured uvconfig and the HP kernel for these setting and come up empty. Could you clue me where to find these settings. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, February 17, 2004 9:47 AM To: U2 Users Discussion List Subject: Re: UV - NLS Barry, Sounds like the NMEMOFF value is not correct. What are yourDMEMOFF, PMEMOFF, CMEMOFF and NMEMOFF values? At 09:34 AM 02/17/2004, you wrote: I am attempting to install and activate NLS on a UniVerse system, 10.0.19 on an HP-UX 11.0 box. We just recent upgraded from 9.6.1.14 to 10 by recommendation from IBM. They said 10.x was a better ground to work from for NLS. My problems is activating NLS - changing NLSMODE in 'uvconfig' to '1'. When I do make that change... uvregen and uv.rc stop work fine. When I uv.rc start, I get the message Unable to get National Language Support shared memory segment I have unistalled and re-installed NLS multiple times. I (with the help of IBM) have gone through the uvconfig and HP kernel setting for a problem - no problems found. Lo though I have tried, I can not get to activate NLS without the error message Unable to get National Language Support shared memory segment IBM seems to be totally befuddled, stymied and confused by this, Any assistance, thoughts would be appreciated. Thanks very much Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How you grow journal entry limitation
we runing UniVerse 9.5.2 r11 OS Tru64 5.1a for a merge off two database, we must input more than 31888 records par day, the problem is the journal have a limitation to 15000 ~ records, It is possible to grow this limitation I'm not clear as to the exact problem. Are you saying there's a UniVerse hashed file called journal that is not large enough for the number of records it needs to support? If so, it will have to be resized, perhaps changing it to a dynamic file. Or is the journal something else? If you can clarify this, we can try to offer specific solutions. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
MV Vendors
Gang, I'm managing two MV Community calendars (user group meetings, conferences, etc.). One is at www.keyally.com/mvcalendar.html and the other will be on the U2UG.org site in the near future. I need help. Please send me info, especially on Vendor-based events for anyone that has MV products. - Charles 'He's so slow they timed him with a calendar' Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COMO: Help on How to use COMO?
Amit, You want error messages in the COMO but not on the screen, right? Use DIVERT.OUT TTY.OFF/TTY.ON DIVERT.OUT is the more general command. In fast, the COMO verb is actually a basic program that executes DIVERT.OUT (source in $UVHOME/uv/BP/COMO_VERB). Example: CT CDS.BP BHUTANI BHUTANI 0001 CRT 'CRT 1 to screen como.' 0002 PRINT 'PRINT 1 to screen como.' 0003 PERFORM 'DIVERT.OUT TTY.OFF'-- what you want 0004 CRT 'CRT 2 only to como' 0005 PRINT 'PRINT 2 only to como' 0006 PERFORM 'DIVERT.OUT TTY.ON' -- what you want 0007 CRT 'CRT 3 to both screen como.' 0008 PRINT 'PRINT 3 to both screen como.' 0009 STOPM 'Stopm to both screen como.' COMO ON BHUTANI- turn como on COMO BHUTANI established 11:10:06 17 FEB 2004 RUN CDS.BP BHUTANI CRT 1 to screen como. PRINT 1 to screen como. CRT 3 to both screen como. -- what you want PRINT 3 to both screen como. Stopm to both screen como. COMO OFF -- turn como off COMO completed. 11:10:16 17 FEB 2004 CT COMO BHUTANI BHUTANI 0001 COMO BHUTANI established 11:10:06 17 FEB 2004 0002 RUN CDS.BP BHUTANI 0003 CRT 1 to screen como. 0004 PRINT 1 to screen como. 0005 CRT 2 only to como-- what you want 0006 PRINT 2 only to como -- what you want 0007 CRT 3 to both screen como. 0008 PRINT 3 to both screen como. 0009 Stopm to both screen como. 0010 COMO OFF 0011 COMO completed. 11:10:16 17 FEB 2004 Another way more similar to the unix idea of redirecting stdout is to use a different print channel directed to HOLD for some messages. (PRINT ON n), but that file would contain ONLY the redirected messages. Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV write fatal error
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, February 13, 2004 12:13 PM To: [EMAIL PROTECTED] Subject: RE: UV write fatal error Permissions? All the preceding steps (Open, BSCAN) can be done without write permission. Write, needless to add, cannot. -Original Message- From: Jimi DeRouen [mailto:[EMAIL PROTECTED] I am attempting to write a record to a type 25 file and apparently getting a fatal error. The platform is UV 9.5.1.1b Pick flavor on W2K SP4. I have constructed the WRITE statement to include all possible (I think) branching, yet the program goes to the command prompt when the WRITE is executed without following any of the branches. The WRITE statement is as follows: [SNIP] I have no problem writing other values. It is only this particular data value that seems to produce the error. Why wouldn't the program follow the on error branch? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unidata ODBC initial setup error - Run out of ideas!!!
Hi, Although I'm an old hand at Unidata and UniBasic, I'm a newbie to ODBC. I am trying to set up an ODBC link to my Unidata 6.0 database, using the Unidata ODBC driver that came with 6.0, to use in a VB.net application I'm writing. All seems to be set properly, but if I try to do a test of my connection by going to Excel and doing Data/Get External Data/New Database Query from the menu, I always get an error saying Non-numeric found when numeric required. Here's what I've done to this point: I've modified the uni.config file on the AIX 5.1.server. I'm creating a schema for the file using the VSG program included with Unidata 6.0. I'm picking the file from the list of files, assigning ALL permissions to PUBLIC. I'm creating a view and schema using all fields (I have tried with only the text fields). My test file (1NF format) has fields of Name (25L Text), Town (25L Text) Code (8R Number Conv=MR0). My @ID is a number (3 records: 1, 2 3). Valid data in each field. I've tried the @ID field with and without a Conv of MR0. With the MR0, VSG calls it an integer. Without the MR0, VSG calls it a VARCHAR. I get no errors while creating the schema in VSG, and I do see all the 'D' type dictionary fields in VSG, so it appears that it's not a network related error. I'm creating a link to the database in Windows XP Pro (and Win2000 Pro) - Administration Tools - Data Sources. There isn't much to configure here, and I think it's all set up ok. I'm trying to use Excel (have tried Access, too), to see if I can pull in the data, and I always get the message Non-numeric found when numeric required. Any ideas? Thanks, - Dave -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse and Backup Exec
Dear Gwen Buck et al I am running UV 9.6.2.8 on a WinNT 4.0 SP 6.0a box using Veritas Backup Exec. I do not know which release of Veritas that I am using. I haven't had any problems. I'd press your VAR for more detail. One possible solution would be to run a uvbackup and allow Veritas to backup the output from uvbackup. Good luck. Steve At 09:18 AM 2/17/04 -0500, you wrote: I am running: UniVerse 10.0.17 Windows 2000 SP 4 Veritas Backup Exec: Media Server Admin. Console: Ver 9.00 Rev 4454 snip much of message Thanks in advance for any help you can offer! Gwen Buck Gaska Tape Inc. [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV write fatal error
Does the data value actually get inserted into the type 25 file if you check after the write fails? Also, is the data pre-existing within the type 25 file and this is an update to that record? Sounds almost like a memory allocation or rotating file pool problem. The on error branch (actually ANY branch) would only be followed if the run-machine wasn't crashing underneath you, which, if you are being dropped back to the command prompt, is happening. At 11:33 AM 02/17/2004, you wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, February 13, 2004 12:13 PM To: [EMAIL PROTECTED] Subject: RE: UV write fatal error Permissions? All the preceding steps (Open, BSCAN) can be done without write permission. Write, needless to add, cannot. -Original Message- From: Jimi DeRouen [mailto:[EMAIL PROTECTED] I am attempting to write a record to a type 25 file and apparently getting a fatal error. The platform is UV 9.5.1.1b Pick flavor on W2K SP4. I have constructed the WRITE statement to include all possible (I think) branching, yet the program goes to the command prompt when the WRITE is executed without following any of the branches. The WRITE statement is as follows: [SNIP] I have no problem writing other values. It is only this particular data value that seems to produce the error. Why wouldn't the program follow the on error branch? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 and use of compares on indices
Well -- the key is indexed...and so is the date field so the caveat does not apply in this case -- more likely the elusive version 8 is the answer -- Debster -- From Lee Bacall: A bit of a caveat in making selects against indexed keys may be helpful... If one is doing a select against a file with an indexed key, as: SELECT YOURFILE WITH YOURKEY = YOURREQUEST will build a select list against only those records containing the key data YOURREQUEST If, on the other hand if one is doing a select against a file (even when all requested criteria are indexed) as: SSELECT YOURFILE WITH FIRSTKEY = YOURREQUEST AND WITH SECONDKEY = OTHERSTUFF AND WITH THIRDKEY = ABC BY FIRSTKEY BY SECONDKEY BY THIRDKEY The entire file (at least in D3 and jBASE) will be stepped through / searched, WITHOUT the benefit of using keys. Here is some methodology that we have developed to: 1. clarify the building and maintenance of select statements 2. ensure that keys are used to reduce system resource requirements EQU TRUE TO 1, FALSE TO 0 Sel = failure = FALSE cmd = \SELECT YOURFILE WITH FIRSTKEY = FIRSTTHINGIE\ Sel1,-1=cmd * cmd = \SELECT YOURFILE WITH SECONDKEY=SECONDTHINGIE\ Sel1,-1=cmd * *where thirdkey may be a non-indexed element cmd=\SELECT YOURFILE WITH THIRDKEY=YOUGETTHEPICTURE\ Sel1,-1=cmd * *Now, order the list cmd=\SSELECT YOURFILE BY FIRSTKEY BY SECONDKEY BY THIRDKEY\ * max=DCOUNT(Sel1,@VM) FOR z = 1 TO max UNTIL failure EXECUTE Sel1,z CAPTURING messages failure=NOT(SYSTEM(11)) NEXT z IF NOT(failure) THEN GOSUB DoYourThing ;! not shown END STOP. This will ensure that btree keys will be used to make the initial list selections. The non-indexed keys would then be used in secondary tiers of the select procedure to reduce the impact of having to step through the entire file. After the selections are made, the list can then be ordered with greatly reduced impact on the system. Any comments? Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575, emergency# 954-937-8989 - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 13, 2004 1:49 PM Subject: D3 and use of compares on indices On D3 VERION 7.3 what is the syntax to use compares other than = if you are using an indexed dictionary in the statement. It seems to return the correct items if it is simply looking for an equal condition but anything other, such as etc. It appears that it does not use the index, but rather scans the entire file when these operators are used. This becomes a problem especially when a date field has been indexed since that is the most common application. Has anyone else experienced this problem? This is D3 on W2k -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Unidata ODBC initial setup error - Run out of ideas!!!
What version of the driver do you have? I had similar issues with an old driver, I now have 3.01.04.7036 which seems to be working OK, I think it is from the 6.0B Client CD. Although at one time it would work from Access but not Excel?!?! I'm not sure what's changed (perhaps some MS updates). The other key thing is the UCI.CONFIG file. If you treat *everything* in this file as case-sensitive things seem to work a lot easier. IBM also sent me this tech tip when I had this problem: Can you check if this TechTip helps solve the problem. It seems to be an issue with Microsoft Excel. With the upgrade to Microsoft's ODBC Administrator 3.0 there is a change in the use of data source definition with the 32 bit data source. Use of Office 97 or upgrading to Visual Basic 5.0 automatically upgades the 32 bit ODBC Administrator to 3.0 from the previous 2.0 or 2.5 versions. Unfortunately, there is a confusing error that is generated from Microsoft Query/Excel when you try to get external data : Key value must not contain any of the following characters: []{}(),;?*=!@ After you create the data source as a User DSN, you need to create a file.dsn text file. In Windows 95/Windows NT in the directory path /Program Files/Common Files/ODBC/Data Sources. copy an existing .dsn file (or with any editor create a new one). The file contains the following: [ODBC] DSN=sourcename (where sourcename is the name of your data source). If your User DSN entry data source = TSTODBC, then create a file called TSTODBC.dsn or any name you choose with the .dsn suffix. The text is as above: [ODBC] DSN=TSTODBC hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Dave Tabor [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 9:52 AM To: U2 Users Discussion List Subject: Unidata ODBC initial setup error - Run out of ideas!!! Hi, Although I'm an old hand at Unidata and UniBasic, I'm a newbie to ODBC. I am trying to set up an ODBC link to my Unidata 6.0 database, using the Unidata ODBC driver that came with 6.0, to use in a VB.net application I'm writing. All seems to be set properly, but if I try to do a test of my connection by going to Excel and doing Data/Get External Data/New Database Query from the menu, I always get an error saying Non-numeric found when numeric required. Here's what I've done to this point: I've modified the uni.config file on the AIX 5.1.server. I'm creating a schema for the file using the VSG program included with Unidata 6.0. I'm picking the file from the list of files, assigning ALL permissions to PUBLIC. I'm creating a view and schema using all fields (I have tried with only the text fields). My test file (1NF format) has fields of Name (25L Text), Town (25L Text) Code (8R Number Conv=MR0). My @ID is a number (3 records: 1, 2 3). Valid data in each field. I've tried the @ID field with and without a Conv of MR0. With the MR0, VSG calls it an integer. Without the MR0, VSG calls it a VARCHAR. I get no errors while creating the schema in VSG, and I do see all the 'D' type dictionary fields in VSG, so it appears that it's not a network related error. I'm creating a link to the database in Windows XP Pro (and Win2000 Pro) - Administration Tools - Data Sources. There isn't much to configure here, and I think it's all set up ok. I'm trying to use Excel (have tried Access, too), to see if I can pull in the data, and I always get the message Non-numeric found when numeric required. Any ideas? Thanks, - Dave -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Need/Want/Would like to know
Someone came to me with the following code sample, and asked why this would happen, while I have some thoughts, I would like a more definitive answer (note no matter what the answer, I believe the solution is dont do that) Thanks, Mike On Universe 9.5: 04 ED BP P1 P2 SELECTed record name = P1. 6 lines long. : P 0001: * 0002: DIM X(100) 0003: MAT X = 0004: X(100) = 1 0005: CALL P2(X(100), MAT X) 0006: END Bottom at line 6. : EX SELECTed record name = P2. 13 lines long. : P 0001: SUBROUTINE P2(A, MAT X) 0002: DIM X(100) 0003: CRT 'A = ':A 0004: CRT 'X(100) = ':X(100) 0005: * 0006: CRT ; CRT SETTING X(100) = A 0007: X(100) = A 0008: CRT ; CRT NOW RE-CHECKING THE VALUES 0009: * 0010: CRT 'A = ':A 0011: CRT 'X(100) = ':X(100) 0012: RETURN 0013: END Bottom at line 13. : EX File name= BP Record name = RUN BP P1 A = 1 X(100) = 1 SETTING X(100) = A NOW RE-CHECKING THE VALUES A = Program P2: Line 10, Variable A previously undefined. Empty string used . X(100) = Program P2: Line 11, Variable $R0 previously undefined. Empty stri ng used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV write fatal error
Ok. So there WAS a bscan done on the T25 file prior to attempting the write. Since this is done from within BASIC, my guess is that the active scan is causing some type of error. Try this; after the scan has verified that the data item does NOT exist, close and reopen the data file, THEN attempt your write (yes I know that this may invalidate the notion that the record does not exist). This would test to see if the active scan of the T25 file is interfering with the low level write, as the close of the data file would automatically terminate the scan (there is no other way from within BASIC). I wrote the code for bscan back in 1992 so I don't recall all different interactions involved, but it could be a long-standing bug that never appeared or not reported. In any case, if you could try that, I'd be interested in the results. At 12:11 PM 02/17/2004, you wrote: No, the value does not get written to the type 25 file. The data is not pre-existing. The BSCAN is done to verify this fact before attempting the write. Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, February 17, 2004 9:00 AM To: [EMAIL PROTECTED] Subject: RE: UV write fatal error Does the data value actually get inserted into the type 25 file if you check after the write fails? Also, is the data pre-existing within the type 25 file and this is an update to that record? Sounds almost like a memory allocation or rotating file pool problem. The on error branch (actually ANY branch) would only be followed if the run-machine wasn't crashing underneath you, which, if you are being dropped back to the command prompt, is happening. At 11:33 AM 02/17/2004, you wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, February 13, 2004 12:13 PM To: [EMAIL PROTECTED] Subject: RE: UV write fatal error Permissions? All the preceding steps (Open, BSCAN) can be done without write permission. Write, needless to add, cannot. -Original Message- From: Jimi DeRouen [mailto:[EMAIL PROTECTED] I am attempting to write a record to a type 25 file and apparently getting a fatal error. The platform is UV 9.5.1.1b Pick flavor on W2K SP4. I have constructed the WRITE statement to include all possible (I think) branching, yet the program goes to the command prompt when the WRITE is executed without following any of the branches. The WRITE statement is as follows: [SNIP] I have no problem writing other values. It is only this particular data value that seems to produce the error. Why wouldn't the program follow the on error branch? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[ADMIN] Net Nanny filter
Not only did I get flooded with with McAfee content filter bounce messages, but I am getting reports from posters to the list that they received profanity and sex rejections from the offending (offended?) domain. Some of these are for posts that went out days ago. I suspect some postmaster hasn't figured out his/her config file yet. The perpetrator has been unsubscribed. For reference, I am the only content filter server-side on the list grin. So if you ever get one of these Net Nanny messages, it came from a subscriber. Please forward it to me at [EMAIL PROTECTED] teasing Now y'all clean up your language and stop posting those dirty pictures to the list, hear? /teasing -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Swap array values? In UV
Within BASIC, try array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); It only works with integers. Other real numbers and strings won't work. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Need/Want/Would like to know
I'm on UV 10 and got the same results. George -Original Message- From: Mike Rajkowski [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, February 17, 2004 12:17 PM To: U2 Users Discussion List Subject: Need/Want/Would like to know Someone came to me with the following code sample, and asked why this would happen, while I have some thoughts, I would like a more definitive answer (note no matter what the answer, I believe the solution is don't do that) Thanks, Mike On Universe 9.5: 04 ED BP P1 P2 SELECTed record name = P1. 6 lines long. : P 0001: * 0002: DIM X(100) 0003: MAT X = 0004: X(100) = 1 0005: CALL P2(X(100), MAT X) 0006: END Bottom at line 6. : EX SELECTed record name = P2. 13 lines long. : P 0001: SUBROUTINE P2(A, MAT X) 0002: DIM X(100) 0003: CRT 'A = ':A 0004: CRT 'X(100) = ':X(100) 0005: * 0006: CRT ; CRT SETTING X(100) = A 0007: X(100) = A 0008: CRT ; CRT NOW RE-CHECKING THE VALUES 0009: * 0010: CRT 'A = ':A 0011: CRT 'X(100) = ':X(100) 0012: RETURN 0013: END Bottom at line 13. : EX File name= BP Record name = RUN BP P1 A = 1 X(100) = 1 SETTING X(100) = A NOW RE-CHECKING THE VALUES A = Program P2: Line 10, Variable A previously undefined. Empty string used . X(100) = Program P2: Line 11, Variable $R0 previously undefined. Empty stri ng used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] Net Nanny filter
It was that XOR post. Guess it really was nasty! George -Original Message- From: Moderator [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, February 17, 2004 1:46 PM To: U2 Users Discussion List Subject: [ADMIN] Net Nanny filter Not only did I get flooded with with McAfee content filter bounce messages, but I am getting reports from posters to the list that they received profanity and sex rejections from the offending (offended?) domain. Some of these are for posts that went out days ago. I suspect some postmaster hasn't figured out his/her config file yet. The perpetrator has been unsubscribed. For reference, I am the only content filter server-side on the list grin. So if you ever get one of these Net Nanny messages, it came from a subscriber. Please forward it to me at [EMAIL PROTECTED] teasing Now y'all clean up your language and stop posting those dirty pictures to the list, hear? /teasing -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - NLS
The shared segment key is 0xaceea000 for version 10.x for any x. The xMEMOFF parameters are tuneable in DataStage, but not in UniVerse. You may have to ask IBM support to escalate this to ATS (advanced technical support) where someone like Leroy (sometime participant here) will be able to look at it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Need/Want/Would like to know
It works fine on UDT 6 on AIX - I know that UDT passes by reference if that helps -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Tuesday, February 17, 2004 1:36 PM To: 'U2 Users Discussion List' Subject: RE: Need/Want/Would like to know I'm on UV 10 and got the same results. George -Original Message- From: Mike Rajkowski [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, February 17, 2004 12:17 PM To: U2 Users Discussion List Subject: Need/Want/Would like to know Someone came to me with the following code sample, and asked why this would happen, while I have some thoughts, I would like a more definitive answer (note no matter what the answer, I believe the solution is don't do that) Thanks, Mike On Universe 9.5: 04 ED BP P1 P2 SELECTed record name = P1. 6 lines long. : P 0001: * 0002: DIM X(100) 0003: MAT X = 0004: X(100) = 1 0005: CALL P2(X(100), MAT X) 0006: END Bottom at line 6. : EX SELECTed record name = P2. 13 lines long. : P 0001: SUBROUTINE P2(A, MAT X) 0002: DIM X(100) 0003: CRT 'A = ':A 0004: CRT 'X(100) = ':X(100) 0005: * 0006: CRT ; CRT SETTING X(100) = A 0007: X(100) = A 0008: CRT ; CRT NOW RE-CHECKING THE VALUES 0009: * 0010: CRT 'A = ':A 0011: CRT 'X(100) = ':X(100) 0012: RETURN 0013: END Bottom at line 13. : EX File name= BP Record name = RUN BP P1 A = 1 X(100) = 1 SETTING X(100) = A NOW RE-CHECKING THE VALUES A = Program P2: Line 10, Variable A previously undefined. Empty string used . X(100) = Program P2: Line 11, Variable $R0 previously undefined. Empty stri ng used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Need/Want/Would like to know
It's because the underlaying function first free's off the memory of X(100) before storing the value of A into it. Problem is, the contents for A actually reside in the just free'd up memory location for X(100), hence you are trying to store something that was previously defined in that location BACK into the same location. No can do. Glenn At 01:36 PM 02/17/2004, you wrote: I'm on UV 10 and got the same results. George -Original Message- From: Mike Rajkowski [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, February 17, 2004 12:17 PM To: U2 Users Discussion List Subject: Need/Want/Would like to know Someone came to me with the following code sample, and asked why this would happen, while I have some thoughts, I would like a more definitive answer (note no matter what the answer, I believe the solution is don't do that) Thanks, Mike On Universe 9.5: 04 ED BP P1 P2 SELECTed record name = P1. 6 lines long. : P 0001: * 0002: DIM X(100) 0003: MAT X = 0004: X(100) = 1 0005: CALL P2(X(100), MAT X) 0006: END Bottom at line 6. : EX SELECTed record name = P2. 13 lines long. : P 0001: SUBROUTINE P2(A, MAT X) 0002: DIM X(100) 0003: CRT 'A = ':A 0004: CRT 'X(100) = ':X(100) 0005: * 0006: CRT ; CRT SETTING X(100) = A 0007: X(100) = A 0008: CRT ; CRT NOW RE-CHECKING THE VALUES 0009: * 0010: CRT 'A = ':A 0011: CRT 'X(100) = ':X(100) 0012: RETURN 0013: END Bottom at line 13. : EX File name= BP Record name = RUN BP P1 A = 1 X(100) = 1 SETTING X(100) = A NOW RE-CHECKING THE VALUES A = Program P2: Line 10, Variable A previously undefined. Empty string used . X(100) = Program P2: Line 11, Variable $R0 previously undefined. Empty stri ng used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - NLS
Thanks to all - I will pass this along to Ibm support. Hopefully this will bring some light to the day. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, February 17, 2004 2:55 PM To: U2 Users Discussion List Subject: RE: UV - NLS The shared segment key is 0xaceea000 for version 10.x for any x. The xMEMOFF parameters are tuneable in DataStage, but not in UniVerse. You may have to ask IBM support to escalate this to ATS (advanced technical support) where someone like Leroy (sometime participant here) will be able to look at it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Need/Want/Would like to know
Hello, Mike. I added a print X(100) following the Call in P1 and that fails too. I suppose that the X(100) element is being cleared before the assignment of A. However, as A is a pointer to X(100), both become cleared. Perhaps the move_matrix op-code should test if the r-value (e.g. A) resolves to the same l-value element (e.g. X(100)) and treat the statement as a no-op in such cases. One can short-circuit the problem by adding an intermediate variable, such as, C = A; X(100) = C, in P2. Interesting puzzle. I wonder if there is a GTAR on this? Best regards, Gyle -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Rajkowski Sent: Tuesday, February 17, 2004 9:17 AM To: U2 Users Discussion List Subject: Need/Want/Would like to know Someone came to me with the following code sample, and asked why this would happen, while I have some thoughts, I would like a more definitive answer (note no matter what the answer, I believe the solution is don't do that) Thanks, Mike On Universe 9.5: 04 ED BP P1 P2 SELECTed record name = P1. 6 lines long. : P 0001: * 0002: DIM X(100) 0003: MAT X = 0004: X(100) = 1 0005: CALL P2(X(100), MAT X) 0006: END Bottom at line 6. : EX SELECTed record name = P2. 13 lines long. : P 0001: SUBROUTINE P2(A, MAT X) 0002: DIM X(100) 0003: CRT 'A = ':A 0004: CRT 'X(100) = ':X(100) 0005: * 0006: CRT ; CRT SETTING X(100) = A 0007: X(100) = A 0008: CRT ; CRT NOW RE-CHECKING THE VALUES 0009: * 0010: CRT 'A = ':A 0011: CRT 'X(100) = ':X(100) 0012: RETURN 0013: END Bottom at line 13. : EX File name= BP Record name = RUN BP P1 A = 1 X(100) = 1 SETTING X(100) = A NOW RE-CHECKING THE VALUES A = Program P2: Line 10, Variable A previously undefined. Empty string used . X(100) = Program P2: Line 11, Variable $R0 previously undefined. Empty stri ng used. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Enabling ODBC for non-SQL file
Anthony Youngman wrote: Did you run HS.UPDATE.FILEINFO? Have you put the correct SQL type definitions in fields 8? Did HS.UPDATE.FILEINFO actually work correctly! THAT'S A BIGGIE! I've shoved a little article on pickwiki you might want to look at - multivaluedatabasesuniverseodbcaccess Cheers, Wol Thanks for pointing me to the pickwiki. That was a lot easier to follow than the UV documentation. I made sure the correct SQL types were in attr. 8 of all the dict items. I had previously cleared the entire dict and put in only the things I needed (I copied the live file to a separate ODBC-only account), so I only have a handful to worry about. I also manually added the file to HS_FILE_ACCESS. I used the verbose version of HS.UPDATE.FILEINFO from the wicki and there were no complaints about this particular file. Still can't get this file to be seen though. HS.SCRUB does give an error message on all the I-type dict items and I'm not sure exactly what it's telling me. I get this message: CUST.CITY was analyzed using VARCHAR(254) for a data type * Invalid conversion code ' '. And here's the I-type: 0001: I 0002: TRANS(CR,@ID[8,8],21,X) 0003: 0004: CITY 0005: 20L 0006: S 0007: 0008: VARCHAR The I-type is referencing a file that's a Q-pointer to a non-SQL file in another account. All the other I-types it complains about point to the same file. The only other potential problem I can think of is since I'm using a stripped down version of the actual dict, there are attributes in the data portion that now have no corresponding dict entry. Could this be a problem? Thanks, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Unidata ODBC initial setup error - Run out of ideas!!!
If you have trouble getting an upgrade CD from your vendor you can download the Client CD from the IBM website under the Personal Edition. https://www-927.ibm.com/software/data/u2/support/u2techconnect/udt6pe.asp I don't think there is any difference on the client side... hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Dave Tabor [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 12:11 PM To: U2 Users Discussion List Subject: RE: Unidata ODBC initial setup error - Run out of ideas!!! Hi, Thanks for the suggestions. Here's what I've found. I've got the Unidata ODBC driver version number 3.01.04.7013, so it's a little earlier than you mentioned. I also tried setting up a .dsn file as you mentioned, and that didn't seem to work either. Is there a way to download a 'Service Pack' for this, or do I need to obtain an upgrade CD from our VAR? Any other ideas? Thanks, Dave -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: STILL HANGING
Just as another data point, I have problems with both XP Pro and XP Home with a process locking up the CPU at 99% and freezing the system, and I do not have UV installed on either of these machines. So you might be looking at a Windows XP issue. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Ron White wrote: I have a development machine running UniVerse on WinXP PRO. snip/ While this may not have anything to do with your problem, it is one more thing you can check. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV - NLS
Also, check that no existing 0xACEE segment exists (i'm sure this has been done). I have frequently found that I have needed to stop UniVerse two or three times before doing a uvregen inorder for it to work. Also try nls.stamp just before the uvregen and see if that makes a difference. Regards, T. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING
Susan, Curious, I find the reverse to be true. Since I usually read in threads, I find that having to scroll through the last part to get to the current part mildly annoying. The information flow problem is that messages, especially email, don't always arrive and sort threaded. This is problem is further compounded because somebody could reply today to a message that was deleted from your Inbox or expired from your news server days or even weeks ago. Without interposting, you have no idea where the reply fits into the thread. If you are a reader that typically reads through an entire thread, when it's essentially dead, and don't mind the occasional reply that's out of place because somebody has their clock out of sync, or the time zone set incorrectly, then that's fine for you. But top-posting still makes things more difficult for just about everybody else. The byte flow problem, is the one that directly affects Cliff and the digests. Unfortunately, 99.% of Top-Posters neglect to trim the quoted message to the relevant material. That wastes huge amounts of bandwidth. Another thing to remember here, is that Usenet and email are international, and that the US is pretty much the only place where almost everybody can get internet access without per-byte or per-minute charges. Please note I typed almost everybody -- There are still places in the US where there are no local access numbers and people have to pay per-minute line charges in order to access their unlimited internet accounts. There really are no valid reasons to top-post, but there are plenty of valid reasons to inter-post and trim the quoted material. That's why it's been a flameable action on Usenet for over twenty years. Top-posting has only become more common in recent years because OE and a few other email/newsreader hybrids (that really don't do either well) make it tough to reply correctly and newbies are showing up everyday, not just in the first couple of weeks in September. Insisting on top-posting and not trimming the quoted material, especially when there's replies that have already been right-posted (aka inter-posted), I hate to say it, is just plain rude and self serving. Please take a moment and read the material listed in the two links previously provided. If you missed them, here they are again: http://www.netmeister.org/news/learn2quote.html http://www.greenend.org.uk/rjk/2000/06/14/quoting Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)| .=. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] The aforementioned and promised NAG about OVERQUOTING
While I have seen the aversion to MS products on this list, I do like the way Outlook allows me to sort by subject then by received date/time. It is smart enough to handle the replies as part of a subject flow. Usually most of the threads are in blocks in the intray. I don't know if other products allow this. The sorting does go astray when someone changes the subject - so please restrain yourselves. My 2¢ Jef Lee IT Vision Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153 Tel: (08) 9315 7000 Fax: (08) 9315 7088 P O Box 881, Canning Bridge, WA 6153 A.C.N. 068 914 867 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray DeGennaro at Eaglerock IS Sent: Wednesday, February 18, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING Susan, Curious, I find the reverse to be true. Since I usually read in threads, I find that having to scroll through the last part to get to the current part mildly annoying. The information flow problem is that messages, especially email, don't always arrive and sort threaded. This is problem is further compounded because somebody could reply today to a message that was deleted from your Inbox or expired from your news server days or even weeks ago. Without interposting, you have no idea where the reply fits into the thread. If you are a reader that typically reads through an entire thread, when it's essentially dead, and don't mind the occasional reply that's out of place because somebody has their clock out of sync, or the time zone set incorrectly, then that's fine for you. But top-posting still makes things more difficult for just about everybody else. The byte flow problem, is the one that directly affects Cliff and the digests. Unfortunately, 99.% of Top-Posters neglect to trim the quoted message to the relevant material. That wastes huge amounts of bandwidth. Another thing to remember here, is that Usenet and email are international, and that the US is pretty much the only place where almost everybody can get internet access without per-byte or per-minute charges. Please note I typed almost everybody -- There are still places in the US where there are no local access numbers and people have to pay per-minute line charges in order to access their unlimited internet accounts. There really are no valid reasons to top-post, but there are plenty of valid reasons to inter-post and trim the quoted material. That's why it's been a flameable action on Usenet for over twenty years. Top-posting has only become more common in recent years because OE and a few other email/newsreader hybrids (that really don't do either well) make it tough to reply correctly and newbies are showing up everyday, not just in the first couple of weeks in September. Insisting on top-posting and not trimming the quoted material, especially when there's replies that have already been right-posted (aka inter-posted), I hate to say it, is just plain rude and self serving. Please take a moment and read the material listed in the two links previously provided. If you missed them, here they are again: http://www.netmeister.org/news/learn2quote.html http://www.greenend.org.uk/rjk/2000/06/14/quoting Ray -- .=. | =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= | | -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- | | http://www.eriscorp.commailto:[EMAIL PROTECTED] | |Midwest Regional Office: 815-547-0662 (voice) 503-905-8153 (eFax)| .=. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[OT] RE: Top / Bottom posting, was: The aforementioned and promised NAG about OVERQUOTING
Jef Lee [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: While I have seen the aversion to MS products on this list, I do like the way Outlook allows me to sort by subject then by received date/time. It is smart enough to handle the replies as part of a subject flow. That doesn't change the fact that Mocrslops refusal to follow established standards make it nearly impossible for their *experienced* to follow those same standards. Add millions of new users every month and Micro$lop has managed to totally destroy the standard. That leads to the mentioned aversion. Usually most of the threads are in blocks in the intray. I don't know if other products allow this. There are many email and newsreaders that have allowed threading for much longer than OE. Some do it much better. Of course, when OE comes free on every desktop more and more of the alternatives are going away. More reason for the adversion The sorting does go astray when someone changes the subject - so please restrain yourselves. But what do we do when the thread a) goes *totally* off-topic or b) changes to a new subject? Convention has always been that the subject should reflect the content, and that there should be a way for the reader to filter out the OT messages. As much as I would like to see you be able to use OE to the fullest, it is more important to me that I follow 20 year old established conventions. My 2¢ My 2¢ would be that even more important than posting your response directly after the text you are replying to would be to remove extra text. Because you failed to do that those that read the digest will be forced to wade through Ray's post all over again. While it was a high quality post, full of vim and vigor, one reading should be enough for the slowest of us. I don't really care whether you follow the convention or not, but please, *please*, **please**, trim your posts so the digesters can get the full value from the list! -- ~ kevin zollinger [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How you grow journal entry limitation
THANKS We have decided to stop the journal during the migration carlos -Original Message- From: Timothy Snyder [mailto:[EMAIL PROTECTED] Sent: mardi, 17. février 2004 16:43 To: U2 Users Discussion List Subject: Re: How you grow journal entry limitation we runing UniVerse 9.5.2 r11 OS Tru64 5.1a for a merge off two database, we must input more than 31888 records par day, the problem is the journal have a limitation to 15000 ~ records, It is possible to grow this limitation I'm not clear as to the exact problem. Are you saying there's a UniVerse hashed file called journal that is not large enough for the number of records it needs to support? If so, it will have to be resized, perhaps changing it to a dynamic file. Or is the journal something else? If you can clarify this, we can try to offer specific solutions. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system.E FG is not responsible for, nor endorses, any opinion, recommendation, conclusion, solicitation, offer or agreement or any information contained in this communication. EFG cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender. Should you require any further information, please contact the Compliance Manager on [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users