How to load rows from Nth record to N+10 records from flat file to a table by using BTEQ Import and Fastload?
In Fastload, you can use options like RECORD and THRU to load the rows fro Nth record to N+10.
For BTEQ, I am aware of SKIP option that would allow you to load from the Nth record, but not sure how to get only N+10 records. There should be something like THRU, but never tried that.
As I kept my thinking cap still on, got one idea. I think (not 100% sure though), you can achieve N+10 records using BTEQ if you use .SET RETLIMIT = 10 along with the SKIP option. Try it out and post if it works or not.