Changes

Jump to: navigation, search

BAC344 03 2011

12,026 bytes added, 06:47, 9 September 2011
Created page with '= Introduction = This wiki-page is intended for students studying BAC344. Feel free to contribute anything you want as long as it is relevant to BAC344. This wiki-page is maint…'
= Introduction =

This wiki-page is intended for students studying BAC344. Feel free to contribute anything you want as long as it is relevant to BAC344.

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


= 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/~cindy.laurin/ILE_Debugger_Instructions.doc ILE Debugger (STRDBG) Instructions]
* [https://cs.senecac.on.ca/~cindy.laurin/BAC344_Class_Std.doc Course Standards]
* [https://cs.senecac.on.ca/~cindy.laurin/File%20Status%20Codes.doc File
Status Codes and Their Meanings!]
* [http://proquest.safaribooksonline.com/9780471418467 File
Text Book]
* [https://cs.senecac.on.ca/~cindy.laurin/File%20Status%20Codes.doc
Project Initation Document]

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

! Assignment !! Due Date !! Test !! Week Number !! Test Date
|-
| [https://cs.senecac.on.ca/~cindy.laurin/BAC_Assignment_1_Summer_2011.doc 1] || Sept 9 || Compiled Listing - SYSVALPRG, Compiled Listing of second program || 1 || Week 6 || Oct 12
|-
| 2 || Sept 21 || Compiled Listing - STUDENTS *FILE and STUDENTS *PGM || 2 || Week 10 || Nov 14
|-
| 3 || Sept 26 || Demonstration of RPG Program and STRDBG || || ||
|-
| 4 - Part A-E || Oct 3 || Demonstration || || ||
|-
| 4 - Remainder || Oct 17 || Demonstration || || ||
|-
| 5 || Oct 17 || Demonstration || || ||
|-
| 6 || Oct 31 || Hand in lab sheet|| || ||
|-
| 7 || Oct 31 || Demonstration || || ||
|-
| 8 || Nov 7 || Demonstration || || ||
|-
| 9 || Nov 14 || Demonstration || || ||
|-
| 10 || Nov 21 || Demonstration || || ||
|-
| 11 || Nov 28 || Demonstration || || ||
|-
| 12 || Dec 5 || 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: 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
|-
| 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]

Navigation menu