DSXchange

Thanks Mr.bcarlson.
this helped me in resolving my issue..
HEX 0A is unix new line charecter!
I wouldn't have known it..Thanks ray.

Hi all, I have a job copying the same file to another file using two sequential file stages.I have a problem while importing this file which is a fixed width file 0f 150 charecters length and and has a HEX 0A at the end of each record. I am taking the record length as char(151). with properties fina...

ray.wurlod wrote:Search - this has been asked - and answered - more than once already. ...

Thanks Ray..

Hi my job and the partition used in each atage is shown below.. External Source(gives the file path)-->XML input(same)-->transformer(same)-->sequential file. external source specifies the path of the file name to the XML input stage. when I run the job it is giving me a warning message like tr_FRN_F...

I'm confused here.... to be safe and keeping it clean, especially with the behavior of nulls and repeating elements, one of your date fields ought to be the repeating element, unless you are only going to go as deep as Period in your retrieval (and then play games later with the entire Period eleme...

throbinson wrote:What is the XPath for the Period repetition key?

/ColumnL/Schedule/Period

throbinson wrote:What is the XPath for the Period repetition key?

ColumnL/Schedule/Period

Hi I Have an XML file in which a row looks something like this,Which is getting interpreted by XML input stage. <ColumnL> <Schedule> <Period> <Date1>2009.06.24</Date1> <Date2>2011.06.24</Date2> </Period> <Period> <Date1>2010.06.24</Date1> <Date2>2012.06.24</Date2> </Period> <Period> <Date1>2011.06.2...

A couple of things spring to mind. 1. Add the @INROWNUM value to each record as it passes through the transformer and then sort on this in the sequential file. I suspect you'll need to execute the stage sequentially though. 2. Is the data in the input file sorted in anyway. If so you could just re-...

ray.wurlod wrote:This is a ridiculous requirement. You are grouping data (in the Aggregator) so the rows can only come out of that group by group.

A Funnel stage with only one input is a waste of space. ...

actually there is another input to funnel stage which comes from an 'external command' stage :D

Hi my design is something like sequential file1-->transformer-->aggregator-->funnel--->sequential file2. My requirement is that the oreder of rows in sequential file1 should be same as that of sequential file2. the order is coming fine till the o/p of transformer.after that the order is getting lost...

ray.wurlod wrote:Assuming that the data type of the outbound column is string, and that you're doing this in a Transformer stage, then a suitable expression is

Code: Select all

"'" : InLink.TheColumn

...

Thanks ray.That helped me in solving my problem.

Hi,
I have a requirement to append a single quote(') to a column in datastage.
As quotes are used to enclose string values it is not letting me to print this charecter.
can any one help me with this?

example:
if the input is 123456
I want the output as '123456

If you want to have nullable columns then you need to handle this condition explicitly in Transformer stage expressions. If IsNull(DSLink5.name) Or IsNull(DSLink5.value) Then Se ...[/quote] found a better solution for my problem ray. we have an option to convert nulls to spaces in xml input stage. ...

Please strive for a professional standard of written English on DSXchange. This includes not using SMS-style abbreviations (DSXchange is not a mobile telephony device) and paying attention to spelling. This request is made to help those participants whose first language is not English. sorry about ...