I have raised a PMR with IBM for resolution. If you have any suggestions that could help resolve my issue, please let me know
Regards
Search found 79 matches
- Mon Feb 08, 2016 4:59 pm
- Forum:
- Topic: Workbench metadata export from Oracle
- Replies: 8
- Views: 5504
- Thu Feb 04, 2016 6:12 pm
- Forum:
- Topic: Workbench metadata export from Oracle
- Replies: 8
- Views: 5504
- Thu Feb 04, 2016 5:36 pm
- Forum:
- Topic: Workbench metadata export from Oracle
- Replies: 8
- Views: 5504
What is your goal? My end goal is to write data into MDM database using MDM connector stage. To do that I'm first exporting MDM metadata from MDM Workbench as XMI files. Then I would import these XMI files into Infosphere Metadata Asset Manager and share it in XMETA database, so that I can see that...
- Thu Feb 04, 2016 4:59 pm
- Forum:
- Topic: Workbench metadata export from Oracle
- Replies: 8
- Views: 5504
metadata import using MDM Workbench
Yes, I'm able to import metadata using DataStage plugin import.
Regards
Regards
- Wed Feb 03, 2016 8:53 pm
- Forum:
- Topic: Workbench metadata export from Oracle
- Replies: 8
- Views: 5504
Workbench metadata export from Oracle
Hi I'm not able to export metadata from Oracle database using Metadata Workbench. I'm using this application for first time with and I'm learning and doing it at the same time. What i did so far --> 1 Using Rational Application Developer (Workbench), created a Configuration Project. 2 Then launched ...
- Mon Jun 10, 2013 3:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Round Float type data
- Replies: 3
- Views: 2386
Float data type trunc and round
Hi Chulett Here is some sample data input and desirable output Input Output (8 decimals) ===== ========== 0 0.00000000 - Padded with zeroes 1.22334222765 1.22334223 - Truncate and Round 1.23244 1.23244000 - Truncate and Round Thanks
- Mon Jun 10, 2013 12:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Truncate and Round Float type data
- Replies: 3
- Views: 2386
Truncate and Round Float type data
Hi I have a Sybase source with Column A as Float. I want to Truncate the value of decimals to 8 places and round it and if there is a zero after decimal place, that should be padded with 8 zeroes. My job design is Sybase Src (Float) ---> Transfrmer ----> Sequential file (Float) I didn't find a funct...
- Tue Jul 17, 2012 1:17 am
- Forum: General
- Topic: Decrypting issue with GPG
- Replies: 4
- Views: 3341
Thanks All for your responses. I'm not sure about the resolution of this issue. It was resolved automatically. Now I'm able to decrypt all files. I didn't do any changes at all. @Chulett : I have posted the issue in GPG forum, but it's already a month now, I didn't receive any suggestions. Have a gr...
- Thu Jul 12, 2012 7:06 pm
- Forum: General
- Topic: Decrypting issue with GPG
- Replies: 4
- Views: 3341
Decrypting issue with GPG
Hi I'm facing some issues with decrypting files using GPG4Win 2.1.0 I have an execute command activity that triggers a windows batch file in server. some error messages listed below, ************************ Decryptnavtech..JobControl (@Execute_Command_0): Executed: E:\Data\Engineering-Test\Scripts\...
- Tue Aug 02, 2011 12:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2 error when I run the job
- Replies: 3
- Views: 4658
DB2 error when I run the job
Hi,
I have searched google and found the link that you have posted, but I wanted to make sure before I go to the DBA and ask him to enable the stored proc.
the issue has been resolved, stored procedure was not enabled due to some upgrade in db2 database.
Thanks for yor help.
I have searched google and found the link that you have posted, but I wanted to make sure before I go to the DBA and ask him to enable the stored proc.
the issue has been resolved, stored procedure was not enabled due to some upgrade in db2 database.
Thanks for yor help.
- Tue Jul 26, 2011 2:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2 error when I run the job
- Replies: 3
- Views: 4658
DB2 error when I run the job
Hello My job aborted with a DB2 message " [IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C". SQLSTATE=55023 " I have searched forum, but could not find appropriate post. Regarding my job, I'm using a db2 stage and w...
- Mon Jun 07, 2010 11:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Auto purge options
- Replies: 5
- Views: 2643
Auto purge options
Hi I wanted to know that if we select the auto purge option to purge to previous number of job runs in admin client, will the multi instant job status records in director delete to certain number mentioned. i.e will some of the instances delete from the status view in director.(datastage 8.1 server ...
- Thu Feb 11, 2010 1:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Automate Converting OCI 8 to OCI 9
- Replies: 3
- Views: 3428
Automate Converting OCI 8 to OCI 9
Hi All There is a need to convert all the OCI 8 stages in a project to OCI 9. The process we followed was, exported a job in XML format and replaced the Stage Type from "ORACI8" to "ORACI9" and the code worked. Is there a better way to convert the stages?? Like any command from A...
- Thu Feb 19, 2009 1:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cannot open file DSR_JOBS
- Replies: 1
- Views: 2527
Cannot open file DSR_JOBS
Hi All Today I had a problem while I try to export components. Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project glreports_uat (Subroutine failed to complete successfully (30107)) So, I rebuilt the DataStage Reporsitory indices. Now after the ...
- Tue Jan 27, 2009 9:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC configuration
- Replies: 2
- Views: 3998
ODBC configuration
Hi All Im using an ODBC stage to pull data. But when i try using that its not resolving connection. Errored out with below message. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('pscrm3g','sysadm')): BCI Error: SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]...