IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

OLQ-information


IBM Mainframe Forums -> IDMS/ADSO
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Fri Jan 23, 2009 9:06 am
Reply with quote

Hi,

OLQ is the online query which is used to search the data. Is is possible to to have "AND" or "OR" for the same field.

Say in the database we have a field called service code, can we search for two or more codes using AND or OR condition.

Please let me know if you guys need more information on this.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Fri Jan 23, 2009 9:25 am
Reply with quote

Hello,

What have you tried? What happened?

Every query language i've used (more than a dozen) support and/or one way or another. The syntax may vary, but the functonality is there.

When you run a test query and there either an error raised or incorrect results occur, post the query and the problem. If there is an error message, also post the message id.
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Fri Jan 23, 2009 10:03 am
Reply with quote

Please find the attachment for the brief description of the problem.

Do let me know is there any other way to do online search.
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Fri Jan 23, 2009 10:16 am
Reply with quote

To enter the condition to specify the value to be searched we need to use the following command:

OLQ -> signon ss u212da10 -> menu

Menu Screen
Computer Associates International, Inc. CAGJG0
CA-OLQ Release 16.0 *** Menu ***
-> Page 1 Of 3
122000 Select an option and press the ENTER key.

Select Command/ Show/
Pfkey Option Description Screen Name Help

---> Data Source for Report <---
_ Choose tables TABle _
_ Choose subschema SUBschema _

---> Retrieval Activity <---
x Choose records from selected subschema RECord _
_ Choose columns for report COLumn _
_ Retrieve data to build report RETrieve _
_ Alter database access strategy LINkage _

---> Processing Mode <---
_ Execute or create a predefined routine QFIle _
_ View existing or save current report SAVe _
Submit batch report request BATch _

1=HELP 2=GLOBAL HELP 3=QUIT 4=MESSAGE 8=FWD

I have selected 2 records

CA-OLQ *** Record Select ***
-> Page 3 Of 7
123000 Select records and press the ENTER key.

Records Currently Selected: 2
Enter Records :

-And/Or-
Select Records :
_ FORETAK2 _ KATLTRA
_ FRMKONTO _ KODETAB
_ FRMLOGG X KONS
_ FYSSENT _ KONSATT
_ GODMRK _ KONSATTD
_ GODUTST _ KONSMRK
_ HOVEDLEV _ KONS2
_ IDMSQUEU _ KONS4
_ IMSINTRV _ KONS5
_ KAMPANJE _ KONS6
_ KAMPER _ KONTFREE
_ KAMRESP _ KONTO
_ KAMTJE _ KONTOMRK
_ KAPKNYT _ KONTO1
1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 8=FWD PA2=REFRESH




Kons and Tjlinje are in number and service respectively.
TJKD -> service code






CA-OLQ *** Column Select ***
-> Page 5 Of 5
091047 Command syntax is invalid at token Æ 11 value= = .

Columns Currently Selected: 41 Selection Criteria Distinct N Y/N
x TJLINJE
_ 02 TJTILBF
x 02 TJTILBT =00000000
x 02 TJKD =04001 and =04369
_ 02 TJMERK
_ 02 INNMELDING
_ 02 SENDT-GENEVA







Additional Selection Criteria:


Proceed to Selection Criteria Screen? N Y/N
1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD PA2=REFRESH


I want to have a kons[number] with the service code 04001 and 04369.

The screen are in Norwegian.
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Fri Jan 23, 2009 11:39 am
Reply with quote

Hi Dick,

If you have time please look into the issue.

In case u needed more information or concern do let me know.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Fri Jan 23, 2009 10:13 pm
Reply with quote

Hello,

None of my current sites has idms installed, so i cannot experiment.

What does the online help say? The manual?

Suggest you open an issue with CA Support.
Back to top
View user's profile Send private message
vijayakumar.yellala

New User


Joined: 19 Apr 2006
Posts: 63
Location: Chennai

PostPosted: Wed Jan 28, 2009 4:19 pm
Reply with quote

Hi Deepak...

U can seach for more service codes in OLQ.

In the bottom of the OLQ.

Give 'Y' ,Proceed to Selection Criteria Screen? Y Y/N

then enter..

It will display query selection screen.
there u can mention which field u need select more.

TJKD =04001 or TJKD =04002 or TJKD =04001

like this u have to mention.

Please let me know if u r not clear.

Regards
Vijay
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Thu Jan 29, 2009 11:09 am
Reply with quote

Hi Vijay,

Thanks for sharing the information.
I got the error message '124000 Select columns, specify selection criteria and press the ENTER key'

Please update me.
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Thu Jan 29, 2009 11:17 am
Reply with quote

CA-OLQ *** Column Select ***
-> Page 5 Of 5
124000 Select columns, specify selection criteria and press the ENTER key.

Columns Currently Selected: 47 Selection Criteria Distinct N Y/N
_ TJLINJE
X 02 TJTILBF
X 02 TJTILBT =00000000
X 02 TJKD
X 02 TJMERK
X 02 INNMELDING
X 02 SENDT-GENEVA







Additional Selection Criteria: TJKD =04001 OR TJKD =04129


Proceed to Selection Criteria Screen? N Y/N
1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD PA2=REFRESH
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Thu Jan 29, 2009 1:18 pm
Reply with quote

its working fine for OR but for AND i am not getting any records
Back to top
View user's profile Send private message
sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Fri Jan 30, 2009 9:12 am
Reply with quote

Hi Deepak,
Quote:
its working fine for OR but for AND i am not getting any records


are u trying to give a command as
Additional Selection Criteria: TJKD =04001 AND TJKD =04129.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IDMS/ADSO

 


Similar Topics
Topic Forum Replies
No new posts Remove additional information in SUPE... TSO/ISPF 10
This topic is locked: you cannot edit posts or make replies. Control-M Information. CLIST & REXX 1
No new posts how to read accounting information in... COBOL Programming 1
No new posts Need information on creating dynamic ... CLIST & REXX 11
No new posts Utility to list Data Set Information JCL & VSAM 6
Search our Forums:

Back to Top