DSXchange

Hi to all, I resolved the problem. The solution that I have implemented is the following: Oracle Connector -------> Peek Stage (oracle connector as input stage and Peek stage linked its output link). In the oracle connector "Properties page" i set "Read Mode" field to Select and ...

hi to all, please can any one tell me how to delete record from oracle table in datastage parallel? the only operation to be executed is delete record from table which date field value is greater than another date. In particular I must exec this SQL statement (on a oracle table) in datastage: DELETE...

Okay, as soon as I can try, I'll let you know. I'm waiting for account to access to datastage.

thanks.

Hi Ray

No, the write sheet does not exist it should be created "online" by the job.
Is it possible?

thanks.

Thanks Craig/Chulett

Indeed, I already searched for the "excel" key word in the forum and I found only topic that tells about how to read from excel files but not how to write in another sheet of same excel file.

I think that this task is not possible to do.

Hi to all, my requirement is this: I have an excel file (.xls) with multiple sheets (three sheets for precision: sheet1, sheet2 and sheet3) and I must read data from sheet1, sheet2 and sheet3 and write them in a new sheet, say, sheet4 of same excel file. How to realize this in datastage 8.1 server e...

Hi at all, I done a job interview on Datastage (not very technical but cognitive) to a company where probably i should work. During the interview they have asked me if I knew and I used in datastage the semaphores processes. My response has been no! I used datastage for short time and my knowledge i...

So, can it not possibile to install datastage server v7.5.2 on windows XP or any windows client operating system?

Hi at all I want to install datastage server v7.5.2 and I have one question in regards. The question is: what are the operating system supported. Have it to be a server operating system, e.g., windows 2000 server, or may be a client operating system, e.g., windows xp or later. On the IBM infocenter ...

But, why is orchestrate schema definition more metadata accuracy then import metadata definition?

Hi at all

Please, can any one say me how to get more accuracy of metadata in oracle database stage ?

By using import metadata table definition or orchestrate schema definition file?

regards.

hi,

the problem is resolved. In the output page of lookup stage properties i have unchecked the "Runtime Column propagation" option and the warning is disappeared.

Now, the question is: Why?

Hi at all I'm using a lookup stage in datastage 8.7, but i get a strange warning as the follow: Lookup: When checking operator: Dropping component "CUSTOMER_NUMBER" because of a prior component with the same name. Customer_Number is the lookup key and so it is present both reference link a...

This is the full/complete error message, but i not found any entry 'cl not found': Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 11:25:14(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6366 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserv...

Hi at all I installed datastage 8.7 version on windows server 2008 machine with visual studio compiler 2008 version. When i try to compile a simple job with a transformer stage between source file and destination file i get this error at compile time: ##E IIS-DSEE-TOSH-00384 10:43:26(009) <main_prog...