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 77 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: VSAM KSDS OPEN/CLOSE FAILED in CICS
Jaya

Replies: 3
Views: 7153

PostForum: 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: 5580

PostForum: 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: 1827

PostForum: 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: 1827

PostForum: 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: 6080

PostForum: 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: 6080

PostForum: 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: 6080

PostForum: 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: 6080

PostForum: 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: 6080

PostForum: 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: 7072

PostForum: 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: 7072

PostForum: 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: 1243

PostForum: 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: 11389

PostForum: 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: 1631

PostForum: 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. Sad

Jaya..
  Topic: Query for removing Space and Unstring
Jaya

Replies: 3
Views: 1631

PostForum: 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.
 
Page 1 of 6 Goto page 1, 2, 3, 4, 5, 6  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group