Interested to Buy Any Domain ? << Click Here >> for more details...
How to Skip or Get first and Last Record from Flat File
through MultiLoad and TPUMP Utility?
- 4 Answers
- 26871 Views
- Comsys, IBM, I also Faced
- E-Mail Answers
Answer Posted / kvsnr
MultiLoad is going to need to know the structure the INPUT
flat file. Use the .LAYOUT command to name the layout.
It is used to designate the starting location for this data
based on the previous fields length. If you are listing
fields in order and need to skip a few bytes in the record,
you can either use the .FILLER (like above) to position to
the cursor to the next field, or the "*" on the Dept_No
field could have been replaced with the number 132 ( CHAR
(11)+CHAR(20)+CHAR(100)+1 ). Then, the .FILLER is not needed
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
Is multi insert ansi standard?
What can be achieved by using the teradata rdbms?
Did you write stored procedures in teradata?
What is the purpose of using case expression in teradata?
How to select first n records in teradata?
What is the use of stored procedures in teradata?
Highlight the points of differences between the database and user in Teradata.
If RDBMS is halted what will you do ?
Why does varchar occupy 2 extra bytes?
Describe primary index in teradata?
Explain the new features of teradata?
What is the use of having index on table?
How do you do backup and recovery in teradata?
Highlight the need for Performance Tuning.
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
