Home > Archive > Cobol > May 2006 > Static or Dynamic Call.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Static or Dynamic Call.
|
|
| arrbee 2006-05-03, 7:55 am |
| 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
| |
| Binyamin Dissen 2006-05-03, 6:55 pm |
| 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 answers?
--
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
| |
| arrbee 2006-05-04, 3:55 am |
| 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
| |
| Michael Mattias 2006-05-04, 7:55 am |
| <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
| |
| Michael Mattias 2006-05-04, 7:55 am |
| <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...[color=darkred]
value[color=darkred]
>
> Well... *you* would, now wouldn't you, Mr Mattias.
>
desk[color=darkred]
>
> 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
| |
| Pete Dashwood 2006-05-07, 6:55 pm |
|
"arrbee" <arrbee@gmail.com> wrote in message
news:1146716121.417751.80700@e56g2000cwe.googlegroups.com...
> 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?
Yes, Ram, you should. At least for now.
I understand why you are asking the questions and I also understand why you
are getting the responses you are getting.
It is not your fault or the fault of the people here.
You need to learn how to teach yourself. That means reading the manuals and
learning where and how to look stuff up. If you read through the DB2 manual
you would be much better equipped to ask questions.
The questions you are asking are so basic that people here are assuming you
must be a student trying to get his homework done for him. You need to get
some basic understanding of the tools you are being required to use. Your
employer should not throw you in at the deep end with no training, but,
 ly, many employers do. You therefore need to learn to acquire knowledge
quickly by reading. That is a difficult skill when English is not your first
language. But you must persevere at it.
Get hold of the DB2 manual and read it. Learn about tables and the interface
via ESQL which allows them to be accessed. Understand what the precompiler
does, and why it is required.
I might have some very basic stuff that I used for students some years back.
I'll try and find it and mail it to you, privately.
Remember when you post here that there is no obligation on the forum to
respond with answers. It is not a right, it is a privelege.
You are asking professional people (who are seeing their jobs moving to
India), to help you, for free.
The amazing thing (well, I find it amazing...:-)) is that there is enough
generosity of spirit among programmers to actually assist you. But before
doing so, people want to know that you have put in time yourself trying to
solve the problems. They expect you to have covered the basics. From your
posts, it doesn't appear that you have. It may be that you don't have access
to the manuals, or the language is too much of a problem, or a number of
factors, but if you expect to get answers here you must persuade the forum
that you deserve an answer.
My advice would be to withdraw for now and do some reading. If you cannot
understand what you are reading, then post for clarification.
The people here are not mean spirited; they just need to see that you have
done the initial learning.
Hit the books, and good luck!
Pete.
>
>
| |
| Pete Dashwood 2006-05-07, 6:55 pm |
|
"Michael Mattias" <michael.mattias@gte.net> wrote in message
news:Ham6g.1628$fb2.1415@newssvr27.news.prodigy.net...
> <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.....
>
> 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).
>
LOL! I was going to respond by advising the Doc to visit your site, Michael,
but you beat me to it... :-)
Pete.
| |
|
| In article <h3n6g.72737$H71.57146@newssvr13.news.prodigy.com>,
Michael Mattias <michael.mattias@gte.net> wrote:
><docdwarf@panix.com> wrote in message news:e3csvt$scu$1@reader1.panix.com...
[snip]
>
>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.
Hmmmmm... time to start searching the web to find out how to hook this
into the 3278 terminal I get to use... did you know that if I hold my hand
up in front of it I can see all the bones?
DD
| |
| Michael Mattias 2006-05-07, 6:55 pm |
| <docdwarf@panix.com> wrote in message news:e3d3hf$rh0$1@reader1.panix.com...
> In article <h3n6g.72737$H71.57146@newssvr13.news.prodigy.com>,
> Michael Mattias <michael.mattias@gte.net> wrote:
news:e3csvt$scu$1@reader1.panix.com...[color=darkred]
>
> [snip]
>
but[color=darkred]
>
> Hmmmmm... time to start searching the web to find out how to hook this
> into the 3278 terminal I get to use... did you know that if I hold my hand
> up in front of it I can see all the bones?
I don't do hardware.
(But I do... do Windows(r)!)
MCM
| |
|
| In article <Wqo6g.1662$fb2.1351@newssvr27.news.prodigy.net>,
Michael Mattias <michael.mattias@gte.net> wrote:
><docdwarf@panix.com> wrote in message news:e3d3hf$rh0$1@reader1.panix.com...
[snip]
>
>
>I don't do hardware.
I'm not sure what this 'doing' might be, Mr Mattias... but I've found the
need to make use of hardware in order to perform the tasks for which my
clients pay me.
DD
| |
| Howard Brazee 2006-05-07, 6:55 pm |
| On Thu, 4 May 2006 14:50:09 +0000 (UTC), docdwarf@panix.com () wrote:
>
>I'm not sure what this 'doing' might be, Mr Mattias... but I've found the
>need to make use of hardware in order to perform the tasks for which my
>clients pay me.
Mercenary.
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
| |
|
| In article <os8k52tm2puae6mp72qj3k1fprtkhlbffe@4ax.com>,
Howard Brazee <howard@brazee.net> wrote:
>On Thu, 4 May 2006 14:50:09 +0000 (UTC), docdwarf@panix.com () wrote:
>
>
>Mercenary.
I've never made any secret of the way the will of One Who Signs My
Timesheets figures into the way that I perform my job, Mr Diss... Mr
Brazee; one who is motivated by love is, by etymology, an amateur.
DD
| |
| William M. Klein 2006-05-07, 6:55 pm |
| >>Thanks Holly. I tell you why such questions come up. All these years I
>
> 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?
Boy, has it been YEARS since I had to figure that stuff out. Maybe *I* need to
stop answering (IBM) mainframe COBOL questions!!! (But I would know where to
look for manuals and programming guides with "hints").
--
Bill Klein
wmklein <at> ix.netcom.com
<docdwarf@panix.com> wrote in message news:e3ci0o$mq$1@reader1.panix.com...
| |
|
| Hey I just saw your website and the Provider Payment Partner System-
that is so  !. Isn't HIPAA fun? Do you guys plan on creating any
other software that handles other EDI types in the future, maybe HL7
mapping? Most impressed.
| |
| Clark Morris 2006-05-07, 6:55 pm |
| On Thu, 04 May 2006 20:25:16 GMT, "William M. Klein"
<wmklein@nospam.netcom.com> wrote:
>
>Boy, has it been YEARS since I had to figure that stuff out. Maybe *I* need to
>stop answering (IBM) mainframe COBOL questions!!! (But I would know where to
>look for manuals and programming guides with "hints").
This of course is IBM z/OS (OS390) environment only.
The fun comes when the manuals misleadeth or lieth. Most of the manual
give too low a size for the Index CI (control interval or data block)
size when the key does not lend itself to compression thus wasting
space in the CA (control area or space allocated for a group of
control intervals). Determining good values for this depends on
record length, type of updating - are the updates clustered around a
given value or random, etc. which also affect the free space
percentages that are best. Also look at the growth in CA and CI
splits over a period to determine how often to reorganize a file. In
some cases there is an initial large split activity followed by mostly
low volume of split activity. In this case minimize reorganizations.
| |
| Michael Mattias 2006-05-07, 6:55 pm |
| "Holly" <anderschwan@hotmail.com> wrote in message
news:1146787205.499927.134740@e56g2000cwe.googlegroups.com...
> Hey I just saw your website and the Provider Payment Partner System-
> that is so !. Isn't HIPAA fun? Do you guys plan on creating any
> other software that handles other EDI types in the future, maybe HL7
> mapping? Most impressed.
Thank you for your kind words. Now tell your provider friends about it.
As to 'other documents'...
I have an API for both the X096A1(Faciilty) and X098A1 (professional) '837
Claim or Encounter' documents, which parses out the 837 and stores every
possible data item discretely. Function calls are provided to get any field
or logical table row you want.
I also market the EDI Pal(tm) ANSI EDI Viewer-Editor-Printer. For only
$159.00 (qty 1) it's a great way to see and print ANSI ASC X12 EDI data, or
modify existing documents to create EDI 'test data' or extract & re-envelope
one transaction set from a big file.
I have pretty much focused on "EDI-related" applications in the distribution
and manufacturing industries since about 1994, and added healthcare in about
1996 (when the HIPAA was passed. No, it wasn't implemented for another four
of five years, but the industry is FINALLY getting the standard EDI
transactions implemented on a broad basis)
I have no plans to do any kind of 'canned' product for HL7 or any other
format. But I provide contract design/mapping services using the
Mercator/DataStage TX/Websphere Mapping product, which handles 'any-to-any'
about as well as anything on Mother Earth (and at that price it damn well
better!), and I know some folks use Mercator for HL7 applications.
Got something in mind? You can always ask. If I can't do it I will tell you.
--
Michael Mattias
Tal Systems, Inc.
Racine WI
mmattias@talsystems.com
http://www.talsystems.com
| |
|
| In article <Lqt6g.312867$117.137696@fe02.news.easynews.com>,
William M. Klein <wmklein@nospam.netcom.com> wrote:
>
>Boy, has it been YEARS since I had to figure that stuff out.
Well, Mr Klein... it may have been a like number of years since you made
a claim like 'All these years I have been working on JCL, VSAM, COBOL',
also.
>Maybe *I* need to
>stop answering (IBM) mainframe COBOL questions!!! (But I would know where to
>look for manuals and programming guides with "hints").
The hints also have to do with different file uses... in DB2, for example,
system design changes on how the users will be accessing the data (OLTP vs
mining). It may or may not be that such considerations might have an
effect on what CA/CI value one chooses, neh?
Note that I am *not* asking for a particular number... just what is to be
considered when choosing one. I'm not looking for The Answer, that can be
found in a text or on the web... I'm looking to be shown how someone
thinks.
DD
| |
| Joel C. Ewing 2006-05-07, 6:55 pm |
| Clark Morris wrote:
> On Thu, 04 May 2006 20:25:16 GMT, "William M. Klein"
> <wmklein@nospam.netcom.com> wrote:
>
>
> This of course is IBM z/OS (OS390) environment only.
>
> The fun comes when the manuals misleadeth or lieth. Most of the manual
> give too low a size for the Index CI (control interval or data block)
> size when the key does not lend itself to compression thus wasting
> space in the CA (control area or space allocated for a group of
> control intervals). Determining good values for this depends on
> record length, type of updating - are the updates clustered around a
> given value or random, etc. which also affect the free space
> percentages that are best. Also look at the growth in CA and CI
> splits over a period to determine how often to reorganize a file. In
> some cases there is an initial large split activity followed by mostly
> low volume of split activity. In this case minimize reorganizations.
Since at least z/OS 1.4, the algorithm used to calculate the default
(and minimum) Index CI size was revised so it is now highly unlikely
that you can even force an inadequate Index CI size to be assigned.
There is also a PTF available on z/OS 1.6 that enhances the IDCAMS
utility so that EXAMINE INDEXTEST on a KSDS VSAM dataset will now give
statistics on how much space is actually used for compressed keys in the
INDEX -- you no longer need to guess whether INDEX CI size is an issue.
On current z/OS systems it should rarely, if ever, be necessary to
specify INDEX CISIZE.
I also get ticked off at vendor examples that redundantly specify names
for the KSDS DATA and INDEX components with the last qualifier of
"DATA" and "INDEX", which has been the MVS default for at least 20
years; or an explicit INDEX space requirement of CYLINDERS(1) for a KSDS
with 2 DATA CA's, which only needs a fraction of 1 track for an INDEX;
or "IMBED" or "REPLICATE" attributes, which have not been recommended
for 15 years and have been ignored for at least the last 5 years. These
days, 99% of the time you shouldn't even need to specify an "INDEX"
section when defining a KSDS VSAM dataset, as the defaults are fine.
When I see inappropriate or redundant attributes in documentation, its
tells me the author lacks a basic understanding of current KSDS VSAM
best practices.
--
Joel C. Ewing, Fort Smith, AR jREMOVEcCAPSewing@acm.org
| |
|
| In article <jOT6g.7431$An2.7176@newsread2.news.pas.earthlink.net>,
Joel C. Ewing <jcREMOVEewing@CAPSacm.org> wrote:
>Clark Morris wrote:
[snip]
[color=darkred]
>Since at least z/OS 1.4, the algorithm used to calculate the default
>(and minimum) Index CI size was revised so it is now highly unlikely
>that you can even force an inadequate Index CI size to be assigned.
>There is also a PTF available on z/OS 1.6 that enhances the IDCAMS
>utility so that EXAMINE INDEXTEST on a KSDS VSAM dataset will now give
>statistics on how much space is actually used for compressed keys in the
>INDEX -- you no longer need to guess whether INDEX CI size is an issue.
How very interesting... but I've noticed that the fellow who made the
claim, originally, that his experience is in JCL, VSAM and COBOL so he
just *had* to ask 'experts' questions posed to him by an interviewer about
CICS and DB2 has been... strangely silent.
A pity he wasn't willing or able to 'share knowledge', I guess.
DD
| |
| arrbee 2006-05-07, 6:55 pm |
| Yes. That is correct.
| |
|
| In article <1146898620.088440.221100@e56g2000cwe.googlegroups.com>,
arrbee <arrbee@gmail.com> wrote:
>Yes. That is correct.
Beg pardon, old boy, but what are you calling 'correct' here... the fact
that you've fallen strangely silent upon being asked a Standard Question
about things for which you've claimed knowledge or... something else?
(It might do one well to keep in mind that one asks 'experts' about
matters because the 'experts' are able to see things that non-experts
cannot.)
DD
|
|
|
|
|