By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,180 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,180 IT Pros & Developers. It's quick & easy.

storing in mixed case

P: n/a
I have a table with data stored on upper case. I would like to change
it proper mixed case. For example : change data from , THIS IS A TEST
to This is a test or
This Is A Test.
Is there any easy way to do this.

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
create table testchar (col1 char(20));

insert into testchar values ('THIS IS A TEST');

select substr(col1,1,1) concat lcase(substr(col1,2,19))
as col1 from testchar;

COL1
--------------------
This is a test

1 record(s) selected.
Wonderinguy wrote:
I have a table with data stored on upper case. I would like to change
it proper mixed case. For example : change data from , THIS IS A TEST
to This is a test or
This Is A Test.
Is there any easy way to do this.

Thanks


Nov 12 '05 #2

P: n/a
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote:
create table testchar (col1 char(20));

insert into testchar values ('THIS IS A TEST');

select substr(col1,1,1) concat lcase(substr(col1,2,19))
as col1 from testchar;

COL1
--------------------
This is a test


If you want to do more fancy things like "This is a Test", then you might be
better off with a user-definde function (UDF), possibly implemented in
Java.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #3

P: n/a
Can anybody show me a UDF that do what Knut is saying ? Any input will be great.

Thanks
Knut Stolze <st****@de.ibm.com> wrote in message news:<bu**********@fsuj29.rz.uni-jena.de>...
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote:
create table testchar (col1 char(20));

insert into testchar values ('THIS IS A TEST');

select substr(col1,1,1) concat lcase(substr(col1,2,19))
as col1 from testchar;

COL1
--------------------
This is a test


If you want to do more fancy things like "This is a Test", then you might be
better off with a user-definde function (UDF), possibly implemented in
Java.

Nov 12 '05 #4

P: n/a
Wonderinguy <wo*********@hotmail.com> wrote:
Can anybody show me a UDF that do what Knut is saying ? Any input will be
great.


This function is not that fancy and just capitalizes every word:
-----------------------------------------------------------
/** Capitalize all words in a string.
*
* The whole string is converted to lower case, except the first characters
* of every word. The criteria to decide whether we have a new word is the
* character preceding the word. If that character is not a letter or
* digit, then we start with a new word and capitalize the next character.
*
* To register the UDF if your database, use the following SQL statement:

CREATE FUNCTION capitalizeString(str VARCHAR(4000))
RETURNS VARCHAR(4000)
SPECIFIC capitalizeStr
EXTERNAL NAME 'TextConv.capitalizeString'
LANGUAGE JAVA
PARAMETER STYLE JAVA
DETERMINISTIC
FENCED
RETURNS NULL ON NULL INPUT
NO SQL
NO EXTERNAL ACTION
NO SCRATCHPAD
NO FINAL CALL
ALLOW PARALLEL
NO DBINFO

* @param input String to be converted
* @return capitalized string
*/
public class TextConv
{
public static String capitalizeString(String input)
throws Exception
{
String output = "";
boolean prevCharIsWhitespace = true;

// iterate over all the characters in the string
for (int i = 0; i < input.length(); i++) {
char c = input.charAt(i);
// convert character to upper case if a new word starts
if (prevCharIsWhitespace) {
output += Character.toUpperCase(c);
}
else {
output += Character.toLowerCase(c);
}
// remember if we are in a word or not
prevCharIsWhitespace = !Character.isLetterOrDigit(c);
}
return output;
}
}
-----------------------------------------------------------
db2 "VALUES capitalizeString('THIS IS A TEST')

1
------------------------------
This Is A Test
If you want to handle each word differently, depending on some
characteristics (like noun or verb), then you need some more logic, of
course.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #5

P: n/a
"Wonderinguy" <wo*********@hotmail.com> wrote in message
news:69*************************@posting.google.co m...
Can anybody show me a UDF that do what Knut is saying ? Any input will be great.
Thanks

Here is a plan SQL UDF

in file UDF.sql:

CREATE FUNCTION Mixed_Case (X VARCHAR(20))
RETURNS VARCHAR(20)
LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
BEGIN ATOMIC
DECLARE i INTEGER;
DECLARE l INTEGER;
DECLARE c VARCHAR(20);
DECLARE p CHAR(2);
SET l = LENGTH(RTRIM(X));
SET i = 2;
SET c = UPPER(SUBSTR(X,1,1));
SET p = c;
main_loop:
WHILE i <= l
DO
IF p=' '
THEN
SET c = c || UPPER(SUBSTR(X,i,1));
ELSE
SET c = c || LOWER(SUBSTR(X,i,1));
END IF;
set p = SUBSTR(X,i,1);
set i = i + 1;
END WHILE main_loop;
RETURN c;
END
@
db2 -td@ -f udf.sql
DB20000I The SQL command completed successfully.
db2 values mixed_case('THIS IS A TEST')

1
--------------------
This Is A Test

1 record(s) selected.
Regards
Paul Vernon
Business Intelligence, IBM Global Services
Nov 12 '05 #6

P: n/a
Hi Paul, I tried your UDF on my DB2 7.1 on Z/os. I does like the
ATOMIC. I believe the LANGUAGE SQL is not valid in Z/os. Is there any
other way I can do
this on DB2 on Mainframe ?

THanks
"Paul Vernon" <pa*********@ukk.ibmm.comm> wrote in message news:<bu***********@gazette.almaden.ibm.com>...
"Wonderinguy" <wo*********@hotmail.com> wrote in message
news:69*************************@posting.google.co m...
Can anybody show me a UDF that do what Knut is saying ? Any input will be

great.

Thanks

Here is a plan SQL UDF

in file UDF.sql:

CREATE FUNCTION Mixed_Case (X VARCHAR(20))
RETURNS VARCHAR(20)
LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
BEGIN ATOMIC
DECLARE i INTEGER;
DECLARE l INTEGER;
DECLARE c VARCHAR(20);
DECLARE p CHAR(2);
SET l = LENGTH(RTRIM(X));
SET i = 2;
SET c = UPPER(SUBSTR(X,1,1));
SET p = c;
main_loop:
WHILE i <= l
DO
IF p=' '
THEN
SET c = c || UPPER(SUBSTR(X,i,1));
ELSE
SET c = c || LOWER(SUBSTR(X,i,1));
END IF;
set p = SUBSTR(X,i,1);
set i = i + 1;
END WHILE main_loop;
RETURN c;
END
@
db2 -td@ -f udf.sql
DB20000I The SQL command completed successfully.
db2 values mixed_case('THIS IS A TEST')

1
--------------------
This Is A Test

1 record(s) selected.
Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #7

P: n/a
I had written a COBOL (no sql) to do the Mix case. I compiled and link
edited the COBOL program . Here are a few line from my compile and
link edit :

//PREDB2 EXEC PGM=DSNHPC,REGION=0M,COND=(8,LE,PAN1),
// PARM=('HOST(IBMCOB)',APOST,APOSTSQL,NOSOURCE,
// NOXREF,'SQL(DB2)','DEC(31)','VERSION(AUTO)')

.....
....
//LKED EXEC PGM=IEWL,
// COND=((8,LE,COMP),(8,LE,PLKED)),
//* PARM='MAP'
// PARM='LIST,LET,MAP,RMODE=ANY,AMODE=31'
//SYSLIB DD DISP=SHR,DSN=SYS1.SCEELKED
// DD DISP=SHR,DSN=SYS5.DSN710.DB2X.SDSNLOAD
//SYSLIN DD DSN=&&PLKSET,DISP=(OLD,DELETE)
// DD DDNAME=SYSIN
//SYSLMOD DD DSN=ROGER.PRIVATE.LOADLIB(CNVTSTR),DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD SPACE=(32000,(30,30)),UNIT=SYSDA
//SYSIN DD *
INCLUDE SYSLIB(DSNRLI)
NAME CNVTSTR(R)
/*

Once I compiled and linked edited it. I created the function :

CREATE FUNCTION ROGER.MIXCASES
(CHAR(60))
RETURNS CHAR(60)
EXTERNAL NAME 'CNVTSTR'
PARAMETER STYLE DB2SQL
WLM ENVIRONMENT DB2XWLM
LANGUAGE COBOL
NOT DETERMINISTIC
NO SQL
NO DBINFO
NO EXTERNAL ACTION;

When I try to execute the Function :

select roger.mixcases('this is a test') from sysibm.sysdummy1;

I get SQL -440

I can't seem to figure out why . The loadlib ROGER.PRIVATE.LOADLIB is
part of the DB2XSPAS and DB2XWLM started tasks.

Could anybody please help me out ? Also is there any books or website
which could give me more about coding UDFs.

Thanks


wo*********@hotmail.com (Wonderinguy) wrote in message news:<69*************************@posting.google.c om>...
Hi Paul, I tried your UDF on my DB2 7.1 on Z/os. I does like the
ATOMIC. I believe the LANGUAGE SQL is not valid in Z/os. Is there any
other way I can do
this on DB2 on Mainframe ?

THanks
"Paul Vernon" <pa*********@ukk.ibmm.comm> wrote in message news:<bu***********@gazette.almaden.ibm.com>...
"Wonderinguy" <wo*********@hotmail.com> wrote in message
news:69*************************@posting.google.co m...
Can anybody show me a UDF that do what Knut is saying ? Any input will be great.
Thanks

Here is a plan SQL UDF

in file UDF.sql:

CREATE FUNCTION Mixed_Case (X VARCHAR(20))
RETURNS VARCHAR(20)
LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
BEGIN ATOMIC
DECLARE i INTEGER;
DECLARE l INTEGER;
DECLARE c VARCHAR(20);
DECLARE p CHAR(2);
SET l = LENGTH(RTRIM(X));
SET i = 2;
SET c = UPPER(SUBSTR(X,1,1));
SET p = c;
main_loop:
WHILE i <= l
DO
IF p=' '
THEN
SET c = c || UPPER(SUBSTR(X,i,1));
ELSE
SET c = c || LOWER(SUBSTR(X,i,1));
END IF;
set p = SUBSTR(X,i,1);
set i = i + 1;
END WHILE main_loop;
RETURN c;
END
@
db2 -td@ -f udf.sql
DB20000I The SQL command completed successfully.
db2 values mixed_case('THIS IS A TEST')

1
--------------------
This Is A Test

1 record(s) selected.
Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #8

P: n/a
You may need to refresh the load module.
(just like in cics when you do a program new copy)

see
4.2.10.4.2 Refreshing the environment for stored procedures or user-defined
functions
http://publib.boulder.ibm.com/cgi-bi...STHIT#FIRSTHIT

PM
"Wonderinguy" <wo*********@hotmail.com> a écrit dans le message de
news:69*************************@posting.google.co m...
I had written a COBOL (no sql) to do the Mix case. I compiled and link
edited the COBOL program . Here are a few line from my compile and
link edit :

//PREDB2 EXEC PGM=DSNHPC,REGION=0M,COND=(8,LE,PAN1),
// PARM=('HOST(IBMCOB)',APOST,APOSTSQL,NOSOURCE,
// NOXREF,'SQL(DB2)','DEC(31)','VERSION(AUTO)')

....
...
//LKED EXEC PGM=IEWL,
// COND=((8,LE,COMP),(8,LE,PLKED)),
//* PARM='MAP'
// PARM='LIST,LET,MAP,RMODE=ANY,AMODE=31'
//SYSLIB DD DISP=SHR,DSN=SYS1.SCEELKED
// DD DISP=SHR,DSN=SYS5.DSN710.DB2X.SDSNLOAD
//SYSLIN DD DSN=&&PLKSET,DISP=(OLD,DELETE)
// DD DDNAME=SYSIN
//SYSLMOD DD DSN=ROGER.PRIVATE.LOADLIB(CNVTSTR),DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD SPACE=(32000,(30,30)),UNIT=SYSDA
//SYSIN DD *
INCLUDE SYSLIB(DSNRLI)
NAME CNVTSTR(R)
/*

Once I compiled and linked edited it. I created the function :

CREATE FUNCTION ROGER.MIXCASES
(CHAR(60))
RETURNS CHAR(60)
EXTERNAL NAME 'CNVTSTR'
PARAMETER STYLE DB2SQL
WLM ENVIRONMENT DB2XWLM
LANGUAGE COBOL
NOT DETERMINISTIC
NO SQL
NO DBINFO
NO EXTERNAL ACTION;

When I try to execute the Function :

select roger.mixcases('this is a test') from sysibm.sysdummy1;

I get SQL -440

I can't seem to figure out why . The loadlib ROGER.PRIVATE.LOADLIB is
part of the DB2XSPAS and DB2XWLM started tasks.

Could anybody please help me out ? Also is there any books or website
which could give me more about coding UDFs.

Thanks


wo*********@hotmail.com (Wonderinguy) wrote in message

news:<69*************************@posting.google.c om>...
Hi Paul, I tried your UDF on my DB2 7.1 on Z/os. I does like the
ATOMIC. I believe the LANGUAGE SQL is not valid in Z/os. Is there any
other way I can do
this on DB2 on Mainframe ?

THanks
"Paul Vernon" <pa*********@ukk.ibmm.comm> wrote in message news:<bu***********@gazette.almaden.ibm.com>...
"Wonderinguy" <wo*********@hotmail.com> wrote in message
news:69*************************@posting.google.co m...
> Can anybody show me a UDF that do what Knut is saying ? Any input
will be great.
>
> Thanks
>
Here is a plan SQL UDF

in file UDF.sql:

CREATE FUNCTION Mixed_Case (X VARCHAR(20))
RETURNS VARCHAR(20)
LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
BEGIN ATOMIC
DECLARE i INTEGER;
DECLARE l INTEGER;
DECLARE c VARCHAR(20);
DECLARE p CHAR(2);
SET l = LENGTH(RTRIM(X));
SET i = 2;
SET c = UPPER(SUBSTR(X,1,1));
SET p = c;
main_loop:
WHILE i <= l
DO
IF p=' '
THEN
SET c = c || UPPER(SUBSTR(X,i,1));
ELSE
SET c = c || LOWER(SUBSTR(X,i,1));
END IF;
set p = SUBSTR(X,i,1);
set i = i + 1;
END WHILE main_loop;
RETURN c;
END
@
db2 -td@ -f udf.sql
DB20000I The SQL command completed successfully.
db2 values mixed_case('THIS IS A TEST')

1
--------------------
This Is A Test

1 record(s) selected.
Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #9

P: n/a
I tried that too. But if i write a stored procedure instead of a
function, the program works great. I guess there is something wrong
with the create function statement.
Can a function call a stored procedure ?

"PM \(pm3iinc-nospam\)" <PM(pm3iinc-nospam)@sympatico.ca> wrote in message news:<ni********************@news20.bellglobal.com >...
You may need to refresh the load module.
(just like in cics when you do a program new copy)

see
4.2.10.4.2 Refreshing the environment for stored procedures or user-defined
functions
http://publib.boulder.ibm.com/cgi-bi...STHIT#FIRSTHIT

PM
"Wonderinguy" <wo*********@hotmail.com> a écrit dans le message de
news:69*************************@posting.google.co m...
I had written a COBOL (no sql) to do the Mix case. I compiled and link
edited the COBOL program . Here are a few line from my compile and
link edit :

//PREDB2 EXEC PGM=DSNHPC,REGION=0M,COND=(8,LE,PAN1),
// PARM=('HOST(IBMCOB)',APOST,APOSTSQL,NOSOURCE,
// NOXREF,'SQL(DB2)','DEC(31)','VERSION(AUTO)')

....
...
//LKED EXEC PGM=IEWL,
// COND=((8,LE,COMP),(8,LE,PLKED)),
//* PARM='MAP'
// PARM='LIST,LET,MAP,RMODE=ANY,AMODE=31'
//SYSLIB DD DISP=SHR,DSN=SYS1.SCEELKED
// DD DISP=SHR,DSN=SYS5.DSN710.DB2X.SDSNLOAD
//SYSLIN DD DSN=&&PLKSET,DISP=(OLD,DELETE)
// DD DDNAME=SYSIN
//SYSLMOD DD DSN=ROGER.PRIVATE.LOADLIB(CNVTSTR),DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD SPACE=(32000,(30,30)),UNIT=SYSDA
//SYSIN DD *
INCLUDE SYSLIB(DSNRLI)
NAME CNVTSTR(R)
/*

Once I compiled and linked edited it. I created the function :

CREATE FUNCTION ROGER.MIXCASES
(CHAR(60))
RETURNS CHAR(60)
EXTERNAL NAME 'CNVTSTR'
PARAMETER STYLE DB2SQL
WLM ENVIRONMENT DB2XWLM
LANGUAGE COBOL
NOT DETERMINISTIC
NO SQL
NO DBINFO
NO EXTERNAL ACTION;

When I try to execute the Function :

select roger.mixcases('this is a test') from sysibm.sysdummy1;

I get SQL -440

I can't seem to figure out why . The loadlib ROGER.PRIVATE.LOADLIB is
part of the DB2XSPAS and DB2XWLM started tasks.

Could anybody please help me out ? Also is there any books or website
which could give me more about coding UDFs.

Thanks


wo*********@hotmail.com (Wonderinguy) wrote in message

news:<69*************************@posting.google.c om>...
Hi Paul, I tried your UDF on my DB2 7.1 on Z/os. I does like the
ATOMIC. I believe the LANGUAGE SQL is not valid in Z/os. Is there any
other way I can do
this on DB2 on Mainframe ?

THanks
"Paul Vernon" <pa*********@ukk.ibmm.comm> wrote in message news:<bu***********@gazette.almaden.ibm.com>... > "Wonderinguy" <wo*********@hotmail.com> wrote in message
> news:69*************************@posting.google.co m...
> > Can anybody show me a UDF that do what Knut is saying ? Any input will be
great. > >
> > Thanks
> >
> Here is a plan SQL UDF
>
> in file UDF.sql:
>
> CREATE FUNCTION Mixed_Case (X VARCHAR(20))
> RETURNS VARCHAR(20)
> LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
> BEGIN ATOMIC
> DECLARE i INTEGER;
> DECLARE l INTEGER;
> DECLARE c VARCHAR(20);
> DECLARE p CHAR(2);
> SET l = LENGTH(RTRIM(X));
> SET i = 2;
> SET c = UPPER(SUBSTR(X,1,1));
> SET p = c;
> main_loop:
> WHILE i <= l
> DO
> IF p=' '
> THEN
> SET c = c || UPPER(SUBSTR(X,i,1));
> ELSE
> SET c = c || LOWER(SUBSTR(X,i,1));
> END IF;
> set p = SUBSTR(X,i,1);
> set i = i + 1;
> END WHILE main_loop;
> RETURN c;
> END
> @
>
>
> db2 -td@ -f udf.sql
> DB20000I The SQL command completed successfully.
>
>
> db2 values mixed_case('THIS IS A TEST')
>
> 1
> --------------------
> This Is A Test
>
> 1 record(s) selected.
>
>
> Regards
> Paul Vernon
> Business Intelligence, IBM Global Services

Nov 12 '05 #10

P: n/a
I guess you verified all the obvious ones listed in the -440.

I'd try with the cast('this is a test' as char(60)).
If it's the problem, recode the udf using varchar. (generally, sp's and
udf's are coded with varchar() parms)
constants are varchar. db2 may not find a udf with varchar as a parameter
even though
it's compatible with char.
Ref. links if you need them.
base v7 doc
http://www-306.ibm.com/software/data...0/v7books.html

5.26 CREATE FUNCTION (external scalar)
http://publib.boulder.ibm.com/cgi-bi...STHIT#FIRSTHIT

PM

"Wonderinguy" <wo*********@hotmail.com> a écrit dans le message de
news:69*************************@posting.google.co m...
I had written a COBOL (no sql) to do the Mix case. I compiled and link
edited the COBOL program . Here are a few line from my compile and
link edit :

//PREDB2 EXEC PGM=DSNHPC,REGION=0M,COND=(8,LE,PAN1),
// PARM=('HOST(IBMCOB)',APOST,APOSTSQL,NOSOURCE,
// NOXREF,'SQL(DB2)','DEC(31)','VERSION(AUTO)')

....
...
//LKED EXEC PGM=IEWL,
// COND=((8,LE,COMP),(8,LE,PLKED)),
//* PARM='MAP'
// PARM='LIST,LET,MAP,RMODE=ANY,AMODE=31'
//SYSLIB DD DISP=SHR,DSN=SYS1.SCEELKED
// DD DISP=SHR,DSN=SYS5.DSN710.DB2X.SDSNLOAD
//SYSLIN DD DSN=&&PLKSET,DISP=(OLD,DELETE)
// DD DDNAME=SYSIN
//SYSLMOD DD DSN=ROGER.PRIVATE.LOADLIB(CNVTSTR),DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD SPACE=(32000,(30,30)),UNIT=SYSDA
//SYSIN DD *
INCLUDE SYSLIB(DSNRLI)
NAME CNVTSTR(R)
/*

Once I compiled and linked edited it. I created the function :

CREATE FUNCTION ROGER.MIXCASES
(CHAR(60))
RETURNS CHAR(60)
EXTERNAL NAME 'CNVTSTR'
PARAMETER STYLE DB2SQL
WLM ENVIRONMENT DB2XWLM
LANGUAGE COBOL
NOT DETERMINISTIC
NO SQL
NO DBINFO
NO EXTERNAL ACTION;

When I try to execute the Function :

select roger.mixcases('this is a test') from sysibm.sysdummy1;

I get SQL -440

I can't seem to figure out why . The loadlib ROGER.PRIVATE.LOADLIB is
part of the DB2XSPAS and DB2XWLM started tasks.

Could anybody please help me out ? Also is there any books or website
which could give me more about coding UDFs.

Thanks


wo*********@hotmail.com (Wonderinguy) wrote in message

news:<69*************************@posting.google.c om>...
Hi Paul, I tried your UDF on my DB2 7.1 on Z/os. I does like the
ATOMIC. I believe the LANGUAGE SQL is not valid in Z/os. Is there any
other way I can do
this on DB2 on Mainframe ?

THanks
"Paul Vernon" <pa*********@ukk.ibmm.comm> wrote in message news:<bu***********@gazette.almaden.ibm.com>...
"Wonderinguy" <wo*********@hotmail.com> wrote in message
news:69*************************@posting.google.co m...
> Can anybody show me a UDF that do what Knut is saying ? Any input
will be great.
>
> Thanks
>
Here is a plan SQL UDF

in file UDF.sql:

CREATE FUNCTION Mixed_Case (X VARCHAR(20))
RETURNS VARCHAR(20)
LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC
BEGIN ATOMIC
DECLARE i INTEGER;
DECLARE l INTEGER;
DECLARE c VARCHAR(20);
DECLARE p CHAR(2);
SET l = LENGTH(RTRIM(X));
SET i = 2;
SET c = UPPER(SUBSTR(X,1,1));
SET p = c;
main_loop:
WHILE i <= l
DO
IF p=' '
THEN
SET c = c || UPPER(SUBSTR(X,i,1));
ELSE
SET c = c || LOWER(SUBSTR(X,i,1));
END IF;
set p = SUBSTR(X,i,1);
set i = i + 1;
END WHILE main_loop;
RETURN c;
END
@
db2 -td@ -f udf.sql
DB20000I The SQL command completed successfully.
db2 values mixed_case('THIS IS A TEST')

1
--------------------
This Is A Test

1 record(s) selected.
Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.