DSXchange

Please find the more detail. Now i have tried for the date "20130102 16:40:40.84282" as StringToTimestamp(Field(in.Timestamp,'-',1),"%yyyy%mm%dd %hh:%nn:%ss.6") Now the error message is Transformer_18,1: Data string '"20130102 16:40:40.84282' does not match format '%yyyy%mm%...

Hi Experts,

I am having a string value as "20130305 07:41:45.798181", need to convert into timestamp.

I have used

StringToTimestamp(<Column Name > , yyyy%mm%dd %hh:%nn:%s:%SSSSSS,v")
.But throwing error. Kindly help me to fix this.

Thanks In advance.
Ramesh

Hi Experts, I am having an input data as follows col1 1,2,3,4,5,6,7,8.... col2 qa,ee,rrrr,fff,wds,r,fff,..... while i tried to read this data with sequential stage its throwing error as "consume more than 10000 bytes looking for record delimiter, aborting" Could you please suggest me which...

Hi Friend,

Its working fine , i used the below format to achive this

StringToTimestamp(Column1,"%mmm %(d,s) %yyyy %(H,s):%n:%s:%SSS%(aa,w)")

, thank you so much, i never forget this great help

Hi Please find the error below, while i tried to use your approach -------------------------------------------------------------------------------- XFR_In_Trans_1,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%mmm %d %yyyy %H:%n%s:%(SSS,v)%aa" for conversion &q...

I will try it and let you know.

Hi,

I have a string value as "Jan 22 2010 2:12:44:201PM", i want to convert this string value to timestamp like 2010-01-22 14:12:44:201, is there any short way to handle this ? mean minimum using of stage variable.

Thanks

Hi , i am very interest with datastage 8.5 .0 version, . Is it possible for us to download for home use (i.e., trial / crippled / education version)?

In XL Sheet 12000000.000000000000 * 0.934448160535 = 11213377.926421400000 In Data stage 12000000.000000000000 * 0.934448160535 = 0011213377.926420000000 See there is round off after 4 digits from the decimal point the derivation i used is [remaning_multiplier* factor_schedule] i used this derivatio...

Hi Friends,
This thing is happening when the column undergone on multiplication, please help As Soon As Possible.

Hi All, I have a column as decimal with length 22 and precision as 12 in sql server, in datastage for the column have many arithmetic function (ie addition, subtraction and division ) with same with length 22 and precision as 12, when I test the values with XL Sheet(precision as 12 ) with same opera...

Hi Experts
Often I am getting my job was locked and give error as Jobname.fifo getting locked. please any one can help out this.

Hi Rajeseaker, You mention as Date:Date= What is the first Date mean is it the column name , if yes please change the Column name because The Date is datatype so it not accept as column name, the correct syntax is Source _ColumnName:datatype =date_from_string(Destination column name["%mmm %dd, ...

Hi,
In Sequential file on format tab in Quote mark as Comma(,).

I have a Dat file as source, any one can say how to read this file in datastage , please help in this