DSXchange

HI Team, Requirement: Need to import table definitions of multiple tables and then convert the table definitions into xml. Existing way which we are doing: we are using the Import>>>Table Definitions>>ODBC to import the table definitions. Then we are exporting the same table definition and saving it...

Try the same process but instead of the taking a standard dsx may be try with the XML option. I ll try and replicate the this here. WIll let you know what I find POST - edit So I did this experiment at my end. Simple job. Took the dsx , changed the job took the dsx (added an environment variable an...

I have added the double quotes..they are not part of the dsx.

Original DSX: BEGIN HEADER CharacterSet "CP1252" ExportingTool "IBM InfoSphere DataStage Export" ToolVersion "8" ServerName "DSENGINE.DIF.HEW.US.ML.COM" ToolInstanceID "MIDAS" MDISVersion "1.0" Date "2015-03-16" Time "21.30.0...

I have done as suggested by you. first i have a created a sample job without any parameters and then take the dsx. Then created a job with the parameters added and then taken the dsx. compared the dsx. then took the dsx of the job without the parameters in it and then added the values as present in ...

The reason for doing this , we have some 2500 odd jobs for which we need to add APT_Variables and change the annotation. So thought if i can write a script and add the environmental variables and change the annotations a lot of manual effort would be reduced. Requirement is we need add APT_GRID vari...

Team, I have a requirement of addding three new parameters and annotations to a job. I have taken the dsx of the job to my local machine. I modified the annoation and saved the dsx and imported the DSX back. the change got reflected in the job. Likewise i added three parameters under the cparameters...

Team, we are using a SoundexName function in datastage 7.5 server on windows. for a given string it is generating a value. what is the equivalent of the SoundexName in datastage parallel 8.7? Tried with Soundex function which is giving a another value for the same string in 8.7 Parallel. Please let ...

Hi, In datastage 7.5 version installed on windows there are special characters or may be they are unicode representations whiich are like "..:" "-" "-->". In 7.5 server jobs the above characters are replaced using rreplace function of char(9) char(10).Char(13) char(26)....

Hi I am sorry, I have multiple XML file in a directory for every day. I just tried a design ESS stage--> XML stage in ESS stage --> program Files. #FileName# as ls /dirmain/lan/ls *.xml but iam not able to view data in ESS I am geeting a error like Could not open source list file " ls /dirmain/...

Hi , Can yoy please guide me how to merge multiple XML's into one target XML with new XML stage. Source files. File_1.xml <?xml version="1.0" encoding="UTF-8"?> <CollateralSchema:ObjectData xmlns:CollateralSchema="http://www.AAA.com/AAASchema.xsd"> <CollateralSchema:Req...

we are migrating from v 8.1 to v 8.7. we need to add the grid parameters to the jobs after they are migrated to v8.7. to add the parameters to each of the job trying to export the project into a dsx file and then add the three parameters in that dsx file. please let me know if we can export the proj...

how do we the compile dates of server jobs present in datastage 7.5.2 on windows

Hi Partha, As per my knowledge your XSD element TrxnRec should contain below statement. <xs:element name="TrxnRec" maxOccurs="unbounded" minOccurs="0"> after adding that I am able to map Trxn array element from left hand to right in output mapping window . (I have not t...

Hi ,

Please let us know what are steps/ properties you used in XML stage