IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 8343

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 4468

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 7081

What is the difference between Primary key and unique index?

6 8663

My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)

HCL, IBM, L&T, TCS,

11 53200

How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.

IBM,

13 24593

What is the use of a COPYBOOK in Fileaid ?

Steria,

4 10821

Looking for mainframes IMS DB training @ 9912598882

3 6407

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 7812

What is package versioning? Please give an example.

1 4216

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 5354

What is the difference between the NOHANDLE option and the IGNORE condition?

3 16553

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

Syntel,

8 16715

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 20529

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 20696


Un-Answered Questions { IBM MainFrame }

Explain the difference between getting the system time with eibtime and asktime command?

676


What is rmode(any) ?

776


Explain the primary significance of intra-partition and extra-partition tdqs ?

680


how you will the direct the data to spool using sysout option?

1925


What is a bind card?

770






What is the maximum of key fields and search fields allowed in a segment?

657


Explain the difference between pseudo-conversational and conversational?

679


What is the role of union all and union

727


what if I need to have the same application running on multiple platforms, such as unix and the mainframe? Does that mean I have to maintain two separate sources?

586


Explain identify whether a call statement is a static or dynamic call?

652


what is use of space parameter in dd statement?

853


I want to set position for a particular text in a certain position in several of my cics maps.Please provide me with a solution. Ex: If "F1-Help" has to be set to pos(4,27) always in all the maps within a PDS.

2015


can any one plzzzzzz tell the jcl code for creating ps using idcams

10768


Define gdg?

640


What is isolation level in db2?

654