DSXchange

Open Edit Column Metadata window for newly added column and there you have the option of defaulting this new field to a constant value instead of randomly generated data on the basis of specified datatype.

Try IsValid function

Please read my posting clearly before suggestion I am saying comma within quotes is getting treated as delimiter which should not..THATS MY ONLY CONCERN PLEASE DONT SUGGEST, LENGHT PROBLEM OR SOME TRUNCATION PROBLEM. this is not the way of asking for favour... this is a professional forum, please t...

could you please provide sample record having junk characters

Is this question for Ray only

This also doesn't looks sufficiant information for debugging . Please explain your job design, database etc.

Starting two threads for a same problem won't speed up resolution of your problem. Moreover if your previous post Unable to read the dataset is resolved then mark it as resolved with the solution implemented so that could be useful later for other guys as well, else respond to that. Don't leave them...

Palak,
Could you please let us know your database and its version. Also if your query is resolved, please mark it as Closed.

Kenny, I don't have datastage access at the moment, so can't try it on my side. But still , want you to give a last shot by assigning datatype of this field as VARCHAR all throughout the job starting from source to target. If it still doesn't works, will try it tomorrow if you don't get solution by ...

not sure why this is happening... but try using trimming in a stage variable with varchar datatype and use that stage variable in the column derivation.

it looks fine...

try using this one: Post error log as well.

could you please also post the exact column derivation of this field used in transformer stage.

Is this the complete error message from logs?

Make sure that you are able to read dataset in target dataset stage of your first job. If yes, then try to view the dataset in source dataset stage of second job. If any of these steps fail, there is no need to run your second job.

raji33 wrote:i dont know exactly what it is but what ever it may be iam converting that to , by using that command in filter

if you don't know exactly what it is, then how could you substitute it with another character.

Did you try using my other solution.

Just curious, why do you want to first convert newline to ',' character and then want to use ',' character as record delimiter.

Simply use UNIX newline as record delimiter without any substitution.