DSXchange

Hi all,

Can we have header and trailer records in the sequential file through datastage?

Thanks in advance
sam

Sam

The answer is 'Yes'.

You can have header and trailer records in your sequential file. You may have to filter header and trailer records during the process if you don't want these to be processed inside your job

Hi Sam,

The Best way to accomplish Header and Trailer in Seq File is to Create Header,Trailer and Detail record in a Three Different Seq file and Concatenate all the three Seq file into One.In which you have Header,Detail and Trailer Record.

-Chandru

You've gotten two different answers, Sam, because you haven't said if you are trying to read a file with header and trailer records or are trying to create one.

You might investigate the Complex Flat File stage. It can deal with multiple record types.

This can also be accomplished by appending the DSJobStartDate and DSJobStarTime in After job subroutine.

kumar_s wrote:This can also be accomplished by appending the DSJobStartDate and DSJobStarTime in After job subroutine.

Hi kumar

can you elaborate this a little.

Thanks
Sam

kumar_s wrote:This can also be accomplished by appending the DSJobStartDate and DSJobStarTime in After job subroutine.

how to do that

I need to check the way to use it in after job subroutine.
But you can use the UserVariableActivity to pass these variable to a ExecuteCommandActivity. Which inturns will append the the file with these information.
By giving 'echo' in the command and Parameters (DSJobStartDate and DSJobStarTime) passed from the previous stage (UserVariableActivity) and >> filename.txt in the Parameters.