CA IDMS IUA EIUA

Re:OLQ Select index set

  • 1.  Re:OLQ Select index set

    Posted 08-20-2010 10:13 AM
    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
    privileged.
    If you have received it by mistake please notify the sender by return
    e-mail and delete this message from your system.
    Any unauthorised use or dissemination of this message in whole or in
    part is 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 companies, shall not be liable for the improper or
    incomplete transmission of the information contained in this
    communication nor for any delay in its receipt or damage to your system.
    ABN AMRO Bank N.V. (or its group companies) does not guarantee that the
    integrity of this communication has been maintained nor that this
    communication is free of viruses, interceptions or interference.
    ------------------------------------------------------------------------
    -----
    Dit bericht (inclusief de eventuele bijlagen) is vertrouwelijk.
    Wanneer u dit bericht ten onrechte heeft ontvangen, dient u de afzender
    hiervan onmiddellijk per kerende e-mail op de hoogte te brengen en dit
    bericht te verwijderen uit 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 zijn.
    ABN AMRO Bank N.V., statutair gevestigd te Amsterdam en ingeschreven in
    het handelsregister van de Kamer van Koophandel onder nummer 34334259,
    en haar groepsmaatschappijen, is niet aansprakelijk voor de onjuiste en
    onvolledige overdracht van de informatie in dit bericht noch voor
    mogelijke vertraging in de ontvangst van dit bericht of schade aan uw
    systeem als gevolg van dit bericht. ABN AMRO Bank N.V. (en haar
    groepsmaatschappijen) staat er niet voor in dat de integriteit van dit
    bericht behouden is gebleven noch dat dit bericht vrij is van virussen,
    niet is onderschept of vatbaar is geweest voor tussenkomst (door
    derden).
    ************************************************************************
    *****
    =20
    *****JuliusBaer Disclaimer***** This e-mail is for the intended =
    recipient only and may contain confidential or privileged information. =
    If you have received this e-mail by mistake, please contact us =
    immediately and completely delete it (and any attachments) and do not =
    forward it or inform any other person of its contents. If you send us =
    messages by e-mail, we take this as your authorization to correspond =
    with you by e-mail, however, we will not accept the electronic =
    transmission of orders/instructions without a specific agreement being =
    in place to govern the same. If you do not wish to receive any further =
    e-mail correspondence please let us know. E-mail transmission cannot be =
    guaranteed to be secure or error-free as information could be =
    intercepted, amended, corrupted, lost, destroyed, arrive late or =
    incomplete, or contain viruses. Neither the Julius Baer Group nor the =
    sender accept liability for any errors or omissions in the content of =
    this message which arise as a result of its e-mail transmission. Please =
    note that all e-mail communications to and from the Julius Baer Group =
    may be monitored. This communication is for informational purposes only. =
    It is not intended as an offer or solicitation for the purchase or sale =
    of any financial instrument or as an official confirmation of any =
    transaction.
    "
    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: z/os 1.11
    "Short answer - Yes.

    Long answer - You can find this info in CA Support Online by following the
    compatibilities link. It will lead you to APAR GI93034 which states R16 is
    compatible with z/OS 1.11, but with caveats. You must also look at QI82743
    (details about 'ALLOWCSAUSERKEY') and RO20143 (details about 'VSM
    USEZOSV1R9RULES').

    We are R16 SP4 and have successfully tested with z/OS 1.11 in VM guest and
    isolated environments. We will be upgrading our development systems to 1.11
    this weekend.

    Thanks - Tom W
    413-229-5072 (Telecommuter)

    Team Mail: CID_OLTP_IDMS
    Remedy CTI: SOFTWARE / DATABASE / IDMS
    Remedy Group: CV IDMS SUPPORT
    Theme Song: ""Been Down So Long, Look Like Up To Me""



    ""Barta, Michael""
    <Michael.Barta@IN
    FOCROSSING.COM> To
    Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
    Public Discussion cc
    Forum
    <IDMS-L@LISTSERV. Subject
    IUASSN.COM> z/os 1.11


    08/20/2010 09:26
    AM


    Please respond to
    IDMS Public
    Discussion Forum
    <IDMS-L@LISTSERV.
    IUASSN.COM>






    Does anyone know if IDMS Rel. 16 SP05 is z/OS 1.11 certified?



    Michael J. Barta

    Mainframe Database || Infocrossing, a Wipro Company || 11707 Miracle
    Hills Drive, Omaha NE, 68154|| ': 402.496.8564 ||7: 402.496.8676 || ::
    michael.barta@infocrossing.com **Think Green - Please print
    responsibly**





    Confidentiality Note: This e-mail, including any attachment to it, may
    contain material that is confidential, proprietary, privileged and/or
    ""Protected Health Information,"" within the meaning of the regulations under
    the Health Insurance Portability & Accountability Act as amended. If it is
    not clear that you are the intended recipient, you are hereby notified that
    you have received this transmittal in error, and any review, dissemination,
    distribution or copying of this e-mail, including any attachment to it, is
    strictly prohibited. If you have received this e-mail in error, please
    immediately return it to the sender and delete it from your system. Thank
    you.
    "
    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: z/os 1.11
    "Short answer - Yes.

    Long answer - You can find this info in CA Support Online by following the
    compatibilities link. It will lead you to APAR GI93034 which states R16 is
    compatible with z/OS 1.11, but with caveats. You must also look at QI82743
    (details about 'ALLOWCSAUSERKEY') and RO20143 (details about 'VSM
    USEZOSV1R9RULES').

    We are R16 SP4 and have successfully tested with z/OS 1.11 in VM guest and
    isolated environments. We will be upgrading our development systems to 1.11
    this weekend.

    Thanks - Tom W
    413-229-5072 (Telecommuter)

    Team Mail: CID_OLTP_IDMS
    Remedy CTI: SOFTWARE / DATABASE / IDMS
    Remedy Group: CV IDMS SUPPORT
    Theme Song: ""Been Down So Long, Look Like Up To Me""



    ""Barta, Michael""
    <Michael.Barta@IN
    FOCROSSING.COM> To
    Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
    Public Discussion cc
    Forum
    <IDMS-L@LISTSERV. Subject
    IUASSN.COM> z/os 1.11


    08/20/2010 09:26
    AM


    Please respond to
    IDMS Public
    Discussion Forum
    <IDMS-L@LISTSERV.
    IUASSN.COM>






    Does anyone know if IDMS Rel. 16 SP05 is z/OS 1.11 certified?



    Michael J. Barta

    Mainframe Database || Infocrossing, a Wipro Company || 11707 Miracle
    Hills Drive, Omaha NE, 68154|| ': 402.496.8564 ||7: 402.496.8676 || ::
    michael.barta@infocrossing.com **Think Green - Please print
    responsibly**





    Confidentiality Note: This e-mail, including any attachment to it, may
    contain material that is confidential, proprietary, privileged and/or
    ""Protected Health Information,"" within the meaning of the regulations under
    the Health Insurance Portability & Accountability Act as amended. If it is
    not clear that you are the intended recipient, you are hereby notified that
    you have received this transmittal in error, and any review, dissemination,
    distribution or copying of this e-mail, including any attachment to it, is
    strictly prohibited. If you have received this e-mail in error, please
    immediately return it to the sender and delete it from your system. Thank
    you.
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: z/os 1.11
    "Thanks for the info.=20