Search found 13 matches
- Sat Dec 28, 2019 7:54 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA-Column Analysis-Incorrect inferred results for a column
- Replies: 3
- Views: 14733
Re: IA-Column Analysis-Incorrect inferred results for a colu
The maximum length of the string in the field was around 3000.
- Thu Oct 03, 2019 12:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC:Warning: Data type 0xE7 has an invalid data length
- Replies: 2
- Views: 4928
ODBC:Warning: Data type 0xE7 has an invalid data length
Hi Experts, Parallel job with source as ODBC connector is generating the below warning when run with/with out any data in source table. "SQLSTATE = HY000: Native Error Code = 8,016: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver][SQL Server Parallel Data Warehouse]The incomin...
- Wed Jul 31, 2019 1:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to implement logic to apply join with PARTIAL match key
- Replies: 4
- Views: 4069
- Wed Jul 24, 2019 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to implement logic to apply join with PARTIAL match key
- Replies: 4
- Views: 4069
Need to implement logic to apply join with PARTIAL match key
Hi Experts, I have a requirement of joining two tables on a column value with Partial Match (Not exact key match). Example: First Table Data value: "Mathematica" Second table Data value: "Mathematica 11.0 JDBC Support x64" "Mathematica 11.0 JDBC Support x86" "Wolfr...
- Tue Jul 23, 2019 2:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Improve performance for nvarchar(max)/LOB type in ODBC stage
- Replies: 2
- Views: 3402
- Mon Jul 15, 2019 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Improve performance for nvarchar(max)/LOB type in ODBC stage
- Replies: 2
- Views: 3402
Improve performance for nvarchar(max)/LOB type in ODBC stage
The nvarchar(max) field of sql server is read as LOB by datastage ODBC stage ([IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]). In order to read the data it suggests to change the array size to 1 for LOB and this change highly impacts the performance. Is there any solution/workaround fo...
- Mon Jul 15, 2019 2:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while inserting into nvarchar(max) record
- Replies: 1
- Views: 3347
Error while inserting into nvarchar(max) record
Error while inserting into nvarchar(max) record of PDW through an ODBC stage in Datastage. The nvarchar(max) records are read as LOBs and treated has LOBs by Datastage. So, the array size had to be made to 1. This is working for most of the records. However when the text length is greater than 2000(...
- Tue Jul 02, 2019 8:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add a new column without using Transformer Stage
- Replies: 6
- Views: 5777
- Tue Jul 02, 2019 3:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add a new column without using Transformer Stage
- Replies: 6
- Views: 5777
Add a new column without using Transformer Stage
Hi, I have a requirement to read data from 7 different tables using a ODBC stage and apply some logic. Table structure is different for each table so want to add new columns with NULL value. I don't want to use Transformer stage as I need to use 7 transformers. It would be great help, If anyone have...
- Tue Dec 04, 2018 4:32 pm
- Forum: General
- Topic: DB2 vs SQL Server for repositories?
- Replies: 5
- Views: 4858
- Thu Nov 29, 2018 5:40 pm
- Forum: Site/Forum
- Topic: Premium membership upgrade issue
- Replies: 2
- Views: 14489
- Thu Nov 29, 2018 4:10 am
- Forum: General
- Topic: DB2 vs SQL Server for repositories?
- Replies: 5
- Views: 4858
DB2 vs SQL Server for repositories?
Hi experts, How much better still is using DB2 over SQL Server for IIS repositories these days (IADB and XMETA)? We are considering upgrading to 11.7 whilst re-architecturing (moving to RedHat). I am guessing it is safe to say that using DB2 for IIS repositories is the best option. However the DBA's...
- Mon Oct 29, 2018 3:08 pm
- Forum: Site/Forum
- Topic: Premium membership upgrade issue
- Replies: 2
- Views: 14489
Premium membership upgrade issue
Hi All, Would anyone know of the quickest way of getting in touch with Dennis or anybody else that could help with upgrading the membership? I have emailed him to membership.director@dsxchange.com and it bounced. I have also texted him to the phone number provided in http://www.dsxchange.com/viewtop...