 |
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 29 matches |
| Author | Message |
|---|---|
 Topic: GDG Reset |
|
| OSCORP Replies: 2 Views: 1745 |
 Forum: Utilities Posted: Mon Jul 16, 2007 9:55 am Subject: GDG Reset |
| Hi,
I remember of using one utility UCC11 which used to reset the GDG pointers for the new files created in previous step. Does anyone know if I can find any documentation/information related to ... |
|
| Topic: DB2 Query Tuning |
|
| OSCORP Replies: 2 Views: 1710 |
Forum: Database Posted: Sun Jun 24, 2007 2:01 pm Subject: DB2 Query Tuning |
| Hi,
I need to tune the following two queries. Currently queries take @ 9 hrs to execute I want to reduce the time to @ 1 hr. Can anyone please assist? SQL1 SELECT ... |
|
| Topic: write Matching records in output using SPLICE |
|
| OSCORP Replies: 4 Views: 2846 |
Forum: Utilities Posted: Sat Mar 31, 2007 6:33 pm Subject: write Matching records in output using SPLICE |
| Thanks a lot Kolusu,kolusu...
Regs Oscorp |
|
| Topic: write Matching records in output using SPLICE |
|
| OSCORP Replies: 4 Views: 2846 |
Forum: Utilities Posted: Fri Mar 30, 2007 11:17 am Subject: write Matching records in output using SPLICE |
| Hi Kolusu,
ThankS a lot for the quick reply... But I am still getting the OPEN SYSIN Error. I guess thrivikram has posted the same query as mine...but I overlooked it while doing the search ... |
|
| Topic: write Matching records in output using SPLICE |
|
| OSCORP Replies: 4 Views: 2846 |
Forum: Utilities Posted: Fri Mar 30, 2007 9:33 am Subject: write Matching records in output using SPLICE |
| Hi,
I need to compare two files on first 9 bytes and write only the matching records from first file (of 25 bytes) to the output file. I tried writinga DFSORT JCL using SPLICE but keep getting F ... |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Mon Mar 26, 2007 6:12 pm Subject: DB2 Query converted to DFSORT |
| Hi kolusu,
sorry for being so late in posting thank you reply. Regs Oscorp |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Fri Feb 23, 2007 5:47 pm Subject: DB2 Query converted to DFSORT |
Sorry...I knew this would happen. In OPCB File there will be duplicates In PROV & PTA file there will not be any duplicates Regs Oscorp |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Thu Feb 22, 2007 3:14 pm Subject: DB2 Query converted to DFSORT |
| Hi Kolusu,
PTA Extract ..."D. |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Thu Feb 22, 2007 12:04 pm Subject: DB2 Query converted to DFSORT |
| Hi Kolusu,
I am getting some different result set this time. The first comparision did worked fine...but for the last comparision I am not able to get the desired output. It seems that the outp ... |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Wed Feb 21, 2007 9:34 am Subject: DB2 Query converted to DFSORT |
| Hi kolusu,
Thanks....here are the details: OPCB File: LRECL = 51 Bytes 10 PROV-ID PIC S9(9) USAGE COMP. 10 OVTN-PROV-CONTR-ID PIC S9(9) USAGE COMP. 10 O ... |
|
| Topic: DB2 Query converted to DFSORT |
|
| OSCORP Replies: 11 Views: 5193 |
Forum: Utilities Posted: Tue Feb 20, 2007 4:04 pm Subject: DB2 Query converted to DFSORT |
| Hi,
Can anyone help me with this? I have a join query of 3 tables which is abending with -904. Some issues with Temp Workspace. Each table has about 2 to 8 million rows. Also it takes 4-5 hrs to ... |
|
| Topic: VSAM RPL Exception...! |
|
| OSCORP Replies: 0 Views: 1966 |
Forum: Data Management Posted: Thu Dec 21, 2006 3:42 am Subject: VSAM RPL Exception...! |
| Guys...
Can anyone interpret this error?? SM 0F0C SMAR *EXC* - Storage_check_failed_at_address - 1711B0E0 FUNCTION(RELEASE_TRANSACTION_STG) KE_NUM-0039 TCB-QR /009C5938 RET-94640718 T ... |
|
| Topic: How EDIT Masks work?? |
|
| OSCORP Replies: 2 Views: 3037 |
Forum: Utilities Posted: Mon Mar 14, 2005 10:10 pm Subject: How EDIT Masks work?? |
| Hi,
Can anybody please let me know how EDIT masks work?? 3/,2:'AVERAGE PRICE OF BOOK IN STOCK: ', AVG=(170,4,BI,M18), 3/,2:'TOTAL PRICE OF BOOKS IN STOCK: ', TOTAL=& ... |
|
| Topic: Can i get daily digest of posting ? |
|
| OSCORP Replies: 4 Views: 3226 |
Forum: About Mvsforums Posted: Sun Mar 13, 2005 9:27 pm Subject: Can i get daily digest of posting ? |
| Yesss.....Daily digest required.
count me as well.. Oscorp |
|
| Topic: Gmail Invitations |
|
| OSCORP Replies: 99 Views: 74648 |
Forum: Related Non-Technical Topics Posted: Sat Feb 26, 2005 11:53 am Subject: Gmail Invitations |
| madhusudhanan
sent u an invitation.. regs OsCorp |
|
All times are GMT - 5 Hours |