View previous topic :: View next topic
|
Author |
Message |
sreeniy
New User
Joined: 06 Aug 2007 Posts: 4 Location: hyderabad
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
In IMS DC you cannot access files.
BTW you dont have to make your post BOLD |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
Quote: |
GSAM would be the answer |
Can this be accesed in MPP or BMP? |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
YEP - you can use GSAM for MPP - I have done it..... |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
sreeniy
New User
Joined: 06 Aug 2007 Posts: 4 Location: hyderabad
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
sreeniy
New User
Joined: 06 Aug 2007 Posts: 4 Location: hyderabad
|
|
|
|
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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
sreeniy
New User
Joined: 06 Aug 2007 Posts: 4 Location: hyderabad
|
|
|
|
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 |
|
|
|