then also I get data in exponantial formatDouble in, VarChar out, no conversion function. What happens then?
Search found 55 matches
- Thu Dec 23, 2010 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Double to varchar conversion
- Replies: 5
- Views: 4624
- Thu Dec 23, 2010 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Double to varchar conversion
- Replies: 5
- Views: 4624
- Thu Dec 23, 2010 2:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Double to varchar conversion
- Replies: 5
- Views: 4624
Double to varchar conversion
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...
- Tue Dec 21, 2010 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings on data type int (int32 to uint32)
- Replies: 3
- Views: 5048
- Tue Dec 21, 2010 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings on data type int (int32 to uint32)
- Replies: 3
- Views: 5048
Warnings on data type int (int32 to uint32)
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...
- Mon Dec 20, 2010 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: setNull() output in Char(1) data type
- Replies: 5
- Views: 4379
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 ...
- Mon Dec 20, 2010 12:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: setNull() output in Char(1) data type
- Replies: 5
- Views: 4379
- Mon Dec 20, 2010 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: setNull() output in Char(1) data type
- Replies: 5
- Views: 4379
setNull() output in Char(1) data type
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_...
- Mon Aug 02, 2010 7:00 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Need help to implement recursion in WTX
- Replies: 2
- Views: 19606
Need help to implement recursion in WTX
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...
- Tue Jan 13, 2009 7:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scheduling a job for executing continuously
- Replies: 4
- Views: 2956
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...
- Tue Jan 13, 2009 4:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scheduling a job for executing continuously
- Replies: 4
- Views: 2956
Scheduling a job for executing continuously
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...
- Sat Nov 08, 2008 4:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Multiple date formats in to one
- Replies: 1
- Views: 2043
Convert Multiple date formats in to one
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..
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..
- Tue May 27, 2008 9:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Parellel transformer using Env Variable
- Replies: 1
- Views: 2060
Error in Parellel transformer using Env Variable
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- *********************************************...
- Mon May 12, 2008 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem in XML ouput to MQ connector
- Replies: 0
- Views: 2460
Problem in XML ouput to MQ connector
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...
- Tue Feb 26, 2008 6:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal:Shared library(xmli.so) even after installing patch
- Replies: 0
- Views: 1180
Fatal:Shared library(xmli.so) even after installing patch
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...