Anand

• Oct 25th, 2016

Read - INPUT - SHR, OLD
Write - OUTPUT - NEW, OLD
Rewrite - IO - OLD
Append - EXTEND - MOD

nder

• Aug 2nd, 2016

3 modes.
Read, Write, Read-write depending on the data processing.

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

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

What are memory structures used to handle multiple row selections at a time 1 Cursors2 Host Variables3 Indicator Variable4 SQLCACursors

Mahi

• Apr 6th, 2017

1 Cursors

Answer Question  Select Best Answer

Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results.

Yash Rajput

• Aug 15th, 2017

Static SQL: 1) SQL statements are compiled at compile time.
2) more efficient.

Dynamic SQL: 1) SQL statements are compiled at run time.
2) Less efficient.

Answer Question  Select Best Answer

Explain what is - 530 DB2 return code? How will you resolve it?

supriya

• Sep 21st, 2017

Constraint name is invalid.

abhilasha

• Apr 30th, 2017

THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS INVALID

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

-

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

How to handle a non-matching column (which is NULL) in outer joins. My site standards prevent the use of Null indicator.

Shanthi G

• Jan 29th, 2019

If any column is null we need to declare null indicator of S9(04) comp for that . if you not mention null indicator while fetching record that is null it shows -305 error.

Answer Question  Select Best Answer

SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.

Read Best Answer

Editorial / Best Answer

Answered by: burelamanohar

• Feb 6th, 2007

---

SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal

vineeta bachani

• Oct 17th, 2019

In SPUFI: we can store and write multiple queries but will execute only one at a time. here we mention user-defined input and output datasets
IN QMF: every time we open it we have to write the SQL query again. we dont give input and output datasets

jzmoonrock56

 Profile Answers by jzmoonrock56 Questions by jzmoonrock56

• Aug 31st, 2011

Interactive SQL commands Special Processor Utility File Input

Improve 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