[U2] Printers
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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: maandag 30 april 2007 11:12 To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes 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 evaluate using the "u" parser. > >-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.u2ug.org >Subject: [U2] unibasic select woes > >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 this >type of search? > >Any help is greatly appreciated! > >Thank you, >Greg >--- >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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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...' ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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 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 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes 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. > > > >-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.u2ug.org >Subject: [U2] unibasic select woes > >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 this >type of search? > >Any help is greatly appreciated! > >Thank you, >Greg >--- >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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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 evaluate using the "u" parser. -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.u2ug.org Subject: [U2] unibasic select woes 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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 used to facilitate this type of search? One solution is to add another dictionary item and uppercase it through the conversion field of the dictionary item. One of the great strengths (and weaknesses) of U2 is that you can have multiple dictionary items defining the same data field. Which sometimes makes it difficult to figure out what the data is supposed to look like, but if organized properly lends itself to selecting and reporting. -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] unibasic select woes
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...' Martin Phillips, Ladybridge Systems Ltd --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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. -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.u2ug.org Subject: [U2] unibasic select woes 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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 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 this > type of search? > > Any help is greatly appreciated! > > Thank you, > Greg --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Jeff Schasny - Denver, Co, USA jschasnyATgmailDOTcom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unibasic select woes
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.u2ug.org Subject: [U2] unibasic select woes 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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: Wednesday, May 30, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] unibasic select woes 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 this type of search? Any help is greatly appreciated! Thank you, Greg --- 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] unibasic select woes
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 this type of search? Any help is greatly appreciated! Thank you, Greg --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RedBack Garbage Collection
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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RedBack Garbage Collection
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 Garbage Collection 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 looks like collection hasn't happened since February when there was a power failure.. despite RedBack being restarted since. Parameters in WWCONTROL GARBAGE.COLLECT are fine. Thanks Brian --- 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] RedBack Garbage Collection
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 calculate "time since last run". That might well not be the problem here, but hey, it's an idea to investigate... Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RedBack Garbage Collection
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 run". That might well not be the problem here, but hey, it's an idea to investigate... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 30 May 2007 12:14 To: u2-users@listserver.u2ug.org Subject: [U2] RedBack Garbage Collection 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 looks like collection hasn't happened since February when there was a power failure.. despite RedBack being restarted since. Parameters in WWCONTROL GARBAGE.COLLECT are fine. Thanks Brian --- 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] RedBack Garbage Collection
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 looks like collection hasn't happened since February when there was a power failure.. despite RedBack being restarted since. Parameters in WWCONTROL GARBAGE.COLLECT are fine. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [BB] U2 Enhancement Request - WRITE
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 less informative that > what the system would have done without the ON ERROR > clause being present. The ON ERROR clause should only be used if you need to stay alive and take some recovery action. I'd agree that it is mostly useless if you don't implement an entire strategy to deal with exception handling. Be it I/O exceptions and/or business rule exceptions. Dropping to TCL is one strategy, but it's the year 2007 now...that may of cut in the 1980's, but not any more. ;-) I've seen to many applications that merrying continue on their way, assuming everything is okay. Ignorance is not bliss in critical business applications. I've seen lots of applications with initialisation sections loading critical static data or performing checks that may merely print "error" message or much more common - set variables to empty strings and then carry on! This is extremely common "feature". Of course, 99.98% of the time it's ok...it's not okay when you have to find the problem, of course. I'd recommend an "all or nothing" approach to ON ERROR. And you have to do something graceful to "undo" the transaction. Which where transaction logging may and can help - again - if use correctly and implemented correctly. All of which takes an awful lot of time to retrofit into an existing application (hence, never gets done)... Otherwise, you're kind of wasting your time. Regards, David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/