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 

Can we access Flat Files through IMS-DC?

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
ramu_mohan21
Beginner


Joined: 29 Jun 2004
Posts: 106
Topics: 41
Location: Bangalore, INDIA

PostPosted: Thu Dec 09, 2004 5:44 am    Post subject: Can we access Flat Files through IMS-DC? Reply with quote

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
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Thu Dec 09, 2004 6:39 am    Post subject: Reply with quote

ramu_mohan21,

Please search before posting. check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=1033&highlight=files

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
ramu_mohan21
Beginner


Joined: 29 Jun 2004
Posts: 106
Topics: 41
Location: Bangalore, INDIA

PostPosted: Thu Dec 09, 2004 8:40 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Thu Dec 09, 2004 8:49 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
ramu_mohan21
Beginner


Joined: 29 Jun 2004
Posts: 106
Topics: 41
Location: Bangalore, INDIA

PostPosted: Fri Dec 10, 2004 3:12 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Fri Dec 10, 2004 9:40 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group