Re: [U2] UVODBC, MS-Query gets data but Excel can't get results

2006-07-18 Thread Ray Wurlod
The connection between Excel and MS Query is (still!) a DDE conversation. Something has gone wrong with the way this is working. There's probably some diagnostic tools - search the MS knowledge base. I believe it's unrelated to uvutils.dll - that's a separate problem that you have! :( ---

Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT

2006-07-18 Thread Ray Wurlod
It may not be "more" that you need. As Martin noted, the hashing algorithms generate a number between 1 and GSEMNUM based on the group address (and device/inode numbers), so that all records in the same group in the same file use the same semaphore set. Making this wider (incresasing GSEMNUM)

RE: [U2] UD: Synonym account

2006-07-18 Thread Nick Cipollina
I don't know how it works in Unidata, but in Universe, you add a record to the VOC called DEMO, and in that record you put IAM DEMO. If you want the account to be MyDemo, you add a record to the VOC called MyDemo and put in IAM MyDemo. These records would be paragraphs. Thanks, Nick Cipollina

RE: [U2] ODBC Error {Unclassified}

2006-07-18 Thread HENDERSON MIKE, MR
Al, For what it's worth ... >CT SYS.MESSAGE 081001 081001 0001 unirpc: Bad Connection 0002 > Not very helpful, I'm afraid Mike > -Original Message- > From: [EMAIL PROTECTED] On Behalf Of Al DeWitt > Sent: Wednesday, 19 July

[U2] UD: Synonym account

2006-07-18 Thread Bill Haskett
How does one go about creating a synonym account. For instance, I have an account E:\MyDirectory\Demo If I log into this directory, which I must do, the @WHO tells me I'm logged into "DEMO". Makes sense. The path in the (UD.ACCOUNT) file is "E:\IBM\ud71\Demo". So, if I want to log into both

RE: [U2] ODBC Error

2006-07-18 Thread Amy Cook
Al, Is it possible that you lost network connectivity between the client executing the query, and the unidata server, during the query? I'm responding from memory, so I could be off, but I'm thinking this might be the culprit. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE

[U2] ODBC Error

2006-07-18 Thread Al DeWitt
Has anybody know what this error means? SQL Status: IM985 Error code: 81001 [Ardent][UniData ODBC Driver][UniData RDBMS][IBM][SQL Client][RPC] error code = 81001 Albert L. DeWitt Jr. Senior Programmer Analyst Stylmark, Inc. (V) 763-574-8705 (F) 763-574-1052 [EMAIL PROTECTED] --

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Jerry Banker
Exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Tuesday, July 18, 2006 1:48 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] SOX question (United States only, I believe) The friendly neighborhood cracker isn't a threat. I

[U2] UVODBC, MS-Query gets data but Excel can't get results

2006-07-18 Thread Joey Walter
Have a customer who has been succesfully running (actually using very heavily) UVODBC with MS-Query and Excel. They are using MS Office 2003, but I'm not sure of their Universe version off the top of my head. Today something has broken the loving couple of MS-Query and MS-Excel ;-) MS-Query functi

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Dave Walker
The friendly neighborhood cracker isn't a threat. It's only the employees that can't be trusted. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Sent: Tuesday, July 18, 2006 1:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOX question

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Jerry Banker
But doesn't this leave the information readily available to the friendly neighborhood cracker? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Tuesday, July 18, 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOX q

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Gordon J Glorfield
Document everything! Make no changes without a written request from the users. Have them test and approve the changes, in writing, after completion. Store your documentation in a format that is readily accessible to the auditors. Gordon J. Glorfield Sr. Applications Developer UnitedHealthca

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Dave Walker
Short answer: you can't. (We just went thru a Sox audit) Regards, -- Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of DAWES, Ray Sent: Tuesday, July 18, 2006 10:19 AM To: u2-users@listserver.u2ug.org Cc: ALLEN, David Subject: RE: [U2] SOX question (Unite

Re: [U2] SOX question (United States only, I believe)

2006-07-18 Thread Results
Ray, One way to do it is to form a joint venture with other tea makers and do business through that company, which subcontracts your company and the others. Of course, in theory, all the subs would have to be SOX compliant, but it should satisfy most customers. - Chuck "Or, You Could J

RE: [U2] SOX question (United States only, I believe)

2006-07-18 Thread DAWES, Ray
Hi, I have been reading this thread and others with interest, but no one has managed to answer how you can be SOX compliant when you have only one guy who programmes, administers, upgrades the software and makes the tea! Any suggestions anyone? Cheers, Ray Dawes

Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT

2006-07-18 Thread Martin Phillips
Hi Manu, > Actually, I've got many Collision, Retries into the analyze.shm -s > > I'll probably conclude to increase the GSEMNUM to give more > processing versus give more space by expend TABSZ. This is a good conclusion. High collision counts can be caused by having a table that is too wide (xxT

Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT

2006-07-18 Thread Manu Fernandes
Hi Martin, Thanks for your comments, Yes theses values are large, (too large). I'm looking to understand how to manage theses parameters in a environment where applications use Transaction processing (commit / rollback) with little records in a pure relational schema (header files and details

Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT

2006-07-18 Thread Martin Phillips
Hi Manu, These do seem to be some very large numbers. GSEMNUM=241, GLTABSZ=150, RLTABSZ=375, RLOWNNER=375 This gives a record lock table with 90,000 items in it. Ok, because of how locking works you would be very unlikely to be able to use all 90,000 but this still seems very large. Do you reall

Re: [U2] asymmetric encyption

2006-07-18 Thread Symeon Breen
Do the U2 ENCRYPT and DECRYPT functions not do what you want ? On 14/07/06, Raymond DeGennaro II <[EMAIL PROTECTED]> wrote: > > At 00:44 +0200 2006/07/14, 8ukasz s wrote: > >has anyone got some implementation in PICK (UVI, > >U2, JBASE) BASIC (or somethig similar) of > >asymmetric encryption algo

Re: [U2] [UV] gsemnum,gltabsz,rltabsz - on NT

2006-07-18 Thread Manu Fernandes
Hi, Thanks for suggestion, A good way to search. I found two events, when I search about it into the ibm's kdb and google, I found reference to the windows's heap, From uvregen I receive : with new parameters : uvregen: reconfiguration complete, disk segment size is 11'862'500 Universe don