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

Global Moderator


Joined: 14 Mar 2007
Posts: 10373
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 query to fetch record which has only ... maxsubrat DB2 4 Mon Dec 11, 2017 5:03 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Squeeze record left so that zeroes ar... Vignesh Sid SYNCSORT 5 Fri Nov 10, 2017 1:40 pm
No new posts Formatting multiple records to a sing... Vignesh Sid SYNCSORT 3 Tue Nov 07, 2017 12:22 pm

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