All Forums Tools
Bobby890 12 posts Joined 05/11
15 Apr 2013
Tools and Utilities

Hi,
How to load rows from Nth record to N+10 records from flat file to a table by using BTEQ Import and Fastload?

KS42982 137 posts Joined 12/12
15 Apr 2013

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.

KS42982 137 posts Joined 12/12
15 Apr 2013

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.  

You must sign in to leave a comment.