DSXchange

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

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

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" .
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

Steve, I don't think BigPoppa is around anymore. They haven't posted since around March of this year I believe...

Cool Cheers Craig - just trying to make sure we get all these enhancements logged in the new system - If someone else wants to champion this one I'd love to get a requirements source as I've heard it before .

Cheers

Steve