DSXchange

Hi all,

Thanks for your suggestion.I have used remove duplicate stage and used retain last column it worked fine.

thanks! :D

Hi, For a parent multiple childs can be there,i need to concatenate all child records in one column in a row.I have used 3 stage variables. s1=s2,s2=i/p column,s3=if s1=s2 then s1:',':s3 else i/p column If i have 3 child records,i'm getting output as 1 row:1 , 2nd row:1,2 3rd row :1,2,3 But i need o...

Hi, I have to generate xml output from a data set.Column name is PARNT_ITEM_F and its value maybe either true or false.In the output it should be displayed as <gsa-template> <import-items> <add-item item-descriptor="ensemble-product" id="140150"> <set-property name="publishF...

hi , I have tried removing thet semicolon at the end even then it is showing the error: DB2_UDB_API_ITEM_PUBL_EVNT: When processing argument -inlinkpropsWhen processing input link property list: { TRANSSIZE=100, PARRARYSIZE=50, INPUTMODE='User-defined SQL', CREATETABLE='No', GENCREATEDDL='Yes', CREA...

hi, I'm using rogenerator and db2_udb_api stage.Rowgenerator generates dummy colmn and api stage for updation.Query used is UPDATE schema.ITEM_PUBL_EVNT SET STAT_C='2' WHERE STAT_C='U'; But the job is getting aborted.the log is DB2_UDB_API_ITEM_PUBL_EVNT: When processing argument -inlinkpropsWhen pr...

ArndW wrote:Stylesheets are an element of XML files and are not really part of the scope of DataStage. Whole books have been written about stylesheets and a Google search for "XML Stylesheet definition" returned ...

Hi

Thanks a lot

What is names space declaration?How it is useful in XML stage.

How to create required namespace declaration.

How can I create stylesheet ?What is the required information in creating this stylesheet.