Static or Dynamic Call.

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.

In article <1146655537.010440.224890@i40g2000cwc.googlegroups.com>,
arrbee <arrbee@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

On 3 May 2006 04:25:37 -0700 "arrbee" <arrbee@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 answer
s?

--
Binyamin Dissen <bdissen@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.

Here ya go dude, here are some links you need to know.  Quickly.
http://www.pdc.kth.se/doc/SP/manual...2l0/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!

In article <1146690299.881625.152150@u72g2000cwu.googlegroups.com>,
Holly <anderschwan@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

Thanks Holly. I tell you why such questions come up. All these years I
have been working on JCL, VSAM, COBOL. Ok. Now, I am put into a project
where it involves DB2, IMS/DB, CICS, CA-7. So, I've always asked the
questions in the trainee point of view only. I always got HARD HITTING
answers from this forum (Thanks to DOCDWARF).
Perhaps, I should've joined this forum once I become expert.....:-)

Am I at wrong place (forum)? Some people are generous to give answers.
Many are not so. I pity this.

If I knew something then why would I ask a query here unless it is very
critical to me !!! I presume no expert asks a question here in this
forum!? It is sure that once has to struggle to master a subject. But,
one cannot keep doing mistakes till last minute.

Should I quit this forum?

In article <1146716121.417751.80700@e56g2000cwe.googlegroups.com>,
arrbee <arrbee@gmail.com> wrote:
>Thanks Holly. I tell you why such questions come up. All these years I
>have been working on JCL, VSAM, COBOL.

You have?  You seem to hide your experience very well... but here is a
chance to shine.  What considerations do you make before applying a
particular CA/CI value?

[snip]

>It is sure that once has to struggle to master a subject.

Maybe I've been missing something... can you point towards a posting which
shows you doing this kind of 'struggling'?

[snip]

>Should I quit this forum?

There is a difference between quitting a kind of behavior and quitting the
behaving of it in a certain place.  What you might want to quit is the
behavior that has been pointed out to you, repeatedly, as being of the
'please do my job/homework' variety.

DD

<docdwarf@panix.com> wrote in message news:e3ci0o$mq$1@reader1.panix.com...
>  What considerations do you make before applying a  particular CA/CI value
[to a VSAM definition]?

Ooh, Ooh, I know that one.. at least a big part of it.....

But to actually do it without having to do all that arithmetic on your desk
calculator ( or longhand) , you go to my web site at
http://www.talsystems.com, click on "Tech Corner", and download the
VSAMSPACE utility in either EXE or ZIP format.

(yes, totally free!)

(Maybe someone will prod me into updating the "available drive model"
tables).

--
Michael Mattias
Tal Systems, Inc.
Racine WI
mmattias@talsystems.com

In article <Ham6g.1628$fb2.1415@newssvr27.news.prodigy.net>,
Michael Mattias <michael.mattias@gte.net> wrote:
><docdwarf@panix.com> wrote in message news:e3ci0o$mq$1@reader1.panix.com...
 
>[to a VSAM definition]?
>
>Ooh, Ooh, I know that one.. at least a big part of it.....

Well... *you* would, now wouldn't you, Mr Mattias.

>
>But to actually do it without having to do all that arithmetic on your desk
>calculator ( or longhand) , you go to my web site at
>http://www.talsystems.com, click on "Tech Corner", and download the
>VSAMSPACE utility in either EXE or ZIP format.
>
>(yes, totally free!)

Most generous of you, Mr Mattias, and I'll grab a copy... just for...
ummmm... yes, research and experimental purposes, that's the ticket... but
what's this 'EXE' format stuff and how do I specify it in my JCL?  Might
be time to break out the pencil and do a little cypherin'... carry the
two, multiply by 1024... that 3380/3390 ratio is 39825/50085 bytes/pack,
y'know... check for a non-zero value before the divide, too...

... an' don't get me started on what them kids nowadays is callin'
'music', neither... buncha durned noise, 'f ya ask me...

DD

<docdwarf@panix.com> wrote in message news:e3csvt$scu$1@reader1.panix.com...
> In article <Ham6g.1628$fb2.1415@newssvr27.news.prodigy.net>,
> Michael Mattias <michael.mattias@gte.net> wrote: 
news:e3ci0o$mq$1@reader1.panix.com... 
value 
>
> Well... *you* would, now wouldn't you, Mr Mattias.
> 
desk 
>
> Most generous of you, Mr Mattias, and I'll grab a copy... just for...
> ummmm... yes, research and experimental purposes, that's the ticket... but
> what's this 'EXE' format stuff and how do I specify it in my JCL?

I guess I should have pointed out (here, it does say so at the web site)
that the VSAMSPACE utility is Windows/32 desktop software. But it's still
free for personal use.

MCM