Search found 84 matches
- Thu May 18, 2017 4:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage upgrade from v8.7 to v11.5
- Replies: 6
- Views: 6702
always faced this
Hey Mohit, Good to see you here..Doing Good? I never used DRS stage, instead used ODBC connector to connect to various databases if a native stage is not found. These errors that you have highlighted around not using aliases for column names like (upper(x)) as XY or 'hardcoded' as HRDCD, we have alw...
- Mon Jan 25, 2016 7:23 am
- Forum: General
- Topic: How are license PVU's counted?
- Replies: 3
- Views: 3644
- Wed Jan 20, 2016 2:33 am
- Forum: General
- Topic: Multiple Statements in Before/After SQL File with Semicolon
- Replies: 4
- Views: 3411
- Wed Jan 20, 2016 2:23 am
- Forum: General
- Topic: How are license PVU's counted?
- Replies: 3
- Views: 3644
How are license PVU's counted?
Hi, I am trying to understand how licensing works with InfoSphere DataStage with respect to various tiers. Whatever licenses(PVU) we are eligible for , is that exclusively for engine tier or is shared with other tiers like services tier and/or metadata tier? ex. Suppose we have 140 PVU (2 cores) and...
- Thu Jan 24, 2013 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: confusing APT_STRING_PADCHAR - help me
- Replies: 1
- Views: 12400
padding
When you use the default padding i.e. 0x0, it is padded with ascii null which you can verify by taking ascii dump value of the padded character. Your SQL will not match name='xyz' name column has been padded with two ascii null charcaters(assuming that name is char(5). You must be careful while sele...
- Thu Sep 20, 2012 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To read Foxpro .DBF files
- Replies: 12
- Views: 8803
dbf drivers
Apologies for late posting .... Even though the .odbc.ini file mentions the complete driver name, when i checked in the path, the said driver does not exist. I am not sure if IBM ships it with the package. Does anybody have any idea? [dBase] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/...
- Tue Sep 18, 2012 6:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HOW TO USE PREFIX BYTES
- Replies: 4
- Views: 2831
- Wed Sep 12, 2012 3:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using parameters in Netezza connector
- Replies: 3
- Views: 3774
APAR# JR40698
Hi All This has been identified as a bug in Netezaa Connector and JR file avalaible from IBM. JR40698 would solve this issue. This JR is a client level JR that is included within JR42573. Once this JR file is imported, the issue is resolved. It has also solved issues of DSN connection not visible in...
- Mon Sep 10, 2012 1:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using parameters in Netezza connector
- Replies: 3
- Views: 3774
- Fri Sep 07, 2012 4:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading the sequential file
- Replies: 4
- Views: 5126
is it filter
Hi Not sure what you are trying to say in the last few lines but if your requirement is to put filter while reading the sequential file you may use oany of the two options 1. Use Sequential File to read complete set of data and use filter stage to filter out records. Use parameters to change the dep...
- Fri Sep 07, 2012 4:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: using parameters in Netezza connector
- Replies: 3
- Views: 3774
using parameters in Netezza connector
Hi, I am on DS 8.7 on unix trying to establish connection with Netezza DB using Netezza connector. When I supply all 4 connection properties as hardcoded (Data Source,DB Name, User Name, Password), the connection is successfully established. When I supply 3 connection properties as parameters(Data S...
- Wed Jan 11, 2012 11:55 pm
- Forum: General
- Topic: can we add cc list to notification activity
- Replies: 7
- Views: 4586
adding list in the server
Hi ray Can you please suggest how we create a list in the mail server so that To and CC can be sepearted. Is it something that datastage people do or is it the network team. Once this list is created, your suggestion is to send email to this list...which will automatically handle the TO and CC part....
- Mon Sep 26, 2011 10:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: runLocally() did not reach EOF on its input data set 0
- Replies: 9
- Views: 6846
EOF reached prematurely
Hey this warning message comes when the last record is read and parser does not find suitable record final delimiter as specified in the "format" tab. Even before final demiliter is encountered, the EOF is reached. Though this does not impacted data read, but it does throw a warning. Can y...
- Mon Sep 26, 2011 4:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Parallel Shared Container
- Replies: 4
- Views: 3349
Design of shared container
Hi Ray My shared container design looked like Row Generator----------------->Transformer------------------>Sequential File lnk1 lnk2 After some trial, I have been able to fix this by replacing Row generator with container input and sequential file as container output. Container Input------------>Tra...
- Mon Sep 26, 2011 4:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Parallel Shared Container
- Replies: 4
- Views: 3349
Using Parallel Shared Container
Hi, I am trying to use shared container for the first time and am facing some issues. When I searched through the forum, I couldn't find somebody who had faced such a basic elemntary problem. :oops: I have a parallel shared container consisting of a row generator , Transformer and sequential file wi...