DSXchange

Hi, we are using DS MQ Connector stage to read xml messages from Websphere MQ. Then using XML i/p stage, the message is split into individual xml elements and then inserted into Target DB2 table. 'Message Read Mode' read mode property is set to 'Delete Under Transacton'. In case of Incorrect message...

Hi, I have a job to read xml messages from Queue(Msg Read Mode: Delete(Under Transaction)) and write it to a Tgt table. It has a MQ Connector stage which reads the messages and gives it to XML i/p stage for interpreting. XML i/p stage interprets(based on the XML table definition loaded) and breaks t...

Hi, When i submit column analysis in Information Analyzer, it shows "Executing" status for some time and then it fails with the status "Error Encountered". The error is: "SorcererServiceLogging.java:-3 executeBaseProfile: Exception in process: Fail to create session for user...

Hi, I want to design a DS job(parallel/server). I want it to behave as Web service. It should be able to receive the input from a web page(html) and should process that input and then should send the response back to the web page. Is this possible in Datastage V8 ? Are there any inbuilt stages that ...

Hi, I have created 3 environment variables to hold the values of ServerName, UserID and Password respectively. Then i define a parameter set 'Param_Set_A' by adding these 3 environment variables. Now i want to attach 'Param_Set_A' to a DB2API Connection (call it 'DB2API_Conn_X'), but when i try to d...

Even after closing all the jobs which are using that DB connection, the problem persists. Only when the session is closed, the other user is able to load that DB Connection in his job.

Hi, I have created a DB2API connection(Let's call it 'Sample_Db_Connection') and want it to be used by more than one users in their jobs for re-usability. User1 logs in first, and loads 'Sample_Db_Connection' in DB2API stage in his Job A. Then User2 logs in, wants to load 'Sample_Db_Connection' in D...

Hi,
When we have only Dimesion source data,
Can we update only dimensional table without updating the fact table using Slowly Changing Dimension Stage?
Or is it mandatory to load fact table too?

Hi, I have built two identical jobs consisting of MQ stage, one is Server job and other one is Parallel. The job consists of, MQ stage which reads xml msgs from Q for infinite period(Wait time=-1). Then these are inputted to XML i/p stage where it breaks down the XML into data elements and inserts t...

Hi, If i turn off the waves, records are not getting inserted into table. As suggested by Ernie, i tried other filter property 'Priority'. In this case also i am getting the same error. Another clarification: Error comes only when i put new msg (which satisfies Filter condition) on to Q when job is ...

Hi ArndW,
I am not changing filter condition in MQ Connector stage interactively. Application ID Data=1 is set before compiling.
I have set 'End Of Wave'=Before and 'End Of Data'=Yes

No other messages appearing.. A window pops up showing the above error and only tab options are 'Abort' or 'Skip'.

Hi,

When exporting a DS project, the following error occurs:
"Failed to attach to job 'ROOT'.The job 'ROOT' cannot be found in the repository."

Plz suggest the solution.

Thank You.

Hi, I am using MQ connector stage as source.I am reading the messages(Msg Read Mode=Delete, so that only the read msgs are deleted from the Q) selectively based on the Filter property 'Application ID Data'(i.e when Application ID Data=1).Wait Time is set to -1, so that MQ connectr keeps on reading m...

Now that error is not coming while running. Unable to found what was the cause. But still View Data doesn't work.
Thnx.