MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 5 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Creating Index
rishikesh_u

Replies: 1
Views: 1168

PostForum: Database   Posted: Wed May 18, 2005 9:12 am   Subject: Creating Index
Hi,

Can anyone please clarify on what factors should we consider while creating Index.

Suppose say I have a query like

SELECT EMP-NAME
FROM EMP-TABLE
WHERE EMP-NO = 12345

Creating inde ...
  Topic: Search a string
rishikesh_u

Replies: 1
Views: 1349

PostForum: TSO and ISPF   Posted: Sat May 07, 2005 5:40 am   Subject: Search a string
Hi,

I have 'n' number of programs and each program has say 'm' copybooks. I've to find the programs that use a particular string 'xyz'. Using 3.14 option I can just search the programs, but it will ...
  Topic: Replacing characters in a record
rishikesh_u

Replies: 8
Views: 6308

PostForum: Utilities   Posted: Wed Mar 30, 2005 6:06 am   Subject: Replacing characters in a record
Kolusu,

Tried the sort option as given by you and it's working fine. But i am not very clear how this is acheived.

What is the need of "Using OUTREC fileds we put the first 17 bytes and 8 bytes ...
  Topic: Grant access for PDS
rishikesh_u

Replies: 6
Views: 11081

PostForum: TSO and ISPF   Posted: Mon Mar 07, 2005 4:41 am   Subject: Grant access for PDS
Try this,

Type RACF from command promt
then select the option 1 . DATA SET PROFILES
then again select option 1 Add a profile then type the profile name as the PDS which you want to give the acce ...
  Topic: How to examine the performance of SQL statements.
rishikesh_u

Replies: 1
Views: 942

PostForum: Database   Posted: Mon Mar 07, 2005 4:22 am   Subject: How to examine the performance of SQL statements.
We are working on performance tuning of a DB2 program. There are 100 and odd queries in the program. We identified 15 quueries that can be written in an efficient way. How to examine the performance ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group