Search found 44 matches
- Thu Feb 10, 2011 4:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Validate timestamp with milliseconds in Transformer
- Replies: 4
- Views: 12869
How to Validate timestamp with milliseconds in Transformer
Hi, I am getting timestamp string (varchar(17) ) with milliseconds. Now using transformer i want to validate whether Timestamp is in correct format with correct value. I am doing this: If IsValid('TimeStamp', CL.crctn_dltn_ts) Then SetNull() Else "2010". But its not validating milliseconds...
- Wed Feb 02, 2011 3:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
- Wed Feb 02, 2011 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Append string using modifier
- Replies: 2
- Views: 1788
Append string using modifier
Hi, I have this input string "20101221101010457" ( varchar(17) ) and i want to insert "." after 14 character in this string using modifier stage. I want the output string as "20101221101010.457" ( including DOT ). I know how to do this using transformer but i dont want ...
- Wed Feb 02, 2011 1:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
- Tue Feb 01, 2011 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
- Tue Feb 01, 2011 1:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
- Tue Feb 01, 2011 1:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
- Tue Feb 01, 2011 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
I am getting the data in this format: 20101221101010437 So this with format %yyyy%mm%dd%hh%nn%ssn is not working. If i get the data in 20101221101010.437 ( millisecond with dot ) then %yyyy%mm%dd%hh%nn%ss.n is working fine. So i am getting string without dot (Timestamp string of 17 characters ) whic...
- Tue Feb 01, 2011 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp upto milliseconds
- Replies: 11
- Views: 12910
Timestamp upto milliseconds
Can timestamp be represented in milliseconds in Datastage and What is the format ?
Currently we are using this format for timestamp is: %yyyy%mm%dd%hh%nn%ss
Can i extend it further to check incooperate milliseconds also ?
Please reply ASAP.
Currently we are using this format for timestamp is: %yyyy%mm%dd%hh%nn%ss
Can i extend it further to check incooperate milliseconds also ?
Please reply ASAP.
- Tue Jan 25, 2011 12:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Hexadecimal String to Integer
- Replies: 1
- Views: 2165
Convert Hexadecimal String to Integer
Hi,
Can anybody please tell me how do i convert hexadecimal string to integer/bigint.
Is there any inbuilt function available for this conversion in Datastage?
Can anybody please tell me how do i convert hexadecimal string to integer/bigint.
Is there any inbuilt function available for this conversion in Datastage?
- Thu Sep 09, 2010 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compress Stage
- Replies: 1
- Views: 1799
Compress Stage
I am using compress stage to read data from sequential file , compress it and write it to data sets. seq. file ----->Compress Stage---------> dataset But i am getting this error "Program 'compress' was not found in PATH " I donot understand what do i need to include in my path variable ? P...
- Fri Jun 18, 2010 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MD5 CheckSum key generator
- Replies: 8
- Views: 14036
- Fri Jun 18, 2010 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MD5 CheckSum key generator
- Replies: 8
- Views: 14036
- Fri Jun 18, 2010 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MD5 CheckSum key generator
- Replies: 8
- Views: 14036
In our table we are having 30 columns and we need to compare all the 30 column of one record with another to determine duplicates and also we are doing almost the same thing to determine the parent child relationship. So it is very cumbersome to every time use all the 30 columns So we are generating...
- Fri Jun 18, 2010 8:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MD5 CheckSum key generator
- Replies: 8
- Views: 14036
MD5 CheckSum key generator
Hi , I want to use the inbuilt checkSum stage in DS8.1 to generate a unique key. I have couple of question regarding this. 1. It generates the checksum field in Alphanumeric form. Can it generate the checksum field in integer/Bigint ? 2. We are getting 5 billion records a day ( may be more in future...