Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to get data into a VSAM file from an IMS-DC program.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
sreeniy

New User


Joined: 06 Aug 2007
Posts: 4
Location: hyderabad

PostPosted: Tue Aug 07, 2007 10:04 am    Post subject: How to get data into a VSAM file from an IMS-DC program.
Reply with quote

Hi i have a doubt on IMS-DC program coding. From past 1 week i am trying to include a VSAM or any other file into an IMS-DC program.My requirement is I have a variable in the program and i want to move the data from that variable into a file(any file). Please let me know if you have any idea which can be helpful to me.[/b][/b]
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Aug 07, 2007 1:11 pm    Post subject:
Reply with quote

In IMS DC you cannot access files.

BTW you dont have to make your post BOLD
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Aug 07, 2007 6:47 pm    Post subject:
Reply with quote

GSAM would be the answer. It can be accessed by IMS - basically it is used for situations such as yours. It is a root only.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Aug 07, 2007 6:54 pm    Post subject:
Reply with quote

Quote:
GSAM would be the answer
Can this be accesed in MPP or BMP?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Aug 07, 2007 8:35 pm    Post subject:
Reply with quote

A real advantage of GSAM is its ability to support checkpoint/restart. The processing options allowable for GSAM are GET UNIQUE, GET NEXT, and ISRT. GSAM supports variable record lengths.

Sreeniy, it would be helpful to know why you need to write a file from your DC program?
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Aug 08, 2007 3:06 am    Post subject:
Reply with quote

Quote:
Sandy Zimmer

GSAM is for BMP and not MPP.

However you mentioned that GSAM is the answer.

Question is related to MPP, and your explanation is for BMP program design.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Aug 08, 2007 3:50 am    Post subject:
Reply with quote

YEP - you can use GSAM for MPP - I have done it.....
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Aug 08, 2007 3:55 am    Post subject:
Reply with quote

I must add, however, that it is not easy. That is why it is always necessary to know the WHY of the design. I have also used HIDAM or HDAM for generating "end-of-day" balancing reports - settlement issues. That would be the best solution - we just need to know the WHY.
Back to top
View user's profile Send private message
sreeniy

New User


Joined: 06 Aug 2007
Posts: 4
Location: hyderabad

PostPosted: Wed Aug 08, 2007 10:37 am    Post subject:
Reply with quote

Hi Sandy, we have an online transaction which do the deletion process of customer account number whenever the user enters it. Previously we were deleting through MPP program in direct. Due to the performance issues Client wanted to do it through batch process. So first we need to copy the records into a file, then need give the file as input to a new batch job to delete the records. We planned to change it to BMP to insert GSAM. Upto now i know that GSAM works for BMP only.Please let me know if it works for MPP also. Thanks.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Aug 08, 2007 10:44 am    Post subject:
Reply with quote

Quote:
sreeni

For your reqt, you can write the transaction messages into Queue, and then trigger batch BMP program which reads the queue and processess the transaction by writing into an output GSAM file.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Aug 09, 2007 2:32 am    Post subject:
Reply with quote

Performance issues? Where are you getting the customer number? If you have the customer number to enter online - where are you getting it?
Back to top
View user's profile Send private message
sreeniy

New User


Joined: 06 Aug 2007
Posts: 4
Location: hyderabad

PostPosted: Thu Aug 09, 2007 9:33 am    Post subject: Re: How to get data into a VSAM file from an IMS-DC program.
Reply with quote

I have to thank you both Devzee & Sandy for spending your valuable time on this. I have an on-line screen (DC). In that screen the PF1 key mapped for deletion. We have to enter the account number, which deletes the account number thorough on-line process. I am unable to know why management wants to do this deletion through a batch process. They just said performance issues.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Aug 09, 2007 4:50 pm    Post subject:
Reply with quote

How do they know what accounts they want to delete? Performance issues? Well, if they are going to let you "write" something from an online process, then another suggestion would be to not use online at all. You could just create a flat sequential file to offline read thru the database doing the deletes.

Or, you could change the PF1 to write the keys to the "delete database" instead of actually doing the delete. Unless you are doing massive deletes, I don't know what this would buy you?
Back to top
View user's profile Send private message
sreeniy

New User


Joined: 06 Aug 2007
Posts: 4
Location: hyderabad

PostPosted: Thu Aug 09, 2007 4:57 pm    Post subject:
Reply with quote

Hi Sandy this could be a better option if the management agree. If not I will go through Devzee's suggestion. Thanks
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us