Tools and Utilities

Tools
Enthusiast

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?

Tags (1)
2 REPLIES
Enthusiast

Re: Tools and Utilities

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.

Enthusiast

Re: Tools and Utilities

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.