Changes

This wiki-page is intended for students studying IBC233. Feel free to contribute anything you want as long as it is relevant '''Please do not post lab solutions to IBC233this Wiki.'''

Please do not post lab solutions 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 this Wiki[http://freenode.net/ Freenode] and join the conversation

There is If you're looking for an IRC on Freenode where client you can try [http://chatzilla.hacksrus.com/ Chatzilla] or you can chat through a few Seneca studentsbrowser by logging into [http://iSeries enthusiasts hang outwebchat.freenode.net/ webchat.freenode. Just go on to Freenode and join the conversationnet]

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:/join /zenit.senecac.on.ca/wiki/index.php/IBC233_03_2010#seneca-ibc233General_Discussion General Discussion].

If you're looking for an <!--* [http://zenit.senecac.on.ca/wiki/index.php/OOP344_Student_Resources#The_Basics_of_IRC IRC client you can try Chatzilla or you can chat through a browser by logging into webchatBasics]-->* [http://irchelp.freenodeorg/irchelp/irctutorial.nethtml IRC Tutorial]

If you don't have a user ID and password you can select the Log in* [https:/Create Account link at the top-right of this page, and then select the Create an account link (or just click here)/cs.senecac.on.ca/~ibc233/ IBC233 Home Page]

[edit] ! 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 || Useful Links|| |||-IBC233 Home Page|}

[edit] Labs [edit] Lab = Class Notes ={| border="1" cellpadding="5"

Hello everyone! 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|-Deva| 2 ||* Library Lists* Intro to RDI* Physical Files

Edit by Paul Class Notes: Here is a Step by step Guide to connecting to Zeus From Homehttps://cs.senecac.on.ca/~cindy.laurin/ibc233_lect2_fall_2011.ppt

1. Go to the ACS seneca web page Cindy's Notes: https://acscs.senecac.on.ca/pages/index~cindy.php2. Go to download laurin/ type information that is needed to log inibc233_week2_notes.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 ofdaemon tools, its a little hard to find the download link but it comes with 20days free (Ichoose the lite version.5. Once installed go to your start menu and Click IBM iSeries Access for Windows unless you havechanged it, then go to sublink Emulator, and click start or Configure Session.6. One the new window pops up click NEW Session7. A window should pop up, their you can click properties and in the first box type: zeus.senecac.on.cadocx

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

************************************************************************<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 solution 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 select The IBM website. Down load the version of the Remap Keyboard Functions icon RDp.ISO file from the Client Access Window and click acs.senecac.on the ENTER key in the image .ca. It has a file size of 1.18GB. You may have trouble running launcher by double clicking the QWERTY keyboardEXE file. Then in You must have admin rights AND you must right click the Change Current Actions for Selected Key area of the same screen change the Base value to [Enter]EXE file and run as administrator. That should fix itThe program will take about 30 seconds to load when running off a DVD drive.

[edit] 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. Lab 2The 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'.

If you use the RDp.ISO file from the ACS server make sure you use == Lab 4 ==Original Post:So, i hope i'm putting this in the activation program from the ACS server alsoright area, do not be tempted to use an activation file from another source. The activation.ISO file must be transferred but does anyone out there understand how to a DVD find out 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.jarprompt'.was qiplsts does?

Original PostReply: 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?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 == Lab 5 ==What command does WS provide a shortcut to?? (as indicated on page 9 Page 2 of lab4 part 112 in LAB 5) 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.BY: ZAKERIA HASSAN

ReplyThe command is WRKSBMJOB.By: It sure did! Thanks! :)Jayakumar Govinthasamy

What command does WS provide a shortcut toDFU mean?? (Page 2 of 12 in LAB 5) BYBy: ZAKERIA HASSANJayakumar Govinthasamy

The command Ans...:DFU is WRKSBMJOBused to manipulate data in files. DFU stands for '''DATA FILE UTILITY''' and can be accessed by using CL commands such as '''strdfu''' or '''upddta'''. ByANSWERED BY: Jayakumar GovinthasamyZAKERIA HASSAN

Ans: Library Descriptions are stored in QSYS. 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

[edit] = General Discussion=

[edit] =Students=

First NameLast NameSeneca Learn IDSectionBlog UrlIRC Nick LjubomirGorscakgljubomirN/ALjubomir's Blogljubo & ljog CindyLaurinN/AN/ACindy's Home Pageclaurin KarlDanningerkadanningerAKarl Danninger's Blogkarlwithak ZakeriaHassanzmhassanA-ELECTRON JayakumarGovinthasamyjgovinthasamyAN/AN/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|| NAB|-| Akash || Patel || acpatel4 || A || N/A|| N/A|-NA| Hadi|| Saeed|| N/A|| N/A || [http://haddiss.blogspot.com/ Hadi's Page] || N/A

* [edithttp://zenit.senecac.on.ca/wiki/index.php/IBC233_03_2010 2010 Fall] Previous Wiki Links