Cursor stability means that DB2 takes a lock on the page the cursor is accessing and releases the lock when the cursor moves to another page.

sintalam4

 Profile Answers by sintalam4 Questions by sintalam4

• Dec 21st, 2010

The Cursor Stability (CS) isolation level is the default isolation level and locks any row on which the cursor is positioned during a unit of work. The lock on the row is held until the next row is fe...

radibioinfo

 Profile Answers by radibioinfo Questions by radibioinfo

• Oct 2nd, 2007

Cursor stability  isolation level ensures that any row that was changed by an application process cannot be read untill committed by that process. It ensures that the current row of every updatab...

Answer Question  Select Best Answer

Joins, unions and nested selects are used to retrieve data.

Srinivas17738

 Profile Answers by Srinivas17738 Questions by Srinivas17738

• Aug 17th, 2010

Inner JoinLeft Outer JoinRight Outer JoinFull Outer join

AR

• Mar 16th, 2007

The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A,  Table2 B WHERE A.EMP_ID = B.EMP_ID

AND A.EMP_ID = 100001 END-EXEC.

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

ruth suganya sebastian

 Profile Answers by ruth suganya sebastian Questions by ruth suganya sebastian

• Jan 6th, 2009

sysibm is a default schema which has all the base tables and syscat is also a default schema which has the tables and views of sysibm objects...

uma

• Jan 23rd, 2007

hi,  sys cat will give all data sets that are catalogged ang sys ibm will give all data sets.

Answer Question  Select Best Answer

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

Returns a fixed-length character string representation of Datetime Character Integer Decimal Floating-point number Row ID

kalone

 Profile Answers by kalone Questions by 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)

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

?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

-

Shanthi G

• Jan 29th, 2019

Check wether that jcl is using utility called IKJEFT01 if it uses this it is having db2

Amit

• Jun 27th, 2015

Search for db2 keywords in sql code.

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

It is a DB2 facility for static SQL statements - it replaces these statements with calls to the DB2 language interface module.

Raghuram

• Jul 17th, 2007

During Pre-compilation : 1. The embedded SQL statements are stripped out.  In the source code they are commented out and instead CALL statements are inserted.2. Based on the DECLARE TABLE st...

Sukanya Srinivas

• Apr 20th, 2007

Precompiler: 1) Checks for SQL syntax in application prgram 2) Copies all the?SQL statements into a sepearte member known as DBRM(DataBase Request Module) 3) Comment all the SQL statements 4)...

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

An outer join includes rows from tables when there are no matching values in the tables.

lrsantosh

 Profile Answers by lrsantosh Questions by lrsantosh

• Aug 18th, 2011

Outer Join is a type of join where the matching rows from the given tables are selected for sure and it follows following criteria to select unmatched rows. 1. LEFT OUTER JOIN it will give All Matchin...

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Sep 2nd, 2008

3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected.

Answer Question  Select Best Answer

B L Praveen

• Sep 21st, 2007

You will declare the Cursor with "WITH HOLD " Option when you?want the cursor to be pointing to the next row even after the fetch from the db2 table and you exit from the program until expilicit commit is performed to updated to Db2 and Close cursor command is executed.

subbu

• Feb 20th, 2006

 hi,We use cursor only when we updating existing records or Inserting Some Records to the Table.When you Using commit, in DB2 every single row will be commited after the process. If abend oc...

Answer Question  Select Best Answer

sita

• Feb 26th, 2007

Yes, We can see the Comp-3 Data by pressing Hex On In the File-AID

Bibhu

• Mar 31st, 2006

What I think we cannot see the comp-3 value by USAGE verbwe have to type HEX ON in the command prompt of that particular file to see the numberExample:        &...

Answer Question  Select Best Answer

srinu86k

 Profile Answers by srinu86k Questions by srinu86k

• Dec 3rd, 2009

By altering its secqty values.

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      ...

Answer Question  Select Best Answer

Uma mahesh

• Oct 22nd, 2007

After binding you can use IKJEFT01 utility in stepname and specify db2 system name, program, library and parm in sysin dd *

sangramkc

• Dec 28th, 2006

We use IKJEFT1BAnd pass the follwing in the SYSTSIN DD *DSN SYSTEM(your DB2 system name)RUN PROG(DB2 program name) -PLAN(the plan name to which the program is bound) -PARM(' vale to be passed') -ENDWe need a corresponding SYSTSPRT DD parameter just like SYSOUT or SYSPRINTJai sai ram

Answer Question  Select Best Answer

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

Embedded SQL -> Access Path is generated during BIND time. also table authorizations are checked during BIND (if VALIDATE(BIND) is used).

Dynamic SQL => Access path is generated during Run-time. Table authorizations can only be checked during run-time.

kalone

 Profile Answers by kalone Questions by kalone

• Feb 1st, 2010

STATIC sql(embedded) : It is hardcoded in the program itself and the changeable                   &n...

Answer Question  Select Best Answer

sangramkc

• Nov 28th, 2006

for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a  deadlock or timeout occurred. The most common reason codes are:   ...

bnirmalraj

• Sep 26th, 2006

911 - THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO      DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name &...

Answer Question  Select Best Answer

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

Not on DB2 table,
However it can be displayed on internal table.

BrantleyL1

 Profile Answers by BrantleyL1 Questions by BrantleyL1

• Jul 27th, 2011

However, here is an easy solution:

code in ws...

01 ws-index pic S9(8) comp.

set ws-index to (table-index)
display ws-index.

Answer Question  Select Best Answer

A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column? A. Using a view to access the table B. Using a referential constraint on the table C. Revoking access from the phone_number column D. Defining a table check constraint on the table

mk.2010

 Profile Answers by mk.2010 Questions by mk.2010

• Aug 29th, 2010

Providing views is the best practise to hide the sensitive info.

davindersingh29

 Profile Answers by davindersingh29 Questions by davindersingh29

• Jun 22nd, 2009

A. Using a view to access the tableOne should create a VIEW, this way the phone number column can be made read only.

Answer Question  Select Best Answer