DSXchange

Hi all I have a problem while reading with delimiters... in the sequential stage the record is as below QuoteChar "\"" In this case i have the delimiter as " so first column value is QuoteChar second column value is \ third column value is null but i want to have second column va...

thanks ... i was to do with that idea

yes datastage reserved words ..
The scenario is as follows ..
i have to compare an input column in the transformer and check whether that column starts with the "begin" or "end" and then i have to do some more operations....

Hi all,
Are there any datastage functions like begins with or ends with ...
I just want to check in the transformer that whether a certain coulmn begins with a particular word...

chulett, the nature of changes that i want to make is that.. suppose i have seqential stage in the job that has been exported as an xml file... I may require to change the column names or length of the columns, its precision, or I may change the delimiter to a different value... all such kinds of th...

Hi all,
In the output sequential stage is there any method to remove the delimiters for certain rows....

the ultimate goal is .. first think that i have developed a job with certain stages ,compiled and run ... Now i export this in an xml format.... With this xml file i should be able to capture all the properties of job including stage column names ,its length, precision etc... with the xml meta data ...

Hi I have exported a job design in xml format... the format of xml output is as follows /********************************************* <?xml version="1.0" encoding="UTF-8" ?> - <DSExport> <Header CharacterSet="CP1252" ExportingTool="Ascential DataStage Export"...

Hi.. I have developed a job with two sequential stage and exported the job as xml file.. Ihave used the this xml file as an input in the xml input stage... Here in this we have to specify a repition element on which the output xml wil be generated.... here i have a doubt on what basis you select the...

okay... i will do small xml files.... but i was getting the following error when i was generating the xml outfile Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------...

thanks.. i was able to process the xml file...
But one thing in that it is taking a lot of time to run the job containing


folder stage------>xmlinput------>transformer---->xmloutputstage

Are there methods to increase the performance...??

Hi... I want to export a job in an XML format . And then i want to get each and every property of the job (including meta data information) used in the job in XML inputstage.. After that i want to send it to XML output stage with some modifications. in the transformer stage. when i import the change...

while inserting the records getting warnings like inserted value too large for a coumn..... How should we solve this problem