fisql – Seeing “Carriage Return”

Background

Received email pasted below.

The email indicates that we are seeing Carriage Return in the output of one of unix scripts.

Email

Email Image

fisql_seeingCarriageReturn_email_20180720_1113AM.png

Email Text


 end as f6

,case len(rtrim(ltrim(appt_title_code_name)) + rtrim(ltrim(emp_primary_title)))  ^M^[[A^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[K

when 0 then null

when null then null

else rtrim(ltrim(emp_primary_title)) + ' - ' + rtrim(ltrim(appt_title_code_name) ^M)

Trouble Shooting

Reviewed the script and saw that it uses fisql.

Dug into the SQL and did not see anything amiss.

Editor ( vi )

Hidden Characters

Launched vi and asked for hidden characters to be shown.

BTW the command is “:set list”

Again, Nada.

Line Length

Finally noticed that the offending line length is longer than others.

Remediation

In your SQL file, please make sure that each line’s length is within 80.

References

  1. systutorials.com
    • fisql
      • fisql (1) – Linux Man Pages
        Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s