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

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

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

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

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

sekhar018

 Profile Answers by sekhar018 Questions by sekhar018

• Oct 18th, 2008

Cursor is a Context Area. where which can process multiples rows.

Answer Question  Select Best Answer

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by 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...

Answer Question  Select Best Answer

What does WITH HOLD option do ?forces cursor to close after commitb.Keeps cursor open after commitc.Does not allow cursor to close till all rows are fetchedd.Locks the cursore.None of the aboveKeeps cursor open after commit

BrantleyL1

 Profile Answers by BrantleyL1 Questions by BrantleyL1

• Jul 27th, 2011

This answer is wrong. It keeps the cursor open.

prasadkss

 Profile Answers by prasadkss Questions by prasadkss

• Dec 4th, 2009

When a commit is issued by a program all the cursors opened by that program are closed, but WITH HOLD option is used to retain the cursor pointer, even if the commit is used.

Answer Question  Select Best Answer

What are the important bind parameters to be used in bind card? What is the significance of each parameter?

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

I will say the Answer Depends barring a few parameters which are mostly used. 1) ISOLATION -> Isolation Level to decide level of locking used along with LOCK parameters on the DB2 objects. 2) ACQUI...

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

The bind parameters are generally generic the most important is isolation level which is always CS and sometimes UR if you want to rock right thru.

Answer Question  Select Best Answer