Site Map
Table of Contents
Static Pages
- Post questions by: admin
August 8, 2009, 02:33
Post interview questions answers of all related to Microsoft.Net, Interview preparation, IIS, SQL, My SQL, Teacher Tarining, NTT, B.Ed, Entrance exam, Aptitute
- Members by: admin
December 10, 2009, 18:09
No description found for this item.
- Jobs by: admin
December 27, 2009, 14:52
Search jobs in microsoft technologies, java, oracle,php,db2, mysql. web designing,flash,silverlight, asp.net mvc
- Site Map by: admin
February 12, 2010, 02:17
This page contains the site table of contents. Use it to quickly find content on this website.
Blog Posts
- Microsoft .Net (32)
Contains all Microsoft Technology questions answers with a keen look. Many questions are live interview questions.
- Can we store filtered DataView in ViewState? by: smartbrain
January 25, 2010, 18:46
We can store only objects of the following types: 1. string 2. integers 3. boolean 4. Array 5. ArrayList 6. Hash tables 7. Custom types etc. Apart from…
- How can I create a Singleton class by using public constructor? by: meghna
January 11, 2010, 21:09
I have also asked a tricky question like this: Can we create a singleton class using public constructor? Simply answer is yes.
- How can I insert hyperlinks in ListBox? by: admin
November 3, 2009, 05:53
How can I insert hyperlinks in ListBox
- What's the top.Net class that everything is derived from? by: meghna
September 2, 2009, 17:55
System.object
- Can we maintain state in webservices? by: meghna
August 15, 2009, 03:00
There is no direct way provided by webservices to maintain state. But webservices can maintain the state by using asp.net instrinsic objects i.e Session and…
- What is cross page posting? by: meghna
August 8, 2009, 04:03
What is cross page posting?
- Asp.Net (13)
This category contains all asp.net interview questions
- Can I inherit two difference classes to partial classes? by: smartbrain
January 25, 2010, 20:20
Can I inherit two difference classes to partial classes? Following is the whole scenario of this question: I have two classes XYZ and ABC and two partial…
- Can we store filtered DataView in ViewState? by: smartbrain
January 25, 2010, 18:46
We can store only objects of the following types: 1. string 2. integers 3. boolean 4. Array 5. ArrayList 6. Hash tables 7. Custom types etc. Apart from…
- How can I insert hyperlinks in ListBox? by: admin
November 3, 2009, 05:53
How can I insert hyperlinks in ListBox
- How to add flash movie in my project? by: smartbrain
October 12, 2009, 13:19
Use object classid
- How to set width of Column in Gridview Control? by: smartbrain
October 12, 2009, 10:59
By default width of column handled automatically, means columns in Gridview control are sized automaticlaly internally column cells redered as HTML cell. On…
- Can you edit data in the Repeater control? by: meghna
September 2, 2009, 17:43
No, it just reads the information from its data source.
- Should validation(did the user enter a real date) occur server-ride or client-side?why? by: meghna
September 2, 2009, 17:06
Client-side.  This reduces an additional request to the server to validate the user input.
- What are the different types of assemblies? by: meghna
August 30, 2009, 23:36
Private, Public/ share, and Satellite. There is some debate for Satelite assemblies some says this is a type some says this is a technique.
- What is the Global.asax used for? by: meghna
August 30, 2009, 23:33
The Global. asax (including Global. asax.cs) is used to implement application and session level events. All variables are available of Global.asax through…
- Can we maintain state in webservices? by: meghna
August 15, 2009, 03:00
There is no direct way provided by webservices to maintain state. But webservices can maintain the state by using asp.net instrinsic objects i.e Session and…
- What is cross page posting? by: meghna
August 8, 2009, 04:03
What is cross page posting?
- I have a check boxes in datagrid and want to checked and unchecked on a specific operation. How to do this at client side? by: meghna
August 8, 2009, 03:56
I have a check boxes in datagrid and want to checked and unchecked on a specific operation. How to do this at client side?
- What is Form authentication? by: smartbrain
August 8, 2009, 03:50
What is Form authentication?
- Can I inherit two difference classes to partial classes? by: smartbrain
- CSharp (13)
Category contains all questions related to CSharp
- Can I inherit two difference classes to partial classes? by: smartbrain
January 25, 2010, 20:20
Can I inherit two difference classes to partial classes? Following is the whole scenario of this question: I have two classes XYZ and ABC and two partial…
- How can I create a Singleton class by using public constructor? by: meghna
January 11, 2010, 21:09
I have also asked a tricky question like this: Can we create a singleton class using public constructor? Simply answer is yes.
- How's method overriding different from overloding? by: meghna
September 2, 2009, 17:55
In overriding, you change the method behavior for a derived class. While, overloading simply involves having a method with the same name within the class.
- What does the Keyword 'virtual'mean in the method definition? by: meghna
September 2, 2009, 17:52
The method can be over-ridden.
- Are private class-level variables inherited? by: meghna
September 2, 2009, 17:48
Yes ,but they are not accessible, out-side the class.
- When you inherit a protected-class-level variable,who is it available to? by: meghna
September 2, 2009, 17:48
classes in the same namespace.
- Does c# supports multiple inheritance? by: meghna
September 2, 2009, 17:47
No, but we can use interfaces for that.
- How do you inherit from a class in c#? by: meghna
September 2, 2009, 17:13
Place a colon(:)and then the name of the base class. eg: public baseclass { / /signatures } public childclass : baseclass { //signature …
- What is the way to stop a long running thread? by: meghna
August 30, 2009, 23:46
Thread.Abort ( ) stops the thread execution at that moment itself.
- Can we use events with threading? by: meghna
August 30, 2009, 23:42
Yes, we can use event with thread,this is one of the techniques to synchronize one thread with other.
- What is method overloading? by: meghna
August 30, 2009, 23:39
Method overloading occurs when a class contains two methods with the same name, but different signatures.
- How can you reference current thread of the method? by: meghna
August 29, 2009, 00:59
'Thread Current thread' refers to the current thread running in the method.  'Current Thread  is a public Static property.
- What is the way to stop a long running thread? by: meghna
August 29, 2009, 00:58
Thread  abort()  stops  the  thread execution at that moment itself.
- Can I inherit two difference classes to partial classes? by: smartbrain
- VB.Net Interview (9)
Category related to all questions of VB.Net
- Can you declare the override method static while the original method is non-static? by: meghna
September 2, 2009, 17:57
No, you can't the signature of the virtual method must remain the same, only the keyword 'virtual is changed to keyword override'.
- How's method overriding different from overloding? by: meghna
September 2, 2009, 17:55
In overriding, you change the method behavior for a derived class. While, overloading simply involves having a method with the same name within the class.
- What does the Keyword 'virtual'mean in the method definition? by: meghna
September 2, 2009, 17:52
The method can be over-ridden.
- Are private class-level variables inherited? by: meghna
September 2, 2009, 17:48
Yes ,but they are not accessible, out-side the class.
- What is the way to stop a long running thread? by: meghna
August 30, 2009, 23:46
Thread.Abort ( ) stops the thread execution at that moment itself.
- Can we use events with threading? by: meghna
August 30, 2009, 23:42
Yes, we can use event with thread,this is one of the techniques to synchronize one thread with other.
- What is method overloading? by: meghna
August 30, 2009, 23:39
Method overloading occurs when a class contains two methods with the same name, but different signatures.
- How can you reference current thread of the method? by: meghna
August 29, 2009, 00:59
'Thread Current thread' refers to the current thread running in the method.  'Current Thread  is a public Static property.
- What is the way to stop a long running thread? by: meghna
August 29, 2009, 00:58
Thread  abort()  stops  the  thread execution at that moment itself.
- Can you declare the override method static while the original method is non-static? by: meghna
- silverlight (3)
Section deals all questions and answers related to Silverlight.
- What is the difference between WPF and Silverlight? by: admin
August 8, 2009, 00:13
What is the difference between WPF and Silverlight? Silverlight uses a particular implementation of a XAML parser, with that parser being part of the…
- What is XAML ? by: admin
August 8, 2009, 00:09
XAML : stands for eXtensible Application Markup Language and pronounced as zammel.
- Silverlight Frequently Asked Questions by: admin
August 7, 2009, 23:39
Here are some Silverlight FAQ: Q. What is Silverlight Tool Kit? Ans: To create an application or game you need to design, code and give some extra feature…
- What is the difference between WPF and Silverlight? by: admin
- LINQ (2)
- Define Lambda expressions by: smartbrain
December 9, 2009, 19:25
A Lambda expression is nothing but an Anonymous Function, can contain expressions and statements. Lambda expressions can be used mostly to…
- What is a Lambda expression? by: admin
October 13, 2009, 12:51
A Lambda expression is nothing but an Anonymous Function, can contain expressions and statements. Lambda expressions can be used mostly to create delegates or…
- Define Lambda expressions by: smartbrain
- Can we store filtered DataView in ViewState? by: smartbrain
- General (3)
Contains all the general articles for preparation of interview, presence of mind at time of interview etc.
- Is it possible to create constructor for an Abstract class? by: admin
April 29, 2010, 20:37
Abstract classes contain constructors
- CICS interview Questions Part – XIII by: neerajmehta1984
August 9, 2009, 11:57
Q316)   Difference between TSQ & TDQ A316)    TDQ is read destructive, TSQ is not. TSQ can be…
- Interview >> Best place for interview preparation by: admin
August 1, 2009, 18:14
Welcome all! This is the best place to prepare interview. Presently, we are updating our Interview Databank. Please stay back for numerous interview…
- Is it possible to create constructor for an Abstract class? by: admin
- Database Questions (10)
Contains all the questions of RDBMS questions
- Write query to get custom results by: smartbrain
February 8, 2010, 16:00
This question is asked in recent interview, following is the scenario: Q. I have a following table : University UtoTal Status StatusCnt U1 …
- Create dynamic query with dynamic joins by: admin
February 4, 2010, 20:30
Here is the scenario:
- How can I get the date of Last Monday of specified week? by: smartbrain
January 22, 2010, 22:20
How can I get the date of Last Monday of specified wek?
- DB2 : SQL Codes and Description by: neerajmehta1984
August 9, 2009, 00:16
DB2 : SQL Codes and Description
- DB2 understanding : Part – II by: neerajmehta1984
August 8, 2009, 23:58
LOAD Use LOAD to load one or more tables of a table space. LOAD loads records into the tables and builds or extends any indexes defined on them. If the…
- DB2 understanding : Part - I by: neerajmehta1984
August 8, 2009, 23:37
The whole series us updated by Deepthi Topics covered QMF SPUFI Program preparation and execution DCLGEN LOCKS DB2 Utilities
- Interview Questions DB2 : Part - II by: neerajmehta1984
August 8, 2009, 23:14
The following is the entire collection of DB2 interview questions: Q36. What are some characteristics of columns that benefit from indexes? A36. Primary…
- Interview Questions DB2 : Part - I by: neerajmehta1984
August 8, 2009, 23:04
The following is the entire collection of DB2 interview questions: Q1. What is a DB2 bind? A1. A DB2 bind is a process that builds an access path to DB2…
- MsSql Server (5)
This category contains all MsSQl Server Interview questions
- Write query to get custom results by: smartbrain
February 8, 2010, 16:00
This question is asked in recent interview, following is the scenario: Q. I have a following table : University UtoTal Status StatusCnt U1 …
- Create dynamic query with dynamic joins by: admin
February 4, 2010, 20:30
Here is the scenario:
- How can I get the date of Last Monday of specified week? by: smartbrain
January 22, 2010, 22:20
How can I get the date of Last Monday of specified wek?
- Change date format mm/dd/yy to dd/mm/yy using query? by: meghna
August 29, 2009, 01:00
Sql server stores date as yyyy/dd/mm and returns with time. use following query: Select CAST(DAY(GETDATE()) AS VARCHAR(2)) + '/' + CAST(MONTH(GETDATE())…
- How to create a new table with datafrom another table by: meghna
August 21, 2009, 11:34
Simply, you can use 'Insert Into' ex: Create Table newTable (id VarChar(10)) Insert Into newTable Select id from oldTable
- Write query to get custom results by: smartbrain
- Write query to get custom results by: smartbrain
- Company asked interview questions (4)
This category contains most asked interview questions by different companies.
- Can I inherit two difference classes to partial classes? by: smartbrain
January 25, 2010, 20:20
Can I inherit two difference classes to partial classes? Following is the whole scenario of this question: I have two classes XYZ and ABC and two partial…
- IBM (3)
Section contains all collection of interview questions, white papers, written interview etc.
- IBM Interview Questions – Section-3 by: neerajmehta1984
August 9, 2009, 13:53
SECTION 3 Choose the correct answer: 1)   Which VSAM clusters support only fixed length records?   …
- IBM Interview Questions – Section-2 by: neerajmehta1984
August 9, 2009, 13:51
SECTION 2 State whether True or False: 1.    All VSAM data sets reside on DASD devices.    Â…
- IBM Interview Questions - Section1 by: neerajmehta1984
August 9, 2009, 13:50
SECTION 1 Fill in the blanks: 1.    A logical record is a unit of information used to store data in a VSAM data set. 2.…
- IBM Interview Questions – Section-3 by: neerajmehta1984
- RSystems (1)
- Can I inherit two difference classes to partial classes? by: smartbrain
January 25, 2010, 20:20
Can I inherit two difference classes to partial classes? Following is the whole scenario of this question: I have two classes XYZ and ABC and two partial…
- Can I inherit two difference classes to partial classes? by: smartbrain
- Can I inherit two difference classes to partial classes? by: smartbrain
- UML (1)
All questions answers related to UML
- What are the good practices to use while designing for reuse by: admin
August 8, 2009, 00:02
What are the good practices to use while designing for reuse? noramally you will move common functinality in base class or create the abstract class with…
- What are the good practices to use while designing for reuse by: admin
- OOPs (6)
Category related to all OOPs questions and answers
- Can you declare the override method static while the original method is non-static? by: meghna
September 2, 2009, 17:57
No, you can't the signature of the virtual method must remain the same, only the keyword 'virtual is changed to keyword override'.
- How's method overriding different from overloding? by: meghna
September 2, 2009, 17:55
In overriding, you change the method behavior for a derived class. While, overloading simply involves having a method with the same name within the class.
- What does the Keyword 'virtual'mean in the method definition? by: meghna
September 2, 2009, 17:52
The method can be over-ridden.
- What is method overloading? by: meghna
August 30, 2009, 23:39
Method overloading occurs when a class contains two methods with the same name, but different signatures.
- What is object slicing by: meghna
August 8, 2009, 06:13
What is object slicing
- What is differance between Abstract and Interface by: smartbrain
August 7, 2009, 23:57
An abstract class is a class with at least one function without definitions. An Interface is a class which only contains function declarations, all the…
- Can you declare the override method static while the original method is non-static? by: meghna
- PHP (1)
All questions and answer for PHP
- What is hidden variable? what is its difference with the normal variable by: meghna
August 8, 2009, 06:10
No description found for this item.
- What is hidden variable? what is its difference with the normal variable by: meghna
- Mainframe (394)
Category contains all Mainframe Interview questions.
- IBM Interview Questions – Section-3 by: neerajmehta1984
August 9, 2009, 13:53
SECTION 3 Choose the correct answer: 1)   Which VSAM clusters support only fixed length records?   …
- IBM Interview Questions – Section-2 by: neerajmehta1984
August 9, 2009, 13:51
SECTION 2 State whether True or False: 1.    All VSAM data sets reside on DASD devices.    Â…
- IBM Interview Questions - Section1 by: neerajmehta1984
August 9, 2009, 13:50
SECTION 1 Fill in the blanks: 1.    A logical record is a unit of information used to store data in a VSAM data set. 2.…
- IMS interview questions by: neerajmehta1984
August 9, 2009, 12:35
Q1)    What is the physical nature of a database called? A1)    DBD Q2) …
- CICS interview Questions Part – XII by: neerajmehta1984
August 9, 2009, 11:54
Q271)   What is the command for reading a record form a TSQ? A271)    READQ TS, READQ Q272)Å
- CICS interview Questions Part – XI by: neerajmehta1984
August 9, 2009, 11:53
Q241)   If DATAONLY option is specified in the SEND MAP command what will happen? A241)    Only…
- CICS interview Questions Part – X by: neerajmehta1984
August 9, 2009, 11:50
Q201)   What are the situations under which NEWCOPY is required ? A201)    When a program…
- CICS interview Questions Part – IX by: neerajmehta1984
August 9, 2009, 11:48
Q171)   Can you use OCCURS in a BMS map? If you do, what are the issues related with its use? A171)  Â…
- CICS interview Questions Part – II by: neerajmehta1984
August 9, 2009, 07:37
Q11) Mention the option (along with argument type) used in a CICS command to retrieve the response code after execution of the command. A11) RESP(…
- CICS interview Questions Part – I by: neerajmehta1984
August 9, 2009, 07:32
Q1) What are the six different types of argument values in COBOL that can be placed in various options of a CICS command? A1) ·Data Value…
- Customer Information Control System(CICS) - at a glance by: neerajmehta1984
August 9, 2009, 07:27
IBM’s Customer Information Control System (CICS) is an on-line teleprocessing system developed by IBM. By providing a sophisticated control…
- Cobol Interview Questions - unsolved by: neerajmehta1984
August 9, 2009, 07:10
Following are the unsolved questions What R 2 of the common forms of the EVALUATE STATEMENT ? What does the initialize statement do ? What is the…
- COBOL interview Questions Part – IV by: neerajmehta1984
August 9, 2009, 07:07
Q106) What is Redefines clause? A106) Redefines clause is used to allow the same storage allocation to be referenced by different data names…
- COBOL interview Questions Part – III by: neerajmehta1984
August 9, 2009, 07:03
Q76) What is the default value(s) for an INITIALIZE and what keyword allows for an override of the default. A76) INITIALIZE moves spaces to alphabetic…
- COBOL interview Questions Part - II by: neerajmehta1984
August 9, 2009, 06:58
Q41) What is the maximum value that can be stored in S9(8) COMP? Q41) 99999999 Q42) What is COMP SYNC? Q42) Causes the item to be aligned on…
- COBOL interview Questions Part - I by: neerajmehta1984
August 9, 2009, 06:55
Q1) Name the divisions in a COBOL program ?. A1) IDENTIFICATION DIVISION, ENVIRONMENT DIVISION, DATA DIVISION, PROCEDURE DIVISION. Q2) What are the…
- Important Tips - IBM MainFrame by: neerajmehta1984
August 9, 2009, 06:14
Block contains 0 records is used to specify that the actual size of the block of the referenced file will be specified in the corresponding JCL. Label…
- What is meant by AUTO COMMIT? by: neerajmehta1984
August 9, 2009, 01:43
AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed.
- What is a DB2 bind? by: neerajmehta1984
August 9, 2009, 00:33
A bind is a process that builds "access paths" to DB2 tables. A bind uses Database Request Modules (DBRMs) from the DB2 precompile step as input and produces…
- Explain what a plan is? by: neerajmehta1984
August 9, 2009, 00:32
A plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name.
- What is an alias? by: neerajmehta1984
August 9, 2009, 00:29
It is an alternate name that can be used in SQL statements to refer to a table or view in the same or a remote DB2 subsystem.
- What is an access path? by: neerajmehta1984
August 9, 2009, 00:27
The path that is used to get to data specified in SQL statements.
- What is DB2 (IBM Database 2)? by: neerajmehta1984
August 9, 2009, 00:18
DB2 is a subsystem of the MVS operating system. It is a Database Management System (DBMS) for that operating system.
- DB2 : SQL Codes and Description by: neerajmehta1984
August 9, 2009, 00:16
DB2 : SQL Codes and Description
- DB2 understanding : Part – II by: neerajmehta1984
August 8, 2009, 23:58
LOAD Use LOAD to load one or more tables of a table space. LOAD loads records into the tables and builds or extends any indexes defined on them. If the…
- DB2 understanding : Part - I by: neerajmehta1984
August 8, 2009, 23:37
The whole series us updated by Deepthi Topics covered QMF SPUFI Program preparation and execution DCLGEN LOCKS DB2 Utilities
- Interview Questions DB2 : Part - II by: neerajmehta1984
August 8, 2009, 23:14
The following is the entire collection of DB2 interview questions: Q36. What are some characteristics of columns that benefit from indexes? A36. Primary…
- Interview Questions DB2 : Part - I by: neerajmehta1984
August 8, 2009, 23:04
The following is the entire collection of DB2 interview questions: Q1. What is a DB2 bind? A1. A DB2 bind is a process that builds an access path to DB2…
- DB2 (139)
Category contains collection of all questions related to IBM mainframe DB2
- How can one determine the status of a tablespace? by: neerajmehta1984
August 9, 2009, 12:29
By using the DISPLAY DATABASE command.
- How is the status of a utility reset after it has been stopped by DB2 ? by: neerajmehta1984
August 9, 2009, 12:29
By issuing the START RLIMIT command.
- Which command is issued to establish the Boot Strap Data Set after an I/O failure? by: neerajmehta1984
August 9, 2009, 12:29
The DBA would issue a RECOVER BSDS command.
- Which DB2 command is used to retrieve environmental information? by: neerajmehta1984
August 9, 2009, 12:28
The DISPLAY command can return the following environmental data: DATABASE info, RLIMIT info, THREAD info, TRACE info, and UTILITY info.
- What is read-only cursor? by: neerajmehta1984
August 9, 2009, 12:28
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword •…
- When is the results table for the query in a DECLARE CURSOR statement created? by: neerajmehta1984
August 9, 2009, 12:27
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement.
- What is the syntax required for the creation of a cursor? by: neerajmehta1984
August 9, 2009, 12:27
EXEC SQL DECLARE cur_name CURSOR for SELECT col1,col2 FROM table1 WHERE col1 = search_condition END-EXEC.
- Explain the use of the WHERE clause. by: neerajmehta1984
August 9, 2009, 06:05
It directs DB2 to extract data from rows where the value of the column is the same as the current value of the host variable.
- : what is the maximum number of tables that can be joined ? by: neerajmehta1984
August 9, 2009, 06:04
Fifteen
- How do you declare a host variable (in COBOL) for an attribute named EMP-NAME of type VARCHAR(25) ? by: neerajmehta1984
August 9, 2009, 06:04
01 EMP-GRP. 49 E-LEN PIC S9(4) COMP. 49 E-NAME PIC X(25).
- How to see the structure of db2 table?? by: neerajmehta1984
August 9, 2009, 06:04
Using QMF.
- What is the difference between Where and Having Clause by: neerajmehta1984
August 9, 2009, 06:03
WHERE is for Rows and HAVING is for Groups
- How will you delete duplicate records from a table? by: neerajmehta1984
August 9, 2009, 06:03
Delete From Table1Where Id In (Select Id From Tabel1 As Temp Group By Id Having Count(*) >1)
- What are the levels of isolation available with DB2V4 by: neerajmehta1984
August 9, 2009, 06:02
CS RR UR( added new for DB2V4 which stands for uncommited read which allows to retreive records from the space which has exclusive locks also but data…
- What is the difference between TYPE 1 index & TYPE 2 index by: neerajmehta1984
August 9, 2009, 06:02
TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be…
- What does CURRENTDATA option in bind indicate by: neerajmehta1984
August 9, 2009, 06:02
CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been changed to NO. Therefore it is necessary to change all…
- when does the sql statement gets executed when you use cursor in the application programming ? by: neerajmehta1984
August 9, 2009, 06:02
sql statement gets executed when we open cursor
- What's the maximum number of characters that a tablename can have? by: neerajmehta1984
August 9, 2009, 06:01
The answer is 18 characters.
- Can you define an Index if the table size less than 10 PAGES? by: neerajmehta1984
August 9, 2009, 06:01
NO
- what's the percentage free space for by: neerajmehta1984
August 9, 2009, 06:01
ZERO
- what's the best locksize that you could use when you create a tablespace? by: neerajmehta1984
August 9, 2009, 06:00
The answer is Locksize = ANY.Unless you are Sure what's the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically…
- What is the size of a data page? by: neerajmehta1984
August 9, 2009, 06:00
4K to 8K
- CAN ALL USERS HAVE THE PRIVILAGE TO USE THE SQL STATEMENT SELECT * (DML)? by: neerajmehta1984
August 9, 2009, 06:00
NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT.
- The only place of VSAM KSDS in DB2 is? by: neerajmehta1984
August 9, 2009, 06:00
BSDS is a VSAM KSDS.
- MAX. NO OF ROWS PER PAGE by: neerajmehta1984
August 9, 2009, 06:00
127
- What are the functions of Bind? by: neerajmehta1984
August 9, 2009, 05:59
: BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart…
- What is a corelated subquerry? by: neerajmehta1984
August 9, 2009, 05:59
In a subquerry, if the outer querry reffers back to the outcome of innerquerry it is called corelated subquerry. That's why the outer querry is evaluated first…
- what is the difference between join and union? by: neerajmehta1984
August 9, 2009, 05:59
join is used to retrive data from different tables using a single sql statement.union is used to combine the results of two or more sql querries.
- When Can you be sure that a query will return only one row? by: neerajmehta1984
August 9, 2009, 05:59
When you use the primary key and only the primary key in the where clause.
- WHAT IS THE NAME OF THE DEFAULT db2 CATALOG DATABASE? by: neerajmehta1984
August 9, 2009, 05:58
DSNDB06
- What should be specified along with a cursor in order to continue updating process after commit? by: neerajmehta1984
August 9, 2009, 05:58
With Hold option.
- Can we declare DB2 HOST variable in COBOL COPY book? by: neerajmehta1984
August 9, 2009, 05:56
NO.If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not…
- what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain? by: neerajmehta1984
August 9, 2009, 05:56
Pic s9(x-y)V9(Y) Comp-3; the current SQLID contains the current authorization ID.
- what is the error code -803 ? by: neerajmehta1984
August 9, 2009, 05:56
unique index violation
- What is the command used by TSO users to invoke DB2? by: neerajmehta1984
August 9, 2009, 05:56
DSN RUN
- How many Bufferpools are there in DB2 and what are they? by: neerajmehta1984
August 9, 2009, 05:55
There are 4 Bufferpools.They are BP0,BP1,BP2 and BP32.
- What are the different methods of accessing db2 from tso?B.How is the connection established between TSO & DB2? by: neerajmehta1984
August 9, 2009, 05:55
There are three ways in establishing tso/db2 connection 1. SPUFI 2. QMF 3. CATALOG VISIBILITY B. A thread between TSO & DB2 is established while attempting…
- Can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table? by: neerajmehta1984
August 9, 2009, 05:54
yes possible. until the updation or selection is commited db2 table will not be restructured. new column definition will be there but it will not be included…
- What is JOIN and different types of JOIN. by: neerajmehta1984
August 9, 2009, 05:53
The ability to join rows and combaine data from two or more tables is one of the most powerful features of relational system.Three type of joins:1. Equi-join2.N…
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this? by: neerajmehta1984
August 9, 2009, 05:53
Can any one give me the answer for this?
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this? by: neerajmehta1984
August 9, 2009, 05:52
SELECT * FROM SYSTABLES WHERE OWNER=
- I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this? by: neerajmehta1984
August 9, 2009, 05:50
The query SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = 'owner id' This displays the table names with that If you want only the number of tables give the…
- maxx number of columns in a db2 table by: neerajmehta1984
August 9, 2009, 05:49
224
- How do you debug a DB2 STORED PROCEDURE by: neerajmehta1984
August 9, 2009, 05:49
I dont know, can anyone help to answer ?
- While the Copy Pending flag is on, is the tablespace that is just recovered available for use? by: neerajmehta1984
August 9, 2009, 05:48
No, it is not available.
- What will the STOSPACE utility do? by: neerajmehta1984
August 9, 2009, 05:47
This utility updates DB2 catalog columns that tell how much space is allocated for storage groups and related tablespace and indexes.
- What will the RUNSTATS utility do? by: neerajmehta1984
August 9, 2009, 05:46
RUNSTATS will scan tablespaces or indexes gathering information about utilization of space and efficiency of indexes. The information is stored in the DB2…
- What will the REPAIR utility do? by: neerajmehta1984
August 9, 2009, 05:45
It will repair invalid data with valid data and/or reset status conditions. The data may be your own data or data you would not normally access : space map…
- What will the REORG utility do? by: neerajmehta1984
August 9, 2009, 05:45
It will reorganize a tablespace to improve access performance and reorganize indexes so that they are more efficiently clustered.
- What will the RECOVER utility do? by: neerajmehta1984
August 9, 2009, 05:45
This utility recovers data to the current state or a previous state. The largest unit of data recovery is the tablespace; the smallest is a page. Data is…
- What can the MERGECOPY utility do? by: neerajmehta1984
August 9, 2009, 05:44
It can merge several incremental copies of a tablespace to make a single incremental copy and it can merge incremental copies with a full-image copy to make a…
- What will the LOAD utility do? by: neerajmehta1984
August 9, 2009, 05:44
The LOAD utility can load data into one or more tables in a tablespace or partition. The LOAD can also replace contents of a single partition or an entire…
- What will the copy utility do? by: neerajmehta1984
August 9, 2009, 05:43
The copy utility will create an image copy of a tablespace or a dataset within a tablespace. There are two types of image copies : full and incremental. A full…
- Once you create a view, where would information about the view be stored? by: neerajmehta1984
August 9, 2009, 05:41
When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.
- Where could you look if you had a question about whether a column has been defined as an index? by: neerajmehta1984
August 9, 2009, 05:41
This information can be found in SYSIBM.SYSINDEXES.
- Where would you find information about the type of database authority held by a user? by: neerajmehta1984
August 9, 2009, 05:41
SYSIBM.SYSDBAUTH.
- What information can you find in SYSIBM.SYSLINKS table? by: neerajmehta1984
August 9, 2009, 05:41
The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints.
- What information is contained in a SYSCOPY "entry"? by: neerajmehta1984
August 9, 2009, 05:40
It includes the name of database, tablespace name, and the image copy type (full, incremental, etc.), as well as the date and time each copy was made.
- What information is held in SYSIBM.SYSCOPY? by: neerajmehta1984
August 9, 2009, 05:40
The SYSIBM.SYSCOPY table contains information about image copies made of the tablespaces.
- In which column of which DB2 catalog would you find the length of rows for all tables? by: neerajmehta1984
August 9, 2009, 05:40
In the RECLENGTH column of SYSIBM.SYSTABLES.
- What is the DB2 catalog? by: neerajmehta1984
August 9, 2009, 05:40
The DB2 catalog is a set of tables that contain information about all the DB2 objects (tables, views, plans, etc.).
- After a table has been recovered, which flag is turned on? by: neerajmehta1984
August 9, 2009, 05:40
The Copy Pending flag is turned on.
- How are write I/Os from the buffer pool executed? by: neerajmehta1984
August 9, 2009, 05:39
Asynchronously.
- What is the maximum number of partitions allowed in a partitioned tablespace? by: neerajmehta1984
August 9, 2009, 05:39
The maximum is 64.
- What are the names of the different types of DB2 tablespaces? by: neerajmehta1984
August 9, 2009, 05:39
Simple, segmented and partitioned.
- Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2? by: neerajmehta1984
August 9, 2009, 05:39
DB2 can be invoked by TSO users by using the DSN RUN command.
- What are the three types of page locks that can be "held"? by: neerajmehta1984
August 9, 2009, 05:39
Exclusive, update, and share.
- What type of information is contained on the BSDS? by: neerajmehta1984
August 9, 2009, 05:38
The BSDS contains information about active and archive logs, their dataset names and volumes on which they reside.
- Can DASD types assigned to storage groups by intermixed (i.e., 3350s and 3380s)? by: neerajmehta1984
August 9, 2009, 05:38
Simply No.
- When a transaction issues a commit, to what is the commit writing? by: neerajmehta1984
August 9, 2009, 05:38
A commit triggers a write to a log record.
- What is a data model? by: neerajmehta1984
August 9, 2009, 05:38
A data model is a way of representing entities, attributes and relationships.
- What does a view do? by: neerajmehta1984
August 9, 2009, 05:38
A view restricts access to specific columns and rows.
- What is a view? by: neerajmehta1984
August 9, 2009, 05:37
A view is an alternative representation of data contained in one or more tables. A view can include all or some of the columns contained in the table or…
- What is a unique index? by: neerajmehta1984
August 9, 2009, 05:36
An index specified as unique is an index for which no duplicates are allowed.
- What is the format (internal layout) of 'TIMESTAMP'? by: neerajmehta1984
August 9, 2009, 05:36
This is a seven-part value that consists of a date (yymmdd) and time (hhmmss and microseconds).
- How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace? by: neerajmehta1984
August 9, 2009, 05:35
1. If the tablespace used is only allocated to that STOGROUP : • ALTER STOGROUP-add volume (new) delete volume (old) • REORG…
- What is a tablespace? by: neerajmehta1984
August 9, 2009, 05:35
A tablespace is a VSAM dataset which is used to store one or more tables. The physical page can consist of 4K or 32K pages.
- Describe what a table is? by: neerajmehta1984
August 9, 2009, 05:35
A table is a DB2 structure in which column names are used to specify the information that is being stored by row.
- What is meant by synonym? by: neerajmehta1984
August 9, 2009, 05:35
A synonym is an alternate name for a table or view which is stored in the SYSIBM.SYSSYNONYMS table.
- Describe what a storage group (STOGROUP) is? by: neerajmehta1984
August 9, 2009, 05:35
A STOGROUP is a named collection of DASD volumes to be used by tablespace and index space of databases. The volumes of a STOGROUP must be of the same device…
- What is a row? by: neerajmehta1984
August 9, 2009, 05:27
A row is a single occurrence of columns (of data) described by the table definition.
- What is meant by a repeatable read? by: neerajmehta1984
August 9, 2009, 05:26
When an application program executes with repeatable read protection, rows referenced by the program cannot be changed by other programs until the program…
- Describe referential integrity? by: neerajmehta1984
August 9, 2009, 05:26
Referential integrity refers to a feature in DB2 that is used to ensure consistency of data in the database.
- Where are plans stored? by: neerajmehta1984
August 9, 2009, 05:26
Each plan is defined uniquely in the SYSIBM.SYSPLAN table to correspond to the transactions that are to execute that plan.
- What is a Resource Control Table (RCT)? Describe its characteristics. by: neerajmehta1984
August 9, 2009, 05:26
The RCT is a table that is defined to a DB2/CICS region. It contains control characteristics which are assembled via the DSNCRCT macros. The RCT matches the…
- What is a recovery log? by: neerajmehta1984
August 9, 2009, 05:25
A recovery log is a collection of records that describes sequence of events that occur in DB2. The information is needed for recovery in the event of a failure…
- Describe a primary key? by: neerajmehta1984
August 9, 2009, 05:25
A primary key is a key that is unique, nonnull and is part of the definition of a table. A table must have a primary key to be defined as parent.
- What is a predicate? by: neerajmehta1984
August 9, 2009, 05:25
A predicate is an element of a search condition that expresses or implies a comparison operation.
- What is a pagespace? by: neerajmehta1984
August 9, 2009, 05:23
Pagespace refers either to an unpartitioned table to an index space, or to a single partition of a partitioned table of index space.
- What is a page? by: neerajmehta1984
August 9, 2009, 05:23
This is the unit of storage within a tablespace or indexspace that is accessed by DB2.
- What will the DB2 optimizer do? by: neerajmehta1984
August 9, 2009, 05:22
The optimizer is a DB2 component that processes SQL statements and selects the access paths.
- What is an object? by: neerajmehta1984
August 9, 2009, 05:22
An object is anything that is managed by DB2 (that is, databases, tablespaces, tables, views, indexes, or synonyms), but not the data itself.
- What is meant by null? by: neerajmehta1984
August 9, 2009, 05:22
This is a special value that indicates the absence of data in a column. This value is indicated by a negative value, usually -1.
- What is a “nonleaf†page? by: neerajmehta1984
August 9, 2009, 05:22
This is a page that contains keys and page numbers of other pages in the index. Nonleaf pages never point to actual data.
- What is meant by locking? by: neerajmehta1984
August 9, 2009, 05:21
Locking is a process that is used to ensure integrity of data. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked…
- What is a join? by: neerajmehta1984
August 9, 2009, 05:21
A join is a relational operation that allows retrieval of data from two or more tables based on matching column values.
- What is meant by indicator variable? by: neerajmehta1984
August 9, 2009, 05:20
An indicator variable is an integer variable used to show whether its associated host variable has been assigned a null value.
- What is meant by an index scan? by: neerajmehta1984
August 9, 2009, 05:20
When an entire index (or a portion thereof) is scanned to locate rows, we call this an index scan. This type of access can be used, for example, to select rows…
- What is an index key? by: neerajmehta1984
August 9, 2009, 05:20
It is a column or set of columns in a table used to determine the order of index entries.
- What is meant by an index? by: neerajmehta1984
August 9, 2009, 05:19
An index is a set of row identifiers (RIDS) or pointers that are logically ordered by the values of a column that has been specified as being an index. Indexes…
- What is an image copy? by: neerajmehta1984
August 9, 2009, 05:19
It is an exact reproduction of all or part of a tablespace. DB2 provides utility programs to make full-image copies (to copy the entire tablespace) or…
- What is a host variable? by: neerajmehta1984
August 9, 2009, 05:19
This is a data item that is used in an SQL statement to receive a value or to supply a value. It must be preceded by a colon (:) to tell DB2 that the variable…
- What does the term "grant privileges" mean? by: neerajmehta1984
August 9, 2009, 05:18
Grant privileges means giving access/authority to DB2 users.
- What will the GRANT option do? by: neerajmehta1984
August 9, 2009, 05:18
It will grant privileges to a list of one or more users. If the GRANT option is used in conjunction with the "PUBLIC" option, then all users are granted…
- What will the FREE command do to a plan? by: neerajmehta1984
August 9, 2009, 05:17
It will drop (delete) that existing plan.
- What is a foreign key? by: neerajmehta1984
August 9, 2009, 05:17
A foreign key is a column (or combination of columns) in a table whose values are required to match those of the primary key in some other table.
- What will the EXPLAIN do? by: neerajmehta1984
August 9, 2009, 05:17
EXPLAIN obtains information (which indexes are used, whether sorting is necessary, which level of locking is applied) about how SQL statements in the DBRM will…
- What is meant by entity integrity? by: neerajmehta1984
August 9, 2009, 05:16
Entity integrity is when the primary key is in fact unique and not null.
- What is meant by embedded SQL? by: neerajmehta1984
August 9, 2009, 05:16
They are SQL statements that are embedded within an application program and are prepared during program preparation process before the program is executed.…
- What is meant by dynamic SQL? by: neerajmehta1984
August 9, 2009, 05:16
Dynamic SQL are SQL statements that are prepared and executed within a program while the program is executing. The SQL source is contained in host variables…
- What does DSNDB07 database do? by: neerajmehta1984
August 9, 2009, 05:16
DSNDB07 is where DB2 does its sorting. It includes DB2's sort workarea and external storage.
- What is a Declarations Generator (DCLGEN)? by: neerajmehta1984
August 9, 2009, 05:15
DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the…
- What are data types? by: neerajmehta1984
August 9, 2009, 05:15
They are attributes of columns, literal and host variables. The data types are SMALLINT, INTEGER, FLOAT, DECIMAL, CHAR, VARCHAR, DATE and TIME.
- What is a data page? by: neerajmehta1984
August 9, 2009, 05:15
A data page is a unit of retrievable data, either 4K or 32K (depending on how the table is defined) containing user or catalog information.
- What is a Database Request Module (DBRM)? by: neerajmehta1984
August 9, 2009, 05:14
A DBRM is a DB2 component created by the DB2 precompiler containing the SQL source statements extracted from the application program. DBRMs are input to the…
- What is the function of the Data Manager? by: neerajmehta1984
August 9, 2009, 05:14
The Data Manager is a DB2 component that manages the physical databases). It invokes other system components as necessary to perform detailed functions such as…
- What is cursor stability? by: neerajmehta1984
August 9, 2009, 05:14
It is cursor stability that "tells" DB2 that database values read by this application are protected only while they are being used. (Changed values are…
- What is meant by concurrency? by: neerajmehta1984
August 9, 2009, 05:13
Concurrency is what allows more than one DB2 application process to access the same data at essentially the same time. Problems may occur, such as lost…
- What will the COMMIT accomplish? by: neerajmehta1984
August 9, 2009, 05:13
COMMIT will allow data changes to be permanent. This then permits the data to be accessed by other units of work. When a COMMIT occurs, locks are freed so that…
- What is a clustering index? by: neerajmehta1984
August 9, 2009, 05:12
It is a type index that : • locates table rows • Determines how rows are grouped together in the tablespace
- On the create tablespace, what does the CLOSE parameter do? by: neerajmehta1984
August 9, 2009, 05:12
CLOSE physically closes the tablespace when no one is working on the object. DB2 (Release 2.3) will logically close tablespaces.
- How many buffer pools are there in DB2? by: neerajmehta1984
August 9, 2009, 05:11
There are four buffer pools namely : BPO, BPI, BP2, and BP32.
- What is a buffer pool? by: neerajmehta1984
August 9, 2009, 05:11
A buffer pool is main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes and is made up of either 4K or 32K…
- What is the function of Buffer Manager? by: neerajmehta1984
August 9, 2009, 05:10
The Buffer Manager is the DB2 component responsible for physically transferring data between an external medium and (virtual) storage (performs the actual I/O…
- What is a base table? by: neerajmehta1984
August 9, 2009, 05:09
A base table is a "real" table-a table that physically exists, in that there are physical stored records.
- What is meant by AUTO COMMIT? by: neerajmehta1984
August 9, 2009, 05:09
AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed.
- What is meant by attachment facility? by: neerajmehta1984
August 9, 2009, 05:09
The attachment facility is an interface between DB2 and TSO, IMS/VS, CICS or batch address spaces. It allows application programs to access DB2.
- What information is used as input to the bind process? by: neerajmehta1984
August 9, 2009, 05:08
1. The database request model produced during the precompile. 2. The SYSIBM.SYSSTMT table of the DB2 catalog.
- What is meant by AUTO COMMIT? by: neerajmehta1984
August 9, 2009, 01:43
AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed.
- What is a DB2 bind? by: neerajmehta1984
August 9, 2009, 00:33
A bind is a process that builds "access paths" to DB2 tables. A bind uses Database Request Modules (DBRMs) from the DB2 precompile step as input and produces…
- Explain what a plan is? by: neerajmehta1984
August 9, 2009, 00:32
A plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name.
- What is an alias? by: neerajmehta1984
August 9, 2009, 00:29
It is an alternate name that can be used in SQL statements to refer to a table or view in the same or a remote DB2 subsystem.
- What is an access path? by: neerajmehta1984
August 9, 2009, 00:27
The path that is used to get to data specified in SQL statements.
- What is DB2 (IBM Database 2)? by: neerajmehta1984
August 9, 2009, 00:18
DB2 is a subsystem of the MVS operating system. It is a Database Management System (DBMS) for that operating system.
- DB2 : SQL Codes and Description by: neerajmehta1984
August 9, 2009, 00:16
DB2 : SQL Codes and Description
- DB2 understanding : Part – II by: neerajmehta1984
August 8, 2009, 23:58
LOAD Use LOAD to load one or more tables of a table space. LOAD loads records into the tables and builds or extends any indexes defined on them. If the…
- DB2 understanding : Part - I by: neerajmehta1984
August 8, 2009, 23:37
The whole series us updated by Deepthi Topics covered QMF SPUFI Program preparation and execution DCLGEN LOCKS DB2 Utilities
- Interview Questions DB2 : Part - II by: neerajmehta1984
August 8, 2009, 23:14
The following is the entire collection of DB2 interview questions: Q36. What are some characteristics of columns that benefit from indexes? A36. Primary…
- Interview Questions DB2 : Part - I by: neerajmehta1984
August 8, 2009, 23:04
The following is the entire collection of DB2 interview questions: Q1. What is a DB2 bind? A1. A DB2 bind is a process that builds an access path to DB2…
- How can one determine the status of a tablespace? by: neerajmehta1984
- Cobol (29)
Category contains all relevant question collection related to COBOL
- CICS interview Questions Part – VIII by: neerajmehta1984
August 9, 2009, 11:46
Q141)   How do you get data from a task that began with a START command? A141)    The RETRIEVE…
- CICS interview Questions Part – VII by: neerajmehta1984
August 9, 2009, 07:49
Q122)   What tables must be updated when adding a new transaction and program? A122)    At a bare…
- CICS interview Questions Part – VI by: neerajmehta1984
August 9, 2009, 07:47
Q71)  What does the following transactions do? A71)  CEDF : CICS-supplied Execution Diagnostic …
- CICS interview Questions Part – V by: neerajmehta1984
August 9, 2009, 07:43
Q51)  What is the difference between EXEC CICS HANDLE CONDTION and an EXEC CICS IGNORE command? A51)  A HANDLE CONDITION…
- CICS interview Questions Part – IV by: neerajmehta1984
August 9, 2009, 07:41
Q32)  Code a program meeting the following requirements. ‘EMPS’ is a transaction used to return information…
- CICS interview Questions Part – III by: neerajmehta1984
August 9, 2009, 07:39
Q21) What is the option specified in the read operation to gain multiple concurrent operations on the same dataset? A21) REQID(value).
- CICS interview Questions Part – I by: neerajmehta1984
August 9, 2009, 07:32
Q1) What are the six different types of argument values in COBOL that can be placed in various options of a CICS command? A1) ·Data Value…
- Customer Information Control System(CICS) - at a glance by: neerajmehta1984
August 9, 2009, 07:27
IBM’s Customer Information Control System (CICS) is an on-line teleprocessing system developed by IBM. By providing a sophisticated control…
- Cobol Interview Questions - unsolved by: neerajmehta1984
August 9, 2009, 07:10
Following are the unsolved questions What R 2 of the common forms of the EVALUATE STATEMENT ? What does the initialize statement do ? What is the…
- COBOL interview Questions Part – IV by: neerajmehta1984
August 9, 2009, 07:07
Q106) What is Redefines clause? A106) Redefines clause is used to allow the same storage allocation to be referenced by different data names…
- COBOL interview Questions Part – III by: neerajmehta1984
August 9, 2009, 07:03
Q76) What is the default value(s) for an INITIALIZE and what keyword allows for an override of the default. A76) INITIALIZE moves spaces to alphabetic…
- COBOL interview Questions Part - II by: neerajmehta1984
August 9, 2009, 06:58
Q41) What is the maximum value that can be stored in S9(8) COMP? Q41) 99999999 Q42) What is COMP SYNC? Q42) Causes the item to be aligned on…
- COBOL interview Questions Part - I by: neerajmehta1984
August 9, 2009, 06:55
Q1) Name the divisions in a COBOL program ?. A1) IDENTIFICATION DIVISION, ENVIRONMENT DIVISION, DATA DIVISION, PROCEDURE DIVISION. Q2) What are the…
- How do you define a sort file in JCL that runs the COBOL program? by: neerajmehta1984
August 9, 2009, 06:48
Use the SORTWK01, SORTWK02,..... dd names in the step. Number of sort datasets depends on the volume of data being sorted, but a minimum of 3 is required.
- How do you sort in a COBOL program? Give sort file definition, sort statement syntax and meaning. by: neerajmehta1984
August 9, 2009, 06:46
Syntax: SORT file-1 ON ASCENDING/DESCENDING KEY key.... USING file-2 GIVING file-3. USING can be substituted by INPUT PROCEDURE IS para-1 THRU para-2 GIVING…
- My program has an array defined to have 10 items. Due to a bug, I find that even if the program access the 11th item in this array, the program does not abend. What is wrong with it? by: neerajmehta1984
August 9, 2009, 06:46
Must use compiler option SSRANGE if you want array bounds checking. Default is NOSSRANGE
- What is binary search? by: neerajmehta1984
August 9, 2009, 06:46
Search on a sorted array. Compare the item to be searched with the item at the center. If it matches, fine else repeat the process with the left half or the…
- What should be the sorting order for SEARCH ALL? by: neerajmehta1984
August 9, 2009, 06:46
It can be either ASCENDING or DESCENDING. ASCENDING is default. If you want the search to be done on an array sorted in descending order, then while defining…
- What is the difference between SEARCH and SEARCH ALL? by: neerajmehta1984
August 9, 2009, 06:45
SEARCH - is a serial search. SEARCH ALL - is a binary search & the table must be sorted ( ASCENDING/DESCENDING KEY clause to be used & data loaded in…
- What is the difference between index and subscript? by: neerajmehta1984
August 9, 2009, 06:45
Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using…
- Can the OCCURS clause be at the 01 level? by: neerajmehta1984
August 9, 2009, 06:45
No
- How do you define a table/array in COBOL? by: neerajmehta1984
August 9, 2009, 06:45
ARRAYS. 05 ARRAY1 PIC X(9) OCCURS 10 TIMES. 05 ARRAY2 PIC X(6) OCCURS 20 TIMES INDEXED BY WS-INDEX.
- What does the IS NUMERIC clause establish ? by: neerajmehta1984
August 9, 2009, 06:44
IS NUMERIC can be used on alphanumeric items, signed numeric & packed decimal items and unsigned numeric & packed decimal items. IS NUMERIC returns…
- What is level 66 used for ? by: neerajmehta1984
August 9, 2009, 06:44
For RENAMES clause.
- What is 88 level used for ? by: neerajmehta1984
August 9, 2009, 06:44
For condition names.
- What is 77 level used for ? by: neerajmehta1984
August 9, 2009, 06:44
Elementary level item. Cannot be subdivisions of other items (cannot be qualified), nor can they be subdivided themselves.
- What does the INITIALIZE verb do? - GS by: neerajmehta1984
August 9, 2009, 06:33
Alphabetic, Alphanumeric fields & alphanumeric edited items are set to SPACES. Numeric, Numeric edited items set to ZERO. FILLER , OCCURS DEPENDING ON…
- What are the different data types available in COBOL? by: neerajmehta1984
August 9, 2009, 06:33
Alpha-numeric (X), alphabetic (A) and numeric (9).
- Name the divisions in a COBOL program ?. by: neerajmehta1984
August 9, 2009, 06:33
IDENTIFICATION DIVISION, ENVIRONMENT DIVISION, DATA DIVISION, PROCEDURE DIVISION.
- CICS interview Questions Part – VIII by: neerajmehta1984
- CICS (13)
Section contains all interview questions answers collection related to IBM’s Customer Information Control System (CICS)
- CICS interview Questions Part – XII by: neerajmehta1984
August 9, 2009, 11:54
Q271)   What is the command for reading a record form a TSQ? A271)    READQ TS, READQ Q272)Å
- CICS interview Questions Part – XI by: neerajmehta1984
August 9, 2009, 11:53
Q241)   If DATAONLY option is specified in the SEND MAP command what will happen? A241)    Only…
- CICS interview Questions Part – X by: neerajmehta1984
August 9, 2009, 11:50
Q201)   What are the situations under which NEWCOPY is required ? A201)    When a program…
- CICS interview Questions Part – IX by: neerajmehta1984
August 9, 2009, 11:48
Q171)   Can you use OCCURS in a BMS map? If you do, what are the issues related with its use? A171)  Â…
- CICS interview Questions Part – VIII by: neerajmehta1984
August 9, 2009, 11:46
Q141)   How do you get data from a task that began with a START command? A141)    The RETRIEVE…
- CICS interview Questions Part – VII by: neerajmehta1984
August 9, 2009, 07:49
Q122)   What tables must be updated when adding a new transaction and program? A122)    At a bare…
- CICS interview Questions Part – VI by: neerajmehta1984
August 9, 2009, 07:47
Q71)  What does the following transactions do? A71)  CEDF : CICS-supplied Execution Diagnostic …
- CICS interview Questions Part – V by: neerajmehta1984
August 9, 2009, 07:43
Q51)  What is the difference between EXEC CICS HANDLE CONDTION and an EXEC CICS IGNORE command? A51)  A HANDLE CONDITION…
- CICS interview Questions Part – IV by: neerajmehta1984
August 9, 2009, 07:41
Q32)  Code a program meeting the following requirements. ‘EMPS’ is a transaction used to return information…
- CICS interview Questions Part – III by: neerajmehta1984
August 9, 2009, 07:39
Q21) What is the option specified in the read operation to gain multiple concurrent operations on the same dataset? A21) REQID(value).
- CICS interview Questions Part – II by: neerajmehta1984
August 9, 2009, 07:37
Q11) Mention the option (along with argument type) used in a CICS command to retrieve the response code after execution of the command. A11) RESP(…
- CICS interview Questions Part – I by: neerajmehta1984
August 9, 2009, 07:32
Q1) What are the six different types of argument values in COBOL that can be placed in various options of a CICS command? A1) ·Data Value…
- Customer Information Control System(CICS) - at a glance by: neerajmehta1984
August 9, 2009, 07:27
IBM’s Customer Information Control System (CICS) is an on-line teleprocessing system developed by IBM. By providing a sophisticated control…
- CICS interview Questions Part – XII by: neerajmehta1984
- IMS (1)
Section contains all interview question collection related to Information Management System(IMS)
- IMS interview questions by: neerajmehta1984
August 9, 2009, 12:35
Q1)    What is the physical nature of a database called? A1)    DBD Q2) …
- IMS interview questions by: neerajmehta1984
- JCL (135)
Section contains all collection of interview questions related to JOB CONTROL LANGUAGE(JCL)
- JCL interview questions - unsolved by: neerajmehta1984
August 9, 2009, 13:14
1. Distinguish between positional & keyword parameters 2. How can you omit positional parameters ? 3. How do u define the identifier field for a…
- What are three major types of JCL statements? What are their functions? by: neerajmehta1984
August 9, 2009, 13:12
JOB - indicates start of jobstream to the operating system and through parms coded on it, certain details about the job (time, region, message level, job…
- What does SYSIN * indicate? by: neerajmehta1984
August 9, 2009, 13:12
Instream data follows this card and is terminated when followed by a card containing // or /* in columns 1 and 2.
- What are the three basic types of statements in a jobstream? by: neerajmehta1984
August 9, 2009, 13:11
JOB(one per jobstream)EXEC(one or more per job)DD(one or more per jobstep)
- What is the difference between specifying DISP=OLD and DISP=SHR for a dataset? by: neerajmehta1984
August 9, 2009, 13:11
OLD specifies exclusive use of a dataset, SHR allows multiple jobs to concurrently access the dataset Note: When updating a dataset, you would normally use…
- What is a procedure? by: neerajmehta1984
August 9, 2009, 13:11
A set of precoded JCL that can be modified through the use of parameters or override cards. Note: Procedures can be catalogued or instream.
- What is the error code SOC01 indicate ? by: neerajmehta1984
August 9, 2009, 13:11
Operation exception error For e.g. a dataset open error
- How many parameters are there to a DISP statement and what are their uses ? by: neerajmehta1984
August 9, 2009, 13:11
There are three(3) parameters. Parameter 1: current data set disposition(new, shr, old, mod) Parameter 2: normal close action for data set (catlg, keep,…
- How to get cursor position from system in CICS environment ? by: neerajmehta1984
August 9, 2009, 13:10
Get it from EIBCURPOS !
- What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ? by: neerajmehta1984
August 9, 2009, 13:10
Minimum Size : 1 track Maximum size : 1 cylinder
- Can we browse or edit the GDG dataset if it is a tape entry? by: neerajmehta1984
August 9, 2009, 13:10
No, You can’t edit or browse the GDG if it resides on tape.
- What do you feel makes a good program? by: neerajmehta1984
August 9, 2009, 13:10
A program that follows a top down approach. It is also one that other programmers or users can follow logically and is easy to read and understand.
- What is the difference between catalogue procedure and In-Stream procedure? by: neerajmehta1984
August 9, 2009, 13:10
In Stream procedures are set of JCL statements written between JOB and EXEC statements, start with PROC and end with PEND statement. Mainly used to test…
- What is the difference between static call & Dynamic call ? by: neerajmehta1984
August 9, 2009, 13:09
In the case of Static call, the called program is a stand along program, it is an executable program . During run time we can call it in our called program. As…
- How to execute a set of JCL statements from a COBOL program ? by: neerajmehta1984
August 9, 2009, 13:09
Using EXEC CICS SPOOL WRITE(var-name) END-EXEC command. var-name is a COBOL host structure containing JCL statements.
- How do you submit JCL via a Cobol program? by: neerajmehta1984
August 9, 2009, 13:09
Use a file //dd1 DD sysout=(*,intrdr)write your JCL to this file. Pl some one try this out.
- What is the difference between IEBGENER, IEBCOPY and REPRO in IDCAMS utility? by: neerajmehta1984
August 9, 2009, 13:09
IEBGENER -- This is a dataset utility for copying sequential datasets which produces a PDS or a member from a sequential dataset. IEBCOPY -- This is a dataset…
- On the DD statement, what is the main difference between creating a new sequential flat file and a partitioned dataset? by: neerajmehta1984
August 9, 2009, 13:09
SPACE=(n,m) for a sequential file, SPACE=(n,m,p) for a PDS where n, m, and p are numbers. The p designates how many directory blocks to allocate.
- What 3 guidelines do we have to follow when concatenating DD statements? by: neerajmehta1984
August 9, 2009, 13:08
Datasets must be of the same type (disk or tape), All datasets must have the same logical record length, The dataset with the largest blocksize must be listed…
- What is a Dummy Utility and what it does ? by: neerajmehta1984
August 9, 2009, 13:08
IEFBR14 is a Dummy utility and it is used for the sake of EXEC PGM= .... statement in JCL. e.g. While Allocating a dataset you don't have to run any utility .…
- What is DATACOM db? by: neerajmehta1984
August 9, 2009, 13:08
It is a database used with VSE.
- What is the use of DSNDB07 ? by: neerajmehta1984
August 9, 2009, 13:08
This is the area where sorting takes place in DB2
- What is DSNDB06 ? by: neerajmehta1984
August 9, 2009, 13:08
This is the Place where DB2 Catalog resides
- How much is memory space involved, when we code BLOCKSIZE,TRK & CYL ? by: neerajmehta1984
August 9, 2009, 13:07
One block constitutes 32KB of formatted memory/ 42KB of Unformatted memory,6 blocks makes one Track & 15 Tracks makes one cylinder.
- The maximum number of steps in a job? by: neerajmehta1984
August 9, 2009, 13:07
255
- Min no of member’s (PDS) in one directory block? by: neerajmehta1984
August 9, 2009, 13:07
SIX(6)
- How much space OS allocates when you create a PS or PDS? by: neerajmehta1984
August 9, 2009, 13:07
56 KB
- Max. No of DD statements in a job ? by: neerajmehta1984
August 9, 2009, 13:07
3273
- For how long a job can be executed continuously in a mainframe ? by: neerajmehta1984
August 9, 2009, 13:07
248 DAYS
- what do you mean By spooling? Expand SPOOL? by: neerajmehta1984
August 9, 2009, 13:06
This is managed by JES. This is used for Queuing the Outputs that are intended for Printing and are first stored in SPOOLDASD. This can be managed Using
- What is GDG? by: neerajmehta1984
August 9, 2009, 13:06
GDG - group of dataset that are logically or chronologically related, referred by name and a relative generation number - an integer which identifies the…
- In which table PLAN is registered in ? by: neerajmehta1984
August 9, 2009, 13:06
RCT
- What does S0C4 error mean? by: neerajmehta1984
August 9, 2009, 13:06
This error is faced when we execute the COBOL program. The main reason for this error is that a variable is defined with less characters and we are trying to…
- What is the purpose of include statement in a JCL? by: neerajmehta1984
August 9, 2009, 13:06
It is used as an alternative for STEPLIB. When we specify the dataset name in include ,it will search in all the datasets specified in the include dataset.
- What is QSAM error usually when it is occurs? by: neerajmehta1984
August 9, 2009, 13:06
Usually it is occurs at the time of job submission.
- Which is the most widely used batch performance monitor for DB2? by: neerajmehta1984
August 9, 2009, 13:05
DB2PM
- What does the statements: typrun=scan and typrun=hold do in a JCL statement by: neerajmehta1984
August 9, 2009, 13:05
typrun=scan checks the JCL for errors, typrun=hold holds the job until further notice.
- What are the basic JCL Statements for a Job? by: neerajmehta1984
August 9, 2009, 13:05
JOB : Identifies a job and supplies accounting info EXEC : Identifies a job step by indicating the name of the program to be executed. DD :…
- What is the max blocksize for a Tape file? by: neerajmehta1984
August 9, 2009, 13:05
It is 32,760.Based on that we can calculate efficient number of Records in a Block
- What is JCL ? by: neerajmehta1984
August 9, 2009, 13:05
JCL is Job Control Language and is used for Batch processing. The startup procedures of OS and standard products like CICS etc are written in JCL. It is…
- How do you submit a JCL under CICS environment ? by: neerajmehta1984
August 9, 2009, 13:04
Edit the JCL in Extra partition TDQ and submit the same using some system command (not sure) under CICS subsystem. This is what i think, please clarify....
- What you mean by skeleton JCl? by: neerajmehta1984
August 9, 2009, 13:04
Jcl which changes during run time i.e. the values for the jcl such as pgm name , dd name will change .ie same jcl can be used for various job, equivalent to…
- The maximum number of in-stream procedure you can code in any JCL is ? by: neerajmehta1984
August 9, 2009, 13:04
Fifteen
- What u mean by include statement in JCL ? by: neerajmehta1984
August 9, 2009, 13:04
An include statement identifies a member of a pds or pdse that contains. This set of JCL statements is called an include group. The system replaces the include…
- How many types of libraries are there in JCL ? by: neerajmehta1984
August 9, 2009, 13:04
Libraries are of three types.1.Sytem Libraries: SUCH AS SYS1.LINKLIB2.Private Libraries: SPECIFIED IN A JOBLIB OR STEPLIB DD STATEMENTS.3.Temporary Libraries:…
- Write a jcl to execute a job by 7 a.m on Jan 20,1986 ? by: neerajmehta1984
August 9, 2009, 13:04
THE code IS : //*MAIN DEADLINE=(0700,B,012086)
- What is a COND parameter in JCL? by: neerajmehta1984
August 9, 2009, 13:03
COND means condition parameter. It is compared with system return code of previous step.//step1 exec pgm=abcd//step2 exec pgm=xyz, cond=(4,lt)step2 will be…
- How to pass the temp dataset form one JOB step to another? by: neerajmehta1984
August 9, 2009, 13:03
By specifying the DISP as PASS for the temp dataset
- What is meant by S0C7 system abend code? by: neerajmehta1984
August 9, 2009, 13:03
S0C7 - Data exception error - you will get it whenever you are trying to move the low values or spaces into the numeric field, or compare the numeric fields…
- Definition of COND parameter in JCL by: neerajmehta1984
August 9, 2009, 13:03
COND is a condition parameter, consists of 2 sub parameters, 1st - return code from the previous step, 2nd - condition. If COND is true, the step on which…
- What is the parameter to be passed in the job card for the unlimited time , irrespective of the job class ? by: neerajmehta1984
August 9, 2009, 13:03
TIME=1440
- How do you submit a JCL under CICS environment ? by: neerajmehta1984
August 9, 2009, 13:03
Pass all the jcl codes to a COBOL variable(should be declare using OCCURS clause) and the write the line one by one to the spool using CICS commands like…
- How do you submit JCL via a Cobol program? by: neerajmehta1984
August 9, 2009, 13:02
In your JCL define as //JOBA JOB 1111, JOB1 //STEP01 EXEC PGM=PROG1 //ddname DD SYSOUT=(*,INTRDR)....and your COBOL(PROG1) should look like this SELECT…
- Why do you use a control card? by: neerajmehta1984
August 9, 2009, 13:02
A control card can be a member of a pds or a sequential dataset and is used for storing the date fields, Definitions of VSAM files....etc. You use control card…
- How do you pass parameters to the program as the job is being executed ? by: neerajmehta1984
August 9, 2009, 13:02
By using 'parm' parameter in exec statement. the value mentioned here should be declared in linkage section in the program and process thru procedure division.…
- How do you restart a step in JCL? by: neerajmehta1984
August 9, 2009, 13:02
Use RESTART=step name.
- How can you trap abends in the JCL? by: neerajmehta1984
August 9, 2009, 13:02
Use IF ABEND statement in the JCL.
- What are three parameters you can specify on Job statement as well as on exec stmt ? by: neerajmehta1984
August 9, 2009, 13:01
Time, Region and Cond parameters
- How many positional parameters are there in job statement? by: neerajmehta1984
August 9, 2009, 13:01
There are two position parameters in job statement.
- What will happen if you attempt to restart a job in the middle of a JCL // IF .... // ENDIF? by: neerajmehta1984
August 9, 2009, 13:01
Job will fall through to the ENDIF (not executing any steps), then resume execution with the first step AFTER the // ENDIF.
- Can you execute a PROC from another PROC? by: neerajmehta1984
August 9, 2009, 13:01
I did not know the answer and my interviewer said NO. Later I tried and executed PROC from a PROC, three levels deep. Manuals do not state any limit on PROC…
- What is the difference between BLKSIZE and LRECL? by: neerajmehta1984
August 9, 2009, 13:01
LRECL is the logical record length , where as BLKSIZE is multiples of LRECL
- What does the keyword DCB mean and what are some of the keywords associated with it? by: neerajmehta1984
August 9, 2009, 13:00
DCB stands for data control block; it is a keyword for the DD statement used to describe datasets. Keywords associated with it are BLKSIZE, DEN, LRECL and…
- How is the keyword DUMMY used in JCL? by: neerajmehta1984
August 9, 2009, 13:00
For an output file DUMMY specifies that the output is to be discarded. For input it specifies that the file is empty.
- What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement? by: neerajmehta1984
August 9, 2009, 13:00
Data definition name is the eight character designation after the // of the DD statement. It matches the internal name specified in the steps executing…
- What is the purpose and meaning of the TIME keyword and what JCL statement is it associated with? by: neerajmehta1984
August 9, 2009, 13:00
TIME specifies the maximum CPU time allocated for a particular job or job step. If TIME is in the JOB card, it relates to the entire job; if in the EXEC…
- What is the purpose and meaning of the REGION keyword and what JCL statement is it associated with? by: neerajmehta1984
August 9, 2009, 13:00
REGION specifies the maximum CPU memory allocated for a particular job or job step. If REGION is in the JOB card, it relates to the entire job; if in the…
- What is the purpose of the PARM keyword in the EXEC statement? by: neerajmehta1984
August 9, 2009, 12:59
The value after the PARM= specifies control information to be passed to the executing program of the job step.
- What is the improvement to COND= in the latest version of MVS? by: neerajmehta1984
August 9, 2009, 12:59
MVS now allows for an IF bracketed by an END IF around any job step to replace the COND= syntax. Again, if the IF statement is true, the step is bypassed.
- What is the meaning of the EXEC statement keyword, COND? What is its syntax? by: neerajmehta1984
August 9, 2009, 12:59
COND specifies the conditions for executing the subsequent job step. The value after the COND= is compared to the return codes of the preceding steps and if…
- How do you designate a comment in JCL? by: neerajmehta1984
August 9, 2009, 12:59
The comment statement is //* followed by the comments.
- What are the keywords associated with DCB? How can you specify DCB information? What is the OS precedence for obtaining that DCB information, ie. where does the system look for it first? by: neerajmehta1984
August 9, 2009, 12:59
The keywords associated with the DCB parameter are LRECL, RECFM, BLKSIZE and DSORG. The DCB information can be supplied in the DD statement. The system looks…
- What is MOD and when would you use it? by: neerajmehta1984
August 9, 2009, 12:59
DISP=MOD is used when the dataset can be extended, ie, you can add records at the end of an existing dataset.
- What is the difference between specifying DISP=OLD and DISP=SHR for a dataset? by: neerajmehta1984
August 9, 2009, 12:58
DISP=OLD denotes exclusive control of the dataset; DISP=SHR means there is no exclusivity.
- Explain concatenating datasets? by: neerajmehta1984
August 9, 2009, 12:58
Datasets can be grouped in a DD statement one after another, eg. in a JOBLIB statement where the load module can exist in one of many datasets.
- What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB? by: neerajmehta1984
August 9, 2009, 12:58
GDG stands for generation data group. It is a dataset with versions that can be referenced absolutely or relatively. It is defined by an IDCAMS define…
- What is RESTART? How is it invoked? by: neerajmehta1984
August 9, 2009, 12:58
RESTART is a JOB statement keyword. It is used to restart the job at a specified step rather than at the beginning.
- What is the difference between a symbolic and an override in executing a PROC? by: neerajmehta1984
August 9, 2009, 12:58
A symbolic is a PROC placeholder; the value for the symbolic is supplied when the PROC is invoked, eg. &symbol=value. An override replaces the PROC's…
- What is a PROC? What is the difference between an instream and a catalogued PROC? by: neerajmehta1984
August 9, 2009, 12:57
PROC stands for procedure. It is 'canned' JCL invoked by a PROC statement. An instream PROC is presented within the JCL; a catalogued PROC is referenced from…
- Describe the DD statement, its meaning, syntax and keywords? by: neerajmehta1984
August 9, 2009, 12:57
The DD statement links the external dataset name (DSN) to the DDNAME coded within the executing program. It links the file names within the program code to…
- Describe the EXEC statement, its meaning, syntax and keywords? by: neerajmehta1984
August 9, 2009, 12:57
The EXEC statement identifies the program to be executed via a PGM= program name keyword. Its format is //jobname EXEC PGM= program name. The PARM= keyword…
- Describe the JOB statement, its meaning, syntax and significant keywords? by: neerajmehta1984
August 9, 2009, 12:57
The JOB statement is the first in a JCL stream. Its format is // jobname, keyword JOB, accounting information in brackets and keywords, MSGCLASS, MSGLEVEL,…
- What is the meaning of keyword in JCL? What is its opposite? by: neerajmehta1984
August 9, 2009, 12:56
A keyword in a JCL statement may appear in different places and is recognized by its name, eg. MSGCLASS in the JOB statement. The opposite is positional…
- What are the kinds of job control statements? by: neerajmehta1984
August 9, 2009, 12:56
The JOB, EXEC and DD statement.
- What are the causes for S0C1, S0C4, S0C5, S0C7, S0CB abends ? by: neerajmehta1984
August 9, 2009, 12:56
S0C1-May be due to 1.Missing or misspelled DD name 2.Read/Write to unopened dataset 3.Read to dataset opened output 4.Write to dataset opened input 5.Called…
- What are the differences between JES2 & JES3 ? by: neerajmehta1984
August 9, 2009, 12:56
JES3 allocates datasets for all the steps before the job is scheduled. In JES2, allocation of datasets required by a step are done only just before the step…
- What are the valid DSORG values ? by: neerajmehta1984
August 9, 2009, 12:56
PS - QSAM, PO - Partitioned, IS - ISAM
- The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ? by: neerajmehta1984
August 9, 2009, 12:55
Records will be written to end of file (append) when a WRITE is done in both cases.
- How to change default PROCLIB? by: neerajmehta1984
August 9, 2009, 12:55
//ABCD JCLLIB ORDER=(ME.MYPROCLIB,SYS1.PROCLIB)
- When you specify mutiple datasets in a JOBLIB or STEPLIB, what factor determines the order? - GS by: neerajmehta1984
August 9, 2009, 12:55
The library with the largest block size should be the first one.
- What happens if both JOBLIB and STEPLIB is specified ? by: neerajmehta1984
August 9, 2009, 12:55
JOBLIB is ignored.
- What is order of searching of the libraries in a JCL? - GS by: neerajmehta1984
August 9, 2009, 12:55
First any private libraries as specified in the STEPLIB or JOBLIB, then the system libraries such as SYS1.LINKLIB. The system libraries are specified in the…
- What is STEPLIB, JOBLIB? What is it used for? by: neerajmehta1984
August 9, 2009, 12:55
Specifies that the private library (or libraries) specified should be searched before the default system libraries in order to locate a program to be executed.…
- How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program? by: neerajmehta1984
August 9, 2009, 12:54
To run a non DB2 program, //STEP001 EXEC PGM=MYPROG To run a DB2 program, //STEP001 EXEC PGM=IKJEFT01 //SYSTSIN DD * DSN SYSTEM(....) RUN PROGRAM(MYPROG) PLAN(…
- How do you overcome this limitation ? by: neerajmehta1984
August 9, 2009, 12:54
One way is to code SYSIN DD DUMMY in the PROC, and then override this from the JCL with instream data.
- Can you code instream data in a PROC ? by: neerajmehta1984
August 9, 2009, 12:54
No
- I have a COBOL program that Accepts some input data. How do you code the JCL statement for this? ( How do you code instream data in a JCL? ) by: neerajmehta1984
August 9, 2009, 12:54
//SYSIN DD* input data input data /*
- I have multiple jobs ( JCLs with several JOB cards ) in a member. What happens if I submit it? by: neerajmehta1984
August 9, 2009, 12:54
Multiple jobs are submitted (as many jobs as the number of JOB cards).
- How do you send the output of a COBOL program to a member of a PDS? by: neerajmehta1984
August 9, 2009, 12:53
Code the DSN as PDS (member) with a DISP = SHR. The DISP applies to the PDS and not to a specific member.
- What does IEBGENER do? by: neerajmehta1984
August 9, 2009, 12:53
Used to copy one QSAM file to another. Source dataset should be described using SYSUT1 ddname. Destination dataset should be described using SYSUT2. IEBGENR…
- How do you check the syntax of a JCL without running it? by: neerajmehta1984
August 9, 2009, 12:53
TYPERUN=SCAN on the JOB card or use JSCAN.
- What is COND=ONLY ? by: neerajmehta1984
August 9, 2009, 12:53
Means execute this step only if any of the previous steps, terminated abnormally.
- What is COND=EVEN ? by: neerajmehta1984
August 9, 2009, 12:52
Means execute this step even if any of the previous steps, terminated abnormally.
- What does the TIME parameter signify ? What does TIME=1440 mean ? by: neerajmehta1984
August 9, 2009, 12:52
TIME parameter can be used to overcome S322 abends for programs that genuinely need more CPU time. TIME=1440 means no CPU time limit is to be applied to this…
- Why do you want to specify the REGION parameter in a JCL step? by: neerajmehta1984
August 9, 2009, 12:52
To override the REGION defined at the JOB card level. REGION specifies the max region size. REGION=0K or 0M or omitting REGION means no limit will be applied.
- What is S322 abend ? by: neerajmehta1984
August 9, 2009, 12:52
Indicates a time out abend. Your program has taken more CPU time than the default limit for the job class. Could indicate an infinite loop.
- What are SD37, SB37, SE37 abends? by: neerajmehta1984
August 9, 2009, 12:51
All indicate dataset out of space. SD37 - no secondary allocation was specified. SB37 - end of vol. and no further volumes specified. SE37 - Max. of 16…
- What is a S0C4 error ? by: neerajmehta1984
August 9, 2009, 12:51
Storage violation error - can be due to various reasons. e.g.: READING a file that is not open, invalid address referenced due to subscript error.
- What is 'S0C7' abend? - GS by: neerajmehta1984
August 9, 2009, 12:51
Caused by invalid data in a numeric field.
- What is NOTCAT 2 - GS by: neerajmehta1984
August 9, 2009, 12:51
This is an MVS message indicating that a duplicate catalog entry exists. E.g., if you already have a dataset with dsn = 'xxxx.yyyy' and u try to create one…
- How do you override a specific DDNAME/SYSIN in PROC from a JCL? by: neerajmehta1984
August 9, 2009, 12:51
// DSN=...
- A PROC has five steps. Step 3 has a condition code. How can you override/nullify this condition code? - GS by: neerajmehta1984
August 9, 2009, 12:50
Provide the override on the EXEC stmt in the JCL as follows: //STEP001 EXEC procname, COND.stepname=value All parameters on an EXEC stmt in the proc such as…
- How do you skip a particular step in a proc/JOB? - GS by: neerajmehta1984
August 9, 2009, 12:50
Can use either condition codes or use the jcl control statement IF (only in ESA JCL)\
- How do you restart a PROC from a particular step? - GS by: neerajmehta1984
August 9, 2009, 12:50
In job card, specify RESTART=PROCSTEP.STEPNAME where PROCSTEP = name of the JCL step that invoked the PROC and STEPNAME = name of the PROC step where you want…
- How do you create a temporary dataset? Where will you use them? by: neerajmehta1984
August 9, 2009, 12:50
Temporary datasets can be created either by not specifying any DSNAME or by specifying the temporary file indicator as in DSN=&&TEMP. We use them to…
- What is DISP= (NEW,PASS,DELETE)? by: neerajmehta1984
August 9, 2009, 12:50
This is a new file and create it, if the step terminates normally, pass it to the subsequent steps and if step abends, delete it. This dataset will not exist…
- What do you do if you do not want to keep all the space allocated to a dataset? - GS by: neerajmehta1984
August 9, 2009, 12:50
Specify the parameter RLSE ( release ) in the SPACE e.g. SPACE=(CYL,(50,50),RLSE)
- What is the DD statement for a output file? by: neerajmehta1984
August 9, 2009, 12:49
Unless allocated earlier, will have the following parameters: DISP=(NEW,CATLG,DELETE), UNIT , SPACE & DCB
- MOD, DELETE; What does a disposition of (,DELETE) mean ? by: neerajmehta1984
August 9, 2009, 12:49
The MOD will cause the dataset to be created (if it does not exist), and then the two DELETEs will cause the dataset to be deleted whether the step abends or…
- How do you access a file that had a disposition of KEEP? - GS by: neerajmehta1984
August 9, 2009, 12:49
Need to supply Volume Serial Number VOL=SER=xxxx.
- What does a disposition of (NEW,CATLG,KEEP) mean? - GS by: neerajmehta1984
August 9, 2009, 12:49
That this is a new dataset and needs to be allocated, to CATLG the dataset if the step is successful and to KEEP but not CATLG the dataset if the step abends.…
- What does a disposition of (NEW,CATLG,DELETE) mean? - GS by: neerajmehta1984
August 9, 2009, 12:48
That this is a new dataset and needs to be allocated, to CATLG the dataset if the step is successful and to delete the dataset if the step abends.
- How many extents are possible for a sequential file ? For a VSAM file ? by: neerajmehta1984
August 9, 2009, 12:48
16 extents on a volume for a sequential file and 123 for a VSAM file.
- What is the difference between primary and secondary allocations for a dataset? by: neerajmehta1984
August 9, 2009, 12:48
Secondary allocation is done when more space is required than what has already been allocated.
- What is primary allocation for a dataset? by: neerajmehta1984
August 9, 2009, 12:48
The space allocated when the dataset is first created.
- Name some of the JCL statements that are not allowed in procs.? by: neerajmehta1984
August 9, 2009, 12:48
Some of the JCL statements which are not allowed in procedures are: 1. JOB, Delimiter(/*), or Null statements 2. JOBLIB or JOBCAT DD statements 3. DD * or…
- What is the difference between the JOBLIB and the STEPLIB statements? by: neerajmehta1984
August 9, 2009, 12:48
The JOBLIB statement is placed after the JOB statement and is effective for all job steps. It cannot be placed in a cataloged procedure. The STEPLIB statement…
- How are datasets concatenated? by: neerajmehta1984
August 9, 2009, 12:47
Datasets are concatenated by writing a normal DD statement for the first dataset and then adding a DD statement without a DDNAME for each dataset to be…
- How is a dataset passed from one step to another? by: neerajmehta1984
August 9, 2009, 12:47
A dataset is passed from one step to another based on what is coded on the DISP parameter. The dataset can only be passed to subsequent steps if PASS was used…
- When should DISP=MOD is used? by: neerajmehta1984
August 9, 2009, 12:47
DISP=MOD is used to either extend an existing sequential dataset or to create a dataset if it does not exist. If the dataset exists, then records are appended…
- How is a new GDG coded? by: neerajmehta1984
August 9, 2009, 12:47
A new GDG is coded as (+1) after the dataset name as follows: DSN=JAN.DATA(+1). This will cause all generations to be pushed down one level at the end of the…
- How are GDGs concatenated? by: neerajmehta1984
August 9, 2009, 12:47
Generation Data Groups are concatenated by specifying each dataset name and the generation number for all generations of the generation data group. Otherwise…
- What is model dataset label(Model DSCB)? by: neerajmehta1984
August 9, 2009, 12:46
A model dataset label is a pattern for the dataset label created for any dataset named as a part of the GDG group. The system needs an existing dataset to…
- How is a GDG base created? by: neerajmehta1984
August 9, 2009, 12:46
A GDG base is created in the system catalog and keeps track of the generation numbers used for datasets in the group. IDCAMS utility is used to define the GDG…
- What is a Generation Data Group (GDG)? by: neerajmehta1984
August 9, 2009, 12:46
Generation Data Group is a group of chronologically or functionally related datasets. GDGs are processed periodically, often by adding a new generation,…
- JCL interview questions - unsolved by: neerajmehta1984
- VSAM (81)
Section contains all collection of interview questions related to Virtual Storage Access Method (VSAM)
- What's the implicit name of the parameter that gets passed into the class'set method? by: meghna
September 2, 2009, 17:46
value, and its datatype depends on whatever variable we're changing.
- If FSPC(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both CI and ca are specified to be empty? by: neerajmehta1984
August 9, 2009, 13:42
No, they would not be left empty. one record will be written in each CI and 1 CI will be written for each ca.
- what is a Base Cluster? by: neerajmehta1984
August 9, 2009, 13:42
The Index and data components of a KSDS
- what is the RRN for the first record in RRDS? by: neerajmehta1984
August 9, 2009, 13:42
The answer is : 1
- How many times secondary space allocated? by: neerajmehta1984
August 9, 2009, 13:41
122 TIMES
- what's the device independent method to indicate where a Record is Stored? by: neerajmehta1984
August 9, 2009, 13:41
By USING RBA(Relative Byte Address).
- what's the biggest disadvantage of using a VSAM dataset? by: neerajmehta1984
August 9, 2009, 13:41
FREE SPACE(FPSC)
- How many buffers are allotted to VSAM KSDS and ESDS? by: neerajmehta1984
August 9, 2009, 13:41
2 data buffers by default for ESDS. For KSDS it allots 2 data buffers and 1 index buffers. each buffer is about 4k.
- What is an alternate index and path ? by: neerajmehta1984
August 9, 2009, 13:41
An alternate index is an another way of accessing key sequenced data record stored in a base cluster and path is the linkage which connect alternate index to…
- Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ? by: neerajmehta1984
August 9, 2009, 13:40
No delete operation is not possible in VSAM ESDS.B. Yes rewrite operation is possible in an ESDS.
- What is the Difference between LDS & ESDS ? by: neerajmehta1984
August 9, 2009, 13:40
These two datasets are VSAM datasets. ESDS maintains control information. But LDS does not maintains the control information.
- How to delete a member using JCL. by: neerajmehta1984
August 9, 2009, 13:40
Using IDCAMS a member can be deleted. DELETE 'XXX.YYY(member)
- What is IDCAMS? and what is the purpose of it?. by: neerajmehta1984
August 9, 2009, 13:40
IDCAMS is an access method services utility used for creating, deleting, altering VSAM files and copying sequential file to a VSAM file, etc.
- What are the optional parameters to the input dataset While loading the empty cluster with the data records? by: neerajmehta1984
August 9, 2009, 13:40
1)FROMADDRESS(address) 2)TOADDRESS(address) where 'address' specifies the RBA value of the key of the input record. 3)FROMNUMBER(rrn) 4)TONUMBER(rrn) where…
- What does the KEYRANGES parameter in Define Cluster commend do? by: neerajmehta1984
August 9, 2009, 13:39
It divides a large dataset into several volumes according to the Key ranges specified. e.g., KEYRANGES ((0000001 2999999) (3000000 5999999)). if the activity…
- Describe SHAREOPTIONS parameter (SHR) in Define Cluster command. by: neerajmehta1984
August 9, 2009, 13:39
It defines the cross-region and cross-system sharing capabilities of the dataset. Syntax is SHR(Crvalue, CSvalue) value 1 means multiple read OR single write…
- What is RECOVERY and SPEED parameters in DEFINE CLUSTER command? by: neerajmehta1984
August 9, 2009, 13:39
RECOVERY (default) and SPEED are mutually exclusive. Recovery preformats the control areas during the initial dataset load, if the job fails, you can restart…
- Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? by: neerajmehta1984
August 9, 2009, 13:39
Yes. Why? Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
- How many Alternate Indexes you can have on a dataset? by: neerajmehta1984
August 9, 2009, 13:39
255 - but you must be a nut to have so many ALT Indexes on a dataset!
- On which datasets You can have ALT INDEX?. by: neerajmehta1984
August 9, 2009, 13:38
only on KSDS and ESDS - not RRDS
- What is the meaning of VSAM RETURN-CODE 28? by: neerajmehta1984
August 9, 2009, 13:38
Out of space condition is raised.
- How do you fix the problem associated with VSAM out of space condition? by: neerajmehta1984
August 9, 2009, 13:38
Define new VSAM dataset allocated with more space. Use IDCAMS to REPRO the old VSAM file to new VSAM dataset. Use IDCAMS to ALTER / rename the old VSAM…
- During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ? by: neerajmehta1984
August 9, 2009, 13:38
Run VERIFY.
- Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation? by: neerajmehta1984
August 9, 2009, 13:37
Use the LISTCAT command.
- What more info you should give in the DD statement while defining the next generation of a GDG? - GS by: neerajmehta1984
August 9, 2009, 13:37
Give (+1) as the generation number, give (new,catlg) for disp, give space parameter, can give the DCB parameter if you want to override the dcb of the model…
- Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now? - GS by: neerajmehta1984
August 9, 2009, 13:37
Relative generation numbers are updated only at the end of the job, not at the end of a step. To allocate a new generation, we would be using (+1) with a DISP…
- Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL? - GS by: neerajmehta1984
August 9, 2009, 13:37
Use GDG name(-2).
- How are different versions of GDG named ? by: neerajmehta1984
August 9, 2009, 13:37
base-file-name.GnnnnnV00 where nnnn= generation number (upto 255). nnnn will be 0000 for the 1st generation.
- Do all versions of the GDG have to be of the same record length ? by: neerajmehta1984
August 9, 2009, 13:36
No, the DCB of the model dataset can be overridden when you allocate new versions.
- How do you define a GDG ? by: neerajmehta1984
August 9, 2009, 13:36
Use the DEFINE GENERATIONDATAGROUP command. In the same IDCAMS step, another dataset must be defined whose DCB parameters are used when new generations of the…
- How do you load a VSAM data set with records ? by: neerajmehta1984
August 9, 2009, 13:36
Using the REPRO command.
- What is the difference between sequential files and ESDS files? by: neerajmehta1984
August 9, 2009, 13:36
Sequential (QSAM) files can be created on tape while ESDS files cannot. Also, you can have ALTINDEX for an ESDS while no such facility exists for QSAM files.
- How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique. by: neerajmehta1984
August 9, 2009, 13:35
Unique Case: 5 + ( alt-key-length + primary-key ) Non unique Case: 5 + ( alt-key-length + n * primary-key ) where n = number of duplicate records for the…
- What does a file status of 02 on a VSAM indicate? by: neerajmehta1984
August 9, 2009, 13:35
Duplicate alternate key . Happens on both input and output operation
- How do you initialize a VSAM file before any operation? a VSAM with alternate index? by: neerajmehta1984
August 9, 2009, 13:35
Can write a dummy program that just opens the file for output and then closes it.
- What happens when you open an empty VSAM file in a COBOL program for input? by: neerajmehta1984
August 9, 2009, 13:35
A VSAM file that has never contained a record is treated as unavailable. Attempting to open for input will fail. An empty file can be opened for output only.…
- Using Alternate Indexes in CICS pgms: by: neerajmehta1984
August 9, 2009, 13:35
FCT entries must be created for both base cluster & the path. To read using the alternate index, use the dd name of the path in CICS file control commands.
- Using Alternate Indexes in Batch pgms: by: neerajmehta1984
August 9, 2009, 13:34
In the JCL, you must have DD stmts for the cluster and for the path(s). In the COBOL Program, SELECT .. ASSIGN TO ddname for base cluster RECORD KEY IS...…
- How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgm’s ? by: neerajmehta1984
August 9, 2009, 13:34
DEFINE ALTERNATEINDEX. Important paramters are RELATE where you specify the base cluster name, KEYS, RECORDSIZE,SHAREOPTIONS,UNIQUEKEY(or NONUNIQUEKEY),…
- How do you define a KSDS ? by: neerajmehta1984
August 9, 2009, 13:34
DEFINE CLUSTER(cluster name) with the INDEXED parameter. Also specify the ds name for the DATA component & the ds INDEX component. Other important parms…
- What is the meaning of each of the values in SHAREOPTS(2 3)? by: neerajmehta1984
August 9, 2009, 13:34
Value of 2 for cross region means that the file can be processed simultaneously by multiple users provided only one of them is an updater. Value of 3 for cross…
- What is SHAREOPTS ? by: neerajmehta1984
August 9, 2009, 13:34
SHAREOPTS is a parameter in the DEFINE and specifies how an object can be shared among users. It is coded as SHAREOPTS(a b), where a is the cross region share…
- Would you specify FREESPACE for an ESDS? by: neerajmehta1984
August 9, 2009, 13:33
No. Because you cannot insert records in an ESDS, also when you rewrite a record, it must be of the same length. Thus putting any value for freespace does not…
- How do you decide on optimum values for CI, FREESPACE etc...? by: neerajmehta1984
August 9, 2009, 13:33
CI size should be based on record length, type of processing. Usually CI is 4K. If record length is larger(>1K), chose 6K or 8K. FREESPACE should be large…
- What is FREESPACE ? by: neerajmehta1984
August 9, 2009, 13:33
Coded in the DEFINE as FREESPACE(ci ca) where ci is the percentage of each control interval to be left free for insertions, ca is the percentage of control…
- What is Control Interval, Control Area? by: neerajmehta1984
August 9, 2009, 13:33
Control Interval is analogous to a physical block for QSAM files. It is the unit of I/O. Must be between 512 bytes to 32 k. Usually either 2K or 4K. A larger…
- Under IDCAMS , multiple functions can be executed, each of which returns a cond code. What will be the condition code returned to the operating system ? by: neerajmehta1984
August 9, 2009, 13:33
The maximum condition code generated is returned as the condition code of the IDCAMS step.
- Syntax of AMS modal commands ? by: neerajmehta1984
August 9, 2009, 13:32
Note: these can be used only under IDCAMS and not from the TSO prompt. IF LASTCC(or MAXCC) >(or <,= etc..) value - THEN - DO - command set (such…
- Can AMS commands be run from the TSO prompt ? by: neerajmehta1984
August 9, 2009, 13:32
Yes
- What is IDCAMS ? by: neerajmehta1984
August 9, 2009, 13:32
IDCAMS is the Access Method Services program. You run the IDCAMS program and supply AMS commands thru SYSIN. (examples of AMS commands are DELETE, DEFINE,…
- What's a LDS (Linear Data Set) and what's it used for? by: neerajmehta1984
August 9, 2009, 13:32
LDS is a VSAM dataset in name only. It has unstructured 4k (4096 bytes) fixed size CI’s which do not contain control fields and therefore from…
- What is File Status in VSAM? by: neerajmehta1984
August 9, 2009, 13:32
The FILE STATUS clause of the FILE-CONTROL paragraph allows for each file to be associated with a file status key (i.e., the 2-character data item…
- What is the meaning of the DEFINE MODEL parameter? by: neerajmehta1984
August 9, 2009, 13:31
It specifies whether Daniela Pestova or Yamila - oops! Wrong models! The MODEL parameter allows you to model your cluster by modeling it after an existing…
- What is the significance of the SHAREOPTIONS parameter? by: neerajmehta1984
August 9, 2009, 13:31
It specifies how the file may be shared between jobs and between batch and CICS environments.
- What are the three levels of definition for the VSAM DEFINE? by: neerajmehta1984
August 9, 2009, 13:31
They are DEFINE CLUSTER, DATA and INDEX.
- There are at least seven IDCAMS commands; name and explain each of them ?. by: neerajmehta1984
August 9, 2009, 13:31
ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. DEFINE is used for ALTERNATEINDEX,…
- What is the utility program closely associated with VSAM? by: neerajmehta1984
August 9, 2009, 13:31
IDCAMS, the access method services utility.
- What is a VSAM slot? by: neerajmehta1984
August 9, 2009, 13:31
A relative record dataset (RRDS) consists of a specified number of areas called slots. Each slot is identified by a relative record number (RRN) which…
- Name some common VSAM error conditions and codes. by: neerajmehta1984
August 9, 2009, 13:29
They are end of file (10), duplicate key (22), record not found (23), VSAM logic error (90), open problem (92) and space problem (93).
- What is the meaning of dynamic processing? by: neerajmehta1984
August 9, 2009, 13:24
It's rarely used. It means one program uses both sequential and random processing for a VSAM KSDS file.
- Explain the meaning and syntax for the START command. by: neerajmehta1984
August 9, 2009, 13:23
The START command is used read other than the next VSAM record. A value must be moved into the RECORD KEY. The KEY clause is optional, but it can be used to…
- If you wish to use the REWRITE command haw must the VSAM file be opened? by: neerajmehta1984
August 9, 2009, 13:23
It must be opened as I/O.
- What is the purpose of the FILE STATUS clause in the SELECT statement? by: neerajmehta1984
August 9, 2009, 13:23
The FILE STATUS field identifies the field that VSAM uses to provide information about each I/O operation for the file.
- In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS? by: neerajmehta1984
August 9, 2009, 13:23
ACCESS can be SEQUENTIAL, RANDOM or DYNAMIC.
- In the COBOL SELECT statement what is the ORGANIZATION for a KSDS? by: neerajmehta1984
August 9, 2009, 13:23
The ORGANIZATION is INDEXED.
- Do primary key values have to be unique? Do alternate key values have to be unique? by: neerajmehta1984
August 9, 2009, 13:22
Primary key values must be unique; alternate key values need not be.
- What is the base cluster? by: neerajmehta1984
August 9, 2009, 13:22
The base cluster consists of the data component and the index component for the primary index of a KSDS.
- What is a VSAM split? by: neerajmehta1984
August 9, 2009, 13:22
If there isn't enough space in the control interval VSAM performs a control interval split by moving some records to the free control intervals. If there…
- What is free space? by: neerajmehta1984
August 9, 2009, 13:22
Free space is reserved within the data component of a KSDS to accommodate inserting new records.
- What is the upgrade set? by: neerajmehta1984
August 9, 2009, 13:21
The upgrade set is the list of all AIXes that VSAM must maintain for a specific base cluster, so that when data in the base cluster is updated, the AIX files…
- What is a path? by: neerajmehta1984
August 9, 2009, 13:21
A path is a file that allows you to access a file by alternate index - the path provides an association between the AIX and the base cluster.
- What is an alternate index? by: neerajmehta1984
August 9, 2009, 13:21
An AIX is a file that allows access to a VSAM dataset by a key other than the primary one.
- What is the catalog? by: neerajmehta1984
August 9, 2009, 13:21
The catalog contains the names of all datasets, VSAM and non-VSAM. It is used to access these datasets.
- What is a cluster? by: neerajmehta1984
August 9, 2009, 13:21
A cluster is the combination of the index, sequence set and data portions of the dataset. The operating system gives program access to the cluster, ie. to all…
- What is the index set? by: neerajmehta1984
August 9, 2009, 13:21
This is the other part of the index. It has multiple levels with pointers that ultimately reach to the sequence set.
- What is a sequence set? by: neerajmehta1984
August 9, 2009, 13:20
This is the part of the index that points to the CA and CI of the record being accessed.
- What is a CA, control area? by: neerajmehta1984
August 9, 2009, 13:20
A group of control intervals makes up a control area.
- What are the distinctive features of a ksds, key sequenced dataset? by: neerajmehta1984
August 9, 2009, 13:20
The index and the distributed free space.
- They are stored without respect to the contents of the records and in the order in which they are included in the file. by: neerajmehta1984
August 9, 2009, 13:20
A control interval is the unit of information that VSAM transfers between virtual and auxiliary storage.
- How are records stored in an ESDS, entry sequenced dataset? by: neerajmehta1984
August 9, 2009, 13:20
They are stored without respect to the contents of the records and in the order in which they are included in the file.
- What are the types of VSAM datasets? by: neerajmehta1984
August 9, 2009, 13:19
Entry sequenced datasets (ESDS), key sequenced datasets (KSDS) and relative record dataset (RRDS).
- What's the implicit name of the parameter that gets passed into the class'set method? by: meghna
- IBM Interview Questions – Section-3 by: neerajmehta1984
- HTML (1)
- How to add flash movie in my project? by: smartbrain
October 12, 2009, 13:19
Use object classid
- How to add flash movie in my project? by: smartbrain
- Crystal Report (1)
- Difference between Clone, Close and Dispose methods of Crystal Report? by: admin
October 12, 2009, 14:51
The basic difference between Close() and Dispose() is, when a Close() method is called, any managed resource can be temporarily closed and can be opened once…
- Difference between Clone, Close and Dispose methods of Crystal Report? by: admin
- WCF (1)
- In a WCF, does the datacontract belong in the interface or the class? by: admin
October 12, 2009, 15:49
DataContract is belongs to Class.
- In a WCF, does the datacontract belong in the interface or the class? by: admin
Generated by Table of Contents Creator v1.6.4.1
by Mark Beljaars
Popularity: 8% [?]
