DSXchange

try this

Convert('KolkataMumai','Calcutta','Kolkata') it works in parallel transformer too..

Hello, I am reading data from from sybase and the members have latin names but my target is NLS enabled American. I want to exclude the special character in the DS. Is there a way to exclude. I tried below function but no luck. StripWhiteSpace(Convert("^@?/#()\&.,'-"," ",Null...

Yes, Arnd i did checked the extended attributes and nothing is checked.

nope, the job is just a oracle enterprise stage, transformer and sequential stage..its a direct move and i didn't set any properties except the format tab with row delimiter string dos prompt.

Yes, it is a Varchar and weird part is, it is working for few fields and only missing for this comment field.

Hi All, i am creating a csv file with 10 fields and selected the field defaults Quote = double. But when i am generating the file, the quotes are missing in the out put for few fields. especially it is missing for one filed which is a 'COMMENT' field and the comment field has some ',' (comma) in the...

I am using the new 8.5 XML stage and not the XMLInput stage. In XMLInput stage we can hard code the header information but in new XML stage I dont see any such option.

Hello, Pls give me some ideas to handle this scenario: I'm trying to validate an XML file against XSD using 8.5 xml stage, but XSD location is not showing up in the xml file which fails the validation. If i include that XSD path in the XML file manually - its getting validated. Is there anywhere in ...

Hi All, I am using ODBC stage to load into oracle table. The datatype of one field is defined number and the datastage is reading it as decimal (38,10). when I run the job am getting following error. APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision va...

Hi,

I am new to Teradata and have a problem converting date into string.
actually date is stored as varchar in teradata ex: 07/24/1922 fromat
and i want to convert into '19220724'. Please help me...

thanks,
Venkat

hi.. when doing a lookup on a nullable field, I am getting the following error.. When binding output schema variable "outRec": When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result; a fatal runtime error could ...

Hi, I have import the dsx file and when i try to open the job, am getting the below error.

The version of this item 's design time information is incompatible with the current version of Datastage.

Please let me know how to open the jobs.

thnx