ca.portal.admin

Lower-case in OCF

Discussion created by ca.portal.admin on Nov 21, 2006
When I enter an SQL command that contains lower-case characters
(example: WHERE LAST_NAME =3D 'Smith'), OCF converts the lower-case
characters to upper-case, and the query fails. BCF does not do this.

I have tried 'DCUF SET UPLOW', and also setting the case in a user
profile, but it has no effect on OCF. Has anyone else had this problem?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Lower-case in OCF
"Kay,

First set In CICS :
CECI SET TERMINAL(terminalname) NOUCTRAN
In IDMS :
DCUF SET UPLOW

Luc De Naeyer
Corporate System Database Administrator for IDMS
Infoco (InformaticsColruyt)
T : +32 2 360 10 40
----- Original Message -----
From: ""Cates, Joe"" <Joe_Cates@MCPSMD.ORG>
To: <IDMS-L@listserv.iuassn.com>
Sent: dinsdag 21 november 2006 15:33
Subject: Re: Lower-case in OCF

Kay,

My OCF session doesn't do that to me. Until you get a definitive answer
to that problem have you considered WHERE upper(LAST_NAME) = 'SMITH' ?

Joe S Cates, Database Analyst II
Information and Organizational Systems
Database Management/Unix Administration
Montgomery County Public Schools
Rockville, MD 20850
joe_cates@mcpsmd.org



-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Rozeboom, Kay [DAS]
Sent: Tuesday, November 21, 2006 9:16 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Lower-case in OCF

When I enter an SQL command that contains lower-case characters
(example: WHERE LAST_NAME = 'Smith'), OCF converts the lower-case
characters to upper-case, and the query fails. BCF does not do this.

I have tried 'DCUF SET UPLOW', and also setting the case in a user
profile, but it has no effect on OCF. Has anyone else had this problem?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Lower-case in OCF
"Dan, you are right! When I go in through CICS, the DCUF SET CASE
UPPER/UPLOW command has no effect. But when I go in through TSO, it
works.

Thanks for pointing this out. I never would have figured it out on my
own.

Outcomes