Control M characters in Sequential File

[gaya3]

Hi,

I have written a job control to capture the job summary using DSMakeJobReport and to write this information to a sequential file in a loop (for each job).

I am able to see the expected result in the output flat file, but I also see ^M characters at the end of each line in the output.

Can anyone please suggest a way to remove these charcters in the output?

[DSDexter]

There are various ways of removing the ^M characters. Simplest one is to use the dos2unix utility.

This will work...Just in case if it doesnt, use the tr utility of unix. Use the following command to remove the ^M characters. You can use this commands in a before job routine and strip the unwanted character.

Code: Select all

tr -d '\r' < yourfile.txt > yourfile1.txt
mv yourfile1.txt yourfile.txt

[ray.wurlod]

Change the line terminator in Sequential File stage from DOS-style to UNIX-style (it's a stage property).

[Sainath.Srinivasan]

Infact it is to change FROM Unix TO DOS terminator.

[gaya3]

Hi Ray, Iam not using a Sequential File Stage. I have used OpenSeq and WriteSeq commands to write to a flat file in a Job Control.

Is there an option to avoid the occurence of ^M characters while writing to the file itself? I would not prefer to remove the characters after the file has been created, because this job is going to be run as part of the main sequencer everyday.

[mandar84]

As an alternative, try using $APT_STRING_PADCHAR enviroment variable in you Job Parameter list and set it to 0x20(space)

[Sainath.Srinivasan]

As an alternative, try using $APT_STRING_PADCHAR enviroment variable in you Job Parameter list and set it to 0x20(space)

This is Server architecture and not PX. So no APT variables.

[gaya3]

Hi all,

I have decided to invoke a script as suggested by DSDexter in the After Job Subroutine to remove the characters for now.

Thanks everyone!

[ray.wurlod]

In your routine simply

Code: Select all

Convert CtrlM To "" In Line

where CtrlM = Char(13)

[chulett]

So do I take it that, when you write out sequential file records with those routines, they give you DOS delimiters even on a UNIX system unless you 'convert' them with the syntax you posted?