[U2] UniVerse 10.0.19 abnormal termination

2005-07-14 Thread Kezic, David
Hi all.

In attempting to track down an issue causing abnormal termination of
Universe I have discovered the following scenario which causes this to
happen.  I would have expected universe to report a variable unassigned
or equivalent in this case without dropping out of UV.  Have passed this
on to UV support.

Thoughts/comments anyone?

The routine below demonstrates the issue.

DK.TEST
* Test routine to cause UV to abort with following error
*
* Program "DK.TEST": Line 16, Variable "VAL" previously undefined.
Empty string used.
* Abnormal termination of UniVerse.
* Fault type is 11.  Layer type is BASIC run machine.
* Fault occurred in BASIC program DK.TEST at address 3a.
* /usr/contrib/bin/uv_connect[21]: 5621 Memory fault
*
* RELLEVEL as follows
* 001: X
* 002: 10.0.19
* 003: PIOPEN
* 004: PIOPEN.FORMAT
* 005: 10.0.19
*

$INCLUDE SYSCOM ATFUNCTIONS.INS.IBAS
*
  EQUATE BG LIT "@(IT$SHALF)"
  EQUATE FG LIT "@(IT$EHALF)"
*
  DIM TEMP(2)
*
  VAL = TEMP(1)
*
  CNT = COUNT(VAL, BG) + COUNT(VAL, FG)
*
  STOP
*
   END


> ___
David Kezic
Systems Analyst Programmer
> Royal Automobile Club of W.A.
> 228 Adelaide Terrace
> Perth  WA   6000
> AUSTRALIA
>
> p  08 9421 4321
> f   08 9421 4319
> e  [EMAIL PROTECTED]
> w rac.com.au
>


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] THE variable names

2005-07-14 Thread Larry Hiscock
What systems DON'T support REMOVE?  I cut my teeth in the MV world back in
1979 on Microdata Reality, and it had REMOVE.  Since then I've worked on a
variety of other MV systems, including Ultimate, Prime Information, UniVerse
and UniData, among others that I've probably forgotten.  I can't recall any
of them that didn't support REMOVE.

Larry Hiscock
Western Computer Services


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Thursday, July 14, 2005 8:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] THE variable names

Don't cast such stones on us 'old pro's. Many of us have spent more time
with these older systems prior to the current system than many have with
their only systems. There is an evolution with these MV systems that allows
us to be a little cautious of new, platform specific 'features'.

At present I have active accounts in Microdata, UV, UD, AP-Pro, D3, MvBase
and R90. All support DCOUNT etc and it gets a little hard to remember which
system supports REMOVE or SELECT TO. I for one got a little tired with the
LOCATE differences and the EXECUTE/PERFORM syntaxes. So I go with the
trusted, comprehensive methods.

My productivity isn't hampered by using DCOUNT instead of REMOVE. I won't
yield to a cpu cycle argument either. Given the tremendous amount of poor
programming that I have inherited these last 27 years, I feel pretty good
about my abilities (and bank account) in MV programming.

I just removed 680 lines from a 900 line program that needed a repair. Since
I'm the current cook in the kitchen at my clients, I have to take
responsibility for any problems that creep up when I change a program. I may
be tweaking lines 100-115 and when the fresh compile produces a new error at
line 580, it's now my problem.

As with other debatable elements, there will always be 2 solutions to every
program. What started out as a curiosity with the THE prefixes, ended up
with slandering against the senior members of this forum. Not read the
manual in 20 years? We've probably written the one you're reading now.

My 1 cent.
Mark Johnson

- Original Message -
From: "gerry-u2ug" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, July 12, 2005 9:53 AM
Subject: RE: [U2] THE variable names


> not trying to start anything - but was this intended as a joke ?
> I read this as : "don't use current language features because the old
'pros' who haven't picked up a manual in 20 years won't understand it" ?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of 
> [EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 03:59 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] THE variable names
>
>
> In a message dated 7/10/2005 6:18:39 PM Pacific Daylight Time, 
> [EMAIL PROTECTED] writes:
>
>
> > LOOP
> >REMOVE PROD FROM PRODS SETTING MORE.PRODS
> >...do stuff...
> > WHILE MORE.PRODS
> > REPEAT
>
> Why use Remove?  It's unfamiliar to more oldtimers and requires use of 
> SETTING.
> Just
> SELECT PRODS
> and then
> READNEXT PROD ELSE DONE = TRUE
>
> :)
> Will Johnson
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] THE variable names

2005-07-14 Thread gerry-u2ug
wow.  I can't believe how touchy people get about the simplest comments. 
I am also surprised at the assumptions that get made in order to flame back at 
some perceived insult.
Why do you assume anything about how long I've been at this game, my abilities 
or the size of my bank account ?  And how is any of that even relevant ?

For the record, I wasn't slandering old pros. I was slandering old 'pros' that 
haven't picked up a manual in 20 years - big difference.
The comment was made in response to the statement that 'newer' ( ie. post 
1970's ) language features shouldn't be used as they would confuse the 'old 
timers'.

If you are current in the profession then what I said was in no way directed at 
you - so why the indignation ?

Gerry




-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
Sent: Thursday, July 14, 2005 11:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] THE variable names


Don't cast such stones on us 'old pro's. Many of us have spent more time
with these older systems prior to the current system than many have with
their only systems. There is an evolution with these MV systems that allows
us to be a little cautious of new, platform specific 'features'.

At present I have active accounts in Microdata, UV, UD, AP-Pro, D3, MvBase
and R90. All support DCOUNT etc and it gets a little hard to remember which
system supports REMOVE or SELECT TO. I for one got a little tired with the
LOCATE differences and the EXECUTE/PERFORM syntaxes. So I go with the
trusted, comprehensive methods.

My productivity isn't hampered by using DCOUNT instead of REMOVE. I won't
yield to a cpu cycle argument either. Given the tremendous amount of poor
programming that I have inherited these last 27 years, I feel pretty good
about my abilities (and bank account) in MV programming.

I just removed 680 lines from a 900 line program that needed a repair. Since
I'm the current cook in the kitchen at my clients, I have to take
responsibility for any problems that creep up when I change a program. I may
be tweaking lines 100-115 and when the fresh compile produces a new error at
line 580, it's now my problem.

As with other debatable elements, there will always be 2 solutions to every
program. What started out as a curiosity with the THE prefixes, ended up
with slandering against the senior members of this forum. Not read the
manual in 20 years? We've probably written the one you're reading now.

My 1 cent.
Mark Johnson

- Original Message -
From: "gerry-u2ug" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, July 12, 2005 9:53 AM
Subject: RE: [U2] THE variable names


> not trying to start anything - but was this intended as a joke ?
> I read this as : "don't use current language features because the old
'pros' who haven't picked up a manual in 20 years won't understand it" ?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 03:59 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] THE variable names
>
>
> In a message dated 7/10/2005 6:18:39 PM Pacific Daylight Time,
> [EMAIL PROTECTED] writes:
>
>
> > LOOP
> >REMOVE PROD FROM PRODS SETTING MORE.PRODS
> >...do stuff...
> > WHILE MORE.PRODS
> > REPEAT
>
> Why use Remove?  It's unfamiliar to more oldtimers and requires use of
> SETTING.
> Just
> SELECT PRODS
> and then
> READNEXT PROD ELSE DONE = TRUE
>
> :)
> Will Johnson
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] SYSTEM(20)?

2005-07-14 Thread Mark Johnson
Here, here. My MCD roots are showing as I truly love SP-JOBS. I have even
wrote an equivilent using LISTPEQS for D3 systems. I never bothered on U2
systems as I was more of a contract programmer than an administater.

SP-JOBS should have been picked up by the remaining keepers of the MV flame.
It was too good to die with MCD.

MJ
- Original Message -
From: "Norman Morgan" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, July 14, 2005 9:28 AM
Subject: RE: [U2] SYSTEM(20)?


> > We had the same issue converting from RealityX to universe. The
> > spooler menu on RX was much more user-friendly and listed such
> > helpful options as "pages printed so far" for the displayed job.
>
> Tell me about it!  We came to D3/SB+/AIX 10 years ago from a Wang VS
> environment.  I don't miss writing COBOL, but there never was a more user
> and operator friendly OS than the Wang VS.  You could stop a print job in
> mid-stream and resume where you left off, even on another printer.  That
was
> great if a printer broke down in the middle of a long report.  You could
> also skip
> back or skip ahead to a specific page or line.  The D3/SB+ combo was a
> big step down in regard to convenient printer control.  Now the switch to
> Unidata/SB+ is an even bigger step backwards.
>
> ===
> Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
> ===
> If people listened to themselves more often, they would talk less.
> ===
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 7/12/2005
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Select Question

2005-07-14 Thread Mark Johnson
At the risk of starting another debate, I'll toss out my preference on
internal (or external) READNEXTS.

UD:
LOOP WHILE READNEXT ID DO
BLAH
REPEAT

D3:
LOOP READNEXT ID ELSE EXIT UNTIL 0 DO
BLAH
REPEAT

MCD and others I use the infidel EOF=0 logic
EOF=0
LOOP READNEXT ID ELSE EOF=1 UNTIL EOF DO
BLAH
REPEAT

I have been stung when using the value of the incoming ID as a test value.
Thus I leave it alone.
my 1 cent.

- Original Message -
From: <[EMAIL PROTECTED]>
To: "u2-Users" 
Sent: Thursday, July 14, 2005 12:04 AM
Subject: [U2] [UV] Select Question


> Hi all,
>
> Can someone tell me the diference between the following two examples of
executing an external select?
>
> SELECT FILE TO LIST
> LOOP
> READNEXT ID FROM LIST ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
>
> SELECT FILE
> LOOP
> READNEXT ID ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
>
> Someone pointed out to me that there is overhead in selecting to a list
that I need not be exposing myself to.  Aren't they both kind of reading
from a list somewhere anyways?
>
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] THE variable names

2005-07-14 Thread Mark Johnson
Don't cast such stones on us 'old pro's. Many of us have spent more time
with these older systems prior to the current system than many have with
their only systems. There is an evolution with these MV systems that allows
us to be a little cautious of new, platform specific 'features'.

At present I have active accounts in Microdata, UV, UD, AP-Pro, D3, MvBase
and R90. All support DCOUNT etc and it gets a little hard to remember which
system supports REMOVE or SELECT TO. I for one got a little tired with the
LOCATE differences and the EXECUTE/PERFORM syntaxes. So I go with the
trusted, comprehensive methods.

My productivity isn't hampered by using DCOUNT instead of REMOVE. I won't
yield to a cpu cycle argument either. Given the tremendous amount of poor
programming that I have inherited these last 27 years, I feel pretty good
about my abilities (and bank account) in MV programming.

I just removed 680 lines from a 900 line program that needed a repair. Since
I'm the current cook in the kitchen at my clients, I have to take
responsibility for any problems that creep up when I change a program. I may
be tweaking lines 100-115 and when the fresh compile produces a new error at
line 580, it's now my problem.

As with other debatable elements, there will always be 2 solutions to every
program. What started out as a curiosity with the THE prefixes, ended up
with slandering against the senior members of this forum. Not read the
manual in 20 years? We've probably written the one you're reading now.

My 1 cent.
Mark Johnson

- Original Message -
From: "gerry-u2ug" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, July 12, 2005 9:53 AM
Subject: RE: [U2] THE variable names


> not trying to start anything - but was this intended as a joke ?
> I read this as : "don't use current language features because the old
'pros' who haven't picked up a manual in 20 years won't understand it" ?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 03:59 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] THE variable names
>
>
> In a message dated 7/10/2005 6:18:39 PM Pacific Daylight Time,
> [EMAIL PROTECTED] writes:
>
>
> > LOOP
> >REMOVE PROD FROM PRODS SETTING MORE.PRODS
> >...do stuff...
> > WHILE MORE.PRODS
> > REPEAT
>
> Why use Remove?  It's unfamiliar to more oldtimers and requires use of
> SETTING.
> Just
> SELECT PRODS
> and then
> READNEXT PROD ELSE DONE = TRUE
>
> :)
> Will Johnson
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] journaling information

2005-07-14 Thread Ken Wallis
> Any UniData Journaling users out there?
>
> We are considering using journaling as a way to keep a near real-time
> backup of our primary system.  We would be journaling
> hundreds of files
> on a system with over 1000 users.
>
> We have lots of questions, like:
> Has anyone used journaling on that scale before?
> How much of a performance hit is there with journaling?
> Are there any options recommended, or to be avoided?
> What tricks can we use to avoid any know problems?
>
> If anyone has any experiences or critiques to share, I would
> appreciate them, either here or off list ( [EMAIL PROTECTED] ).

I've only ever looked at Journaling as a poor-man's RFS.  In that capacity
it really didn't cut the mustard.

I have, however, successfully set up RFS for use in a DR scenario - archive
logs regularly and automatically copied to a backup machine and replayed
there automatically each morning via mediarec.  This is running well at
decent sized production site, but nothing like the user population you are
talking about - 100 to 150 users, not 1000 like you have.

In an ideal world, IBM would publish the format of the archive logs so one
could write a tool to allow transactions to be picked out of these and
replayed over to a remote system without stopping it and doing a mediarec
rollforward, but with UniData having replication built-in using an entirely
different approach, I doubt they'll ever allow that.

Do you have version issues which would prevent you using replication for
this purpose Dean, or have you identified issues that prevent it from
working for you?

Cheers,

Ken
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] 7.1 PE for Linux is now available for download

2005-07-14 Thread Wally Terhune
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trials

Wally Terhune
Manager - U2 Advanced Technical Services
IBM Information Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]

Don't miss out on the IBM DB2 Information Management Technical Conference
September 11-16, 2005  Orlando, FL
http://www.ibm.com/software/data/u2/offers

Experience in-depth U2 product sessions, along with the entire DB2
Information Management Software product portfolio.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Kevin Drury/Denver/IBM is out of the office.

2005-07-14 Thread Kevin Drury
I will be out of the office starting  07/14/2005 and will not return until
07/19/2005.

If it is an urgent work related matter then please call 1 800 729 3553.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] GET.LIST

2005-07-14 Thread karlp

> On a reality flavor UV account, I can do GET.LIST ACCOUNTNAME LISTNAME
> to get a list which exists on another account.  But on PICK flavor, I
> don't seem to be able to do that.  When I read the manual help on
> GET.LIST I don't see anything about getting a list from another account
> for any flavor.   Is there some other syntax on the PICK flavor account
> I can use to accomplish this?
> Thanks
> -Dianne

I've solved that by creating a Q-Pointer to the &SAVEDLISTS& file in the
remote account. Then performing QSELECT REMOTEACCTSL SAVEDLISTNAME. If you
follow a standard, such as ACCTNAMESL, then it's not too annoying.

Or, you could change the VOC GET.LIST to be REALITY flavor as previously
pointed out.

HTH

Karl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] GET.LIST

2005-07-14 Thread Glenn Herbert
There is no other work around but to change field 6 in the VOC entry for 
GET.LIST from whatever it says to REALITY.FORMAT.

FYI, the INFORMATION flavor does support doing the same thing, but you 
have to swap syntax to:

   GET.LIST LISTNAME ACCOUNTNAME
_
"I reject your reality and substitute my own" - Adam Savage

Glenn M. Herbert - Connectivity Development  Engineer
Information Integration Solutions, IBM Software Group
50 Washington Street Westboro, MA 01581
 508-599-7281 direct 



Dianne Ackerman <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
07/14/2005 03:50 PM
Please respond to
u2-users


To
U2 List Server 
cc

Subject
[U2] [UV] GET.LIST






On a reality flavor UV account, I can do GET.LIST ACCOUNTNAME LISTNAME 
to get a list which exists on another account.  But on PICK flavor, I 
don't seem to be able to do that.  When I read the manual help on 
GET.LIST I don't see anything about getting a list from another account 
for any flavor.   Is there some other syntax on the PICK flavor account 
I can use to accomplish this?
Thanks
-Dianne
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UD] journaling information

2005-07-14 Thread Dean.Armbruster
Any UniData Journaling users out there?

We are considering using journaling as a way to keep a near real-time
backup of our primary system.  We would be journaling hundreds of files
on a system with over 1000 users.

We have lots of questions, like:
Has anyone used journaling on that scale before?
How much of a performance hit is there with journaling?
Are there any options recommended, or to be avoided?
What tricks can we use to avoid any know problems?

If anyone has any experiences or critiques to share, I would appreciate
them, either here or off list ( [EMAIL PROTECTED] ).

Tia,
Dean Armbruster
Ferguson Enterprises, Inc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] IBM PHP & U2

2005-07-14 Thread Jeff Schoby
 Anyone have any info on this they could send to me off list?  Our
inhouse developers would like to know more.

Thanks 

-Jeff

 
>>>[EMAIL PROTECTED] 07/14/05 7:31 am >>> 
I have noticed that IBM & Zend Technologies have been developing a
native PHP interface 
to DB2!! 
 
I wonder if someone from IBM could explain if 
we will get the same native interface to U2 from PHP.. 
 
 
best regards from Denmark 
 
Claus Derlien 
edb-afdelingen 
direkte : 63 13 86 69 
email   : [EMAIL PROTECTED] 
 
Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse -
www.f-f.dk 
 
 
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt
materiale, der kun er beregnet for adressaten, 
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en
fejltagelse modtaget denne email, bedes 
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa
forhaand tak. 
 
This email and any files transmitted with it may contain confidential
information intended for the addressee(s) only. 
The information is not to be surrendered or copied to unauthorised
persons. If you have received this 
communication in error, please notify us immediately by telephone: +45
6313 8550. Thank you. 
 
--- 
u2-users mailing list 
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] GET.LIST

2005-07-14 Thread Dianne Ackerman
On a reality flavor UV account, I can do GET.LIST ACCOUNTNAME LISTNAME 
to get a list which exists on another account.  But on PICK flavor, I 
don't seem to be able to do that.  When I read the manual help on 
GET.LIST I don't see anything about getting a list from another account 
for any flavor.   Is there some other syntax on the PICK flavor account 
I can use to accomplish this?

Thanks
-Dianne
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Internal date conversion

2005-07-14 Thread Jerry Banker
With the format you have given this will work:

INT.DATE = ICONV(OCONV(external.date,'MCN'),'D')

The OCONV strips everything non-numeric leaving 20050714 which will ICONV to 
the internal date.

- Original Message - 
From: "Pankaj Gupta04" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, July 14, 2005 11:39 AM
Subject: [U2] Internal date conversion


I want to convert a date in following format to Universe internal
format.

Can anyone please provide me the specific format command?
-MM-DD e.g. 2005-07-14 is the input format.
I want to store it in equivalent Universe format i.e. 13710.

Thanks and Regards
Pankaj Gupta

 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, 
please notify the sender by e-mail and delete the original message. Further, 
you are not to copy, disclose, or distribute this e-mail or its contents to 
any other person and any such actions are unlawful. This e-mail may contain 
viruses. Infosys has taken every reasonable precaution to minimize this 
risk, but is not liable for any damage you may sustain as a result of any 
virus in this e-mail. You should carry out your own virus checks before 
opening the e-mail or attachment. Infosys reserves the right to monitor and 
review the content of all messages sent to or from this e-mail address. 
Messages sent to or from this e-mail address may be stored on the Infosys 
e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Internal date conversion

2005-07-14 Thread Roger Glenfield

About the same time as D2E  started iconverting DAY/MON/YEAR?

I think I preferred the Ultimate method of setting a system wide flag 
and letting D2/ be D2/ for the locals.


Or even better, MMDDYY instead of slashing/dashing.  Of course, some 
preferred not having to enter years, entering  7/13 and defaulting to 
current year.


Gordon J Glorfield wrote:

FYI This does work in UV.  Which is odd to me.  I had always thought that 
in an ICONV anything following the "D" was ignored.  I wonder when this 
changed?


I've learned something new so it's not a completely wasted day.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Internal date conversion

2005-07-14 Thread Glenn Herbert
This functionality was added end of March, 1995.   Been there a long 
while.
_
"I reject your reality and substitute my own" - Adam Savage

Glenn M. Herbert - Connectivity Development  Engineer
Information Integration Solutions, IBM Software Group
50 Washington Street Westboro, MA 01581
 508-599-7281 direct 



"Gordon J Glorfield" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
07/14/2005 02:41 PM
Please respond to
u2-users


To
u2-users@listserver.u2ug.org
cc

Subject
RE: [U2] Internal date conversion






>FYI This does work in UV.  Which is odd to me.  I had always thought that 

>in an ICONV anything following the "D" was ignored.  I wonder when this 
>changed?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Internal date conversion

2005-07-14 Thread Gordon J Glorfield
FYI This does work in UV.  Which is odd to me.  I had always thought that 
in an ICONV anything following the "D" was ignored.  I wonder when this 
changed?

I've learned something new so it's not a completely wasted day.


Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839

[EMAIL PROTECTED] wrote on 07/14/2005 01:08:19 PM:

> It's been a while since I've worked in UV, but in UniData, this works:

> DT = '2005-07-14'
> INT.DT = ICONV(DT,'DYMD')

> Larry Hiscock
> Western Computer Services

[snip]


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Select Question

2005-07-14 Thread Richard Taylor
There can be a major problem with the second syntax depending on what you
are doing to the file.  The SELECT filevar syntax does not create a select
list even in memory.  It traverses each group in order as you perform the
readnext command keeping a pointer to where it left off.  This is why is
can be so much faster/more efficient than a select to a list which must:
a) traverse the file to create the list and b) hold that list somewhere.

The problem comes in if you write back to the file you are traversing.
This will reorganize the group moving where records are located.  You can
end up records not being processed that you believed were going to be.  

You are much safer either Executing an Retrieve select or selecting to a
list.


Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319 
[EMAIL PROTECTED] | http://www.vertisinc.com
 
Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.
 
"The more they complicate the plumbing
  the easier it is to stop up the drain"
 
- Montgomery Scott NCC-1701

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Thursday, July 14, 2005 12:05 AM
> To: u2-users@listserver.u2ug.org (u2-Users)
> Subject: [U2] [UV] Select Question
> 
> Hi all,
> 
> Can someone tell me the diference between the following two examples of
> executing an external select?
> 
> SELECT FILE TO LIST
> LOOP
> READNEXT ID FROM LIST ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
> 
> SELECT FILE
> LOOP
> READNEXT ID ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
> 
> Someone pointed out to me that there is overhead in selecting to a list
> that I need not be exposing myself to.  Aren't they both kind of reading
> from a list somewhere anyways?
> 
> Thanks
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Internal date conversion

2005-07-14 Thread Richard Taylor
I have found that a general date conversion is pretty flexible in UV (not
sure about Unidata yet)

Try:

I.DATE = ICONV(EXTERN.DATE,"D")



Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319 
[EMAIL PROTECTED] | http://www.vertisinc.com
 
Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.
 
"The more they complicate the plumbing
  the easier it is to stop up the drain"
 
- Montgomery Scott NCC-1701
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of Pankaj Gupta04
> Sent: Thursday, July 14, 2005 12:39 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Internal date conversion
> 
> I want to convert a date in following format to Universe internal
> format.
> 
> Can anyone please provide me the specific format command?
> -MM-DD e.g. 2005-07-14 is the input format.
> I want to store it in equivalent Universe format i.e. 13710.
> 
> Thanks and Regards
> Pankaj Gupta
> 
>  CAUTION - Disclaimer *
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this
e-mail
> or its contents to any other person and any such actions are unlawful.
> This e-mail may contain viruses. Infosys has taken every reasonable
> precaution to minimize this risk, but is not liable for any damage you
may
> sustain as a result of any virus in this e-mail. You should carry out
your
> own virus checks before opening the e-mail or attachment. Infosys
reserves
> the right to monitor and review the content of all messages sent to or
> from this e-mail address. Messages sent to or from this e-mail address
may
> be stored on the Infosys e-mail system.
> ***INFOSYS End of Disclaimer INFOSYS***
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] SYSTEM(20)?

2005-07-14 Thread Norman Morgan
> The Wang spooler was probably running directly attached printers (via
> serial or parralell interfaces).  This would allow the spooler to
> "know" much more about the status of a job than the more "modern"
> printers that are network attached (and deal with complete print jobs
> in one fell swoop).  For a network attached printer to offer up the
> same funtionality, full two way communication of status as it happens
> would need to occur.  While the Wang may have had much better control
> over the print job, how long did you have to wait for that 500+ page
> report???

I understand the reasons, but that doesn't mean I don't miss the
functionality.  We were dealing primarily with a big 1200 lpm band printer.
(Dataproducts disguised as Wang).  The Wang used a proprietary dual coax
wiring scheme.  It looked like small welding hose!  Archaic to the extreme,
but it sure did work well.  All the pieces talked to each other constantly,
so the host knew the status of everything.  Don't misunderstand...I'd never
go back, but I sure miss having that level of control over the peripheral
hardware.

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
Miracle Software, Inc.  "If it works, it's a Miracle!"
===



> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Don Kibbey
> Sent: Thursday, July 14, 2005 10:36 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] SYSTEM(20)?
>
>

>
> Today we just print the whole thing, take one look at the first page,
> decide it's all wrong and print it again (and again, and again)...
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 7/14/2005
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 7/14/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Internal date conversion

2005-07-14 Thread Glenn Herbert
Better might be:  ICONV("2005-07-14","D-YMD[4,2,2]")

_
"I reject your reality and substitute my own" - Adam Savage

Glenn M. Herbert - Connectivity Development  Engineer
Information Integration Solutions, IBM Software Group
50 Washington Street Westboro, MA 01581
 508-599-7281 direct 



[EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED]
07/14/2005 12:56 PM
Please respond to
u2-users


To
u2-users@listserver.u2ug.org
cc

Subject
Re: [U2] Internal date conversion






In a message dated 7/14/2005 9:50:12 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Can anyone please provide me the specific format command?
> -MM-DD e.g. 2005-07-14 is the input format.
> I want to store it in equivalent Universe format i.e. 13710.

Wouldn't you need to do something like this?
T.DATE = "2005-07-14"
NEW.DATE = ICONV(T.DATE,"G1-2"):"-":ICONV(T.DATE,"G0-1")
INTERNAL.DATE = ICONV(NEW.DATE,"D")

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Internal date conversion

2005-07-14 Thread Larry Hiscock
It's been a while since I've worked in UV, but in UniData, this works:

DT = '2005-07-14'
INT.DT = ICONV(DT,'DYMD') 

Larry Hiscock
Western Computer Services


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04
Sent: Thursday, July 14, 2005 9:39 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Internal date conversion

I want to convert a date in following format to Universe internal format.

Can anyone please provide me the specific format command?
-MM-DD e.g. 2005-07-14 is the input format.
I want to store it in equivalent Universe format i.e. 13710.

Thanks and Regards
Pankaj Gupta

 CAUTION - Disclaimer * This e-mail contains
PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the
addressee(s). If you are not the intended recipient, please notify the
sender by e-mail and delete the original message. Further, you are not to
copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is
not liable for any damage you may sustain as a result of any virus in this
e-mail. You should carry out your own virus checks before opening the e-mail
or attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Select Question

2005-07-14 Thread FFT2001
In a message dated 7/13/2005 9:11:23 PM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> SELECT FILE TO LIST
> LOOP
> READNEXT ID FROM LIST ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
> 
> SELECT FILE
> LOOP
> READNEXT ID ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT

I agree that I don't see any extra overhead.
But why do you use an odd convention like ID = @AM ?
In this small loop it's probably apparent what you're doing but if the 
distance between the LOOP and the UNTIL were large enough I dare say you'd be 
adding 
confusion to the mix for any future programmer.

What I do is
DONE = @FALSE
LOOP
   READNEXT ID ELSE DONE = @TRUE
UNTIL DONE DO REPEAT

I think DONE is a more clear-cut variable usage rather than setting ID to @AM 
personally.  Just my opinion.

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Internal date conversion

2005-07-14 Thread FFT2001
In a message dated 7/14/2005 9:50:12 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> Can anyone please provide me the specific format command?
> -MM-DD e.g. 2005-07-14 is the input format.
> I want to store it in equivalent Universe format i.e. 13710.

Wouldn't you need to do something like this?
T.DATE = "2005-07-14"
NEW.DATE = ICONV(T.DATE,"G1-2"):"-":ICONV(T.DATE,"G0-1")
INTERNAL.DATE = ICONV(NEW.DATE,"D")

Will Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] problems with UVODBC, crystal reports viewer

2005-07-14 Thread Hennessey, Mark F.
Could there be variances in post SP2 patches that have been applied by users?

Something is jiggling in the back of my mind about different ports...  But I 
should think that Crystal reports and Excel, since they're both using ODBC, 
would
be going out the same ports on the PCs and connecting to the same port on the 
server
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Internal date conversion

2005-07-14 Thread Pankaj Gupta04
I want to convert a date in following format to Universe internal
format.

Can anyone please provide me the specific format command?
-MM-DD e.g. 2005-07-14 is the input format.
I want to store it in equivalent Universe format i.e. 13710.

Thanks and Regards
Pankaj Gupta

 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Select Question

2005-07-14 Thread Mats Carlid

gerry-u2ug wrote:


is this true ?  I have never experienced the slowdown of the initial 
"traversal" and can't see the need for it - this statement just uses a 
different select list other than zero.  now if the question had been regarding SELECTV 
rather than SELECT, then I would agree.

Gerry


 


Mea culpa!

As  there's no way you can assign the resulting select list to a 
variable without
first  'traverse' the file -  that is without at least read the  list of 
record-id
in each page ( or hash point ) I jumped to the conclusion that there 
would be..


But evidently the implementation is such as the variable is not assigned 
to/with/as

the full list before the program continues with the loop.

That also explains why you can't do much else than readnext with
a list variable -  dcount it for example.


Took a large file  used both methods and printed the first
readnext'ed id   and timed it for proof - both ways printed
emediately.

(But I had to SELECTV  for the list variable case )

-- mats


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mats Carlid
Sent: Thursday, July 14, 2005 06:22 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Select Question


I'm aware of two differences that may be of importance

- if we're speaking uv -

The LIST alternative is immune to a secondary select
inside the loop  -  possibly well hidden in an itype in
a subroutine of an subr


The bare select lets the readnext loop start emediately
and saves (probably) one traversal of the file.


So yes You'd save overhead - lot's of wall clock time
and io but probably not that much cpu.

hth
-- mats


[EMAIL PROTECTED] wrote:

 


Hi all,

Can someone tell me the diference between the following two examples of 
executing an external select?

SELECT FILE TO LIST
LOOP
  READNEXT ID FROM LIST ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

SELECT FILE
LOOP
  READNEXT ID ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

Someone pointed out to me that there is overhead in selecting to a list that I 
need not be exposing myself to.  Aren't they both kind of reading from a list 
somewhere anyways?

Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
   


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] SYSTEM(20)?

2005-07-14 Thread Don Kibbey
The Wang spooler was probably running directly attached printers (via
serial or parralell interfaces).  This would allow the spooler to
"know" much more about the status of a job than the more "modern"
printers that are network attached (and deal with complete print jobs
in one fell swoop).  For a network attached printer to offer up the
same funtionality, full two way communication of status as it happens
would need to occur.  While the Wang may have had much better control
over the print job, how long did you have to wait for that 500+ page
report???

Today we just print the whole thing, take one look at the first page,
decide it's all wrong and print it again (and again, and again)...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] problems with UVODBC, crystal reports viewer

2005-07-14 Thread Joe Walter
having a strange problem. got a customer with many, many users running crystal
reports viewer that access universe data via UVODBC. in the past this has
worked fabulously, but all of a sudden, in the last 10 days or so some subset
of the users get NO results returned when using the crystal reports viewer.
however, if we try to access Universe data via MS Excel on those same
workstations - no problemo.

all workstations are running Win XP Pro SP2.

i'm wondering if there's an off chance anyone else has encountered a similar
problem and come up with a resolution.

also wondering if it might have something to do with the latest batch of
'automatic updates' from Microsoft. i don't have specifics, but do know that
some workstations have MS automatic updates enabled and others do not.

joe

~~~
"Live dangerously. Communicate!"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] AUTOLOGOUT

2005-07-14 Thread Dean Fox
This is what I wrote for a client. Maybe it will help. It uses a
couple local UV files built from a UNIX command query(s) and if I
recall user profiles using a "charge to".  I'd have to pull it apart
to remember the details but maybe there's something in here that might
help.

There was a UV file with user timeout parameters that was checked when
the system load exceeded a specified amount.  The logout/logoff from
both UV and UNIX functioned completely when all parameters were met.

-[d]-

001   PROGRAM AUTO.LOGOFF
002 **  This program is designed to automatically logoff users that
003 **  have been inactive for a specified lenght of time.  It takes
004 **  into consideration keyboard inactivity as well as CPU usage so as not
005 **  to logoff a user who is currently processing data.
006 **
007 **  A priority user file is examined. Consideration is made for users
008 **  that are not to be logged off at all or for users who have longer
009 **  inactivity allowances. Unless an emergency limit has been reached.
010 **  In that case priority users are allowed to be logged off with
011 **  a regular timeout default.
012 **
013 **  Currently there are 90 UDT licenses. This program is set to activate
014 **  when 80+ licenses are being used.  It's felt there's no reason to
015 **  logoff a user to conserve licenses if < the max are in use, etc.
016 **
017 **
018 **  USE.REC<1> = Last two charactors of tty identifier
019 ** <2> = User login id
020 ** <3> = PID
021 ** <4> = CPU usage
022 ** <5> = Keyboard inactivity
023 ** <6> = Delete flag
024 **
025 **TUSER<1> = Last two charactors of tty identifier
026 ** <2> = User login id
027 ** <3> = PID
028 ** <4> = CPU usage
029 ** <5> = Keyboard inactivity
030 ** <6> = Delete flag
031 ** <7> = User Priority
032 **
033 **PUSER<1> = Priority Level
034 ** <2> = Max Inactivity Allowed
035 **
036 ** HIST.REC<1>   = Current Number of udt Sessions
037 ** <2.M> = Last two charactors of tty identifier
038 ** <3.M> = User login id
039 ** <4.M> = PID
040 ** <5.M> = CPU usage
041 ** <6.M> = Keyboard inactivity
042 ** <7.M> = Delete Flag
043 ** <8.M> = User Priority
044 ** <9.M> = Run Date (Internal)
045 *
046 *  MODIFICATION HISTORY
047 *
048 *  No  Date  SCRno   Who  Description
049 *  00  29-04-02  0   def  Orginal Code...
050 *
051
052   CRT ">>> AUTO.LOGOFF <<<"
053
054   CALL MP.OPEN("PRIORITY.USER" , PRIORITY.USER , OPENSTAT) ; IF OPENSTAT
055   OPEN "DICT","PRIORITY.USER" TO DICT.PRIORITY.USER ELSE STOP 201,"DICT,
056   CALL MP.OPEN("TRACK.USER" , TRACK.USER , OPENSTAT) ; IF OPENSTAT THEN
057   CALL MP.OPEN("LOGOFF.HIST" , LOGOFF.HIST , OPENSTAT) ; IF OPENSTAT THE
058
059   DONE= 0
060   KILL.ALL= 0
061   SESSION.LIMIT   = 80
062   EMERGENCY.LIMIT = 88
063   DEFAULT.TIMEOUT = 20
064
065   LOOP UNTIL DONE DO
066  SLEEP 300;* Run every 5 minutes
067
068  IF TIME() > 85500 THEN KILL.ALL = 1
069  RUN.DATE = DATE()
070
071  GOSUB 1000 ; * Build Usage Variable
072
073  USER.CNT = DCOUNT(USE.REC<1>,@VM)
074  FOR NXT.USER = 1 TO USER.CNT
075 GOSUB 2000;* Check Usage
076  NEXT NXT.USER
077
078  GOSUB 3000;* Logoff Qualified Users
079
080 * Check for program abort flag / sleep the night
081  IF KILL.ALL THEN
082 KILL.ALL = 0
083 CLEARFILE TRACK.USER;* Clear accumulated users
084 * Clear Out History Past 7 Days
085 DEL.DATE = OCONV(RUN.DATE - 7,'D')
086 STMT = 'SELECT LOGOFF.HIST WITH DATE < "' :DEL.DATE: '"'
087 EXECUTE STMT CAPTURING RESULT RETURNING ERROR
088 LOOP WHILE READNEXT ID DO
089DELETE LOGOFF.HIST,ID
090 REPEAT
091 SLEEP 21600;* Sleep six hours
092  END
093  READV DONE FROM DICT.PRIORITY.USER,"TERMINATE",1 ELSE DONE = 0
094
095   REPEAT
096
097 * Program Termination
098   RETURN
099
100 1000 ;* Build Usage Variable
101
102   USE.REC = ""
103
104 * Get udt Sessions
105   STMT = "ps -ef | grep udt | grep -v root | grep -v grep | grep -v PHAN
106   PCPERFORM STMT CAPTURING RESULT
107   ATTR.CNT = DCOUNT(RESULT,@AM)
108   UDT.SESSIONS = ATTR.CNT
109
110 * Write History Record / End Processing if Not Exceeding udt Session Limit
111   LOGOFF.HIST.ID = OCONV(RUN.DATE,"D4-"):"_":OCONV(TIME(),"MTS")
112   HIST.REC= UDT.SESSIONS
113   HIST.REC<9> = RUN.DATE
114   WRITE HIST.REC ON LOGOFF.HIST,LOGOFF.HIST.ID
115
116 * Set Session Usage for Each User
117   FOR NXT.ATTR = 1 TO ATTR.CNT
118  IF RESULT[1,1] = " " THEN RESULT = RESULT = TRIM(RESULT)
120  RESULT = CONVERT(" " , @VM , RESULT)
121  TTY = RESULT,@VM)-2> [LEN(RESULT
123  

RE: [U2] [UV] Select Question

2005-07-14 Thread gerry-u2ug
is this true ?  I have never experienced the slowdown of the initial 
"traversal" and can't see the need for it - this statement just uses a 
different select list other than zero.  now if the question had been regarding 
SELECTV rather than SELECT, then I would agree.

Gerry



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mats Carlid
Sent: Thursday, July 14, 2005 06:22 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Select Question


I'm aware of two differences that may be of importance

- if we're speaking uv -

The LIST alternative is immune to a secondary select
inside the loop  -  possibly well hidden in an itype in
a subroutine of an subr


The bare select lets the readnext loop start emediately
and saves (probably) one traversal of the file.


So yes You'd save overhead - lot's of wall clock time
and io but probably not that much cpu.

hth
-- mats


[EMAIL PROTECTED] wrote:

>Hi all,
>
>Can someone tell me the diference between the following two examples of 
>executing an external select?
>
>SELECT FILE TO LIST
>LOOP
>READNEXT ID FROM LIST ELSE ID = @AM
>UNTIL ID = @AM DO
>REPEAT
>
>SELECT FILE
>LOOP
>READNEXT ID ELSE ID = @AM
>UNTIL ID = @AM DO
>REPEAT
>
>Someone pointed out to me that there is overhead in selecting to a list that I 
>need not be exposing myself to.  Aren't they both kind of reading from a list 
>somewhere anyways?
>
>Thanks
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Select Question

2005-07-14 Thread Geoffrey Mitchell
Selecting to a list variable is a VERY good idea.  Personally, I regard 
selecting to the default select list in a program as very bad form, and 
using a numbered select list as only marginally better.  Brian Leach's 
response has a good explanation of why, so I won't go into details.


I'm not aware of any additional overhead, and can't imagine why there 
would be any, but I am not familiar with the implementation details, so 
I can't say authoritatively that there is none.  I guess that some 
memory would need to be allocated to manage a list stored in a list 
variable, whereas it would already be allocated for the default list, 
but we're talking about clock cycles here.  In practice, I know of no 
viable reason not to use list variables.


[EMAIL PROTECTED] wrote:


Hi all,

Can someone tell me the diference between the following two examples of 
executing an external select?

SELECT FILE TO LIST
LOOP
   READNEXT ID FROM LIST ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

SELECT FILE
LOOP
   READNEXT ID ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

Someone pointed out to me that there is overhead in selecting to a list that I 
need not be exposing myself to.  Aren't they both kind of reading from a list 
somewhere anyways?

Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
[This E-mail scanned for viruses by Declude Virus]



 


---
[This E-mail scanned for viruses by Declude Virus]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] 7.1 - PE is available

2005-07-14 Thread Wally Terhune
Marc Harbeson wrote:
"WOW!
You go Wally.  This time around was a lot faster!
Well done."

I'm just the messenger. I take no credit.
Linux is poised - just waiting for the web page to refreshed to include the
link.
DOC will be posted soon, also.
This is all on public IBM U2 Web Sites...


Wally Terhune
Manager - U2 Advanced Technical Services
IBM Information Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]

Don't miss out on the IBM DB2 Information Management Technical Conference
September 11-16, 2005  Orlando, FL
http://www.ibm.com/software/data/u2/offers

Experience in-depth U2 product sessions, along with the entire DB2
Information Management Software product portfolio.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] SYSTEM(20)?

2005-07-14 Thread Norman Morgan
> We had the same issue converting from RealityX to universe. The
> spooler menu on RX was much more user-friendly and listed such
> helpful options as "pages printed so far" for the displayed job.

Tell me about it!  We came to D3/SB+/AIX 10 years ago from a Wang VS
environment.  I don't miss writing COBOL, but there never was a more user
and operator friendly OS than the Wang VS.  You could stop a print job in
mid-stream and resume where you left off, even on another printer.  That was
great if a printer broke down in the middle of a long report.  You could
also skip
back or skip ahead to a specific page or line.  The D3/SB+ combo was a
big step down in regard to convenient printer control.  Now the switch to
Unidata/SB+ is an even bigger step backwards.

===
Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
===
If people listened to themselves more often, they would talk less.
===

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 7/12/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AUTOLOGOUT

2005-07-14 Thread Dana Baron
>remember that you need to 'exec' uv to overlay the current process or it
>will create a subprocess to run UniVerse. In which case, the autologout
will
>simply be returning them to their calling shell.

We take a shortcut on using startup files like .profile. Instead, we put an
entry into /etc/passwd for users that we want going directly to Unidata. In
the field used to designate the user's shell, we put a reference to a login
file that starts up Unidata. Since this then becomes the user's shell, once
the shell ends, the process goes away. For example:

juser:*:238:15:Joe User,Reservations
Dept,1131,:/usr/users/juser:/unidata/local/bin/udtlogin

The last entry points to a udtlogin which sets all the necessary environment
variable, changes directory to the top of our Unidata application menu, then
starts udt:

# Define environment variables and set PATH, then start udt
#
PRINTER=system; export PRINTER
UDTHOME=/unidata/ud5211; export UDTHOME
UDTBIN=/unidata/ud5211/bin; export UDTBIN
UDTLOCBIN=/unidata/local/bin; export UDTLOCBIN
UDT_EDIT=emacs; export UDT_EDIT
INTERFACE=/unidata/interface; export INTERFACE
#
LD_LIBRARY_PATH=/var/opt/DAU200/connect/lib; export LD_LIBRARY_PATH
PATH=$PATH:$UDTBIN:$UDTLOCBIN:LD_LIBRARY_PATH:/opt/odbc/odbc.ini; export
PATH
ODBCINI=/opt/odbc/odbc.ini; export ODBCINI
ODBCHOME=/var/opt/DAU200/connect; export ODBCHOME
EDITOR=/usr/bin/emacs; export EDITOR
#
alias ED="emacs"
alias PRINT="lp"
alias print="lp"
alias edit="emacs"
alias EDIT="emacs"
#
umask 000
#
cd /unidata/SMUGGLER/AHS
udt


Dana Baron
System Manager
Smugglers' Notch Resort
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] SYSTEM(20)?

2005-07-14 Thread TPellitieri
Norman Morgan <[EMAIL PROTECTED]> wrote on Wed, 13 Jul 2005 13:51:59 -0500

> I need to find a workaround for a D3 feature that I have become
> dependent on.  SYSTEM(20) returns the number of the last spooler
> entry you created.

DICT _HOLD_ NEXT.HOLD contains the next job number to use.  Reading this
value would give you the next entry to be created, provided no one else
gets in ahead of you :->

The SETPTR command also includes the option BANNER which will allow you to
name the print job.  We have used this option to have weekly reports stored
in _HOLD_ so we could find the items automatically.

For example, using

SETPTR 0,133,65,0,0,3,NOEJECT,NFMT,COPIES 1,DEST ,BANNER
,NOMESSAGE,BRIEF

creates an item in _HOLD_ with the ID of .  We find this extremely
useful for reports run weekly or monthly, since we sometimes need time to
extract them from _HOLD_ before they get over-written.

You could also use BANNER UNIQUE , which would create the item
_, where  is the sequence number obtained from DICT _HOLD_
NEXT.HOLD.

--Tom Pellitieri
  Toledo, Ohio
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] 7.1 - PE is available

2005-07-14 Thread Marc Harbeson
WOW!

You go Wally.  This time around was a lot faster!

Well done.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune
Sent: Wednesday, July 13, 2005 8:13 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 7.1 - PE is available

7.1 PEs ARE available now and have been for a bit.
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trial
s

Wally Terhune
Manager - U2 Advanced Technical Services
IBM Information Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]

Don't miss out on the IBM DB2 Information Management Technical
Conference
September 11-16, 2005  Orlando, FL
http://www.ibm.com/software/data/u2/offers

Experience in-depth U2 product sessions, along with the entire DB2
Information Management Software product portfolio.



 Roger Glenfield
 <[EMAIL PROTECTED]
 net>
To
 Sent by:  u2 
 [EMAIL PROTECTED]
cc
 stserver.u2ug.org
 
Subject
   [U2] 7.1
 07/13/2005 04:52
 PM


 Please respond to
 u2-users






Any word on the status of Unidata 7.1?  Any real life experiences?


No, lets not ask when the PE edition is coming out.

Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type image/gif which had a name
of graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name
of pic19684.gif]

[demime 1.01d removed an attachment of type image/gif which had a name
of ecblank.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] SYSTEM(20)?

2005-07-14 Thread colin.alfke
Norman;

As others pointed out you can use GETPU(). We went a different way and
execute a SETPTR command using the "BANNER" option to actually name the
_HOLD_ item. This will eliminate the renaming step and perhaps with the
right options could eliminate the "editing the printer control
characters" and since the _HOLD_ file is actually a directory under
UNIX/windows you might not need your little program anymore.

Hth 

Colin Alfke
Calgary, AB

>-Original Message-
>From: Norman Morgan
>
>I may have asked this before, if so, I have forgotten the 
>answer and apologize for wasting your time.
>
>We are (still) in the midst of converting from D3/AIX to 
>UniData on AIX.  I need to find a workaround for a D3 feature 
>that I have become dependent on.
>SYSTEM(20) returns the number of the last spooler entry you 
>created.  I have a semi-automated system for archiving 
>selected reports to CD at the end of the month that depends on 
>this information.  How can I capture this info in my Basic 
>program to be able to write it to a log file.  We print 
>reports with either H to HS status (SB+ print controls), 
>depending on whether we even want a paper copy of the report.  
>A little standard routine in each program grabs the SYSTEM(20) 
>value and makes an entry in a log record.
>Later we enter that info into a program that automates the 
>copying of the PEQS file entries to Unix and editing the 
>printer control characters off both ends of the report file, 
>as well as changing the numeric item name to something 
>meaningful.  It all works pretty well, but it is absolutely 
>dependent on grabbing that SYSTEM(20) value.  The only 
>alternative is spending hours poking around in held reports in 
>the SB+ print queue to find each report to be archived.
>
>===
>Norman Morgan 
>===
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] 7.1 - PE is available

2005-07-14 Thread Dave Walker
Do you have a link to the linux version?

--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune
> Sent: Wednesday, July 13, 2005 8:13 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] 7.1 - PE is available
> 
> 
> 7.1 PEs ARE available now and have been for a bit.
> http://www14.software.ibm.com/webapp/download/search.jsp?go=y&;
> rs=u2trials
> 
> Wally Terhune
> Manager - U2 Advanced Technical Services
> IBM Information Management Solutions
> Tel: 303.294.4866 Fax: 303.294.4832
> [EMAIL PROTECTED]
> 
> Don't miss out on the IBM DB2 Information Management 
> Technical Conference
> September 11-16, 2005  Orlando, FL
> http://www.ibm.com/software/data/u2/offers
> 
> Experience in-depth U2 product sessions, along with the entire DB2
> Information Management Software product portfolio.
> 
> 
> 
>  Roger Glenfield
>  <[EMAIL PROTECTED]
>  net> 
>   To
>  Sent by:  u2 
> 
>  [EMAIL PROTECTED]
>   cc
>  stserver.u2ug.org
>   
>  Subject
>[U2] 7.1
>  07/13/2005 04:52
>  PM
> 
> 
>  Please respond to
>  u2-users
> 
> 
> 
> 
> 
> 
> Any word on the status of Unidata 7.1?  Any real life experiences?
> 
> 
> No, lets not ask when the PE edition is coming out.
> 
> Roger
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
> [demime 1.01d removed an attachment of type image/gif which 
> had a name of graycol.gif]
> 
> [demime 1.01d removed an attachment of type image/gif which 
> had a name of pic19684.gif]
> 
> [demime 1.01d removed an attachment of type image/gif which 
> had a name of ecblank.gif]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] IBM PHP & U2

2005-07-14 Thread Claus Derlien
I have noticed that IBM & Zend Technologies have been developing a native PHP 
interface
to DB2!!

I wonder if someone from IBM could explain if
we will get the same native interface to U2 from PHP..


best regards from Denmark

Claus Derlien
edb-afdelingen
direkte : 63 13 86 69
email   : [EMAIL PROTECTED]

Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk

***
Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, 
der kun er beregnet for adressaten,
og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en 
fejltagelse modtaget denne email, bedes
De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand 
tak.
***
This email and any files transmitted with it may contain confidential 
information intended for the addressee(s) only.
The information is not to be surrendered or copied to unauthorised persons. If 
you have received this
communication in error, please notify us immediately by telephone: +45 6313 
8550. Thank you.
***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [Redback] multi-valued data displays strangely

2005-07-14 Thread Don Verhagen
Adrian.

Using RBOScope, I don't think so. The RBOScope asp/uv/ud code "Magically" 
converts new lines characters into Value Marks, this is, as I believe also, 
useful when testing and have to enter multivalue data into a RBO property. 
Using a textbox outside of RBOScope does not exhibit
(magically) this behaviour.  I suppose you may be able to ScopeProps.asp to get 
the behaviour you are looking for.

Thanks,


--
Donald Verhagen  
Application Development Manager
[EMAIL PROTECTED]
Tandem Staffing Solutions, Inc.
1690 S Congress Avenue, Suite 210
Delray Beach, FL 33445  USA
Voice Phone: 561.454.3592 Fax Phone: 561.454.3640 

>>> [EMAIL PROTECTED] 3:40:57 AM 07/14/2005 >>>
Using RBOScope for testing - if I press enter to get a new line in a text box
and then call a validation routine which returns an error - the new line in
the text box has magically transformed into a "}" character.  When the data
arrives in my universe subroutine the new line is a value-mark (which is fine
by me).

Is there a way to keep the new line as a new line instead of a "}" ?

I've tried defining the field as a "Field" and later as a "mvField" in redback
designer, and it made no difference.

AdrianW










DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org 
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] AUTOLOGOUT

2005-07-14 Thread Dianne Ackerman
I think it has do to with the way they get to Universe in the first 
place.  We have it setup so the unix users automatically go to a certain 
place where there is a .profile which does 'exec uv' within it.  Then 
the AUTOLOGOUT works just as you want it to, it logs them off 
completely.  Other users we have which go into unix but stay there until 
they execute a command to go into uv work the other way, the AUTOLOGOUT 
brings them back to unix.

-Dianne

Andy Moore wrote:


DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hello,

Anyone got any ideas on the autologout command on a Unix environment?

We have it working happily on some Windows servers, set to log people
off if they are inactive for 60 minutes, but when used on a Unix server
it drops the user to the Unix prompt when logging them off from
Universe.

I am looking for a way to completely log the user off the server.

Thanks


Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
Support: http://tracker.selima.co.uk 
Forum: http://forum.selima.co.uk 
---

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] 7.1 - PE is available

2005-07-14 Thread Kevin Allen
I think so,  I just tried to go into the spooler and I don't have key
movement.  No enter key or anything within the spooler.

Kevin

-Original Message-
From: Wally Terhune [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 13, 2005 7:13 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 7.1 - PE is available

7.1 PEs ARE available now and have been for a bit.
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trials

Wally Terhune
Manager - U2 Advanced Technical Services
IBM Information Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]

Don't miss out on the IBM DB2 Information Management Technical Conference
September 11-16, 2005  Orlando, FL
http://www.ibm.com/software/data/u2/offers

Experience in-depth U2 product sessions, along with the entire DB2
Information Management Software product portfolio.



 Roger Glenfield
 <[EMAIL PROTECTED]
 net>   To
 Sent by:  u2 
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   [U2] 7.1
 07/13/2005 04:52
 PM


 Please respond to
 u2-users






Any word on the status of Unidata 7.1?  Any real life experiences?


No, lets not ask when the PE edition is coming out.

Roger
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of
pic19684.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


=== 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AUTOLOGOUT

2005-07-14 Thread Brian Leach
Andy,

How do you start their uv processes? 
If you are starting the uv process from e.g. a .profile or .login script,
remember that you need to 'exec' uv to overlay the current process or it
will create a subprocess to run UniVerse. In which case, the autologout will
simply be returning them to their calling shell.


Brian 

Hello,
> 
> Anyone got any ideas on the autologout command on a Unix environment?
> 
> We have it working happily on some Windows servers, set to 
> log people off if they are inactive for 60 minutes, but when 
> used on a Unix server it drops the user to the Unix prompt 
> when logging them off from Universe.
> 
> I am looking for a way to completely log the user off the server.
> 
> Thanks
> 
> 
> Andy Moore
> Selima Software Ltd
> Tel: 0114 2815000
> Fax: 0114 281
> email: [EMAIL PROTECTED]
> Support: http://tracker.selima.co.uk 
> Forum: http://forum.selima.co.uk 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] AUTOLOGOUT

2005-07-14 Thread u2
[EMAIL PROTECTED] wrote:
> 
> Hello,
> 
> Anyone got any ideas on the autologout command on a Unix environment?

How are your users logging in to Unix?
> 
> We have it working happily on some Windows servers, set to log people
> off if they are inactive for 60 minutes, but when used on a Unix server
> it drops the user to the Unix prompt when logging them off from
> Universe.

It's actually probably working the same on both. It kicks them out of the UV/UD 
environment.

With Windows, that IS their login environment so they get kicked off the server.

With Unix, chances are it's not their login environment, so they get dropped 
back to their login. Is U2 started up from their .profile? Or do they log into 
Unix and then start U2? If it's the latter, you're stuck.

If it's the former, look at the .profile. I think it's the 'exec' command - if 
you 'exec' U2 it then replaces the .profile environment - exit U2 and you get 
kicked off the system - that's the best approach. The other option is to finish 
.profile with "exit" - that terminates the login session and will kick them 
off, but it's vulnerable (a) to deliberate tampering, and (b) a crash *could* 
leave them in Unix.
> 
> Andy Moore
> Selima Software Ltd

Cheers,
Wol
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] Select Question

2005-07-14 Thread Mats Carlid

I'm aware of two differences that may be of importance

- if we're speaking uv -

The LIST alternative is immune to a secondary select
inside the loop  -  possibly well hidden in an itype in
a subroutine of an subr


The bare select lets the readnext loop start emediately
and saves (probably) one traversal of the file.


So yes You'd save overhead - lot's of wall clock time
and io but probably not that much cpu.

hth
-- mats


[EMAIL PROTECTED] wrote:


Hi all,

Can someone tell me the diference between the following two examples of 
executing an external select?

SELECT FILE TO LIST
LOOP
   READNEXT ID FROM LIST ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

SELECT FILE
LOOP
   READNEXT ID ELSE ID = @AM
UNTIL ID = @AM DO
REPEAT

Someone pointed out to me that there is overhead in selecting to a list that I 
need not be exposing myself to.  Aren't they both kind of reading from a list 
somewhere anyways?

Thanks
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] AUTOLOGOUT

2005-07-14 Thread Andy Moore
DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hello,

Anyone got any ideas on the autologout command on a Unix environment?

We have it working happily on some Windows servers, set to log people
off if they are inactive for 60 minutes, but when used on a Unix server
it drops the user to the Unix prompt when logging them off from
Universe.

I am looking for a way to completely log the user off the server.

Thanks


Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
Support: http://tracker.selima.co.uk 
Forum: http://forum.selima.co.uk 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV - GTARs

2005-07-14 Thread Ray Wurlod
Yes.  Eventually.  Probably when there's a business case (that is, the vendor 
can make some bucks by fixing it).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [Redback] multi-valued data displays strangely

2005-07-14 Thread Moderator

Adrian,
You may want to cross-post this the the rb solutions list.

   - Charles Barouch, Moderator
   Posting instructions:
   Visit http://listserver.u2ug.org/, enter your e-mail address, and 
'browse all' lists to maintain your access.


Womack, Adrian wrote:


Using RBOScope for testing - if I press enter to get a new line in a text box
and then call a validation routine which returns an error - the new line in
the text box has magically transformed into a "}" character.  When the data
arrives in my universe subroutine the new line is a value-mark (which is fine
by me).

Is there a way to keep the new line as a new line instead of a "}" ?

I've tried defining the field as a "Field" and later as a "mvField" in redback
designer, and it made no difference.

AdrianW

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Select Question

2005-07-14 Thread Brian Leach
The first syntax is used to ensure isolation of select lists.

It is a good practice to get into, in case someone later on modifies the
code processing whatever you are handling in your selection, especially if
that processing involves calling an external subroutine. Personally I prefer
to use select variables rather than list numbers for certain isolation.

Just in case that isn't clear, consider an example selecting and processing
some files.

If you were to do the following:

Open "VOC" To VOC Else STOP
Execute 'SELECT VOC WITH F1 LIKE F...'
Fin = @False
Loop
  ReadNext FileName Else Fin = @True
Until Fin Do
  GoSub DoFile
Repeat
(etc)

DoFile:
  Open FileName To FL Else Return
  Select FL
  Fin2 = @False
  Loop
ReadNext Id Else Fin2 = @True
  (etc)

The second select in DoFile will overwrite the contents the active select
list of files.

Using redirection this would be handled safely as the outer select is
isolated from the inner one:

Open "VOC" To VOC Else STOP
Execute 'SELECT VOC WITH F1 LIKE F...', SELECT. > FILELIST
Fin = @False
Loop
  ReadNext FileName FROM FILELIST Else Fin = @True
Until Fin Do
  GoSub DoFile
Repeat
(etc)

Brian
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [Redback] multi-valued data displays strangely

2005-07-14 Thread Womack, Adrian
Using RBOScope for testing - if I press enter to get a new line in a text box
and then call a validation routine which returns an error - the new line in
the text box has magically transformed into a "}" character.  When the data
arrives in my universe subroutine the new line is a value-mark (which is fine
by me).

Is there a way to keep the new line as a new line instead of a "}" ?

I've tried defining the field as a "Field" and later as a "mvField" in redback
designer, and it made no difference.

AdrianW










DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/