DSXchange

Hi All, We are trying to decide if its necessary to migrate from Datastage version 7.5.2 to Version 8.1. Our current set of job designs use the following components: 1. Websphere MQ Stage 2. XML Stage 3. Hash File Stage 4. Sequential File Stage 5. Aggregator Stage 6. Transformer Stage 7. DB2 /UDB st...

Hi All, We are using DB2 UDB version 9 and plan to perform the following upgrades: DB2 Connect V9.5 64 bits AIX Datastage from V7.5.2 (32 bit) to V8.1 (64bit) Will there be any conflict if Datastage is not upgraded ? Are there any known issues encountered during the upgrade process for systems using...

Hi All,

We are upgrading from version 7.5.2 to version 8.1. I would like to check if it would be necessary to test all jobs using datastage or to perform a selective testing. What is the best practice on testing due to version upgrades ?

Hi, Suppose a datastage job has been changed from its previous version and no description of the change is noted, is there a way I could spot the changes to a datastage job ? For e.g using CVS I can tell if a change has been made or not. But to find out specifically what changes have been made...is ...

Hi,

I have a job that deletes rows in the target based 'delete existing rows' option in a DB2 stage.

To avoid getting a transaction log error do i need to issue a commit ? or does it automatically commit when I use the 'Cursor Stability' Option ?

Thanks.

I have a source sequential file with three fields and a target table with no primary key/s. I need to delete those records where there is match in the table for those three fields. I used a custom SQL as follows delete from tbl_sample where A=? and B = ? and C = ? ; but this does not seem to work......

I re-installed my client after installing the latest .net Framework and that solved my issue.

Thanks

Thanks Ernie......

Hello all I have the XML Pack 1.0 and when I was installing it to my local pc...the XML Input Stage,XML Output Stage and the XML Transformer look like plug points instead of what it should look like....

Does it come under a different pack ?

Hello Ernie, Appreciate your assistance. The Description Section is as follows : Column 1 : /PR/PR_HEADER/PR_NO/text() Column 2 : /PR/PR_HEADER/PR_REQ_NO/text() Column 3 : /PR/PR_HEADER/PR_APPR_DTTM/text() Column 4 : /PR The <ITEM_DESC> </ITEM_DESC> is actually inside the 4th column along with other...

Hi, Currently my job is designed as follows: An MQ Stage - > XML Input Stage -> Transformer -> Sequential File. As I mentioned previously in the XML file that is read by the MQ stage the following representation <ITEM_DESC> </ITEM_DESC> becomes <ITEM_DESC/> in the sequential file. As I understand fr...

Thanks for the Response. I am not able to choose which way to generate the output(ie open/close tag or single tag)..Is this because I am using an XML Input Stage and not the XML Output stage? The reason for my questions are because when the XML Tag is single and when I convert the XML file to a deli...

Any idea where I can find some documentation on the XML Input and Output stages ? Need to know when to use which stage. Currently I have a job that has an MQ stage and then the output going to an XML Input stage and from there to a Sequential File. Is it possible to do the same with the output stage...

But it's not an empty element since it has a space in between <ITEM_DESC> </ITEM_DESC> So does that mean Datastage still refers to it as an empty string ? Also I tried changing the options in the property file and not able to switch to the open/close tag. Any other alternative ? Thanks for your resp...

I have an input from a MQ Stage going in to an XML Output Stage and then to a Sequential File.

The XML File has a field <ITEM_DESC> </ITEM_DESC>

After execution in the Sequential file this field is represented as <ITEM_DESC/>

is this representation correct ?