DSXchange

If the Field Width is, for example, 10, then supply 10 space characters. " " ... thanks u ray for your quick response once again. yes ray what u said is fine but the requirement is not to have spaces in the field it should take '' i.e, null. its taking simply by using the property null va...

ray.wurlod wrote:Use the right number of blanks. ...

well using right number of blanks?? how do we specify 'no of blanks'. I am sorry i did not get u

hello friends, i have a simple issue but is not getting resolved. i have some not null fields coming from OES and being written to a SFS using a Tfm. i have both varchar fields and date and decimal fields. I am able to take care of the warnings for varchar fields by putting Null value='' but this do...

hello everyone, i have a decimal field and i need to make sure that it does not contain any spaces anywhere. i tried to directly use trim function on this field but as i know its giving compiling problems.so in the transformer i have taken a stage variable sv=col1 and this sv is of course varchar an...

hello, first of all i think using trim function on a varchar filed and taking it as char in the target will not work because the spaces will not be trimmed as u store it in char.u can do one thing use trim function and populate it into varchar data type only.it does not matter whether the target tab...

i have the data coming form flat files. i have date columns as char(8).for example:20080115. this is not a problem wherein i can convert it into date data type in the transfomer. I also have dates coming from some other column in the source as char(6) eg:PQ0115. There is business logic for this like...

i have the sample coming as follows: "abc", "this is ""pick it up"" and check", "def" now i want the output in viewdata as follows abc, this is "pick it up" def instead this is getting rejected when reading with SFS. what delimiter string i...

i am trying to read a flatfile which is comma delimiter and double quoted. i have used the following format in SFS to read it. first line column name-true final delimiter-end record delimiter-unix newline field delimiter-comma quote-double i am working on DS 7.5.2 connected to unix server and my loc...