CODE - 100 Days of Code #2

100 Days of Code

I am walking down a couple of paths depending on the day and how I feel.

I am doing a lot of COBOL/JCL and a little DB2 programming now.

ECBAP is IBM's free Enterprise COBOL for Business Application Programming.

VSCode is IBM's free Open Mainframe Project - Learn COBOL with VSCode and Zowe.

Apress COBOL is the book Beginning COBOL for Programmers by Michael Coughlan.

The Python paths are: Talk Python to Me Training, Real Python, PyBites Code Challenges, and others.

The Web Developer paths are Free Code Camp, Wes Bos, and a HTML/CSS course that was taught in a Community College.

Those paths are supplemented by books, courses and videos from various sources including Udemy.com, Lydia.com, and YouTube.

Day 39: August 13, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP:

    Apress COBOL:

    Zowe Stuff: Updated the Zowe scripts to Create a Test Database. Changed the structure of the directories, changed the code so you copy the file you want to upload into the current directory, created a "pure Zowe" version that just uses Zowe commands to do the same thing as the hybrid JCL/Zowe method. Pushed it up to GitHub.

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

Link(s) to work:

Day 38: August 12, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Attended WebEx question call-in.

    Apress COBOL: Started working on Called programs and sub-programs.

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • Had some "issues" with the compile and running script. Had to add some extra parameters but it works now.

Link(s) to work:

Day 37: August 11, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Completed Worshop 18.2. Single Level Control Break Report Program.

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • It took a bit but I was able to remember how to setup the structure of a Control Break program. I wish I had copies of the stuff I did before.

Link(s) to work:

Day 36: August 10, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Created TABLENA which demos a whole bunch of Tables and processing data with them.

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • Spend all day doing and re-doing TABLENA to be able to process Tables in COBOL. It went mostly well but there were a couple of things I forgot and/or didn't take care of the first time. It's all good now though.

Link(s) to work:

Day 35: August 9, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Did a lot of Table work. 3D tables using SUM function.

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • The ECBAP system is off-line so I can't try any DB2 stuff but I will try and create some basic pgms that I can run once it's on-line again.

    I feel good about Table walking. Now I need to work on Table Searching both normal and ALL.

    Did some simple Searching. Created TABLOAD3 to load two datasets. Will try some "complicated" searches with those.

    Small gripe: I looked for a python module to convert csv's to fixed-length. I found one that said it will convert a dict to a fixed length. I can convert csv to dict. But when I looked at the module, it can convert something to a fixed length but it wasn't a Python dict. So, I don't know whats up with that.

    Need to update the Tables Tutorial with some of the tables I have created.

Link(s) to work:

Day 34: August 8, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Worked on TABLE1 - I am trying to create, load and print every kind of table I can think of.

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • It took me a bit but I was able to do both Vertical and Horizontal Function SUM'ing on 2D tables. There is a parameter on ZOS "ALL" that is not available on gnuCOBOL. So I was able to do a lot of the calculations but I did have to go up to Z to "finish" is. I would like to take a try at SUM or other FUNCTIONS on a 3D table next. On the good side, I have some really good examples for the website Tables pages.

Link(s) to work:

Day 33: August 7, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Completed WS172A. Working on B.

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code: Finished 04-06 Collections.

    100Web:
    • Completed 05-08 Build Yaahoo! and Sign-up form.

    • Completed 09-12 API-Star Days 1 & 2.

    Flask-SQLAlchemy:

Thoughts:

  • Starting to get a better "feel" for using Jupyter in PyCharm. I actually think it helped to switch to the light theme.

    Got access to DB2 on the Mainframe today. Yea! I'll finish up the Table stuff I'm working on and try that tomorrow.

Link(s) to work:

Day 32: August 6, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP: Converted CBL0001, created ODS000C to create a non-COMP'd numbers data file.

    Apress COBOL: Converted BDS1004, ran sucessfully on OC and ZOS.

    COBOL-DB2:

    TPT-Python:

    100Code: Started 004-006 Collections but got side tracked learning how to use Notebooks in Pycharm.

    100Web:

    Flask-SQLAlchemy:

Thoughts:

  • Did a little updating to dastagg website. Added COBOL Tables entry.

    Need to add the other table examples.

Link(s) to work:

Day 31: August 5, 2020

Today's Progress:

  • Cobol-Projects:

    ECBAP:

    Apress COBOL:

    COBOL-DB2:

    TPT-Python:

    100Code:

    100Web:

    Flask-SQLAlchemy: Completed up to Chapter 10.

Thoughts:

  • Finally got Flask-SqlAlchemy to create the db. Not a Windows thing. It was because of the way the "if __name__" was setup, it wasn't running the setup_db function.

    I was also able to connect to the DB2 Sample DB through PyCharm's Database browser. Had to change the connection to the Type 4 and then it all worked.

Link(s) to work:

Day 30: August 4, 2020

Today's Progress:

  • ECBAP:

    Apress COBOL: Copied, adjusted and ran BDS1003, BDS1004 and BDS1005. I have not yet modified them to my "style".

    BDS1003 is complete.

    Python: 100Code:

    Python: 100Web:

    Python: Flask-SQLAlchemy: Completed Bootstrap Chapter and started on SQLAlchemy.

Thoughts:

  • Had a problem with MS Edge browser. I updated the nav css but it wasn't showing up.

    Installed Firefox and it displayed. Is there a problem with MS Edge?

    I also seem to have an issue with Firefox as well. I went into the settings and changed the cache setting from 3 to 1 but it's not helping much.

    Something about the refresh of the browser on Windows. Maybe I need to install Chrome?

    Also having a problem creating the Sqlite DB as per the video. Again, maybe it's a Windows thing.

Link(s) to work:

Day 29: August 3, 2020

Today's Progress:

  • ECBAP: Updated rme4.

    Apress COBOL: BDS1002: OC and ZOS.

    Python: 100Code: Completed Days 1-3: Playing with Datetimes.

    Python: 100Web: Completed Days 1-3: Flask Intro. Need to finish Flaskr.

Thoughts:

  • Attended (online): IDz Webinar class with Jon: Module 4.

Link(s) to work:

Day 28: August 2, 2020

Today's Progress:

  • ECBAP: Completed Workshop 16.2 e Optional version

    Apress COBOL: None

Thoughts:

Link(s) to work:

Day 27: August 1, 2020

Today's Progress:

  • ECBAP: More work on Workshop 16.2

    Add INTEG1 test

    Apress: None

Thoughts:

Link(s) to work:

Day 26: July 31, 2020

Today's Progress:

  • ECBAP: Started Workshop 16.2

    Apress: None

    DB2: Uninstalled and re-installed the server

    Changed the default DB from MYSERVER back to SERVER

Thoughts:

Link(s) to work:

Day 25: July 30, 2020

Today's Progress:

  • ECBAP: Add extra programs for Modules 13 and 14

    Add TRIM1 pgm

    Apress: None

    DB2: Created and pushed the DB2-Cobol-et-al repo

Thoughts:

Link(s) to work:

Day 24: July 29, 2020

Today's Progress:

  • ECBAP: Module 13 Workshops

    Completed Workshop 15.2

    Apress: None

    DB2: Created some test programs

Thoughts:

Link(s) to work:

Day 22: July 27, 2020

Today's Progress:

  • ECBAP: None

    Apress: None

Thoughts:

  • Started working on installing an IBM DB2 server on Windows.

Link(s) to work:

  • None for this entry

Day 20: July 25, 2020

Today's Progress:

  • ECBAP: None

    Apress: None

Thoughts:

  • More work into getting to know the Windows environment.

    Getting Git, Cygwin and other tools installed.

Link(s) to work:

  • None for this entry

Day 19: July 24, 2020

Today's Progress:

  • ECBAP: Completed Mid-Term Project

    Apress COBOL: Started BDS1001

Thoughts:

  • I started to "convert" over to a Windows 10 PC.

    I was having issues running IBM IDz on Arco Linux. So I started using Windows.

Link(s) to work:

Day 18: July 23, 2020

Today's Progress:

  • ECBAP: Completed

    Clean up of code.

Thoughts:

Link(s) to work:

  • None for this entry

Day 17: July 22, 2020

Today's Progress:

  • ECBAP: Completed

    Workshops 8.1(a, b, and c)

    Workshop 8.1d

    Workshop 8.1e

Thoughts:

Link(s) to work:

Day 16: July 21, 2020

Today's Progress:

  • ECBAP: Completed

    The remainder of Module 6

    Workshop 7.2 + Optional

Thoughts:

Link(s) to work:

Day 15: July 20, 2020

Today's Progress:

  • ECBAP: Completed

    Workshop 6.3

    Workshop 6.3a and 6.3o

    Workshop 6.4

Thoughts:

Link(s) to work:

Day 14: July 19, 2020

Today's Progress:

  • ECBAP: Completed Workshop 5.3.2

Thoughts:

Link(s) to work:

Day 13: July 18, 2020

Today's Progress:

  • ECBAP: Completed Workshop 4.4

Thoughts:

Link(s) to work:

Day 11: July 16, 2020

Today's Progress:

  • ECBAP: Update COBUCLG.jcl to better format.

    Add ALLOCATE.jcl

    Add README4.md

    Update READMEs.

Thoughts:

Link(s) to work:

Day 01: July 6, 2020

Today's Progress:

  • ECBAP: Completed

    Maintenance Workshop 4.1.

    Optional Workshop 4.2a.

Thoughts:

Link(s) to work: