View source for IBC233 03 2011

= 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 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 lab solutions to this Wiki.
'''

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


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

! Lab !! Due Date !! Requirements !! Test !! Week Number !! Test Date
|-
| 1 || Sept 14 || Send Cindy an email with your userid when you are done! || 1 || Week 6 || Oct 12
|-
| 2 || Sept 21 || Compiled Listing - STUDENTS *FILE and STUDENTS *PGM || 2 || Week 10 || Nov 14
|-
| 3 || Sept 28 || Demonstration of RPG Program||  ||  ||
|-
| 4 - Part A-E || Oct 5 || Demonstration ||  ||  ||
|-
| 4 - Remainder || Oct 19 || Demonstration ||  ||  ||
|-
| 5 || Oct 17 || Demonstration ||  ||  ||
|-
| 6 || Nov 2 || Hand in lab sheet||  ||  ||
|-
| 7 || Nov 2 || Demonstration ||  ||  ||
|-
| 8 || Nov 9 || Demonstration ||  ||  ||
|-
| 9 || Nov 16 || Demonstration ||  ||  ||
|-
| 10 || Nov 23 || Demonstration ||  ||  ||
|-
| 11 || Nov 30 || Demonstration ||  ||  ||
|-
| 12 || Dec 7|| 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_fall_2011.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_fall_2011.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_fall_2011.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

			Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect4_fall_2011.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: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect5_fall_2011.ppt

Review: ibc233_review3.doc
|-

| 6 ||
Database Design

			Data Representatives

			Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect6_fall_2011.ppt

	                Review: https://cs.senecac.on.ca/~cindy.laurin/ibc233_review3.doc
|-
| 7 ||
System Configuration

		Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect7_fall_2011.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_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
|-
| 9 ||
Menus, Security and Report Writer

	   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

	                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_fall_2011.ppt

|-
| 11 ||
Calling Programs and Overriding Files

			Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect11_fall_2011.ppt

|-

| 12 ||
Query/400 and DFU

		Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect12_fall_2011.ppt

|-
| 13 ||
Review

		Class Notes:

|-


|}

= Labs =

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



IMPORTANT NOTE, Remember your password needs to be in CAPS.

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 attention.  Does anyone else have a comment?

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=

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
|-
| Thevakaran || Virutthasalam || tvirutthasalam || C || [http://thevakaran.blogspot.com Thevakaran's Blog] || gobihun
|-
| 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
|-
| 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
|-
| 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]