View previous topic :: View next topic
|
Author |
Message |
gcchowdary Warnings : 1 New User
Joined: 26 Dec 2005 Posts: 18 Location: India
|
|
|
|
Hi,
I want to know how to INSERT UPPER case data into a DB2 table....
I mean , while trying to insert records using INSERT function, I want data/fields should load a UPPER case.. Please let me know
Thank You,
G C Chowdary |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
I usually INSPECT CONVERTING before INSERTing. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
...or use intrinsic function UPPER-CASE. |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
You can even use UPPER(:Host-VAR) in the insert statement. |
|
Back to top |
|
|
gcchowdary Warnings : 1 New User
Joined: 26 Dec 2005 Posts: 18 Location: India
|
|
|
|
I am INSERTing data into the Db2 table thru the Host variables as below
EXEC SQL
INSERT INTO BENEFIT
(PLAN_CODE,
BM_STATE_CODE)
VALUES
(:Host Var1,
:Host Var2)
END-EXEC
Where can we use UPPER-CASE in this query....Please let me know
I will try Dick's Idea ... |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
You can use like this.
EXEC SQL
INSERT INTO BENEFIT
(PLAN_CODE,
BM_STATE_CODE)
VALUES
(UPPER(:Host Var1),
UPPER(:Host Var2))
END-EXEC |
|
Back to top |
|
|
|