Difference between revisions of "BAC344 03 2011"

From CDOT Wiki
Jump to: navigation, search
(Due Dates)
(Class Notes)
 
(15 intermediate revisions by 4 users not shown)
Line 35: Line 35:
 
* [https://cs.senecac.on.ca/~cindy.laurin/BAC344_Class_Std.doc Course Standards]
 
* [https://cs.senecac.on.ca/~cindy.laurin/BAC344_Class_Std.doc Course Standards]
 
* [https://cs.senecac.on.ca/~cindy.laurin/File%20Status%20Codes.doc File Status Codes and Their Meanings!]
 
* [https://cs.senecac.on.ca/~cindy.laurin/File%20Status%20Codes.doc File Status Codes and Their Meanings!]
* [http://proquest.safaribooksonline.com/9780471418467 File Text Book]
+
* [http://proquest.safaribooksonline.com/book/programming/cobol/9780471418467 File Text Book]
 
* [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_Requirements_Fall_2011.doc File Project Initiation Document]
 
* [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_Requirements_Fall_2011.doc File Project Initiation Document]
  
Line 45: Line 45:
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_1_Fall_2011.doc 1] || Sept 9 || 1 || Oct 12
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_1_Fall_2011.doc 1] || Sept 9 || 1 || Oct 12
 
|-
 
|-
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_2_Fall_2011.doc 2] || Sept 23 || 2 || Nov 14
+
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_2_Fall_2011.doc 2] || Sept 23 || 2 || Nov 16
 
|-
 
|-
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_3_Fall_2011.doc 3]  || Oct 7 ||  ||
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_3_Fall_2011.doc 3]  || Oct 7 ||  ||
Line 56: Line 56:
 
|-
 
|-
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_7_Fall_2011.doc 7] || Dec 9 ||  ||
 
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_7_Fall_2011.doc 7] || Dec 9 ||  ||
|-
 
| 7 || Oct 31 || Demonstration ||  ||  ||
 
|-
 
| 8 || Nov 7 || Demonstration ||  ||  ||
 
|-
 
| 9 || Nov 14 || Demonstration ||  ||  ||
 
|-
 
| 10 || Nov 21 || Demonstration ||  ||  ||
 
|-
 
| 11 || Nov 28 || Demonstration ||  ||  ||
 
|-
 
| 12 || Dec 5 || Demonstration ||  ||  ||
 
 
|-
 
|-
 
|}
 
|}
Line 74: Line 62:
 
{| border="1" cellpadding="5"
 
{| border="1" cellpadding="5"
  
! Week !! Lecture Topic
+
! Week !! Lecture Topic || Text Book Material
 
|-
 
|-
| 1 ||Introduction to IBM i: signing on, using menus, libraries, library lists, objects, SEU, creating a CL program.
+
| 1 ||
+
* The System I environment
Lecture Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect1_fall_2011.ppt
+
* Cobol Program Structure and Programming
+
 
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week1_1.ppt Class 1]
At Home:    Install Client Access and RDI
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week1_2.ppt Class 2]
+
||
Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week1_notes.docx
+
Chapters 1, 2 and 3
 +
 
 
|-
 
|-
 
| 2 ||
 
| 2 ||
* Library Lists
+
* Cobol Verbs
* Intro to RDI
+
* Display File Review
* Physical Files
 
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect2_fall_2011.ppt
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week2_2.doc Class 1]
 
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week2_1.ppt Class 2]
Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week2_notes.docx
+
||
 
+
Chapters 4, 5, 6 and 14
                        DDS Reference: https://cs.senecac.on.ca/~cindy.laurin/dds_reference.doc
 
 
|-
 
|-
 
| 3 ||
 
| 3 ||
RPG Programming with Display Files
+
* Selection Statements
 
+
* Indicators
Class Notes:          https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect3_fall_2011.ppt
+
* Function Keys
 
 
Reference Material: https://cs.senecac.on.ca/~cindy.laurin/ibc233_reference.doc
 
  
Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review1.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week3_1.doc Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week3_2.ppt Class 2]
 +
||
 +
Chapters 8 and 14
 
|-
 
|-
 
| 4 ||
 
| 4 ||
CL Programming with Display Files
+
* Conditions
 
+
* Iteration
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect4_fall_2011.ppt
+
* Logical Files
 
+
* Random Reads
Reference Material:
 
IBM DDS manual: Display Files: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzakc/rzakcmst02.htm       
 
  
Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review2.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week4_1.ppt Class 1]
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week4_2.doc Class 2]
Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week3_notes.docx
+
||
 +
Chapters 8, 9, 10, 11 and 14
 
|-
 
|-
 
| 5 ||
 
| 5 ||
CL Programming with Display Files
+
* File Access Techniques
 
 
Class Notes: ibc233_lect5_fall_2011.ppt
 
  
Review: ibc233_review3.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week5_1.ppt Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week5_2.doc Class 2]
 +
||
 +
Chapters 8, 9, 10, 11 and 14
 
|-
 
|-
  
 
| 6 ||
 
| 6 ||
Database Design
+
* ILE Functions
 
+
* INDARA and SI
Data Representatives
+
* Condition Names
 +
* Iteration
 +
* Logical Files
 +
* Positioning the file Pointer
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect6_fall_2011.ppt
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week6_1.ppt Class 1]
 
+
||
                Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review3.doc
+
Chapters 14
 
|-
 
|-
 
| 7 ||
 
| 7 ||
System Configuration
+
* Reporting
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect7_fall_2011.ppt
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week7_1.ppt Class 1]
 
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week7_2.doc Class 2]
                Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review4.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/Printer_Spacing_Chart.xls Printer Spacing Chart]
 +
||
 +
Chapters 4
 
|-
 
|-
 
| 8 ||
 
| 8 ||
Creating a CLLE command
+
* Reporting example
 
+
* Math in COBOL
        RPGLE Programming with database files
 
 
 
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect8_fall_2011.ppt
 
 
 
                Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review4.doc
 
  
                Query Notes: https://cs.senecac.on.ca/~cindy.laurin/query_options.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week8_1.ppt Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week8_2.doc Class 2]
 +
||
 +
Chapters 4
 
|-
 
|-
 
| 9 ||
 
| 9 ||
Menus, Security and Report Writer
+
* Arrays
 
 
  Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect9_fall_2011.ppt
 
  
                Review1: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review5.doc
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week9_1.ppt Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week9_2.doc Class 1 Example]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week10_1.ppt Class 2]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week10_2.doc Class 2 Example]
  
                Review2: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review6.doc
+
||
 +
Chapters 15 and 16
 
|-
 
|-
 
| 10 ||
 
| 10 ||
RPGLE Business Application
+
* Multi Dimensional Arrays
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect10_fall_2011.ppt
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week10_1.ppt Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week10_2.doc Class 1 Example]
  
 +
||
 +
Chapters 15 and 16
 
|-
 
|-
 
| 11 ||
 
| 11 ||
Calling Programs and Overriding Files
+
* Control Breaks and Passing Parameters
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect11_fall_2011.ppt
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week12_1.ppt Class 1]
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week11_1.ppt Class 2]
  
 +
||
 +
Chapters 12, and 19
 
|-
 
|-
  
 
| 12 ||
 
| 12 ||
Query/400 and DFU
+
* SQL
 +
 
 +
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week11_2.ppt Class 1]
  
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect12_fall_2011.ppt
+
||
  
 
|-
 
|-
 
| 13 ||
 
| 13 ||
Review
+
*Review
 
+
[https://cs.senecac.on.ca/~cindy.laurin/BAC_Week13_1.ppt Class 1]
Class Notes:
 
 
 
 
|-
 
|-
  
Line 190: Line 189:
 
|}
 
|}
  
= Labs =
+
= General Discussion =
 
 
== Lab 1 ==
 
 
 
Edit by Paul:
 
Here is a Step by step Guide to connecting to Zeus From Home:
 
    1. Go to the ACS seneca web page: https://acs.senecac.on.ca/pages/index.php
 
    2. Go to download / type information that is needed to log in.
 
    3. Go to the iSeries Link, and Download IBM Client Access Version5 R4 (ISO image file)
 
    4. Once completed either burn the disc and install that way, or use a free trail version of
 
      daemon tools, its a little hard to find the download link but it comes with 20days free (I
 
      choose the lite version.
 
    5. Once installed go to your start menu and Click IBM iSeries Access for Windows unless you have
 
      changed it, then go to sublink Emulator, and click start or Configure Session.
 
    6. One the new window pops up click NEW Session
 
    7. A window should pop up, their you can click properties and in the first box type: zeus.senecac.on.ca
 
     
 
    8. Now to set your UserID just click the drop box and choice the 3rd option "Use Default UserId, and prompt
 
      as needed", then type your userId
 
      not your learn id, but the userId handed out during class.
 
    9. Once this is set up you can connect.
 
 
 
In addition to the written instructions above I located this online video for loading the Client Access portion.
 
        <u>https://senema.senecac.on.ca/videos/678/how-to-install-as-400-client-access</u>
 
  
 +
Post anything relevant
  
 +
I was wondering if any body knew how to gain access to cindy's source code on green screen?
 +
Any help would be appreciated.
 +
Thank you. - Saulius Grybas
  
IMPORTANT NOTE, Remember your password needs to be in CAPS.
+
Hi Saulius,
  
Awesome job Paul!  I'm not sure if you're password needs to be in caps - it shouldn't be case sensitive.  I type so automatically, that I don't pay attentionDoes anyone else have a comment?
+
At the command line, type WRKOBJPDM WF344A40Type 12 beside QCBLLESRC and then browse what ever you like!
  
 
Cindy
 
Cindy
 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
 
Dear all, I experienced a challenge installing the green screen V5R4M0 software on my home computer which runs the Windows home 7 operating system.  Ultimately, what worked for me was to install the green screen V5R4M0 software on a virtual machine that was running Windows XP home edition.
 
 
Best, Vincent
 
 
************************************************************************
 
<u>'''Trouble with login to ZEUS.'''</u>
 
: If you have visual studio loaded on you PC the '''''ENTER''''' key does not complete the input to the server.  It advances the cursor to the next valid entry input field.  This makes it impossible to enter your loginID and password.
 
 
The solution is to select the ''Remap Keyboard Functions'' icon from the Client Access Window and click on the ENTER key in the image of the QWERTY keyboard.  Then in the Change Current Actions for Selected Key area of the same screen change the Base value to [Enter].  That should fix it.
 
 
== Lab 2 ==
 
The rdp.iso file which is 937MB contains a version of LAUNCHER.EXE which is not supported on a PC running Win7 or Vista OS.  This is according to The IBM website. Down load the version of the RDp.ISO file from acs.senecac.on.ca.  It has a file size of 1.18GB.  You may have trouble running launcher by double clicking the EXE file.  You must have admin rights AND you must right click the EXE file and run as administrator.  The program will take about 30 seconds to load when running off a DVD drive.
 
 
If you use the RDp.ISO file from the ACS server make sure you use the activation program from the ACS server also, do not be tempted to use an activation file from another source.  The activation.ISO file must be transferred to a DVD or CD, you cannot extract it to the hard drive as the text file suggest.  The file you need to activate the RDp software is called 'com.ibm.rdpower.rpgtools.pek.jar'.
 
 
== Lab 3 ==
 
 
== Lab 4 ==
 
Original Post:
 
So, i hope i'm putting this in the right area, but does anyone out there understand how to find out or 'prompt' was qiplsts does?
 
 
Edit:
 
>> I'm not sure where you would be using QIPLSTS - that is the status of the Initial program load. QIPLTYPE (as indicated on page 9 of lab4 part 1) options can be found by typing the appropriate RTV command Cindy told us in class and pressing F4. Page-down to find QIPLTYPE for the information. Hope this helps.
 
 
Reply:
 
It sure did! Thanks! :)
 
 
== Lab 5 ==
 
What command does WS provide a shortcut to?? (Page 2 of 12 in LAB 5)
 
BY: ZAKERIA HASSAN
 
 
The command is WRKSBMJOB.
 
By: Jayakumar Govinthasamy
 
 
How is a key field denoted in DDS?
 
By: Jayakumar Govinthasamy
 
 
What does DFU mean?
 
By: Jayakumar Govinthasamy
 
 
Ans...:
 
DFU is used to manipulate data in files. DFU stands for '''DATA FILE UTILITY''' and can be accessed by using CL commands such as '''strdfu''' or '''upddta'''.
 
ANSWERED BY: ZAKERIA HASSAN
 
 
== Lab 6 ==
 
== Lab 7 ==
 
 
== Lab 8 ==
 
 
== Lab 9 ==
 
== Lab 10 ==
 
== Lab 11 ==
 
== Lab 12 ==
 
 
=Tests=
 
Where are the library descriptions stored?
 
BY:Zakeria HASSAN
 
 
Ans: Library Descriptions are stored in QSYS.
 
By: Jayakumar Govinthasamy
 
 
 
What is the exact difference between OUTPUT QUEUE and Spooled files?
 
By: Jayakumar Govinthasamy
 
 
 
Ans.......:
 
The output queues are objects and spooled files are not. Output queue files are permanent and it contains spooled files which are temperary. Spooled files are output from a file which is compiled and contains detail about that file.
 
BY: ZAKERIA HASSAN
 
 
= General Discussion =
 
 
Post anything relevant
 
  
 
=Students=
 
=Students=
Line 311: Line 215:
 
| Cindy|| Laurin|| N/A|| N/A || [http://cs.senecac.on.ca/~cindy.laurin Cindy's Home Page] || claurin
 
| Cindy|| Laurin|| N/A|| N/A || [http://cs.senecac.on.ca/~cindy.laurin Cindy's Home Page] || claurin
 
|-
 
|-
| Karl || Danninger || kadanninger || A || [http://karldanninger.com Karl Danninger's Blog] || karlwithak
+
| Karl || Danninger || kadanninger || A || [http://www.karldanninger.com Karl Danninger's Blog] || kdanninger
|-
 
| Zakeria || Hassan || zmhassan || A || - || ELECTRON
 
|-
 
| Jayakumar|| Govinthasamy || jgovinthasamy || A || N/A || N/A
 
|-
 
| Quan|| Khau|| qkhau|| B|| N/A|| NA
 
 
|-
 
|-
| Akash || Patel || acpatel4 || A || N/A || N/A
+
| Jason || Quan || jquan4 || A || || JQuan
 
|-
 
|-
| Hadi|| Saeed|| N/A|| N/A || [http://haddiss.blogspot.com/ Hadi's Page] || N/A
 
 
 
|}
 
|}
 
=Previous Wiki Links=
 
 
* [http://zenit.senecac.on.ca/wiki/index.php/IBC233_03_2010 2010 Fall]
 

Latest revision as of 11:53, 5 December 2011

Introduction

This wiki-page is intended for students studying BAC344. Feel free to contribute anything you want as long as it is relevant to BAC344.

This wiki-page is maintained by students and Cindy Laurin and is intended to be an informal place to share information. Please refer to the course materials or consult your professor regarding specific information related to your course.

Please do not post assignment solutions to this Wiki.


Wiki

If you don't have a user ID and password you can select the Log in/Create Account link at the top-right of this page, and then select the Create an account link (or just click here).


Wiki is also compatible with HTML


Useful Links

Due Dates

Assignment Due Date Test Test Date
1 Sept 9 1 Oct 12
2 Sept 23 2 Nov 16
3 Oct 7
4 Oct 21
5 Nov 11
6 Nov 25
7 Dec 9

Class Notes

Week Lecture Topic Text Book Material
1
  • The System I environment
  • Cobol Program Structure and Programming

Class 1 Class 2

Chapters 1, 2 and 3

2
  • Cobol Verbs
  • Display File Review

Class 1 Class 2

Chapters 4, 5, 6 and 14

3
  • Selection Statements
  • Indicators
  • Function Keys

Class 1 Class 2

Chapters 8 and 14

4
  • Conditions
  • Iteration
  • Logical Files
  • Random Reads

Class 1 Class 2

Chapters 8, 9, 10, 11 and 14

5
  • File Access Techniques

Class 1 Class 2

Chapters 8, 9, 10, 11 and 14

6
  • ILE Functions
  • INDARA and SI
  • Condition Names
  • Iteration
  • Logical Files
  • Positioning the file Pointer

Class 1

Chapters 14

7
  • Reporting

Class 1 Class 2 Printer Spacing Chart

Chapters 4

8
  • Reporting example
  • Math in COBOL

Class 1 Class 2

Chapters 4

9
  • Arrays

Class 1 Class 1 Example Class 2 Class 2 Example

Chapters 15 and 16

10
  • Multi Dimensional Arrays

Class 1 Class 1 Example

Chapters 15 and 16

11
  • Control Breaks and Passing Parameters

Class 1 Class 2

Chapters 12, and 19

12
  • SQL

Class 1

13
  • Review

Class 1

General Discussion

Post anything relevant

I was wondering if any body knew how to gain access to cindy's source code on green screen? Any help would be appreciated. Thank you. - Saulius Grybas

Hi Saulius,

At the command line, type WRKOBJPDM WF344A40. Type 12 beside QCBLLESRC and then browse what ever you like!

Cindy

Students

Take a look at Ljubomir's example, copy/paste it, and modify it with your own info. If a category does not apply to you, just leave a dash '-' or 'N/A'

First Name Last Name Seneca Learn ID Section Blog Url IRC Nick
Ljubomir Gorscak gljubomir N/A Ljubomir's Blog ljubo & ljog
Cindy Laurin N/A N/A Cindy's Home Page claurin
Karl Danninger kadanninger A Karl Danninger's Blog kdanninger
Jason Quan jquan4 A - JQuan