RE: [U2] [UV] RAID debugger
That's the one I was looking for! Thanks very much Stuart. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: 02 February 2005 22:17 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] RAID debugger Mike, The line numbers get messed up in RAID if you have an inline comment after the include. This buggers the line numbers $INCLUDE ARINCLUDE AR.MASTER ;*In line comment and this doesn't $INCLUDE ARINCLUDE AR.MASTER Get rid of the in line comment and the line numbers will be correct. Regards, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Farrant Sent: Thursday, 3 February 2005 1:28 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] RAID debugger Talking of debuggers, can anyone remind me how the $INCLUDE s can mess up the line numbers displayed within the RAID debugger. I had a solution to this once which I seem to remember had something to do with the configuration or placement of the $INCLUDE lines in the source code. I look forward to any response Thanks Mike Farrant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] RAID debugger
Does everyone find upgrading so easy? Personally, I find to upgrade a system supporting over 1000 users world-wide quite a daunting task and not a decision that can be taken lightly. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: 02 February 2005 23:06 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] RAID debugger Upgrade to the most current release for your platform and you'll find that is no longer a problem. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Mitchell, Stewart Stewart.Mitchell To @au.faulding.com 'u2-users@listserver.u2ug.org' Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] [UV] RAID debugger 02/02/2005 03:17 PM Please respond to [EMAIL PROTECTED] er.u2ug.org Mike, The line numbers get messed up in RAID if you have an inline comment after the include. This buggers the line numbers $INCLUDE ARINCLUDE AR.MASTER ;*In line comment and this doesn't $INCLUDE ARINCLUDE AR.MASTER Get rid of the in line comment and the line numbers will be correct. Regards, Stewart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Farrant Sent: Thursday, 3 February 2005 1:28 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] RAID debugger Talking of debuggers, can anyone remind me how the $INCLUDE s can mess up the line numbers displayed within the RAID debugger. I had a solution to this once which I seem to remember had something to do with the configuration or placement of the $INCLUDE lines in the source code. I look forward to any response Thanks Mike Farrant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic10855.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] RAID debugger
I think if I were supporting that many users, I'd want to insure the system had the most reliable code base I could. Does not mean you do every upgrade, but it does requrie an effort to stay fairly current. With that many users, you probably have a test environment where upgrades could be evaluated prior to rollout to the live system. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SBClient cannot connect to SB+ on UV/AIX
David, Its usually just that you have to upgrade SB+ at the same time. The message is saying that you have to be on a newer SBClient but it just can't do math. I believe its telling you that you need to be on a newer SB+ to go with your new SBClient. You can't rarely upgrade one without the other. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Query about UniVerse database
Hello ppl How do i configure the arrow keys on the keyboard such that they move in their respective directions. I am talking relating to the Universe database. - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query about UniVerse database
Keyboard on PC or Dumb terminal? If PC what emulator are you using? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Avinash Sent: 04 February 2005 12:46 To: u2-users@listserver.u2ug.org Subject: [U2] Query about UniVerse database Hello ppl How do i configure the arrow keys on the keyboard such that they move in their respective directions. I am talking relating to the Universe database. - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] examples of X[n], X[m,n], X[c,m,n] substring extractions and assignments
Charles Stevenson wrote on 3 Feb 2005 at 23:16:59 -0500: I wrote these examples up for our own programmers. Might as well share them with the group for the newbies' sakes. A caution: these apply to UniVerse. UniData doesn't support the third syntax (X[c,m,n]). Also, UniData may give different results, based on BASICTYPE and the Null Value Handling settings. In BASICTYPE U, it should work as Charles stated. In BASICTYPE M and P (we are always set with P, as we use SB+), the string can be reduced or cleared on assignments. According to the help, if Null Value Handling is on, the X[3] syntax will give a warning, and a zero will be used. I don't know if it will make it X[3,0] or X[0,3], however. I put all of Charles' examples in a program and got the following results (using * before and after the string to show the lack of spaces...) X: *AB-CD-EF-GH* X[3]: *-GH* X[2,3]: *B-C* X[2,1] = 1: *A1-CD-EF-GH* X[2,3] = 123: *A123D-EF-GH* X[3] = 123: *AB-CD-EF123* X[2,1] = 123: *A123-CD-EF-GH* X[2,3] = 12: *A12D-EF-GH* X[3] = 12:*AB-CD-EF12* X[3] = : *AB-CD-EF* So, remember, your mileage may vary :- --Tom Pellitieri --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe CREATE SCHEMA
One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. TypeGRANT ALL TO PUBLIC (I think I got the syntax right). If you want to limit some people create an SQL user for them and set more limited permissions. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, February 04, 2005 1:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You need to login as the administrator, which is the initial SQL User. Then GRANT Connect and then resources, etc to alternative users. Then you can logout and login under the new user and you will have SQL access rights. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 4 February 2005 10:14 AM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] RAID debugger
I have found Universe upgrades to be extremely clean. We upgrade our customers on a consistent basis and I've never had a real problem because of it. Now application upgrades those can be a little dicier ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donald Kibbey Sent: Friday, February 04, 2005 7:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] RAID debugger I think if I were supporting that many users, I'd want to insure the system had the most reliable code base I could. Does not mean you do every upgrade, but it does requrie an effort to stay fairly current. With that many users, you probably have a test environment where upgrades could be evaluated prior to rollout to the live system. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett Dunner LLP --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the Inbound TSH Mail Filter Please Report any issues to [EMAIL PROTECTED] __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Memory cannot be written to
Anyone seen a message on Windows 2003 servers when the services are started :- The instruction at 0x00144590d referenced memory at 0x0246. The memory could not be written to. thanks Graham Hansen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe CREATE SCHEMA
List UV_USERS to find the initially configured administrator user. On our system it is uvsql. I'm not sure if that is a standard or something that we setup. At any rate, if you haven't done anything with SQL, there should only be one user in there, but you are looking for someone with DBAuth privelege. Once logged in as this user, you should be able to grant CONNECT to whoever. See the Universe SQL reference (under the GRANT command) for details on priveleges required for different operations. Bob Woodward wrote: Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [This E-mail scanned for viruses by Declude Virus] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] [UD]: examples of X[n], X[m,n], X[c,m,n] substring extractions and assignments
Thank-you, Tom. I was hoping someone would be kind enough to speak up about Unidata. Does UD (as does UV) support these alternate syntaxes?: []-Syntax. Alternate Y = X[c,m,n]Y = FIELD( X, c,n,m ) X[c,m,n] = substringX = FIELDSTORE( X, c,m,n, substring ) (and, while we're at it:) Y = X[n]Y = RIGHT( X, n ) Y = X[1,n] Y = LEFT( X, n ) functionbally equivalent __ Notice how UV's VLIST shows these compilations. They all compile exactly the same except the last one: Y = X[c,m,n] 00024 : 084 field X c m n = Y Y = FIELD( X, c,m,n ) 00030 : 084 field X c m n = Y X[c,m,n] = substring 0003C : 086 fieldstore X c m n substring = X X = FIELDSTORE(X,c,m,n,substring) 0004A : 086 fieldstore X c m n substring = X Y = X[n] 00058 : 164 right X n = Y Y = RIGHT( X, n ) 00060 : 164 right X n = Y Y = X[1,n] 00068 : 0F0 midX 1 n = Y Y = LEFT( X, n ) 00072 : 286 left X n = Y _ cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe CREATE SCHEMA
Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query about UniVerse database
What are you using to connect to the UV database? What is it you're seeing that they are not moving in the respective direction? Has your terminal definition file been modified? Check your ...\uv\terminfo\v directory and see if any of the files have a different modification date. In particular, look at the vt220 file. In our case, we had a modification to our vt100 file to fix the numeric keypad's ability to switch to numeric values when the NumLock key is on. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Avinash Sent: Friday, February 04, 2005 4:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] Query about UniVerse database Hello ppl How do i configure the arrow keys on the keyboard such that they move in their respective directions. I am talking relating to the Universe database. - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query about UniVerse database
Hello Sir, Thanks for your suggestions..Well, I am using a secured shell here. I checked out the modification dates as you said, but they are all the same. Well, I am also unable to open the vt220 file. What do i need to open the file of that type? I gave use the web service to open this type of file but it dint give me anything. Thanks, Avinash - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe CREATE SCHEMA
Thanks to those that replied. I'd like to summarize the information and what I did. 1. While logged in to UV as my regular ID, I did a LIST UV_USERS which told me that the system was, in fact, installed by the Administrator user. 2. I logged out of UV then back in as the HWGDOM\administrator user and did a LOGTO UV. 3. Next I typed the following commands: GRANT CONNECT TO HWGDOM\bobw GRANT DBA TO HWGDOM\bobw 4. I logged out of UV then back in as my normal user id, bobw. 5. From my application account I was able to successfully issue the CREATE SCHEMA command. Again, thanks for you help, folks! BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, February 03, 2005 3:14 PM To: U2-Users List Subject: [U2] Universe CREATE SCHEMA Hi folks. I'm trying to get my feet wet with SQL and I've got what seems like a simple question to ask but one that is proving to be rather difficult to find an answer to. I'm wanting to issue a CREATE SCHEMA command but when I do I get an error message that I'm not an SQL user. How do I go about setting myself up as an SQL user? I'm logged into our domain and my UID is in the Administrators group so I should have rights to just about everything. The environment is Win2003 server, UV 10.1.3. I've searched FAQ's, PDF's, DOC's, websites, Google and still am having no luck finding anything that tells me how to set myself up as an SQL user. Any direction would be greatly appreciated. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] POS for Pizza Restaurant
Is that $1000 before or AFTER you pay for the DBMS (assuming they aren't using the 2 user freebie) Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Gerrish Sent: Friday, 4 February 2005 2:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] POS for Pizza Restaurant Anyone out there know of any reasonably priced (under $1000) POS systems in UniVerse (or mv in general) that would work for a Limited Service Pizza Restaurant that does delivery? I have a client with a limited budget that needs something. Thanks Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe CREATE SCHEMA
You are correct. I made an assumption regarding what he was doing. I know, I know assuming anything is not great practice. I humbly beg forgiveness from the group :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 04, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe CREATE SCHEMA Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] POS for Pizza Restaurant
Paragon Software has pizza in pick = [EMAIL PROTECTED] as far as free MV try ladybridge open systems! D Raven cell (949)2282224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- Ross Ferris [EMAIL PROTECTED] wrote: Is that $1000 before or AFTER you pay for the DBMS (assuming they aren't using the 2 user freebie) Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Gerrish Sent: Friday, 4 February 2005 2:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] POS for Pizza Restaurant Anyone out there know of any reasonably priced (under $1000) POS systems in UniVerse (or mv in general) that would work for a Limited Service Pizza Restaurant that does delivery? I have a client with a limited budget that needs something. Thanks Bob Gerrish - [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 3/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query about UniVerse database
Hi Avinash. If the terminal definition files are unmodified then changing them probably won't help you. If you are interested then look into the uvtic.exe and uvtidc.exe programs in the .../uv/bin directory. Everything in the .../uv/terminfo/* directories are the compiled information files and I would suggest, strongly, that make sure you have a saved copy of the current files before doing anything. Where are you seeing the problem? In the editor? At the TCL prompt? Bob W -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Avinash Sent: Friday, February 04, 2005 9:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Query about UniVerse database Hello Sir, Thanks for your suggestions..Well, I am using a secured shell here. I checked out the modification dates as you said, but they are all the same. Well, I am also unable to open the vt220 file. What do i need to open the file of that type? I gave use the web service to open this type of file but it dint give me anything. Thanks, Avinash - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe CREATE SCHEMA
So if I have an account and want to access the data from my SQLPLAY account, how do I set this up so I can use SQL in SQLPLAY but not change the other accounts access? Can I create VOC entries that point to the same DATA files but have different DICT's? Is that enough? -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Friday, February 04, 2005 10:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You are correct. I made an assumption regarding what he was doing. I know, I know assuming anything is not great practice. I humbly beg forgiveness from the group :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 04, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe CREATE SCHEMA Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Running a stored procedure from Excel
I have a co-worker that is trying to get a stored procedure to run from Excel via an ODBC connection. What he is trying to do is have a routine that will regenerate some data whenever this query is run or the refresh button is clicked. This is a straight ODBC connection run against UniData Any help would be appreciated. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata core dumps
We're a Datatel client also, and have the same problem. It seems to happen most often when do UniQuery stuff with i-descriptors, especially i-descriptors that call subroutines (not necessarily Datatel subroutines, sometimes the UniData subroutines that are meant to be used in i-descriptors) and/or are multi-valued and/or are in a file with an especially large dictionary with lots of large associations. Unfortunately I have never been able to come up with a specific sequence that causes it to happen. It happened to me about four times yesterday (doing repeated queries on the EMPLOYES file), after going for months (if not more than a year) without it happening to me personally. At 11:08 AM 02/03/05, you wrote: Is anyone experiencing sporadic core dumps and have any suggestions to eliminate them? I'm running Unidata 6.0.3 on HPUX 11.11. The hardware is an RP5470 (2 cpus, 6GB memory). The application software is Datatel's Colleague and Benefactor. I have only indirect support from IBM for Unidata (I have to call Datatel for support). Datatel first indicates that it may be old compiled code. I find it all, and recompile and catalog (if needed) all our custom. Recompiled every I-descriptor. Still get dumps. Datatel then indicates that it might be level 2 overflow in the files. I've memresize-d the files and dicts and now udtmon shows no level-2 activity. Still got dumps, but not as frequently. Datatel then says it might be index overflows. I recreate the indexes with larger node sizes to eliminate overflow reads/writes. Now there is none. Still get the occasional dump. Datatel then says it must be hardware. There are no errors logged. I know hardware monitoring is working since I was getting single-bit errors reported 6 months ago and replaced affected memory, and a raid drive failure 9 months ago. Last Thursday, I have a rash of failures of unidata in a 20 minute period. I've got dumps of some of the processes. Not all udt processes were affected. No hardware events recorded. Of the dumps I looked at the top of the stack was: U_free_varmem(4012EFC0) from U_freevar+0xA4 (or similar). I did reboot the machine, no problems. Guide is run nightly on all accounts and their files using Datatel's WUFA process. There are no broken files reported and no overflow2 statuses. Last night I find a powerpoint presentation Problem Determination Techniques for Diagnosing UniData Database and System Issues by Wally Terhune at the IBM DB2 Info. Mgmt. Technical Conference, Sept 20-24, 2004. There is a page that says Working with Unix core files...UniData engineering likely at fault I am beginning to believe that I'm just spinning my wheels. Having come from Prime Information, piopen, and universe environments where a dump/failure meant you have a problem, these occasional dumps are frustrating. Does anyone have any ideas? Mike Cannady Computing Services Campbell University PO Box 164 Buies Creek, NC 27506 [EMAIL PROTECTED] (910) 893-1204 +--+ | There is no place like 127.0.0.1 (aka ::1)! | +--+ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Kathy Tymoczko Information Technology Services Wabash College, Crawfordsville, Indiana 47933 [EMAIL PROTECTED] 765-361-6440 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata core dumps
I used to experience lots of core dumps on UV 8 and 9 (DG/ux) when running TCL selects/sorts that had I-descriptors. I think it was someone on this list that suggested we look to see if the I-desc's had COMMON blocks in them. Sure enough, they did. We removed the COMMON blocks, recompiled the I-descriptors, and had no further problems. Not sure if UD, or UV10 for that matter, have that glitch, but it might be worth a look... --Ron P. -Original Message- At 11:08 AM 02/03/05, you wrote: Is anyone experiencing sporadic core dumps and have any suggestions to eliminate them? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Running a stored procedure from Excel
To start with be sure they have a good working odbc connection to uniVerse (just checking ..) Next .. the 'Basic Sql Client Interface Guide' has some great info on running a procedure .. Where is it not working? DSig David Tod Sigafoos -Original Message- From: Richard Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Fri, 4 Feb 2005 14:38:42 -0500 Subject: [U2] Running a stored procedure from Excel I have a co-worker that is trying to get a stored procedure to run from Excel via an ODBC connection. What he is trying to do is have a routine that will regenerate some data whenever this query is run or the refresh button is clicked. This is a straight ODBC connection run against UniData Any help would be appreciated. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata core dumps
IF you run the debug versions of Unidata, Unidata techs can read the core dumps and make sense of what is in them. They are found in the bin directory: cleanupd.d cm.d kp.d lib.d restart.d sm.d smm.d systest.d tm.d udt.d Note the size of udt.d is much larger than udt, as it has a symbol table. This size difference helps figure out what version you rally are looking at. This size difference should be noted for all of the above. The debug do not have the symbol tables stripped out of the object code. So the dump will have variable's that can be deciphered. What I did to run these was, backup the original versions, and rename the debug versions the normal name. i.e.: cp udt to udt.orig cp cm to cm.orig . etc Then I copied udt.d to udt cm.d to cm ... etc Now if you stop and restart Unidata, it will be running with the debug versions. To go back, copy the udt.orig to udt etc. The possible downside is that Unidata may run a little slower with the debug versions. But it is the only way for anybody to make sense of the core dumps. This did help us eventually find a problem that was causing core dumps. But I can't remember what the problem was. - Rod -Original Message- From: Kathy Tymoczko [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 2:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata core dumps We're a Datatel client also, and have the same problem. It seems to happen most often when do UniQuery stuff with i-descriptors, especially i-descriptors that call subroutines (not necessarily Datatel subroutines, sometimes the UniData subroutines that are meant to be used in i-descriptors) and/or are multi-valued and/or are in a file with an especially large dictionary with lots of large associations. Unfortunately I have never been able to come up with a specific sequence that causes it to happen. It happened to me about four times yesterday (doing repeated queries on the EMPLOYES file), after going for months (if not more than a year) without it happening to me personally. At 11:08 AM 02/03/05, you wrote: Is anyone experiencing sporadic core dumps and have any suggestions to eliminate them? I'm running Unidata 6.0.3 on HPUX 11.11. The hardware is an RP5470 (2 cpus, 6GB memory). The application software is Datatel's Colleague and Benefactor. I have only indirect support from IBM for Unidata (I have to call Datatel for support). Datatel first indicates that it may be old compiled code. I find it all, and recompile and catalog (if needed) all our custom. Recompiled every I-descriptor. Still get dumps. Datatel then indicates that it might be level 2 overflow in the files. I've memresize-d the files and dicts and now udtmon shows no level-2 activity. Still got dumps, but not as frequently. Datatel then says it might be index overflows. I recreate the indexes with larger node sizes to eliminate overflow reads/writes. Now there is none. Still get the occasional dump. Datatel then says it must be hardware. There are no errors logged. I know hardware monitoring is working since I was getting single-bit errors reported 6 months ago and replaced affected memory, and a raid drive failure 9 months ago. Last Thursday, I have a rash of failures of unidata in a 20 minute period. I've got dumps of some of the processes. Not all udt processes were affected. No hardware events recorded. Of the dumps I looked at the top of the stack was: U_free_varmem(4012EFC0) from U_freevar+0xA4 (or similar). I did reboot the machine, no problems. Guide is run nightly on all accounts and their files using Datatel's WUFA process. There are no broken files reported and no overflow2 statuses. Last night I find a powerpoint presentation Problem Determination Techniques for Diagnosing UniData Database and System Issues by Wally Terhune at the IBM DB2 Info. Mgmt. Technical Conference, Sept 20-24, 2004. There is a page that says Working with Unix core files...UniData engineering likely at fault I am beginning to believe that I'm just spinning my wheels. Having come from Prime Information, piopen, and universe environments where a dump/failure meant you have a problem, these occasional dumps are frustrating. Does anyone have any ideas? Mike Cannady Computing Services Campbell University PO Box 164 Buies Creek, NC 27506 [EMAIL PROTECTED] (910) 893-1204 +--+ | There is no place like 127.0.0.1 (aka ::1)! | +--+ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Kathy Tymoczko Information Technology Services Wabash College, Crawfordsville, Indiana 47933 [EMAIL PROTECTED] 765-361-6440 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users
RE: [U2] Universe CREATE SCHEMA
I had converted normal UV accounts to a schema for one client because it improved the access via ODBC/ADO. You could then access the data files externally as SQL tables or normally in UV. Just remember to grant 'public' sufficent access for the normal UV users to work. You can do SQL statements in a UV account without doing any of this as someone else suggested. -Original Message-- Now, if you are talking about *converting* the tables in question to SQL tables (which allows you to use constraints, but, as far as I can think of, that's the only benefit), you would probably want to make a complete copy of the data (or a subset adequate for testing/playing around with). Bob Woodward wrote: So if I have an account and want to access the data from my SQLPLAY account, how do I set this up so I can use SQL in SQLPLAY but not change the other accounts access? Can I create VOC entries that point to the same DATA files but have different DICT's? Is that enough? -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Friday, February 04, 2005 10:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe CREATE SCHEMA You are correct. I made an assumption regarding what he was doing. I know, I know assuming anything is not great practice. I humbly beg forgiveness from the group :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 04, 2005 11:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe CREATE SCHEMA Richard Taylor wrote: One other thing to watch out for is when you make an account into a Schema normal, non-sql users, will not have access to the files anymore. If you want to use the account as a Schema and as a regular UV account you can do so but you will need to grant permissions to the non-sql defined users. This is only true if you *convert* an account to a schema. Merely creating a schema on an account does *NOT* convert existing files to SQL tables. You will still be able to access your existing traditional Universe files as you always have. --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
I have never done this before so I'm likely making some horrible blunder. I have IIS running and I have a Universe database on top of Windows XP. I have a Hello page in HTML with a form and the submit action a name that I have in the same directory as the Hello page is in. So the hello page just looks something like this HTMLTITLEHELLO/TITLE BODYFORM SUBMIT=test/BODYHTML And the test item just looks like echo Hello which seems to work, although I have it created as a .bat file which is probably not right. But when I try to make it run a command like H:\IBM\UV\BIN\UV MYTESTPROGRAM It complains with a message that UNIRPC32.DLL can't be found in the paths ... and then it lists some paths. What is this telling me? And how do I fix it? Thanks Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
OK I did a search on my system for where the UNIRPC32.dll lives and figured out how to add a PATH variable to the .bat file. So now it doesn't complain about not being able to find the dll but it still doesn't run the universe routine. Now I get an error in the event log that says The description for Event ID (1000) cannot be found... [and it ends by saying] Message [DBS0043] And then I get another one similar only it uses Event ID 1004 and Message [DBS0036] I have no idea what all of that means. Maybe I need some way of telling uv how to log me in? Like I said this is all new to me. Thanks. Will I have never done this before so I'm likely making some horrible blunder. I have IIS running and I have a Universe database on top of Windows XP. I have a Hello page in HTML with a form and the submit action a name that I have in the same directory as the Hello page is in. So the hello page just looks something like this HTMLTITLEHELLO/TITLE BODYFORM SUBMIT=test/BODYHTML And the test item just looks like echo Hello which seems to work, although I have it created as a .bat file which is probably not right. But when I try to make it run a command like H:\IBM\UV\BIN\UV MYTESTPROGRAM It complains with a message that UNIRPC32.DLL can't be found in the paths ... and then it lists some paths. What is this telling me? And how do I fix it? Thanks Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] examples of X[n], X[m,n], X[c,m,n] substring extractionsand assignments
Don't forget the other variations: X['-',2,0] X['-',2,-2] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query about UniVerse database
The vt220 file within the terminfo file is a binary file; you would not benefit by opening it. You need to create a source file using the uvtidc command. This is a text file that you can read. uvtidc terminfo/v/vt220 vt220.src --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/