Re: [U2] Job opening in Plymouth Meeting PA

[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 8:45 AM
To: U2 Users List
Subject: [U2] Job opening in Plymouth Meeting PA

Hi,
RATEX Business Solutions, the premier provider of software solutions to the 
independent college bookstore community, has several openings for programmers 
with Pick BASIC experience.  

These individuals will help support our GUI products, our POS product and 
participate in our expansion of technology solutions we are offering to our 
customers.

These positions are full time or contract to hire positions.

Our office is located in Plymouth Meeting PA, just outside of Philadelphia.  
Looking at a map, we are at the intersection of I-276 (PA Turnpike) and I-476.

The senior programmer must have a minimum of 10 years of Pick BASIC experience, 
preferably with UniVerse.

The junior programmer must have a minimum of 3 to 5 years of Pick BASIC 
experience, preferably with UniVerse.

Additional requirements:
1) Strong problem solving skills
2) Able to work in a team or independently
3) Strong communication skills
4) Strong people skills

Pluses:
1) Have 4-GL experience (SB+, BlackSmith, DesignBais, etc.)
2) Experience with POS
3) Experience with PCI PA-DSS
4) Familiar with Unix environment
5) .NET, Java, Delphi or other languages

No recruiters please.

Please send resumes to res...@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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Job opening in Plymouth Meeting PA

[Tom Whitmore]

Hi,
RATEX Business Solutions, the premier provider of software solutions to the 
independent college bookstore community, has several openings for programmers 
with Pick BASIC experience.  

These individuals will help support our GUI products, our POS product and 
participate in our expansion of technology solutions we are offering to our 
customers.

These positions are full time or contract to hire positions.

Our office is located in Plymouth Meeting PA, just outside of Philadelphia.  
Looking at a map, we are at the intersection of I-276 (PA Turnpike) and I-476.

The senior programmer must have a minimum of 10 years of Pick BASIC experience, 
preferably with UniVerse.

The junior programmer must have a minimum of 3 to 5 years of Pick BASIC 
experience, preferably with UniVerse.

Additional requirements:
1) Strong problem solving skills
2) Able to work in a team or independently
3) Strong communication skills
4) Strong people skills

Pluses:
1) Have 4-GL experience (SB+, BlackSmith, DesignBais, etc.)
2) Experience with POS
3) Experience with PCI PA-DSS
4) Familiar with Unix environment
5) .NET, Java, Delphi or other languages

No recruiters please.

Please send resumes to res...@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] Dynamic Concepts Unibasic ... Is this Pick ?

[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 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, April 24, 2014 2:33 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Dynamic Concepts Unibasic ... Is this Pick ?


http://www.dynamic.com/software/unibasic/

This company confuses me.  Is this the same UniBASIC ?
They are based in Irvine but their website makes it seem like this UniBasic 
is theirs.
No mention of Rocket.

Or are their actually two completely unrelated companies, hawking products both 
called Uni Basic ?


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Rivert back delete screen

[Tom Whitmore]

Hi Shanmukh,
I'm sorry to hear that you have a problem with a screen being deleted.  We 
don't use SB+ but here are some things to consider:

Do you use version control software?   
If so, you should be able to use your version control software to undelete the 
screen.  We use PRC and are 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-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shanmukh Nandha
Sent: Tuesday, March 18, 2014 8:39 AM
To: U2-Users@listserver.u2ug.org
Subject: Re: [U2] Rivert back delete screen

Hello Friends,


Can any one of you can let me know How can we rivet back deleted SB+ screen

Thank you,
Shanmukh
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse Dictionary question

[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 List
Subject: Re: [U2] UniVerse Dictionary question

Well, I'll be a son of a biscuit eater! I never knew that. I've done it the 
same way Martin does for 35 years. I just checked it in Jbase and it works. You 
learn something new every day. Of course, I consider a day a total waste if I 
don't either learn something new or catch hell about something. As you can 
guess, I don't have many wasted days.

Thanks, Dan!
Charlie

Tiny Bear Wild Bird Store
Home of Safety Net Shipping
http://www.TinyBearWildBirdStore.com
Toll Free: 1-855-TinyBear (855-846-9232)

On 02-05-2014 6:15 PM, Daniel McGrath wrote:
 A tip my original mentor taught me on the first day was that in ED/AE, the 
 back tick (`) gets treated as an empty line so you can keep going in insert 
 mode and not need to worry about it.

 Regards,
 Dan


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin 
 Scholl
 Sent: Wednesday, February 05, 2014 5:07 PM
 To: 'U2 Users List'
 Subject: Re: [U2] UniVerse Dictionary question

 The dots were just there to keep the numbered list going, The same I use dots 
 in the Editor to enter blank lines. Later I go to the top and do R/.//50 to 
 remove the dot.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
 Sent: Tuesday, February 04, 2014 3:04 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] UniVerse Dictionary question


 What are the periods in 3 and 4 for?
 Did you try removing those?



 -Original Message-
 From: Woodward, Bob bob_woodw...@k2sports.com
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Tue, Feb 4, 2014 11:49 am
 Subject: Re: [U2] UniVerse Dictionary question


 Just to make sure, you're wanting FIELD 178 and the first value of that 
 field.  Correct?  Because you have a length of 1, left justified I want to 
 make sure you're not looking for the first character of the 178th field.
 Maybe if you showed what you're wanting and what you're getting, instead, 
 then we'd be sure to give you an answer that makes sense.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill 
 Haskett
 Sent: Tuesday, February 04, 2014 11:45 AM
 To: U2 Users List
 Subject: Re: [U2] UniVerse Dictionary queston

 Martin:

 This is the only way to do accomplish the defined task in UniData.
 Maybe @RECORD178,1 is the preferred method in UV.

 Bill
 Untitled Page


 --
 --
 - Original Message -
 *From:* msch...@martinscholl.com
 *To:* U2 Users List u2-users@listserver.u2ug.org
 *Date:* 2/4/2014 11:33 AM
 *Subject:* [U2] UniVerse Dictionary queston
 UniVerse.

 I want to create a dictionary item that extract value 178,1

 I thought

 1.   I
 2.   EXTRACT(@RECORD,178,1,0)
 3.   .
 4.   .
 5.   1L
 6.   S


 Would do but it does not give me the desired result. Any suggestions?

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

   
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] No mail

[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 mail

Still no mail from the list.



--
View this message in context: 
http://u2-universe-unidata.1073795.n5.nabble.com/No-mail-tp41844p41855.html
Sent from the U2 - Users mailing list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] KeyPressed

[Tom Whitmore]

I do agree that INPUTCLEAR should work but since it doesn't, try CLEARDATA.

Your example seems to be missing something that may help clarify things but 
another thought is:
  loop

call *timeOfDay
call *displayOtherStuff

 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

-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 4:04 PM
To: 'U2 Users List'
Subject: [U2] KeyPressed

With Dynamic Connect... and UniBasic...

I need a screen that continuously displays time... as we have an inspection 
screen where press operators enter fresh data each hour.  Something like...

  loop

call *timeOfDay
call *displayOtherStuff

 input thisKey, -1

  until (thisKey = '1')
  
 sleep
  
  repeat  

  gosub secondScreen



The trouble with this thing is... when a key is pressed... it wants to display 
the key on asubsequent screen.

I tried...inputclear... but it is not doing what I want.

Suggestions would be appreciated.

--Bill

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] KeyPressed

[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 4:22 PM
To: 'U2 Users List'
Subject: Re: [U2] KeyPressed

Tom:

Thanks for writing... but...

Once I put in 

Input junk, 1:

The loop waits for a user input and thus stops updating time.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Friday, August 9, 2013 4:19 PM
To: U2 Users List
Subject: Re: [U2] KeyPressed

I do agree that INPUTCLEAR should work but since it doesn't, try CLEARDATA.

Your example seems to be missing something that may help clarify things but 
another thought is:
  loop

call *timeOfDay
call *displayOtherStuff

 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

-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 4:04 PM
To: 'U2 Users List'
Subject: [U2] KeyPressed

With Dynamic Connect... and UniBasic...

I need a screen that continuously displays time... as we have an inspection 
screen where press operators enter fresh data each hour.  Something like...

  loop

call *timeOfDay
call *displayOtherStuff

 input thisKey, -1

  until (thisKey = '1')
  
 sleep
  
  repeat  

  gosub secondScreen



The trouble with this thing is... when a key is pressed... it wants to display 
the key on asubsequent screen.

I tried...inputclear... but it is not doing what I want.

Suggestions would be appreciated.

--Bill

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] What is true

[Tom Whitmore]

Hi,
To add a little more to the discussion.  I know in UniVerse this is true and I 
suspect it is true in other flavors of Pick.

If you wrap a variable in parenthesis it will be treated as a Boolean test.  
For example:

A=''
IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE'   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.

I have found this useful in coding.

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, August 01, 2013 4:40 AM
To: 'U2 Users List'
Subject: Re: [U2] What is true

To clarify

In multivalue, True is not False, where False is anything that is 'falsy'
i.e. zero or empty.
Obviously different than other languages, notably those where true is -1 (all 
bits set on a signed integer).

So:

A = HELLO
IF A THEN CRT A : WORLD

Gives HELLO WORLD

Regarding file variables, the best way to check for these being assigned on 
UniVerse is to use FILEINFO().

If FileInfo(SomeUnassignedVariable, 0) Then
   Crt This is an open file variable
End Else
   Crt This isn't
End

Brian


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] What is true

[Tom Whitmore]

Here is a simple program I wrote and ran on UV 11.1.9.  It would be interesting 
to hear if UD behaves the same way.

0001: A=''
0002: CRT 'A = ':QUOTE(A):' ':
0003: IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE'
0004: A=0
0005: CRT 'A = ':QUOTE(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 (A) THEN CRT 'TRUE' ELSE CRT 'FALSE'

The results are:
 A =  FALSE
 A = 0 FALSE
 A = HELLO TRUE
 A = 1 TRUE

Tom Whitmore
RATEX Business Solutions


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Swain
Sent: Thursday, August 01, 2013 8:24 AM
To: U2 Users List
Subject: Re: [U2] What is true

This is not true as when A='HELLO'  IF (A) returns true.

You use the parenthesis to set a Boolean variable, i.e  BRITISH = (COUNTRY = 
'ENGLAND' OR COUNTRY = 'WALES')  etc   the var BRITISH is set to 1 when the 
conditions inside the parenthesis are met, otherwise BRITISH is set to 0




Jim Swain - Developer
Telephone: +44 (0) 1295 701 810  | Fax: +44 (0) 1295 701 819

www.zafire.com

Consider the environment.  Think before you print.

This is a commercial communication from Zafire Group.
This communication is confidential and is intended only for the person to whom 
it is addressed. If you are not that person you are not permitted to make use 
of the information and you are requested to notify us immediately that you have 
received it and then destroy the copy in your possession.  Zafire Group may 
monitor outgoing and incoming e-mails.  By replying to this e-mail you consent 
to such monitoring.  This e-mail message and any attached files have been 
scanned for the presence of computer viruses. However, you are advised that you 
open attachments at your own risk.

Zafire Limited is a limited liability company registered in England and Wales. 
Co. Reg. No. 3968255. Our registered address is Zafire House, Manor Park, 
Banbury, Oxfordshire OX16 3TB. VAT Reg.No. 754 0161 55. Zafire Aviation 
Software Limited is a limited liability company registered in England and 
Wales. Co. Reg. No. 05577742. Our registered address is Zafire House, Manor 
Park, Banbury, Oxfordshire OX16 3TB. VAT Reg.No. 874 5890 70

If you have any concerns regarding the content of this e-mail please contact 
postmas...@zafire.com

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: 01 August 2013 13:17
To: U2 Users List
Subject: Re: [U2] What is true

Hi,
To add a little more to the discussion.  I know in UniVerse this is true and I 
suspect it is true in other flavors of Pick.

If you wrap a variable in parenthesis it will be treated as a Boolean test.  
For example:

A=''
IF (A) THEN CRT 'TRUE' ELSE CRT 'FALSE'   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.

I have found this useful in coding.

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, August 01, 2013 4:40 AM
To: 'U2 Users List'
Subject: Re: [U2] What is true

To clarify

In multivalue, True is not False, where False is anything that is 'falsy'
i.e. zero or empty.
Obviously different than other languages, notably those where true is -1 (all 
bits set on a signed integer).

So:

A = HELLO
IF A THEN CRT A : WORLD

Gives HELLO WORLD

Regarding file variables, the best way to check for these being assigned on 
UniVerse is to use FILEINFO().

If FileInfo(SomeUnassignedVariable, 0) Then
   Crt This is an open file variable
End Else
   Crt This isn't
End

Brian


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Signature Capture and use

[Tom Whitmore]

Hi,
We use VeriFone's Payware and VeriSheld products with HostAccess.  This 
accomplishes several things for us:
1) all the credit card information is encrypted at the device and is sent to 
Payware encrypted.  This takes the server out of PCI scope, and can take the 
register out of PCI scope.
2) Our coding is limited to the forms, and talking to VeriFone.
3) We selected HostAccess because it had the hooks we needed to call VeriFone's 
DLL.
4) VeriFone sends only PCI approved data to the server, including the 
signature.

Taking the server and potentially 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 signature pad capture to a 
 Universe system.  What are you using and doing?
 I'd like to look into adding that feature to our jail system.
 --
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi Mecki,

One think that I always do with BDT is right-click on the program, select 
refresh, then open the program.  That seems to be the only way to make sure I 
have the current version.

Currently, BDT is sort of working with PRC but it isn't honoring file 
ownership so I'm unable to let the programmers use BDT.  You do need to get 
some programs from Susan for things to work as I have it now.  I'm told the 
latest version of PRC supports BDT.  We are currently testing the new version 
of PRC but I haven't had an opportunity to try BDT on this version.. 

As far as false errors, the latest version of BDT is greatly improved.  
However, I have noticed couple of false errors:
1) if the numeric subroutine label does not have a : BDT doesn't recognize 
the label (like 99*).
2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT 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-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Thursday, June 06, 2013 12:06 PM
To: U2 Users List
Subject: [U2] How do I get the U2 Metadata Manager to work

Ever since we finally upgraded UniData at work I have been trying out the new 
tools and don't seem to have much fun with them.
The best one is XAdmin and I use it a lot these days.

IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and 
you can't do much about that.
The BDT is not of much use since I need to make tweaks of the program using AE 
(even if it only to make PRC work) but when I then open it again in BDT it 
reverts to the old version. Looks like it keeps that in memory on my PC so any 
changes made on the server are lost.
Looks nice and shiny but the syntax check isn't really working either. 
99% of the errors shown turn out to be no errors at all.

The latest one I tried is the Metadata Manager.
It installed fine and I can connect to the server and the database no problem.
I can see the files and the dictionaries and can even change data on the server 
but that's it.
The metadata tools I want to use are all greyed out, so what am I doing wrong?

As stated in the Help I ran MIGRATE.SQL on the server but all I achieved is 
that I now cannot change anything using the old Avante Batch Schema Generation 
process. It goes through the motions but just hangs up at the end now.

So at the end I am not overly impressed.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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: U2 Users List
Subject: Re: [U2] Relative Path for SET.INDEX in Universe

Rick,

Don't know if you got your question about relative index answered, but this was 
from a post I made back in 2007:



IBM tech support just made me aware of an apparently undocumented 
feature that was added to SET.INDEX in release 10.1 allowing a relative path 
for the index file.

SET.INDEX  filename  TO  RELATIVE.PATH

This command will set the index pathname to ./I_filename eliminating the need 
to reset the index pathname when the files are copied, as long as the data file 
and index file are copied as a unit.  Similarly:

CREATE.INDEX  filename  indexname  AT  RELATIVE.PATH

Wanted to share this *very* nice enhancement.

Jeff Fitzgerald
Fitzgerald  Long, Inc.

---

Not too long after my post, Steve O'Neal made this post about a problem.
 Haven't tested lately to see if it's still a problem or not

---

There are, of course, caveats with everything.  You cannot add a second index 
after you make the first one, AT RELATIVE.PATH, in a typical fashion.  This 
would be necessary if you wanted indices with different characteristics, for 
example, with and without NO.NULLS.

This behavior occurs on AIX 5.3 and Windows XP at UniVerse 10.2

Case 422234*USA has been created.

C:\Accounts\bugs\IndexRelative2C:\ibm\uv\bin\uv
This directory is not set up for uniVerse.
Would you like to set it up (Y/N)?Y
 0. Ideal UniVerse compatibility
 1. IN2 compatibility
 2. Prime Information compatibility
 3. PICK compatibility
 4. PI/open compatibility
 5. Microdata Reality compatibility


Which way do you wish to configure your VOC ? 0 Your VOC is configured for 
Ideal UniVerse compatibility Creating file VOC as Type 3, Modulo 23, 
Separation 4.
Creating file D_VOC as Type 3, Modulo 2, Separation 1.
Loading your VOC file.  (Each * = 10 records.)

Loading your D_VOC file.  (Each * = 10 records.)
*
Creating file SAVEDLISTS as Type 1.
Creating file D_SAVEDLISTS as Type 3, Modulo 1, Separation 2.
Added @ID, the default record for RetrieVe, to D_SAVEDLISTS.
Creating file VOCLIB as Type 2, Modulo 7, Separation 4.
Creating file D_VOCLIB as Type 3, Modulo 1, Separation 2.
Added @ID, the default record for RetrieVe, to D_VOCLIB.
UniVerse Command Language 10.2
(c) Copyright IBM Corporation 2006. All rights reserved.
IndexRelative2 logged on: Thu May 17 10:16:49 2007

CREATE.INDEX VOC F2 AT RELATIVE.PATH
CREATE.INDEX VOC F1 AT RELATIVE.PATH

Unable to open index map C:\Accounts\bugs\IndexRelative2/VOC/INDEX.MAP
for rea
d/write,CREATE.INDEX VOC F1

Unable to open index map C:\Accounts\bugs\IndexRelative2/VOC/INDEX.MAP
for rea
d/write,
---

Hope this helps!

Jeff Fitzgerald
Fitzgerald  Long, Inc.
www.fitzlong.com


On Tuesday, May 7, 2013, Rick Nuckolls wrote:

 Has anyone else used relative paths for Universe indexes?  Perry, if 
 you remember what problems you had, please get back to me!

 Thanks,
 Rick

 On May 7, 2013, at 6:38 AM, Perry Taylor 
 perry.tay...@zirmed.comjavascript:;
 wrote:

  Tried it at 10.3.9 and there were some problems.  I don't recall 
  exactly
 what it was but I had to revert back to absolute pathing.
 
  Perry
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto:
 u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Rick 
 Nuckolls
  Sent: Monday, May 06, 2013 1:59 PM
  To: 'U2 Users List'
  Subject: [U2] Relative Path for SET.INDEX in Universe
 
  I was told, at one point, that it was possible to use a relative 
  path in
 the SET.INDEX command for UV.
 
  If anyone knows that syntax, please advise!
 
  Thanks,
  Rick Nuckolls
  Lynden Inc
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org javascript:; 
  http://listserver.u2ug.org/mailman/listinfo/u2-users
 
  CONFIDENTIALITY NOTICE: This e-mail message, including any 
  attachments, is for the sole use of the intended recipient(s) and 
  may contain confidential and privileged information.  Any 
  unauthorized review, use, disclosure or distribution is prohibited. 
  ZirMed, Inc. has strict policies regarding the content of e-mail 
  communications, specifically Protected Health Information, any 
  communications containing such material will be returned to the 
  originating party with such advisement noted. If you are not the 
  intended recipient, please contact the sender by reply e-mail and 
  destroy all copies of the original message.
  ___
  U2-Users mailing list
  U2-Users

Re: [U2] select query..

[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.NAME RTNLIST sellist CAPTURING junk

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Wednesday, May 15, 2013 7:19 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] select query..

Manu Fernandes efv at infodata.lu writes:


 
 Hi
 
 Do you have wildcard characters like [] into KEYVALUE ?
 If not, why do you SELECT ; it's the key of file.name ; you can read 
directly !
 
 Elsewhere, For performance, set a index on the  at id
 
 Why do you want to use save-list/get-list ? 
 You can work on LIST1 directly !
 
 manu 


Hi Fernandes, 

Thanks for your comments. But as Im new to this technology Im not sure how 
to proceed with your suggestions. 

Can u please be more specific on this approach?

There is no [] symbols in the KEYVALUE. How do I check whether @ID is 
indexed?

I will modify it with using LIST1 directly.

Thanks  Regards,
Sathya V.




Hi Experts..

I have one issue here with fetching data from the file.

EXECLINE = SELECT FILE.NAME WITH  at ID = \:KEYVALUE:\
DISPLAY EXECLINE
EXECUTE EXECLINE RTNLIST LIST1
EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1

LIST.NAME = GET-LIST SOME.LIST
sellist = ''
EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk

Here Im running a loop for a set of KEYVALUEs and for each run the 
SSELECT
statement is taking around 30 seconds. When I want to run 1000 loops, 
ideally
the run time will be much.

Is there any easier way to do this with less time consumption.

Thanks  Regards,
Sathya V.

___
://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Help needed..

[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 SOURCE.FN ELSE EXIT
  ROW=CONVERT(CHAR(9),ATFM,ROW)
  WRITE ROW TO F.XXX,KEY
   REPEAT

If the file isn't a type 1 or 19 then use the REMOVE function on the internal 
array.  It is very fast.
An example is:
   READ TXT.REC FROM F., KEY.TXT
   TXT.REC=TXT.REC
   LOOP
  REMOVE ROW FROM TXT.REC SETTING POS
   UNTIL ROW='' AND POS=0
  ROW=CONVERT(CHAR(9),ATFM,ROW)
  WRITE ROW TO F.XXX,KEY
   REPEAT
If you need to reprocess the array then add TXT.REC=TXT.REC and start the 
process again.  The reason is that assigning the array to itself will reset the 
internal pointer REMOVE uses to keep track of where it is.

One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text 
mark) so you need to know the data you are working with.

Tom
RATEX Business Solutions


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya
Sent: Tuesday, May 07, 2013 12:36 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Help needed..


Wjhonson wjhonson at aol.com writes:

 
 That's interesting John, but the del *does* in fact *shift* the entire 
array forward each time.
 It really does :)
 
 You can traverse without re-scanning by using the SELECT or SELECTV to 
transform the entire contents
 *once* into a type of Get List (it works try it!)
 
 You can then use a READNEXT to extract each row, without the need to 
rescan from the beginning, since
 READNEXT has always maintainted a pointer to where it left off.  It 
doesn't start at the front each time.


Hi 

I just used OSOPEN to open the file and the file is not getting 
recognized. 

Here is the piece of script I have used. 

OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file

Where FILE.NAME2 is the path and the file name. 

Also as suggested below, how could I use get list for a file which is 
opened from server. 

Thanks in Advance,
Sathya V. 


 
 -Original Message-
 From: Israel, John R. JohnIsrael at daytonsuperior.com
 To: 'U2 Users List' u2-users at listserver.u2ug.org
 Sent: Tue, Apr 30, 2013 9:27 am
 Subject: Re: [U2] Help needed..
 
 Here is some fast and loose code that I often use.
 
 READ TXT.REC FROM F., KEY.TXT
 LOOP
   ROW = TXT1
 WHILE ROW # 
   DEL TXT1  ;* Make the TXT file smaller and smaller 
and not traversing deeper 
 and deeper
   CONVERT CHAR(9) TO  at FM IN ROW
   KEY = ROW1;* extract the key out of the row
   DEL ROW1  ;* Remove the key from the row - all that 
is left is the record
   WRITE ROW ON F.XXX, KEY
 REPEAT
 
 JRI
 
 -Original Message-
 From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces 
at listserver.u2ug.org] 
 On Behalf Of Sathya
 Sent: Tuesday, April 30, 2013 11:21 AM
 To: u2-users at listserver.u2ug.org
 Subject: [U2] Help needed..
 
 Hi all,..
 
 I have a requirement here. Need guidance in doing that. Any help will be 
useful. 
 
 TIA.
 
 I have a flat file with tab delimited records and the file looks like 
below:
 
 abcd 1234
 cdef 3478
 ghae 6284
 ...
 
 I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch 
some 
 corresponding attributes from a file which has 'abcd' and 'cdef' as the 
key 
 values. Please let me know if this could be done. If yes any kinda basic 
 suggestions in doing that will be helpful. 
 
 Thanks again,
 Sathya V. 
 
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
  
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi,
I was wondering what tools you use to export data to an SQL data warehouse from 
UniVerse.  This export could occur on multiple flavors of Unix.

What we would need to do is extract the UV data and perform some data 
translations before importing the data into the SQL table.

I know 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.org/mailman/listinfo/u2-users

Re: [U2] [UV] RESIZE INPLACE

[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).

Tom Whitmore
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, April 25, 2013 4:10 PM
To: U2-Users List
Subject: [U2] [UV] RESIZE INPLACE

Before I go and resize a 144GB file has anyone had any experiences with the 
INPLACE option of RESIZE in UniVerse?  Good, bad, ugly???

Thanks.
Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UD - Display Current Terminal Type

[Tom Whitmore]

Sorry, I thought it was available on both UV and UD.  It is a valid verb on UV:

GET.TERM.TYPE
Wyse Technology 50/60 (W)
Width : 127
Depth : 40

-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 9:09 PM
To: U2 Users List
Subject: Re: [U2] UD - Display Current Terminal Type

:GET.TERM.TYPE
Not a verb
  GET.TERM.TYPE
:version

 Module Name Version   Licensed

UniData RDBMS 7.3 Yes
Connection Pooling... 7.3 Yes
Device License... 7.3 Yes
NFA.. 7.3 No
RFS.. 7.3 No
EDA.. 7.3 No
733

Bill
Untitled Page



- Original Message -
*From:* tewhitm...@ratex.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*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 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
 Sent: Tuesday, April 23, 2013 5:12 PM
 To: U2 Mail List
 Subject: [U2] UD - Display Current Terminal Type

 I've had a brain-freeze and can't remember how to display the current 
 terminal type at ECL.  I know it's SYSTEM(7) but what ECL command do I need 
 to display it?

 TERM doesn't work (although I can set it by entering TERM WYSE60).
 PTERM doesn't work (it gives me all kinds of other things).

 Any help would be appreciated.

 Bill

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi,
Can you provide more information on what you are trying to capture? (edits, 
list commands, etc.)  I suspect that you may be able to put security on the 
commands you are concerned with and address the problem with less pain.

The problem with using the command stack or a COMO is 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 
provide 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 
bradley.sch...@usbank.com
Sent: Wednesday, April 24, 2013 5:06 PM
To: U2 Users List
Subject: Re: [U2] TCL input and response logging such as COMO

I can't speak for UV, but we've been required to log all sessions for specific 
powerful users. It becomes a little simpler if you do it for all users. Make 
sure you have some type of automated purge of whatever log files you create or 
you'll probably start filling up your file system. 

This is what we're doing under UD7.1. Nothing fancy.


We added this to our LOGIN:

PQ
HRUN DIR COMO.PROG
P


And here's what's in COMO.PROG

USERS = 'user1, user2, user3'
IF INDEX(USERS,@LOGNAME,1)  0 THEN
  FN = @LOGNAME:'_':@USERNO:'_':DATE():'_':TIME()
  DATA FN
  EXECUTE 'COMO ON'
END
U.S. BANCORP made the following annotations
-
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.



-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UD - Display Current Terminal Type

[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 List
Subject: [U2] UD - Display Current Terminal Type

I've had a brain-freeze and can't remember how to display the current terminal 
type at ECL.  I know it's SYSTEM(7) but what ECL command do I need to display 
it?

TERM doesn't work (although I can set it by entering TERM WYSE60).
PTERM doesn't work (it gives me all kinds of other things).

Any help would be appreciated.

Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] is this an INDEX ISSUE?

[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 on some files but other files have 
problems and we aren't doing anything special with the indexes that have 
problems (they are simple D or A type dictionaries)
Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins
Sent: Saturday, April 13, 2013 3:30 AM
To: david yu; U2 Users List
Cc: u2-users@listserver.u2ug.org
Subject: Re: [U2] is this an INDEX ISSUE?

Was the file open to a UniVerse session! Or we're you EXECUTING the RESIZE from 
a process that had the file open? The latter can cause issues -close the file 
first. If it's AIX and you are running multiple UniVerse shells from crown tab 
as foreground tasks (I.e. not as phantoms or by using executive) at the same 
time it could be relevant too.

Regards

JayJay

On 13 Apr 2013, at 00:46, david yu d...@yahoo.com wrote:

 hello,
  
 We have a file that is updated almost every minute for transportation 
 appointment, we index a field in a file to make the reporting much faster but 
 recently we noticed when we ran the report not all the transportation appt 
 shows up on the report, so customer doesnt get their transportation. We have 
 been rebuilding the index every night but problem still exists. Anyone 
 encounter this issue? we are on HP-UX b.11.23.
  
 thanks in advance.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi,
Be aware, the date last run is a static date.  You would need to rerun the 
MAKE.MAP.FILE to get it refreshed.

The only way I know to obtain the information you are looking for is to do the 
following:
LOGTO UV
SH
cd catdir
ls -l

For a specific program you would append a 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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, April 09, 2013 4:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Ref: Is there anything built in to UV that contains when/who 
last

This is interesting in that it includes the number of times the program has 
been run since being catalogued
But although it contains the date it was last accessed doesn't actually 
contain the date it was catalogued!

So it can definitely answer a query like Is this still being used?
Which could be useful for cobweb removal.

But it cannot answer Who compiled this or Who last touched it

 

 

 

-Original Message-
From: Cooper, Rudy rudy.coo...@sagepub.com
To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
Sent: Tue, Apr 9, 2013 1:49 pm
Subject: [U2] Ref: Is there anything built in to UV that contains when/who last


Do a help on the tcl command MAKE.MAP.FILE.  That may be able to help you.



Is there anything built in to UV that contains when/who last


Are you a fan of SAGE? Show us at www.facebook.com/SAGEPublications.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] User cannot login

[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 account they are case 
sensitive, they need to be identical to how they are defined on the AD.   

If you are interested, I have an old document I wrote for UniAdmin for our 
customers.

Good luck!

Tom
RATEX Business Solutions.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, March 11, 2013 5:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] User cannot login

There's some kind of setting in Windows that allows the domain to be discarded 
when on the same domain... or something.  I'm not sure, maybe there's a Windows 
guru on here.


 

 

 

-Original Message-
From: Holt, Jake jh...@samsill.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Mar 11, 2013 2:00 pm
Subject: Re: [U2] User cannot login


I've tried it in the past, but doing it again made me consider something else 
and it worked.

If I use domain\username it works...

Must be something strange with his AD account.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, March 11, 2013 3:53 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] User cannot login

This has nothing to do with Universe.  It's a windows issue alone.
Reset their password to something like TEST and then try it yourself first. 
Before you tell them to try it.


 

 

 

-Original Message-
From: Holt, Jake jh...@samsill.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Mar 11, 2013 1:48 pm
Subject: Re: [U2] User cannot login


It just acts like the password is invalid:

Welcome to the IBM UniVerse Telnet Server.  

Enter user name: calvinr   
Enter password:

Invalid domain/user/password.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, March 11, 2013 3:37 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] User cannot login

Describe more what happens when they *try* to login.
 

 

 

-Original Message-
From: Holt, Jake jh...@samsill.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Mar 11, 2013 1:33 pm
Subject: [U2] User cannot login


I have a user, one of my system admins, that cannot login to Universe.
Their user account is setup exactly like mine, there is no voc entry for the 
user and I have deleted and recreated the user a couple times just today.

Is there anything else I can look at that would be preventing the him from 
logging in? 

We're running 10.0.21 on windows server 2003. 

Thanks,


Jake Holt l samsill l Information Technology Director
(817) 536 - 1906 x 217 l jh...@samsill.com www.samsill.com


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi,
You didn't identify the OS.  Here are a few examples of how you can see if 
there is a copy on your system:

   On Linux use locate (in Unix shell)
 locate A26.ISS.EMPLOYMENT
   On other flavors of Unix you will need to be root, and use the find 
command. (in Unix shell).  Find will work for Linux as well but it is slower.
 Find / -name A26.ISS.EMPLOYMENT -print

Sorry, I don't know the DOS command for Windows but you can do a search from 
the desktop.

The other thing is to look at the date time stamp of the object code and see if 
you have 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: Re: [U2] How do I find the code?

It might be a non-runnable command.
Have you tried to actually RUN this to see if it complains that the code is 
missing?


 

 

 

-Original Message-
From: Greg Coelho coe...@american.edu
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Mar 5, 2013 6:19 pm
Subject: Re: [U2] How do I find the code?


Can't seem to find it in either WBP.O or WBP.OBS (I do have a VOC listing for 
WBP.OBS). 



From:   Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org, 
Date:   03/05/2013 09:06 PM
Subject:Re: [U2] How do I find the code?
Sent by:u2-users-boun...@listserver.u2ug.org



Then Greg I suggest someone has stripped the source, and left you with 
only the object.
You can do
ED WBP.O A26.ISS.EMPLOYMENT
to verify that it exists, but DO NOT LIST IT
it will screw up your terminal emulator software most likely if you 
display the object code
ED only gives you Top, then you can do EX right away

 

 

 

-Original Message-
From: Greg Coelho coe...@american.edu
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Mar 5, 2013 5:52 pm
Subject: Re: [U2] How do I find the code?


Unfortunately that was one of the first things I tried...

:AE WBP A26.ISS.EMPLOYMENT 
Top of New A26.ISS.EMPLOYMENT in WBP. 
*--: P 
Top. 
Top of new record. 

It looks like A26.ISS.EMPLOYMENT doesn't live in WBP.

Greg



From:   Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org, 
Date:   03/05/2013 07:51 PM
Subject:Re: [U2] How do I find the code?
Sent by:u2-users-boun...@listserver.u2ug.org



You have a file called WBP so

ED WBP A26.ISS.EMPLOYMENT



 

 

 

-Original Message-
From: Greg Coelho coe...@american.edu
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Mar 5, 2013 4:50 pm
Subject: Re: [U2] How do I find the code?


All,

I am not versed in (PQ) PROC.  Can anybody tell where I have to go to find 


the code for A26.ISS.EMPLOYMENT?

:AE VOC A26.ISS.EMPLOYMENT 
3 lines long. 
 
: P 
0001: PQ 
0002: HRUN WBP A26.ISS.EMPLOYMENT 
0003: P 
Bottom at line 3. 

As Always, THANKS!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Retirement and knowledge transfer

[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 and knowledge transfer

John Thompson wrote: I have heard of a couple of folks retiring at Rocket.  I 
hope you guys passed on all your great knowledge of the DBMS' internals :)

Absolutely. One of my primary activities since the first of the year was 
delivering technical presentations to the U2 support engineers and sales 
engineers - world-wide. In addition to that, I've been writing. The following 
Rocket Tech Notes have been published in the Rocket Solutions portal (entitled 
access). There are a few more out for review and editing that will be published 
before I leave. 

UDT-9311: Debugging UniData UNIX Segmentation Violations  Core Dumps
UDT-22: UniData Data Replication Operations Guide v4.1
UDT-9507: Detecting and Repairing UniData File Corruption
UDT-9509: Understanding and correcting the memresize error: overflow file is 
goo big(2G) in mem_get_blk()

Just had my 22nd anniversary with UniData / Ardent / Informix / IBM / Rocket. 
It has been a rewarding run.
Regards,

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com

Rocket U2 Support: +1.800.729.3553
** Please note that I am only available on Tuesdays and Wednesdays. **


I have heard of a couple of folks retiring at Rocket.  I hope you guys passed 
on all your great knowledge of the DBMS' internals :)

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UV full screen editor

[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 which works for 
you.  I have not figured out how to edit data with BDT, only programs and 
dictionaries.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nirvan Wijesekera
Sent: Monday, February 25, 2013 9:04 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV full screen editor


Hello all,
 
I'm new to this forum, so apologies if this topic has been brought up before. 
Can anyone recommend a decent full-screen editor for Universe? I require it for 
editing source code as well as modifying data files. Seems like most of them 
can do one or the other, but not both. We do not run System Builder, so is 
there anything else available? We are trying to move away from the native UV 
line editor.
 
Many thanks.  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] fnuxi error

[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 21, 2013 3:05 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] fnuxi error

Universe 10.3.9 Linux (Red Hat)

Anyone seen this before?

[root@cubs6 CUB]# fnuxi TX.TMF
Processing 'TX.TMF'.
File 'TX.TMF' is an SQL file and may not be fnuxi'ed.

More importantly what can I do to fix it?

Thanks
-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] : Evaluating DCOUNT

[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 a new field 
delimited string using -1.  The program took about 15 minutes to perform the 
tasks needed.  I then raised each string, used remove and concatenated 
@FM:item.  It was done almost immediately, there was no perception of a delay 
getting to TCL.  To put it in code snippet, the first took 15 minutes and the 
second took maybe a second.

X=20K values
Y=20K values
Z=''
MAX=DCOUNT(X,@VM)
FOR C=1 TO MAX
   I1=X1,C
   I2=Y1,C
   ZC=I1*I2
NEXT C


X=RAISE(20Kvalues)
Y=RASE(20Kvalues)
Z=''
LOOP
   REMOVE I1 FROM X  SETTING XPOS
   REMOVE I2 FROM Y SETING YPOS
UNTIL I1='' AND I2='' AND XPOS=0 AND YPOS=0
  IF (Z) 
  THEN Z:=@AM:I1*I2
  ELSE Z=I1*I2
REPEAT

There are several things:
1) REMOVE is faster than extract, especially when you are working with values
2) Strings are treated different from dynamic arrays even though in theory you 
are doing the same thing (appending to the end of the string).
3) COUNT will scan the string, then the extract will scan the string when it is 
value delimited.  Field marks are indexes so the first scan resolves the 
location where each field begins.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Tuesday, February 12, 2013 1:21 PM
To: 'U2 Users List'
Subject: Re: [U2] : Evaluating DCOUNT

Hey Allen,

The REMOVE so fast How fast is it?! Match Game throwback that I suspect the 
time it takes to interpret the difference between a VM and AM is negligible. I 
could be wrong.

And as far as using dimensioned arrays, agreed. They do seem to improve speed 
... but still not in comparison to the REMOVE virtual bow to the REMOVE god.

Sincerely,
David Laansma
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Monday, February 11, 2013 9:02 AM
To: U2 Users List
Subject: Re: [U2] : Evaluating DCOUNT

David,

You're correct that the remove is faster, and it is because it maintains an 
internal pointer to the next item, as opposed to positioning to it for each 
reference.

And I'm pretty sure that you can make it run even faster with:
LINE.KEYS = RAISE(HEADER.REC200)

As a matter of preference, I would set D1 to 999 or some other numeric value 
rather than a null, only because Universe/Unidata is typeless, and I would be 
afraid that the null, (), might be treated as a zero; but that's just 
personal fear and preference not based on a horror story.


On 2/11/2013 8:30 AM, Dave Laansma wrote:
 I would HOPE that it evaluates it each time since the size of array could 
 change within the loop.
 
 Personally if the size of array is relatively small, DCOUNT is alright. 
 However I've found REMOVE to be EXTREMELY faster and therefore use it 
 whenever possible, even on small arrays.
 
 For example, we have two files, a 'header' and 'detail' file. The keys to the 
 'detail' file are stored in attribute 200 of the header file. So I'll pull 
 the keys out of the header record, such:
 
 LINE.KEYS = HEADER.REC200
 D1 = 
 LOOP UNTIL D1 = 0
   REMOVE LINE.KEY FROM LINE.KEYS SETTING D1
   loop statements
 REPEAT
 
 As opposed to:
 
 FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM)
   LINE.KEY = HEADER.REC200,V1
   loop statements
 NEXT V1
 
 Based on historical dialogs on this subject on this forum, I have seen an 
 improvement in overall performance.
 
 Sincerely,
 David Laansma
 Hubbard Supply Co.
 Direct: 810-342-7143
 Office: 810-234-8681
 Fax: 810-234-6142
 www.hubbardsupply.com
 Delivering Products, Services and Innovative Solutions
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey 
 Butera
 Sent: Monday, February 11, 2013 7:55 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] : Evaluating DCOUNT
 
 On 02/11/2013 12:14 AM, Peter Cheney wrote:
 Hi Everyone,

 Does a DCOUNT get evaluated again for each iteration of a loop?
 Or is UniVerse these days intelligent enough to keep track of what's going 
 on?

 e.g.

 for i = 1 to dcount(array,@fm)
 *commands here
 next i

 versus

 totalattributes = dcount(array,@fm)
 for i = 1 to totalattributes
 *commands here
 next i

 Apart from readability and perhaps easier debugging is there an actual 
 internal difference?
 I know it was an issue on older pick releases but I cannot remember if it 
 ever affected UV?
 
 Not sure about universe, but unidata defintely checks

Re: [U2] : Evaluating DCOUNT

[Tom Whitmore]

My understanding is that UniVerse keeps track of the location of each attribute 
the first time is hits an attribute.  U2 support will need to provide a 
definitive answer.  

I do know that we have found field marks are measurably faster than value 
marks, and concatenating strings is measurably 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-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, February 12, 2013 3:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] : Evaluating DCOUNT

Yes it keeps track of the position of the current field (only), not each field.
It's not indexed.  Its just a one value pointer.

 

 

 

-Original Message-
From: Wols Lists antli...@youngman.org.uk
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, Feb 12, 2013 12:16 pm
Subject: Re: [U2] : Evaluating DCOUNT


On 12/02/13 19:04, Wjhonson wrote:
 Correct me if I'm misunderstanding you Tom, but you said that field 
 marks are
indexes so the first scan resolves where each field begins. That is not 
correct, at least not literally.
 
 Count or Raising or Lowering or Scanning in general will not create an 
 index
to the position of any fields.
 The Remove maintains *A* (singular) pointer to where it's at, right 
 now, as it
moves along.
 It's not a fully indexed string.  There's just a current position pointer.  
One.
 
The thing here, is Tom said he used for/next, and not remove. Just as remove 
keeps track of the current position in the string, so does
*field* access in a dynamic array!

So the original program had to scan the multi-value variable every single time 
round the loop. SLOW. The revised program, using RAISE, was scanning a 
multi-*field* variable, and BASIC's internal optimiser kept track of the 
current field. Effectively increasing the speed to pretty much the same as 
using REMOVE.

Cheers,
Wol
 
  
 
  
 
  
 
 -Original Message-
 From: Tom Whitmore tewhitm...@ratex.com
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Tue, Feb 12, 2013 10:43 am
 Subject: Re: [U2] : Evaluating DCOUNT
 
 
 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 a new field delimited string using -1.  The program took 
 about 15 minutes to perform the

 tasks needed.  I then raised each string, used remove and concatenated
@FM:item.  
 It was done almost immediately, there was no perception of a delay 
 getting to TCL.  To put it in code snippet, the first took 15 minutes 
 and the second took

 maybe a second.
 
 X=20K values
 Y=20K values
 Z=''
 MAX=DCOUNT(X,@VM)
 FOR C=1 TO MAX
I1=X1,C
I2=Y1,C
ZC=I1*I2
 NEXT C
 
 
 X=RAISE(20Kvalues)
 Y=RASE(20Kvalues)
 Z=''
 LOOP
REMOVE I1 FROM X  SETTING XPOS
REMOVE I2 FROM Y SETING YPOS
 UNTIL I1='' AND I2='' AND XPOS=0 AND YPOS=0
   IF (Z) 
   THEN Z:=@AM:I1*I2
   ELSE Z=I1*I2
 REPEAT
 
 There are several things:
 1) REMOVE is faster than extract, especially when you are working with 
 values
 2) Strings are treated different from dynamic arrays even though in 
 theory you

 are doing the same thing (appending to the end of the string).
 3) COUNT will scan the string, then the extract will scan the string 
 when it
is 
 value delimited.  Field marks are indexes so the first scan resolves 
 the location where each field begins.
 
 Tom
 RATEX Business Solutions
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org]

 On Behalf Of Dave Laansma
 Sent: Tuesday, February 12, 2013 1:21 PM
 To: 'U2 Users List'
 Subject: Re: [U2] : Evaluating DCOUNT
 
 Hey Allen,
 
 The REMOVE so fast How fast is it?! Match Game throwback that I 
 suspect
the 
 time it takes to interpret the difference between a VM and AM is 
 negligible. I

 could be wrong.
 
 And as far as using dimensioned arrays, agreed. They do seem to 
 improve speed ... but still not in comparison to the REMOVE virtual bow to 
 the REMOVE god.
 
 Sincerely,
 David Laansma
 Hubbard Supply Co.
 Direct: 810-342-7143
 Office: 810-234-8681
 Fax: 810-234-6142
 www.hubbardsupply.com
 Delivering Products, Services and Innovative Solutions
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org]

 On Behalf Of Allen Egerton
 Sent: Monday, February 11, 2013 9:02 AM
 To: U2 Users List
 Subject: Re: [U2] : Evaluating DCOUNT
 
 David,
 
 You're correct that the remove is faster, and it is because it 
 maintains an internal pointer to the next item

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

[Tom Whitmore]

Hi  Doug,
We use UniVerse instead of UniData, but I understand the tools are the same.  
You do not need to be on the same subnet or network, but you do need access to 
the subnet/network  for the RPC port.  I have successfully connected to 
external servers without a problem, you may need to use an IP address rather 
than the host name but that depends on how you have things configured.

I would strongly recommend that you use a VPN or a gateway to access your 
server, this keeps your sever and network secure.  I think using VPN is easier 
to use with the admin tools than setting up a 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 5.3 Stops Unexpectedly

To use that tool, he would have to be on the same subnet/network as the server 
(i.e. he would have to vpn into their system, or remote desktop/vnc/etc into a 
system they have over there that had the admin tool installed).

Having said that I think that's a great idea, the customer could setup a 
windows system with the admin tool installed and logmein/gotomypc/etc 
(which would NOT require vpn access)  so that he could access the system 
remotely and run uniadmin

Dougc
   

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Monday, January 21, 2013 11:52 AM
To: U2 Users List
Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly

Didn't you get Unidata admin tools? You can connect to the server with it and 
look at all the locks, files and configs with the one tool.

Thank You

Robert Frailey
Manager Information Systems
Utah Medical Products Inc.
Femcare-Nikomed Ltd.
rfrai...@utahmed.com
801-569-4016


- Original Message -
From: Kevin King ke...@precisonline.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Saturday, January 19, 2013 12:16 PM
Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly


 Usually we can still telnet into AIX.  That's how I'm running the 
 stopud/startud.  This errpt command is new to me but thanks to 
 everyone for that input; that should be very valuable.

 I still wish there was some way we could do a LIST.READU from AIX 
 without having to login to udt, like listuser but for locks.  I don't 
 know if an overflowed lock table is even remotely related to the 
 problem, but it would be nice to be able to check it without having to 
 get to TCL.

 -K

 On Fri, Jan 18, 2013 at 10:49 AM, doug chanco d...@chancofamily.com
 wrote:

 That was my question as well, do you telnet or ssh into the box?  
 Once you login su over to root and do

 errpt -aD

 this will give you short listing of all the errors aix has logged and 
 consolidates duplicate errors (see below for an example)

 LABEL:   STOK_RCVRY_EXIT
 Date/Time:   Tue Dec 14 15:25:33
 Type:TEMP
 Resource Name:   tok0
 Description
 PROBLEM RESOLVED
 Detail Data
 FILE NAME
 line: 273 file: stok_wdt.c
 SENSE DATA
      
 DEVICE ADDRESS
 0004 AC62 25F1

 My aix sysadmin days are way behind me  but I am willing to bet that 
 the company has a aix support contract and you could contact them to 
 help with any errors found.


 dougc



 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
 Sent: Friday, January 18, 2013 12:33 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly

 On 18/01/13 03:18, Kevin King wrote:
  Peter, I'm 1200+ miles away from the box.  Getting to the console 
  is not an option.  To restart, I've been forcing Unidata down with 
  stopud -f and starting it again with startud.  Yeah, drastic, I 
  know.  But that's why I'm looking for better ways.

 How do you get to the box to do a stopud/startud?

 This implies AIX is up and responding. So it shouldn't be too hard to 
 open a remote session at the AIX level to find out what is going 
 wrong.
 Not that I can advise how to do it ...

 Cheers,
 Wol
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http

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

[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  September 28th.

This is a cumulative update release and includes the following version 
updates...

September  2012
   U2 Extensible Administration Tool 3.10.4
   U2 Basic Developer Toolkit 3.0.3

August  2012
U2 Extensible Administration Tool 3.10.3
U2 Web Services Developer 3.20.2 (continued a fix from June 
2012 release)

July 2012
U2 Basic Developer Toolkit 3.0.2

June 2012
U2 RESTful Web Services Developer 3.60.3
U2 Web Services Developer 3.20.2

May 2012
U2 Metadata Manager 3.70.1

April 2012
Extensible Administration Tool 3.10.2
U2 RESTful Web Services Developer 3.60.2

File name(s) posted to the U2BC FTP site:
N/A

For details on this update, point your browser to 
http://updates.rocketsoftware.com/u2 .  Please note that you must have the 
March 2012 version of the DBTools installed as a prerequisite to install from 
the U2 Update Site.

To install updates for U2 DBTools products, you must first add the U2 Update 
Site to your list of Eclipse update sites by following these steps...

1.  Launch any of the U2 DBTools installed on your machine
2.  From the Eclipse Help menu, select Install New Software...
3.  Click Add...
4.  Enter a name for the site as U2 Update Site and in Location enter 
http://updates.rocketsoftware.com/u2; and click OK
5.  Allow the repository to load, expand the tree for U2 DB Tools and 
select the updates you wish to apply
NOTE: For April 2012, only XAdmin and U2 RESTful Web Services Developer contain 
updates
6.  Click Next and follow the installation wizard to complete the 
installation of updates
7.  Updates will take effect the next time an updated tool is launched

This release has been certified for the following versions of the operating 
system(s): 
Same platforms as supported in the full March 2012 DB Tools release.

Additional information:
 Compilers Used:Eclipse 3.5.2, Oracle Java SDK 1.6

For product availability questions, please send an e-mail to:  
u2as...@rocketsoftware.com


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Friday, November 30, 2012 2:11 PM
To: U2 Mail List
Subject: [U2] U2 Product Release: U2 DBTools vNOV2012

Now that I look here, I guess this isn't the source for the vNOV2012 Clients 
and the vNOV2012 DB Tools release.  :-(

Bill

Untitled Page

- Original Message -
*From:* wphask...@advantos.net
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 11/30/2012 11:03 AM
*Subject:* Re: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012
 Many, many thanks!  :-)

 I'll bookmark this.

 Bill

 --
 --
 - Original Message -
 *From:* ma...@afsi.com
 *To:* U2 Users List u2-users@listserver.u2ug.org
 *Date:* 11/30/2012 9:33 AM
 *Subject:* Re: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012
 http://u2.rocketsoftware.com/resources/downloads

 
 From:u2-users-boun...@listserver.u2ug.org  
 [u2-users-boun...@listserver.u2ug.org] on behalf of Bill Haskett 
 [wphask...@advantos.net]
 Sent: Friday, November 30, 2012 10:18 AM
 To: U2 Mail List
 Subject: [U2] Fwd: U2 Product Release: U2 DBTools vNOV2012

 Trying to find the download link on the U2 site is like trying to 
 find a needle in a haystack!  Anyone have an idea specifically where 
 to get these links (I did get the readme)?

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Wednesday, October 24, 2012 6:17 PM
To: U2 Users List
Subject: Re: [U2] [BDT] A giant leap forward

Thank you, it's always great to hear when we've hit the mark.

I've sent this off to the team members responsible.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 24, 2012 3:55 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [BDT] A giant leap forward

I would like to *commend*, yes commend, the developers of the Basic Developers 
Toolkit for recent changes.

In particular, the ability to *install updates* from within the Eclipse package.
In conjunction with the *detailed release notes* highlighting changes in each 
version, for example July's here:

http://updates.rocketsoftware.com/u2/July2012_ReleaseNotes.htm


It's quite useful to be able to read the release notes and try out the fixed 
features ___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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.u2ug.org] On Behalf Of Dianne Ackerman
Sent: Wednesday, October 17, 2012 3:02 PM
To: U2 Users List
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL

That's a neat trick, I always assumed that you would have to write the 
paragraph out to the VOC and then execute it.   I like this! Thanks.
-Dianne


On 10/17/2012 2:45 PM, David A. Green wrote:
 And to do this from UniBasic:

 CMD = 
 CMD-1 = PA
 CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1
 CMD-1 = IF @SYSTEM.RETURN.CODE  1 THEN GO THE.END
 CMD-1 = SELECT PEOPLE TO 2
 CMD-1 = IF @SYSTEM.RETURN.CODE  1 THEN GO THE.END
 CMD-1 = MERGE.LIST 2 DIFF 1
 CMD-1 = THE.END:
 EXECUTE CMD

 David A. Green
 (480) 813-1725
 DAG Consulting


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry 
 Hiscock
 Sent: Wednesday, October 17, 2012 10:54 AM
 To: 'U2 Users List'
 Subject: Re: [U2] Selection Suggestions for using UV instead of SQL

 select registration with EID = '1' saving unique PID to 1 select 
 people to 2 merge.list 2 diff 1

 Larry Hiscock
 Western Computer Services

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George 
 Gallen
 Sent: Wednesday, October 17, 2012 6:59 AM
 To: U2 Users
 Subject: [U2] Selection Suggestions for using UV instead of SQL

 Ok.

 I have file1 - people that has @ID of PID I have file2 - registration
 that has @ID of PID+EID+RID  (EID = event id,  RID = registration id)

 I want to select people who are not in the registration file with an 
 EID of 1.

 With an SQL statement - I could join the two, then do the select or 
 use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just 
 curious how this could be done with UV Native, and without involving a 
 program.

 I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID 
 - NSELECT PEOPLE

 But that returned 0 - since the NSELECT only works off the current 
 select list, not the whole file

 Yes, I could create a temporary file, then select off that Yes, I 
 could read each people record, then loop through registration to see 
 if it doesn't exist.
 Both of the above require programming
 I guess I could create a subroutine that does the looping through 
 registration, and put that into an I descriptor - looking for another 
 option.

 George



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] PI/UV: Decompiler

[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
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Tuesday, August 28, 2012 8:18 AM
To: U2 Users List
Subject: Re: [U2] PI/UV: Decompiler

I don't know of any UniData UniBasic object code decompiler utilities. 
Certainly none ever created by the UniData engineering team.

Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert
Sent: Monday, August 27, 2012 8:37 PM
To: U2 Users List
Subject: Re: [U2] PI/UV: Decompiler

Does anyone know how to find out more information about 'IBM's compiler'?
(see http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg10843.html )

Does anyone know where to locate a decompiler (or decompiler service) for 
UNIBASIC (UNIDATA BASIC)?

Does anyone know how to access the 'free decompiler that Universe provides'?
*Why would I pay to use the SRS for my PI/open recovery when I can use the free 
decompiler that UniVerse provides?*  
http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the%20SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20free%20decompiler%20that%20UniVerse%20provides?
(see 
http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the%20SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20free%20decompiler%20that%20UniVerse%20provides?
 ) (or just see http://www.srs4uv.com/faq.htm and look for *Why would I pay to 
use the SRS for my PI/open recovery when I can use the free decompiler that 
UniVerse provides?*  
http://www.srs4uv.com/faq.htm#Why%20would%20I%20pay%20to%20use%20the%20SRS%20for%20my%20PI/open%20recovery%20when%20I%20can%20use%20the%20free%20decompiler%20that%20UniVerse%20provides?)

Robert Norman
.
ROBERT NORMAN AND ASSOCIATES
Address: 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 Phone  : 
951/541-1668 Email  :i...@keyway.net Website:http://users.keyway.net/~ice/
[Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse 
Basic, UniBasic, R/BASIC, jBC]

-Original Message-

RE: [U2] PI/UV: Decompiler

Gyle Iverson
Thu, 18 Aug 2005 18:37:56 -0700


AD
When you need to recover the BASIC source code for PI/open or UniVerse systems, 
your ultimate source is found at www.srs4uv.com. The srs4uv team has helped 
companies, government agencies and learning institutions around the globe with 
their source recoveries for over 22 years. Many srs4uv customers tried IBM's 
PI/open decompiler beforehand and seem amazed at how easy the recovered 
programs are to read and maintain.
/AD

While the PI/open decompiler provided by IBM was a technically accurate 
utility, the maintainability of their recovered source code leaves much to be 
desired. IBM's decompiler failed to perform logical structure recovery, the 
most important quality, as this impacts the long-term maintainability of the 
programs. (There are other deficiencies with IBM's decompiler, such as, 
maintainable common member naming, reversing equated variable expressions, and 
recovering programs with certain internal-use statements. Please contact me 
directly for additional information on these PI/open recovery issues.)

The logical structure for LOOP-REPEAT, FOR-NEXT and CASE statements, like 
IF-THEN-ELSE statements, are translated by a BASIC compiler into conditional 
and unconditional branch instructions. IBM's PI/open decompiler took the 
lazy-mans approach to decompiling, returning conditional branches as IF-THEN 
statements and unconditional branches as GOTO statements. As you might imagine, 
IBM's results look like a pile of spaghetti code. The srs4uv decompilers 
analyze the branch patterns to recover all of the high-level logical 
structures, making the recovered source code look as good, if not better, than 
the original source code.

Best regards,
Gyle
[EMAIL PROTECTED]
www.srs4uv.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visithttp://listserver.u2ug.org/

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http

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

[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

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Tuesday, July 31, 2012 11:16 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Running a command in a different account

It's unix, so all the suggestions are well taken.

Thanks, all!!


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A 
(Rod) 46K
Sent: Friday, July 27, 2012 12:31 PM
To: 'U2 Users List'
Subject: Re: [U2] Running a command in a different account

Are you on Unix or Windows?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Friday, July 27, 2012 10:42 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Running a command in a different account

Greetings!



We have a program that runs in one account, but under certain conditions it is 
becoming necessary for that program to execute a command in another account, 
and then continue on its merry way doing other things.  One fairly simplistic 
example might be that the process might find it necessary to create a file in 
another account.



We have come up with a number of different ways of accomplishing this, but all 
involve a phantom LOGTO of some sort -whether it be through working with the 
UV.ACCOUNT file, the LOGIN paragraph, or some combination of the above.  While 
this will do what is necessary, there are timing issues to consider, control 
and response issues, error checking, etc.  It can be done, but it's not pretty.



Does anyone have a more elegant and efficient way of accomplishing this?



Thanks in advance!



Brian F. Paige






_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material not 
intended for Public use.
Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is strictly prohibited. If you received this communication 
in error, please notify the sender and delete the material from any and all 
computers or devices.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

-
-
CONFIDENTIALITY NOTICE: If you have received this email in error, please 
immediately notify the sender by e-mail at the address shown.
This email transmission may contain confidential information.  This information 
is intended only for the use of the individual(s) or entity to whom it is 
intended even if addressed incorrectly.  Please delete it from your files if 
you are not the intended recipient.  Thank you for your compliance.  Copyright 
(c) 2012 Cigna 
=
=

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material not 
intended for Public use.
Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is strictly prohibited. If you received this communication 
in error, please notify the sender and delete the material from any and all 
computers or devices.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SAVING UNIQUE ( multivalued)

[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, use EVAL to raise the string.  For example:
SELECT filename SAVING UNIQUE EVAL @RECORDnn;RAISE(@1)

filename is a placeholder for the file you are selecting.
nn is the field number.  You may be able to use the field name instead of 
@RECORDnn.

Tom
RATEX Business Solutions.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 3:39 PM
To: 'U2 Users List'
Subject: [U2] SAVING UNIQUE ( multivalued)

Does anyone know a trick to achieve the equivalent of

SELECT filename SAVING UNIQUE fieldname

When fieldname is the name of a multivalued field, and I want a list  of all 
the unique values for that field?

The syntax above does not explode the values, but just looks at the whole field.

I suppose that I can do a LIST with a BY.EXP  a BREAK.ON, but perhaps I am 
missing something...

Thanks,

Rick Nuckolls
Lynden Inc.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Here is my simple program.  Before the critics begin, remember it was written 
14 years ago, and it does work. :D

Some simple rules:
1) Set STACKWRITE to OFF
2) Compile and catalog UTL.STACK.
3) Add the command UTL.STACK IN to your login paragraph/proc.
4) Add to the ON.EXIT paragraph/proc (or create one) that has UTL.STACK OUT.
5) 1-4 are true for all accounts you want to utilize this utility.
6) This is AS IS, there are no implied or explicit warranties.  Make sure you 
understand what this is doing, and test, before putting this on your live 
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 : NONE
* FILES UPDATED : NONE
*
*
* MODIFICATIONS:
*
*
*
  COMMON/STKCOM/STACK.NO
*
* Open files
*
  ABORT.FLAG = 
  WHOAMI = UPCASE(@LOGNAME)
  IF (SYSTEM(91)) THEN
 WHOAMI=FIELD(WHOAMI,'\',2)
 IF WHOAMI='' THEN WHOAMI=UPCASE(@LOGNAME)
  END
  OPEN DICT,SAVEDLISTS TO SAVEDLISTS.FILE ELSE
 ABORT.FLAG-1 = DICT :WHOAMI:.DATA
  END
*
  IF ABORT.FLAG # '' THEN
 CRT @(-1):@(10,5):Unable to open the following files:
 CNTR = 6
 POS = 0
 LOOP
REMOVE FILE.NAME FROM ABORT.FLAG SETTING POS
 UNTIL POS = 0 AND FILE.NAME = 
CNTR += 1
CRT @(15,CNTR):FILE.NAME
 REPEAT
 ABORT
  END
*
  GOSUB INIT
*
*
***   Begin Main Program  ***
*

  GET(ARG.) OPTION  ELSE
 BEGIN CASE
CASE @PARASENTENCE='ON.EXIT'
   OPTION='OUT'
CASE @PARASENTENCE='ON.ABORT'
   RETURN
CASE 1
   OPTION='IN'
 END CASE
  END
  READ CTRL FROM SAVEDLISTS.FILE, WHOAMI:'.STACK.CONTROL' ELSE CTRL = ''
  IF CTRL1 # DATE() THEN
 CTRL1 = DATE()
 CTRL2 = 0
 CTRL3 = 
  END
  IF OPTION = 'IN' AND NOT(STACK.NO) THEN
 IF CTRL3 #  THEN
STACK.NO = CTRL3,1
DEL CTRL3,1
 END ELSE
STACK.NO = CTRL2 + 1
CTRL2 = STACK.NO
 END
 EXECUTE GET.STACK :WHOAMI:STACK.NO
  END
  IF OPTION = 'OUT' THEN
 IF STACK.NO = 0 THEN
STACK.NO = CTRL2 + 1
CTRL2 = STACK.NO
 END
 LOCATE STACK.NO IN CTRL3,1 BY AR SETTING FOUND ELSE
INS STACK.NO BEFORE CTRL3,FOUND
 END
 EXECUTE SAVE.STACK :WHOAMI:STACK.NO
  END
  WRITE CTRL TO SAVEDLISTS.FILE, WHOAMI:'.STACK.CONTROL'
  GO TERMINATE
*
*
***   End Main Program***
*
*
*
***   Begin Subroutines   ***
*
*
INIT:
  PROMPT 
  RETURN
*
TERMINATE:
*
FINISH:
*
  RETURN TO FINISH
   END



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Saturday, May 05, 2012 9:39 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Command that turns off default command stacker


 Yes I'm interested.

 

 

-Original Message-
From: Tom Whitmore tewhitm...@ratex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Sat, May 5, 2012 5:56 pm
Subject: Re: [U2] Command that turns off default command stacker


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 stacks saved.  I can 
dig up my code and share it if anyone is interested.
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of Wjhonson
Sent: Saturday, May 05, 2012 5:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Command that turns off default command stacker


 Yep it's already in the stack below :)
That's what you get for reading only the top post!

 

 

-Original Message-
From: Clifton Oliver w...@oliver.com
To: U2 Users List u2-users@listserver.u2ug.org
Cc: u2-users u2-users@listserver.u2ug.org
Sent: Sat, May 5, 2012 2:16 pm
Subject: Re: [U2] Command that turns off default

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

[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 satya satya
Sent: Monday, May 07, 2012 1:19 PM
To: U2 Users List
Subject: Re: [U2] Command that turns off default command stacker

Hi to every one,

I am heart fully Thank to one and all for sharing important information 
including with me may i know the some logic of the pick basic 7.3 version can u 
guys forward some material based on unidata please

Thank you,
Satya

On Mon, May 7, 2012 at 10:22 PM, George Gallen ggal...@wyanokegroup.comwrote:

 Idk,

 What happens on the second entry into Finish? If there wasn't a gosub 
 to start with?
 Will it just error out, or just drop out of the program?

 I haven't tried it, just my 2c

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
 Sent: Monday, May 07, 2012 12:50 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Command that turns off default command stacker


 Finish... return to finish
 Isn't this an infinite loop?



 FINISH:

 RETURN TO FINISH
  END




 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




--
*satya king**
software professional*
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 stacks saved.  I can 
dig up my code and share it if anyone is interested.
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Saturday, May 05, 2012 5:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Command that turns off default command stacker


 Yep it's already in the stack below :)
That's what you get for reading only the top post!

 

 

-Original Message-
From: Clifton Oliver w...@oliver.com
To: U2 Users List u2-users@listserver.u2ug.org
Cc: u2-users u2-users@listserver.u2ug.org
Sent: Sat, May 5, 2012 2:16 pm
Subject: Re: [U2] Command that turns off default command stacker


ED VOC STACKWRITE

Change ON to Off

I think that's what you are looking for. 



On May 5, 2012, at 12:11 PM, Wjhonson wjhon...@aol.com wrote:

 
 The users arent getting to TCL
 The stack is created simply by logging in.
 It doesn't matter if you are at TCL or not.
 
 
 
 
 
 
 -Original Message-
 From: Bill Haskett wphask...@advantos.net
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 12:06 pm
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 ok, well...  a reasonably written replacement is a shell.  You never 
 get to real tcl, so you don't have that problem.
 
 Bill
 
 - Original Message -
 *From:* wjhon...@aol.com
 *To:* u2-users@listserver.u2ug.org
 *Date:* 5/5/2012 12:04 PM
 *Subject:* Re: [U2] Command that turns off default command stacker
  It isn't, that's the point.
 It's turned on by default when you load Universe It sits there in the 
 background creating thousands of savedlists since it
 makes one for every user and port combination
 
 We have thousands of ports and dozens of users and it's been this way 
 for 8
 years now
 
 Times every account they may log to and some of our users log into 
 multiple
 accounts during the day
 The 40,000 lists i mentioend was for just *one* account.
 The users dont use the stacker, but that doesnt matter it merrily 
 creates a
 stack that just says LOGIN ove and over and over
 
 
 
 
 
 -Original Message-
 From: Bill Haskettwphask...@advantos.net
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 11:50 am
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 After all of these years, it's hard for me to digest the fact that 
 the porcine U2 stacker is even in use!  :-)
 
 Bill
 
 -
 ---
 - Original Message -
 *From:* wjhon...@aol.com
 *To:* u2-users@listserver.u2ug.org
 *Date:* 5/5/2012 8:43 AM
 *Subject:* Re: [U2] Command that turns off default command stacker
 Well you have to do it at least once!
 In a single one of our accounts we had 44000 of these buggers
 
 
 -Original Message-
 From: Allen Elwood RRaelw...@socal.rr.com
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Sat, May 5, 2012 1:02 am
 Subject: Re: [U2] Command that turns off default command stacker
 
 
 or you could just write a program to purge the file of those entries 
 and run it from time to time :-)
 
 On 5/4/2012 5:35 PM, Wjhonson wrote:
 I found the answer
 
 In the VOC is an item called STACKWRITE the first attribute is an X 
 the second attribute says ON
 
 If you change that second attribute to OFF then universe will stop 
 creating all these thousands of savedlists entries
 which are keyed to user combined with port number
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] READU vs READ

[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 suggested, there are several things to do: 
Tune your files.  
If you are using dynamic files, make sure you have the MINIMUM.MODULUS set 
to reduce the shrink and merging
If the records are lumpy redesign them so you have a header file and a 
detail file, with detail files being individual records for the associated 
values. 
Use LIST.INDEX with the STATISTICS option to see if you have huge index 
value, you may need to refine the index.  
Check your hardware, you may have a bottleneck due to slow disk, I/O pipe.
Minimize the number of times you go through the associated values.  
Use READU with the LOCKED clause, if the record is locked, add logic to 
queue it up and try the records again once everything else is processed 
(WRITEs will hang on a lock if you don't have the LOCKED clause, just like a 
READU without the LOCKED clause.

Good luck!
Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, May 01, 2012 4:44 AM
To: 'U2 Users List'
Subject: Re: [U2] READU vs READ

Have you been able to do any os level tools to see what the utilisation of 
resources is. E.g. on linux, vmstat, top, iostat will show you if it is a 
diskio or cpu bottleneck.  If it is diskio (i.e. high wait on io times) then 
you may need to upgrade the disks or add more ram so you have more data in 
cache.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: 01 May 2012 02:58
To: U2 Users List
Subject: Re: [U2] READU vs READ

Oh ... you're good ... I ALMOST pasted it ...

I know better that to put even FICTITIOUS code on this board ... unless I'm 
just trying to rile things up about the OS. |-)

I do appreciate all of the input. Thank y'all for the info. I'll see what I can 
do.

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, April 30, 2012 9:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] READU vs READ

why not post the relevant code you are using to do the field updates perhaps we 
can see some inefficiency in the way you're grabbing and updating fields you 
said the records were sizeable and that raises my eyebrow (just one)

 

 

 

-Original Message-
From: Dave Laansma dlaan...@hubbardsupply.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Apr 30, 2012 6:38 pm
Subject: Re: [U2] READU vs READ


No indexes and no triggers.

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott
Sent: Monday, April 30, 2012 9:22 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Add to the mix indexes and triggers. They can both add to the time needed to 
update just one record.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy 
(Contractor, Logitek Systems)
Sent: Tuesday, 1 May 2012 11:12 AM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Inefficient file sizing and disk I/O are your possible issues with
slowness.   You might be able to address the first at your desk, the
latter may require a purchase order. How old is your hardware?

We recently upgraded to a virtual server and just using more current technology 
hard drives we doubled all of our disk I/O from what we had 5 or
6 years ago.  CPU speed increased as well, but that was not as suprising.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Monday, April 30, 2012 6:01 PM
To: U2 Users List
Subject: Re: [U2] READU vs READ

Yes, using SELECT and READNEXT. These are sizable records. The logic is very 
straight forward, just updating several multi-valued fields in each record 
(month end).

500,000 have been updated and I'm 2:45:00 into the process.



_
Scanned by IBM Email Security Management Services powered by MessageLabs.
For more information please visit http

Re: [U2] Credit Card numbers in your database

[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 
backups is the best way to be sure.
Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Carl Dula
Sent: Thursday, April 19, 2012 6:17 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Credit Card numbers in your database

It appears this list will not allow me to post an attachment, so please take a 
look at the following to answer your question on tape.

https://www.pcisecuritystandards.org/security_standards/documents.php?assocation=PCI%20DSS

To see the document (PCI DSS v2.0) you will have to agree to the license. Then 
download and take a look at both pages 31 and 67.

Also lots of other good info in this document and on this site.

hope that helps!

--
Carl Dula   Voice: 973-227-8440 X111
Pulsar Systems, Inc.Fax: 973-227-8440
271 US Highway 46, STE H209 email:c...@pulsarsystems.com
Fairfield, NJ 07004-2474http://www.pulsarsystems.com 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Compare/Diff feature in BDT

[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-click and choose Compare with, then 
each other.

Make sure you don't have the folder selected, BDT will report that it doesn't 
support the function. (not the exact wording).

The compare view shows two panes and you have icons to move from one difference 
to another, and to move code from one pane to another... all icons but the 
hover does provide a description.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Thursday, April 05, 2012 9:49 AM
To: U2 Users List
Subject: [U2] Compare/Diff feature in BDT

In  Rocket Software's Basic Developer Toolkit, I thought there was a source 
code compare capability - did I imagine that?  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 requires compiling the world to make sure you get 
all the programs that use that include.
Maintenance costs are higher

From my perspective, just say NO to code in includes.  The cost is too high 
with no real benefit.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Wednesday, February 08, 2012 10:15 AM
To: 'dgr...@dagconsulting.com'; 'U2 Users List'
Subject: Re: [U2] Including Code - A Best Practice?

David,

Could you elaborate a little more on your two positive arguments?  Thanks for 
your insights, and all those shared from others so far.

Thank you.
-Baker

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
Sent: Wednesday, February 08, 2012 8:21 AM
To: 'U2 Users List'
Subject: Re: [U2] Including Code - A Best Practice?

I don't think using an INCLUDE is bad, but it must be done in the right way.

Pros:

* It is the fastest way to use reusable code.
* It can be debugged just fine if you use the correct compile arguments.

Cons:

* You must, MUST, address the variable names. I always prefix mine with 
CODE$NAME where CODE is the prefix I've chosen for my INCLUDE and should be 
unique for your system.
* You must recompile all instances if you want the change to be updated 
everywhere.
* More difficult to edit program logic, unless you have a nice editor that 
brings in INCLUDES/INSERTS for you automatically.

David A. Green
(480) 813-1725
DAG Consulting

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Tuesday, February 07, 2012 4:05 PM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Including Code - A Best Practice?

A friendly discussion arose recently among some U2/MV Developers about whether 
to include code.

If any of you have opinions about the positive aspects or negative aspects of 
this practice, please respond.  Should it be adopted as a best practice, or 
rejected as special situation use only?

Many shops probably include long sections of variable assignments, or perhaps 
globally opened files.  This is pretty much accepted everywhere as a good 
practice.

In question here is the insertion of actual code - business logic or screen I/O 
programs or code snippets.

Maybe you know of methods to overcome some of the obvious downsides:
unintended reassignment of local variables, difficulty in debugging, others.

What are the positive upsides?  Performance gains?

What is the longest snippet you think should be included, if allowed?

What advantage has included code over a CALL or a Function?  Reuse.  What else?

Can the downsides be mitigated satisfactorily to justify the gains?

Thanks so much.

-Baker

This communication, its contents and any file attachments transmitted with it 
are intended solely for the addressee(s) and may contain confidential 
proprietary information.
Access by any other party without the express written permission of the sender 
is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy, distribute 
or use the contents, attachments or information in any way.  Please destroy it 
and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] local variables

[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 you compile a 
program in the BP file, it would be stored in the BP.L file).

The -L (-LIST) resolves all the includes and places it in the .L file.  The 
key is the program id.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark
Sent: Thursday, January 26, 2012 5:40 PM
To: U2 Users List
Subject: Re: [U2] local variables

I think it's already been mentioned, but I'll repeat. Both universe and unidata 
have the ability to create a cross-reference listing of a program. unidata's is 
particularly nice and shows every variable, including what lines the variable 
is defined and used on.

but it would still be nicer to have local variables.

You can do this in mvbase. Instead of external functions defined with DEFFUN, 
mvbase has internal functions with local variables.
You can also do this in Caché.

On Jan 26, 2012, at 3:58 PM, Wjhonson wrote:

 
 Mecki you're not paying attention.
 You have an 8000 line program that uses a variable A
 You didn't write it.  You need to find where that variable is assigned.
 You search for A ?
 
 That's not going to work.
 
 
 
 -Original Message-
 From: Mecki Foerthmann mec...@gmx.net
 To: u2-users u2-users@listserver.u2ug.org
 Sent: Thu, Jan 26, 2012 12:55 pm
 Subject: Re: [U2] Passing by Value
 
 
 No, you are completely wrong if you think that is only your world.
 ho in our game has the luxury working only with their own code?
 have been doing what you describe for over 25 years now and probably 
 ost of the contributors here do the same thing for a living too and 
 not ust since yesterday.
 nd I may have made that silly mistake once or twice as a junior but 
 ince then it has become second nature.
 nd in those days we didn't have the luxury of 8000 line programs 
 ecause the limit for any item was 32K and you were forced to use very 
 hort variable names and couldn't even indent your code because spaces 
 re characters too.
 n one shop I worked we used X, Y, Z etc. in 'primary' code and in 
 nternal subroutines XX, YY, ZZ and so on for loop counters.
 personally prefer more meaningful names but can't do that always 
 ecause I try to follow the naming conventions of the code I'm working on.
 Even the editor you use is irrelevant since I haven't seen one yet 
 that oesn't have a search function.
 ust go to the top of the program and search for the variable name you 
 ntend to use.
 f your search comes up negative you're safe to use it.
 imple!
 And OTOH how can you make 'rapid changes' to code if you don't 
 nderstand what it is supposed to do and where the varibles come from?
 On 26/01/2012 20:16, Wjhonson wrote:
 Completely wrong :)
 You apparently have the luxury of only working on programs written by 
 ourself.
 
 In my world, we are called upon to make rapid changes in programs 
 written by wenty programmers over twenty years.
 You haven't specified *how* you ensure that your counters are unique, 
 and by he way, the issue is not just counters, but any variable.
 
 
 
 -Original Message-
 From: Mecki Foerthmannmec...@gmx.net
 To: u2-usersu2-users@listserver.u2ug.org
 Sent: Thu, Jan 26, 2012 12:13 pm
 Subject: Re: [U2] Passing by Value
 
 
 What has the length of the program to do with it?
   always abide to the rule that a for next counter in any internal 
 ubroutine has to be unique.
 hat way even if the sub is called from within a for next loop the 
 ounters never conflict.
 o it doesn't make any difference whatsoever if a program is 80 or 8000 
 ines long.
 BTW a program with 8000 lines is usually a sign of poor design.
 On 26/01/2012 19:02, Wjhonson wrote:
   You've never worked on programs that are 8000 lines long I take it 
 :)
 
 
 
 
   -Original Message-
   From: John Hesterjhes...@momtex.com
   To: U2 Users Listu2-users@listserver.u2ug.org
   Sent: Thu, Jan 26, 2012 10:49 am
   Subject: Re: [U2] Passing by Value
 
 
   I like to use increasing roman numerals:
   FOR I = 1 TO COUNTER
 GOSUB PROCESS
   EXT I
   PROCESS:
   OR II = 1 TO COUNTER2
 FOR III = 1 TO COUNTER3
   FOR IV = 1 TO COUNTER4
 
   NEXT IV
 NEXT III
   EXT II
   ETURN
   -Original Message-
   rom: u2-users-boun...@listserver.u2ug.org
   mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
   ent: Thursday, January 26, 2012 10:09 AM
   o: u2-users@listserver.u2ug.org
   ubject: Re: [U2] Passing by Value
 
   n a related note, any clever ideas to localize a variable to a local
   ubroutine?
   For I = 1 to 10
  GOSUB PROCESS
   ext I
   top
   3000 Lines of code later
   PROCESS:
   OR I = 1 TO 20
   RINT I
   EXT I

Re: [U2] Brilliant? or not?

[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 can write self-documenting code, or code 
that is dense and obtuse.

I urge everyone to write clear code, including meaningful variables and 
comments!

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, January 16, 2012 3:17 PM
To: 'U2 Users List'
Subject: Re: [U2] Brilliant? or not?

H


This has whole topic has been mentioned on here before, and my stance is the 
same, if you can not read that code and work it out in 4 seconds, then maybe 
you should not be a programmer.  Code is code, read it , understand it, get
over it   

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 16 January 2012 18:50
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Brilliant? or not?

 From: Charles_Shaffer
 Aside from it not being readable, compacting C code like that can 
 reduce portability.  Different compilers may evaluate complex, 
 compacted code differently.

Same thing has actually happened with BASIC code that's ported from one 
platform to another.

Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or 
programmer can read it.

On-topic: that makes my response to this thread, not. 

One of our colleagues from the mid 80's wrote code that was so clean I liked to 
say we could eat off of it.  I think he still reads this forum: So to Mark 
Vander Veen, here we are over 20 years later and I Still appreciate your code.  
Now THAT is Brilliant.

T

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1416 / Virus Database: 2109/4146 - Release Date: 01/16/12

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Show.Timestamp

[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] Show.Timestamp


0001= TODAY = DATE()
0002= NOW = TIME()
0003= CRT TIMESTAMP FOR :OCONV(TODAY,'D4-'): :OCONV(NOW,MTS): IS :
0004= CRT TODAY:*:NOW

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn
Sent: Sunday, November 20, 2011 8:19 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] -E debugger entry; Universe?

Hi everyone,

Is there a Universe function similar to the Unidata option to run a program 
from the command line with -E, which causes the program to enter the debugger 
when an error is encountered?

 

Susan

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Question about UniVerse indexes...

[Tom Whitmore]

Hi,
I'm trying to find a command at TCL or in BASIC that will provide a list of UV 
indexes.  LIST.INDEX truncates the dictionary id.  I know back on Prime 
Information you could use SELECTINDEX to get a list of indexes, or indexed 
values, depending on how you used the function.  I'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...

[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@listserver.u2ug.org
Subject: Re: [U2] Question about UniVerse indexes...

I believe LIST.INDEX is just a basic program in the BP file (uv account)
- you may find some info there.

Mark




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Friday, November 18, 2011 3:11 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Question about UniVerse indexes...

Hi,
I'm trying to find a command at TCL or in BASIC that will provide a list of UV 
indexes.  LIST.INDEX truncates the dictionary id.  I know back on Prime 
Information you could use SELECTINDEX to get a list of indexes, or indexed 
values, depending on how you used the function.  I'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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Mercurial/TortoiseHg source version control

[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 Behalf Of Barber, Bonnie
Sent: Tuesday, November 15, 2011 10:39 AM
To: U2 Users List
Cc: Winchell, Mike
Subject: [U2] Mercurial/TortoiseHg source version control

Does or has anyone on this list used Mercurial (UNIX) or TortoiseHg (windows) 
for Universe program version control. It is used currently here at Perseus for 
our relational database scripts and code.  Now management would like us to use 
it for our Universe programs also.  If anyone is familiar with this product are 
there any caveats we should know about?  Currently we use a homegrown 
application for our Universe source control.



Thanks in advance for any information you might have.



Bonnie Barber J
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Mercurial/TortoiseHg source version control

[Tom Whitmore]

Hi Rex,
It is all in UniVerse or UniData so I believe the answer would be Yes, I'll 
let Susan reply since it is her product.  

Also, remember that PRC will track dictionaries, procs, includes, as well as 
programs, which isn't possible with version control products that are 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] Mercurial/TortoiseHg source version control

Tom,

Would it possible to export all the source code from PRC into a flat 
file/directory format for Mercurial?

rex

On Tue, Nov 15, 2011 at 11:05 AM, Tom Whitmore tewhitm...@ratex.com wrote:
 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Mercurial/TortoiseHg source version control

[Tom Whitmore]

PRC is written in PICK so it knows about the various types of records we 
would modify in PICK, and tracks them.  Non-PICK tools can read directories, 
for programs, and includes, but that's it.  You would need to create a lot of 
tools to provide the hooks into the PICK database.  Here, when a programmer 
modifies a dictionary, PRC tracks the change.  The same is true with PROCs, 
programs, etc.  I tell PRC what files to track, for dictionaries I just tell 
PRC to track ALL dictionary changes.  It is seamless.  My biggest hurdle is the 
4GL we are using, it isn't a main-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 3:07 PM
To: U2 Users List
Subject: Re: [U2] Mercurial/TortoiseHg source version control

Tom,

I keep dictionaries, procs, Q-pointers, programs, and includes in CVS and 
Mercurial.  What do you mean by PICK aware?

rex
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Universe File Issue

[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 from Rocket)
3) convert to a multi-part file.  This allows you to break up a file based on 
an i-descriptor, but I couldn't find details during my quick search.  It would 
be the most complicated to implement of the three, if it hasn't been deprecated 
by Rocket.

Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney
Sent: Tuesday, October 11, 2011 7:29 AM
To: 'U2 Users List'
Subject: [U2] Universe File Issue

I inherited a system running UniVerse over windows 2003 Server.

I have a history file that seems corrupt. It's just over 2 gigs in size (The 
problem I believe) and fixfile and uvfixfile won't work on it.

I'm thinking the size of the file needs to shrink a bit before I can do 
anything with it. Thoughts?

John Varney
Integra Life Sciences


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] PE72 Unidata will not start

[Tom Gray]

Daniel McGrath DMcGrath at rocketsoftware.com writes:

 
 Okay, first, don't worried about RFS not being licensed. That is additional 
functionality that doesn't
 come with the Personal Edition.
 
 Since you are getting Start SMM first, you probably have not started the 
UniData engine. With this, you
 don't want to actually start SMM by itself directly. All you need to do is 
run 'startud' to start the UniData
 engine and it should all be fine.
 
 Regards,
 
 Dan McGrath
 U2 Product Manager
 Rocket Software
 4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
 Tel: +1.720.475.8098 * Fax: +1.617.630.7392
 Email: dmcgrath at rs.com 
 Web: www.rocketsoftware.com/u2 
 
 -Original Message-
 From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at 
listserver.u2ug.org] On
 Behalf Of Tom Gray
 Sent: Monday, October 10, 2011 2:24 PM
 To: u2-users at listserver.u2ug.org
 Subject: [U2] PE72 Unidata will not start
 
 Installed unidata PE7.2.7, tryimg to start unidata, udt.exe, receive the 
  following messages:
 
  RFS is not licensed. SB_FLAG is turned off.  Start SMM first!
 
 I have looked at the License and it hasn't expired this is a recient download 
I tried starting the SMM from the
 command prompt 
 
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users at listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 I went to the Bin directory and ran startud 
it echoed back with It could not start Unidata Service.


The following services are running:
Uni RPC Service
Uni Objectcall
Unidata Telnet Service
Unidata Terminal Service





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] PE72 Unidata will not start

[Tom Gray]

Installed unidata PE7.2.7, tryimg to start unidata, udt.exe, receive the 
 following messages:

 RFS is not licensed. SB_FLAG is turned off.  Start SMM first!

I have looked at the License and it hasn't expired this is a recient download I 
tried starting the SMM from the command prompt 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

I would never use HASH.HELP on a file, there are known problems with it.  
Examples are not providing a prime modulus, and calculating the wrong file time.

I have used FAST for many years, and now recommend it to our customers.  It is 
far more accurate, and easier to use, than any tool UniVerse 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 Sizing Tool)

Following a HASH.HELP and then a RESIZE on a number of files... it is likely 
that a bigger disk drive will be needed. 

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Subject: Re: [U2] FAST (File Analysis and Sizing Tool)


 could you or someone maybe provide a little more clarity on this issue?
The place where I'm now working has almost every file as a dynamic file that 
they claim have never been resized and are at least five to eight years old.  
And the system is actually amazingly fast to my mind.

 
So what would I be looking for to show that the files are actually not very 
efficient?


 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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, August 31, 2011 3:18 PM
To: U2-Users@listserver.u2ug.org
Subject: Re: [U2] PC based UniBasic program editor for 64 bit OS

I know I haven't ever posted in here before ... I just lurk and read all the 
responses.

 

I've actually used mvDeveloper and it works on a 64-bit OS though it is a bit 
quirky.  

I've used WED with Accuterm and it works GREAT on a 64-bit OS - this is my 
preferred method.  

I use Notepad++ occasionally, but I don't have a syntax file that can be used 
for UniBasic.  Also not sure where to get one, so if someone can post a link, 
that would be great. 

I haven't used the Rocket one ... I have started the download and then read the 
part about Eclipse... don't have that installed :P.  Oh well, maybe later.

 

Thanks for all the great advice and info, keep it coming.

Will Goodwin

(Pick Noob - cut my teeth reading Doug Chanco programs.  Hi Doug! )

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
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

[Tom Whitmore]

Actually, Universe ships a telnet for Window but not *nix.  The reason, 
according to U2 support, is that *nix provides telnet and Windows does not.
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Monday, August 01, 2011 6:34 PM
To: John Thompson; u2-users@listserver.u2ug.org
Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

John

Universe ships with its own secure telnet daemon for *nix running telnet over 
ssl (uvtelnetd). That's what you need to configure.

Brian

Sent from my HTC

- Reply message -
From: John Thompson jthompson...@gmail.com
Date: Mon, Aug 1, 2011 21:44
Subject: [U2] Using SSL, with .Net to make a connection to Linux/Unix
To: U2 Users List u2-users@listserver.u2ug.org

Another thing to think about is that by default most Linux distro's heavily 
restrict telnet.

My first question would be, are your Universe users using telnet or ssh?

If they are using ssh only, then I doubt a telnet system is even installed on 
the Linux machine.

If they are using telnet, you might try checking the following files to see if 
there are any security restrictions set:

One place might be /etc/hosts.allow AND /etc/hosts.deny Here is a random blog 
entry on tcpwrappers (One package that can restrict telnet access) 
http://linuxhelp.blogspot.com/2005/10/using-tcp-wrappers-to-secure-linux.html

I think also many linux distro's use xinetd (instead of inetd) to run their 
telnet daemon.

So, there may be some restrictions there also.
I think the config file is called:
xinetd.conf
http://www.xinetd.org/sample.shtml

From a root prompt... 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 tewhitm...@ratex.com 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-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 SSL, with .Net to make a connection to 
 Linux/Unix

 Tom

 I don't know what '.NET TELNET tool' you refer to - but I wrote a 
 customized terminal emulator in .NET for a client that makes a 
 connection Telnet/SSL connection to UniVerse on Solaris and tested fine on 
 Linux.

 For the server configuration and details on setting up the secure 
 telnet daemon take a look at my blog (you can get to it from my website).

 As far as the client is concerned, I can't give too much away as I 
 don't own it - it was funded by a customer - but I can probably share 
 the following if you're tempted to roll your own!

 1. for the low level connection I use a SecureTCPClient that wraps an 
 SslStream - here are the salient pieces:

 public delegate void SecureConnectionResultsCallback(object sender, 
 SecureConnectionResults args);
public delegate void ReceivedDataEvent( object sender, string data);
public delegate void ReceiveErrorEvent( object sender );

public class SecureTcpState
{


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
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

[Tom Whitmore]

Hi,
At this point, we are using an internal development server and our Admin does 
have SSL, and SSH, turned on and it works with our terminal emulator.  Changing 
from SSH to SSL Telnet won't be a problem with our customers.  The critical 
piece is that it must be an encrypted pipe.

Thanks for the thought.
Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Monday, August 01, 2011 4:44 PM
To: U2 Users List
Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix

Another thing to think about is that by default most Linux distro's heavily 
restrict telnet.

My first question would be, are your Universe users using telnet or ssh?

If they are using ssh only, then I doubt a telnet system is even installed on 
the Linux machine.

If they are using telnet, you might try checking the following files to see if 
there are any security restrictions set:

One place might be /etc/hosts.allow AND /etc/hosts.deny Here is a random blog 
entry on tcpwrappers (One package that can restrict telnet access) 
http://linuxhelp.blogspot.com/2005/10/using-tcp-wrappers-to-secure-linux.html

I think also many linux distro's use xinetd (instead of inetd) to run their 
telnet daemon.

So, there may be some restrictions there also.
I think the config file is called:
xinetd.conf
http://www.xinetd.org/sample.shtml

From a root prompt... 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 tewhitm...@ratex.com 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-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 SSL, with .Net to make a connection to
 Linux/Unix

 Tom

 I don't know what '.NET TELNET tool' you refer to - but I wrote a
 customized terminal emulator in .NET for a client that makes a
 connection Telnet/SSL connection to UniVerse on Solaris and tested fine on 
 Linux.

 For the server configuration and details on setting up the secure
 telnet daemon take a look at my blog (you can get to it from my website).

 As far as the client is concerned, I can't give too much away as I
 don't own it - it was funded by a customer - but I can probably share
 the following if you're tempted to roll your own!

 1. for the low level connection I use a SecureTCPClient that wraps an
 SslStream - here are the salient pieces:

 public delegate void SecureConnectionResultsCallback(object sender,
 SecureConnectionResults args);
public delegate void ReceivedDataEvent( object sender, string data);
public delegate void ReceiveErrorEvent( object sender );

public class SecureTcpState
{
   public SslStream stream;
public System.Byte[] Buffer;

public SecureTcpState()
{
this.Buffer = new System.Byte[8192];
}
}

public class SecureConnectionResults
{
private SslStream secureStream;
private Exception asyncException;

internal SecureConnectionResults(SslStream sslStream)
{
this.secureStream = sslStream;
}

internal SecureConnectionResults(Exception exception)
{
this.asyncException = exception;
}

public Exception AsyncException { get { return asyncException; } }
public SslStream SecureStream { get { return secureStream; } }
}

/// summary
/// SecureTcpClient: a TCP client socket with ssl streaming
/// /summary
public class SecureTcpClient: IDisposable
{
X509CertificateCollection clientCertificates = null;
RemoteCertificateValidationCallback certValidationCallback= null;
SecureConnectionResultsCallback connectionCallback = null;
bool checkCertificateRevocation = true;
SslStream sslStream = null;
TcpClient client = null;
IPEndPoint remoteEndPoint = null;
string remoteHostName = string.Empty;
SslProtocols protocols = SslProtocols.None;
protected int disposed = 0;
protected Semaphore _sendLock = null; // guard against possible
 BeginSend clashes
protected uint _keepAlive = 0;
protected System.Text.Encoding _encoding =
 System.Text.Encoding.GetEncoding(1252);

// async callbacks for connection and authentication
AsyncCallback onConnected;
AsyncCallback onAuthenticateAsClient;

// async callback for receiving
private AsyncCallback callbackProc = null;
private AsyncCallback callbackEndDispatch = null;

public event ReceivedDataEvent onReceived = null;
public event

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

[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 SSL, with .Net to make a connection to Linux/Unix

Tom

I don't know what '.NET TELNET tool' you refer to - but I wrote a customized 
terminal emulator in .NET for a client that makes a connection Telnet/SSL 
connection to UniVerse on Solaris and tested fine on Linux. 

For the server configuration and details on setting up the secure telnet daemon 
take a look at my blog (you can get to it from my website).

As far as the client is concerned, I can't give too much away as I don't own it 
- it was funded by a customer - but I can probably share the following if 
you're tempted to roll your own!

1. for the low level connection I use a SecureTCPClient that wraps an SslStream 
- here are the salient pieces:

public delegate void SecureConnectionResultsCallback(object sender, 
SecureConnectionResults args);
public delegate void ReceivedDataEvent( object sender, string data);
public delegate void ReceiveErrorEvent( object sender );

public class SecureTcpState
{
   public SslStream stream;
public System.Byte[] Buffer;

public SecureTcpState()
{
this.Buffer = new System.Byte[8192];
}
}

public class SecureConnectionResults
{
private SslStream secureStream;
private Exception asyncException;
   
internal SecureConnectionResults(SslStream sslStream)
{
this.secureStream = sslStream;
}

internal SecureConnectionResults(Exception exception)
{
this.asyncException = exception;
}

public Exception AsyncException { get { return asyncException; } }
public SslStream SecureStream { get { return secureStream; } }
}

/// summary
/// SecureTcpClient: a TCP client socket with ssl streaming
/// /summary
public class SecureTcpClient: IDisposable
{
X509CertificateCollection clientCertificates = null;
RemoteCertificateValidationCallback certValidationCallback= null;
SecureConnectionResultsCallback connectionCallback = null;
bool checkCertificateRevocation = true; 
SslStream sslStream = null;
TcpClient client = null;
IPEndPoint remoteEndPoint = null;
string remoteHostName = string.Empty;
SslProtocols protocols = SslProtocols.None;
protected int disposed = 0;
protected Semaphore _sendLock = null; // guard against possible 
BeginSend clashes
protected uint _keepAlive = 0;
protected System.Text.Encoding _encoding = 
System.Text.Encoding.GetEncoding(1252);

// async callbacks for connection and authentication
AsyncCallback onConnected;
AsyncCallback onAuthenticateAsClient;

// async callback for receiving
private AsyncCallback callbackProc = null;
private AsyncCallback callbackEndDispatch = null;

public event ReceivedDataEvent onReceived = null;
public event ReceiveErrorEvent onReceiveError = null;

public SecureTcpClient(SecureConnectionResultsCallback callback)
: this(callback,null,SslProtocols.Default){
}
public SecureTcpClient(SecureConnectionResultsCallback callback, 
RemoteCertificateValidationCallback certValidationCallback)
: this(callback, certValidationCallback, SslProtocols.Default){
}
 
public SecureTcpClient(SecureConnectionResultsCallback callback, 
RemoteCertificateValidationCallback certValidationCallback, 
SslProtocols sslProtocols){
if (callback == null) {
throw new ArgumentNullException(callback);
}

onConnected = new AsyncCallback(OnConnected);
onAuthenticateAsClient = new AsyncCallback(OnAuthenticateAsClient);
this.certValidationCallback = certValidationCallback;
this.connectionCallback = callback;
protocols = sslProtocols;
this.disposed = 0;
}
 
~SecureTcpClient(){
Dispose();
}
 
public bool CheckCertificateRevocation{
get { return checkCertificateRevocation; }
set {checkCertificateRevocation = value;}
}
 
public void StartConnecting(string remoteHostName, IPEndPoint 
remoteEndPoint){
StartConnecting(remoteHostName,remoteEndPoint,null);
}
 

public void StartConnecting(string remoteHostName, IPEndPoint 
remoteEndPoint, 
X509CertificateCollection clientCertificates){
if (string.IsNullOrEmpty(remoteHostName)) {
throw new ArgumentException(Value cannot

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

[Tom Whitmore]

Hi,
We are having problems making the .NET telnet tool make an SSL connection to 
UniVerse on a Linux server.
Has anyone been successful in making this type of connection?
If so, did you use the .NET telnet tool or a third-party product?
(We are able to connect to UniVerse on a Windows server.)
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

[Tom Whitmore]

I should clarify one thing.  We are able to connect using SSL with our terminal 
emulator, it is only the .net application that is unable to make the SSL 
connection.
Thanks again!
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@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 successful in making this type of connection?
If so, did you use the .NET telnet tool or a third-party product?
(We are able to connect to UniVerse on a Windows server.) Thanks, Tom Whitmore 
RATEX Business Solutions ___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

READUO is just READ (keep an original copy of the record, to detect 
changes), at the end of your code perform the write.  If you want to detect, 
and remediate any changes someone else made, read the record again, compare it 
to the original record (before the record 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

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris
Sent: Wednesday, July 13, 2011 10:47 PM
To: U2 Users List
Subject: Re: [U2] Record Locks - How long should they last for? (Opinion)

why haven't the MV DBMS vendors created a READUO

Possibly in part because of the need to then have resolution mechanism for when 
2 processes change the same data (assuming of course that the data wasn't, say, 
an accumulation total) -- what interface would you use  telnet will not 
work nicely with the web app described, nor with someone using, say UOJ

Still, extend a bit, and it could throw an error with the differences to be 
handled by whatever application layer -- but of course the real kicker in 
all of this is, and always has been, the wealth of legacy code that WOULDN'T 
use the new mechanism without a major rewrite  and if you get to THAT 
point, refer to why U2 thread :-(



Ross Ferris
Stamina Software
Visage  Better by Design!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Thursday, 14 July 2011 8:46 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Locks - How long should they last for? (Opinion)

After all of these years, why o why haven't the MV DBMS vendors created a 
READUO mechanism which allows us to optimistically lock records in exactly the 
way that George, Rex, and a hundred other app developers have indicated over 
the last 15 years?

Design tip: For all new development, abstract your file IO and all OS access 
into separate functions, Includes, and/or subroutines, away from the business 
code.  This way you can change your datastore interaction without messing with 
your application logic, and you can re-use the routines for a lot of different 
work.  The application needs to be aware of whether you're moving forward with 
a pessimistic or optimistic lock, but your app code shouldn't have to manage 
those mechanisms.

T

 From: George Gallen
 ... instead of the checksum token method, I was going to write the 
 record to a holding file with an ID that was a combination of 
 file/record/transaction token
 
 And do a comparison using the saved item to see if record changed, but 
 only if the record lock had expired - I still wanted to keep the locks 
 since the system could be used by local users as well, which is easier 
 using the READU locally to test for locking.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 develop software for college bookstores.  Over the past year and a half, we 
implemented PRC's version control software in-house, which has helped us 
improve the development and release process.  We are no looking at how to 
improve the installation process at our customers.  At this point, our goal is 
to have an isolated, sandbox, where we can install the update and have our 
customers test.  Once they are happy, provide them tools to install the code 
into their production system.

As we start down this path, we are wondering if anyone in this group could 
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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Adding capabilities in the sort term

[Tom Whitmore]

Hi,
We are using HostAccess as our terminal emulator and Verifone's MX870 for the 
PIN Pad device.  We chose to use Verifone's IP Connect product to actually 
perform the communication with the device.  HostAccess provides basic 
subroutines that will permit you to send the commands to either talk to the MX 
or their SIM dll.  Either way, we receive the signature back and display it on 
the screen without a problem.  The beauty of the way we are doing this is that 
credit cards never touch our server, and with Verifone's end-to-end encryption 
no usable credit card information 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 Oaks, Harold
Sent: Wednesday, July 06, 2011 2:35 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Adding capabilities in the sort term

Has anyone done either of the following with a U2 system (we have
Universe) and can give me some recommendations?

(1) Added a signature pad so that captured signatures can be stored for future 
use. (We have Print Wizard, so can easily print graphical images if they can 
just be captured.)

(2) Worked with Web Services from within your U2 application?

Thanks-
Harold Oaks

This e-mail and related attachments and any response may be subject to public 
disclosure under state law.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Break and debug

[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 Behalf Of Dianne Ackerman
Sent: Friday, June 24, 2011 3:32 PM
To: U2 List Server
Subject: [U2] [UV] Break and debug

On one system that I'm working on, I no longer get the D debug option when I 
do a control-break.  Somewhere in the far reaches of my memory, I know there is 
some setting that controls that, but I have no idea anymore what it is.  Can 
anyone help?  Thanks!
-Dianne

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[Tom Whitmore]

Hi,
We develop software for college bookstores.  Over the past year and a half, we 
implemented PRC's version control software in-house, which has helped us 
improve the development and release process.  We are no looking at how to 
improve the installation process at our customers.  At this point, our goal is 
to have an isolated, sandbox, where we can install the update and have our 
customers test.  Once they are happy, provide them tools to install the code 
into their production system.

As we start down this path, we are wondering if anyone in this group could 
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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 test before going live with the 
update.

Putting the update in an isolated environment, and letting them push the 
button to install the code, I believe, would address these issues.  However, 
there are so many factors involved, we want to make sure we have identified the 
gotchas that others have come across.
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Thursday, June 16, 2011 12:19 PM
To: U2 Users List
Subject: Re: [U2] Question about updating customer's systems...

Hi Tom:

We had a similar problem years ago trying to deliver our customers consistent 
releases that we could script.  We tried Windows bat files and Unix shell 
scripts but each release was never quite right.  Our staff would forget this 
file or this dictionary or just plain copy the wrong account to our customer.  
Then there was the problem the installation for our payroll system, for 
example, took 8 hours to do a full installation using wIntegrate bridge copy 
utility which was a really bad way of doing it.

[ad]
We developed XLr8Installer an Eclipse plug-in.  You build a XML script using 
our tool.  The script can be saved on say your network drive for everyone to 
access or in your version control software.  The script can be run over the 
internet to create your customer's test account environment from your base 
system.  It will create all of the files, copy all of the dictionaries, compile 
all of the dictionaries, create the indexes, copy any data and program, compile 
all of the programs, remove source if required, and can run and TCL/ECL 
commands.

We open a connection to our client using XLr8Installer.  We either install the 
full release or a patch release using the XML script that we previously built.  
All of the data is copied over the internet in a few minutes.  Our payroll 
installation takes about 7 to 10 minutes to do a full install.  Our Doc Mgt 
system that use to take an 1 hour with wIntegrate now takes 45 seconds max.

On some of our Client systems we open 3 connections and use all of those 
connections to updating their site simultaneously.  We do not have to do linear 
installs anymore which cuts our installation time from several hours per site 
to about 15 minutes depending on how many packages we have to install.

For those sites that do not allow internet access in but allow it out.  You can 
run the scripts from the client site to your build site.  We even have client 
that does not allow internet access out or in, so we send our base account on 
thumb drive.  The client or our staff uses the thumb driver to install the 
software at their site.

Pricing is at $99.00 per workstation for XLr8Installer.  So even in these hard 
times, it is difficult that you or your clients cannot afford this amazing 
solution.
[/ad]

Regards,
Doug
www.u2logic.com
Eclipse solutions for U2 marketplace
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Enterprise Scheduling solution

[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-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, June 14, 2011 9:18 AM
To: 'U2 Users List'
Subject: Re: [U2] Enterprise Scheduling solution

Cron is great however sounds like the op wants something much much more than 
cron  :)


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: 14 June 2011 12:54
To: U2 Users List
Subject: Re: [U2] Enterprise Scheduling solution

We use plain old cron in AIX.  If you get your korn shell initialization set 
right in the shell script you call U2 from you can do almost anything.  BASIC 
will do anything cron won't.  Let me know if you need more details... Kind of 
hard to type them out on a blackberry.

On 6/13/11, Baker Hughes baker.hug...@mouser.com wrote:
 Many MV systems have some kind of home-brewed or even purchased 
 scheduling solution for handling batch processes.  Many times, in 
 distribution or manufacturing ERP applications, certain processes such 
 as Aging A/R, or stock replenishment/reserving, is performed 'after 
 hours' by these schedulers.  We've all worked with one or perhaps 
 written our own.  We
have
 one of these, that gets the job done.

 Does anyone know of an Enterprise Scheduler solution that can handle 
 jobs across a heterogeneous enterprise, that is also MV or *nix compatible?
 Rather than try and take our UniVerse based scheduler front end to the
next
 level of perfection, we need a job/phantom/scheduler solution that 
 would allow an Operator with little or no MV knowledge to 
 monitor/adjust/manage jobs across a plethora of different OS-based enterprise 
 applications.

 The Enterprise Scheduler we are interested in can be MV based, or 
 other DB based, but must have a graphical front end, and must be able 
 to manage
jobs
 on non-MV systems as well as MV systems.

 Thanks for any ideas.
 -Baker



   
 This communication, its contents and any file attachments transmitted 
 with it are intended solely for the addressee(s) and may contain 
 confidential proprietary information.
 Access by any other party without the express written permission of 
 the sender is STRICTLY PROHIBITED.
 If you have received this communication in error you may not copy, 
 distribute or use the contents, attachments or information in any way.
 Please destroy it and contact the sender.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


--
Sent from my mobile device

John Thompson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1382 / Virus Database: 1513/3702 - Release Date: 06/13/11

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Quickbooks to Dashboard

[Tom Dodds]

I know some of you have worked with interfacing Quickbooks into various U2 
products, but I was wondering if anyone has generated a Dashboard from the data 
garnered from Quickbooks.
I have a suspect that has a lot of data in Job costing within Quickbooks and is 
looking to generate a dashboard to get a better handle of the changes in their 
business.  Has anyone seen anything like this.

Thanks

Tom Dodds




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] serial #

[Tom]

No, darn. I have written basic programs to simulate the information. 

Sent from my iPhone
Tom Dodds
t...@ix.netcom.com
630.235.2975


On May 7, 2011, at 15:19, Larry Hiscock lar...@wcs-corp.com wrote:

 Does UV have the WHAT tcl verb like UD does?
 
 Larry Hiscock
 Western Computer Services
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
 Sent: Saturday, May 07, 2011 10:30 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] serial #
 
 
 Someone asked me the other day how they could determine their uv serial
 number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone
 know? 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Question about uvbackup dd and uvrestore

[Tom Dodds]

Ad
I am not directly associated with Ashwood Computer Companies, but after the 
thrashing others have taken for not including the Ad moniker on their 
postings I felt compelled.

Ashwood Computer Companies at www.ashwoodcomputer.com 
(do...@ashwoodcomputer.com) have a backup product that is specifically designed 
to work with MV databases and is quite capable and reliable.  You might want to 
look into their product.  You can find it on their web site.

Thanks


Tom Dodds



On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote:

 Hi all.
 I'm trying to pipe uvbackup (universe) and gzip in order to compress backups
 on the fly.
 I've done it with success. But the problem arise when I try to uvrestore
 from it.
 
 A simple test that you can try:
 
 RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 Label :
 
 Current device(s): stdout
 Backing up HS.SALES
 Backing up HS.SALES/VOC.u
 Backing up HS.SALES/D_VOC
 Backing up HS.SALES/VOCLIB
 Backing up HS.SALES/D_VOCLIB
 Backing up HS.SALES/CUSTOMER
 Backing up HS.SALES/CUSTOMER.u
 Backing up HS.SALES/D_CUSTOMER
 Backing up HS.SALES/D_CUSTOMER.u
 Backing up HS.SALES/PRODUCTS
 Backing up HS.SALES/PRODUCTS.u
 Backing up HS.SALES/D_PRODUCTS
 Backing up HS.SALES/D_PRODUCTS.u
 Backing up HS.SALES/STATES
 Backing up HS.SALES/STATES.u
 Backing up HS.SALES/D_STATES
 Backing up HS.SALES/D_STATES.u
 Backing up HS.SALES/HS_FILE_A000
 Backing up HS.SALES/D_HS_FILE_A000
 Backing up HS.SALES/.hs_fileinfo
 Backing up HS.SALES/VOC
 Backing up HS.SALES/.uvconfig
 Backing up HS.SALES/uvconfig
 Backing up HS.SALES/puntouvconfig
 
 Total files: 24  Total bytes : 97273  Elapsed Time: 00:00:01
 12 operating system files processed, 0 broken, totalling 41444 data bytes.
 12 UniVerse files processed, 0 corrupted.
 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes.
 -1073742616 extended keys processed, 0 not supported at specified revision
 level.
 
 EndOfUvbackup
 288+0 records in
 288+0 records out
 
 
 RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore  -v -i -t /dev/stdin
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 FastWrite On  : False
 Label :
 
 Current device(s): /dev/stdin
 
 WARNING: Block 1 checksum value of 0 does not match computed checksum
 of -6667.  Integrity of block questionable.  Continue (Y/N)?
 intended publication of source code.   *
 
 Total files: 0  Total bytes : 0  Elapsed Time: 12:00:00
 0 operating system files processed, 0 broken, totalling 0 data bytes.
 0 UniVerse files processed, 0 corrupted.
 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes.
 -1073742632 extended keys processed, 0 not supported at specified revision
 level.
 
 EndOfUvrestore
 26+0 records in
 25+0 records out
 RHEL:/u2/uv#
 
 
 Could someone explain why this happen?
 
 And the backup is all right, because it works if you change the syntax
 (without pipe):
 
 RHEL:/u2/uv# bin/uvrestore  -v -i -t hs_sales.bk
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 FastWrite On  : False
 Label :
 
 Current device(s): /u2/uv/hs_sales.bk
 HS.SALES (Apr 13 21:22:29)
 HS.SALES/VOC.u (Apr 13 21:22:29)
 HS.SALES/D_VOC (Apr 13 21:22:29)
 HS.SALES/VOCLIB (Apr 13 21:22:29)
 HS.SALES/D_VOCLIB (Apr 13 21:22:29)
 HS.SALES/CUSTOMER (Apr 13 21:22:29)
 HS.SALES/CUSTOMER.u (Apr 13 21:22:29)
 HS.SALES/D_CUSTOMER (Apr 13 21:22:29)
 HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29)
 HS.SALES/PRODUCTS (Apr 13 21:22:29)
 HS.SALES/PRODUCTS.u (Apr 13 21:22:29)
 HS.SALES/D_PRODUCTS (Apr 13 21:22:29)
 HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29)
 HS.SALES/STATES (Apr 13 21:22:29)
 HS.SALES/STATES.u (Apr 13 21:22:29)
 HS.SALES/D_STATES (Apr 13 21:22:29)
 HS.SALES/D_STATES.u (Apr 13 21:22:29)
 HS.SALES/HS_FILE_A000 (Apr 13 21:22:29)
 HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29)
 HS.SALES/.hs_fileinfo (Apr 13 21:22:29)
 HS.SALES/VOC (Apr 13 21:22:29)
 HS.SALES/.uvconfig (Apr 13 21:22:29)
 HS.SALES/uvconfig (Apr 13 21:22:29)
 HS.SALES/puntouvconfig (Apr 13 21:22:29)
 
 Total files: 0  Total bytes : 0  Elapsed Time: 12:00:00
 0 operating system files processed, 0 broken, totalling 0 data bytes.
 0 UniVerse files processed, 0 corrupted.
 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes.
 -1073742632 extended keys processed, 0 not supported at specified revision
 level.
 
 EndOfUvrestore
 RHEL:/u2/uv#
 
 
 Any suggestion?
 Regards
 --
 Augusto Alonso
 IT manager
 QUITER SERVICIOS CENTRALES
 Zoco Gran Santander, 1ª planta - 39011 Santander - España
 Telf: +34 902233323 - Fax: +34 902234280
 
 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al

Re: [U2] Question about uvbackup dd and uvrestore

[Tom]

Thanks for the clarification, Larry. With the verbal beating some people took 
over the last view weeks, I felt it better to be safe than beaten. 

Sent from my iPhone
Tom Dodds
t...@ix.netcom.com
630.235.2975


On Apr 15, 2011, at 11:54, Larry Hiscock lar...@wcs-corp.com wrote:

 LOL, Tom.  Just to clarify -- when users of a product or service praise the
 product or company, when they have no fiduciary stake or relationship to the
 company, the AD tag is not required.
 
 An AD tag is only required when someone stands to gain financially from the
 product or service that they're recommending.  It's just fair disclosure.
 
 Larry Hiscock
 Moderator
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Dodds
 Sent: Friday, April 15, 2011 5:44 AM
 To: U2 Users List
 Subject: Re: [U2] Question about uvbackup dd and uvrestore
 
 Ad
 I am not directly associated with Ashwood Computer Companies, but after the
 thrashing others have taken for not including the Ad moniker on their
 postings I felt compelled.
 
 Ashwood Computer Companies at www.ashwoodcomputer.com
 (do...@ashwoodcomputer.com) have a backup product that is specifically
 designed to work with MV databases and is quite capable and reliable.  You
 might want to look into their product.  You can find it on their web site.
 
 Thanks
 
 
 Tom Dodds
 
 
 
 On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote:
 
 Hi all.
 I'm trying to pipe uvbackup (universe) and gzip in order to compress
 backups
 on the fly.
 I've done it with success. But the problem arise when I try to uvrestore
 from it.
 
 A simple test that you can try:
 
 RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 Label :
 
 Current device(s): stdout
 Backing up HS.SALES
 Backing up HS.SALES/VOC.u
 Backing up HS.SALES/D_VOC
 Backing up HS.SALES/VOCLIB
 Backing up HS.SALES/D_VOCLIB
 Backing up HS.SALES/CUSTOMER
 Backing up HS.SALES/CUSTOMER.u
 Backing up HS.SALES/D_CUSTOMER
 Backing up HS.SALES/D_CUSTOMER.u
 Backing up HS.SALES/PRODUCTS
 Backing up HS.SALES/PRODUCTS.u
 Backing up HS.SALES/D_PRODUCTS
 Backing up HS.SALES/D_PRODUCTS.u
 Backing up HS.SALES/STATES
 Backing up HS.SALES/STATES.u
 Backing up HS.SALES/D_STATES
 Backing up HS.SALES/D_STATES.u
 Backing up HS.SALES/HS_FILE_A000
 Backing up HS.SALES/D_HS_FILE_A000
 Backing up HS.SALES/.hs_fileinfo
 Backing up HS.SALES/VOC
 Backing up HS.SALES/.uvconfig
 Backing up HS.SALES/uvconfig
 Backing up HS.SALES/puntouvconfig
 
 Total files: 24  Total bytes : 97273  Elapsed Time: 00:00:01
 12 operating system files processed, 0 broken, totalling 41444 data bytes.
 12 UniVerse files processed, 0 corrupted.
 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes.
 -1073742616 extended keys processed, 0 not supported at specified revision
 level.
 
 EndOfUvbackup
 288+0 records in
 288+0 records out
 
 
 RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore  -v -i -t /dev/stdin
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 FastWrite On  : False
 Label :
 
 Current device(s): /dev/stdin
 
 WARNING: Block 1 checksum value of 0 does not match computed checksum
of -6667.  Integrity of block questionable.  Continue (Y/N)?
 intended publication of source code.   *
 
 Total files: 0  Total bytes : 0  Elapsed Time: 12:00:00
 0 operating system files processed, 0 broken, totalling 0 data bytes.
 0 UniVerse files processed, 0 corrupted.
 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes.
 -1073742632 extended keys processed, 0 not supported at specified revision
 level.
 
 EndOfUvrestore
 26+0 records in
 25+0 records out
 RHEL:/u2/uv#
 
 
 Could someone explain why this happen?
 
 And the backup is all right, because it works if you change the syntax
 (without pipe):
 
 RHEL:/u2/uv# bin/uvrestore  -v -i -t hs_sales.bk
 
 Backup Date   : Wed Apr 13 21:22:29 2011
 Reel Number   : 1
 Image Type: Full Backup (ver9 UNIX)
 Block Size: 8192 bytes
 NLS on: False
 FastWrite On  : False
 Label :
 
 Current device(s): /u2/uv/hs_sales.bk
 HS.SALES (Apr 13 21:22:29)
 HS.SALES/VOC.u (Apr 13 21:22:29)
 HS.SALES/D_VOC (Apr 13 21:22:29)
 HS.SALES/VOCLIB (Apr 13 21:22:29)
 HS.SALES/D_VOCLIB (Apr 13 21:22:29)
 HS.SALES/CUSTOMER (Apr 13 21:22:29)
 HS.SALES/CUSTOMER.u (Apr 13 21:22:29)
 HS.SALES/D_CUSTOMER (Apr 13 21:22:29)
 HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29)
 HS.SALES/PRODUCTS (Apr 13 21:22:29)
 HS.SALES/PRODUCTS.u (Apr 13 21:22:29)
 HS.SALES/D_PRODUCTS (Apr 13 21:22:29)
 HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29)
 HS.SALES/STATES (Apr 13 21:22:29)
 HS.SALES/STATES.u (Apr 13 21:22:29)
 HS.SALES/D_STATES (Apr 13 21:22:29)
 HS.SALES

Re: [U2] Databasic conversion

[Tom Dodds]

I have been involved in a number of migrations.

I have stubbed my toes on several issues.
Printers
Assembly language code/C++/ what ever foreign external code
Interface to external devices, scanners, funny printers/plotters, etc.

The issues of printers is the most common.  Users and developers are use to 
seeing printers react in a certain manner and when they don't react as expected 
it can derail an entire migrations.  I had one client that refused to test 
every printer, as recommended, and had to cancel the scheduled cut over because 
they could only address 64 of their 200 printers at one time.  If you are using 
a spooler, check with the developer to be sure it will work on the new 
platform, if you can still find the developer. 

HTH

Tom Dodds
t...@ix.netcom.com
630.235.2975



On Apr 15, 2011, at 10:04 AM, fft2...@aol.com wrote:

 In a message dated 4/15/2011 5:43:33 AM Pacific Daylight Time, 
 u...@edclark.net writes:
 
 But then we decided we wanted to upgrade the universe system and have all 
 our accounting users on that. Just about everything else was ok, but it 
 took the var 3 months of work to convert the procs to work on universe. 
 
 Can you explain a bit more this statement about Procs and Universe ?
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] User LogOut Cabbage

[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
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David
Sent: Tuesday, March 08, 2011 8:22 PM
To: 'U2 Users List'
Subject: Re: [U2] User LogOut Cabbage

Are you clearing your SAVEDLISTS directory from UNIX (scheduled or manually) 
and then this error appears?

If so, it is probably deleting the required .Type19 entry (within the 
SAVEDLISTS directory.

Possible solution: purge away, but re-create the .Type19 file using 'touch 
.Type19' or the like in your UNIX script. )...refrain from doing when you have 
users logged in too. Perhaps use CLEAR.FILE instead from within UV instead?

Regards,
David


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Wednesday, 9 March 2011 9:35 AM
To: U2 Users List
Subject: [U2] User LogOut Cabbage

When a user here logs out of UniVerse on HP-Ux, it comes back with repeating...

Mkpath: @SAVEDLISTS/S.maryann.14 is not a directory

Suggestions would be appreciated.

--Bill

** IMPORTANT MESSAGE *   
This e-mail message is intended only for the addressee(s) and contains 
information which may be confidential. 
If you are not the intended recipient please advise the sender by return email, 
do not use or disclose the contents, and delete the message and any attachments 
from your system. Unless specifically indicated, this email does not constitute 
formal advice or commitment by the sender or the Commonwealth Bank of Australia 
(ABN 48 123 123 124) or its subsidiaries. 
We can be contacted through our web site: commbank.com.au. 
If you no longer wish to receive commercial electronic messages from us, please 
reply to this e-mail by typing Unsubscribe in the subject line. 
**



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] SB+ positions available

[Tom Dodds]

I know a company that is looking for SB+ North America based contract 
programmers for 3 months projects (to test you) and then you commonly get 
extended for 6 or 9 months more.  Work on-site for project kick off, then 
remote, on-site for code drops and go-live.  Pays well, including TL.  Please 
forward me your contact information with resume and I’ll make the introduction

I know no more about these positions than is stated in the prepared 
announcement above, so don't ask me any questions, just send me your contact 
info and your resume and I will forward it on to the employer.

Good luck.

Tom Dodds
t...@ix.netcom.com
630.235.2975



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SB+ positions available

[Tom Dodds]

I really don't know anything more than was included in their pre-prepared 
announcement.


Send me you resume and I will pass it on and then you will know.

Tom Dodds
t...@ix.netcom.com
630.235.2975



On Mar 4, 2011, at 12:03 PM, Paul Wilson wrote:

 Where ?? I don't care who at the moment - but where does matter.
 
 
 
 
 
 From: Tom Dodds t...@ix.netcom.com
 To: U2 User group u2-users@listserver.u2ug.org
 Sent: Fri, March 4, 2011 1:01:11 PM
 Subject: [U2] SB+ positions available
 
 I know a company that is looking for SB+ North America based contract 
 programmers for 3 months projects (to test you) and then you commonly get 
 extended for 6 or 9 months more.  Work on-site for project kick off, then 
 remote, on-site for code drops and go-live.  Pays well, including TL.  
 Please 
 forward me your contact information with resume and I’ll make the introduction
 
 I know no more about these positions than is stated in the prepared 
 announcement 
 above, so don't ask me any questions, just send me your contact info and your 
 resume and I will forward it on to the employer.
 
 Good luck.
 
 Tom Dodds
 t...@ix.netcom.com
 630.235.2975
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Scripps Networking Services - softwaresearch.com

[Tom Gorton]

Definitely a thumbs up from me for Larry and his organization. They have helped 
me out over the years getting me first class opportunities including my current 
one.
 
 
Regards,
 
Tom Gorton
Laars Heating Systems
20 Industrial Way
Rochester, NH 03867
Phone: 603-834-6833
email: tgor...@laars.com 
 


 On 2/25/2011 at 8:25 AM, in message 
 546618.12977...@web120706.mail.ne1.yahoo.com, Dave Costello 
 accretiondisk0...@yahoo.com wrote:
Hello David,

   Larry is definitely a good guy. He got me my current job and I have been 
here 5+ years.

Good luck.  



  
___
U2-Users mailing list
U2-Users@listserver.u2ug.org 
http://listserver.u2ug.org/mailman/listinfo/u2-users

-
NOTICE: The information transmitted is intended only for the person or entity 
to which it is addressed and may contain confidential and/or privileged 
material. Any review, retransmission, dissemination or other use of, or taking 
of any action in reliance upon, this information by persons or entities other 
than the intended recipient is prohibited. If you received this in error, 
please contact the sender and delete the material from any computer.
-

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Clear Messages

[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.org] On Behalf Of u2ug
Sent: Friday, February 11, 2011 8:48 AM
To: U2 Users List
Subject: Re: [U2] Clear Messages

I believe those are the program counters




-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: February 10, 2011 06:29 PM
To: U2 Users List
Subject: [U2] Clear Messages

The following program (and sub) returns the following string.  What is nice 
about it is that if running SYSTEM(9001) from a sub, it comes back with the 
grand path.  

2ý/usr/ibm/uv/catdir/*SUB.GET.PROGR/AM.NAME.R0ý0x0þ1ý/u2/CODE/B.BP.O/GET.CODE.DATA.R0ý0x16aþ

What is the significance of the data at the end of the sub-strings... that 
is... 0x0  and   x16a ?

--Bill

*

  call *SUB.GET.PROGRAM.NAME.R0(Who.Am.I)
  
  crt  Who.Am.I

*

SUBROUTINE SUB.GET.PROGRAM.NAME.Rx(This.Program.Name)

  This.Program.Name = SYSTEM(9001)
  
RETURN  
END

Thanks to those who responded earlier especially Steve and Will.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Pick Dinosaurs

[Tom]

I started on a Microdata in 1972, first system in Seattle,Wa

Sent from my iPhone
Tom Dodds
t...@ix.netcom.com
630.235.2975


On Feb 7, 2011, at 10:56, Peter S. Goldberger pet...@eoftech.com wrote:

 Started in 1984 on an ADDS Mentor with a 40 Mb hard disk and 12 tape
 
 George Gallen wrote:
 and we had to walk to work in bare feet uphill both ways!
 
  
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com
 Sent: Monday, February 07, 2011 11:52 AM
 To: U2 Users List
 Subject: Re: [U2] Pick Dinosaurs
 

 I started on Microdata systems back in 1982.  Same big 'ol washtub

 drives,

 1/2 reel tapes and Interrupt-Reset-Interrupt or
 Interrupt-Reset-Clock-Interrupt paddle-switch sequences.
The first machine I worked on was a Microdata 1600 with 4 50 MB

 Winchester

 washtub drives.  It ran 16 users on 64K of core memory.  That was

 back
 in

 1981.

 Wow.  You guys are really old.
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 
  
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Pick Dinosaurs

[Tom]

Jerry:

I also worked for Victor tech, as a contractor in about '82, but that was after 
they sold the computer division to Tandy. I maintained an Arev application for 
about 5 years for a company that sold, and is still selling, the calculators. 

Sent from my iPhone
Tom Dodds
t...@ix.netcom.com
630.235.2975


On Feb 7, 2011, at 21:22, Jerry jpb-u...@hotmail.com wrote:

 I also started in 1972 on point of sale systems at Victor Comptometer 
 Corporation. At the time we were a US manufacturing facility for Noxdorf 
 Computers. I didn't get into a Pick flavor until 1980 when I started work at 
 Prime Computers. I think at tat time Primos was 16 something and Prime 
 Information was around 4 or 5. It's been a long time.
 
 Jerry
 
 On 2/7/2011 12:48 PM, Steve Romanow wrote:
 Earliest we've seen yet. Awesome! You early adopter!
 
 On 2/7/2011 1:45 PM, Tom wrote:
 I started on a Microdata in 1972, first system in Seattle,Wa
 
 Sent from my iPhone
 Tom Dodds
 t...@ix.netcom.com
 630.235.2975
 
 
 On Feb 7, 2011, at 10:56, Peter S. Goldbergerpet...@eoftech.com
 wrote:
 
 Started in 1984 on an ADDS Mentor with a 40 Mb hard disk and 12 tape
 
 George Gallen wrote:
 and we had to walk to work in bare feet uphill both ways!
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of
 charles_shaf...@ntn-bower.com
 Sent: Monday, February 07, 2011 11:52 AM
 To: U2 Users List
 Subject: Re: [U2] Pick Dinosaurs
 
 
 I started on Microdata systems back in 1982. Same big 'ol washtub
 
 drives,
 
 1/2 reel tapes and Interrupt-Reset-Interrupt or
 Interrupt-Reset-Clock-Interrupt paddle-switch sequences.
 The first machine I worked on was a Microdata 1600 with 4 50 MB
 
 Winchester
 
 washtub drives. It ran 16 users on 64K of core memory. That was
 
 back
 in
 
 1981.
 
 Wow. You guys are really old.
 
 Charles Shaffer
 Senior Analyst
 NTN-Bower Corporation
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Data in Dict

[Tom]

My experience with the Pick O/S - database of nearly 40 years has taught me 
that once you truly understand it's power you stop trying to change it.

Sent from my iPhone
Tom Dodds
t...@ix.netcom.com
630.235.2975


On Jan 24, 2011, at 9:12, Jeff Schasny jscha...@gmail.com wrote:

 My thoughts exactly. We have a perfectly good database here, why not use it. 
 Storing data in a dictionary has always been a bad idea, even the ubiquitous 
 next.available record key.
 
 
 David A. Green wrote:
 All this talk about using the Dictionary item to store extra data has
 prompted this post.
 
 I realize in the past when the limit to the number of Opened Files in a
 Basic program was a programming challenge, that doing creative data storage
 might have been an necessity.  But I would like to suggest we leave the
 Dictionary alone, let the database use it the way it wants to and let us
 create our own storage device for dictionary related data.
 
 Thoughts?
 
 David A. Green
 (480) 813-1725
 DAG Consulting
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
  
 
 -- 
 
 Jeff Schasny - Denver, Co, USA
 jschasny at gmail dot com
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] PORT.STATUS questions.

[Tom Dodds]

Good question, Dan

Tom Dodds
t...@ix.netcom.com
630.235.2975



On Dec 30, 2010, at 12:22 PM, Dan Fitzgerald wrote:

 
 Did real estate prices also cause you to stop putting [ad] in your 
 advertisements?
 
 From: fft2...@aol.com
 Date: Thu, 30 Dec 2010 13:19:17 -0500
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [UV] PORT.STATUS questions.
 
 In a message dated 12/30/2010 8:46:12 AM Pacific Standard Time, 
 donr_w...@yahoo.com writes:
 
 
 I use PORT.STATUS for several function within programs by capturing the 
 output 
 and parsing it. I have a couple of problems with this.
 
 First, only one user at a time can run the command and this causes random 
 failure of the programs.
 Second, the output can vary depending on options and success or failure of 
 the 
 command.
 
 So, is there a callable routine to get the same info in a cleaner way?
 
 
 Yes. If you have a budget.
 The solution is rather elegant, but also proprietary... to me.
 You have to buy a license. I stopped giving away free software when real 
 estate went South :)
 
 Will Johnson
 Fast Forward Technologies
 831 477 7125
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Uppercasing in SELECT

[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 Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of 
charles_shaf...@ntn-bower.com
Sent: Friday, December 03, 2010 10:38 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Uppercasing in SELECT

I need to SELECT on a name field that has mixed case and has never been 
enforced.  John Smith might be entered as John Smith, JOHN SMITH, John, 
etc.  I can UPCASE the user supplied search argument and do a partial 
string match, but I am not sure how to handle the SELECT.

Is there an option in a SELECT to ignore case?  Or alternatively, if I 
make a virtual attribute to upcase the data value, what is the best way?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Compiling 101

[Tom Dodds]

Good try,  First off when you created the file, CODE, you had to be sure to 
create a Type 1 on Type 19 file.  These are really Unix directories and 
accessible to the basic compiler which is a Unix program.  Secondly the compile 
command, in your case would be BASIC CODE FLAVOR.RO.  The second argument is 
the name of the directory where you placed your source code and the third is 
the program name as you have already surmised. 

HTH

Tom Dodds
t...@ix.netcom.com
630.235.2975



On Oct 19, 2010, at 7:29 PM, Bill Brutzman wrote:

   I created a new UV account
 /u2/CODE
 
   I put a program in /u2/CODE/BP/FLAVOR.R0.
   I was not able to compile the program.  
 
   When I ran the command BASIC BP FLAVOR.R0
   I obtained an error message 
Unable to open BP file.  
 
   I did a Unix CHMOD command on the parent folders and the file 
 to 777 but still get the same error.
  I suppose that it is a Q pointer PATH thing.
   Help would be appreciated.
 
 --Bill
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [U2} Cloud UniVerse?

[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
Sent: Monday, October 04, 2010 10:43 AM
To: U2 Users List
Subject: [U2] [U2} Cloud UniVerse?

In case of a local disaster, we are wondering if there is available hosted 
UniVerse.

I suppose that there is a license hurdle.  I suppose it would be great if 
Rocket would consider doing hosting.  I looked at Sierra Bravo's website.

Suggestions would be appreciated.

--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [U2} Cloud UniVerse?

[Tom Whitmore]

Printing is not a problem.  We have customers that are using a hosted solution 
and Printing works fine.  You should have a secure connection between your 
network and the server, so setting up printers is it is an internal server.
Tom
RATEX Business Solution.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Monday, October 04, 2010 2:33 PM
To: U2 Users List
Subject: Re: [U2] [U2} Cloud UniVerse?

Tony:

Thanks for writing.

I expect that one of the kickers in this is printing forms.  Right now I cannot 
see how to send print jobs from the cloud host through our static IP router to 
our printers.

Also, I sent a message to our sales rep at Rocket to ask about how licensing 
would work.  That is, would we need to buy more seats or is there special 
pricing for disaster recovery seats.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, October 04, 2010 1:52 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [U2} Cloud UniVerse?

Knowledge about the platform is certainly a good thing, but is it necessary?

What's wrong with getting root-level Linux or Windows from any number of 
providers, and simply hosting your own environment?
This is quite simple, really.  Base pricing ranges from $15/month though maybe 
$100/month depending on disk, traffic, and memory.
I know some U2 sites are hosting with CoLo's with various services totally 
anyhere from $400 to $800 per month.

My recommendation: Find a low-cost host that provides root access for Linux or 
Windows.  Install and configure your U2 environment within the usual money-back 
trial period of 30 days or so.  Don't make any long term commitments.  If you 
don't like it you have spent zero to maybe $30.  Once you have the software 
installed you will know more about your actual needs.  Then you can decide 
whether you need the services of a company like Zumasys (well recommended with 
MV expertise) or RackSpace  (well recommended but no U2-specific experience).

Also consider using Amazon services where you only power-on the virtual system 
(and pay for use) when you need it.

Don't want to do this yourself?  Find a well qualified U2 support company and 
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://Twitter.com/TonyGravagno

 From: Tom Whitmore
 We had looked into hosted solutions. Check out Sumasys (zumasys.com), 
 they are very knowledgeable about U2, or
RackSpace.

 From: Bill Brutzman
 In case of a local disaster, we are wondering if there is available 
 hosted UniVerse.
 I suppose that there is a license hurdle.  I suppose it would be great 
 if Rocket would consider doing hosting.  I looked at Sierra Bravo's 
 website.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Sequential Files Question

[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, or write an end of file mark at the 
end of an existing file, making the file null.

If you want to keep the data, if the file exists, then add the WEOFSEQ in an 
OPENSEQ ELSE condition... but you need to position the pointer to the end of 
the file or you will be stepping on existing data.

Tom
RATEX Business Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: Wednesday, September 08, 2010 10:15 PM
To: U2 Users List
Subject: Re: [U2] Sequential Files Question

I GET THE FOLLOWING MESSAGE [FATAL ERROR: - Cannot open file
C:\OUTPUT\APCHECKS1002] and I'm sent to the colon prompt. 


Al DeWitt

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Wednesday, September 08, 2010 7:20 PM
To: U2 Users List
Subject: Re: [U2] Sequential Files Question

If you run this code:

OPENSEQ FNAME TO OUTFILE ON ERROR
   STOP 'FATAL ERROR: - Cannot open file ':FNAME END THEN
   STOP 'FATAL ERROR: - Already exiting file called: ':FNAME END ELSE
   CRT FILE OPEN SUCCEEDED!
   WRITESEQ Dummy data ON OUTFILE THEN NULL END

What happens?


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: Thursday, September 09, 2010 10:03 AM
To: U2 Users List
Subject: Re: [U2] Sequential Files Question

I forgot to mention that I'm on Windows.

My output path is: C:\OUTPUT\
My file name isAPCHECKS where is a counter that gets incremented
each time the program is run.

FNAME would be C:\OUTPUT\APCHECKS so that my statement would read:
OPENSEQ FNAME TO OUTFILE...

However, since APCHECKS would be unique each time it doesn't exist.


BTW when I try to display OUTFILE it gives me an Unitialized Variable,
zero assumed error.

Al DeWitt

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Wednesday, September 08, 2010 6:29 PM
To: U2 Users List
Subject: Re: [U2] Sequential Files Question

Yes, it will. 

Note: It will drop into the 'ELSE' clause if the file didn't exist to
start with.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt
Sent: Thursday, September 09, 2010 8:55 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Sequential Files Question

Unidata 7.1.20
 
I've never dealt with sequential files, but I have a need to output
records to a text file.  Each record will be a series of fixed-length
fields.  Each file will need to be created at the time of opening.  The
destination will be a Windows folder on one of our servers.  I will be
using OPENSEQ to open the file.  However, since each file needs to be
created at time of opening what do I use to create the file?  My reading
of OPENSEQ doesn't indicate that it will create it automatically if it
doesn't exist.
 
Thanks.
 
Al DeWitt
 
 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__

###
The information transmitted in this message and attachments (if any) is
intended only for the person or entity to which it is addressed. The
message may contain confidential and/or privileged material.  Any
review, retransmission, dissemination or other use of or taking of any
action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.  If you received this in
error, please contact the sender and delete the material from any
computer.

The intended recipient of this e-mail may only use, reproduce, disclose
or distribute the information contained in this e-mail and any attached
files with the permission of IMB.

###
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Shared Record Locks

[Tom Whitmore]

Thanks Mecki!
That is what I was trying to relay.

The only conceivable reason that I can think of for READL is if you have a 
process where you want to be able to have more than one person pull up a 
record, so they could discuss it, and not have the data change between the 
two reads.  In real life, I think there are a lot of ways to handle this 
situation without using READL.

Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, September 01, 2010 3:28 AM
To: U2 Users List
Subject: Re: [U2] [UV] Shared Record Locks

 Hi Stuart,

you are talking about READU not READL.
Of course it is dangerous to allow a user to read a record without
locking it if that user can then write that record back.
But READL will not allow any user to WRITE, not even the holder of the
lock unless all locks have been released.
OTOH it is contrary to your statement quite useful not to lock
everything during a process when no update will occur.
Why lock the customer master record for instance if it is only read to
display the name and address on a screen?
And even your example with the exchange rate doesn't really make sense.
If you want to make sure the exchange rate doesn't change then you read
it once and assign the value to a variable.
Especially on large systems locking the exchange rate record of a
popular currency every time somebody reads it can cause serious problems.
And no, I don't think this would be a good application for READL, since
you only can update the exchange rate once all locks have been released.
Imagine you have 1000 or more users and the poor person trying to update
exchange rates has to wait until everybody who uses a process that uses
this rate to release their locks.

Mecki




On 01/09/2010 07:25, Boydell, Stuart wrote:
 Hi Tom,
 READL is useful. Normatively, DBMS theory says you should lock *everything* 
 during a process to guarantee that other processes aren't making changes to 
 the db underneath your process. In practice, I've seen a lot of code which 
 doesn't do this. Most of these systems must simply get away with it through 
 sheer dumb luck.

 Looking at the standard read mechanism; Consider two sessions (pid 101  102) 
 running on a U2 database both READ a customer record, X at the same time 
 (without locking). Both processes update a comments field; both processes 
 write X back to file.
 (101 reads X, 102 reads X, 101 changes X, 102 changes X, 101 writes X, 102 
 writes X.)

 In the scenario above the comments added by 101 are lost because 102 
 overwrites the changes made by 101. 

 This is an obvious problem with concurrent use of a DB. To fix this you use 
 pessimistic locking and an update lock, READU. This will ensure that if 101 
 and 102 both try to READU the record, the second process will fail (hopefully 
 gracefully).

 All good. Now what if the user also needs to read (and not update) a shared 
 parameter item? For example, a spot currency conversion rate.

 Consider if your process (101) reads, without locking, a rate, while another 
 (102) updates it; you do some processing with the old rate, writes some 
 files, calls a subroutine that re-reads the rate that has just been written 
 by 102 and then does some calculations and writes to some more files - the db 
 could now be inconsistent with figures calculated against both the old and 
 new rate.
 (101 reads rate, 102 reads rate, 102 changes rate, 102 writes rate, 101 
 calculates partly based on old rate and new rate).

 If you (101) were to use READU it would stop other processes from updating 
 the rate while you were doing your calculation but also any other processes 
 which needed to just read the rate record (because they would also be using 
 READU). That could get annoying for users! This is where READL is useful, as 
 it allows a shared lock to be set - ensuring that the record can't change 
 while your (or any other) process has a shared lock on it but allowing the 
 record to be read by any number of processes. The updating process would have 
 to wait till it could get a READU before changing the data.

 If you use BEGIN/END TRANSACTION in a program then within the transaction 
 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 mandatory.

 Hope that helps.
 Cheers,
 Stuart

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
 Sent: Wednesday, 1 September 2010 11:51
 To: U2 Users List
 Subject: Re: [U2] [UV] Shared Record Locks

 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

Re: [U2] [UV] Shared Record Locks

[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 READL, because WRITES require a record lock.

As I said, I don't understand why anyone would use it.

Tom
RATEX Business Solutions.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble
Sent: Tuesday, August 31, 2010 7:07 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] [UV] Shared Record Locks

When you have data you want to update, but do not want to prevent people from 
viewing the rest of the data.

I.E. Updating patient information for the next insurance enrollment period, and 
still letting customer service reps access the data to help customers.

HTH
-Dan

- Original Message -
From: u2-users-boun...@listserver.u2ug.org 
u2-users-boun...@listserver.u2ug.org
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue Aug 31 15:34:51 2010
Subject: [U2] [UV] Shared Record Locks

Has anyone a real-world application where UniVerse shared record locks
are used?  I'm struggling with when they would be preferable to using an
update record lock.  Anyone willing to share their experiences?

Thanks.

Perry Taylor
ZirMed
626 West Main St , 6th Floor
Louisville, KY 40202
www.zirmed.com http://www.zirmed.com/ 




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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, 2010 9:12 AM
To: U2 Users List
Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines?

If I do that, then I lose the features of the Reality Account correct? Or
Do I change it, catalog the routine, then change it back?

The problem is that those accounts were imported from a Reality system, and I
  wanted to use some of the subroutines that were written on another account
  imported from a Prime system.


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
 Sent: Thursday, August 26, 2010 5:16 AM
 To: U2 Users List
 Subject: Re: [U2] Does Reality Flavor have globally cataloged
 subroutines?
 
 George,
 
 Modify the VOC entry for CATALOG so that field 6 contains
 INFORMATION.FORMAT. This will give you the full features of the
 CATALOG
 verb as in Ideal, Information and PI/open accounts.
 
 You can call a globally catalogued subroutine from all account types.
 Just
 remember to include the prefix character.
 
 
 Martin Phillips
 Ladybridge Systems Ltd
 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
 +44 (0)1604-709200
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com
Sent: Tuesday, July 13, 2010 8:29 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Universe: AE just ... disappears?

Comparing the stability of UV with the instability of Windows, I think your 
problem lies elsewhere.

By the way catalog pointers can disappear if someone (or someTHING) does a 
Decatalog.  I've seen cases where programmers write routines to decatalog 
which works and then try to recatalog the *new* version and it fails.  Voila 
your pointer is gone and replaced by nothing.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] SB+ PA Compare

[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 the project(s) on.

The beauty of PRC is you can track what changes are made, why, and reverse the 
changes if needed.  You also have control over what is going out to customers.

Tom
RATEX Business Solutions

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony Youngman
Sent: Wednesday, June 02, 2010 4:59 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SB+ PA Compare

I'm not a mercurial user - I'm learning git, but what's wrong with a
DVCS? Yes it would be nice if each dev could have their own account, but
you're assuming one dev per DVCS instance. Why not one account per
DVCS instance? But by not giving each dev their own account, you're
throwing all the advantages of ANY version control system! Whether it's
Mercurial, git, SCCS, CVS, Visual Source Safe, as soon as you have devs
fighting over access to the source you're giving yourself a headache.
Centralised system, distributed system, it's all the same.

Let me give you an example method of working with git, several devs, one
test environment. Pretty safe bet you can translate this into Mercurial
terms easy enough.

Each dev has their own test account, probably can't do an awful lot
there, but they do all their coding, compiling, and basic unit testing
in their own account. They can then push their changes to a branch in
the central test account to test them. When they're happy, they can
merge them into the main branch. If several devs are fighting over the
central test account, the fact that git allows very rapid changes
between branches means that one can have it for however long it takes,
then revert his changes leaving it clean for the next one, so you can
switch the test account rapidly. And more importantly, dev A *can't*
step all over

My experience of cvs's commercially was either none (for UV, had to
track everything manually), or VSS for VB where it was a right pain when
I had something checked out for dev work and somebody else needed it for
a quick bugfix, or vice versa.

Thing is, you can put procedures in place so that a DVCS has strict
central control. You can't set up a centralised VCS to give several
developers flexibility to work on the same code at the same time.

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Can't RESIZE some files

[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 your login paragraph 
so files aren't opened.
Tom

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David 
(Health)
Sent: Wednesday, May 26, 2010 11:50 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Can't RESIZE some files

We are trying to use RESIZE * * * on a couple of dynamic files to reclaim 
unused disk space. RESIZE complains that it hasn't got exclusive access, even 
though LIST.READU EVERY shows no locks at all, fuser -u shows no one using the 
.30 files, and UniVerse (10.0.16) having been stopped and started. We can 
resize other dynamic files with no problems. There's plenty of room for the 
temporary files.
How can we persuade RESIZE that these files aren't open ?

Thanks,

David Norman
Senior Software Engineer - SA Ambulance Service

ICT Services
SA Health
Government of South Australia

Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* david.nor...@health.sa.gov.au


This e-mail may contain confidential information, which also may be legally 
privileged. Only the intended recipient(s) may access, use, distribute or copy 
this e-mail. If this e-mail is received in error, please inform the sender by 
return e-mail and delete the original. If there are doubts about the validity 
of this message, please contact the sender by telephone. It is the recipient's 
responsibility to check the e-mail and any attached files for viruses.



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor
Sent: Thursday, May 20, 2010 1:44 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] SSH Telnet Server for NT, W2000, XP?

Would anyone care to recommend a Secure Shell Telnet Server that will run on 
NT/W2000/XP?

Thanks,

Dave Taylor
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
(O) 800-SYSMARK (800-797-6275)
(F) 310-377-3550
(C) 310-561-5200
www.sysmarkinfo.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Updating SQL database from Universe 10.3

[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 SOAP, and XML, is that it is multi-dimensional and the 
SOAP service takes care of extracting the data.  This is also OS independent.  
We have customers on AIX, Linux, HPUX, Sun, Windows,... and we don't care.  The 
big one concern is designing efficient XML data sets.

Because of the memory problems, we limit how many records are processed at a 
time, and how many loops, before the phantom shuts down and another starts.

We are using it for our ecommerce solution.  We had some bumps along the way, 
but it is proving to be reliable.  At this point, the biggest problem is design 
flaws in the XML data.

Tom
RATEX Business Solutions.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies
Sent: Wednesday, April 14, 2010 3:13 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Updating SQL database from Universe 10.3

Good Day,

 

I need to update SQL database/tables from Universe, and I was wondering if
anyone has done this in production mode in real-time mode.

 

I will be updating the files in the legacy platform, and then I need to
perform real-time updates on SQL database. 

 

Best regards,

 

Ara Baghdasraian /USC

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

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

[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 they are moving to .Net.  preferred communication is via 
a secure pipe (ssh or ssl) but it also supports telnet. 
 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Thursday, April 08, 2010 1:16 PM
To: 'U2 Users List'
Subject: [U2] Quick poll - how many use 3-tier or N-tier Architecture

Would those of you mind responding that use 3-Tier or N-Tier architecture - I'm 
trying to gather some quick numbers for some decision makers (somewhat urgent).

Please respond if your site, or sites who you service have UniData, UniVerse, 
or any other MV db on the backend, and any fully graphical user interface:

a.  How many have a middle-tier application server?
b.  How many use IBM Websphere?
c.  How many use some other? Please give product name if you can.
d.  How many have a Java front end User Interface?
e.  How many have a C# front end User Interface?
f.  How many have other UI? Please give name.

For anyone - what Multi-Value aware / friendly middleware products are there?  
(That don't require data normalization before sending to the middleware.)

Thank you so much,
-Baker



  
This communication, its contents and any file attachments transmitted with it 
are intended solely for the addressee(s) and may contain confidential 
proprietary information.
Access by any other party without the express written permission of the sender 
is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy, distribute 
or use the contents, attachments or information in any way. Please destroy it 
and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] FTP Users in HP-UX

[Tom]

I had sent a response to the group that the mystery was solved. Did not 
have an /etc/shells file.



On 4/6/2010 10:56 AM, Charlie Rubeor wrote:

I didn't want to bother the list, but are you still having this issue?

On 4/1/2010 8:12 AM, Tom wrote:

We have something strange happening with FTP on our UNIX box. We have
some users setup to FTP files from our windows server to the UNIX box.
They were working fine until we rebooted the UNIX server. Now none of
them have FTP access into the UNIX box. This was the first time the
box had been rebooted since setting them up. These logins can telnet
in fine but cannot ftp.

I have reviewed all the settings and believe they are all correct. I
am not a UNIX guru but know enough to be dangerous;) Wish there was a
setting up FTP for Dummies instruction manual. Any clues as to what
may be part of the puzzle I am missing?

Hardware : HP
Operating system : HP-UX
O.S. version : B.11.00
UniData version : 6.1.16

Tom
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] sudo for dummies

[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 the 
uniadmin user.  I also believe U2 is making this more functional.

Tom
RATEX Business Solutions.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Rodgers
Sent: Friday, April 02, 2010 8:08 AM
To: U2 Users List
Subject: [U2] sudo for dummies

I have a problem with a developer login where we want to provide 'root'
privileges on our DEV box.

 

HP-UX B.11.11 U 9000/800 (tl)

UniVerse 9.6 in Pick flavor

 

 

This is done by changing the login profile to run something this:

 

exec /usr/local.bin/sudo /usr/opt/uv/bin/uv

 

This gives us 'root' access in UniVerse.

 

For one user this is not working but I cannot spot any difference in his
setup from anyone else's.

 

The exec sudo (above) is changing the user id to root.

For our other users the @LOGNAME in UniVerse does not change.

Our login process relies on the @LOGNAME to perform some other checks
which are now failing for this user.

 

Can anyone explain why the user.id would be changed by 'sudo'.

Is there some setting or switch for sudo where this is controlled?

 

Alternatively, is there a UniVerse option where the User Name might be
somehow reset? (really clutching at straws here.)

 

 

Cheers

 

JR

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] FTP Users in HP-UX

[Tom]

We have something strange happening with FTP on our UNIX box. We have 
some users setup to FTP files from our windows server to the UNIX box. 
They were working fine until we rebooted the UNIX server. Now none of 
them have FTP access into the UNIX box. This was the first time the box 
had been rebooted since setting them up. These logins can telnet in fine 
but cannot ftp.


I have reviewed all the settings and believe they are all correct. I am 
not a UNIX guru but know enough to be dangerous;) Wish there was a 
setting up FTP for Dummies instruction manual. Any clues as to what may 
be part of the puzzle I am missing?


Hardware : HP
Operating system : HP-UX
O.S. version : B.11.00
UniData version  : 6.1.16

Tom
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users