Prev: dealing with invalid date
Next: Aligning rows horisontaly (again)
From: Lennart on 16 Oct 2009 01:51
On 15 Okt, 11:41, Tonkuma <tonk...(a)fiberbit.net> wrote:
> DB2 9.7 for Linux, UNIX, and Windows supports INITCAP function.

Tonkuma, I can't seem to find the docs for this function. Can you
provide a link to it?


/Lennart
From: Tonkuma on 16 Oct 2009 02:22
On Oct 16, 2:51 pm, Lennart <erik.lennart.jons...(a)gmail.com> wrote:
> On 15 Okt, 11:41, Tonkuma <tonk...(a)fiberbit.net> wrote:
>
> > DB2 9.7 for Linux, UNIX, and Windows supports INITCAP function.
>
> Tonkuma, I can't seem to find the docs for this function. Can you
> provide a link to it?
>
> /Lennart
You can find it by serching "INITCAP" in "IBM DB2 9.7 for Linux, UNIX,
and Windows Information Center": http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

From: Will Honea on 16 Oct 2009 02:40
Tonkuma wrote:

> On Oct 16, 5:09 am, Will Honea <who...(a)yahoo.com> wrote:
>> The database is on 9.5 at the moment but I have a new server in build
>> with 9.7 so that should provide the function for a quick and dirty.
> If you are not on DB2 9.7 for LUW,
> you can use INITCAP UDF in Sample UDFs for Migration:
>
http://www.ibm.com/developerworks/data/library/samples/db2/0205udfs/index.html

Again, Thank you. I was going to ask how you found this - but then I
noticed the author. Now I can get on with things without mucking around
migrating things back and forth (the new server is a tad flaky right now)
but I still need to update things around here.

BTW, INITCAP is documented in the 9.7 Info Center - once you find the
appropriate section.

--
Will Honea

From: Will Honea on 16 Oct 2009 02:44
jefftyzzer wrote:

> If you don't have 9.7, is the two-step process of stripping-out non [A-
> Z] (and space) characters and then shifting everything to uppercase
> more than you want to do?

Yep, since the 9.7 INITCAP() function does exactly what I want with no
hassle.

--
Will Honea

From: Henrik Loeser on 16 Oct 2009 03:34
On Oct 16, 8:22 am, Tonkuma <tonk...(a)fiberbit.net> wrote:
> On Oct 16, 2:51 pm, Lennart <erik.lennart.jons...(a)gmail.com> wrote:> On 15 Okt, 11:41, Tonkuma <tonk...(a)fiberbit.net> wrote:
>
> > > DB2 9.7 for Linux, UNIX, and Windows supports INITCAP function.
>
> > Tonkuma, I can't seem to find the docs for this function. Can you
> > provide a link to it?
>
> > /Lennart
>
> You can find it by serching "INITCAP" in "IBM DB2 9.7 for Linux, UNIX,
> and Windows Information Center":http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

The direct link is here:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0053527.html

Henrik
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: dealing with invalid date
Next: Aligning rows horisontaly (again)