Thank you Binyamin.
To your question about Admin stuff, that is what I had been doing
for a client a few years ago. But now, I see a need for me to do
DB2 applications stuff. But let me be clear on the Admin stuff --
I am not a DB2 DBA. I'm just a guy who can build tools that can
generate JCL/JOB(s) to do COBOL compiles, invoking any|ALL
translators needed for that compile, get it into the LNKEDT and
have it collect all the needed objects for a load module, etc.
What I need to do now is learn how DB2 does SQL, or better, SQL
specific to/for DB2.
Regards,
Steve Thompson
On 11/21/22 04:59, Binyamin Dissen wrote:
On Sun, 20 Nov 2022 18:17:42 -0500 Steve Thompson <[email protected]> wrote:
:>Anyone know of an online, at your own pace, DC2 programming class?
:>I have a need to learn DB2 SQL type programming. I used to do
:>this with Fujitsu COBOL on NT 4.0 years ago, but now I need to
:>know the specifics of the DB2 world. I know that they have to do
:>a BIND (I wrote an ISPF system that generated all the JCL to get
:>the source, expand it prior to the translators then fed it to the
:>COBOL compiler, link-edit and generated the BIND...). But I've
:>not done DB2 specific programming.
:>I currently don't have access to a system that I can use for
:>this, so I need a class that has lab(s) to do.
I would break this up into two parts, SQL and DB2 Admin Work. There are many
versions of SQL which are very close to DB2 on many platforms. That would be
the best way to start. The create table and view is also pretty similar.
Afterwards, the Admin stuff like Binds, Grants, packages and plans, I don't
know if application programmers do these , in general.
--
Binyamin Dissen <[email protected]>
http://www.dissensoftware.com
Director, Dissen Software, Bar & Grill - Israel
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
