Martin Phillips wrote:
When I teach U2 programming courses, I suggest that the ON ERROR
clause is almost useless to most applications. I get very annoyed when
I see live applications the have something like
WRITE REC TO FVAR, ID ON ERROR ABORT Write failed as this message
is significantly
Hi
Does anyone know why garbage collection could stop working on RedBack (4.2.3),
or how I can bring it back to life?
I have a client with state file that is badly undersized, with 160,000 sessions
(and rising) in the LOADBAL.COUNTER. It is not (yet) configured to use the
WWSESSION file. It
I seem to remember a bug in garbage collection at some point. When did
it last run (time of day, not date!)?
There was something about it not working if the previous run was just
before midnight, because all time comparisons were earlier than the last
run so it couldn't calculate time since last
Wol
Bingo!
Brian
I seem to remember a bug in garbage collection at some point. When did
it last run (time of day, not date!)?
There was something about it not working if the previous run was just
before midnight, because all time comparisons were earlier than the last
run so it couldn't
Just run REDBACK.GC from your account with RedBack installed on it or from
RBDEFN account.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, May 30, 2007 5:14 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] RedBack
How does one select alpha-numeric data from a unidata datafile using
SELECT when the case of the text is not known?
I have tried things like:
SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...'
but all I get is a syntax error.
Can someone tell me which function(s) can be used to facilitate
On 5/30/07, daverch [EMAIL PROTECTED] wrote:
Just run REDBACK.GC from your account with RedBack installed on it or from
RBDEFN account.
We run REDBACK.GC at the end of a nightly process we run as a phantom
and works very well. Just thought that little 2 cents worth of info.
;)
Andy
---
In ECLTYPE u
SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC...
If you are currently in ECLTYPE p, you can put the word SELECT in
lowercase to evaluate using the u parser.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent:
Create a new dictionary item with conversion code 'MCU' pointing at the
same attribute#. Use that dictionary item in your select.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent: Wednesday, May 30, 2007 1:28 PM
To:
Create an I-Type pointing to the text field that converts all the text
to upper case and use it in the select
I-Type: UP.HRP.LAST.NAME
001: I
002: OCONV(HRP.LAST.NAME,'MCU')
003:
004: LAST NAME
005: 25L
006: S
Greg Schraiber wrote:
How does one select alpha-numeric data from a unidata
Try: SELECT HRPER WITH EVAL UPCASE(HRP.LAST.NAME) LIKE 'SC...'
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent: Wednesday, May 30, 2007 12:28 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] unibasic select woes
How does one select
Thanks Karen!
Is there really no other way? Seems odd that you can't use functions
in the select statement.
Greg
At 12:42 PM 5/30/2007, Karen Bessel wrote:
Create a new dictionary item with conversion code 'MCU' pointing at the
same attribute#. Use that dictionary item in your select.
Hi Greg,
Create a dictionary item named, for example, U.HRP.LAST.NAME, and defined as
001: I
002: UPCASE(HRP.LAST.NAME)
Fields 3 onwards as for HRP.LAST.NAME
Then do
SELECT HRPER WITH U.HRP.LAST.NAME LIKE 'SC...'
Alternatively, do
SELECT HRPER WITH EVAL UPCASE(HRP.LAST.NAME) LIKE 'SC...'
Greg Schraiber wrote:
How does one select alpha-numeric data from a unidata datafile using
SELECT when the case of the text is not known?
I have tried things like:
SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...'
but all I get is a syntax error.
Can someone tell me which function(s) can
Dave, Wyatt Karen,
Thank you so much for the tips!
Works like a charm!
Thanks again,
Greg
At 12:45 PM 5/30/2007, Dave Davis wrote:
In ECLTYPE u
SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC...
If you are currently in ECLTYPE p, you can put the word SELECT in
lowercase to
The EVAL function that someone else mentioned also should work. I've
never used it personally so I forgot about that. :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent: Wednesday, May 30, 2007 1:52 PM
To: u2-users@listserver.u2ug.org;
Create a new dictionary item like the following:
ED DICT HRPER UPC.HRP.LAST.NAME
001: V
002: OCONV(HRP.LAST.NAME, MCU)
003:
004:
005: 10L
006: S
SELECT HRPER WITH UPC.HRP.LAST.NAME LIKE 'SC...'
Bruce W. McAdoo
Wagner Brown, Ltd.
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL
SELECT HRPER WITH HRP.LAST.NAME CONV MCU LIKE 'SC...'
Should work.
-Original Message-
How does one select alpha-numeric data from a unidata datafile using
SELECT when the case of the text is not known?
I have tried things like:
SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...'
Greg,
Actually the following in saver:
SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE 'SC'...
(note the extra ' around the text) there are a few alphanumeric characters
that are interpreted by SELECT and it will show you weird results when you
are not expecting that.
Regards,
Andre
19 matches
Mail list logo