A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread

Lalit Pant

• Jul 10th, 2014

The answer is thread. The thread is used by the DB2 to pass the results of the query to the application program.
SQLCA is the set of variables that are used by DB2 to pass the status and error messages of the query execution to the program and are used in error routines and paragraphs.

prachi patankar

• Jun 22nd, 2014

SQLCA

Answer Question  Select Best Answer

DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE and UPDATE.

Rishu

• Aug 10th, 2014

DDL:- Create, Alter, Drop etc...
DML:- Select, Insert, Update, Delete, Declare, Open, Fetch, Close etc...

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

DDL - Data Definition Language - Used to create/alter/delete Database objects DML- Data Manipulation Language - Used to insert/delete/update/select the data in the database obects(table/views...)

Answer Question  Select Best Answer

Rishu

• Aug 12th, 2014

LOW-VALUE = X00 which are hexadecimal zeros.
HIGH-VALUE = XFF which are hexadecimal ones.

sc60900

 Profile Answers by sc60900 Questions by sc60900

• Oct 31st, 2008

High-Values & Low-Values are ALPHANUMERIC Figurative Constants in COBOL. These are non printable characters which are having highest and lowest values respectively in a collating sequence.

Answer Question  Select Best Answer

If any DB2 column changed,how impact analysis can be done fo this?

asharm37

 Profile Answers by asharm37 Questions by asharm37

• Sep 20th, 2014

Impact Analysis for DB2 table change: 1.What is changing-If it is column size then find out all the programs using that column in them.ADJUST THE CODE ACCORDINGLY.If working storage value is being po...

Answer Question  Select Best Answer

?a.Check if equal to NULLb.Use null indicator, 0 indicates nullc.Use null indicator, -1 indicates nulld.Use null indicator, -2 indicates nulle.None of the above.Use null indicator, -1 indicates null

PRACHI

• Feb 13th, 2015

Place a null indicator variable in front of the host variable for the nullable column in the query, A value of -1 inidcator null value retrieved

Rishu

• Aug 12th, 2014

0:- Not Null
-1:- Null Value
-2:- Null value because of some conversion error

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

IRLM is a module of DB2 which does1 Logging2 Thread creation3 Concurrency control using locking4 both logging and thread creation

sagar reddy

• Apr 1st, 2015

Concurrency control using locking

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

3. Concurrency control using locking

Answer Question  Select Best Answer

-

Phanikiran Siddineni

• Jul 5th, 2015

TableSpace is Obviously physical entity as the storage of complete table is table space. however table is just a logical part . you can find LDS files of the tablespaces in system.

pooja singh

• Jun 15th, 2015

Both are logical entity.

Answer Question  Select Best Answer

In the process of DB2 compilation after bind process will packages be created first or plan?

Rudresh

• Aug 3rd, 2015

Package

abhi_siddu

 Profile Answers by abhi_siddu Questions by abhi_siddu

• Aug 3rd, 2015

* Preparing executable from DB2 side is bind.
* Either directly bind DBRM in to plan or indirectly bind DBRM into package or plan
* Bind package is recommanded

Answer Question  Select Best Answer

Difference between char and varchar datatype

lauren

• Aug 26th, 2015

DATE - x(8)
TIME - x(6)
TIMESTAMP - X(26)
INT
SMALLINT

Surya Pemasane

• Mar 27th, 2015

VARCHAR is variable-length.

CHAR is fixed length.

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

Aravindhan

• Oct 9th, 2015

Export the excel data as insert command with, separated data into an flat file format. FTP this file in mainframe and then execute the file by submit command.

Rishu

• Aug 8th, 2014

Guys, he is not asking how to FTP files to mainframe. He wants to know, how to convert excel file(tabular format) to DB2 table format.

Answer Question  Select Best Answer

kamalbasha

• Nov 26th, 2015

The main difference between the plan and package is in db2+cobol pogramm we undergo precompilation because the compiler could not understand the statements are in between EXEC and END-EXEC so we go fo...

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

the difference is that a Package is at a more granular level. If a module is bound to a Package, any change in module requires only the Package to be re-bound, without the necessity to re-bind the ent...

Answer Question  Select Best Answer

The operating system in which DB2 runs isa.OS/2b.UNIXc.XENIXd.MVSe.None of the above
MVS

deepika

• Dec 18th, 2015

D.MVS

Aravindhan

• Oct 9th, 2015

UNIX,MVS

Answer Question  Select Best Answer

How and why to use restart checkpoint logic. I am not able to understand the concept of checkpoint restart logic. please anyone explained it to me.

Sai

• Jan 27th, 2016

Check point, we have a check point for each run. or example if we are running some 100 data to be processed and we our job failed. Here in the check point we would have kept a check or every 10, so if...

Answer Question  Select Best Answer

How to find the occurrence of letter A in the name field of a table using SQL?

sudamj

• Apr 20th, 2016

INSTR function will help if you mean to search A in the column value and NOT in table name

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

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

Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.

Siddhesh

• Oct 16th, 2016

Order By is used for sorting of data either in ascending order or in descending order where Group By is used for combining the value of unique combination. Group by used when any aggregate function is used in query.

Blue Gazoo

• Dec 9th, 2006

Group By forms Groups (of course), but this means it also SORTS; but it will also retrieve a DISTINCT RECORD SETORDER BY Sorts by the columns included in the Statement, and does not retrieve DISTINCT Records.Neither determines the order of the columns (the order of the SELECT Statement does).

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