Appearance of 

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Appearance of 

Post by Prashantoncyber »

Hi All,

When I am passing the data from one sequential file to another thro' transformer ,this character  is getting appended to one of colum.

I am wondering why?

thanks
Precious
Charter Member
Charter Member
Posts: 53
Joined: Mon Aug 23, 2004 9:51 am
Location: South Africa
Contact:

Post by Precious »

Hi,

Is this happening to the last column?
Are there any transformation being performed on the column involved?

Regards,
Precious

Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

Is there any warning when you try viewing data from source sequential file?

Regards
Saravanan
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Check whether you have a tab char in the column. Or you may have a null value in that char.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Post by Prashantoncyber »

Thanks for responses,

My Ans to Q asked :

Q: Is this happening to the last column?
Are there any transformation being performed on the column involved?

Ans: No this Happening at first column of Target Sequientail file however the source column from where it is coming is last one.

Following transformation is being performed:-

if char(10) then char(127): DSLink3.colB else 0 (using stage variable).

Q:Is there any warning when you try viewing data from source sequential file?

No and No warning also while viewing the Target Sequential file.

Q:Check whether you have a tab char in the column. Or you may have a null value in that char

Ans: I have Tab char and Not nullable in the all the columns of all the files.

Q:It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.

Ans: Both the places are Unix-type termination.

Hope this shall help in dignosis.

Thanks
Prahsant
Precious
Charter Member
Charter Member
Posts: 53
Joined: Mon Aug 23, 2004 9:51 am
Location: South Africa
Contact:

Post by Precious »

if char(10) then char(127): DSLink3.colB else 0 (using stage variable).
char(127) is - you are getting what you are putting in the column.
Is that what you meant to do?

Regards,
Precious

Mosher's Law of Software Engineering: Don't worry if it doesn't work right. If everything did, you'd be out of a job.
Post Reply