DSXchange

Slip of the finger. It is a parallel job.
Thanks
JR

We need to receive a sequential file in the following format: File Header Record Item Header Record Item Detail Record Item Detail Record Item Detail Record Item Header Record Item Detail Record Item Detail Record Item Header Record Item Detail Record Item Header Record Item Detail Record Item Detai...

You can certainly read data from a clustered table in SAP although this might not be the most efficient way to go. It's generally only practical to do this if you have the full table key and even this will give slow response times due to the way cluster tables are handled in SAP.

Why not generate the code in your SAP development system then get a SAP bod to transport it through to your production system? Datastage doesn't have to create the program every time you run a job.
Hope this helps
JR