Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

OLQ-information

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
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    Post subject: OLQ-information
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

Site Director


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

PostPosted: Fri Jan 23, 2009 9:25 am    Post subject:
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    Post subject: information
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    Post subject: please find the info
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    Post subject: Need help
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

Site Director


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

PostPosted: Fri Jan 23, 2009 10:13 pm    Post subject:
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    Post subject: Reply to: OLQ-information
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    Post subject: error message
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    Post subject: please find the screen shot
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    Post subject: Its working fine
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm
No new posts Passing information through JCL as in... Pia Baruah JCL & VSAM 5 Wed May 25, 2016 2:22 pm
No new posts Extracting Information from DD Statem... Charles Wolters All Other Mainframe Topics 7 Wed Apr 13, 2016 10:21 pm
This topic is locked: you cannot edit posts or make replies. Job Offer: Information systems consu... Express Mainframe Jobs 0 Thu Mar 10, 2016 7:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us