Mainframes Techie !!!!

Cobol

noreply@blogger.com (blogkns) — Wed, 6 May 2009 07:16:00 -0700

History
COBOL (Common Business Oriented Language) was one of the earliest high-level programming languages. It was developed in 1959 by a group of computer professionals called the Conference on Data Systems Languages (CODASYL). Since 1959 it has undergone several modifications and improvements. In an attempt to overcome the problem of incompatibility between different versions of COBOL, the American National Standards Institute (ANSI) developed a standard form of the language in 1968. This version was known as American National Standard (ANS) COBOL. In 1974, ANSI published a revised version of (ANS) COBOL, containing a number of features that were not in the 1968 version. In 1985, ANSI published still another revised version that had new features not in the 1974 standard. The language continues to evolve today. Object-oriented COBOL is a subset of COBOL 97, which is the fourth edition in the continuing evolution of ANSI/ISO standard COBOL. COBOL 97 includes conventional improvements as well as object-oriented features. Like the C++ programming language, object-oriented COBOL compilers are available even as the language moves toward standardization.

The following links will give you more about the cobol.

ibmmainframes
geekinterview
csis.ul.ie
wikipedia

Cobol reference books

The Essentials of Cobol I (Essential Series) (Paperback)
by Ruknet Cezzar (Author)

Fundamentals of Structured Cobol (Paperback)
by Robert C. Nickerson (Author)

Fundamentals of Structured Cobol (Paperback)
by Robert C. Nickerson (Author)

Handbook of Cobol Techniques and Programming Standards

COBOL for Dummies Quick Reference (Paperback)
by John W. Fronckowiak (Author)

Murach's Structured COBOL (Bk/CD)

Mastering Cobol
By Carol Baroudi

Structured Programming With Cobol Examples
By Earl H. Parsons

COBOL for OS/390 Power Programming
By David Shelby Kirk

A Simplified Guide to Structured Cobol Programming
By Daniel D. McCracken, Donald G. Golden

Introduction to Object COBOL
By E. Reed Duke

COBOL Unleashed By Jon Wessler

Sams Teach Yourself COBOL in 24 Hours (Paperback)
by Thane Hubbell (Author)

Advanced Structured Cobol : M. B. Khan, Marle P. Martin

Structured COBOL programming‎
by Nancy B. Stern, Robert A. Stern

The programmer's ANSI COBOL reference manual‎
by Donald A. Sordillo

Fundamentals of structured COBOL programming‎
by Carl Feingold

SQL Basics

noreply@blogger.com (blogkns) — Sat, 2 May 2009 12:15:00 -0700

SQL is a standard language for accessing and manipulating databases.
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL is an ANSI (American National Standards Institute) standard
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
See the following SQL Links
http://www.w3schools.com/Sql/sql_intro.asp
http://en.wikipedia.org/wiki/SQL
http://sqlcourse.com/
http://sqlzoo.net/
http://www.jcc.com/sql.htm
http://www.sql-tutorial.net/
http://www.1keydata.com/sql/sql.html
http://www.sqlmag.com/
http://www.geocities.com/SiliconValley/Vista/2207/sql1.html
http://www.sql-ex.ru/
http://www.contrib.andrew.cmu.edu/~shadow/sql.html
http://www.mysql.com/
http://www.firstsql.com/tutor.htm
http://kb.iu.edu/data/ahux.html
http://www.tizag.com/sqlTutorial/
http://www.baycongroup.com/tocsql.htm
http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html
http://www.sqlcommands.net/
http://www.webappsec.org/projects/threat/classes/sql_injection.shtml
http://www.red-gate.com/products/SQL_Compare/index.htm
http://www.webdevelopersnotes.com/tutorials/sql/index.php3
http://www.orafaq.com/wiki/SQL_FAQ
http://databases.about.com/od/sql/a/sqlfundamentals.htm
http://www.sqlquiz.com/
http://www.quackit.com/sql/tutorial/
http://cas.sdss.org/dr7/en/help/docs/sql_help.asp
http://www.commandprompt.com/ppbook/c1164.htm
http://www.sqlrecipes.com/
http://www.sqltraining.org/
http://www.fluffycat.com/SQL/
http://datasplash.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL_TOC.html
http://www.sommarskog.se/dynamic_sql.html
http://www.mckoi.com/database/SQLSyntax.html

Mainframes Tips

noreply@blogger.com (blogkns) — Thu, 30 Apr 2009 23:49:00 -0700

TIP # 001

ISPFLets start with a generic and simpler one.Consider that you are editing a file/program and you want to know the changes you have donesince the last SAVE command.How to find that?

Answer:Give COMPARE SESSION on the command lineFurther use of COMPARE commands...- Can be used like 3.13 option

TIP # 002

ISPFUsually the PDS or PS bears the ID of the creator or the ID of the person who modified itrecently.But is it possible to change these ID values without leaving trace of one’s own ID?

Answer:Yes its possible! In the command area against the member name or PS name, by giving ‘G’.Dialog box will pop up allowing you to change the ID values.

TIP # 003

ISPFSuppose you are in a ISPF Screen and want to know in which TSO Region ( Development,Production, or other TSO regions) you are now .

Answer:Issue on the command line : SAREAISPF STATISTICS Pop-up window will show you the region( and other info too)

TIP # 004

ISPFAny command entered in the COMMAND LINE disappears after the successful execution of itsintended function.If you want to repeat the same command , you got to re-type it or use some PF key to retrieve thelast command entered.But here is a cool method the make the command entered not to disappear and stay on the screen.Precede commands with '& 'For Example:COMMAND ===> &C '110-PARA' '220-PARA' SCROLL ===> CSR****** ************************ TOP OF DATA **************000001 IDENTIFICATION DIVISION.000002 PROGRAM-ID. COBOLSAMY.000003 DATE-WRITTEN. APRIL 2004.After the execution of the command, the below command stays on the screen.This way you can entering the same command or modifying the command a little and using itmultiple times.

TIP # 005

ISPFWhile trying to open any member in a PDS, we sometimes come across"member in use" message. In that situation, if you want to know who is using the membercurrently, press F1 twice.

TIP # 006

ISPFWe usual search for members in a PDS by the first string of the members.Consider this situation .I have a PDS and I want to search it for member only by middle string of the members.e.g. there are some members like BESTJCL1,RESTJCL2,PESTCBL1, BESTCBL2,WESTCBL3,TESTASM1,BESTASM2...etcI want to find members which have CBL in them.How can I search and find these members?

Answer:Use ISPF 4.12 option.Specify the dataset to be searched and the pattern of the string.Specify the LANG type as COBAnd select the browse option.

TIP # 007

ISPFHow can I find the last 10 datasets that I have accessed ?

Answer:1.GO TO ISPF 3.4 option.2. On the top, there is a MENUBAR. Select REFLIST3. Select Option 1 in it.Using this option you can find out the last 30 datasets that you have accessed....

TIP # 008

ISPFAlternate to SuperCE Option(3.13) is to use the macro COMPARE .Use this when you there is less difference between the two files.1.Open a DSN in EDIT or VIEW Mode2. On the Command line , issue COMP 'YOUR.SECOND.COMPARISON.DSN'3. If you want only the changes to be listed, issue COMP'YOUR.SECOND.COMPARISON.DSN' EXC

TIP # 009

ISPFWhile Browsing Internet, we have some cool option called address autocomplete…we entersome letters in the address bar and the browser auto completes it with the closest guess.Does MAINFRAME has the same feature??

Answer:Yes! It has “Autocomplete” feature!!!How to use it?1.go to ISPF 3.4 ,2. enter KEYS in the command line,KEYS window will popup3. set any key to AUTOTYPE, save and exit2. now type any Dataset partially and press the assigned PFkey!!Note: It will not retrieve GDGs and VSAM files.

TIP # 010

ISPFI want to find a member but I don’t know the PDS to which it belongs. I only know the highlevel qualifier of the PDS.

Answer:For example, lets consider high level Qualifier as MYID.MYAPPLN.* and member as MYMEM1. Go to 3.4 and list all PDS with MYID.MYAPPLN.*2. Now issue, MEMBER MYMEM on the command line

Wrap the data in each record in ISPF

noreply@blogger.com (blogkns) — Thu, 30 Apr 2009 23:35:00 -0700

Q1.I have data which is of length 160. For some reasons, I want to wrap the data in each record to 80characters and have the next 80 characters in the next line. So basically what I am looking for is ,“Is there command similar to Wordwrap (as in Notepad or MS WORD) in mainframe?”

A1.Yes, with ISPF, one can wrap the data as required.To do that,

1.Open the dataset in ISPF EDIT mode.

2.In the first line, issue the line command: TF80 (as in this case I want to wrap to 80 chars perline)

3.All the subsequent lines will wrap to 80 chars per line.