What is the difference between internal tables and extract datasets?

• The lines of an internal table always have the similar structure. By using extract datasets, you can handle groups of data with dissimilar structure and get statistical figures from the grouped data.
• You have to describe the structure of the internal table at the starting. You need not describe the structure of the extract dataset.
• In contrast to internal tables, the system partly compresses precise datasets when storing them. This decreases the storage space required.
• Internal tables need special work area for interface while extract datasets do not require a special work area for interface.

 

Posted Date: 5/11/2013 3:59:01 AM | Location : United States

Ask an Expert

Related Discussions:- Difference between internal tables and extra datasets, Assignment Help, Ask Question on Difference between internal tables and extra datasets, Get Answer, Expert's Help, Difference between internal tables and extra datasets Discussions

Write discussion on Difference between internal tables and extra datasets
Your posts are moderated

Write your message here..

Related Questions

Explain the timestamp ordering protocol, Timestamp Ordering Protocol A ... Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Explain instance and schemas, Explain Instance and schemas? Instances ... Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Define the unique constraints for the table client, Define the following co... Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

What is an operand, What is an Operand? The data on which the operation... What is an Operand? The data on which the operation is to be performed is known as an Operand

What are the ways in which signal can be generated, What are the ways in wh... What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

List out user authorization to modify the database schema, List out various... List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

Relation and relational schema, A relation has: Relational Schema ... A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

Explain the lock based protocol, Lock Based Protocol A lock is nothing ... Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t

What is serializability, What is serializability? Explain its types? Th... What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.