I have tried below in transformer and got the expected results.
pwr( (1+(-2.0/100)),((1.0/12)-1))
convert the incoming columns to floats and this should resolve the issue.
Search found 292 matches
- Wed Jun 28, 2017 1:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use Power (Pwr) function
- Replies: 16
- Views: 9402
- Tue Jun 27, 2017 1:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchial Stage - WebServices - POST to read data
- Replies: 3
- Views: 3365
Hierarchial Stage - WebServices - POST to read data
Hi, We are running 11.3 version on Linux server. I have a requirement to call a RestFul Webservice from DataStage and download the data from client in JSON format. For security reasons, call should be made using POST method rather than GET. I tried to find documentation on using POST method to read ...
- Thu Aug 07, 2014 10:29 am
- Forum: General
- Topic: odbc connection set up on linux
- Replies: 4
- Views: 3113
- Wed Aug 06, 2014 12:27 pm
- Forum: General
- Topic: odbc connection set up on linux
- Replies: 4
- Views: 3113
odbc connection set up on linux
Hi, I am running DataStage 8.7 on Linux environment. We use SQL Server for data purposes. Assuming SQL Server name is "SqlServ" which has 5 databases ( DB1, Db2, DB3, Db4, Db5) under it with multiple tables in each database. A datastage application id is created to read from all 5 database...
- Tue Aug 05, 2014 9:54 am
- Forum: General
- Topic: Datastage connect to windows share space
- Replies: 1
- Views: 1758
Datastage connect to windows share space
Hi,
We are running DataStage 8.7 on Linux server. There was a requirement to connect to Windows share space from Linux and access the file.
Windows share space ( vFiler ) is only a share space with no FTP running on it.
Is there a way to connect Linux to VFiler wiht no FTP?
We are running DataStage 8.7 on Linux server. There was a requirement to connect to Windows share space from Linux and access the file.
Windows share space ( vFiler ) is only a share space with no FTP running on it.
Is there a way to connect Linux to VFiler wiht no FTP?
- Mon Jun 16, 2014 2:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC - Transaction Handling
- Replies: 4
- Views: 2793
- Mon Jun 16, 2014 11:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC - Transaction Handling
- Replies: 4
- Views: 2793
ODBC - Transaction Handling
Hi, I am running DataStage 8.7 on Linux environment. I have a requirement to extract data from Oracle and load into a table named "table1" in SQLServer. But before loading "table1" i am required to delete all the existing records and then insert the new ones. Tricky thing, is &qu...
- Wed May 14, 2014 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Call Oracle stored procedure from Storeprocedure/Oracle conn
- Replies: 1
- Views: 2534
- Wed May 14, 2014 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Call Oracle stored procedure from Storeprocedure/Oracle conn
- Replies: 1
- Views: 2534
Call Oracle stored procedure from Storeprocedure/Oracle conn
Hi, I have an oracle store procedure named "dummy.sp_call" ( schema = dummy & procname = sp_call ). I am required to execute this from either Oracle connector or Store procedure stage. As a first step, i have used store procedure stage and provided the procedure name "dummy.sp_cal...
- Tue May 13, 2014 4:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Stage - Transaction handling
- Replies: 4
- Views: 3497
- Tue May 13, 2014 3:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector Stage - Transaction handling
- Replies: 4
- Views: 3497
ODBC Connector Stage - Transaction handling
Hi, I have a job like ODBC(ext)----->xfm-----ODBC(load). In ODBC load, i am required to delete the data in a table and after it is complete, load the contents coming from xfm into the same table. Deleting the contents of table and inserting into same table should be a part of single transaction. To ...
- Tue May 06, 2014 9:26 am
- Forum: General
- Topic: ODBC entry - Connect to Oracle
- Replies: 1
- Views: 1591
ODBC entry - Connect to Oracle
Hi, I did created a ODBC entry in .odbc.ini file and in uvodbc.config file to connect to Oracle DB "XXX". When i test it, i am getting "No Listener" error. My question, as i am connecting to oracle should i also have a TNS entry for Oracle DB "XXX". And also instead of ...
- Wed Apr 30, 2014 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise stage - execute nlist
- Replies: 1
- Views: 1996
FTP Enterprise stage - execute nlist
Hi, I have a requirement to 1) get the list of files from oracle database 2) get list of files from remote server by connecting using ftp 3) compare the files from remote ftp to files available in oracle and read the files which are unique to remote server. I am trying to connect to remote server vi...
- Mon Jan 27, 2014 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle & DB2 connector -- Cannot pass parameter to SQL
- Replies: 3
- Views: 2607
In previous versions, there used to be a dropdown to select the parameter which is added as a string in SQL. But now if the select the parameter from right side of SQL, then whole SQL is replaced with parameter values. It worked when i just remembered the parameter and executed the query like select...
- Mon Jan 27, 2014 10:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle & DB2 connector -- Cannot pass parameter to SQL
- Replies: 3
- Views: 2607
Oracle & DB2 connector -- Cannot pass parameter to SQL
Hi, I am running DataStage 8.5 and i am required to pull data from DB2 DB and Oracle DB. I have used DB2 and Oracle connectors. I have query like select aa,bb,cc from t ( select aa,bb from table_name where month = pass_parametere and year = pass_parameter ) join ( select cc from table_name] where la...