DSXchange

Hi, i have one text column in one file. I am trying to read that column by varchar or long varchar. Now the problem is the data which are coming are so big, DS is not able to read full data. Data which exceeds the maximum length got truncated. Do we have any data type which can raed more character t...

Hi, When I hardcoded the name of primary key columns(comma separated) and updated colunms(comma separated) in netezza connector stage, then its working fine. But when I passed the same columns on runtime as parameter(mentioning two parameter name for primary key cols and update cols in NZ connector ...

the translate function replaces a sequence of characters in a string with another set of characters. Right? I want to do that in modify stage. If I use transformer, then I can think of use Convert function.But as its not available in Modify stage so I want another function which can do the same thing.

Could someone please suggest the equivalent function of Translate function,which I can use on modifyspec of modify stage?
Please suggest function with its full syntax.
Thanks in advance.

Hi, I got junk characters(like small small boxes) in one field. I am using modify stage and in this stage I handled null for that field. Ex - AMEX_REV_CMNT_TX:string[max=100] = handle_null(AMEX_REV_CMNT_TX,"") where AMEX_REV_CMNT_TX is the field name. But still the issue is not resolved. I...

Now I am using this :

AD_LINE_1_TX:string[max=40]=string_trim["\n"](AD_LINE_1_TX)

and its working fine..

Thanks
:D

Sorry for my late reply. Now I am using this : AD_LINE_1_TX:string[max=40]=string_trim(AD_LINE_1_TX,"\n"); where AD_LINE_1_TX is th column name. But it gives an error. main_program: Error parsing modify adapter: Error in binding: Expected ')', got: "," Expected destination field ...

Actually I am using a multiinstance job. I have done all the transformation in modifyspec of modify stage.I cant use convert function in transformer as I pass everything at runtime.So I have to do it in modify stage only.
Please suggest.

Hi, I am using modify stage in a multiinstance job.Now in one field of the input file I get a new line character. For example - suppose the field name is 'ADDRESS1' and the data is populating like 'SOUDI ARAB'. Now in between SOUDI and ARAB there is a new line character(not space).For that we are no...

The problem has been solved. In that microsecond part instead of giving .%SSSSSS, i gave .%6. Means now I have given like this :

StringToTimestamp(lnk_CONV.TS4,"%yyyy-%mm-%dd-%hh.%nn.%ss.%6")

and the job succesfully ran.I didnot know about this format of timestamp.

Actually we are getting with that format only from source file and as its a multi instance job, I cant see the possibility to change the format in stagevar also.
What 2 do now.

Hi, In transformer stage i use String to Timestamp function like this : StringToTimestamp(lnk_CONV.TS4,"%yyyy-%mm-%dd-%hh.%nn.%ss.%SSSSSS") the data is coming to transformer either with this format or with 'space'. Data in TS4 is proper.We are handling the 'space' also. Though this transfo...

Hi,
Is it ok if you can get your desired output using only a transformer??
Please let me know.