DSXchange

I have a job which takes MQ Connector as source and Distributed Transaction stage as target stage with (MQ Connector option). I am using datastage 8.7 version I am getting the following error message when I try to run the job Distributed_Transaction_29: System call dlopen() failed with OS error 2 (N...

Does Distributed transaction stage as target stage connecting to MQ Connector solves the problem of delete under transaction once it commits at target queue

MQ Connector stage ----> Distributed transaction with the option mq connector

Hi ray, Scenario 1:I tried keeping the delete(under transaction) which is a default option and try to abort the job to see how the source is impacted and the result is I see source message queue got deleted Scenario 2:I tried putting the Keep option as read mode and loaded into target MQ .I have ano...

Hi,

I have requirement to Read messages from source MQ message queue and copy to target MQ message queue.
I have to delete the same source MQ messages after it got committed to the target queue.

May I know the possible ways to fulfill this requirement

Hi All,

When I try to open the Transformer stage in the Server Job.I am getting the Error Messege "Run-time error '440' Automation error" and the Designer client is getting hang

Can you please let me know what needs to be done

How to find the number of datastage jobs in a project and the size it occupied . Is this related with DS_JOBOBJECTS.It contians the 2 parts OVER.30 & DATA.30 under the PROJECT File system DATA.30 is the occupied size and the OVER.30 is available size. SELECT COUNT(*) FROM DS_JOBS from administra...

How can I see in Hex Editor.
I installed the hex Editor Software ,but it is not pointing to the right place

chulett wrote:Use a hex editor and let us know what these "square values" actually are. ...

Hi , I am getting the Source data in Text file which i am using the sequential file stage for extraction. Some of the record's i am getting as square values 00000000 ,but not the zeros which i typed. When I load into the Oracle table ,its showing nothing in that record. Please let me know if any of ...

I am unable to understand. My question is why i am getting this error in my machine,as it worked in other machine Is there any wrong with my machine(changing any parameter in control panel) to get rid of * error Arnd is talking about columns - why are you talking about lines? His point is that you m...

The start point is from line 1

Sainath.Srinivasan wrote:What is the start position you provided? It must be 8.

Surprising that it left the top 5 lines. Did you give the header lines?

Line number 12.
if i delete manually ,it pointed to next line *.

It is working in my friend machine

Hi All, I am facing an error when i try to import the table definition using sequential stage which contains the CFD(Cobol) File layout I used sequential stage because the data is Ascii format Error message is ' *' Unrecognized syntax It is working in my friends machine.Do i need to change any forma...

Hi all,

Currently We are using Oracle 10g database in Datastage 7.5.2.
Now we are planning to move oracle 10g to oracle 11i in Datastage 7.5.2.

My question is oracle 11i supports in Datastage 7.5.2

Thanks

Hi All,

I have a varchar column,where i need to check for the Existence of
Special Character.
If it exists I need to Ignore that value.

Thanks .

Hi all,

I have Experience in Datastage ETL ,DB2,Oracle .

Now I want to learn DataStage TX Which is mapping tool from ibm(formerly mercator)

Will it be useful for me.