DSXchange

First of all ..yes..have read the previous posts on this... My question here is what should I do if I need to sort it on 3 key ,to get themy required records as the first record and then remove duplicate only on 2 keys and keep the first record... and don't get these warning.. Input xxxx yyyy 1 pppp...

I have the data coming in as below col1 col2 col3 col4 Jay x x kay x x output :Insert into DB2 table using ODBC jay col2 jay col4 kay col2 kay col3 Since we have only 8.1 version..I was thinking for having a transformer stage with 3 outputs each having a constrain on cols2,col3 col4 respectively. Si...

Sorry didn't realize it was part of datastage 8.5 version..we have 8.1 only..
hence closing the topic..

I have a requirement to insert multiple rows into a table based on the data of a single input row.. I read through the manual..and seem like its possible to do through looping in transformer stage http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.ds.parjob.de...

Sorry ..am new to datastage didn't quiet understand the answer can you please elaborate.. or probably I didn't put the question correctly. I have installed data-stage designer client on my machine, and the administration had defined the roles and granted access to my id. But whenever i try to login ...

Thanks for the reply...The problem here is the role setup is fine..Since am able to logon to the project from other machine...Its just the new machine which is giving this issue??

Hi, I have a newly installed datastage client on the fresh system Am getting a message "The current user doesn't have the required datastage role setup" . I have been using datastage client from another machine using the same userid and password.All seems to fine there... The new installat...