DSXchange

Double in, VarChar out, no conversion function. What happens then?

then also I get data in exponantial format

When I write Double to Double it gives data in exponantial format.

Hello Folks, I am trying read a double value from MS SQL server table and to write it in a CSV file on UNIX. For converting that double value I have used DFloatToStringNoExp() function. I have defined the scale to maximum of the values in that attribute. I am getting some extra digits (not always sa...

Thanks Ray for responce.

I have checked schema there are not UNSIGNED integers also there are no UNICODE characters. Still I am getting 43 warnings

Hello, I am having some attributes with INT(10) data type on which I am recieving warnings like below - Lookup_XXX,0: When binding input interface field "abcd" to field "abcd": Implicit conversion from source type "int32" to result type "uint32": Possible rang...

Hi All, Something which is unclear to me.. bit strange .. If (len(trim(monitoring_flag)) = 0 or Seq(monitoring_flag) = 0) Then SetNull() else monitoring_flag this works fine .. gives NULL in output but when I check If IsNull(monitoring_flag) Then SetNull() else monitoring_flag it gives spce in that ...

Sorry the logic in transformer is as below -

If ( monitoring_flag <> 'Y' and monitoring_flag <> 'N')
Then SetNull()
else monitoring_flag

Hello All, I am working on IIS 8.1 and source & target database is MS SQL server. I have one flag in target table with data type char(1). I want to set value NULL when it is not Y or N. I am achieving using - If ( monitoring_flag != 'Y' and monitoring_flag != 'N') Then SetNull() Else monitoring_...

Hello, I am new to WTX, need help in implementing a simple recursive logic. Input 1 is a plain text and input 2 is an integer number which is fixed length. Requirement is to get an output file with lines of fixed length given in input2. e.g. Input 1 = abcdefgh Input2= 3 Output- abc def gh I am think...

Hi keshav, I dont have Control-M for scheduling. And I am avoiding use of UNIX scripting for keeping maintanance easier of my jobs. Sainath, I have tested that job gets finished in 10-13 mins everytime still I am keeping a buffer of 15-17 mins more. I am looking in sequencer for this sleep time opti...

Hi, We have source feed as XML Messages, so the data feed is continuous. So our requirement is to have that extraction job continuously running for lets say 8 hours, in result it will extract and load data in Staging area continuously. I am aware of two work around - 1. To schedule the job e.g. afte...

Hi folks,
I am getting data for a date field in different formats like - DD-MM-YY,
DD-MON-YY, MM-DD-YYYY etc as the date field is varchar in source system. Now I need to format the dates in structure and load.

please suggest if you have any idea..

Hi Guru's, I am doing a simple job- Seq File -> Transformer -> Seq File In the trnsformer I am using an environment variable (directly assigning the value to a column). No other transformations are there, simple one to one mapping. I am getting an error- *********************************************...

Hi All, I am trying to create XML files from CSV file and put the XML files in Message Queue. One row of CSV file will become one XML file in output. Following is the job design - Seq File -> Transformer -> XML output -> MQ Connector In XML output stage I kept column details are 'Message',LongVarcha...

Hi, I have Information Server 8.0.1 installed on AIX 5.0 also the fixpack 1a and patch (patch_128727_aix.ispkg) is applied on the server. I have installed same fixpack and patch on my client which is on Windows XP (first fixpack then patch). Now I have a parallel job with sequential file stage -> XM...