Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My database table size is too big,moreover it does not have index number.
Can you please suggest how to get first n records while creating QVD please suggest.
Thanks,
Deepak
Hi Deepak,
At the script try like below:
First 100000 load * from tablename;
This will fetch you the first n records from the DB, then u can make the analysis.
Regards,
@vi
Load *
from table name where Rowno()<100;
Hi Deepak,
At the script try like below:
First 100000 load * from tablename;
This will fetch you the first n records from the DB, then u can make the analysis.
Regards,
@vi