How to load only 10 or 100 records from any file?
how to modify the loading message in execution?
You can use something like
First 10 Load * from abc.csv;
to load the first 10 records. Or use the debug dialog (open from script editor) and limit the numbers of records to load in any LOAD.
You could also use TempTable: Load *, rowno() as Row_Number Resident Tablename; Final Table: Load *, 'Temp' as TempFiled Resident TempTable where Row_Number>= 1 and Row_Number <= 100; Drop Table TempTable; Drop Table Tablename;
you can also do like this ............
in script editor window go to -select debug and in that select limit load enter the no. of records like 10 or 100 and hit run ..
hope this helps
Retrieving data ...