IBC233 01 2012

Introduction

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

This wiki-page is maintained by students 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 lab solutions to this Wiki.

If you have any questions about this Wiki or IRC, you are welcome to email Ljubomir Gorscak

• gljubomir@learn.senecac.on.ca

IRC

There is an IRC on Freenode where a few Seneca students/iSeries enthusiasts hang out. Just go on to Freenode and join the conversation

• /join #seneca-ibc233

If you're looking for an IRC client you can try Chatzilla or you can chat through a browser by logging into webchat.freenode.net

If you notice or take part in an interesting IRC discussion about IBC233, please feel free to edit and paste it into this wiki page under General Discussion.

• IRC Tutorial

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).

• How To edit Wiki pages
• How To edit Wiki Cheatsheet
• More Wiki editing help

Wiki is also compatible with HTML

Useful Links

• IBC233 Home Page

• 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

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

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/ibc233_review2.doc Cindy's 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 4

Use RTVUSRPRF to retrieve user profile values (these values are user specific).
Use RTVSYSVAL to retrieve system values (this values are global to all users).

Lab 8

Tips

On page 6 when you are creating the command source, make sure that you do not allow the characters to exceed column 70. If you go past column 70, it will not be interpreted.

General Discussion

Post anything relevant

There is a CL e-book available at Seneca Libraries: Complete CL: The Definitive Control Language Programming Guide by Ted Holt.

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
Amir M.	Mobasseri	ammobasseri	C	Amir's Wiki	-
Edward	Hanna	echanna	AB	Edward's Wiki on Cdot	eliocharles
-	-	-	-	-	-
-	-	-	-	-	-

Plain Text

This whole text can be copied and pasted into a new Wiki page to re-create the IBC233_Template page.

= Introduction =

This wiki-page is intended for students studying [https://cs.senecac.on.ca/~ibc233/ IBC233]. Feel
free to contribute anything you want as long as it is relevant to [https://cs.senecac.on.ca/~ibc233/ IBC233].

This wiki-page is maintained by students 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.

If you have any questions about this Wiki or IRC, you are welcome to email Ljubomir Gorscak
* gljubomir@learn.senecac.on.ca

= IRC =

There is an [http://irchelp.org/irchelp/irctutorial.html IRC] on [http://freenode.net/ Freenode] where a
few Seneca students/iSeries enthusiasts hang out. Just go on to [http://freenode.net/ Freenode] and
join the conversation

* /join #seneca-ibc233

If you're looking for an IRC client you can try [http://chatzilla.hacksrus.com/ Chatzilla] or you
can chat through a browser by logging into [http://webchat.freenode.net/ webchat.freenode.net]

If you notice or take part in an interesting IRC discussion about IBC233, please feel free to edit
and paste it into this wiki page under
[http://zenit.senecac.on.ca/wiki/index.php/IBC233_03_2010#General_Discussion General Discussion].

<!--
* [http://zenit.senecac.on.ca/wiki/index.php/OOP344_Student_Resources#The_Basics_of_IRC IRC Basics]
-->
* [http://irchelp.org/irchelp/irctutorial.html IRC Tutorial]

= Wiki =

If you don't have a user ID and password you can select the
[http://zenit.senecac.on.ca/wiki/index.php?title=Special:UserLogin&returnto=Special:UserLogout Log in/Create Account]
link at the top-right of this page, and then select the
[http://zenit.senecac.on.ca/wiki/index.php?title=Special:UserLogin&type=signup Create an account] link
(or just click [http://zenit.senecac.on.ca/wiki/index.php?title=Special:UserLogin&type=signup here]).

<!-- * Comment -->
* [http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page How To edit Wiki pages]
* [http://en.wikipedia.org/wiki/Wikipedia:Cheatsheet How To edit Wiki Cheatsheet]
* [http://zenit.senecac.on.ca/wiki/index.php/Help:Editing More Wiki editing help]

<br />

<table border="1" cellpadding="5" cellspacing="5">
<tr>
<td>
<big>Wiki is also compatible with HTML</big>
</td>
</tr>
</table>

<br />

= Useful Links =

* [https://cs.senecac.on.ca/~ibc233/ IBC233 Home Page]
* [https://cs.senecac.on.ca/~cindy.laurin/IBC_Sched.html Cindy's IBC233 Page]

= Labs =

== Lab 1 ==
== Lab 2 ==
== Lab 3 ==
== Lab 4 ==
== Lab 5 ==
== Lab 6 ==
== Lab 7 ==

== Lab 8 ==

===Tips===

On page 6 when you are creating the command source, make sure that you do not allow the characters
to exceed column 70.  If you go past column 70, it will not be interpreted.

=Tests=

= General Discussion =

Post anything relevant

=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'

{| border="1" cellpadding="5"

! First Name !! Last Name !! Seneca Learn ID !! Section !! Blog Url !! IRC Nick
|-
| Ljubomir || Gorscak || gljubomir || N/A || [http://ljubomirgorscak.blogspot.com Ljubomir's Blog] || ljubo & ljog
|-
| Cindy|| Laurin|| N/A|| N/A || [http://cs.senecac.on.ca/~cindy.laurin Cindy's Home Page] || claurin
|-
| - || - || - || - || - || -
|-
| - || - || - || - || - || -
|-
| - || - || - || - || - || -
|-
| - || - || - || - || - || -
|-
|}

=Previous Wiki Links=