adding " . " with column name

mandyli · Post by **mandyli** » Thu Jun 23, 2011 3:12 pm

Hi

I am creating file from mainframe source files.

But I would like give column name with ".".

ex :NameID but in my out put file I need Name.ID

Is there anyway I can able to add "." for columnname?

Thanks
Man

chulett · Post by **chulett** » Thu Jun 23, 2011 4:39 pm

Do you mean creating a first record which contains the column names? Since that's based on the field names in the job and "." is not valid in a field name the stock answer on can you do this automagically would be no.

You could create the record "before job" and then set your output to append to the newly created one record file. Do this by a simple 'echo' of the contents to the filename or keep a one record file stashed elsewhere and copy it to the target location, overwriting what is there.

mandyli · Post by **mandyli** » Thu Jun 23, 2011 5:14 pm

chulett · Post by **chulett** » Thu Jun 23, 2011 10:43 pm

Ok... and?

samyamkrishna · Post by **samyamkrishna** » Fri Jun 24, 2011 6:51 am

you can do it with unix commands in the after job subroutine.

chulett · Post by **chulett** » Fri Jun 24, 2011 7:05 am

You might want to expand a wee bit on the how of that. Still better before job, IMHO.

samyamkrishna · Post by **samyamkrishna** » Sat Jun 25, 2011 3:46 am

Hi Craig,

Are you asking me to explain a bit more.
Or Are you asking the guy who posted the topic.

Regards,
Samyam

chulett · Post by **chulett** » Sat Jun 25, 2011 6:56 am

samyamkrishna wrote:Are you asking me to explain a bit more.

Yes.

It's one thing to say "do X" when it is obvious what that means, but a general statement like "use unix commands after job" should really be explained. IMHO. And I'm sure Mandyli would appreciate it as well.

samyamkrishna · Post by **samyamkrishna** » Mon Jun 27, 2011 12:32 am

Hi Mandyli,

Try something like

sed '1s/NameID SalaryId/Name.ID Salary.ID/' Outputfile > OutputFileTemp

This should help