-
Db2 pre-compiler
What is a db2 precompiler?
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.
-
Which statements are executable in cursor syntax?
sethy.pradeep
- Nov 19th, 2008
Fetching cursor is the executeble statement in cursor syntax.Regards,pradeep
-
Exec sql and End exec
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
ABSS1981
- Sep 18th, 2009
In addition to the answers posted one of the additional things to have an INCLUDE between EXEC SQL and END-EXEC is that:You INCLUDE most likely will be a DCLGEN and it is going to have non COBOL langu...
memays
- Apr 30th, 2009
It all has to do with the sequence of compiling a program with imbedded SQL. It is important to understand that a COBOL program with SQL statements will actually go through 2 steps in the ...
-
What is an alias and how does it differ from a synonym?
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
greeshmavarghese
- Oct 7th, 2009
Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.? Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.
sithusithu
- Jan 27th, 2006
An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu
-
What is a cursor and what is its function?
An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.
nnina
- Oct 12th, 2009
Cursor is a programming device. If you want to fetch more than one record from DB2 table it can be easily done with the help of cursor because single DB2 query fetch at a time one record if it find more than one records (Duplicate) it will gives -811 (trying to retrieve more than one row).
-
What is the difference between DB2 and DB2 UDB?
SspSsp
- Oct 28th, 2009
The main difference between DB2 and DB2 UDB is that DB2 UDB has open DBMS connectivity to other open systems. I.e., though on a mainframe system, it can connect to Java, Unix and a variety of other op...
-
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
-
How to increase table space in db2?
Raghunathan Asari
- Jul 23rd, 2007
User ALTER command to change the PRIQTY and SECQTY of the Tablespace.Eg. ALTER TABLESPACE db.ts PRIQTY 50 SECQTY 50.Here PRIQTY => primary quantity in 50 KB and ...
-
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure? A. DB2 Runtime Client B. DB2 Personal Edition C. DB2 Administration Client D. DB2 Application Development Client
mkumarshashi
- Jan 21st, 2010
DB2 Application Development is required on the client machine to run the stored procedure.
-
DB2 Index Space
A index space contains: Multiple indexesSingle index onlyIndexes for a single tableThere is no concept of index space
Single index only -
DB2 Table Delete Question
Target table T1 is getting deleted. Table T2 has the foreign key. We require that whenever a row from T1 is deleted, the corresponding row from T2 also be deleted. Which option can be used? a.ON DELETE RESTRICTb.ON DELETE CASCADEc.ON DELETE SET NULLd.ON DELETE CHILDe.ON DELETE MATCHON DELETE CASCADE
kalone
- Jan 31st, 2010
ON DELETE CASCADE: If a row in the parent table is deleted, all the corresponding row in child tables will automatically be deleted.ON DELETE RESTRICT: The delete operation on parent table is restricted if there is a matching row in child table.So, ans to the above query should be ON DELETE CASCADE.
-
What are db2 pre compilers?
kalone
- Jan 31st, 2010
DB2 pre-compiler extracts all the SQL stmnts from the appln prg and keeps them in DBRM and comments those SQL stmnts (in the appln prg) and replaces them with a CALL.
-
How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)?
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;
-
DB2 View Purpose
Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately for user copye.To get data from multiple tables To store data separately for user copy
ambareeshtss
- Oct 19th, 2008
DB2 table may have many fields, All the users are not intended to see some fields. To customise this, Views are created for DB2 tables. A single DB2 tables can have any no.of views.
-
Which of the following is not true about Bind ?
a.Programs bound to packages must still be designated in a plan.b.SQL statements are validated during Bind.c.Authorization is verified during bind.d.SQL statements cannot be executed unless bind is performed.e.The program should determine the db2 access path before the bind is performed.The program should determine the db2 access path before the bind is performed.
yuvaevergreen
- Mar 26th, 2010
The program should determine the db2 access path before the bind is performed.
-
DB2 Synonyms
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
-
DB2 Storage groups
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices -
How do we unload the DB2 tables using JCL?
yuvaevergreen
- Mar 26th, 2010
We can use UNLOAD utility for loading a table to file. Following is a sample JCL.//STEP1 EXEC DSNUPROC,UID='SMPLUNLD',UTPROC='',SYSTEM='DSN'//SYSREC DD DSN=USERID.SMPLUNLD.SYSREC,// DISP=...
Smitha Brindavan
- Mar 15th, 2007
If DBP1 is the subsystem name, then the below unload step can be used//STEP001 EXEC DBP1UNLD,USER='USERNAME',ULDTAB='FILE1',DATE='UNLOAD(+1)' //UNLOAD.SYSREC00 DD SPACE=(CYL,(6...
-
Explain about CHAR function and it's use in DB2
yuvaevergreen
- Mar 26th, 2010
Returns a fixed-length character string representation of Datetime Character Integer Decimal Floating-point number Row ID
kalone
- Feb 1st, 2010
If we want to concatenate date or time values to some text ,then we have to convert those values to string char first ,for this in DB2 we have CHAR() function.Eg. CHAR(CURRENT DATE)
-
What is the result of the following statement?
Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What is the result of issuing the following statement? SELECT * FROM dwaine.mytab
DB2 Interview Questions
Ans