5:10 PM
To: u2-users@listserver.u2ug.org
Subject: 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
cha
You can use EVAL in your select to do what you want for the MCU ...
+---
---+
|
|
| EVAL
|
|
|
| _
|
|
|
|
|
|Use in any RetrieVe sentence to introduce
Maybe that works in Universe, but it doesn't in UniData
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart
Sent: Wednesday, May 30, 2007 7:59 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] unibasic select woes
SELECT HRPER
lts 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
Dav
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...'
essage-
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
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
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
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
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...'
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 w
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 selec
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
: 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.
ilto:[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
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
16 matches
Mail list logo