join problem

dnat · Post by **dnat** » Wed May 28, 2008 3:05 am

Hi,

I have a file which i am joining with a oracle table using a varchar column name. The name contains ampersand(&) in the values. But even if there is a join between the file and the table these records which have (&) contained in the column "name" are not being populated in the output. Is there some special handling for this?

ArndW · Post by **ArndW** » Wed May 28, 2008 3:28 am

No, the "&" should have no effect on this. How are you doing the join - do you have any custom SQL involved?

dnat · Post by **dnat** » Thu May 29, 2008 12:33 am

I had defined all the columns in the seq file stage with a default length(it had taken as 255). I just changed the column length of the join key field to its original field and it is working fine now.
But i am wondering why it was not joining the column which had & in its value. Looks wierd.