DSXchange

When I'm using dataset I can see the two rows properly in the dataset when am doing view data. But same is showing one record when using sequential file stage. Now as per your suggestion I will place a peek and will see the recs in the log ,how it's coming

Yes, your understanding is absolutely fine, but have used the new xml stage which was introduced in 8.5.

The deadlock can be happen when a particular record is trying to be getting updated from multiple sessions,which may be the case here as you running the update in parallel.Please check one thing that whether there are any such records which are duplicates on the basis of update key.

I have a job like the following. 1. Extracting data form a xml file using a sequential file staging where the whole xml data is being read into a single column. 2. Parsing the xml by using new xml stage in datastage 8.5(the DS version where I developed the job). 3. Write the parsing records into one...

Are you using any kind of partition in the source data just before entering to lookup or keep it as auto?

I have a simple job where I'm inserting records into one target DB2 table using DB2 connector and write mode as Insert. Now when I'm attaching one reject link to the DB2 connector with ERRORCODE and ERRORTEXT enabled but not able to see it in the column in some of the system where DataStage client i...

Thanks to all for the support. The qm.ini file finally has been changed and entered a new database details and restarted the mq server and it worked perfectly. In my config file I have more than one databases situated in the different server.The DTS stage works perfectly for any one of the database....

Thanks a lot Andy for your response.

You are right the title is most appropriate now.

Surely I will post it in MQ related forum.Just thought that as it is related to datastage job running consisting DTS that's why posted over here.

I am trying to use DTS stage by configuring qm.ini file In queue manager config file I have one DB2 database has already added as resource. Now if I want to add a separate DB2 database in different server(which is already cataloged in the DS server ) then do I need to create a new switch load librar...

Now it's clear,am marking it as resolved.

Thanks a lot Ray for your valuable response.
One small thing can both the command be triggered from windows command prompt?

I have datastage server installed in the UNIX operating system. I want to export a certain parallel job from the project. I can do this by using command also. Now in this regard there are two commands 1. dsexport 2. dscmdexport Now actually what is the difference between these two command? Is it lik...

I have a simple job design as the following. Row generator ----> Column Generator ----> Dataset In the row generator I'm generating 10 rows. Then in the Column generator I'm generating one column(say Integer) and increment it by 1. The intial value in the column generator is being parameterized. It'...

I have a simple job like the following: Sequential file ----> Copy-----> DB2 connector. I'm loading the data from source file into one DB2 table. Now I'm running the DB2 connector in parallel mode.Now the following questions. 1. What is the difference in DB2 and DB2 connector type in the partition m...

Thanks a lot for your valuable response. I am marking it as resolved.