RE: [U2] [DC] Dynamic Connect, Ctrl V

2006-03-23 Thread Bill Haskett
Bill:

In wIntegrate you would click on Setup  Keyboard then click on the
Alpha-numeric radio button in the Key List section.  Scroll down to
C_C, highlight it then make sure Ctrl and Macro are checked then in
the Definition enter Invoke EditCopy.  Do the same thing for the C_V
key except enter into the Definition Invoke EditPaste.

Hope this helps. 

Bill
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Brutzman, Bill
 Sent: Wednesday, March 22, 2006 3:06 PM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] [DC] Dynamic Connect, Ctrl V
 
 I have a user who like to use that Ctrl-V, Ctrl-Something to 
 cut and paste.
 
 Although it runs as part of the install, I am having trouble 
 finding info on
 it in the yr 2000 Using Dynamic Connect manual.
 
 Suggestions would be appreciated.
 
 --Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [DC] Dynamic Connect, Ctrl V

2006-03-23 Thread vance . alspach
We do this all of the time in Dynamic Connect.  I use Ctrl-V, etc for our 
in-house editor (ie; C-V shows ascii values, C-C merges from another 
program).  Our production session uses Ctrl-V and Ctrl-C for cut and 
paste.

Go into Setup-Keyboard, select the Alpha-numeric radio-button and change 
C_C to Invoke EditCopy and C_V to Invoke EditPaste (don't forget to check 
the Macro checkbox).  Save Session.

Could not find it in the Dynamic Connect manuals but stumble with the 
Wintegrate manuals and found it.


hth,


I have a user who like to use that Ctrl-V, Ctrl-Something to cut and 
paste.

Although it runs as part of the install, I am having trouble finding 
info on
it in the yr 2000 Using Dynamic Connect manual.

Suggestions would be appreciated.

--Bill


Vance Alspach
J  L Industrial Supply
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UD] BASIC Footing statement

2006-03-23 Thread Bill Haskett
We're finalizing a conversion from D3 to UD and there are a few issues
remaining.  Our client prints footings on all their reports.  The footing
doesn't print on the last page of the reports.  We've set UDT.OPTIONS 64 ON
and still no luck.

All their reports, both BASIC and UniQuery, are executed from a BASIC
program.  We've also set UDT.OPTIONS 7 ON to make sure pages aren't filled
on the screen.

Any suggestions would be appreciated.  Thanks.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV 10 and Windows 2003 Mapped Drives

2006-03-23 Thread Ray Buchner
I have some simple DOS batch processes executed from Universe Proc's
that are failing now that I moved Universe 10 to a Windows 2003 server.

An example would be this seemingly simple one...

copy d:\accounts\sklar\EDI.EXPORT\810.TXT Z:\Imports

Z:\ Is a mapped drive to another 2003 server called ECOMM_PA1 

When at a DOS command prompt (In windows) I can hit Z: and it connects
perfectly.  I can also execute the above copy command within the batch
process perfectly.

However, when I am in Universe and shell-out to DOS, I cannot hit this
mapped drive Z:  It gives the following error message...

C:\Z:
The system cannot find the drive specified.

I have triple checked all permissions on each side to no avail.  I have
also tried using a UNC path to ECOMM_PA1 which also failed.

Does anyone have any ideas?

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


RE: [U2] [UD] BASIC Footing statement

2006-03-23 Thread Mike Rajkowski
I did a quick test on the 7.1 PE, and it worked fine.  Try the following
on your system and see if it puts the last footer. 

Note that the footer I used was described in the online help.

001: PRINTER ON
002: FOOTING  Page 'PL'Paul''s Produce
003: FOR A = 1 TO 10
004:PRINT TEST :A
005:FOR B = 1 TO 10
006: PRINT LINE :B
007:NEXT B
008:IF A # 10 THEN
009:   PAGE
010:END
011: NEXT A
012: PRINTER OFF



Michael Rajkowski


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, March 23, 2006 8:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] BASIC Footing statement

We're finalizing a conversion from D3 to UD and there are a few issues
remaining.  Our client prints footings on all their reports.  The
footing
doesn't print on the last page of the reports.  We've set UDT.OPTIONS 64
ON
and still no luck.

All their reports, both BASIC and UniQuery, are executed from a BASIC
program.  We've also set UDT.OPTIONS 7 ON to make sure pages aren't
filled
on the screen.

Any suggestions would be appreciated.  Thanks.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
---
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] Determining other user's PORT

2006-03-23 Thread Jacques G.
Is there another way besides
PORT.STATUS  and
!GET.USERS

To get the port of other users ?  We have a client
that has Universe running on a version of Unix that
isn't fully compatible.  The PORT.STATUS command gives
the following line:

Unable to locate uniVerse user data area in kernel.

The !GET.USERS function isn't an option since the
Universe version is too old.  Anyone here know where
the port number information is stored ?  

Is it an algorithm that determines a number based on
the PID or based on the TTY ?

Most of the information given by PORT.STATUS can be
reconstructed with the who -a command or the finger
command with the exception of the PORT.NUMBER and
which program is running.  The last program executed
info can probably be found using the user's stack
which is stored in the SAVEDLISTS file.




__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10 and Windows 2003 Mapped Drives

2006-03-23 Thread Bob Woodward
I've made a couple of batch files that I run from laptops using WinXP.
I had to put a drive mapping command in them because, apparently,
dropping down to the OS from within Universe makes a new shell
environment.  Recreate your mapped drive with the NET USE command in
your batch file.  My process isn't perfect but before I do the NET USE
command, I use the following method to branch around if the drive letter
already exists:

if exist z:\nul then goto z.is.there
net use x: \\127.0.0.1\sharename password /user:DOMANE\USERID
/persistent:no
:z.is.there

Be sure to put in the valid DOMAIN\USERID and password.  Then set the
server IP and sharename and you should be good to go. Biggest issue this
doesn't handle is if the z: is pointing to a different location than
what you're wanting. Methods for ensuring that is a topic for a
different discussion.

HTH's

BobW
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner
Sent: Thursday, March 23, 2006 7:40 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV 10 and Windows 2003 Mapped Drives

I have some simple DOS batch processes executed from Universe Proc's
that are failing now that I moved Universe 10 to a Windows 2003 server.

An example would be this seemingly simple one...

copy d:\accounts\sklar\EDI.EXPORT\810.TXT Z:\Imports

Z:\ Is a mapped drive to another 2003 server called ECOMM_PA1 

When at a DOS command prompt (In windows) I can hit Z: and it connects
perfectly.  I can also execute the above copy command within the batch
process perfectly.

However, when I am in Universe and shell-out to DOS, I cannot hit this
mapped drive Z:  It gives the following error message...

C:\Z:
The system cannot find the drive specified.

I have triple checked all permissions on each side to no avail.  I have
also tried using a UNC path to ECOMM_PA1 which also failed.

Does anyone have any ideas?

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


RE: [U2] [UD] BASIC Footing statement

2006-03-23 Thread Bill Haskett
Mike:

Your program illustrates my problem.  Any other ideas?  When I direct output
to a hold file it looks like:

 1  Top of P_ in PEQS, 561 lines, 1,438 characters.
*--:
547:
548: Page   9
549: Paul's Produce
550: ^012
551: TEST 10
552: LINE 1
553: LINE 2
554: LINE 3
555: LINE 4
556: LINE 5
557: LINE 6
558: LINE 7
559: LINE 8
560: LINE 9
561: LINE 10
Bottom.

All UDT.OPTIONS are OFF except the following:

1 Dtademo (0)- UDT.OPTIONS
2  U_PSTYLEECL   ON
3  U_SHLNOPAGE   ON
7  U_NOMAKEPAGE  ON
15  U_DYNAMICNUL  ON
23  U_PK_READNEXT ON
32  U_PI_PRINT_AT ON
34  U_HEADING_DATEON
43  U_PRM_DETSUP   ON
46  U_UNFLUSHDATA ON
48  U_UNBOUNDARY ON
54  U_PROC_KPTSELECT ON
56  U_CONV_BADRETURN ON
64  U_BASIC_FINISHON
66  U_PICK_NUMERIC_FILESON
75  U_PROC_DELIMITER   ON
78  U_PICK_LOCK   ON
83  U_INPUT_ESC  ON
89  U_PICKSTYLE_MVSORT ON
92  U_INSENSITIVE_MATCH ON
104  U_TRAIL_FM_TLOAD ON
114  U_NOFORMFEED ON

1 Dtademo (0)- SETPTR
Unit   0
Width  132
Length 60
Top margin 3
Bot margin 3
Mode   1

Options are:

1 Dtademo (0)- LISTPTR
Printer...
Port...Status..Comment.
HPLJ2420   IP_192.168.1.41Running Dev printer

1 Dtademo (0)- U2INFO
Platform : INTEL
Operating System : WIN32-2000 Service Pack 4
Porting Date : Wed Jun 29 10:05:40 MDT 2005
UniData Release  : Version 7.1.0PE, Build 3146
Ported by: srcman

...Current account logged onto...
E:\DataTrust\DtaDemo


Licensed(UDT+CP)/Effective UdtSqliPhtmPooledTotal

(   2 + 0   ) / 210001

UDTNO USRNBR  UID   USRNAME  USRTYPE  TTY IP-ADDRESSTIME DATE
1  3096  197615 bill  udt pts/1   192.168.1.101 08:34:06 Mar 23
2006
2  2148  197615 bill  udt pts/2   192.168.1.101 08:36:05 Mar 23
2006

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Mike 
 Rajkowski
 Sent: Thursday, March 23, 2006 7:57 AM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] [UD] BASIC Footing statement
 
 I did a quick test on the 7.1 PE, and it worked fine.  Try 
 the following
 on your system and see if it puts the last footer. 
 
 Note that the footer I used was described in the online help.
 
 001: PRINTER ON
 002: FOOTING  Page 'PL'Paul''s Produce
 003: FOR A = 1 TO 10
 004:PRINT TEST :A
 005:FOR B = 1 TO 10
 006: PRINT LINE :B
 007:NEXT B
 008:IF A # 10 THEN
 009:   PAGE
 010:END
 011: NEXT A
 012: PRINTER OFF
 
 
 
 Michael Rajkowski
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
 Sent: Thursday, March 23, 2006 8:10 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UD] BASIC Footing statement
 
 We're finalizing a conversion from D3 to UD and there are a few issues
 remaining.  Our client prints footings on all their reports.  The
 footing
 doesn't print on the last page of the reports.  We've set 
 UDT.OPTIONS 64
 ON
 and still no luck.
 
 All their reports, both BASIC and UniQuery, are executed from a BASIC
 program.  We've also set UDT.OPTIONS 7 ON to make sure pages aren't
 filled
 on the screen.
 
 Any suggestions would be appreciated.  Thanks.
 
 Bill Haskett
 Advantos Systems, Inc.
 www.advantos.net 
 (760)944-5570 (CA)
 (360)923-4838 (WA)
 ---
 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 10 and Windows 2003 Mapped Drives

2006-03-23 Thread Bill Haskett
Ray:

Try this:

1)  In UniAdmin select Configuration Editor and change the ALLOWNFS
parameter to 1.
 
2)  Get to TCL in UV and execute the following:
 
   DOS /Cnet use Z: \\Server\Share Passwd /user:Server\U2Admin
   ...where Passwd is the actual password of the U2Admin user
   on the Server server.

3)  Create an F item in the VOC that looks like:

U2TEMP
   0001 F
   0002 Z:\Temp
   0003 D_VOC

This will allow UV to access shared network resources without UV/NET.

Hope this helps.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner
 Sent: Thursday, March 23, 2006 7:40 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV 10 and Windows 2003 Mapped Drives
 
 I have some simple DOS batch processes executed from Universe Proc's
 that are failing now that I moved Universe 10 to a Windows 
 2003 server.
 
 An example would be this seemingly simple one...
 
 copy d:\accounts\sklar\EDI.EXPORT\810.TXT Z:\Imports
 
 Z:\ Is a mapped drive to another 2003 server called ECOMM_PA1 
 
 When at a DOS command prompt (In windows) I can hit Z: and it connects
 perfectly.  I can also execute the above copy command within the batch
 process perfectly.
 
 However, when I am in Universe and shell-out to DOS, I cannot hit this
 mapped drive Z:  It gives the following error message...
 
 C:\Z:
 The system cannot find the drive specified.
 
 I have triple checked all permissions on each side to no 
 avail.  I have
 also tried using a UNC path to ECOMM_PA1 which also failed.
 
 Does anyone have any ideas?
 
 -Ray
 ---
 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] [DC] Dynamic Connect, Ctrl V

2006-03-23 Thread Anthony Caufield
This is set when you setup the session there is an option if you want to
use ctrl c and ctrl v. They can be setup a couple of ways. I recommend
creating a new session and selecting the option the user wants then
remove the old entry.

Tony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol
Sent: Wednesday, March 22, 2006 6:02 PM
To: Brutzman, Bill; 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] [DC] Dynamic Connect, Ctrl V

At 18:06 22/03/06 -0500, Brutzman, Bill wrote:

I have a user who like to use that Ctrl-V, Ctrl-Something to cut and
paste.

Although it runs as part of the install, I am having trouble finding
info on
it in the yr 2000 Using Dynamic Connect manual.

Suggestions would be appreciated.

Isn't it   CtrlC to copy and CrlV to paste?  (Standard Winblows)

The Edit menu of a DC session has copy and paste... and the above 
seems to work... for mebut not at an INPUT prompt...

--Bill
---
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.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06

Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is! 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06
---
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 10 and Windows 2003 Mapped Drives {Unclassified}

2006-03-23 Thread HENDERSON MIKE, MR
Bob, 

 -Original Message-
 From: [EMAIL PROTECTED] On Behalf Of Bob Woodward
 Sent: Friday, 24 March 2006 05:36
 To: Ray Buchner; u2-users@listserver.u2ug.org
 Subject: RE: [U2] UV 10 and Windows 2003 Mapped Drives
[snip]
 My process isn't perfect but before I do the NET USE command, I use
the 
 following method to branch around if the drive letter already exists:
 
 if exist z:\nul then goto z.is.there
 net use x: \\127.0.0.1\sharename password /user:DOMANE\USERID
/persistent:no 
:z.is.there
 
 Be sure to put in the valid DOMAIN\USERID and password.  

Hmm, so we now have a userID  password embedded in plain text in a
Basic program.
And we can't change the password without changing the source code
recompiling the program.
If this is the only way of doing this, I strongly recommend using
ENCRYPT() and storing the encrypted password on disk somewhere.
This has two advantages:
+   The plain-text password only exists briefly in memory, 
not permanently on disk
+   You can change the encrypted password on disk with a utility 
program and avoid recompiling

HTH

Mike

[snip]
 
 HTH's
 
 BobW
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or 
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [DC] Dynamic Connect, Ctrl V

2006-03-23 Thread Allen E. Elwood
Isn't that the old WordStar conventions for copy and paste?

I use CTRL-Insert for copy and SHIFT-Insert for paste shortcuts on all
windows applications.  Works 99%.9% of the time (Outlook 'FIND' doesn't see
it).  That said, I have no idea what Dynamic Connect is, or if it's even a
windows app.  But you might have your user try it.  Better to use a current
standard than one that's 20+ years old. imho.



Allen E. Elwood
www.tortillafc.com

Quality Code Since 1978

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony Caufield
Sent: Thursday, March 23, 2006 11:44
To: Bruce Nichol; Brutzman, Bill; u2-users@listserver.u2ug.org
Subject: RE: [U2] [DC] Dynamic Connect, Ctrl V


This is set when you setup the session there is an option if you want to
use ctrl c and ctrl v. They can be setup a couple of ways. I recommend
creating a new session and selecting the option the user wants then
remove the old entry.

Tony

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol
Sent: Wednesday, March 22, 2006 6:02 PM
To: Brutzman, Bill; 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] [DC] Dynamic Connect, Ctrl V

At 18:06 22/03/06 -0500, Brutzman, Bill wrote:

I have a user who like to use that Ctrl-V, Ctrl-Something to cut and
paste.

Although it runs as part of the install, I am having trouble finding
info on
it in the yr 2000 Using Dynamic Connect manual.

Suggestions would be appreciated.

Isn't it   CtrlC to copy and CrlV to paste?  (Standard Winblows)

The Edit menu of a DC session has copy and paste... and the above
seems to work... for mebut not at an INPUT prompt...

--Bill
---
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.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06

Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is!


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06
---
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] Oracle unix odbc driver

2006-03-23 Thread frederick . kuan
Hi all,

Anyone know where i can get a copy of racle unix odbc driver for aix 5.2? 
My dba said she cannot find it either from aix nor oracle 10 systems cds. 
Can anyone help?

Many Thanks
Frederick





To: [EMAIL PROTECTED] 
[EMAIL PROTECTED]
cc:  

Subject:Re: [U2] connection within UniVerse and Oracle


Frederick

If you have the Oracle unix odbc driver installed on the unix box then
you can use bci to connect to the oracle data. It works pretty well,
but may need a bit of setup first.

rgds
Symeon
www.a2c-ltd.com



On 2/28/06, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 I am trying to establish a connection between UniVerse 10.1 ( aix unix )
 and Oracle (Window 2003), has anyone done this before? I was told to
 either use socket connection or ODBC. It seems that it is not that easy 
to
 use socket connection talking to Oracle, so I am thinking of using ODBC?
 Any ideas. Thanks.

 Regards
 Frederick
 ---
 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] RE:[UV:Redback] Automatic Garbage Collection not running

2006-03-23 Thread John Jenkins
Charles

From 4.2.6 you have WWSESSION to consider as well - AFAIK there is nor eason
to do this manually nowadays.

Historically UNIVERSE on UNIX had a specific issue

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles
Sent: 22 March 2006 03:35
To: u2-users@listserver.u2ug.org
Cc: Womack, Adrian
Subject: [U2] RE:[UV:Redback] Automatic Garbage Collection not running

 We recently ran into a problem where the garbage collection 
 (GC) process would no longer run (our WWSTATE file contained 
 over a million records!, and the application response time 
 was abysmal).

RedBack 4.2.3, UV 10.0.16, HPUX 11i.

When we upgraded from 3.x we expected some enhanced garbage collection
but it didn't seem to work as advertised, so we went back to handling it
explicitly.

For our ap we know anything an hour old is not needed, so we schedule a
paragraph every 1/2 hour that does:

   SELECT WWSTATE WITH HRS.OLD = 1
   IF @SELECTED  0 THEN DELETE WWSTATE

where

   DICT WWSTATE HRS.OLD
   01: I
   02: (@DATE-DATE) * 24 + INT( (@TIME - TIME)/3600 )


IIRC, IBM suggests WWSTATE should be dynamic-hashed, but I ended up with
file corruption once upon a time shortly after changing it to dynamic.
Go figure.
So I changed it back to Type-18 with a much larger modulus than I should
ever need.  All access is direct reads. The only filescan is the purge
selection shown above, so an extra large modulus is perfectly efficient
 disk is cheap.

It works  if ain't broke don't fix it, so I don't fix it.

cds


P.S. Strategy-7 is our support vendor, and their RedBack guy, Martin
Fritter, has been a real gem to work with.  I don't know much about
RedBack and he's always gone the extra mile whenever I've needed him.
---
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] RE:[UV:Redback] Automatic Garbage Collection not running

2006-03-23 Thread Womack, Adrian
John,
Thanks for the tips. 

We are running 4.2.5 redback on UniVerse 10.0.19 on HP-UX. 

There's definitely an issue with GC getting stuck when it reschedules
itself to run very close to midnight. I've got it running again and I'm
monitoring it. If it does get stuck in the future, I guess we'll just
have to run GC manually (via cron or another background task)  disable
the built in scheduler.

I have resized the file to make it a lot larger, and I did keep it as a
type 18. I was considering changing it to dynamic (99.99% of all our
application files are dynamic - we came from PI/Open), but I'm not sure
of any other implications of doing that to any of the WWxxx files.

AdrianW 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins
Sent: Friday, 24 March 2006 6:57 AM
To: u2-users@listserver.u2ug.org
Cc: 'Stevenson, Charles'
Subject: RE: [U2] RE:[UV:Redback] Automatic Garbage Collection not
running

Charles

From 4.2.6 you have WWSESSION to consider as well - AFAIK there is nor
eason to do this manually nowadays.

Historically UNIVERSE on UNIX had a specific issue

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: 22 March 2006 03:35
To: u2-users@listserver.u2ug.org
Cc: Womack, Adrian
Subject: [U2] RE:[UV:Redback] Automatic Garbage Collection not running

 We recently ran into a problem where the garbage collection
 (GC) process would no longer run (our WWSTATE file contained over a 
 million records!, and the application response time was abysmal).

RedBack 4.2.3, UV 10.0.16, HPUX 11i.

When we upgraded from 3.x we expected some enhanced garbage collection
but it didn't seem to work as advertised, so we went back to handling it
explicitly.

For our ap we know anything an hour old is not needed, so we schedule a
paragraph every 1/2 hour that does:

   SELECT WWSTATE WITH HRS.OLD = 1
   IF @SELECTED  0 THEN DELETE WWSTATE

where

   DICT WWSTATE HRS.OLD
   01: I
   02: (@DATE-DATE) * 24 + INT( (@TIME - TIME)/3600 )


IIRC, IBM suggests WWSTATE should be dynamic-hashed, but I ended up with
file corruption once upon a time shortly after changing it to dynamic.
Go figure.
So I changed it back to Type-18 with a much larger modulus than I should
ever need.  All access is direct reads. The only filescan is the purge
selection shown above, so an extra large modulus is perfectly efficient
 disk is cheap.

It works  if ain't broke don't fix it, so I don't fix it.

cds


P.S. Strategy-7 is our support vendor, and their RedBack guy, Martin
Fritter, has been a real gem to work with.  I don't know much about
RedBack and he's always gone the extra mile whenever I've needed him.
---
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/


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] Distributed File Confusion

2006-03-23 Thread Ray Wurlod
Check out the VERIFY.DF and REBUILD.DF commands.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV 10 and Windows 2003 Mapped Drives {Unclassified}

2006-03-23 Thread Bob Woodward
Well, there is that.  smile  I mean, after all, I did say it wasn't
perfect.  

BobW
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Thursday, March 23, 2006 12:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV 10 and Windows 2003 Mapped Drives {Unclassified}

Bob, 


Hmm, so we now have a userID  password embedded in plain text in a
Basic program.
And we can't change the password without changing the source code
recompiling the program.
If this is the only way of doing this, I strongly recommend using
ENCRYPT() and storing the encrypted password on disk somewhere.
This has two advantages:
+   The plain-text password only exists briefly in memory, 
not permanently on disk
+   You can change the encrypted password on disk with a utility 
program and avoid recompiling

HTH

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


[U2] [UD] Setptr

2006-03-23 Thread Bill Haskett
If I generate a report to _HOLD_ by using SETPTR 0,3 can I then send
the report to another printer, say unit 2, by using SETPTR 2 just before I
SPOOL _HOLD_ P_.?

According to the documentation each report generated to _HOLD_ is
accompanied by another entry with the SETPTR commands; it even shows two
separate hold entries.  I only get one entry when I do this.  Is this
because I only have one printer on the Windows 2003 system?

As always, thanks.

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