View previous topic :: View next topic |
Author |
Message |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Thu Dec 09, 2004 5:44 am Post subject: Can we access Flat Files through IMS-DC? |
|
|
Hi Board,
My requiremnet is to build the online screen which takes some numbers from the user and the same number should be updated in one of the GDG version. This requirement should be done in IMS-DC Online Transacation.
I heard that using CICS, we can't access flat files(GDG Versions). Is this possible to do the same requirement in IMS-DC?
If we declare GDG Version as a GSAM File will it work?
If any of above assumptions are wrong please correct me. _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Thu Dec 09, 2004 8:40 am Post subject: |
|
|
Hi Kolusu,
I saw the link provided but I didn't get the required answer. My requirement is clearly given below:
1) The user enters the IMS-DC Transaction on the Blank Screen
2) The user enter Some Number on the screen displayed.
3) After pressing enter-> The data should be updated in GDG Version(Not VSAM File)
4) The same GDG Version should be updated as much time as the user stay in that online screen.
5) If the user comes out and again entered into the IMS Transaction, then the new version of the GDG Version should be created with entered data.
I hope I'm clear now. In the above given link it has given reference to VSAM File. Not to Sequential File/GDG.
Please can you clarify my doubt. _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Thu Dec 09, 2004 8:49 am Post subject: |
|
|
Ramumohan_21,
Even though the topic talks about vsam files, it is applicable to sequential files also.
Your design of updating the GDG file is bad.
Simple reasons to avoid the design .
1. what happens when the GDG's are migrated?
2. How do you know which GDG version you are going to update?
you just can't read the base and search for the key to be updated. ex there are 30 generations(each contains a million records) and the key I am trying to update is on the 22nd gen. you need to read 21 generations to get to the record itself. All this happens when the user is waiting for his update.
A DB2 table would be more approriate in your case.
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Fri Dec 10, 2004 3:12 am Post subject: |
|
|
Hi Kolusu,
I will explain my requirements bit more clear. Right now we don't have DB2 in our shop. Hence I need to think in a different way.
Existing State:
1) Right now the user will needs data of some Claims(Claim Number consisting of 17 Character) through a mail/ Some times in a Sequential File.
2)
a)
If the mail has been sent consisting of Claim Numbers We manually copy those Claim Numbers into an Input File(Input File is a GDG. We create a new GDG and update it) of a JOB(For Ex: ABCDJOB) which is going to be executed everyday.
b) If the File has been sent we will copy that data into new Input GDG Version of a JOB(ABCDJOB) which is going to be exeucted.
3) This ABCDJOB will be triggred some time in the middle of the day. Before that we need to do that above mentioned procedure.
4) If he needs the data regarding Claims next day again he will follow the same procedure.
My Design to solve this problem:
1) We want to build an online screen to do this task. Instead of sending a mail consiting of Claim Number/File name, directly the user will enters his claim numbers on the screen. That should update a One GDG Version(Test.New.Data) as I mentioned accordingly.
2) Before running of ABCDJOB we wanted to run one more JOB which will copy all the versions of (Test.New.Data) into input GDG version(New Version) of ABCDJOB and all the existing versions of the Test.New.Data will be deleted within the JOB.
Please let me know if my design consisting of any flaws. And also I am thinking in a way that Instead of taking Test.New.Data as a GDG file, I want to take as a VSAM File.
And also I need some clarification regarding using of GDG Versions. If one user is executing the transaction it will create a new Version of Test.New.Data. At the same time another user running the transaction what will happen. Is new Version is going to be created. Normally in Batch JOBs the GDG Version will be updated Until completion of the whole job(It may be Normal execution/Abend). What will happen in the case of online? _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
Bithead Advanced

Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Fri Dec 10, 2004 9:40 am Post subject: |
|
|
Run the updates into an IMS database then extract them to the GDG when you run the job. Delete the extracted entries from the database is required. |
|
Back to top |
|
 |
|
|