Search found 193 matches
- Fri Aug 28, 2015 8:20 am
- Forum: IBM QualityStage
- Topic: How to create cutomized rule set.
- Replies: 4
- Views: 5485
How to create cutomized rule set.
We have 4 address fields in sources. Each filed may contain city, state,country,postcode in any order. We have to combine all these fields and match the data against the rules sets for country,city,state and postcode and if match is found, we have to lael the data. ex: source data "Hyderabad In...
- Fri Mar 06, 2015 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject Link to ODBC Connector Stage
- Replies: 2
- Views: 3003
- Wed Mar 04, 2015 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject Link to ODBC Connector Stage
- Replies: 2
- Views: 3003
Reject Link to ODBC Connector Stage
Hi, Is there anyway that Data Columns apart from ERRORCODE and ERRORDESC from reject link in ODBC Connector Stage can be controlled from propagating to next stages? I am asking this query because there are couple DataStage Jobs which are running in Production environment but stopped working in Syste...
- Thu Nov 13, 2014 10:14 am
- Forum: General
- Topic: DS 8.5 to DS 9.1 Job Import Error
- Replies: 3
- Views: 4135
- Thu Nov 13, 2014 7:34 am
- Forum: General
- Topic: DS 8.5 to DS 9.1 Job Import Error
- Replies: 3
- Views: 4135
DS 8.5 to DS 9.1 Job Import Error
Hi, We are trying to Import bunch jobs from DataStage version 8.5 to version 9.1. But the Import failed with error - " Not attached to a job" for job designs. Similarly it throws an error - " Class=DSRECORD " for job executables. Options tried are - 1. Tried changing proxy - http...
- Mon Oct 06, 2014 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS LANG / Charactersets in SQL Server Database Compatibilty
- Replies: 1
- Views: 2514
SQL Server database records had multiple Control Characters. There are various control Characters involved and SCD Stage (type-1) needs data to be control Characters free. So I have shifted to use CDC (Change Data Capture) along with IANAAppCodePage=2252 in 'odbc.ini' file and issue has sorted out. ...
- Tue Sep 30, 2014 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS LANG / Charactersets in SQL Server Database Compatibilty
- Replies: 1
- Views: 2514
NLS LANG / Charactersets in SQL Server Database Compatibilty
Hi, I use SQL Server as source and Oracle as Destination database. Am following SCD-Type 1 approach. When SCD Stage is in place, it always sends data as changed data even though there are no Changes literally happened at source. SQL Server database has : COLLATION_NAME as - "SQL_Latin1_General_...
- Tue Sep 30, 2014 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle sys_guid() function in DataStage ??
- Replies: 4
- Views: 3870
I use MS-SQL Server as Source System and Oracle as Target System. Our customer follows some annoying coding standards and one of them is not to use User-Defined queries at oracle side while INSERT/UPDATE. So I used NEW_GUID() in SQL Server while selection and populating the Oracle database. Many tha...
- Mon Sep 22, 2014 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle sys_guid() function in DataStage ??
- Replies: 4
- Views: 3870
Oracle sys_guid() function in DataStage ??
Hi,
What is the quivalent function in DataStage to generate sys_guid() value for each row as surrogate key.
Oracle has - sys_guid() function, any equivalent function in DataStage ?
What is the quivalent function in DataStage to generate sys_guid() value for each row as surrogate key.
Oracle has - sys_guid() function, any equivalent function in DataStage ?
select sys_guid() from dual
- Fri Sep 06, 2013 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC driver does not support retrieving execution status
- Replies: 4
- Views: 5849
- Fri Sep 06, 2013 6:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC driver does not support retrieving execution status
- Replies: 4
- Views: 5849
ODBC driver does not support retrieving execution status
Hi, Hit with below error, as it's working in all environments except production environment. we are using ODBC connector to connect to SQL Server. In all environments the array size and record count is - 2000 (default). odbc_lccyp,0: This driver does not support retrieving execution status for each ...
- Tue Jul 02, 2013 3:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQLSever - SQLSTATE = 42000, fNativeError = 2754
- Replies: 3
- Views: 3871
- Mon Jul 01, 2013 4:31 am
- Forum: General
- Topic: UNIX Commad line - no wait required upon invoking the job
- Replies: 11
- Views: 4883
- Mon Jul 01, 2013 4:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQLSever - SQLSTATE = 42000, fNativeError = 2754
- Replies: 3
- Views: 3871
SQLSever - SQLSTATE = 42000, fNativeError = 2754
hi all, Trying to Invoke a SQL-Server Stored procedure from DataStage. Am encountering below Fatal error. a. Unfortunately same stored procedure is invoked in different job with same input parameter and is working fine. b. Also, same job is working fine in other enviroments. c. Stored procedure is w...
- Wed Jun 26, 2013 5:23 am
- Forum: General
- Topic: UNIX Commad line - no wait required upon invoking the job
- Replies: 11
- Views: 4883