DSXchange

try running the same query in Toad (Outside Datastage) and see if you are getting the same value or not for below example you mentioned: The source value in DB is 0.45 the value coming out is 0.00 Also, try defining the column as decimal(31,7) and see if the warning still appears in Datastage Job?.

Thanks to chulett as it's already known issue

User is using Datastage 11 on Unix and ODBC connector stage on Unix did not have the option of User Defined Sql.

Job Type: Parallel
OS: Unix

Note:Not sure how to attach image. so could not attach the screen snapshot

try creating the File with Record Level Delimiter as : DOS Format and try sending as email attachment. (Format Tab: Record Level Right Click and Format as Dos line terminator)

chulett wrote:Answer is still the same, only a single DML statement is supported.

yes. After sql can support multiple statements

looks like the file is created in Unix and when run unix2dos and then attach, file is coming properly. Try doing unix2dos and test it.

Please check similar post below

viewtopic.php?p=418450

Yes, I tried too and could able to find the first occurrence using the INDEX Function but the issue is to find the last occurrence (May be you need to write a custom subroutine to get the last occurrence of 1 passing the string like: (!@##$$1111^&&&&&&&&&&1111...

Yes. Teradata connector write mode allows for User Defined but not the odbc connector (Only Insert/Update/Delete)

Are you Casting while Extracting from Table As suggested below ?.

you can cast it in the extract sql to match the target format

Please clarify

Please check below link and try one of the 3 suggested options https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.drs.usage.doc/topics/DRS061.html There are generally three approaches for eliminating the schema reconciliation messages: 1.Modify column definitions on ...

Thanks for Clarifying the requirement. I was trying to Convert all Alphabets to some Value and and after that find the First Occurrence of that But looks like the CONVERT Function is not working as Expected Input String: !@##$$Rami^&Reddy*&^%$' Derivation: convert(CHAR(82):CHAR(97):CHAR(101)...

Is your Delimiter: ^& Please clarify. e.g.: Input Data like: !@##$$Rami^&Reddy*&^%$ Output Data Should: Rami^&Reddy Tried with Convert as below Convert(char(10):char(11):char(35):char(36):char(33):char(64):char(37):char(42):,' ','!@##$$Rami^&Reddy*&^%$') !@##$$Rami^&Reddy...

Check the data type in the database table.
Check the data type in your job's metadata.

If you're using a Connector stage, change the "Fail on type mismatch" property from Yes to No.

Note: Assuming that your Input date all have >2000 (20th Century)
Otherwise, please request them to provide with Century part also if you are expecting dates before 2000

Please refer below link

viewtopic.php?p=388928

I guess you can use StringToDate(Trim(DSLink2.File_Date),'%dd-%mmm-%2000yy')