Re: [U2] [UV] PORT.STATUS MFILE.HIST documentation?

2004-10-29 Thread Ray Wurlod
It's covered in the IBM course (UV905) UniVerse Theory and Practice, which is the 
replacement for UniVerse Internals.  (See 
http://www-306.ibm.com/services/learning/ites.wss/us/en?pageType=course_descriptioncourseCode=UV905)
  

Don't have a copy with me at the moment.  From memory you're on the right track.  The 
MF functions are the low-level functions that work with the rotating file pool.  
MFcheck determines whether an open file is currently in or out of the pool, and 
often returns having determined that the file's in.  MFclose, MFfree and MFopen you 
can probably guess after that!  (Note that MFfree is usually called from MFopen.)

The DB... functions are the higher-level, or logical, functions invoked by the 
UniVerse file manager.  For any file that's not guaranteed a file unit, it's always 
necessary to go via the rotating file pool.

Use the FILEMAP option of PORT.STATUS to map file names to FileNo and Chan.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] PORT.STATUS MFILE.HIST documentation?

2004-10-29 Thread Womack, Adrian
Thanks for the reply Ray,

I guess all this is pointing to the fact that our current setting of
MFILES is too low - BUT as far as we can tell everything is flying along
(and much faster than normal due to our new box). Will increasing MFILES
to a more reasonable level show a noticeable performance gain? Ours is
currently at 52, and I'm thinking 300 would be a sensible setting in our
situation. 

Is there an overhead to increasing MFILES? assuming that the Unix nfile
 maxfiles parameters are already set large enough to cope with MFILES
being increased. eg. With 250 users  increasing MFILES by a factor of
6, will we see memory usage sky rocket or will it be all gain and no
pain?

AdrianW

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Friday, 29 October 2004 3:03 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] PORT.STATUS MFILE.HIST documentation?

It's covered in the IBM course (UV905) UniVerse Theory and Practice,
which is the replacement for UniVerse Internals.  (See
http://www-306.ibm.com/services/learning/ites.wss/us/en?pageType=course_
descriptioncourseCode=UV905)  

Don't have a copy with me at the moment.  From memory you're on the
right track.  The MF functions are the low-level functions that work
with the rotating file pool.  MFcheck determines whether an open file
is currently in or out of the pool, and often returns having determined
that the file's in.  MFclose, MFfree and MFopen you can probably guess
after that!  (Note that MFfree is usually called from MFopen.)

The DB... functions are the higher-level, or logical, functions invoked
by the UniVerse file manager.  For any file that's not guaranteed a file
unit, it's always necessary to go via the rotating file pool.

Use the FILEMAP option of PORT.STATUS to map file names to FileNo and
Chan.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UD] UniObjects and Time zones

2004-10-29 Thread Adrian Matthews
Hven't you asked IBM, presumably they would know as both systems are
theirs?


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
Sent: 28 October 2004 21:26
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] [UD] UniObjects and Time zones

When we boot our AIX system, it shows the current date and time as GMT
(UTC?) and our time zone is EST, therefore when I do a date at the
Unix
prompt, I get:

Thu Oct 28 16:25:44 EST 2004

And when I do a DATE at our UniData prompt, I get:

Thu Oct 28 16:26:00 EST 2004

These are giving me the correct time and date.

When I do echo $TZ at a Unix prompt, I get:

EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00

Therefore, our time zone is correct as far as Unix and UniData goes.
However, when I run the command:

LIST WORK.ORDER DT TM SAMPLE 10

through a UniObjects program (see below), It gives me the raw date and
time - with no time zone offset applied.  So my question is, where does
UniObjects get the time zone when a dictionary containing @TIME, TIME(),
@DATE or DATE() is run?

btw, I don't see anything in my .profile that has anything to do with
time
zone.

Thanks.

Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512 

-Original Message-
From: Adrian Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 2:35 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] UniObjects and Time zones


You haven't got something in your account login that is setting timezone
stuff
perhaps?

Uniobjects bypasses the login. Also are you running the uo session under
the
same user as the telnet session that is giving you the correct date?
Might
be
set in profile.



From: [EMAIL PROTECTED] on behalf of Burwell, Edward
Sent: Thu 28/10/2004 15:08
To: '[EMAIL PROTECTED]'
Subject: [U2] [UD] UniObjects and Time zones



Yes, I am on Unix (AIX) and it would seem to be a time zone issue.  Any
dictionary containing @DATE, DATE(), @TIME or TIME(), that is run by
UniObjects is giving me GMT.

How can I tell UniObjects to apply our time zone?

Thanks

Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512

-Original Message-
From: Mark Eastwood [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 11:40 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from?


Assuming you're on Unix - there is an environmental setting tz for
timezone.  Try man on tz or timezone.

-Original Message-
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 10:06 AM
To: [EMAIL PROTECTED]
Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME
from?

Regardless, the @DATE and @TIME are different by about 5 hours.  Is
there a
setting in UniObjects that determines or sets the time zone that I'm in?

-Original Message-
From: Bob Witney [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 6:52 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from?


Yes @TIME on Universe is the proces start time as an intiger (regardless
of
what the book says) and TIME() is the actual time with decimals

i.e

42716
42716.8421
42716
42717.8422
42716
42718.8424

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brian Leach
Sent: 27 October 2004 11:15
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from?


@DATE and @TIME are not necessarily the current date and time, they are
the
date and time the current command/program started. I've seen this as
differences in a program between @TIME and TIME(), which always returns
the
current time.

I'm away from my server at the moment and can't verify this, but I
suspect
that @TIME might be the time that your UniObjects session began.

Brian

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
Sent: 27 October 2004 01:49
To: '[EMAIL PROTECTED]'
Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from?

Hello all,

I have a file with 2 dictionaries.  One called DT and the other TM:

DT
001 V
002 @DATE   I also tried DATE() and got the same thing
003
004
005 5R
006 S

TM
001 V
002 @TIME   I also tried TIME() and got the same thing
003
004
005 6R
006 S

When I run a simple UniQuery statement, I get exactly what you'd expect

LIST WORK.ORDER DT TM SAMPLE 5

WORK
ORDER. DT... TM

584367 13449  74797
59 13449  74797
628402 13449  74797
663471 13449  74797
698540 13449  74797
5 records listed


HOWEVER...

When I run this through UniOjects, I get:

LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT...
TM

584367 13450   6500
59 13450   6500
628402 13450   6500
663471 13450   6500
698540 13450   6500
5 records listed

I am running UniData 5.2 on AIX 4.3.2.

It's around 20:48 on 10/26/2004 as I write this.  The time and date is
right
on our Unix box and it's correct on my XP 

RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Adrian Matthews
Do you mean UniDebugger? There's no format facility in the wIntegrate
editor.

If so then that's not the only format bug in it, there's lot of modern
constructs that it gets confused with.

Proper format within Universe works fine.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: 29 October 2004 01:51
To: [EMAIL PROTECTED]
Subject: [U2] wIntegrate Editor indenting problem

Our VAR likes to pretend that the wIntegrate Editor does not exist, so
if anyone here can get this to the people who might actually fix it, I
would appreciate it!

When I write the following and do Edit-Format All, I get...
  WRITE R.XBEN.WEB.USER TO F.XBEN.WEB.USER, K.XBEN.WEB.USER ON ERROR
  ;*CRT 'STATUS = ':STATUS()
  IF STATUS() = 10 THEN
 RTN.MSG = X.DUPLICATE.IN.INDEX
  END 
  RELEASE
   END

It doesn't recognize the 'ON ERROR' clause of 'WRITE' as something that
needs an END.

Actually I asked about this on the list a couple of weeks ago, because
the documentation doesn't say that END is part of the syntax, it looks
like you only get one line after the WRITE to do what you need to do.

It seems to be working, but I use the autoindent to check my code, and
this looks wrong.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
...at 5:52, is it fixed yet, or still taking an hour to post?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/





The information contained in this email is strictly confidential and for the use of 
the addressee only, unless otherwise indicated. If you are not the intended recipient, 
please do not read, copy, use or disclose to others this message or any attachment. 
Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 
0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that 
do not relate to the official business of this company shall be understood as neither 
given nor endorsed by it.  IG Markets Limited and IG Index Plc are authorised and 
regulated by the Financial Services Authority and, in Australia, by the Australian 
Securities and Investments Commission.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2][UV]telnet

2004-10-29 Thread Rex Gozar
Bob:

I think Stu is trying to run another data entry application via telnet,
without the user realizing it.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Bob Witney
 Sent: Friday, October 29, 2004 3:05 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2][UV]telnet


 Stu:

 I think that you are attempting to so something akin to this;

   ftp -iv servername  EOF
 cd /account
 cd ramis_archive
 cd /account/CRG.VENDOR
 get filename
 quit
   EOF

 Where the login would be a line in .netrc on your home account

 i.e machine servername login loginid password passwordone

 I don't think that you can invoke a telnet session the same way

 Bob

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of Stu Glancy
 Sent: 28 October 2004 19:54
 To: [EMAIL PROTECTED]
 Subject: [U2][UV]telnet


 I want to create a telnet script from a program and execute
 it.  Can it
 be done?  If it can, what would the EXECUTE look like?  What
 would the
 script look like?  I'm looking for concept and a little detail.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/

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

 __
 This email has been scanned by the MessageLabs Email Security System.
 For more information please visit http://www.messagelabs.com/email
 __
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Doyen Klein
Well suggested Charles and Colin .

I had tried all lowercase knowing of the Pick flavor issue, but went with
Colin's gET.LIST just for fun, Doesn't' work on the paragraph name
(pARTLISTS is 'not found' but gET.LIST works just a well (or as poorly) as
GET.LIST did.

Charles, excellent idea, you can see from the _PH_ I am now getting
DELETE.LIST failed. I'm convinced it's some sort of system common issue from
the mysterious 'stat ITMST failed.' message. 

224: Executing PARTSLISTS   
225: DELETE.LIST 2956 failed.   
226: stat ITMMST failed.
227: Open file error.   
228: No active select list, creating empty saved list.  
229: No record retrieved.   
230: 0 records retrieved to list 1. 
231: No record retrieved.   
232: 0 records retrieved to list 2. 
233: 0 record(s) selected.  
234: No active select list, creating empty saved list.  
235: No record retrieved.   
236: 0 records retrieved to list 0. 
237: No active select list, creating empty saved list.  
238: Executing GET.LIST DIFFPARTS   
239: No record retrieved.   
240: 0 records retrieved to list 0. 
241: 0 items on select list 
242: Executing PARTSLISTS   
243: DELETE.LIST 2956 failed.   
244: stat ITMMST failed.
245: Open file error.   
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] PORT.STATUS MFILE.HIST documentation?

2004-10-29 Thread Clifton Oliver
Comments embedded in the message below.

Womack, Adrian wrote:
Thanks for the reply Ray,
I guess all this is pointing to the fact that our current setting of
MFILES is too low 
Not necessarily. A few MFopens is normal in most shops. It is when you 
see a burst of them than you have an indication of an issue; that is, 
you are cycling the file pool. For example, if you are watching with 
PORT.STATUS by using .X to snapshot it and you keep seeing a periodic 
burst of MF operation's, a program might be calling a subroutine that 
opens a set of files over and over. So you have to correlate what you 
see in MFILE.HIST with what is running and some knowledge of the 
application.

- BUT as far as we can tell everything is flying along
(and much faster than normal due to our new box). Will increasing MFILES
to a more reasonable level show a noticeable performance gain? Ours is
currently at 52, and I'm thinking 300 would be a sensible setting in our
situation. 
That might be a bit low, especially if your application is one of those 
that opens every file into a COMMON block at login.

But will you see a _noticable_ performance improvement? Depends on how 
many files you have open at a time and how many of those files a given 
program is likely to access.

Is there an overhead to increasing MFILES? assuming that the Unix nfile
 maxfiles parameters are already set large enough to cope with MFILES
being increased. eg. With 250 users  increasing MFILES by a factor of
6, will we see memory usage sky rocket or will it be all gain and no
pain?
The MFILE table is kept in the per-process memory segment. So you will 
see some increase in memory usage. But the entries in the table are not 
very large. (I don't remember how many bytes. Ray? LeRoy? Comments?) 
Whether it is significant or not depends on how much memory you have and 
what else is using it. But I've never hosed a system's overall 
performance by increasing MFILES reasonably.

fuzzymemory
nfiles  maxfiles--is this an HPUX system? Back a few years (pre y2k) 
one release of HPUX had an issue with memory management and setting 
MFILES higher than 50-something would cause problems with terminal I/O. 
That was solved long ago, but some shops have inherited the MFILES setting.

/fuzzymemory
--
Regards,
Clif
~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Wendy Smoak
Adrian Matthews wrote:

 Do you mean UniDebugger? 

No, I mean the graphical editor that comes with wIntegrate. Possibly
also known as WintEdit.  Text editing, color coding syntax and (usually)
indenting to show me which END goes with which IF, etc.

 There's no format facility in the wIntegrate editor.

There is in mine, assuming we're talking about the same thing:  Edit -
Format All.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Term settings for capture and no extra headings

2004-10-29 Thread Allen E. Elwood
There isn't a HDR-SUPP?  If you use this with NOPAGE it should get you what
you want.
hth, aee

Help Information For: UNIQUERY HDR.SUPP  Page: 1/2

Syntax

...HDR.SUPP

Synonyms

ECLTYPE U

HDR.SUP, HDR-SUP,  HDR-SUPP

ECLTYPE P

HDR-SUPP, SUPP

Description

The UniQuery HDR.SUPP keyword suppresses the default heading in a UniQuery
report. UniQuery continues to display the column headings.


Page 'U'p, 'D'own, 'T'op, 'B'ottom  or 'Q'uit?



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bill H.
Sent: Thursday, October 28, 2004 19:59
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] Term settings for capture and no extra headings


Troy:

I don't think this is possible.  I spent a day trying to find it.  There's a
bevy of stuff Universe doesn't do that D3 does easily.  This is one of them.
:-(

However, I think some mentioned the Report Viewer.  I use this a lot and
maybe it'll work for you.

Bill
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Dave Tabor
What version of the wIntegrate Editor do you have?  I'm on version 1.2 and I don't see 
anything for automatic indenting.  That would be a feature I'd like?
What version of wIntegrate did it come with?
Thanks,
Dave


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak
Sent: Friday, October 29, 2004 11:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] wIntegrate Editor indenting problem


Adrian Matthews wrote:

 Do you mean UniDebugger? 

No, I mean the graphical editor that comes with wIntegrate. Possibly
also known as WintEdit.  Text editing, color coding syntax and (usually)
indenting to show me which END goes with which IF, etc.

 There's no format facility in the wIntegrate editor.

There is in mine, assuming we're talking about the same thing:  Edit -
Format All.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Adrian Matthews
Weird, I can see it in the help now that you mention it but it isn't on
the menu where it says it is on our version (5.2).

I expect the format module used is the same with both UniDebugger and
WintEdit though so I expect its full of bugs. One of the reasons we use
EditPlus
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: 29 October 2004 16:01
To: [EMAIL PROTECTED]
Subject: RE: [U2] wIntegrate Editor indenting problem

Adrian Matthews wrote:

 Do you mean UniDebugger? 

No, I mean the graphical editor that comes with wIntegrate. Possibly
also known as WintEdit.  Text editing, color coding syntax and (usually)
indenting to show me which END goes with which IF, etc.

 There's no format facility in the wIntegrate editor.

There is in mine, assuming we're talking about the same thing:  Edit -
Format All.

-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/





The information contained in this email is strictly confidential and for the use of 
the addressee only, unless otherwise indicated. If you are not the intended recipient, 
please do not read, copy, use or disclose to others this message or any attachment. 
Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 
0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that 
do not relate to the official business of this company shall be understood as neither 
given nor endorsed by it.  IG Markets Limited and IG Index Plc are authorised and 
regulated by the Financial Services Authority and, in Australia, by the Australian 
Securities and Investments Commission.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Wendy Smoak
Dave Tabor wrote:
 What version of the wIntegrate Editor do you have?  I'm on 
 version 1.2 and I don't see anything for automatic indenting. 
  That would be a feature I'd like?
 What version of wIntegrate did it come with?

Help-About in the editor is reporting 4.2.1, also...

:WIN.HOSTVER
Host Programs:
   Version:4.2.1
   Machine Type:   UD
   Parameter File: WIN.PROGS

Hope that helps!
-- 
Wendy Smoak
Applications Systems Analyst, Sr.
Arizona State University, PA, IRM 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Term settings for capture and no extra headings

2004-10-29 Thread Buss, Troy \(Logitek Systems\)
Thanks Bill and everyone for their ideas.

Some more clarification and information...

We have a generic wrapper around all reports, both basic and ad hoc
universe query.  

One of the options (besides PRINTING the report) is that the user can
choose to 'capture' the output and a wintegrate script is executed which
turns on capture to a file  (running in NO.PAGE mode).  Once the report
is captured, they might use the report for excel or word or notepad
editing.

I would like to retain at least the first page's heading because it
contains the column names and other information that may be useful for
the report such as date ranges, report title, as of date, etc.

If I do not change the page depth from 60, I get an undesirable page
header every 60 lines which means the user has to manually remove them.
By changing the page depth to zero in D3, one was able to get the first
page headings, but there was never a second page so the report 'data'
continued all the way to the end (without page breaks).

What I have done for Universe is to set the maximum of 32767 for a page
depth, but for some reports there is a chance that the data may exceed
this line count.  In addition, we have a few basic programs that do a
'page' command that forces a new heading and we end up with almost
32,000 blank lines before the next page heading because universe is
essentially filling out the prior page with CRLF for the remaining line
count.

The only work around that I've come up with (conceptually so far) is to
create a hold file (via (P) printing the job), trim out the blank lines
before form feeds, turn on capture, and then PRINT the HOLD file text
to winteg, and then turn off capture.   (I already do a similar process
for normally printed laserjet reports to eliminate the leading form feed
on all of our print jobs which saves a ton of blank page paper.)

I was just hoping there was some undocumented ASSIGN 1 TO SYSTEM(magic
number) thing that fixed this. Or any other ideas that would work??
Thanks!

-Troy


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill H.
Sent: Thursday, October 28, 2004 7:59 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] Term settings for capture and no extra headings

Troy:

I don't think this is possible.  I spent a day trying to find it.
There's a bevy of stuff Universe doesn't do that D3 does easily.  This
is one of them.
:-(

However, I think some mentioned the Report Viewer.  I use this a lot
and maybe it'll work for you.

Bill
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] wIntegrate Editor indenting problem

2004-10-29 Thread Dave Tabor
Also, used in selected sections using Alt-F8.  I like it.  (How'd I ever miss that 
one!)
Thanks for the tip, everyone!
- Dave

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: 29 October 2004 16:01
To: [EMAIL PROTECTED]
Subject: RE: [U2] wIntegrate Editor indenting problem


 There's no format facility in the wIntegrate editor.

There is in mine, assuming we're talking about the same thing:  Edit -
Format All.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] AE on UniVerse

2004-10-29 Thread Chuck Mongiovi
Hey all,
I'd like to run AE (the UniData line editor) on UniVerse .. The source code
doesn't come with UniData .. Does anyone out there (maybe IBM?) have the
source code available so that I can port it over?

-Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Information on the Unidata fixfile command!

2004-10-29 Thread Bright, Frank
Hi,

Does anyone have a manual or information on using the Unidata fixfile command??  
Especially of how to run the command without the prompts (yes or no) from occuring.

Thanks in Advance!


Frank
[EMAIL PROTECTED]


___
Frank M. Bright [EMAIL PROTECTED] 
Administrative Computing
University of the Arts (A15)  http://www.uarts.edu 
320 S. Broad St.  215-717-6081(w) 
Philadelphia, PA 19102 215-717-6087(f) 
Colleague 17.0.14  AIX 5.2.0.2   Unidata 6.03
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Re: Logging to Universe NT

2004-10-29 Thread Ron White
For users that are not administrators go to the control
panel and select a user that is not an administrator.
Click on properties.  On the property dialog click on
Member Of and add the user the built-in users
group.  Then go to the Profile tab and in the Home
folder section click local path.  Key in the full path
of the account the user will be logged into.  Save the
profile and the user should be able to login normally.
Ron White
- Original Message - 
From: Kevin Vezertzis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 12:30 PM


Just wondering if anyone has any suggestions on how to allow 'non-admin'
groups access to Universe on NT..my users that are members of Admin
login perfectly, but a second group (webuser), has similar permissions
and has been configured to log on locally, but is still not able to
login.
Thanks,
Kevin
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
[ E-mail scanned Virus Free by NAI - McAfee anti-virus system ]

---
[ E-mail scanned Virus Free by NAI - McAfee anti-virus system ]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Alfke, Colin
Perhaps it's the user you're running the phantom as. Maybe there is a
permission issue in the list directory.

Hth
Colin

-Original Message-
From: Doyen Klein [mailto:[EMAIL PROTECTED] 

Well suggested Charles and Colin .

I had tried all lowercase knowing of the Pick flavor issue, but went
with Colin's gET.LIST just for fun, Doesn't' work on the paragraph name
(pARTLISTS is 'not found' but gET.LIST works just a well (or as poorly)
as GET.LIST did.

Charles, excellent idea, you can see from the _PH_ I am now getting
DELETE.LIST failed. I'm convinced it's some sort of system common issue
from the mysterious 'stat ITMST failed.' message. 

224: Executing PARTSLISTS   
225: DELETE.LIST 2956 failed.   
226: stat ITMMST failed.
227: Open file error.   
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AE on UniVerse

2004-10-29 Thread David Scoggins
Any way you can backport it to 10.0 (10.0.17 to be precise)?

 -Original Message-
 From: Leroy Dreyfuss [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 29, 2004 12:09 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [U2] AE on UniVerse
 
 
 AE was ported to UV at release 9.6, but only for UNIX. I ported it to
 Windows in 10.1.
 
 Hey all,
 I'd like to run AE (the UniData line editor) on UniVerse .. 
 The source
 code
 doesn't come with UniData .. Does anyone out there (maybe 
 IBM?) have the
 source code available so that I can port it over?
 
 -Chuck
 ---
 
 We do not ship the source on UV either.
 
 
 Regards,
 
 LeRoy F. Dreyfuss
 Product Manager
 IBM UniVerse and UniData (U2) Extended Relational Databases
 IBM DB2 Information Management Software
 Tel: 303-672-1254  Fax: 303-294-4832
 Mobile: 720-341-4317   Tie-line: 770-1254
 External email:  [EMAIL PROTECTED]
 WWW:  http://www.ibm.com/software/data/u2
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] AE on UniVerse

2004-10-29 Thread Chuck Mongiovi
 Any way you can backport it to 10.0 (10.0.17 to be precise)?

How about UV 9.6?
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread Wendy Smoak
From the documentation:

READU dyn.array.var FROM [file.var,] record.ID.expr [LOCKED statements]
[ON ERROR statements] {THEN statements [END] | ELSE statements [END]}

Am I reading this right?  When I READU I can either have a THEN or an
ELSE, but not both?  (That it does not compile with both tends to
confirm that...) 

At the moment I think I need both. :/ And I need to do the same thing in
either case, so I ended up with:

READU R.XBWU FROM F.XBWU, X.ONE.ID LOCKED
   CRT 'XBWU RECORD IS LOCKED, IGNORE IT'
END THEN
   X.LOCKED = '1'
END ;*END READU

IF X.LOCKED = '1' THEN
   CRT 'OBTAINED LOCK ON XBWU RECORD'
   R.XBWUXBWU.ASURITE = X.ASURITE
   WRITE R.XBWU TO F.XBWU, X.ONE.ID ON ERROR
  IF STATUS() = 10 THEN 
 ;* Either the ASURITE or USER.ID is duplicated
 X.ERROR = X.DUPLICATE.ON.WRITE
  END ;* IF STATUS
   END ;* END WRITE
END ;* IF X.LOCKED

Suggestions for improvement are welcome!

-- 
Wendy Smoak
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Cannot access list ML_3516_1 Unidata phantom (MERGE.LIST)

2004-10-29 Thread Doyen Klein
I've wondered about that. As an update, a simple program that just
udtexecutes the selects seems to work. If the program opens the same file as
the select, the second select doesn't work. If the program opens and then
closes the file, the time it tries to open, it fails.

All of these examples work ok from tcl so it's not an simple programming
bug. The user shows that same name as the login id, so I wouldn't think (but
could be wrong) that the 'phantom' process has different rights than the
terminal process (Don't know how this is implemented in Windows, in *nx I
could do some testing)

I think it's how the open files are kept in a 'system' common area.

Btw: I even tried the OPEN READONLY in hopes that it would work. No dice.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:owner-u2-
 [EMAIL PROTECTED] On Behalf Of Alfke, Colin
 Sent: Friday, October 29, 2004 1:11 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Cannot access list ML_3516_1 Unidata phantom
 (MERGE.LIST)
 
 Perhaps it's the user you're running the phantom as. Maybe there is a
 permission issue in the list directory.
 
 Hth
 Colin
 
 -Original Message-
 From: Doyen Klein [mailto:[EMAIL PROTECTED]
 
 Well suggested Charles and Colin .
 
 I had tried all lowercase knowing of the Pick flavor issue, but went
 with Colin's gET.LIST just for fun, Doesn't' work on the paragraph name
 (pARTLISTS is 'not found' but gET.LIST works just a well (or as poorly)
 as GET.LIST did.
 
 Charles, excellent idea, you can see from the _PH_ I am now getting
 DELETE.LIST failed. I'm convinced it's some sort of system common issue
 from the mysterious 'stat ITMST failed.' message.
 
 224: Executing PARTSLISTS
 225: DELETE.LIST 2956 failed.
 226: stat ITMMST failed.
 227: Open file error.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] RE: READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread Wendy Smoak
 From: Wendy Smoak 
 Am I reading this right?  When I READU I can either have a 
 THEN or an ELSE, but not both?  (That it does not compile 
 with both tends to confirm that...) 

Oh, never mind.  It compiles fine.  It must be a mismatched END
somewhere.  (See my previous gripe about the Wintegrate Editor not
formatting WRITE/ON ERROR properly!)

-- 
Wendy Smoak
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread Allen Egerton
On Fri, 29 Oct 2004 14:07:56 -0700, you wrote:

From the documentation:

READU dyn.array.var FROM [file.var,] record.ID.expr [LOCKED statements]
[ON ERROR statements] {THEN statements [END] | ELSE statements [END]}

Am I reading this right?  When I READU I can either have a THEN or an
ELSE, but not both?  (That it does not compile with both tends to
confirm that...) 

At the moment I think I need both. :/ And I need to do the same thing in
either case, so I ended up with:

READU R.XBWU FROM F.XBWU, X.ONE.ID LOCKED
   CRT 'XBWU RECORD IS LOCKED, IGNORE IT'
END THEN
   X.LOCKED = '1'
END ;*END READU

IF X.LOCKED = '1' THEN
   CRT 'OBTAINED LOCK ON XBWU RECORD'
   R.XBWUXBWU.ASURITE = X.ASURITE
   WRITE R.XBWU TO F.XBWU, X.ONE.ID ON ERROR
  IF STATUS() = 10 THEN 
 ;* Either the ASURITE or USER.ID is duplicated
 X.ERROR = X.DUPLICATE.ON.WRITE
  END ;* IF STATUS
   END ;* END WRITE
END ;* IF X.LOCKED

Suggestions for improvement are welcome!

I don't know if this is an improvement, (actually I know that the
GOTO's in it will offend some people), but here's a snippet of code I
lifted directly from a routine that's heavily used in a Universe
multi-user environment:


ATTEMPTS = 0
READ.NAFILE.DB:
READU D.NAFILE.DB FROM F.NAFILE.DB, K.NAFILE.DB LOCKED
 ATTEMPTS += 1
 IF ATTEMPTS LT 50 THEN  ; *  About 20 Mins, (21:15)
CRT CLR22DOWN: NAFILE.DB : K.NAFILE.DB:
CRT  locked by : STATUS(): , (pausing before retry [:
ATTEMPTS: ]).:
CALL !SLEEP$(ATTEMPTS*1000)
CRT CLR22DOWN:
GOTO READ.NAFILE.DB:
 END ELSE
ERROR.MSG = Record locked and consequently skipped
CALL @WSEQ(*** ERROR *** : K.NAFILE.DB, F.RPT.1)
CALL @WSEQ(  : ERROR.MSG, F.RPT.1)
CALL @WSEQ(  : RAW.LINE, F.RPT.1)
CALL @WSEQ( , F.RPT.1)
CNT.LOCKED += 1
GOTO NEXT.INPUT.LINE:
 END
  END THEN
 NULL
  END ELSE
 ERROR.MSG = Record apparently deleted from database.
 CALL @WSEQ(*** ERROR *** : K.NAFILE.DB, F.RPT.1)
 CALL @WSEQ(  : ERROR.MSG, F.RPT.1)
 CALL @WSEQ(  : RAW.LINE, F.RPT.1)
 CALL @WSEQ( , F.RPT.1)
 RELEASE F.NAFILE.DB, K.NAFILE.DB
 CNT.ABNORMAL += 1
 GOTO NEXT.INPUT.LINE:
  END


-- 
Allen Egerton
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread Horn, John
 On Behalf Of Wendy Smoak
 
 Am I reading this right?  When I READU I can either have a THEN or
an
 ELSE, but not both?  (That it does not compile with both tends to
 confirm that...) 

This snippet of code compiles on Unidata 6.0:

ID=???
OPEN ,VOC TO BLAH ELSE STOP 

READU DUM FROM BLAH,ID LOCKED   
   DISPLAY LOCKED 
END THEN
   DISPLAY GOT IT 
END ELSE
   DISPLAY DON'T GOT IT   
END 

And seems to run correctly.

 - jmh
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread CDMI
Wendy - here's a snippet:
DONELOK = 0
LOOP UNTIL DONELOK = 1 DO
 READU LOKREC FROM CUSTOMERFILE,CUSTID LOCKED
  CRT TIMEDATE():\ port \:SYSTEM(18):\ file CUSTOMER item \:CUSTID:\locked!\
; SLEEP 1
 END THEN DONELOK = 1 ELSE LOKREC = '' ; DONELOK = 1
REPEAT

notice the LOCKED END THEN  ELSE

Steve Trimble
Computerized Data Mgmt Inc
PO Box 3473
Fayetteville, AR 72702
(479) 521-5670
9:00am - 6:00pm CST
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak
Sent: Friday, October 29, 2004 4:08 PM
To: [EMAIL PROTECTED]
Subject: [U2] READU ... THEN _or_ ELSE but not both?


From the documentation:

READU dyn.array.var FROM [file.var,] record.ID.expr [LOCKED statements]
[ON ERROR statements] {THEN statements [END] | ELSE statements [END]}

Am I reading this right?  When I READU I can either have a THEN or an
ELSE, but not both?  (That it does not compile with both tends to
confirm that...)

At the moment I think I need both. :/ And I need to do the same thing in
either case, so I ended up with:

READU R.XBWU FROM F.XBWU, X.ONE.ID LOCKED
   CRT 'XBWU RECORD IS LOCKED, IGNORE IT'
END THEN
   X.LOCKED = '1'
END ;*END READU

IF X.LOCKED = '1' THEN
   CRT 'OBTAINED LOCK ON XBWU RECORD'
   R.XBWUXBWU.ASURITE = X.ASURITE
   WRITE R.XBWU TO F.XBWU, X.ONE.ID ON ERROR
  IF STATUS() = 10 THEN
 ;* Either the ASURITE or USER.ID is duplicated
 X.ERROR = X.DUPLICATE.ON.WRITE
  END ;* IF STATUS
   END ;* END WRITE
END ;* IF X.LOCKED

Suggestions for improvement are welcome!

--
Wendy Smoak
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] READU ... THEN _or_ ELSE but not both?

2004-10-29 Thread Kryka, Richard
I like this format:

READU RECORD FROM FILE, ID LOCKED

END THEN

END ELSE

END

Dick Kryka
Director of Applications
CCCS of Greater Denver, Inc.
Paragon Financial Services
303-632-2226
[EMAIL PROTECTED]
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Friday, October 29, 2004 3:08 PM
To: [EMAIL PROTECTED]
Subject: [U2] READU ... THEN _or_ ELSE but not both?

From the documentation:

READU dyn.array.var FROM [file.var,] record.ID.expr [LOCKED statements]
[ON ERROR statements] {THEN statements [END] | ELSE statements [END]}

Am I reading this right?  When I READU I can either have a THEN or an
ELSE, but not both?  (That it does not compile with both tends to
confirm that...) 

er.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/