IBC233 03 2011

From CDOT Wiki
Jump to: navigation, search

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