I'm trying to burst report into multiple files before ftping in the schedule. The procedure does use correct primary sort field, so it's doing the right thing.
I want to modify this procedure and only ftp those files that satisfy certain condition (using WHERE clause), is there anyway I can accomplish this?
FYI: I used simple WHERE clause, but it failed with Task error:ibi.jlink.EdaPcb: Pcb2.: ibi.ngxxj.NGException: local error .

Thanks in advance!

This message has been edited. Last edited by: Kerry,

If your criteria are based on the data (using a WHERE clause) then you just need to eliminate the burst values that do not meet your criteria in your WHERE statement. If your criteria are based on something else (like # of records, file size, etc., then you've got to do at least a double pass against your data.

Thanks for the reply Darin.
I'd a different problem, and it's fixed now.