Difference between revisions of "IBC233 01 2012"

From CDOT Wiki
Jump to: navigation, search
(→‎Lab 4)
 
(15 intermediate revisions by 5 users not shown)
Line 50: Line 50:
  
 
* [https://cs.senecac.on.ca/~ibc233/ IBC233 Home Page]
 
* [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 =
 
= Due Dates =
 
{| border="1" cellpadding="5"
 
{| border="1" cellpadding="5"
Line 63: Line 71:
 
| 4 - Part A-E || Feb 8 / 10 || Demonstration ||  ||  ||
 
| 4 - Part A-E || Feb 8 / 10 || Demonstration ||  ||  ||
 
|-
 
|-
−
| 4 - Remainder || Feb 15 / 16 || Demonstration ||  ||  ||
+
| 4 - Remainder || Feb 15 / 17 || Demonstration ||  ||  ||
 
|-
 
|-
 
| 5 || Feb 22 /24 || Demonstration ||  ||  ||
 
| 5 || Feb 22 /24 || Demonstration ||  ||  ||
Line 81: Line 89:
 
| 12 || Apr 11 / 13|| 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:
 +
 +
|-
 +
 +
 
|}
 
|}
  
Line 89: Line 218:
 
== Lab 3 ==
 
== Lab 3 ==
 
== Lab 4 ==
 
== 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 5 ==
 
== Lab 6 ==
 
== Lab 6 ==
Line 109: Line 243:
  
 
Post anything relevant
 
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=
 
=Students=
Line 122: Line 258:
 
| 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
 
|-
 
|-
−
| - || - || - || - || - || -
+
| 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
 
|-
 
|-
 
| - || - || - || - || - || -
 
| - || - || - || - || - || -

Latest revision as of 20:53, 25 February 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.

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

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 1

Lab 2

Lab 3

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

Previous Wiki Links

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=
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=IBC233_01_2012&oldid=81846"