DSXchange

Thanks all

Thanks for all the answers

But i have to do it in datatsage and
input rows are of varying length i.e all rows will have even number of columns but number of columns is not same in each row and it is a comma delimited file

Hi All,

i need to replace every even position comma (2, 4, 6...n) in the input row into a next line character.

Thanks in advance

You can define a runtime Schema file and pass it as parameter...

Field names should be unique to get all columns from Master and Update Link. If there are too many similar column names then the warning mentioned by you occurs for every row processed and job gets aborted when warning limit exceeds. One way is to switch off RCP in all output page of input to merge ...

Replace # with \n

Space at starting of a decimal specifies the "sign position" which is a default property. Space indicates a positive value.
To avoid the space you have to set the field width property.

[quote] [code]StringToDate(InputLink.ColumnName,"%yyyy-%mm-%dd") [/code] and you have set the Datatype in the output of the Transformer as Date for this Column? Since you say that most of the rows are nulls, are you handling nulls?[/quote] i thk it should be StringToDate(InputLink.ColumnNa...

ray,

I regret the inconvenience caused.

correction:

please read "u r" as you are and "ur" your

u can define a temp table and load statistics of each run into the table.
Query "temp" table for hw many runs u want....

Check the nullable property in input & output of transformer. if u r not doing any explicit tranformation of converting varachar to number(7,4) in transformer then, it does implicit conversion. if ur varchar column does not have proper number, it will put zero as default. try an explicit convers...

Since it taking more time, you can try the follwoing option.

do the upsert process in datastage and do all records insert into the table.

If you dont have cobol layouts, then how you are reading the source files.

sometimes it will be due to user permissions also.

Is your invisible characters seems to be link "squares"? if yes then ur pad character defined is null character. change into space and try trim function.