1
edit
Changes
→Lab 4
* [https://cs.senecac.on.ca/~ibc233/ IBC233 Home Page]
* [https://senema.senecac.on.ca/videos/678/how-to-install-as-400-client-access Video on how to install AS/400 Client access]Note: When on Windows 7 64-Bit, Client Access will install under Program Files (x86). When putting the files that are specified in the video in their appropriate directories, make sure they are named the same (case sensitive). Change "emulator" to EMULATOR and "private" to PRIVATE. Once this is done. Open ZEUS.WS or any variation thereof and find the HOSTNAME parameter. It should say "ODIN.senecac.on.ca". This is not the server we are using. We are using ZEUS. Change the HOSTNAME paramater to HostName=ZEUS.senecac.on.ca. Launch Client Access with any of the preferred .ws files and login as normal! = Due Dates ={| border="1" cellpadding="5" ! Lab !! Due Date !! Requirements !! Test !! Week Number !! Test Date|-| 1 || Jan 18 / 20|| Hand in Compiled Listing for both programs || 1 || Week 6 || Feb 15 / 17|-| 2 || Jan 25 / 27 || Compiled Listing - STUDENTS *FILE and STUDENTS *PGM || 2 || Week 10 || Mar 19|-| 3 || Feb 2 /4|| Demonstration of RPG Program|| || |||-| 4 - Part A-E || Feb 8 / 10 || Demonstration || || |||-| 4 - Remainder || Feb 15 / 17 || Demonstration || || |||-| 5 || Feb 22 /24 || Demonstration || || |||-| 6 || Mar 7 / 9 || Hand in lab sheet|| || |||-| 7 || Mar 7 / 9 || Demonstration || || |||-| 8 || Mar 14 / 16 || Demonstration || || |||-| 9 || Mar 21 / 23 || Demonstration || || |||-| 10 || Mar 28 / 30 || Demonstration || || |||-| 11 || Apr 4 / 6 || Demonstration || || |||-| 12 || Apr 11 / 13|| Demonstration || || |||-|} = Class Notes ={| border="1" cellpadding="5" ! Week !! Lecture Topic|-| 1 ||Introduction to IBM i: signing on, using menus, libraries, library lists, objects, SEU, creating a CL program. Lecture Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect1_winter_2012.ppt At Home: Install Client Access and RDI Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week1_notes.docx|-| 2 ||* Library Lists* Intro to RDI* Physical Files Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect2_winter_2012.ppt Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week2_notes.docx DDS Reference: https://cs.senecac.on.ca/~cindy.laurin/dds_reference.doc|-| 3 ||RPG Programming with Display Files Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect3_winter_2012.ppt Reference Material: https://cs.senecac.on.ca/~cindy.laurin/ibc233_reference.doc Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review1.doc|-| 4 ||CL Programming with Display Files See you in Class tomorrow - made it back for Quebec safe and sound! Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect4_winter_2012.ppt 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/IBC_Schedibc233_review2.html doc Cindy's IBC233 Page]Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week3_notes.docx|-| 5 ||CL Programming with Display Files Class Notes: Continue with Lab4 Cl Sample Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review3.doc|- | 6 ||Database Design Data Representatives Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect6_winter_2012.ppt |-| 7 ||System Configuration Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect7_winter_2012.ppt Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review4.doc|-| 8 ||Creating a CLLE command RPGLE Programming with database files Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect8_winter_2012.ppt Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review4.doc Query Notes: https://cs.senecac.on.ca/~cindy.laurin/query_options.doc|-| 9 ||Menus, Security and Report Writer Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect9_winter_2012.ppt Review1: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review5.doc Review2: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review6.doc|-| 10 ||RPGLE Business Application Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect10_winter_2012.ppt |-| 11 ||Calling Programs and Overriding Files Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect11_winter_2012.ppt |- | 12 ||Query/400 and DFU Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect12_winter_2012.ppt |-| 13 ||Review Class Notes: |- |}
= Labs =
== Lab 3 ==
== Lab 4 ==
Use '''[http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Frtvusrprf.htm RTVUSRPRF]''' to retrieve user profile values (these values are user specific).<br />
Use '''[http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Frtvsysval.htm RTVSYSVAL]''' to retrieve system values (this values are global to all users).
== Lab 5 ==
== Lab 6 ==
Post anything relevant
There is a CL e-book available at [http://library.senecac.on.ca/ Seneca Libraries]: Complete CL: The Definitive Control Language Programming Guide by Ted Holt.
=Students=
| Cindy|| Laurin|| N/A|| N/A || [http://cs.senecac.on.ca/~cindy.laurin Cindy's Home Page] || claurin
|-
| Amir M. || Mobasseri || ammobasseri || C || [http://zenit.senecac.on.ca/wiki/index.php/User:Amobasseri Amir's Wiki]|| - |-| - Edward || Hanna || - echanna || - AB || - [http://zenit.senecac.on.ca/wiki/index.php/User:Echanna Edward's Wiki on Cdot] || -eliocharles
|-
| - || - || - || - || - || -