Header and Trailer

us1aslam1us · Post by **us1aslam1us** » Tue Mar 21, 2006 4:30 pm

Hi all,

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

Thanks in advance
sam

rasi · Post by **rasi** » Tue Mar 21, 2006 5:46 pm

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

s_r_chandru · Post by **s_r_chandru** » Tue Mar 21, 2006 6:21 pm

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

chulett · Post by **chulett** » Tue Mar 21, 2006 8:31 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 22, 2006 3:38 pm

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

kumar_s · Post by **kumar_s** » Wed Mar 22, 2006 11:53 pm

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

us1aslam1us · Post by **us1aslam1us** » Thu Mar 23, 2006 12:17 pm

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

sendmk · Post by **sendmk** » Fri Mar 24, 2006 2:46 am

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

how to do that

kumar_s · Post by **kumar_s** » Fri Mar 24, 2006 3:52 am

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.