DSXchange

Hi. I'm aware about all. The real problem is that we actually don't know what sql is sent to the db server trought odbc driver. I'm my opinion the combination datastage+odbc+SQL Server+Decimal can't work at all (many others agree). I solved using OLE DB spending 5 minutes. Many thanks for the suppor...

Hi. Surely there's someone there who can help you with basic SQL Server syntax? It's not specific to DataStage, just thinking that leveraging CAST in custom SQL would be one way to go. I'd like just to put "'" around the value and it should work, but I don't know what DS insert in place of...

Hi all. It seems to me that 62.95081967 has more than five decimal places. What is the defined data type in SQL Server? Did you import the table definition from SQL Server into DataStage, and use those me ... I think the problem is not due to the number of decimal places, because I've also tried fix...

Hi. Always best to explain, when something "doesn't work", the why of it. What doesn't work about it? Sorry, I supposed it was clear , the data is not loaded into the table. I'd also be curious what your actual target datatype is - float(n), real? With a mismatch like you have, you may nee...

I tried now.
It doesn't work. Using, for example, both "10.5" and "10,5" as input value.

Thanks,
Andrea

Hi. I'm a problem inserting floatig values, in a SQL Server db, in the field "MVPREZZO" defined as below: [MVPREZZO] decimal(18, 5) NULL The job is very simple: CSV -> transformer -> ODBC Stage The only data type I can use on the target ODBC stage to avoid the warnig "SQLColAttributes...

I know that ;-) The real problems is: identical ETL environment, 2 Oracle both with english language BUT with one of them I get the error. Why ? By know, after further analysis the problem seems to be that Oracle 11 english db was installed on italian windows OS but the Oracle 12c english on english...

Hi. The problem is ORA-01722 ;-) Have you tried adding a reject link off the Oracle Connector stage (if Server jobs allow reject links)? Of course, the problem is related to double fields containing "." for example 123.45 where "." is the decimal searator. The fields are mapped a...

Hi. I'm facing ORA-01722 changing the target DB from Oracle 11 to Oracle 12c. The Oracle 12c NLS_NUMERIC_CHARACTERS are the same as the Oracle 11. The job is Seq.File ==> transformer ==> Oracle db and get the error only with the Oracle 12c (Oracle 11 is the production version). Datastage Server regi...

The server is Windows ... which file should I copy ?

Andrea

The folder exists with both file DATA.30 and OVER.30


Andrea

Hello everybody.

A problem (probably disk space) on my Datastage Server created a problem with a job.
Now when I try to delete the job or rename it I'm getting the message "Cannot open executable job file RT_CONFIG1266".

Anyone knows how to help me ?

Many thanks,
Andrea

ponzio wrote:but also read as double works fine.
So I suppose the important thing is write as decimal

Sorry, reading the field as double doesn't work

A

Sorry, too much PX on the brain. I was supposed last last post then same ;-) If you work with FLOAT you'll see all kinds of issues like this so... don't. Probably won't help but do the move from a string field to a decimal with the proper scale in the transformer and then map that decimal to the NU...

Sorry how can I do the explicit conversion?

I tried and doesn't work.

I tried to read the number in the input as float and write as float
that number becomes 0,333328992 and 0,0207 (previously correct) becomes0,0207000002

Thanks,
Andrea