 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 8 matches |
| Author | Message |
|---|---|
 Topic: Order of predicates in an SQL query |
|
| abhayasahoo Replies: 1 Views: 1646 |
 Forum: Database Posted: Mon Nov 21, 2005 3:33 pm Subject: Order of predicates in an SQL query |
| Does order of predicates in an SQL query with a JOIN matter as far as the performance of the query is concerned ?
For example, SQL1 Select A.col1, A.col2, B.col3 ... |
|
| Topic: Delete a member from a PDS |
|
| abhayasahoo Replies: 9 Views: 13744 |
Forum: Job Control Language(JCL) Posted: Wed Aug 13, 2003 2:27 pm Subject: Delete a member from a PDS |
| I have a requirement in which I have to delete specific members from different PDSs. Can I do it with a JCL ? | |
| Topic: Region Parameter |
|
| abhayasahoo Replies: 8 Views: 8868 |
Forum: Job Control Language(JCL) Posted: Tue Dec 10, 2002 10:46 pm Subject: Region Parameter |
| Thanks for your replies.
Bill, What system problems are encountered when one uses REGION=0M in all the jobs ? When all the jobs are coded with REGION=0M on the job card, does the system still ... |
|
| Topic: Delay of less than a second |
|
| abhayasahoo Replies: 10 Views: 10781 |
Forum: CICS and Middleware Posted: Sun Dec 08, 2002 10:18 pm Subject: Delay of less than a second |
| Hi,
We are having a CICS-DB2 program where we try to fetch a record INSERTed by another application which happens simulataneously. But for some cases, there is a slight delay in putting the reco ... |
|
| Topic: Region Parameter |
|
| abhayasahoo Replies: 8 Views: 8868 |
Forum: Job Control Language(JCL) Posted: Sun Dec 08, 2002 2:25 am Subject: Region Parameter |
| Hi,
Is it advisable to put REGION=0M in all the jobs in the shop ? Let's say that program A does not require enough virtual storage. Does it still allocate unwanted virtual storage for the progra ... |
|
| Topic: Delay of less than a second |
|
| abhayasahoo Replies: 10 Views: 10781 |
Forum: CICS and Middleware Posted: Sun Dec 08, 2002 2:18 am Subject: Delay of less than a second |
| Hi,
The CICS Delay function does not support a DELAY INTERVAL of less than a second. I have a requirement in one of the application programs to put in a delay interval of 0.5 seconds. Can I do th ... |
|
| Topic: DB2 timestamp question |
|
| abhayasahoo Replies: 6 Views: 9204 |
Forum: Database Posted: Sat Dec 07, 2002 3:36 pm Subject: DB2 timestamp question |
| Many times, we get an SQLCODE of -805 or-818 on BIND. Is there a way we can find the date and time from the CONTOKEN stored in DB2 catalog ?
For example, can we decode the CONTOKEN 170A36060594C259 i ... |
|
| Topic: Accessing tables in different DB2 sub-systems |
|
| abhayasahoo Replies: 12 Views: 16841 |
Forum: Database Posted: Wed Dec 04, 2002 12:17 am Subject: Accessing tables in different DB2 sub-systems |
| Is it possible for one DB2 program to access tables from two different sub-systems ? | |
All times are GMT - 5 Hours |