[U2] Printers

2007-05-30 Thread Anthony Caufield
I need to setup printers on a redhat linux box. I have copied setup the .drv file but I don't know what or how to setup the null device for the printer. I am going off of how printers are currently setup on this box. Sorry forgot unix/linux been using windows where this is easy. Thanks Tony --

RE: [U2] unibasic select woes

2007-05-30 Thread Andre Meij
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

RE: [U2] unibasic select woes

2007-05-30 Thread Boydell, Stuart
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...'

RE: [U2] unibasic select woes

2007-05-30 Thread Bruce McAdoo
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 PRO

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
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

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
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 t

Re: [U2] unibasic select woes

2007-05-30 Thread Allen Egerton
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 be

Re: [U2] unibasic select woes

2007-05-30 Thread Martin Phillips
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...'

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
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. -

RE: [U2] unibasic select woes

2007-05-30 Thread Buffington, Wyatt
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

Re: [U2] unibasic select woes

2007-05-30 Thread Jeff Schasny
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 dataf

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
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: u2-users@listserver

RE: [U2] unibasic select woes

2007-05-30 Thread Dave Davis
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 S

[U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
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 thi

Re: [U2] RedBack Garbage Collection

2007-05-30 Thread Andy Pflueger
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 ---

RE: [U2] RedBack Garbage Collection

2007-05-30 Thread daverch
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 Garbag

RE: [U2] RedBack Garbage Collection

2007-05-30 Thread brian
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 calcula

RE: [U2] RedBack Garbage Collection

2007-05-30 Thread Anthony Youngman
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

[U2] RedBack Garbage Collection

2007-05-30 Thread brian
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 l

RE: [U2] [BB] U2 Enhancement Request - WRITE

2007-05-30 Thread Hona, David S
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 significantl