DSXchange

I think that I solved. It was a problem of not good data.

Thanks.

There are char, varchar, decimal and timestamp fields in source.

My doubt is: when my job loads this table, nothing happens. In reading it, just as select * from table, I have this problem.

Hello,

I have an issue with a server job always working until now.

I have warning IDENT1: OCI has fetched truncated data.

I made a job with Oracle stage and Sequential File. Oracle table definition in reading is the same of Sequential file.

May someone help me?

Thanks in advance.

Copy the table to a dataset or to a table you create in a database you have got access to. Use Runtime Column Propagation (needs to be enabled for the project in Administrator and on the Output-page of the DB-Stage). Specify 'select * from tablename' as custom-SQL and leave the Schema-definition (C...

Hello, I have a problem with a table definition. I know only some columns of a table, I don't know if there are other columns besides the one I know. I can't get access to the database, because nobody knows the password, even if there is password on Administrator (but it is encrypted). If I want to ...

So if I develop a new job using Datastage 7.5.3 or I modify a old one i shouldn't have problems, right?

arvind_ds wrote:You are mentioning about DS client versions or what? Explain in detail.

My client is Datastage 7.5.3. Everybody here has client Datastage 7.5.2, so I suppose that it is the same for server.

Hello,

I have Datastage 7.5.3, my costumer uses Datastage 7.5.2. Are there any problems if I use my version of Datastage? If yes, which kind of problems?

Thanks in advance.

Ravi.K wrote:Try with "First Line is Column Name" Option at Format tab of Target Sequential file.

It works, thanks

Hello, I need to write a sequential file. This file has to show column names and rows. In rows I have different datatypes (date, varchar, decimal). I immagine that column names have to be varchar, for example: Date Name Age 21.02.2011 Tom 25 Some people suggested to make 2 jobs. First job will creat...

Hello,

sorry for the question which could be stupid for someone, but how can I convert a Numeric (length 6, scale 3) to a Decimal (length 3, scale 3)?

Thanks in advance.

Hello everyone, we have developed some jobs using as target some Oracle tables. We imported them using Import-->Table Definition-->ODBC Table Definition, because these tables were not processed by ERwin. The icon of table definition is now with red cross, as not synchronized. Now that these tables h...

I think that I resolved the problem: in ODBC connector stage, I set "read committed" where I see "Session" and "Isolation Level". The source table had to read more than 10 millions of records, maybe for some reason it couldn't manage all them and it needed a commit. Any...

I will try...anyway this ODBC connector is the source of my job.

I'm connecting to DB2 and it has straight generated SQL.