ca.portal.admin

OLQ question

Discussion created by ca.portal.admin on Nov 29, 2006
Latest reply on Dec 5, 2006 by ca.portal.admin
EnvironmSent: IDMS R15.0 SP2 (genlevel 200203) with a few PTFs applied
when we installed in the summer of 2002, running under z/OS 1.4

The following syntax, at the tail end of a SELECT statement, works:

. . . AND <date-field-name> BETWEEN '20061122' AND '20061128')

but the following gives me errors:

. . . AND <date-field-name> BETWEEN DATEOFF(TODAY('G'),-7) AND
DATEOFF(TODAY('G'),-1))

I'm sure I must be missing something that's staring me in the face . . .
but I'm damned if I can figure out what it is.

But it gets better: the messages are different in online and batch
runs.

Here's the error message I get online, immediately after the SELECT
syntax is displayed:

OLQ 091047 08 Command syntax is invalid at token # 102 value=
DELIMITER TOKEN

and no more syntax is displayed.

In batch, I really don't get any error message in the true sense of the
word; it just terminates the session with RC=8 after regurgitating the
select syntax (but not the rest of the qfile) on SYSLST:

OLQ 100029 00 Signoff accepted - OLQ session terminated.

Anybody got any ideas?

TIA

PELLERIN MILNOR CORPORATION
Michel J Champagne
Systems Analyst / DBA

Voice: 504-712-7589
FAX: 504-712-3589

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
OLQ question
"EnvironmSent: IDMS R15.0 SP2 (genlevel 200203) with a few PTFs applied
when we installed in the summer of 2002, running under z/OS 1.4

The following syntax, at the tail end of a SELECT statement, works:

. . . AND <date-field-name> BETWEEN '20061122' AND '20061128')

but the following gives me errors:

. . . AND <date-field-name> BETWEEN DATEOFF(TODAY('G'),-7) AND
DATEOFF(TODAY('G'),-1))

I'm sure I must be missing something that's staring me in the face . . .
but I'm damned if I can figure out what it is.

But it gets better: the messages are different in online and batch
runs.

Here's the error message I get online, immediately after the SELECT
syntax is displayed:

OLQ 091047 08 Command syntax is invalid at token # 102 value=
DELIMITER TOKEN

and no more syntax is displayed.

In batch, I really don't get any error message in the true sense of the
word; it just terminates the session with RC=8 after regurgitating the
select syntax (but not the rest of the qfile) on SYSLST:

OLQ 100029 00 Signoff accepted - OLQ session terminated.

Anybody got any ideas?

TIA

PELLERIN MILNOR CORPORATION
Michel J Champagne
Systems Analyst / DBA

Voice: 504-712-7589
FAX: 504-712-3589

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: OLQ question
"Sorry, that was a typo on my part. I didn't cut-and-paste because I had
reverted to the 'hard-coded' dates in my testing by the time I wrote the
email.

The failing line should read "". . . AND <date-field-name> BETWEEN
DATEOFF(TODAYX('G'),-7) AND DATEOFF(TODAYX('G'),-1))"".

While TODAYX (and many other such ""X-functions"") are mentioned in the
OLQ documentation that I have, there is no mention of DATEOFFX or
DATEDIFX, but I tried them and got the same error in both the online and
batch environments.

Hmmmmm - if there is no such function, it seems like the error would be
different. So, just for the fun of it, I changed the line to read "". .
. AND <date-field-name> BETWEEN ABCDEFGH(TODAYX('G'),-7) AND
ABCDEFGH(TODAYX('G'),-1))"" and I GOT THE SAME ERRORS!

What this tells me is that the problem is in the command parser before
any syntax checking is being done.

Anyone else have any ideas? I think this might be one for the good
folks at C-A to take a look at . . .

------------------------------

Date: Wed, 29 Nov 2006 19:22:30 -0500
From: Cynthia Kline <cakask@AOL.COM>
Subject: Re: OLQ question

This is a wild guess since I am not at a shop with IDMS right now, so I
don;t have my quick references or access to test it. . .

But if you are checking for 8 digit dates, Shouldnt the functions be
DATEOFFX (I thought the functions without the X at the end were for the
two digit years).
(I don't recall about TODAY - whether there is a TODAYX.)

HTH
Cindy Kline

Outcomes