DSXchange

Remove the '-'s from your Date, if the date contains '-'s in a stage variable, and then call it in the Derivation.

Hi ArndW,

Yes, it is a multi node configuration job. And it is an insert to database.

Write Method : Write
Write Mode :Append


Thanks

ray.wurlod wrote:Hanging on locks (a lock?) in the database? ...

May be .. But currently i do not have access, to the database. Will a job re-run help?

Thanks

Hello All, I am loading data from sequential file to SQL Server database. The Design of the job is, SEQUENTIAL FILE->TRANSFORMER->ODBC The job aborted due to the following error. APT_CombinedOperatorController(1),0: [IBM(DataDirect OEM)][ODBC SQL Server Driver][libssclient23]Timeout Expired. The dat...

Not really. If those components can come in with one or two digits, you need to check each one and add the zeroes yourself. Of course, the easiest way to fix this is to get the producer of this data to standardize it for you so you don't have to futz with it. :wink: Yep, am trying to add zeros myse...

Hello All, I have a date column, where in the format is '2010-01-17T0009:13:123' . I have to load it as timestamp and am able to do so, by using this suggested by Arndw, StringToTimestamp(DSLink316.DATE[1,10]:' ':DSLink316.DATE[12,12],"%yyyy-%mm-%dd %hh:%nn:%ss.3") The data need not have m...

The decimal number is not stored with the trailing zeroes, it is only displayed with them. You can not get rid of them in the View Data dialog. If you want to get rid of them into a text file, declar ... Sorry, am not a premium member yet. Still, the data is getting loaded with the zeros in the dat...

Length : 15 ; Scale 10 Thanks Now i have changed the source field as 'Numeric' datatype,Length to 10, Scale to 15 The target has the same datatypes and length, and scale.. When i load this i get the 3.1120000000 ( 6 zeros appended in the end) . I used Trim(columnname, "0" , "T" ...

Length : 15 ; Scale 10

Thanks

Check DecimalToDecimal() I tried DFLOAT to Decimal conversion.. It is loading the data, but it is loading it as 10 digits after decimal, where in the input data contains only 4 digits after the decimal point.. The target column is numeric.. and the scale is 10..Is that why it is loading 10 digits??...

ArndW wrote:StringToTimestamp(DSLink316.DATE[1,10]:' ':DSLink316.DATE[12,12],"%yyyy-%mm-%dd %hh:%nn:%ss.3") ...

Thanks, that worked !

Hello ..

Sorry to post a data type conversion questionn again.. I am facing quite a lot of data type conversion offlate. .

Here it is..

The source has the following data,

3.1120 (Float of length 10). How do i convert it to Numeric datatype of length 15?


Thanks a ton !

Hello All,

Below is a varchar and i need to convert it to timestamp length 23, scale 3..

2009-01-15T00:08:13.109.

I used the below code and it doesnt work...

StringToTimestamp(DSLink316.DATE,"%yyyy-%mm-%dd %hh:%nn:%ss")

Any idea on the right code??

Thanks

Thanks ernie.. It works.. I had checked two key columns in the xml input stage..