My year in exercise defines the phrase that one cannot out-exercise a body diet or habits. This week on a bloated day, I hit 198 pounds. I have been trying to reboot my diet for the last two years. I am not a big fan of fat acceptance.

I am going to challenge myself to a modified 75 hard.

First off what is 75 hard:

The 75 Hard challenge was created by called Andy Frisella and goes along the lines out of 'challenging' yourself because it will help you figure out who you really are and how mentally tough you are.

The challenge consists of the following tasks, which must be completed every day without exception:

• Two 45-minute workouts (you define what the workouts are)

• Drink 1 gallon of water

• Read 10 pages of a personal development/business/self-help book

• Stick to a diet (you define the diet)

• No alcohol or cheat meals

• Take a progress picture

There are also a few rules:

• You must complete all 75 days in a row; if you miss a single day you fail. Failure means any deviation from your plan, in the strictest sense. No substitutions, no catch-up days, no excuses.

• If you fail, you must start over on day 1

• One of the daily workouts must be outside, no matter what the weather conditions are

• Audiobooks do not count toward the reading goal

• The day ends when you go to bed

Cool, the problem for me, is that most likely I will not be able to get my other tasks done. I have tasks that I falling behind in. I have no plans of doing another 45-minute exercise session if I bike 60 miles to Faria Beach, jog 8 miles, or bike to Gibraltar peak (extreme example). I am in reading burnout from work (more than 10 pages of manuals). Besides, for the most part, metal toughness is not what I need. I need to get back into a routine. I plan to modify the goals along the line of this entry from Hoyle's Fitness.

• Dietary Discipline – Eating well. Only drinking on social occasions, not at home

• Train Every Day – 75 days without a day off. Active recovery counts

• Drink 3 liters of Water per Day – Nothing but clear, plain water counts

• Read 10 Pages per Day – From a non-fiction self-help book or business book

• Take a Progress Picture Every Day – So you can see the progress at the end

• Complete a full 10,000 steps per day

I think it would not hurt to start posting some of the work I do for my employer. Nothing will be company confidential. There is almost nothing company confidential when you work for a public institution with a few exceptions of FERPA, PII, student records, etc.

One of the tasks that I was asked to do is to integrate data from the SBCC BANNER ERP system with Verba's Inclusive Access system. The project was simple.

• Create a population-based on student enrolment

• Create a sample file

• Create key file for sftp

• automate

Currently, I have to do is automate in ISE. This will have to wait till next week when the move Banner to Oracle Cloud project is done.

This is the code that I create (in a procedure for work, this so I can run it manually).

BTW, should this be in a GitHub gist or this good enough? I like GitHub, but there is a part of me that prefers to keep things local.

declare
        --set up output parameters

        gbcn_outfilepath   CONSTANT VARCHAR2(64) := 'SBCC_OUTGOING';
        v_file_name_s      VARCHAR2(64) := 'ia_enrollment' || '.csv';
        v_fh_s             utl_file.file_type;
        v_outbuf           VARCHAR2(4000);
        v_cat_count        INT(2) := 0;


        CURSOR c_students IS SELECT
                sfrstcr_term_code catalog_name,
                ssbsect_subj_code department_name,
                ssbsect_crse_numb course_number,
                sfrstcr_crn section_code,
                gzf_get_id(sfrstcr_pidm) student_identifier,
                gzf_format_name(sfrstcr_pidm,'PREFF') student_first_name,
                gzf_format_name(sfrstcr_pidm,'L') student_last_name,
                gzf_email_addr(sfrstcr_pidm,'SBCC') student_email_address
                                                 FROM
                sfrstcr
                INNER JOIN stvrsts ON sfrstcr_rsts_code = stvrsts_code
                LEFT OUTER JOIN ssbsect ON ( ssbsect_term_code = sfrstcr_term_code
                                                                         AND ssbsect_crn = sfrstcr_crn )
                                                 WHERE
                sfrstcr_term_code IN (
                        SELECT
                                stvterm_code
                        FROM
                                stvterm
                        WHERE
                                stvterm_code <> '999999'
                                AND stvterm_end_date > SYSDATE
                        INTERSECT
                        SELECT
                                goriccr_value
                        FROM
                                goriccr
                        WHERE
                                goriccr_icsn_code = 'ACTIVE_TERM'
                );

BEGIN
        -- open file
        v_fh_s := utl_file.fopen(gbcn_outfilepath,v_file_name_s,'w');

        --header record
        utl_file.put_line(v_fh_s,'"catalog_name","department_name","course_number","section_code","student_identifier","student_first_name","student_last_name","student_email_address"');

        --write data
        FOR v_students IN c_students LOOP
                v_outbuf := '"'
                                        || v_students.catalog_name
                                        || '",'
                                        || '"'
                                        || v_students.department_name
                                        || '",'
                                        || '"'
                                        || v_students.course_number
                                        || '",'
                                        || '"'
                                        || v_students.section_code
                                        || '",'
                                        || '"'
                                        || v_students.student_identifier
                                        || '",'
                                        || '"'
                                        || v_students.student_first_name
                                        || '",'
                                        || '"'
                                        || v_students.student_last_name
                                        || '",'
                                        || '"'
                                        || v_students.student_email_address
                                        || '"';

                utl_file.put_line(v_fh_s,v_outbuf);
        END LOOP;

        --close file
        utl_file.fclose(v_fh_s);
end;

John 8:7 NABRE But when they continued asking him, he straightened up and said to them, “Let the one among you who is without sin be the first to throw a stone at her.”1

References

1

“John 8:7 (NABRE).” Bible Gateway, www.biblegateway.com/passage/?search=John+8%3A7&version=NABRE. Accessed 24 June 2020.