DSXchange

Hi,

where can i find the documentation for all the ds* commands like dsjob,dssearch,dsrecords etc. can i find all of them at one place in one single PDF documentation that comes with the tool?

TIA

Hi

when using the Teradata Multi Load stage how to parameterise the Table Name, User id and password instead of hardcoding those values?

i dont see any option as in DB2 enterprise stage to insert job parameters in teradata mload stage.

is there a way to do it?

Is the "First Line is Column Names" property set to True? This does need to be explicitly set - it does not import with the other format information, because it is a stage property whereas the other ... Thanks for the quick response ray.. I have set the "First Line Column Names"...

:!: For anyone wanting to help: To put this into perspective, please go through this exchange so you understand how the XML is being generated. I really don't think this is a bug but more likely a problem in the job design, specific to the need to use a Sequential File stage as your final output. T...

Craig, i checked the output. the output had around 2000 records and a few of them had this problem. i used the target type as varbinary with 8000 bytes length.thats more than enough for my data. i also dumped the same data to a flat file and compared. for 2 similar sets of data, one is having a prop...

i already opened a ticket with IBM..just wondering if this is a known issue..or am i doing anything wrong??

Hi i am using XMLOuptut stage to produce xml documents. Is there a bug with the stage? the problem is some of the xml elements are trucated/ill formed and truncated. here is what it looks like Correct : <BusPhoneGrp><BusPhoneNbr>7703214789</BusPhoneNbr><BusPhoneType>BUS</BusPhoneType><BusPhoneStatus...

Cool. :D ... Craig when i am trying to produce my file with real data...for some of the XMLs generated, the tags are lost or misspelt or truncated and ill formed...when i produced a data of 1800 records, i had 20 ill formed XMLs in them.. The same data looks perfectly ok in flat files. Other 1780 r...

chulett wrote:As noted - one field with a single forward slash as the XPath expression. ...

Thanks a lot craig. it worked.

I would disagree that "it doesn't work"... more correct to say you haven't gotten it working. Yet. I suggest setting up your sequential file with one large varchar field to hold the entire record, then just use a forward slash "/" as the XPath expression. That should get you muc...

You've completely lost me. :? If you are saying the current output is correct but it all needs to be in one sequential (non XML) file - have you tried an Output link from the XML Output stage to a Sequential File stage? Yes i did. When i have an output link from the xmloutput stage to a sequential ...

Select the 'Aggregate all rows' Output mode on the Transformation Settings tab. ... Craig that is not what i want..i know that aggregate option.but that is not what i want. if you observe the XML lines, each of them is a individual XML and there is no key value for any element so that group of elem...

Hi i have to do something like this. i need to create an Unformatted XML for each row in the database and have all of them in one big sequential file. I used XMLOutput stage to create one single XML per row. but the problem is XMLOutput stage creates one XML file on the file system per row. As we ca...

$APT_STRING_PADCHAR is a global level variable applicable for the whole project and all the jobs in it.

bcoz those are the only 2 elements that can have value, they need to be separately defined.i validated the xml and the schema in a xml editor.so they should be fine.i dont understand the problem with xmloutput. i tried for one element repeating under busnmgrp tag and it works properly.