View source for IBC233 01 2012

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

'''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 [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://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/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 1 ==
== Lab 2 ==
== 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 ==
== 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.

== Lab 9 ==
== Lab 10 ==
== Lab 11 ==
== Lab 12 ==

=Tests=

= General Discussion =

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=

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
|-
| 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
|-
| - || - || - || - || - || -
|-
| - || - || - || - || - || -
|-
|}

=Previous Wiki Links=

=Plain Text=

This whole text can be copied and pasted into a new Wiki page to re-create the [http://zenit.senecac.on.ca/wiki/index.php/IBC233_Template IBC233_Template] page.

<pre>

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

</pre>