Difference between revisions of "IBC233 03 2011"

From CDOT Wiki
Jump to: navigation, search
(Due Dates)
 
(40 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
= Introduction =
  
== 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.
  
This wiki-page is intended for students studying IBC233. Feel free to contribute anything you want as long as it is relevant to IBC233.
+
'''Please do not post lab solutions to this Wiki.
 +
'''
  
This wiki-page is maintained by students and Cindy Laurin and is intended to be an informal place to share information.
+
= IRC =
  
Please do not post lab solutions to this Wiki.
+
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
  
[edit]  IRC
+
* /join #seneca-ibc233
  
There is an IRC on Freenode where a few Seneca students/iSeries enthusiasts hang out. Just go on to Freenode and join the conversation
+
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]
  
/join #seneca-ibc233
+
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].
  
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
+
<!--
 +
* [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]
  
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 [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]).
  
== IRC Tutorial ==
+
<!-- * 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>
  
=== Wiki ===
+
<br />
  
 +
= Useful Links =
  
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).
+
* [https://cs.senecac.on.ca/~ibc233/ IBC233 Home Page]
  
How To edit Wiki pages
 
How To edit Wiki Cheatsheet
 
More Wiki editing help
 
  
Wiki is also compatible with HTML
+
= Due Dates =
 +
{| border="1" cellpadding="5"
  
[edit] Useful Links
+
! Lab !! Due Date !! Requirements !! Test !! Week Number !! Test Date
IBC233 Home Page
+
|-
 +
| 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 || ||  ||
 +
|-
 +
|}
  
[edit]  Labs  [edit]  Lab 1
+
= Class Notes =
 +
{| border="1" cellpadding="5"
  
Hello everyone! -Deva
+
! 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
  
Edit by Paul: Here is a Step by step Guide to connecting to Zeus From Home:
+
Class Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_lect2_fall_2011.ppt
  
1. Go to the ACS seneca web page: https://acs.senecac.on.ca/pages/index.php
+
Cindy's Notes: https://cs.senecac.on.ca/~cindy.laurin/ibc233_week2_notes.docx
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 thedrop box and choice the 3rd option "Use Default UserId, and prompt
+
                        DDS Reference: https://cs.senecac.on.ca/~cindy.laurin/dds_reference.doc
as needed", then type your userId
+
|-
not your learn id, but the userId handed out during class.
+
| 3 ||
9. Once this is set up you can connect.
+
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.
 
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>
 +
  
https://senema.senecac.on.ca/videos/678/how-to-install-as-400-client-access
 
  
 
IMPORTANT NOTE, Remember your password needs to be in CAPS.
 
IMPORTANT NOTE, Remember your password needs to be in CAPS.
Line 75: Line 239:
  
 
Best, Vincent
 
Best, Vincent
Trouble with login to ZEUS.
 
  
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.
+
************************************************************************
 +
<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.
  
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 keyboardThen 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 fileYou must have admin rights AND you must right click the EXE file and run as administratorThe program will take about 30 seconds to load when running off a DVD drive.  
  
[edit] Lab 2
+
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'.
  
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.
+
== Lab 3 ==
  
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 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]  Lab 3  [edit]  Lab 4
+
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.
  
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?
+
Reply:
 +
It sure did! Thanks! :)
  
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.
+
== Lab 5 ==
 +
What command does WS provide a shortcut to?? (Page 2 of 12 in LAB 5)
 +
BY: ZAKERIA HASSAN
  
Reply: It sure did! Thanks! :)
+
The command is WRKSBMJOB.
 +
By: Jayakumar Govinthasamy
  
[edit]  Lab 5
+
How is a key field denoted in DDS?
 +
By: Jayakumar Govinthasamy
  
What command does WS provide a shortcut to?? (Page 2 of 12 in LAB 5) BY: ZAKERIA HASSAN
+
What does DFU mean?
 +
By: Jayakumar Govinthasamy
  
The command is WRKSBMJOB. 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
  
How is a key field denoted in DDS? By: Jayakumar Govinthasamy
+
== Lab 6 ==
 +
== Lab 7 ==
  
What does DFU mean? By: Jayakumar Govinthasamy
+
== Lab 8 ==
  
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 9 ==
 +
== Lab 10 ==
 +
== Lab 11 ==
 +
== Lab 12 ==
  
[edit]  Lab 6  [edit]  Lab 7
+
=Tests=
 +
Where are the library descriptions stored?
 +
BY:Zakeria HASSAN
  
[edit]  Lab 8 [edit]  Lab 9  [edit]  Lab 10  [edit]  Lab 11  [edit]  Lab 12  [edit] Tests
+
Ans: Library Descriptions are stored in QSYS.
 +
By: Jayakumar Govinthasamy
  
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
  
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
+
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
  
[edit]  General Discussion
+
= General Discussion =
  
 
Post anything relevant
 
Post anything relevant
  
[edit] Students
+
=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'
 
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
+
{| border="1" cellpadding="5"
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
 
 
 
Karl
 
Danninger
 
kadanninger
 
A
 
Karl Danninger's Blog
 
karlwithak
 
 
 
Zakeria
 
Hassan
 
zmhassan
 
A
 
-
 
ELECTRON
 
 
 
Jayakumar
 
Govinthasamy
 
jgovinthasamy
 
A
 
N/A
 
N/A
 
  
Quan
+
! First Name !! Last Name !! Seneca Learn ID !! Section !! Blog Url !! IRC Nick
Khau
+
|-
qkhau
+
| Ljubomir || Gorscak || gljubomir || N/A || [http://ljubomirgorscak.blogspot.com Ljubomir's Blog] || ljubo & ljog
B
+
|-
N/A
+
| Thevakaran || Virutthasalam || tvirutthasalam || C || [http://thevakaran.blogspot.com Thevakaran's Blog] || gobihun
NA
+
|-
 +
| 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
  
Akash
+
|}
Patel
 
acpatel4
 
A
 
N/A
 
N/A
 
  
Hadi
+
=Previous Wiki Links=
Saeed
 
N/A
 
N/A
 
Hadi's Page
 
N/A
 
  
[edit] Previous Wiki Links
+
* [http://zenit.senecac.on.ca/wiki/index.php/IBC233_03_2010 2010 Fall]

Latest revision as of 13:00, 31 October 2011

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


Due Dates

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

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.

        https://senema.senecac.on.ca/videos/678/how-to-install-as-400-client-access


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

Trouble with login to ZEUS.

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'

First Name Last Name Seneca Learn ID Section Blog Url IRC Nick
Ljubomir Gorscak gljubomir N/A Ljubomir's Blog ljubo & ljog
Thevakaran Virutthasalam tvirutthasalam C Thevakaran's Blog gobihun
Cindy Laurin N/A N/A Cindy's Home Page claurin
Karl Danninger kadanninger A 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 Hadi's Page N/A

Previous Wiki Links