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

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

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

-

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

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

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

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

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

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

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

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

Anand

• Oct 25th, 2016

Yes, GROUP BY must come before ORDER BY if both are used

Papadon

• Jul 26th, 2016

Yes, We can.

Code
SELECT COUNT(EMPNO), DEPTNO FROM EMP GROUP BY DEPTNO ORDER BY DEPTNO;

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

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

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

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

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

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

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

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