Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Maximum Record length in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Rajesh S
Warnings : 1

New User


Joined: 11 Jul 2007
Posts: 54
Location: Chennai

PostPosted: Wed Oct 10, 2007 5:39 pm    Post subject: Maximum Record length in DB2
Reply with quote

Hi All,

What is maximum record length in DB2? And What the main difference between SPUFI and QMF?




With Regards

Rajesh S
Back to top
View user's profile Send private message

nuthan

Active User


Joined: 26 Sep 2005
Posts: 146
Location: Bangalore

PostPosted: Wed Oct 10, 2007 5:55 pm    Post subject:
Reply with quote

A row has to fit on a page. So it depends on what page size is defined for
the tablespace that the table is utilizing (either explicitly or by
default). The largest page size is about 32K (with room needed for page and
row overhead). Certain kinds of large objects can be stored by DB2 that are
larger than 32K (which I assume you know about), but these not stored in a
normal tablespace.
Back to top
View user's profile Send private message
nuthan

Active User


Joined: 26 Sep 2005
Posts: 146
Location: Bangalore

PostPosted: Wed Oct 10, 2007 5:57 pm    Post subject:
Reply with quote

Differencr between Spufi and QMF is:
SPUFI :

1.you can execute more queries at a time.
2.you know the sqlcode after executing the query.

QMF:
1.you cannot execute more than one query.
2.you can't know the sqlcode of the query.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10478
Location: italy

PostPosted: Wed Oct 10, 2007 7:58 pm    Post subject: Reply to: Maximum Record length in DB2
Reply with quote

SPUFI

is a simple command environment to issue sql command and queries
useful for the development environment

QMF

is a an environment with sophisticated reporting features
there are large applications written in QMF
given some organizational assumptions
it is a tool that can be used directly by the end user to produce
highly customized reports
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Count a particular record in a... Mounika Nemani DFSORT/ICETOOL 5 Tue May 29, 2018 1:07 pm
No new posts TRAILER3 is creating blank record in ... kodeesm DFSORT/ICETOOL 3 Fri May 18, 2018 5:45 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts Limit in Length for a CICS START seahawk789 CICS 6 Mon Apr 02, 2018 8:34 pm
No new posts Logic to skip Maximum time-stamp and ... vickey_dw DB2 2 Thu Feb 01, 2018 11:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us