DSXchange

Thank you for response. It is working now by setting quote from extended property.

When I open extended property, for the column I used datatype conversion to float was missing. After I added quote over there it is working.

Thank you for solution.

Thank you for response. Yes, when I am mapping float source datatype to Integer in Target (I used a Copy stage in between) , it is giving error that, you are mapping float to int32 which might truncate data and job is failing failing. So I used AsInteger conversion . Value in output is consistently ...

Hi, I have source column float datatype mapped to Integer in target. I used AsInteger function in transformer to convert Float to Integer , as without conversion job was failing as I was mapping float to Integer. After explicitly converting Float to Integer in target table field value is coming with...

Thank you for response.

In source I have data type as float, in transformer I used decimaltoString function and converted to varchar.In target it is varchar only ,still it is not getting quote. Please let me know if there is any solution .

Thanks

Hi, I am creating CSV files from table and in , Job desig is like Table --> transformer (used for datatype conversion as I changed all output to varchar). From Source I have datatype like : Varchar, Decimal and Date . I want output records with quote , like "A"."12","01/01/2...

Thank you for response. I am reading XML files (multiple files) using ESS and in Transformer, I got file names using count function. I was mapping Trnasformer to XML Input stage (I loaded the XSD). What do I need to pass there in Output column derivatio ? As I am unable to pass that file name value ...

Thank you for your reply chulett.

Becuase of some function requirement, I can't go for server job. Just wanted to check if it can be implemented in Parallel job.

Thank you,

Hi, I am using External Source stage to read XML file through DataStage. My question is: when we are reading any(CSV/TXT) file using Sequential File stage, we can set Source File Column ='True' and get source file name , is there any such option to read source file name while reading XML file ? I am...

Hi, In our project, we need to capture the name of DataStage job those are in running state.(writing the name of the jobs in a file those running at a particular time). We can capture the Status of a Datastage job through Shell script using dsjob -report function when job is in Finished Ok/with warn...

Hi,
Thanks for reply.
code is working now.
Thanks,

In the both tables datatype of column is varchar and in all stages (datastage), propragated the column value as varchar only. In the job or tables no where Raw datatype is mentioned . One more observation : The column which is giving error, is present in Changed values of CDC( as per design requirem...

Hi, My datastage job structure is like Oracle table --- --CDC-- target table (sybase) Sybase table-- while running the job, job is aborting . Error msg :No default type conversion from type "raw[max=10]" to type "string In the both sources I have used SQL function to convert column in...

Hi, With reference to the post http://www.dsxchange.com/viewtopic.php?t=124401&highlight=checking+operator+defaulting+transfer+beforerec+outputrec we have same warning (in CDC stage), we have tried all the options mentioned in the post (like change capture on explict key and all values and also ...

same here :D

We are also facing same problem ..can anybody help us out!
Actually we are reading data from Sequential file stage(Mainframes) but it is not getting rejected....
Do we have to use CFF stage inorder to capture rejects..

Thanks,