View previous topic :: View next topic
|
Author |
Message |
elixir1986 Warnings : 1 New User
Joined: 10 Nov 2015 Posts: 44 Location: USA
|
|
|
|
Team,
Can a COBOL CICS program access both VSAM and DB2? I was asked in an interview today. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
Yes . Why not? |
|
Back to top |
|
|
elixir1986 Warnings : 1 New User
Joined: 10 Nov 2015 Posts: 44 Location: USA
|
|
|
|
Hi Team - May be I did not convey my question correct.
I will rephrase my questions,
1) Can a COBOL CICS program access both VSAM and DB2 simultaneously?
2) How does the SYNCHPOINT & ROLLBACK impact VSAM and DB2 changes in that COBOL CICS program?
Many thanks in advance for all your responses! |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
I see you are still considered a new user but have been on this excellent site for 6 years.
So here is my usual reply to questions like yours.
If you want to become an expert, the go-to-person in your organization, then you cannot expect to learn by asking, but rather by doing.
I recommend you set up a test platform/library/etc., and create skeleton programs/scripts/etc. to test the various questions that will continue to arise during your career.
You will then have documented proof you can rely on and refer others to as to what will happen when you try, in this case:
1) a COBOL CICS program accessing both VSAM and DB2 simultaneously
2) Doing a SYNCHPOINT & ROLLBACK and identifying the impact VSAM and DB2 changes in that COBOL CICS program
It may seem like a lot of trouble at first, but once you've done it, adding new small programs to test this-or-that will be quick, and you'll really know the answer, not just what you think the answer is.
I had a great career as a programmer/analyst - loads of fun and interesting technical challenges.
Good Luck. |
|
Back to top |
|
|
elixir1986 Warnings : 1 New User
Joined: 10 Nov 2015 Posts: 44 Location: USA
|
|
|
|
There is no organization to go! I said I was asked in an interview! |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
elixir1986 wrote: |
Hi Team - May be I did not convey my question correct.
I will rephrase my questions,
1) Can a COBOL CICS program access both VSAM and DB2 simultaneously?
2) How does the SYNCHPOINT & ROLLBACK impact VSAM and DB2 changes in that COBOL CICS program?
Many thanks in advance for all your responses! |
It doesn't change the answer regardless if you ask differently. I second Phil, Do test by yourself and nothing can beat that learning.
Besides , Please read manuals to get clear understanding of how it works. Syncpoint and rollback applies to the current unit of work. for e.g. if there is a successful updates to both then syncpoint else rollback everything. Now this gets tricky when you do these updates in called modules and the way you do those calls e.g. START, XCTL, TDQs, MQ triggers etc. .
Moved to Students Section. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2025 Location: USA
|
|
|
|
elixir1986 wrote: |
There is no organization to go! I said I was asked in an interview! |
In order to pass any interview, you need to really understand the matter of the subject, while you are trying just to remember the answers to a number of standard questions. Please, do not consider the interview as a sort of quiz, similar to this example:
Quote: |
Who was the first President of the United States? Please choose the correct answer:
1) Micky Maus
2) Arnold Schwarzenegger
3) George Washington
4) Jacky Chung
|
Even after correct answers to 100 of such questions you may not become a Bachelor of Science in History.
Same story, even more serious one, is with your interview for an IT position. |
|
Back to top |
|
|
|