 |
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 77 matches |
| Author | Message |
|---|---|
 Topic: VSAM KSDS OPEN/CLOSE FAILED in CICS |
|
| Jaya Replies: 3 Views: 7453 |
 Forum: CICS and Middleware Posted: Mon Sep 28, 2009 8:47 am Subject: VSAM KSDS OPEN/CLOSE FAILED in CICS |
| Add index and data buffers to the VSAM using AMP=('BUFNI=1,BUFND=10') . It worked for me. | |
| Topic: Need guidance to choose the Career path for the next 5 years |
|
| Jaya Replies: 2 Views: 6404 |
Forum: Related Non-Technical Topics Posted: Wed Jul 15, 2009 4:13 pm Subject: Need guidance to choose the Career path for the next 5 years |
| I am a mainframe professional with around 6 years of experience performing the role of a technical lead to co-ordinate mainframe support and enhancement projects in DB2/CICS and IDMS/ADSO technologies ... | |
| Topic: Need to concatenate a file based on condition in input file |
|
| Jaya Replies: 3 Views: 1981 |
Forum: Utilities Posted: Wed Sep 20, 2006 3:43 pm Subject: Need to concatenate a file based on condition in input file |
| Thanks you very much FRANK!! This is a very nice trick and it works great! Also it is a very good learning that if we use two COND statement in sysin , the second statement would get ignored..
Than ... |
|
| Topic: Need to concatenate a file based on condition in input file |
|
| Jaya Replies: 3 Views: 1981 |
Forum: Utilities Posted: Wed Sep 20, 2006 1:19 pm Subject: Need to concatenate a file based on condition in input file |
| Hi
I have 3 input files File1: X1 X2 X3 X4 X5 X6 X7 X8 X9 SUZERO File2: SM T2 T3 T4 File 3: T5 T6 In file1, there is a record which satisfies a condition 1,2,CH,EQ,C' ... |
|
| Topic: Running a left outer join SQL through a BATCH JCL |
|
| Jaya Replies: 7 Views: 6451 |
Forum: Database Posted: Tue Sep 05, 2006 9:59 pm Subject: Running a left outer join SQL through a BATCH JCL |
| Thanks for the link coolman!...I had also reffered the same for my current workaround. 8) .
With my recent query i am getting the same rows as my earlier QUERY1. Thanks, Jaya. |
|
| Topic: Running a left outer join SQL through a BATCH JCL |
|
| Jaya Replies: 7 Views: 6451 |
Forum: Database Posted: Tue Sep 05, 2006 12:21 pm Subject: Running a left outer join SQL through a BATCH JCL |
| Coolman,
Thanks for the reply.... TABLE1 and QUERY1 has duplicates on PLANT_CD and DTL_PART_NUM. TABLE2 also has duplicates on PART_NUM and PLANT_CD .But the QUERY2 SELECT PART_NUM ... |
|
| Topic: Running a left outer join SQL through a BATCH JCL |
|
| Jaya Replies: 7 Views: 6451 |
Forum: Database Posted: Tue Sep 05, 2006 9:54 am Subject: Running a left outer join SQL through a BATCH JCL |
| Hi
I am running 2 queries Query 1: SELECT PLANT_CD,CHAR(','),PART_NUM,CHAR(','), DTL_PART_NUM,CHAR(','),CHAR(DTL_PART_EXT_QTY) FROM TABLE1 WHERE CST_BO ... |
|
| Topic: Running a left outer join SQL through a BATCH JCL |
|
| Jaya Replies: 7 Views: 6451 |
Forum: Database Posted: Thu Aug 31, 2006 8:58 pm Subject: Running a left outer join SQL through a BATCH JCL |
| Thanks a lot Kolusu! You have a brilliant answer as usual...
SELECT A.PLANT_CD ,CHAR(',') ,A.PART_NUM ,CHAR( ',') ,A.DTL_PART_NUM ,CHA ... |
|
| Topic: Running a left outer join SQL through a BATCH JCL |
|
| Jaya Replies: 7 Views: 6451 |
Forum: Database Posted: Thu Aug 31, 2006 1:55 pm Subject: Running a left outer join SQL through a BATCH JCL |
| Hi,
I am running the SQL query using the following JCl //STEP5 EXEC PGM=PTLDRIVM, // PARM='EP=UTLGLCTL/DB2P', // REGION=0M, // COND=(04,LT) //* // ... |
|
| Topic: Help sending an Excel file as email attachment thru Mainfram |
|
| Jaya Replies: 5 Views: 7537 |
Forum: Job Control Language(JCL) Posted: Tue Aug 08, 2006 7:11 am Subject: Help sending an Excel file as email attachment thru Mainfram |
| Kolusu,
Thanks for the reply... I have generated the comma seperated fixed block file using a code similar to your model code. The data is getting seggregated properly among the columns i.e My d ... |
|
| Topic: Help sending an Excel file as email attachment thru Mainfram |
|
| Jaya Replies: 5 Views: 7537 |
Forum: Job Control Language(JCL) Posted: Tue Aug 08, 2006 3:38 am Subject: Help sending an Excel file as email attachment thru Mainfram |
| Hi,
I am currently sending an EMAIL with .CSV file as an attachment and it is working fine. The attached CSV file have 7 columns. The first row is the header and the remaining row has detail inform ... |
|
| Topic: Sorted output in single step |
|
| Jaya Replies: 2 Views: 1404 |
Forum: Utilities Posted: Mon Aug 07, 2006 3:53 am Subject: Sorted output in single step |
| Pranabesh,
Please try this jcl... //STEP01 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * ... |
|
| Topic: IEBGENER : Conflicting DCB parameters |
|
| Jaya Replies: 3 Views: 11865 |
Forum: Job Control Language(JCL) Posted: Thu Jul 20, 2006 1:11 am Subject: IEBGENER : Conflicting DCB parameters |
| Beep_bop,
Check the following link for an IEBGENER example that edits and copies a sequential input dataset. http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1u104/6.9.7?DT=19990113 ... |
|
| Topic: Query for removing Space and Unstring |
|
| Jaya Replies: 3 Views: 1810 |
Forum: Database Posted: Wed Jul 12, 2006 5:24 am Subject: Query for removing Space and Unstring |
oops!!...The solution is already posted. I forgot to click the submit button earlier. 
Jaya.. |
|
| Topic: Query for removing Space and Unstring |
|
| Jaya Replies: 3 Views: 1810 |
Forum: Database Posted: Wed Jul 12, 2006 5:18 am Subject: Query for removing Space and Unstring |
| Nadh,
Please try this... UPDATE Emptable SET halltino=SUBSTR(halltino,1,POSSTR(halltino,' ') - 1) WHERE ...; Thanks, Jaya. |
|
All times are GMT - 5 Hours |