Re: [U2] External format command on Unidata

2007-08-15 Thread MAJ Programming
Unidata does have this feature, albeit from within the editor. What's the difference. You're always editing something anyway. D3 has BFORMAT at TCL but since Accuterm's WED has it, I've stopped using BFORMAT completely. My 1 cent Mark Johnson - Original Message - From: John Kent [EMAIL

RE: [U2] [UD7.1] [Solaris 9]SOAP calls

2007-08-15 Thread gerry-u2ug
Not sure what error you are seeing but here are some notes on my experience with the universe soap API. I wrote my own CallSoapService subroutine to handle the following UV Soap API bugs/issues. - adds namespace to method tags but not parameter tags Solution : add option to

[U2] [UV] what files does a user have open

2007-08-15 Thread iggchamp
Hi all, UV10.1.8 PICK FORMAT HPUX 11 How do I go about seeing what files a user has open? Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] [UV] what files does a user have open

2007-08-15 Thread Martin Phillips
Hi, How do I go about seeing what files a user has open? Take a look at the FILEMAP option of PORT.STATUS Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Bill Haskett
Martin: This is not the case. The dictionary looks like: 2 Demo (0)- .X AE DICT GLPOST INDEX_2 Top of INDEX_2 in DICT GLPOST, 9 lines, 364 characters. *--: P 001: I This is the INDEX dictionary that determines what the index is for this file. DO NOT add anything else to the 'correlative'

Re: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Martin Phillips
Hi Bill, The index system should be able to handle a trailing wildcard. My immediate thoughts are that the relevant dictionary item might be defined as right justified which would result in a right justified sort in the index tree which may in turn prevent use of the index for this item.

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Dave Davis
Place the REQUIRE.INDEX option after select GLPOST and before the first WITH. You can't place it after the criteria in UniData. REQUIRE.INDEX works in ecltype U but not ecltype P. You can also use NO.INDEX to force it NOT to use the index. Try: select GLPOST NO.INDEX WITH INDEX_2 LIKE 0605...

RE: [U2] [UV] what files does a user have open

2007-08-15 Thread John Jenkins
Or for an O.S snapshot rather than UniVerse: grep pid_of_choice `find . -type f -exec fuser -u {} \;`|wc -l run from the directory tree you want to search. Or you could drop the grep and wc -l and send it to a text file. Then just sort the text file based on PIDs. fuser -u displays all PIDs

[U2] User activity - SOX compliance

2007-08-15 Thread Bartman, George
All, I'm faced with a task of finding the means to monitor all user activity that results in a database change. Does anyone know of an application that we can plug in to UniVerse to accomplish this? We are running a mix of UniVerse releases mostly centered on 10.1.20 for our HP/UX

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Bill Haskett
Dave: Thanks. But I did that too (I also showed the REQUIRE.INDEX keyword can't come at the end of the sentence). 2 Demo (0)- select GLPOST REQUIRE.INDEX WITH INDEX_2 LIKE 0605... Index can not be used processing this query. 2 Demo (0)- Bill -Original Message- From: [EMAIL

RE: [U2] User activity - SOX compliance

2007-08-15 Thread Mark Eastwood
TRIGGERS should be simple enough; just plan out your audit file very carefully. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bartman, George Sent: Wednesday, August 15, 2007 1:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] User activity -

RE: [U2] [UV] what files does a user have open

2007-08-15 Thread Brutzman, Bill
We are beter off not caring what files are open. They could open any and every file to read them. When writing, if we do a one millisecond (1) record-lock-check (2) lock (3) write (4) un-lock then nobody gets hurt. --Bill -Original Message- From:

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Allen E. Elwood
Did you try LIST.INDEX GLPOST ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Wednesday, August 15, 2007 13:33 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Using indexes in UniQuery Martin: This is not the case. The

RE: [U2] User activity - SOX compliance

2007-08-15 Thread Bartman, George
I guess I should have elaborated on the ideas we had any why we didn't think they would work. Here is what we tried and or thought about: We tried to modify the actual commands like COPY, ED, etc to replace them with Remote items but our software vendor uses different syntaxes for all the

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Dave Davis
The right-justification idea makes the most sense to me. If the index was created and built when the field was defined as right-justified, and then somebody changed the definition to left-justified, it might still think you couldn't use the query. -Original Message- From: [EMAIL

RE: [U2] User activity - SOX compliance

2007-08-15 Thread Brutzman, Bill
There is a transaction logging thing that is built into UniVerse. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bartman, George Sent: Wednesday, August 15, 2007 4:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] User activity - SOX compliance

[U2] Perodic Reminder

2007-08-15 Thread Moderator
All, Please trim excess from your posts when responding. Just leave in the parts you are responding to, as a courtesy to the others on the list *especially* the digest readers. If you read this list through Indexfocus, Nabble, or any other replicator - and you would like to be able to

Re: [U2] User activity - SOX compliance

2007-08-15 Thread Clifton Oliver
The problem with that approach, aside from TL overhead, is that IBM does not publish the log format. Parsing them is possible, but not for the faint of heart. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460

[U2] [UV] Using callHttp POST with XML data.

2007-08-15 Thread Boydell, Stuart
I'm just wondering if anyone else has had any issues using callhttp() to POST data (UV 10.0.7). We have a process which does LIST TOXML and posts the several MB result to a web service. I can reliably cause it to fail by running another completely separate process which also does a LIST TOXML.

[U2] mvEnterprise to UniVerse Account Restore

2007-08-15 Thread Ross Morrissey
Has anyone had experience with account restores from mvEnterprise to UniVerse on AIX? T-LOAD of an mvE T-DUMP works, but acct.restore of an account save does not seem to. Thanks, Ross. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Bill Haskett
Allen: Thanks. Yes I did. The results were in the original email. But here they are again. 22 Demo (0)- LIST.INDEX GLPOST Alternate Key Index Details for File GLPOST Page 1 File.. GLPOST Alternate key length.. 45 Node/Block size... 4K OV

RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread Bill Haskett
Dave: That's not possible. This is an old dictionary that doesn't change. Nobody has access to these dictionaries except me. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Wednesday, August 15, 2007 2:20 PM To:

RE: [U2] mvEnterprise to UniVerse Account Restore

2007-08-15 Thread Bill Haskett
Ross: I'm guessing there may be an option to the SAVE verb which will put the save in a format that UV can then read. I know in D3 one has to use the (A option of the account-save. Another thing may be the block size. I know when we restore D3 to UD we have to make sure both the save and

{Blocked Content} RE: [U2] UD: Using indexes in UniQuery

2007-08-15 Thread colin.alfke
, with the contents of this message to hand when you call. At Wed Aug 15 21:46:42 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20070815 (message l7G4kcx4003633