ca.portal.admin

Re:SQL question

Discussion created by ca.portal.admin on Nov 21, 2006
Hi everyone,

I'm looking for some help with SQL and a BOM set. Let's say we have
records A and B, with sets EXPLOSION and IMPLOSION. We need to get the
dbkey of the owner record of the EXPLOSION set, along with the dbkey of
the owner record of the IMPLOSION set, along with the dbkey of B.

Any suggestions are greatly appreciated, Thank you, Laura Rochon Ajilon
Consulting
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
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: Mulitasking & DC-COBOL Programs
"Paul,

Our non Multitasking system we have our DC-COBOL as MPMODE SYSTEM.
Should we change to ANY?

Thanks

Chris Wood
Alberta Department of Energy
CANADA

Outcomes