RE: [U2] submitRequest

[Stuart . Boydell]

   What's the value of RESULT?

   Is the request POST or GET?

   Are you using SSL?

   Have you tried increasing the timeout?

   Stuart

   -Original Message-

 RESULT=submitRequest(RHANDLE,"6000","",RHEAD,RDATA,RSTAT)
 RHEAD, RDATA AND RSTAT are always null (empty).
 Any thoughts or ideas would be incredibly appreciated.

   **

   This email message and any files transmitted with it are confidential

   and intended solely for the use of addressed recipient(s). If you have

   received  this  email  in  error please notify the Spotless IS Support
   Centre (+61 3 9269 7555) immediately, who will advise further action.

   This footnote also confirms that this email message has been scanned

   for the presence of computer related viruses.

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

RE: [U2] UniData and multi-core chips.

[David Wolverton]

For Windows the processes float?  Interesting!!  I was just reporting what
we were told eons ago -- that Processes were bound to a CPU on on startup on
a Windows MultiProcessor... If that's not the case, even better ...
Information in this area is hard to come by -- any authoritative information
is welcome!!   Where can we find more information on this?


"When you start up, in the case of a dual/quad-processor, my understanding
is that process is 'bound' to whatever CPU the OS kicked it off on... So, in
theory, you do get some advantage of multiple processors, but the load is
not dynamically balanced based on usage.

This is NOT how it works. The OS is able to start a process on a particular
CPU and then can move the process on to other CPU's as it sees fit, to
manage the load. E.g. does dynamically balance based on usage. There are OS
commands to "bind" processes to CPUs, but these should not normally
required, you are best to leave it up to the OS!
---
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] NESTING EVAL

[David Knight]

Not being an expert on EVAL, I would put all the IF THEN ELSE etc  into a
dictionary item. Would that be simpler?


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of rbl000
> Sent: Wednesday, 26 October 2005 3:51 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] NESTING EVAL
> 
> You don't nest EVAL's, you nest IF's.  I would rewrite your expression for
> clarity this way:
> 
> LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS NE Y) THEN 0 ELSE
> IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0"
> 
> Or perhaps:
> 
> LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = Y) * (H.HCG.AWARDED.ALL >
> 0) THEN 1 ELSE 0"
> 
> Richard Lewis
> IBM Certified Solutions Expert -- U2 Family Application Development
> 
> 
> 
>  --- On Tue 10/25, Kevin Michaelsen < [EMAIL PROTECTED] > wrote:
> From: Kevin Michaelsen [mailto: [EMAIL PROTECTED]
> To: u2-users@listserver.u2ug.org
> Date: Tue, 25 Oct 2005 11:00:58 -0400
> Subject: [U2] NESTING EVAL
> 
> Can I nest when using the EVAL command. Here is my statement that doesn't
> work. Do I need to put extra quotes somewhere or do I need to put brackets
> somewhere or is it not possible?LIST CS.2005 TOTAL EVAL "IF
> (H.CS.NEXT.CLASS = Y) THEN EVAL "IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0"
> ELSE 0 "Any help would be appreciated.KevinKevin MichaelsenAssociate
> Director of Financial Aid198 College Hill RoadHamilton CollegeClinton, NY
> 13323telephone (315) 859-4434   (800) 859-4413fax   (315) 859-
> 4457 ---u2-users mailing [EMAIL PROTECTED]
> unsubscribe please visit http://listserver.u2ug.org/
> 
> ___
> No banners. No pop-ups. No kidding.
> Make My Way  your home on the Web - http://www.myway.com
> ---
> 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] [OT] BREAKING NEWS

[Scott Ballinger]

[snip]
My solution is simply to filter any mail that contains text like "out of
office".  Unfortunately I miss all the wonderful discussions people have
about other people being out of the office... which will now include
this one.

Or with a name like tronic5... Oh, wrong list! ;)

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

RE: [U2] U2 SQL cache

[Allen E. Elwood]

Interesting thought...

I have my own TCL manager which is full screen editor/tcl manager and saves
the commands to a file with the Logon*Account as the ID.  That could be
considered "caching" inquiry requests.  The .L at tcl is caching inquiry
requests, and you can save them to file (with a few keystrokes).  So
therefore, you should be able to answer yes thereby satiating PHB demands
for a plethora of optionitis as a requirement for purchase.

p.s., I love my TCL manager as I can play with statements till I get them
working and then paste into a proc, or visa versa take from proc, play with
it till additions are made, and paste it back.  And three years later when
someone wants me to recreate that "one time only" request, I do a search for
filename or dict name till I find the statement - hit return and bingo,
three year old request resurrected from the dead!

Caching *is* good!

Allen
www.tortillfc.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anthony W.
Youngman
Sent: Tuesday, October 25, 2005 13:25
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 SQL cache


In message
<[EMAIL PROTECTED]>, Don
Kibbey <[EMAIL PROTECTED]> writes
>Be carefull how you explain that to the "unwashed masses".  I can just
>see the typical PHB exclaiming that UV/UD does not have this feature,
>therefore it must be inferior!

That's why I thought quite hard about how to word it.

And why I described it as "catch 22" and talked about PHBs :-)

Unfortunately, relational has won the marketing wars, but imho the whole
thing is totally unsound, primarily because it is based on maths without
a single drop of scientific proof anywhere.

Possibly the best way to say it to a PHB (provided he actually listens)
is that "UD is faster than SQL to start with. Query caching would only
slow it down". The other analogy I thought of is "which would you
prefer, an engine that gets 150bhp with a turbocharger, or one that gets
200bhp without?".

Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source
Pick
---
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] [OT] BREAKING NEWS

[Tony Gravagno]

> Rich Taylor is back in the office.
> For all my fans that breathlessly awaited the next
> automatic response...Sorry folks, forgot to set the
> exceptions list 

We don't need you anymore Richard, you've been replaced.  We're now being
comforted by frequent OoO notices from Russ DeWitt.  8^\
I'm sure when he gets back, someone else will be kind enough to turn on
their auto-sender for us.

My solution is simply to filter any mail that contains text like "out of
office".  Unfortunately I miss all the wonderful discussions people have
about other people being out of the office... which will now include this
one.

In a world with so much technology I marvel at how tens of millions of
people have such gracious tolerance for problems like this that go on every
day, year after year... and it's even funnier considering that so many of
us are IT people with the ability to fix it.

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

[U2] SIGPIPE Error on Universe

[Peter S. Goldberger]

Looking for help in clearing following error on printers (shows in 
LISTPEQS on several printers)

***Error: usd child received SIGPIPE signal. (10)

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

Re: [U2] File index problem on Unidata

[Manuel Owens]

Kevin,

When we completed our migration from True64 to AIX we had the same 
problem.  I had to delete all of the indexes and then rebuild them.  
First check to be sure that the index file is present where the VOC 
indicates it should be.  If the file is there try deleting it at the 
system level first.  Then you can copy another X_index file to its 
location.  Use DELETE.INDEX on the new file and then you can use 
CREATE.INDEX and BUILD.INDEX to index the file.




Kevin Yoders wrote:


Hello all,

I have a client that migrated from True64 to AIX a few weeks ago 
(I wasn't involved with the migration).  They are currently having a 
problem with an index corruption on a static file.  Unidata will not 
allow me to do a LIST, LIST.INDEX, DELETE.INDEX, or anything else I've 
tried on the file, giving me the error "Index: /path/X_filename has 
damaged index entries Open file error."  I tried renaming the 
X_filename index file and repeating the above.  The error messages now 
say "Index: open index file /path/X_filename error (2) Open file 
error."  Lots of help.  I've tried running guide_ndx on it, and it 
simply tells me it has errors.  Lots more help.


Unidata version is 6.1.11 on AIX (uname says AIX 570 3 5 ).  Any 
suggestions on how to get rid of the index or retrieving the data from 
the file to build a new file/index would be greatly appreciated.


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



--
**
Manuel Owens
Benefactor/UniData AdministratorBenefactor 5.1
University of California, Berkeley  Envision 4.7.1
Berkeley, CA 94720-4200 UniData 6.1.11
[EMAIL PROTECTED]   AIX 5.2
(510) 643-1495  
(510) 643-2154 FAX
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] submitRequest

[Mike Dallaire]

>As stated, I  pass it all

>through fine,

>but the return statuses never get back.

 

>RESULT=submitRequest(RHANDLE,"6000","",RHEAD,RDATA,RSTAT)

 

>  RHEAD, RDATA AND RSTAT   are always  null (empty).

 

>   Any thoughts or ideas would be incredibly appreciated.

 

Barry,

Just a quick glance at your email and two things come to mind.  1) the third
parameter in the submitRequest is the data being sent, you are sending a
null value.  May or may not be correct, just wondering. 2) Your timeout is
not very long.  You may be timing out before a response gets back to you.

Another helpful thing to do is to turn on protocol logging.  It can give you
lots of helpful information for debugging these types of issues.

HTH,

 

Mike Dallaire

Programmer

IBM Certified Solutions Expert - U2 UniVerse V9.6 Administrator for Unix and
Windows

Mortgage Builder Software Inc.

(248) 304-0600 x 103

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

RE: [U2] [OT] BREAKING NEWS

[karlp]

> We missed you so...:)

... but our aim will get better . . .


>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor
> Sent: Tuesday, October 25, 2005 1:03 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] [OT] BREAKING NEWS
>
> Rich Taylor is back in the office.
>
>
>
> For all my fans that breathlessly awaited the next automatic
> response...Sorry folks, forgot to set the exceptions 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
> ---
> 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/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Running Totals Universe

[Tom Dodds]

If you set up an I-Type that calls a subroutine with a named common where
you keep adding the field you want the running total on into the named
common variable and use the named common value as your answer it will give
you a running total.

0001: I
0002: SUBR("RUNBABY",ANS)
...

0001:  SUBROUTINE RUNBABY(RUNNING.TOTAL)
0002:  COM /RUNRUN/ RUNNING.TOTAL
0003:  RUNNING.TOTAL += @RECORD
0004:  END

I haven't done this for a while, but I think that is the syntax.
The problem with this is that you have to create another routine to clearout
the named common if you want to run the list more than once during a
session.  I used to do mine in a Paragraph and have the clear out routine as
a part of the Paragraph just before the list statement.

hth

Tom Dodds
[EMAIL PROTECTED]
630-235-2975
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz
Sent: Tuesday, October 25, 2005 11:51 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Running Totals Universe

Is there a way to display a running total in Universe within LIST
RECORD...  ?

I am looking thru the docs and I came across TRANSPORT.  At first, it
looked like the "ticket".  After giving it a try, I have come to the
conclusion that it is not.  Then I started to wonder what TRANSPORT
would ever be used for ?

If anyone knows any tricks, please tell.  In the meantime, I am doing a
quick program to do what I need.

Thanks
Anthony
---
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] File index problem on Unidata

[Doug Miller]

In the past when we had problems like this, we would create a small 
index on a file somewhere else.  We would then copy the X_file to the 
appropriate name and location of the broken one.  (There by 
substituting it temporarily)


At that point you can do your DELETE.INDEX file ALL

We (S7) always recommend that indexes be completely rebuilt from 
scratch when migrating to new platforms.


Doug Miller
Strategy 7


At 02:33 PM 10/25/2005, Kevin Yoders wrote:

Hello all,

I have a client that migrated from True64 to AIX a few 
weeks ago (I wasn't involved with the migration).  They are 
currently having a problem with an index corruption on a static 
file.  Unidata will not allow me to do a LIST, LIST.INDEX, 
DELETE.INDEX, or anything else I've tried on the file, giving me 
the error "Index: /path/X_filename has damaged index entries Open 
file error."  I tried renaming the X_filename index file and 
repeating the above.  The error messages now say "Index: open index 
file /path/X_filename error (2) Open file error."  Lots of 
help.  I've tried running guide_ndx on it, and it simply tells me 
it has errors.  Lots more help.


Unidata version is 6.1.11 on AIX (uname says AIX 570 3 5 ).  Any 
suggestions on how to get rid of the index or retrieving the data 
from the file to build a new file/index would be greatly appreciated.


Kevin
---
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] submitRequest

[Barry Rogen]

 I realize as I type this that I may be asking a very
general question to
a scenario that may in fact be very case specific, but I am quite
stumped and
hope that some light can be shed on my dilema.

 EnvironmentUniVerse  10.0.19  on  HPUX 11.0

  I  boldy ventured into using CallHTTP.   My goal was
process a
credit card order  over the web.  Well, I almost made it all the way
around
to home but for one thing.  The data is being pass very fine. The credit
card
orders are being  accurately approved or declined.  The problem is that
I can
not seem to receive the results of  the Response.write  command from the

asp being used.  Therefore programatically, I can not determine the
status
of the credit card authorization request.As stated, I  pass it all
through fine,
but the return statuses never get back.

RESULT=submitRequest(RHANDLE,"6000","",RHEAD,RDATA,RSTAT)

  RHEAD, RDATA AND RSTAT   are always  null (empty).

   Any thoughts or ideas would be incredibly appreciated.

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
[EMAIL PROTECTED]

-
Far better it is to dare mighty things, to win
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat





NOT INTENDED AS A SUBSTITUTE FOR A WRITING

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN
ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF
SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS
ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO
A CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A
PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.

This e-mail message from PNY Technologies, Inc. is for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] File index problem on Unidata

[colin.alfke]

Make sure you're the only one accessing the file. Remove the X_filename
file at the OS level. Copy another X_filename2 to X_filename (if you
don't have a handy one just create an index on a small file. Then your
DELETE.INDEX should work and you can re-create the index.

Hht
Colin Alfke
Calgary Canada 

>-Original Message-
>From: Kevin Yoders
>
>Hello all,
>
>   I have a client that migrated from True64 to AIX a few 
>weeks ago (I wasn't involved with the migration).  They are 
>currently having a problem with an index corruption on a 
>static file.  Unidata will not allow me to do a LIST, 
>LIST.INDEX, DELETE.INDEX, or anything else I've tried on the 
>file, giving me the error "Index: /path/X_filename has damaged 
>index entries Open file error."  I tried renaming the 
>X_filename index file and repeating the above.  The error 
>messages now say "Index: open index file /path/X_filename 
>error (2) Open file error."  Lots of help.  I've tried running 
>guide_ndx on it, and it simply tells me it has errors.  Lots more help.
>
>Unidata version is 6.1.11 on AIX (uname says AIX 570 3 5 
>).  Any suggestions on how to get rid of the index or 
>retrieving the data from the file to build a new file/index 
>would be greatly appreciated.
>
>Kevin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] U2 SQL cache

[Anthony W. Youngman]

In message 
<[EMAIL PROTECTED]>, Don 
Kibbey <[EMAIL PROTECTED]> writes

Be carefull how you explain that to the "unwashed masses".  I can just
see the typical PHB exclaiming that UV/UD does not have this feature,
therefore it must be inferior!


That's why I thought quite hard about how to word it.

And why I described it as "catch 22" and talked about PHBs :-)

Unfortunately, relational has won the marketing wars, but imho the whole 
thing is totally unsound, primarily because it is based on maths without 
a single drop of scientific proof anywhere.


Possibly the best way to say it to a PHB (provided he actually listens) 
is that "UD is faster than SQL to start with. Query caching would only 
slow it down". The other analogy I thought of is "which would you 
prefer, an engine that gets 150bhp with a turbocharger, or one that gets 
200bhp without?".


Cheers,
Wol
--
Anthony W. Youngman <[EMAIL PROTECTED]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [OT] BREAKING NEWS

[Caryl Lange]

We missed you so...:)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor
Sent: Tuesday, October 25, 2005 1:03 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [OT] BREAKING NEWS

Rich Taylor is back in the office.

 

For all my fans that breathlessly awaited the next automatic
response...Sorry folks, forgot to set the exceptions 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
---
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] Running Totals Universe

[Ray Wurlod]

Running totals happen automatically at breakpoints on any field for which the 
field modifier TOTAL is specified.

So one technique would be to BREAK.ON @ID DET.SUP

You can also create EVAL expressions or I-descriptor expressions that keep a 
running total and display same.  Here you can make use of the fact that the 
intermediate result variables (@1 through @20 and @ alone) are automatically 
initialized to zero.  EVAL "@2; @1 + FIELDNAME"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] NESTING EVAL

[Ray Wurlod]

Nested EVAL is not supported.  However, nested IF is supported, at least to a 
certain level of complexity.

LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = 'Y') THEN IF(H.HCG.AWARDED.ALL > 
0) THEN 1 ELSE 0 ELSE 0"

Or, even easier, since 1 is "true" and 0 is "false":

LIST CS.2005 TOTAL EVAL "(H.CS.NEXT.CLASS = 'Y') AND (H.HCG.AWARDED.ALL > 0)"
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [OT] BREAKING NEWS

[Richard Taylor]

Rich Taylor is back in the office.

 

For all my fans that breathlessly awaited the next automatic
response...Sorry folks, forgot to set the exceptions 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
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] File index problem on Unidata

[Kevin Yoders]

Hello all,

	I have a client that migrated from True64 to AIX a few weeks ago (I 
wasn't involved with the migration).  They are currently having a 
problem with an index corruption on a static file.  Unidata will not 
allow me to do a LIST, LIST.INDEX, DELETE.INDEX, or anything else 
I've tried on the file, giving me the error "Index: /path/X_filename 
has damaged index entries Open file error."  I tried renaming the 
X_filename index file and repeating the above.  The error messages 
now say "Index: open index file /path/X_filename error (2) Open file 
error."  Lots of help.  I've tried running guide_ndx on it, and it 
simply tells me it has errors.  Lots more help.


Unidata version is 6.1.11 on AIX (uname says AIX 570 3 5 ).  Any 
suggestions on how to get rid of the index or retrieving the data 
from the file to build a new file/index would be greatly appreciated.


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

Re: [U2] U2 SQL cache

[Don Kibbey]

Be carefull how you explain that to the "unwashed masses".  I can just
see the typical PHB exclaiming that UV/UD does not have this feature,
therefore it must be inferior!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] NESTING EVAL

[rbl000]

You don't nest EVAL's, you nest IF's.  I would rewrite your expression for 
clarity this way:

LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS NE Y) THEN 0 ELSE 
IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0"

Or perhaps:

LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = Y) * (H.HCG.AWARDED.ALL > 0) 
THEN 1 ELSE 0"

Richard Lewis
IBM Certified Solutions Expert -- U2 Family Application Development



 --- On Tue 10/25, Kevin Michaelsen < [EMAIL PROTECTED] > wrote:
From: Kevin Michaelsen [mailto: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Date: Tue, 25 Oct 2005 11:00:58 -0400
Subject: [U2] NESTING EVAL

Can I nest when using the EVAL command. Here is my statement that doesn't work. 
Do I need to put extra quotes somewhere or do I need to put brackets somewhere 
or is it not possible?LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = Y) THEN 
EVAL "IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0" ELSE 0 "Any help would be 
appreciated.KevinKevin MichaelsenAssociate Director of Financial Aid198 College 
Hill RoadHamilton CollegeClinton, NY  13323telephone (315) 859-4434   
(800) 859-4413fax   (315) 859-4457 ---u2-users mailing [EMAIL 
PROTECTED] unsubscribe please visit http://listserver.u2ug.org/

___
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Running Totals Universe

[Anthony Dzikiewicz]

Is there a way to display a running total in Universe within LIST
RECORD...  ?

I am looking thru the docs and I came across TRANSPORT.  At first, it
looked like the "ticket".  After giving it a try, I have come to the
conclusion that it is not.  Then I started to wonder what TRANSPORT
would ever be used for ?

If anyone knows any tricks, please tell.  In the meantime, I am doing a
quick program to do what I need.

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

RE: [U2] NESTING EVAL

[DAWES, Ray]

I would think that you do that as just one EVAL - remove the second EVAL.

Ray

-Original Message-
From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]
Sent: 25 October 2005 16:01
To: u2-users@listserver.u2ug.org
Subject: [U2] NESTING EVAL


Can I nest when using the EVAL command. Here is my statement that doesn't 
work. Do I need to put extra quotes somewhere or do I need to put brackets 
somewhere or is it not possible?

LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = Y) THEN EVAL 
"IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0" ELSE 0 "

Any help would be appreciated.


Kevin



Kevin Michaelsen
Associate Director of Financial Aid
198 College Hill Road
Hamilton College
Clinton, NY  13323

telephone (315) 859-4434
   (800) 859-4413
fax   (315) 859-4457 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


CONFIDENTIALITY NOTICE

The information contained in this e-mail is intended only for the
confidential use of the above named recipient. If you are not the intended
recipient or person responsible for delivering it to the intended recipient,
you have received this communication in error and must not distribute or
copy it. Please accept the sender's apologies, notify the sender immediately
by return e-mail and delete this communication. Thank you. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] NESTING EVAL

[Kevin Michaelsen]

Can I nest when using the EVAL command. Here is my statement that doesn't 
work. Do I need to put extra quotes somewhere or do I need to put brackets 
somewhere or is it not possible?

LIST CS.2005 TOTAL EVAL "IF (H.CS.NEXT.CLASS = Y) THEN EVAL 
"IF(H.HCG.AWARDED.ALL > 0) THEN 1 ELSE 0" ELSE 0 "

Any help would be appreciated.


Kevin



Kevin Michaelsen
Associate Director of Financial Aid
198 College Hill Road
Hamilton College
Clinton, NY  13323

telephone (315) 859-4434
   (800) 859-4413
fax   (315) 859-4457 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] U2 SQL cache

[Bob Little]

[EMAIL PROTECTED] wrote:

>[EMAIL PROTECTED] wrote:
>  
>
>>I'm only a novice when it comes to SQL/RDBMS so forgive me if I sound 
>>clueless here.
>>I'm considering recommending UniData as our next MV platform, and have 
>>been asked this question:
>>"Does UniData do 'result caching' or 'query caching'?"
>>
>>
>
>Umm ... this is a catch 22 question. Is the questioner a PHB ticking boxes, or 
>someone who really wants to know?
>  
>
>>I've not been able to find the answer on IBM's website.  Can anyone tell 
>>me or point me to a link?
>>
>>
>>
>The correct answer is "what's the point?". I'll explain.
>
>Query caching is an optimisation technique that is intended to overcome the 
>inherent limitations of a First Normal Form (relational) database engine. UD 
>is not FNF, therefore does not suffer this limitation, therefore does not need 
>(actually, cannot implement) this form of optimisation.
>
>To give my favourite example ... the invoice. A relational engine will scatter 
>the data for one invoice across multiple rows in multiple tables. A query 
>cache optimises and memorises how the query was executed, in order to speed it 
>up next time. UD will simply store the entire invoice in one record, and you 
>can't speed up a "got everything first attempt" query.
>
>The point is, relational THEORY is hopelessly inefficient. MV PRACTICE is very 
>efficient. So any relational optimisation is a waste of time in the MV world.
>
>Cheers,
>Wol
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>
>  
>
Smashing!  Thank you.
I had a feeling that because I was having such a hard time finding the 
answer to this question, it was irrelevant to UniData.



-- 
Bob Little
Graphik Dimensions, Ltd.
High Point, NC
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Creating Multiple page RTF documents

[Maresh, Mel]

I did something similar a few years and just created the source documents in 
Word with embedded tokens to be replaced dynamically by information from the 
database.  The documents were then saved in .rtf format.  Thus page soft breaks 
were handled by Word and, as I recall, Word would automatically adjust the page 
length if the inserted information made the page longer or shorter.  Hard page 
breaks were inserted as necessary for the end of sections, etc.

A technique that I found useful was to edit the documents in Notepad to reveals 
the embedded codes.

For example, the following code shows the document before and after a new page. 
 A is on page 1 and B is on page 2.  There is no hard page break.

\par A
\par B
\par 

This code shows a inserted hard page break

\par A
\par \page 
\par B

I hope this helps, please feel free to contract me offline if you have any 
other questions that you think I might be of help with.

Mel Maresh
NextiraOne
IT Senior Developer
713.307.4256
[EMAIL PROTECTED]




-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 6:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Creating Multiple page RTF documents


Hi. I am in the process of creating RTF documents in Universe and am stuck 
on how to create a multiple page document.

Currently I have a RTF template which was created in Word with tokens 
which I replace in databasic with the appropriate data. Also, the rtf 
document contains headers and footers (and the data in the header changes 
from one page to the next page) 

can anyone point me in the right direction on how to do this or if its 
possible?

 h
---
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] UniData and multi-core chips.

[James.E.Hogan]

"When you start up, in the case of a dual/quad-processor, my
understanding is that process is 'bound' to whatever CPU the OS kicked
it off on... So, in theory, you do get some advantage of multiple
processors, but the load is not dynamically balanced based on usage.
Therefore, if all your heavy users happen to get assigned to CPU1, then
CPU2 will be vastly underutilized. But if they sign off and back on, and
the load has not changed, it's likely their new session would be bound
to CPU2, but that is the OS handling the event, not UniData."

This is NOT how it works. The OS is able to start a process on a
particular CPU and then can move the process on to other CPU's as it
sees fit, to manage the load. E.g. does dynamically balance based on
usage. There are OS commands to "bind" processes to CPUs, but these
should not normally required, you are best to leave it up to the OS!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniData and multi-core chips.

[John Jenkins]

UniData and UniVerse both work file on multi-processor systems - they let
the O/S deal with the hardware and just deal with the O/S..

A point of note - each LPAR is to all intents and purposes a separate server
- so if you have UniData installed in separate LPARs you need separate
UniData licenses.


Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson
Sent: 24 October 2005 17:31
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: RE: [U2] Unidata and multi-core chips.

Hi all,
We are about to go to RFP for a new box.  How does this change the
dynamics if you use/"or are looking at" IBM's LPARS or virtual server
technology?  
-Keith Johnson
Lewis-Clark State College
500 8th Ave.
Lewiston, ID.  83501
208 792 2510
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] U2 SQL cache

[u2]

[EMAIL PROTECTED] wrote:
> I'm only a novice when it comes to SQL/RDBMS so forgive me if I sound 
> clueless here.
> I'm considering recommending UniData as our next MV platform, and have 
> been asked this question:
> "Does UniData do 'result caching' or 'query caching'?"

Umm ... this is a catch 22 question. Is the questioner a PHB ticking boxes, or 
someone who really wants to know?
> 
> I've not been able to find the answer on IBM's website.  Can anyone tell 
> me or point me to a link?
> 
The correct answer is "what's the point?". I'll explain.

Query caching is an optimisation technique that is intended to overcome the 
inherent limitations of a First Normal Form (relational) database engine. UD is 
not FNF, therefore does not suffer this limitation, therefore does not need 
(actually, cannot implement) this form of optimisation.

To give my favourite example ... the invoice. A relational engine will scatter 
the data for one invoice across multiple rows in multiple tables. A query cache 
optimises and memorises how the query was executed, in order to speed it up 
next time. UD will simply store the entire invoice in one record, and you can't 
speed up a "got everything first attempt" query.

The point is, relational THEORY is hopelessly inefficient. MV PRACTICE is very 
efficient. So any relational optimisation is a waste of time in the MV world.

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

[U2] Re: U2 Users Digest V1 #896

[Russ DeWitt]

I will be out of the office on business, Monday 10/24/2005 thru Wednesday 
10/26/2005. During this time I will not have access to my email. If you need to 
contact me, please call me on my cell phone.

Thanks,

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