How to eliminate the thicked pipeline |

venkycool · Post by **venkycool** » Wed Feb 21, 2007 1:30 am

Hi Everyone,

I just wondering why the thicked pipeline | which appears after the text in my target ODBC. For eg:

my target record should appear like :

TF tfr plnt to plnt

But, in the target the thicked pipeline is added like

TF tfr plnt to plnt | (in bold)

Can anybody let me know how to elimate that pipeline which is appearing after the text record in some of the columns in the Target ODBC.

Thanks in Advance...

khaja.arshad · Post by **khaja.arshad** » Wed Feb 21, 2007 1:46 am

Try to remove any spaces while doing concating any strings

Or

It might be from extra size of the field

-----
Hameed

venkycool · Post by **venkycool** » Wed Feb 21, 2007 2:06 am

Hi,

if this is because of the extra size in the field then why it is appearing only in few columns where all the fields are of the same length? and also tried with the space as u said... Also tried with all the necessary string manipulation. Any other suggestions?

Thanks.

kumar_s · Post by **kumar_s** » Wed Feb 21, 2007 2:10 am

How are you populating the table?
Check the source data that used to populate the data. Check if any transformation logic involved which appends any special character or a space or newline character or tab character at the end of it.

venkycool · Post by **venkycool** » Wed Feb 21, 2007 4:20 am

In the transformations, I am doing the TrimLeadingTrailing to all the records and this is the only logic am doing. But, since I mentioned it is giving the thicked pipeline only in few columns not in all the columns.

khaja.arshad · Post by **khaja.arshad** » Wed Feb 21, 2007 4:53 am

Where you are viewing the data ? in DS or in Database?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 21, 2007 4:53 am

Put in a Peek stage and use it to grab a sample of rows into a file. Then use a hex editor to find out the ASCII code of the character in question.

venkycool · Post by **venkycool** » Wed Feb 21, 2007 6:03 am

am viewing the data is Datastage only....that is SQL (DRS)

venkycool · Post by **venkycool** » Wed Feb 21, 2007 6:07 am

yeah will try the same and this is the solution or will check for the thicked pipeline?

khaja.arshad · Post by **khaja.arshad** » Wed Feb 21, 2007 6:10 am

try to see the results in database ...if it is ok in database ..then i don't think it's an issue ...if it is ok in DB ....In DS increase the column the width(dragging the width ) where u view the data

----
Hameed

balajisr · Post by **balajisr** » Wed Feb 21, 2007 6:10 am

What is your source?
Check if you have any special characters in the source.

venkycool · Post by **venkycool** » Wed Feb 21, 2007 6:16 am

My Source is Sequential File (Flat file). Anyways, I will try increasing the width and see...and get back to u guys...thanks

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 7:36 am

Does this happen in the source as well (in the sequential file stage view data)? If it does then its a dos file that you are viewing as a unix file. Change it to dos style in the sequential file stage properties so that it does not transfer it over to the database.

narasimha · Post by **narasimha** » Wed Feb 21, 2007 9:33 am

If you have Contol M's in your fields, they look like "thicked pipes" when viewed from the stages in Datastage.
Trim before loading.

venkycool · Post by **venkycool** » Wed Feb 21, 2007 10:46 pm

Hey Brian, that worked man and now i dont see any thicked pipeline in my target... as i changed the format as the dos style in Seq File stage properties...thanks alot and this happened with few of my jobs and will put the same for those jobs also....thanks you guys for your response...

DSXchange

How to eliminate the thicked pipeline |

How to eliminate the thicked pipeline |

Reading data from source text file