Static or Dynamic Call.
in [Cobol]
|
Prev: Beautify code
Next: TSQ/TDQ purpose?
From: arrbee on 3 May 2006 07:25 Hi, I have to read a flat file (100,000 records) and update a DB2 table with the values from flat file. So, which call is preferable here? Static or Dynamic? Any reasoning on which type of call to be chosen? What care should be taken in case of an abend (program goes down after updating 50,000 records)? How to restart it in such a situation. Thanks in advance.
From: on 3 May 2006 09:06 In article <1146655537.010440.224890(a)i40g2000cwc.googlegroups.com>, arrbee <arrbee(a)gmail.com> wrote: >Hi, > >I have to read a flat file (100,000 records) and update a DB2 table >with the values from flat file. So, which call is preferable here? >Static or Dynamic? Any reasoning on which type of call to be chosen? >What care should be taken in case of an abend (program goes down after >updating 50,000 records)? How to restart it in such a situation. Please post the code you have used and the results so that others might see what you have already done... or is this another interview question? DD
From: Binyamin Dissen on 3 May 2006 11:37 On 3 May 2006 04:25:37 -0700 "arrbee" <arrbee(a)gmail.com> wrote: :>I have to read a flat file (100,000 records) and update a DB2 table :>with the values from flat file. So, which call is preferable here? :>Static or Dynamic? Any reasoning on which type of call to be chosen? :>What care should be taken in case of an abend (program goes down after :>updating 50,000 records)? How to restart it in such a situation. Was that another question from your interview? Do you really think that you can bluff DB2 knowledge with a few quick answers? -- Binyamin Dissen <bdissen(a)dissensoftware.com> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies.
From: Holly on 3 May 2006 17:05 Here ya go dude, here are some links you need to know. Quickly. http://www.pdc.kth.se/doc/SP/manuals/db2-5.0/html/db2l0/db2l012.htm http://os2ports.com/docs/DB2/db2a0/db2a002.htm If you're preparing for a technical interview, then be prepared to answer their questions in terms of how you would apply the logic in a given situation. It depends on how the shop where you are interviewing is structured. Does the database have indexes? etc. As far as abends, look at error handling in your calls (check for return codes like 0, 811, etc) and if you are doing rollbacks. If you don't know this then you may be in trouble. They aren't going to need canned answers, they just want to see if you have an idea about how to use DB2 & Cobol. It might be better to admit what you don't know, and present yourself as trainable and willing to learn. If you present yourself as an expert and get the job, then what are you going to do if there's nobody to ask? Good luck anyway!
From: on 3 May 2006 18:25
In article <1146690299.881625.152150(a)u72g2000cwu.googlegroups.com>, Holly <anderschwan(a)hotmail.com> wrote: [snip] >It might be better to admit what you don't know, and present yourself >as trainable and willing to learn. I've seen that proven, at times, to be a moderately unsuccessful gambit... a fellow I know has been working with DB2 since 1987 or so; a couple of years back he got certified as an Oracle DBA. Now he gets to hear 'Sorry, there's not enough Oracle on your resume`.' >If you present yourself as an >expert and get the job, then what are you going to do if there's nobody >to ask? Same as now... say 'Hmmmmm, at my other job we did it differently...' and then post to a newsgroup and ask someone else to do his job/homework for him. DD |