ca.portal.admin

OLQ Select index set

Discussion created by ca.portal.admin on Aug 20, 2010
Latest reply on Aug 20, 2010 by ca.portal.admin
Consider the situation:

Recordname : FSPR-VAFVAST
System-owned index : S-9999-783

Using OLQ I want to have the recordoccurrence of FSPR-VAFVAST where (VAF-=
RNR =3D 210002735)
Using GET statement it's quite simple:

GET FIR FSPR-VAFVAST WITHIN S-9999-783 WHERE SORT =3D 210002735


When I use the equivalent SQL statement :

SELECT * FROM FSPR-VAFVAST WHERE S-9999-783 AND VAF-RNR =3D 210002735

I get the errormessage:
OLQ 143005 08 Boolean conjunction (AND/OR/NOT) has non-bit operand.

Is the syntax incorrect or is it impossible to use index sets?


Schema definition of S-9999-783 is :

DIS SET S-9999-783
*+   ADD
*+   SET NAME IS S-9999-783
*+       ORDER IS SORTED
*+       MODE IS INDEX USING SIN-9999-783
*+       OWNER IS SYSTEM
*+           WITHIN AREA VAF-INDEX SUBAREA SYM-9999-783
*+       MEMBER IS FSPR-VAFVAST
*+           WITHIN AREA VAF SUBAREA SYMB-VAFVAST
*+           INDEX DBKEY POSITION IS 3
*+           MANDATORY AUTOMATIC
*+           KEY IS (
*+               VAF-RNR ASCENDING )
*+               DUPLICATES ARE LAST
*+               NATURAL SEQUENCE
*+               UNCOMPRESSED
*+       .

Kind regards,
Sibe Verbeek
ABN Amro bank
The Netherlands
0031-030-2260591





********************************* DISCLAIMER ******************************=
***

This message (including any attachments) is confidential and may be privile=
ged.
If you have received it by mistake please notify the sender by return e-mai=
l and delete this
message from your system.
Any unauthorised use or dissemination of this message in whole or in part i=
s strictly prohibited.
Please note that e-mails are susceptible to change.
ABN AMRO Bank N.V, which has its seat at Amsterdam, the Netherlands, and is=
registered in
the Commercial Register under number 34334259, including its group companie=
s,
shall not be liable for the improper or incomplete transmission of the info=
rmation contained
in this communication nor for any delay in its receipt or damage to your sy=
stem.
ABN AMRO Bank N.V. (or its group companies) does not guarantee that the int=
egrity of this
communication has been maintained nor that this communication is free of vi=
ruses,
interceptions or interference.
---------------------------------------------------------------------------=
--
Dit bericht (inclusief de eventuele bijlagen) is vertrouwelijk.
Wanneer u dit bericht ten onrechte heeft ontvangen, dient u de afzender hie=
rvan onmiddellijk
per kerende e-mail op de hoogte te brengen en dit bericht te verwijderen ui=
t uw systeem.
Elk onbevoegd gebruik en/of onbevoegde verspreiding van dit bericht is niet=
toegestaan.
U wordt erop gewezen dat e-mail berichten aan wijziging onderhevig kunnen z=
ijn.
ABN AMRO Bank N.V., statutair gevestigd te Amsterdam en ingeschreven in he=
t handelsregister
van de Kamer van Koophandel onder nummer 34334259, en haar groepsmaatschapp=
ijen,
is niet aansprakelijk voor de onjuiste en onvolledige overdracht van de inf=
ormatie in dit bericht
noch voor mogelijke vertraging in de ontvangst van dit bericht of schade aa=
n uw systeem als
gevolg van dit bericht. ABN AMRO Bank N.V. (en haar groepsmaatschappijen) s=
taat er niet
voor in dat de integriteit van dit bericht behouden is gebleven noch dat di=
t bericht vrij is
van virussen, niet is onderschept of vatbaar is geweest voor tussenkomst (d=
oor derden).
***************************************************************************=
**
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: OLQ Select index set
"When we used the IDMS SQL option our queries needed to look something like this.

SELECT * FROM FSPR_VAFVAST WHERE ""S-9999-783"" AND VAF_RNR = 210002735


All IDMS record and field names had to use the underscore instead of hyphen and set names were double quoted.


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

Outcomes