Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly

2013-01-21 Thread Tom Whitmore
gateway. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Monday, January 21, 2013 12:02 PM To: 'U2 Users List' Subject: Re: [U2] Unidata 6.1.13/AIX

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Tom Whitmore
Hi, When you have more than about 1,000 values in a field, changing the value mark to a field mark, is significant. I had a program that needed to work through two fields with over 20,000 values. Initially, I left the strings as value delimited, used a for/next loop and assigned the results to

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Tom Whitmore
faster than using dynamic array functions, anytime we go over about 1,000 values. Remove definitely helps, but most of our code is old and is still using for/next loops. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2

Re: [U2] fnuxi error

2013-02-21 Thread Tom Whitmore
Hi Jeff, The problem is that there is a trigger on the file. Please call us and we can help you. Tom RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, February

Re: [U2] UV full screen editor

2013-02-25 Thread Tom Whitmore
Hi, I am aware of several windows editors available that work with U2. MVDeveloper (Brian Leach) BDT (Basic Developer Toolkit, from Rocket) XLr8Editor (Doug A) I have not used XLr8Editor. MVDeveloper and BDT have their strengths and weaknesses, both are free so you can try them out and chose w

Re: [U2] How do I find the code?

2013-03-06 Thread Tom Whitmore
a backup from then and try to restore it. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, March 05, 2013 9:33 PM To: u2-users@listserver.u2ug.org Subject: R

Re: [U2] Retirement and knowledge transfer

2013-03-06 Thread Tom Whitmore
Hi Wally, That's great but what about UniVerse internals as well? Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, March 06, 2013 8:31 AM To: U2 Users List Subject: [U2] Retirement a

Re: [U2] User cannot login

2013-03-12 Thread Tom Whitmore
Hi, I had to support windows implementations a few years ago and our customers had this problem regularly. Go into the GUI u2 admin tool. I haven't had to use the new tool, but in the UniAdmin, you would go into Network Services/Telenet, Click on the User tab. When you enter the domain and ac

Re: [U2] Ref: Is there anything built in to UV that contains when/who last

2013-04-10 Thread Tom Whitmore
space then the program id. You can use other "ls" options to sort the list, etc. For WINDOWS you would use DIR. I don't know the options off the top of my head. Of course, you can use WINDOWS EXPLORER as well. Tom Whitmore RATEX Business Solutions -Original Message- From

Re: [U2] is this an INDEX ISSUE?

2013-04-14 Thread Tom Whitmore
Hi David, To your real problem and question. We are on UniVerse, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine o

Re: [U2] UD - Display Current Terminal Type

2013-04-23 Thread Tom Whitmore
GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail

Re: [U2] UD - Display Current Terminal Type

2013-04-24 Thread Tom Whitmore
ist *Date:* 4/23/2013 5:11 PM *Subject:* Re: [U2] UD - Display Current Terminal Type > GET.TERM.TYPE will display the terminal type, width and depth. > > Tom Whitmore > RATEX Business Solutions > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org

Re: [U2] TCL input and response logging such as COMO

2013-04-24 Thread Tom Whitmore
that they are easily modifiable. You may want to consider using a Unix "Tee" to capture all output which isn't as easy to turn off. Having said that, I'm not a "Unix" expert so I can't offer the command string you should use but I'm sure someone will

Re: [U2] [UV] RESIZE INPLACE

2013-04-25 Thread Tom Whitmore
Check with support. IF it works, it is a very recent fix. Personally, that size file I would rename then create a file with the correct size then copy all the data over and use the overwrite option. (overwrite will reduce the IO because it doesn't have to check if the record exists).

[U2] What tools do you use for data warehouse...

2013-04-26 Thread Tom Whitmore
now at one point DataStage was a powerful but expensive tool that would accomplish this task. All suggestions are greatly appreciated! Tom Whitmore RATEX Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.o

Re: [U2] Help needed..

2013-05-07 Thread Tom Whitmore
Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOUR

Re: [U2] select query..

2013-05-15 Thread Tom Whitmore
Hi, You are better off executing everything in one EXECUTE statement, it is cleaner. EXECLINE='SELECT FILE.NAME WITH @ID = "':KEYVALUE:'"' EXECLINE<-1>='SAVE-LIST SOME.LIST' EXECLINE<-1>='GET-LIST SOME.LIST' EXECUTE LIST.NA

Re: [U2] Relative Path for SET.INDEX in Universe

2013-05-16 Thread Tom Whitmore
Hi Jeff, Are there problems when writing from a different account? Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Fitzgerald Sent: Wednesday, May 15, 2013 11:56 PM To

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-06 Thread Tom Whitmore
will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-

Re: [U2] Signature Capture and use

2013-06-09 Thread Tom Whitmore
the register out of PCI scope is huge for our customers and us. Of course, with everything PCI, your QSA can always have a "better idea". Tom Whitmore RATEX Business Solutions >> >> Harold.Oaks wrote: >> >>> I'm sure some of you are implementing signat

Re: [U2] What is true

2013-08-01 Thread Tom Whitmore
will result in FALSE. A=0 IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in FALSE. A='HELLO' IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in TRUE. A=1 IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' will result in TRUE

Re: [U2] What is true

2013-08-01 Thread Tom Whitmore
E(A):' ': 0006: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0007: A='HELLO' 0008: CRT 'A = ':QUOTE(A):' ': 0009: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE' 0010: A=1 0011: CRT 'A = ':QUOTE(A):' ': 0012: IF

Re: [U2] KeyPressed

2013-08-09 Thread Tom Whitmore
uff input thisKey, -1 input junk,1: until (thisKey = '1') sleep repeat gosub secondScreen The "input junk,1" will take the first character entered and discard it but it will clear the buffer, Tom Whitmore RATEX Business Solutions -Origin

Re: [U2] KeyPressed

2013-08-09 Thread Tom Whitmore
Sorry, you need to do: If (thisKey = '1') then Input junk,1: End Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, August 09, 2013

Re: [U2] No mail

2013-09-20 Thread Tom Whitmore
Hi Will, You are the first email today that I can find. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Johnson Sent: Friday, September 20, 2013 5:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] No

Re: [U2] UniVerse Dictionary question

2014-02-06 Thread Tom Whitmore
Hi, I use a single space which is nulled out by the editor. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, February 05, 2014 7:31 PM To: U2 Users

Re: [U2] Rivert back delete screen

2014-03-18 Thread Tom Whitmore
re able to recover deleted items. How good are your backups? You will need to restore the dictionary of the file to a different location and copy the pieces over. Be careful not to overwrite your live dictionary. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-

Re: [U2] Dynamic Concepts Unibasic ... Is this Pick ?

2014-04-24 Thread Tom Whitmore
This appears to be unrelated to Rocket's UniBASIC. In fact, it appears to run at the OS level. It is odd that their documentation states " UniBasic is a trademark of Dynamic Concepts Inc." Does Rocket have an infringement issue? Tom Whitmore RATEX Business Solutions -O

[U2] Job opening in Plymouth Meeting PA

2014-04-25 Thread Tom Whitmore
...@ratex.com Thanks, Tom Whitmore RATEX Business Solutions WWW.RATEX.COM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Job opening in Plymouth Meeting PA

2014-04-26 Thread Tom Whitmore
Hi, We had a problem with the email address I provided below. This problem is resolved. Sorry for the inconvenience. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, April 25, 2014

Re: [U2] sudo for dummies

2010-04-02 Thread Tom Whitmore
Can you explain what you are trying to do? you are creating a huge security hole with sudo because once the user is logged into UniVerse as root they can shell out, as root, and do whatever they would like to as root. If you want to have a user that can perform UniVerse admin role, check out th

Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture

2010-04-10 Thread Tom Whitmore
a. Yes, we have a handheld applications that use WebDE as the middleware. b. No c. Our ecommerce product uses soap calls and we push/pull from UniVerse. No middle ware required. d. No e. No f. We use AVEXXIS' AVRAD product for our primary product. Currently this has a thin Delphi client but th

Re: [U2] Updating SQL database from Universe 10.3

2010-04-15 Thread Tom Whitmore
We are using SOAP to extract and update and SQL server. Earlier versions (pre 10.3) of UniVerse have a memory leak, but this is working well for us. This isn't "real-time" but it is near real-time. The requests are queued and a phantom process pushes/pulls the data. The nice thing about SO

Re: [U2] SSH Telnet Server for NT, W2000, XP?

2010-05-20 Thread Tom Whitmore
Use Universe's SSL socket. I know this works with HostAccess terminal emulator, but I'm sure most of the other emulators out there support SSL. As is understand it, this is Telnet over SSL. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mai

Re: [U2] Can't RESIZE some files

2010-05-27 Thread Tom Whitmore
Dave, You didn't specify the operating system. I know Windows won't let you resize the file if it is open. Our application opens the files during login. To overcome this, I log into the UV account and create an F-pointer to the file, then resize through the F-pointer. Alternatively, rename y

Re: [U2] SB+ PA Compare

2010-06-02 Thread Tom Whitmore
Hi, We are using PRC, which is U2 aware. I understand your concerns but PRC does seem to address your concerns. You can have multiple programmers working on the same project and the same code, or you can provide each with a copy of the code but they'll have to merge their changes before moving

Re: [U2] Universe: AE just ... disappears?

2010-07-13 Thread Tom Whitmore
This is not just a problem with Windows. We have experienced the same problem on Linux. I think the problem isn't the catalog but the file pointers AE needs. ADDAE catalogs the program and creates the file pointers. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [

Re: [U2] Does Reality Flavor have globally cataloged subroutines?

2010-08-26 Thread Tom Whitmore
Instead of modifying the CATALOG verb, copy it to something like CATALOGI and then make the mod. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, August 26,

Re: [U2] [UV] Shared Record Locks

2010-08-31 Thread Tom Whitmore
Hi, The READL is one verb that causes a lot of confusion, and I have not found a use for it. READU prevents another person to lock the record, but regular READs continue to work without a problem. READL permits multiple READL or READ but no READUs/WRITES are permitted. You cannot update with a

Re: [U2] [UV] Shared Record Locks

2010-09-01 Thread Tom Whitmore
action > boundary best practice locking is enforced. Transactions have to guarantee > consistency (ACID), so that you can roll back a set of updates and leave the > database in exactly the state it was in at the beginning of the transaction. > In this case using READU and READL are manda

Re: [U2] Sequential Files Question

2010-09-09 Thread Tom Whitmore
Al, Do the following: OPENSEQ FNAME TO OUTFILE ELSE NULL WEOFSEQ OUTFILE ON ERROR STOPM 'FATAL ERROR: - Cannot write to file ':FNAME Now, you should be able to perform the writes without a problem. By the way, the ON ERROR clause is optional. The WEOFSEQ will either create the file,

Re: [U2] [U2} Cloud UniVerse?

2010-10-04 Thread Tom Whitmore
We had looked into hosted solutions. Check out Sumasys (zumasys.com), they are very knowledgeable about U2, or RackSpace. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman S

Re: [U2] [U2} Cloud UniVerse?

2010-10-04 Thread Tom Whitmore
ask them to do it for you. Like I said, it's easy, and they may find themselves creating a whole new line of business for themselves. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitte

Re: [U2] Uppercasing in SELECT

2010-12-03 Thread Tom Whitmore
If you need one on the fly try: SELECT filename WITH NAME_FIELD CONV "MCU" = "uppercase value" CONV is a valid function on the command line. As an aside, FMT is also valid, so you can change the format on the SELECT, LIST, or SORT commands lines. Tom RATEX Business Solutions -Original Me

Re: [U2] Clear Messages

2011-02-11 Thread Tom Whitmore
They look like addresses, could be the line that executed the call. You would have to use VLIST to see where it is in the code (VLIST filename program). Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.

Re: [U2] User LogOut Cabbage

2011-03-09 Thread Tom Whitmore
HI, You don't need the ".Type19" file. You can do rm -R \&SAVEDLISTS\& mkdir \&SAVEDLISTS\& You do need to make sure the permissions are correct on the directory, we have found people not having the correct UMASK so people have trouble writing to the directory. Tom RA

Re: [U2] Enterprise Scheduling solution

2011-06-14 Thread Tom Whitmore
You should check out Benton, it works on Unix and Windows OS, and is U2 based so it can run paragraphs, procs, programs etc. Very flexible. I have used it for more years than I care to admit. :D. The link is http://www.infocus50.com/benton.htm Tom -Original Message- From: u2-users-bo

[U2] Question about updating customer's systems...

2011-06-16 Thread Tom Whitmore
ld share their experiences of implementing something like this, and be willing to share what they learned through your implementation (what worked, what didn't, what are the gotcha's that we should make sure we address). Thanks! Tom Whitmore RATEX Business Solution ___

Re: [U2] Question about updating customer's systems...

2011-06-16 Thread Tom Whitmore
Thanks Doug, PRC does a great job of tracking what needs to go where, as we pack up the update. The problems we are currently having are 1) our customers want updates after their business hours (read late into the night) 2) our customers have custom code 3) our customers would like to be able to

Re: [U2] [UV] Break and debug

2011-06-24 Thread Tom Whitmore
Normally that means that it is doing something that won't allow debugging (waiting on a lock, performing a select, I believe are two examples). Tom RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Beh

Re: [U2] Adding capabilities in the sort term

2011-07-07 Thread Tom Whitmore
ion touches the register, which takes both out of scope for PCI DSS, and PCI PA-DSS... depending on your auditor that is. Tom Whitmore, RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oa

Re: [U2] Question about updating customer's systems...

2011-07-08 Thread Tom Whitmore
Hi, Thanks you to everyone that responded. We had identified the items people suggested, and some addition items. Thanks again! Tom From: Tom Whitmore Sent: Thursday, June 16, 2011 11:11 AM To: U2-Users@listserver.u2ug.org Subject: Question about updating customer's systems... Hi, We de

Re: [U2] Record Locks - How long should they last for? (Opinion)

2011-07-14 Thread Tom Whitmore
ord was updated) and remediate the differences. The write will temporarily lock the record. Personally, "optimistic" locking is not an ideal method for performing updates. I know that is the way many DBs work but that doesn't make it right. Tom Whitmore RATEX Business Solutions -O

[U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-07-29 Thread Tom Whitmore
.) Thanks, Tom Whitmore RATEX Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-07-29 Thread Tom Whitmore
...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, July 29, 2011 1:40 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Using SSL, with .Net to make a connection to Linux/Unix Hi, We are having problems making the .NET telnet tool make an SSL connection to UniVerse on a Linux server. Has anyone been

Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-07-31 Thread Tom Whitmore
Thank you everyone. I'll let you know how things progress this week. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, July 30, 2011 11:43 AM To: 'U2 Users List' Subject: Re: [U2] Using

Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-08-01 Thread Tom Whitmore
do a: find / -name xinetd.conf Other than that, I've never done a .NET telnet connection, but, I have worked with configuring telnet on Linux. On Sun, Jul 31, 2011 at 8:49 PM, Tom Whitmore wrote: > Thank you everyone. I'll let you know how things progress this week. > Tom >

Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

2011-08-02 Thread Tom Whitmore
ve worked with configuring telnet on Linux. On Sun, Jul 31, 2011 at 8:49 PM, Tom Whitmore wrote: > Thank you everyone. I'll let you know how things progress this week. > Tom > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-08-31 Thread Tom Whitmore
The latest version of BDT is amazingly fast, and it has a lot of nice features. I have used both BDT and MVDeveloper, both are good. I would encourage you to try both and see which works best for you. The plus with both of these apps is that they are free. Tom Whitmore RATEX Business

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-08-31 Thread Tom Whitmore
Will, when you install BDT it will install Eclipse. I have not had a problem with installing the tool. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Will Goodwin Sent: Wednesday, Augu

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-05 Thread Tom Whitmore
provides. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, October 05, 2011 9:51 AM To: U2 Users List Subject: Re: [U2] FAST (File Analysis and

Re: [U2] Universe File Issue

2011-10-11 Thread Tom Whitmore
Hi John, You do have several options, depending on your company's needs. 1) purge 2) convert the file to 64 bit so it can grow over 2 gigs (modify uvconfig 64BIT_FILES parameter and then resize the file with the "64BIT" option. (see UniVerse User Reference and Administering UniVerse documents fr

Re: [U2] Mercurial/TortoiseHg source version control

2011-11-15 Thread Tom Whitmore
We use PRC, which is a "PICK" based product. We have seen a marked improvement in the whole development cycle since using PRC. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Mercurial/TortoiseHg source version control

2011-11-15 Thread Tom Whitmore
re not "PICK" aware. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Tuesday, November 15, 2011 11:31 AM To: U2 Users List Subject: Re: [U2] Mercu

Re: [U2] Mercurial/TortoiseHg source version control

2011-11-15 Thread Tom Whitmore
ain-stream 4GL (like SB+) and we needed to modify the 4GL's tools to call PRC. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Tuesday, November 15, 2011

[U2] Question about UniVerse indexes...

2011-11-18 Thread Tom Whitmore
7;m having trouble finding a similar function... Any suggestions would be greatly appreciated! Tom Whitmore RATEX Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Question about UniVerse indexes...

2011-11-18 Thread Tom Whitmore
Thanks for the suggestion, the function is INDICES. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Friday, November 18, 2011 5:38 PM To: U2-Users

Re: [U2] -E debugger entry; Universe?

2011-11-20 Thread Tom Whitmore
Hi Susan, Add TRAP to the end of the command. For example: RUN BP TESITIT TRAP TESTIT TRAP If you have command line arguments, add TRAP after the last argument. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users

Re: [U2] Show.Timestamp

2011-12-20 Thread Tom Whitmore
How about CRT TIMEDATE() Tom Whitmore RATEX Business Solutions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, December 20, 2011 12:53 PM To: u2-users@listserver.u2ug.org Subject: [U2

Re: [U2] Brilliant? or not?

2012-01-16 Thread Tom Whitmore
I agree with Tony. You can write dense code, but the goal should always be to write clear, documented, code so the next programmer doesn't have to "figure out" what you are trying to do. The more dense the code, the higher the cost to maintain the code. The beauty of PICK code is that you

Re: [U2] local variables

2012-01-27 Thread Tom Whitmore
UniVerse has the compiler option "-X" (same as "-XREF") that builds a cross reference of all variables, includes, subroutine labels, etc. It identifies the line(s) it is assigned a value, and the lines that reference it. The key is the program id and is stored in a file with a .L suffix (so if

Re: [U2] Including Code - A Best Practice?

2012-02-08 Thread Tom Whitmore
I would agree that code in includes provides a faster program than making an external subroutine. I had performed tests when milliseconds counted, but now systems are so fast the advantage is not noticeable. Putting code in includes: Makes debugging harder Installing updates re

Re: [U2] Compare/Diff feature in BDT

2012-04-05 Thread Tom Whitmore
There is a compare feature in BDT. It only works for records in directories though. I'd love to be able to compare paragraphs, procs or dictionaries but I haven't seen a way. To compare, you need to select the first program then hold the control key and select the second program. Now right-c

Re: [U2] Credit Card numbers in your database

2012-04-18 Thread Tom Whitmore
You need to talk to your QSA, our QSA is great because we can ask him questions anytime and he doesn't charge for each question we ask. He helps us make decisions about our products that eases the recertification process. We only pay every 3 years for our PCI PA-DSS certification. It is well

Re: [U2] Credit Card numbers in your database

2012-04-19 Thread Tom Whitmore
Hi Carl, The document appears to be referring to current backups, not old backups. Moving forward, you do need to have your data encrypted on tape, but if you always encrypt the data at rest then this isn't an issue. Talking to your QSA to make sure you are meeting PCI requirements for your old

Re: [U2] READU vs READ

2012-05-01 Thread Tom Whitmore
Hi, The question of READU vs READ when you are doing updates is moot. If you do a READ then a WRITE, UniVerse/UniData will perform the record lock. The only difference is with READ you are gambling that no one else is updating the record before you perform your WRITE. Performance, as others s

Re: [U2] Command that turns off default command stacker

2012-05-05 Thread Tom Whitmore
I had written a simple process that was added to the LOGIN paragraph and the ON.EXIT paragraph. It used the login id and a sequence number, to retrieve the stack and save the stack on exit... of course I also turned off the STACKWRITE. This worked quite well, and limited the number of command

Re: [U2] Command that turns off default command stacker

2012-05-07 Thread Tom Whitmore
system. Tom PROGRAM UTL.STACK * PROGRAM TITLE : UTL.STACK * AUTHOR: Tom Whitmore * CREATION DATE : 03/06/98 * SAR NUMBER: * DESCRIPTION : This will either save or retrieve a command stack. * INCLUDES : NONE * EXTERNAL CALLS: NONE * CALLED BY

Re: [U2] Command that turns off default command stacker

2012-05-07 Thread Tom Whitmore
The RETURN TO FINISH will clear any stacked gosubs and then exit the program. This was a programming standard that I had to conform to when this was written. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of saty

Re: [U2] SAVING UNIQUE ( multivalued)

2012-05-18 Thread Tom Whitmore
I have not had a problem, in UV, saving multi-values. Make sure the dictionary is flagged as multi-valued (field 6 of a D or I type, has the value of "M"). If the dictionary is set to single value ("S"), saving unique will treat the entire field as one value. If you are still having trouble,

Re: [U2] Running a command in a different account

2012-08-01 Thread Tom Whitmore
We are working on an internal scheduler to run jobs in other accounts. You can add the LOGTO command to your paragraph or proc and log to whatever account you need to run the process in... As long as the login VOC tests for phantoms it should work fine. Tom RATEX Business Solutions -Orig

Re: [U2] PI/UV: Decompiler

2012-08-28 Thread Tom Whitmore
I know there was a decompiler available. I don't remember if Lee Leitner (Infocus) or Fitzgerald and Long were the resellers for this tool. I'll try to dig up information on this but it would be great if Lee, Peggy or Jeff could put their two cents in on this. Tom Whitmore RATE

Re: [U2] Selection Suggestions for using UV instead of SQL

2012-10-17 Thread Tom Whitmore
You don't need the "PA" in field one when you execute the stack. You can create a multi-field record and execute it and UniVerse treats it as a paragraph. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2u

Re: [U2] [BDT] A giant leap forward

2012-10-25 Thread Tom Whitmore
HI, I just looked at http://www.rocketsoftware.com/u2/resources/downloads and it is still BDT 3.0.1. When will this site be updated, or is there somewhere else to look for the update? Thanks, Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@li

Re: [U2] U2 Product Release: U2 DBTools vNOV2012

2012-11-30 Thread Tom Whitmore
This came from U2, and I was able to update BDT following these instructions: You should be able to upgrade BDT from the Eclipse Help menu, select "Install New Software..." Instructions below - U2 Database Tools Update Release September 2012 for Windows has been released to manufacturing on

[U2] RE: Ssh connections to Universe DB?

2008-09-24 Thread Tom Whitmore
HI Laure, SSH is possible on windows. However, There isn't a complete SSH solution You have to purchase it (there are some free ones but they are very weak) They don't work with many of the terminal emulators, but it does work with Putty We are using SSL, which is an enc

[U2] [UV] Job Posting

2008-11-06 Thread Tom Whitmore
Hi, I wanted to let this group know of a job opportunity with my company. I have been working for RATEX for two years, and the work environment is great. Thanks, Tom Job Posting: Job Title: VB.Net Programmer (based on experienced) Department: Development Reports To: Tom

RE: [U2][UD] Index for @ID (IBM documentation)

2009-01-28 Thread Tom Whitmore
No, you don't want to index on the ID because it is unique. That would be a very inefficient index. If you created an i-descriptor that broke the ID into several multi-valued parts, then it MAY help, but I don't think it is worth the overhead. Tom -Original Message- From: owner-u2-us

[U2] Inter-Process Control...

2009-02-26 Thread Tom Whitmore
example) Repeat Phantom2 (3, 4, ...): Loop Process records Notify semaphore Repeat Thanks, Tom Whitmore RATEX Business Solutions --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Inter-Process Control...

2009-02-26 Thread Tom Whitmore
Thank you for all the responses. I should have stated that we are a UniVerse shop. I did play with the lock/unlock but the only process that can modify the lock is the one that set it. Also, I could not get the process to wait on the lock. From the playing I did, lock/unlock seems very limite

RE: [U2] Inter-Process Control...

2009-02-26 Thread Tom Whitmore
I agree. I wrote two little programs. LOCK.TEST1 0001 LOCK 60 ELSE CRT '60 LOCKED' 0002 CRT 'UNLOCKED' LOCK.TEST2 0001 UNLOCK 60 0002 CRT '60 WAS UNLOCKED' LOCK.TEST1 locked 60 displayed "unlocked". LOCK.TEST2 generated the error ' Program "LOCK.TEST2": Line 1, Lock 60 not owned by calling pr

RE: [U2] Inter-Process Control...

2009-02-26 Thread Tom Whitmore
B STOP - Original Message - From: "Tom Whitmore" To: u2-users@listserver.u2ug.org Sent: Thursday, February 26, 2009 12:05:19 PM GMT -06:00 US/Canada Central Subject: RE: [U2] Inter-Process Control... Thank you for all the responses. I should have stated that we are a UniVe

RE: [U2] Inter-Process Control... {Unclassified}

2009-02-26 Thread Tom Whitmore
it collisions, you may need to use persistent connections or a re-architecting of the data and/or application to reduce the frequency of collisions. Hope this helps Mike -Original Message----- From: owner-u2-us...@listserver.u2ug.org On Behalf Of Tom Whitmore Sent: Friday, 27 February 2009

RE: [U2] Help with encryption

2009-05-12 Thread Tom Whitmore
Hi Laure, The U2 encryption is symmetrical. I have asked about one-way, but I have been informed that this is not available. We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Tom

Re: [U2] POS System

2009-06-10 Thread Tom Whitmore
Hi Norm, RATEX does offer a PCI PA-DSS certified POS solution and we are running on UniVerse. We offer a full suite of applications to the college bookstores. The major difference between college bookstores and other retail applications is the store's need to support textbooks (from selection,

Re: [U2] Head Hunter

2009-08-03 Thread Tom Whitmore
Hi Ed, Please send your resume to res...@ratex.com, maybe we have a fit. We are located in western Philadelphia. Tom Thomas Whitmore Director of Product Developmen RATEX Business Solutions, Inc.

Re: [U2] Performance query

2009-09-02 Thread Tom Whitmore
I haven't verified this, but I understand that the "WITH" clause acts as parenthetical statements. Therefore: SSELECT MYFILE WITH FIELD1 = "RED" OR FIELD1 = "BLUE" AND WITH FIELD2 = 4 OR FIELD2 = 6 Will result in a different selectlist than SSELECT MYFILE WITH FIELD1 = "RED" WITH OR FIELD1

Re: [U2] Hmmmm...Learn something new every day!

2009-09-04 Thread Tom Whitmore
EXECUTE creates a new environment, try PERFORM. From BASIC Help: EXECUTE creates a new environment for the executed command. This new environment is initialized with the values of the current prompt, current printer state, Break key counter, the values of in-line prompts, KEYEDITs, KEYT

Re: [U2] [UV][UX] @USERNO > @LOGNAME/PID ;...

2009-09-11 Thread Tom Whitmore
Hi, You weren't clear if the server is Unix or Windows. One Unix solution is: USERNO=STATUS() SENT=\sh -c 'ps -ef|grep \:USERNO:\|grep -v "grep"'\ EXECUTE SENT CAPTURING RESULT USERID=FIELD(TRIM(RESULT),' ') For Windows, the only way I can think of is to maintain a file that records the @USERNO

Re: [U2] EXECUTE 'CLEARSELECT'

2009-10-12 Thread Tom Whitmore
You can just use the CLEARSELECT function in your basic code on UV, instead of using execute or perform. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, October 12, 2009 5:56 PM To: U2

  1   2   >