m_dump

1) How to print records from a file where cust_id started with 1234 by using the m_dump command ?

m_dump dml data -select 'starts_with(cust_id,1234)'

2) How to get null records using the m_dump command?

m_dump dml data -select 'is_null(your column name)'

3) How to find 5 corrupted records from a file out of 500000 records from UNIX? only 5 corrupted records have to come in the output?

m_dump dml data_file -show-partial

Note : -show-partial shows incomplete/corrupted records.

4) How to find corrupted records in multifile and how to know which partition data is corrupted?

m_dump dml data_file -validate

5) How to read the first 10 records from a multifile?

In Filter by expression use (next_in_sequence() +1)*no_of_partition() + this_partition() +1 <=10

or 

use m_dump command with -records -partition argumnets

6) How to find and remove corrupted data files of MFS?

m_dump with -validate will give a record number that has incorrect data as per the data type defined.

Use m_reformat  and m_select to filter the record.

7) How to view data of a particular partition from a multi-file  ?

m_dump dml_file_name.dml mfile:mfs8/tempfile.dat -partition 3

8) How to get 2nd record of each partition of 4 way multifile ?

m_dump dml_filename.dml data_file | awk 'NR==2'{print ;}