DSXchange

Yes My main issue is this i am planning to do transaction grouping using ODBC. ODBC stage does not captures some of the errors. Ok, just wanted to make sure you're using a supported version of Sybase. So... have you configured DataStage for Sybase? Meaning, have a Sybase client installed on the Data...

Sybase 12.5

chulett wrote:What version of Sybase?

I have a job which moves data for two tables

Source DB2

Target Sybase

If i run the job with Sybase OC stage it returns the following error

Sybase Server warning 515 (severity 16)

While similar job with ODBC Stage does not capture this error in the error log.

ODBC Settings Driver=/opt/dsadm/Ascential/DataStage/branded_odbc/lib/VMase19.so Description=DataDirect Sybase Wire Protocol ApplicationName= ApplicationUsingThreads=1 ArraySize=50 Charset= CursorCacheSize=1 Database=GDNADPWEB DefaultLongDataBuffLen=1024 EnableDescribeParam=0 EnableQuotedIdentifiers=...

Transaction Management using ODBC vs Sybase OpenClient I have job which transfer the data for two tables Source - DB2 Target - Sybase Scenario: First table insert 1 row without any error, Second Table have some data error while inserting in target If I use Sybase OC Stage with transaction size 0 for...

Thanks a lot

DSguru2B wrote:Try the following

Code: Select all

oconv(iconv(DSLink2.CODE_EFF_DATE, "D/MDY[2,2,4]"), "DYMD[4,2,2]":@VM:"MCN") 

I am trying the following, does not get desired output
oconv(iconv(DSLink2.CODE_EFF_DATE, "D/MDY[2,2,4]"), "DYMD[4,2,2]")


I need output as YYYYmmdd format.

Thanks in advance!

Hi All, We need to develop a job which will give us the information of the number of records loaded in the final table. The design will be something like this: Source table -----------Transformer------------------Target Table | | | File The information will be trapped in the file , such as table na...

chulett wrote:Talk to your DataStage admin. If it was installed, the stages would be showing up for you, so I'll wager it has not been.

DataStage admin is not sure how to check.

chulett wrote:Talk to your DataStage admin. If it was installed, the stages would be showing up for you, so I'll wager it has not been.

DataStage admin is not sure how to check.

chulett wrote:There's a Server component that needs to be installed as well, from what I recall.

How do i find if the webservices pack is installed on Server (Solaris)?

I have installed Webservices pack on the client for datastage. I am able to import the definition from webservices.

Problem:
I am not seeing the Web Services Transformer in my datastage client.

am i missing something?

Thanks in advance!!

Very interesting to know ereplace() exists in datastage Came up with another option that should do what you want: use eReplace() instead. It would look something like this: eReplace(<fieldname,linkname,etc>, "<String to replace>", "<replacement values>", [# of instances to replac...

I think you have to define this as part of initial XML design. Hi All, I have a requirement. My XML output stage should generated the output format mentioned below: - <xtd:Data> - <![CDATA[ 01|3|34|343|01|01|361227|3|1|2007120600|JUL 2007 |2007120626|WK 26 - 08/04/2007 01|3|34|343|01|01|361227|1|1|2...

The link row counts will work if called from the after-job subroutine. RESOLVED Source --> Transform1 --> Target | |__ Hash file --> transform2 --> report I have moved the function to get out row count to transform2 level and called DSGetLinkInfo (DSJ.ME, "Transform1 ", "link2",...