It seems like quite a few people need processing in PX to allow the stripping of header and trailer records for an incoming dataset. Wouldn't it be nice if the Sequential file import had separate header and trailer flags that would tell the engine to strip an existing header/trailer and output them to preset output ports?
-BP
Strip header/trailer
Re: Strip header/trailer
You can do it with import's "source" option... although this isnt a very elegant solution - source lets you run an arbitrary set of unix commands on your file first, so you could do: source "tail -999 file" .bigpoppa wrote:It seems like quite a few people need processing in PX to allow the stripping of header and trailer records for an incoming dataset. Wouldn't it be nice if the Sequential file import had separate header and trailer flags that would tell the engine to strip an existing header/trailer and output them to preset output ports?
-BP
This does however mean you have to know how many records are in the file (thanks to frobby for the detail on the command
Could you mail me directly so I can log an ecase on this and get some more detail.
Cheers
Steve