Field name with spaces

[senthil_tcs]

Hi,

Just want to know is there a way to create column name with spaces where the output file is in tab delimited format i.e. Instead of EMP_NO they want EMP No as the column name in the output file. As we know in datastage it will not allow us to define the metadata like this..is there an alternate way to doing this?

Appreciate any inputs on this

[chulett]

Never tried, but it seems to me you'd need to either create the file without a header row and include those header values as the first record you write. That or create a file with just that header record as a template, stash it somewhere, copy it 'before job' to your target destination and then set the job to 'append' the data to that starter file.

Come to think of if, I do believe I have done the latter in the past. Worked just fine.

[keshav0307]

Yes, you can do it in Datastage
create the first record with column name.