Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36

abhay

• Jul 18th, 2016

The ans is 36, I have tested it.

Devu

• Feb 26th, 2015

36

Answer Question  Select Best Answer

i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True

Gilbert

• Mar 3rd, 2015

Both are true

Rishu

• Aug 9th, 2014

3 ii) is Only True

Answer Question  Select Best Answer

Yaswanth

• Jul 12th, 2021

Dbrm or package not found in olan

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

-805 will never occur if a DBRM is directly bound to a PLAN. -805 occurs when 1) Source Program is changed and per-compiled and new LOAD Module created as a result of change is used at Run time, but ...

Answer Question  Select Best Answer

Anand

• Oct 25th, 2016

Yes, GROUP BY must come before ORDER BY if both are used

Papadon

• Jul 26th, 2016

Yes, We can.

Code
 

Answer Question  Select Best Answer

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

Check Pending is when you have data added to the table using either insert or LOAD utility which violate table check constraints. The IBM DB2 LOAD UTILITY has ENFORCE CONSTRAINTS and similar options w...

Mohit

• May 28th, 2012

SET INTEGRITY Option....please read IBM libraries before using this.

Answer Question  Select Best Answer

The Cursor can be Declared in Working storage sectionLinkage sectionInput-Output section.
Working storage section

Sid

• May 6th, 2016

It can be declared either in working storage section or in procedure division.

Anandakumar Raju

• Apr 28th, 2016

Cursor can be declared either working storage section or procedure division. It should be declared before open cursor statement if we are declaring in procedure division.

Answer Question  Select Best Answer

madhavan

• Mar 10th, 2014

SELECT * FROM Table_Name order by column_name desc Fetch first 5 rows only;

Mohit

• May 28th, 2012

There is nothing called "fetch last n records only" in db2...

You can use select col1 from table1 order by col1 desc fetch first 5 records only

Answer Question  Select Best Answer

Cecil

• Jan 19th, 2017

As far as a knowledge of coding, you will need to learn how to modify existing JCL code. You also should have a basic knowledge of programming to the point that you can learn to modify the data you m...

Wayne Heckman

• Feb 7th, 2016

Not anything close to testing client server applications.

Answer Question  Select Best Answer

When will occur -811 abend? how will u resolve the -811 abend?

rasheeed17

 Profile Answers by rasheeed17 Questions by rasheeed17

• Jan 19th, 2012

- You will get -811 abend when your SQL query returns more than one record. - COBOL do not have ability to handle more than one db2 record at a time. - You must USE CURSOR If your query returns mor...

6983manish

 Profile Answers by 6983manish Questions by 6983manish

• Nov 12th, 2011

If the need is to get any of the row qualified for the predicates given , you can use "Fetch First 1 Row Only" with your select query.

OR

If you are interested all the data qualified for the query , there is no option except the use of Cursors.

Answer Question  Select Best Answer

dyury

 Profile Answers by dyury Questions by dyury

• Mar 8th, 2010

We can use scrollable cursor ( with DB2 V8 and higher).FETCH FIRST ROWSET STARTING AT ABSOLUTE N FROM CURSOR1 FOR 1 ROW.

kaviarasu

• Jun 23rd, 2006

SELECT  *  FROM  TABLE_NAME  AAWHERE  5 = (SELECT  COUNT (FIRST_FIELD) FROM TABLE_NAME                      WHERE FIRST_FIELD <= AA.FIRST_FIELD )WITH UR;

Answer Question  Select Best Answer

A DB2 bind is a process that builds an access path to DB2 tables.

$@1)+0$#

• Jan 18th, 2017

BIND is to your DBRM what COMPILE is to your COBOL and BIND takes your source code (the SQL) and turn it into executable code (a PACKAGE).
Hope this helps to avoid confusion!!

deepika

• Dec 18th, 2015

A bind is an executable model. It establishes the relationship between the application program and its relational data

Answer Question  Select Best Answer

BrantleyL1

 Profile Answers by BrantleyL1 Questions by BrantleyL1

• Jul 27th, 2011

This only works in CICS. Batch programs do not have the read previous record option.

chinna16445

 Profile Answers by chinna16445 Questions by chinna16445

• Jul 14th, 2008

Read filename at end display record.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Yes you should do recompile otherwise you will get n abend -818.

mail_mathewsonyc

 Profile Answers by mail_mathewsonyc Questions by mail_mathewsonyc

• Sep 1st, 2007

Hi,when you first compile a cobol-db2 program the cobol precompiler seperates all your cobol statements and DB2 statements into two seperate modules.The module containing the DB2 statements is ca...

Answer Question  Select Best Answer

aravindhan

• Oct 8th, 2015

Code
 

This query running 5 minutes. This is called performance tuning.

sagar reddy

• Apr 1st, 2015

Verifying weather a query is performing well or not

Answer Question  Select Best Answer

i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency1 Both are True2 i) Is Only True3 ii) is only True4 Neither is TrueBoth are True

Dinu

• Dec 3rd, 2017

- Used as row level locking
- Acquires an exclusive lock on the row that is to be updated.
- When the control is moved to the next updatable row, the lock is released.

Rama

• Nov 20th, 2016

Cursor Stability provides the High Concurrency (more than one db2 application program can access resource) as it locks only one row.
Repeatable Read Leads to Higher consistency as it hold the page

So both are true

Answer Question  Select Best Answer

Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates? A. Read Stability B. Repeatable Read C. Cursor Stability D. Uncommitted Read

manasa

• Nov 4th, 2011

Cursor stability would be the best one.as it gives consistentdata.

Anil Tambvekar

• Oct 6th, 2011

Uncommitted read would be the Best choice as our application is read only application.

Answer Question  Select Best Answer

What is a db2 precompiler?

davindersingh29

 Profile Answers by davindersingh29 Questions by davindersingh29

• Jun 18th, 2009

Consistency token and time stamp are same thing.

veluvpv

 Profile Answers by veluvpv Questions by veluvpv

• Apr 16th, 2009

I would like to add few points to it, during pre-compilation process it creates an consistency token (not time-stamp) between bind package and load module.

Answer Question  Select Best Answer

Can you select any column in a Group by query even if that column is not groupable?e.g. Select Dept, Empno, Ave(salary) From T1 Group by DeptCan we select empno in the above query?

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Apr 11th, 2010

Yes Empno should be included in the query.

Anand_Hakke

 Profile Answers by Anand_Hakke Questions by Anand_Hakke

• Aug 7th, 2009

No, It is not posssible to select ungrouped column in a query.

Answer Question  Select Best Answer

DCLGEN stands for declarations generator; it is a facility to generate DB2 sql data structures in COBOL or PL/I programs.

RamehNaiduKVA

• Oct 25th, 2007

In COBOL DB2 programs the host variables are needed for the column names of the tables. This can be done by a DB2 utility called DCLGEN Declaration Generator. This is primarily a copybook of host vari...

sunil bansal

• Sep 11th, 2007

It is the place where the complete data field of the table is present and it is easy to use the data name when ever required. Without dclgen also one can run the program but he has to declare all the things in the working-storage section.

Answer Question  Select Best Answer

vardhan.frd

 Profile Answers by vardhan.frd Questions by vardhan.frd

• Dec 21st, 2011

In COBOL

Code
 

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Sep 2nd, 2008

last 2 who answered the query didnt you see that its a VSAM based question...dont just put up anything and everything.

Answer Question  Select Best Answer