Author |
Message |
Topic: Creating Index |
rishikesh_u
Replies: 1
Views: 1168
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|