ca.portal.admin

Re: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 = '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,

In the #UCFCICS macro : set UCTRAN=TCT .
(Default = NO : &UCTRAN=NO, DON'T ALLOW UPPER-CASE TRANSLATION )

Luc


Luc De Naeyer
Corporate System Database Administrator for IDMS
Infoco (InformaticsColruyt)
T : +32 2 360 10 40
----- Original Message -----
From: ""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To: <IDMS-L@listserv.iuassn.com>
Sent: dinsdag 21 november 2006 15:44
Subject: 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.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Hall, Dan (GE Comm Fin)
Sent: Tuesday, November 21, 2006 8:26 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Re: Lower-case in OCF

Kay,
Are you getting into the CV via CICS or a direct connect to IDMS via
VTAM? In both of them there is a parm in the terminal definition that
will force all characters into upper case.

Although I don't remember the exact syntax, I know in CICS you can issue
a CEMT S TERM(your_termid) ?something? to set the terminal to mixed
case.

In IDMS you can use the DCUF SET CASE UPPER/UPLOW command. I am not sure
if the IDMS command over-rides the CICS setting.

Hope this helps.


Dan Hall
GE
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/


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

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: CALL IDMSCOMP BEFORE FINISH
"First some context.

The work areas will be released by the end-of-task processing, so there
are only a few very specific circumstances where this matters.

For external run-units, the FINISH will cause (internal) task
termination, and therefore cleanup, therefore no issue.

For truly interactive online tasks, same thing.

It is only for those long-running DC tasks and local mode programs which
go through repeated BIND RU/FINISH sequences where the work areas start
to pile up.

Having said that, in looking at the IDMSCOMP/IDMSDCOM source it appears
they are doing two #GETSTGs.

One is for a work area of 32 bytes (plus storage housekeeping overhead
of another 12 bytes or so).

The second is for an area equal to largest record size in the subschema
+ 8 bytes (plus housekeeping).

Add an RLE and an RCE for each chunk of stg acquired.

Don Casey
APL Limited

Outcomes