Search found 160 matches
- Mon Apr 23, 2018 6:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
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...
- Fri Apr 20, 2018 9:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
- Fri Apr 20, 2018 6:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
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...
- Thu Apr 19, 2018 7:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
- Thu Apr 19, 2018 6:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
- Thu Apr 19, 2018 2:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with double SQL Server (ODBC)
- Replies: 12
- Views: 39142
Problem with double SQL Server (ODBC)
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...
- Tue Dec 02, 2014 10:35 am
- Forum: General
- Topic: Problem switching to Oracle12c
- Replies: 6
- Views: 4796
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...
- Tue Dec 02, 2014 8:21 am
- Forum: General
- Topic: Problem switching to Oracle12c
- Replies: 6
- Views: 4796
- Tue Dec 02, 2014 2:25 am
- Forum: General
- Topic: Problem switching to Oracle12c
- Replies: 6
- Views: 4796
Problem switching to Oracle12c
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...
- Tue Nov 11, 2014 11:00 am
- Forum: General
- Topic: Cannot open executable job file RT_CONFIG1266
- Replies: 6
- Views: 3988
- Tue Nov 11, 2014 9:26 am
- Forum: General
- Topic: Cannot open executable job file RT_CONFIG1266
- Replies: 6
- Views: 3988
- Tue Nov 11, 2014 5:33 am
- Forum: General
- Topic: Cannot open executable job file RT_CONFIG1266
- Replies: 6
- Views: 3988
Cannot open executable job file RT_CONFIG1266
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
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
- Thu Sep 04, 2014 3:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Connector conversion problem
- Replies: 7
- Views: 7553
- Thu Sep 04, 2014 2:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Connector conversion problem
- Replies: 7
- Views: 7553
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...
- Wed Sep 03, 2014 8:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle Connector conversion problem
- Replies: 7
- Views: 7553