We tried to execute istool.sh and it worked fine.
Thanks,
Kiran
Search found 110 matches
- Wed Oct 18, 2017 8:13 pm
- Forum: General
- Topic: Regarding istool command in Datastage 11.3 version
- Replies: 3
- Views: 3580
- Wed Oct 18, 2017 12:24 pm
- Forum: General
- Topic: Regarding istool command in Datastage 11.3 version
- Replies: 3
- Views: 3580
Regarding istool command in Datastage 11.3 version
Hi, We were using the istool command to export and import projects in Datastage 9.1 version. Currently we are migrating to 11.5 v and I am unable to find this command, Is something changed in the new version 11.5? Earlier we used to find istool in /opt/IBM/InformationServer/Clients/istools/cli folde...
- Wed Oct 29, 2014 5:57 am
- Forum: General
- Topic: OS for install Infosphere datastage server edition 9.1.2
- Replies: 0
- Views: 1914
OS for install Infosphere datastage server edition 9.1.2
We are planning to migrate all the ds jobs from Ascentiial datastage 7.5 server to Infosphere datastage 9.1.2 server edition. We want to install Infosphere datastage server edition 9.1.2 on Windows. I have read in the IBM website that, OS Microsoft Windows 2012 server, is the IBM Supported OS , howe...
- Mon Mar 11, 2013 5:02 am
- Forum: General
- Topic: Regarding the components available in Infosphere 8.7(Server)
- Replies: 3
- Views: 2880
Thanks for the detailed explanation. In summary, I understood that, irrespective of the edition of Datastage(server jobs or parallel jobs), and based on the licensing of PVUs,we can use the components of datastage (Business Glossary,Metadata workbench,Information Analyzer) and my earlier assumption ...
- Mon Mar 11, 2013 2:34 am
- Forum: General
- Topic: Regarding the components available in Infosphere 8.7(Server)
- Replies: 3
- Views: 2880
Regarding the components available in Infosphere 8.7(Server)
Hi, We are currently on Infoshere 8.7 server edition. Just wanted to check, if can we install and use the other components i.e Business Glossary,Metadata workbench,Information Analyzer, once we have the licenses from IBM ? Or Do we need to compulsory have parallel edition installed to make use of th...
- Thu Jul 19, 2012 8:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ETL logic using server jobs
- Replies: 4
- Views: 3688
Thanks.The solution you provided looks pretty simple and good. We had implemented this,in other way as well. We had splitted the single source link into two links using Transformer constraints as Mod(@inrownum,2) = 0 into one link(it contains data as test_seq test_seq1 test_seq2 and the Mod(@inrownu...
- Wed Jul 18, 2012 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ETL logic using server jobs
- Replies: 4
- Views: 3688
ETL logic using server jobs
Hi We have text file as source,it contains only one column.The first row is related to job status of second row which is jobname, and third row is related to job status of fourth row which is Jobname and so on..... The output should contain 2 columns i.e job status and that particular jobname.(it is...
- Wed Jul 04, 2012 12:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call oracle stored procedure in datastage server job
- Replies: 8
- Views: 9089
- Tue Jul 03, 2012 9:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call oracle stored procedure in datastage server job
- Replies: 8
- Views: 9089
Perhaps you need to qualify the SP name with its schema name, so that it is unambiguously indentified. ... Hi Ray, We had called this SP in the After SQL tab with the schema name as well. i.e CALL schemaname.Procdurename,execute schemaname.Procedurename. We had also given the execute permission to ...
- Tue Jul 03, 2012 9:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call oracle stored procedure in datastage server job
- Replies: 8
- Views: 9089
How to call oracle stored procedure in datastage server job
Before writing this,I had searched on this on the forum,but couldnot find the exact solution. I have one oracle procedure which I want to execute via datastage server job. It is not taking any parameters and not returning anything. It is extracting data from one table and doing some functionality(lo...
- Thu Mar 29, 2012 2:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find last day of the monthyear in server jobs
- Replies: 4
- Views: 2979
- Tue Mar 27, 2012 3:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find last day of the monthyear in server jobs
- Replies: 4
- Views: 2979
- Tue Mar 27, 2012 3:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find last day of the monthyear in server jobs
- Replies: 4
- Views: 2979
How to find last day of the monthyear in server jobs
Hi We are working on Datastage 7.5v server jobs on windows environment. We had a requirement to load the last day of the particular monthyear from the source. Input : MONTHYEAR 01/2011 02/2011 03/2011 06/2011 08/2011 01/2012 02/2012 Output : MONTHYEAR LASTDAYMONTHYEAR 01/2011 31/01/2011 02/2011 28/0...
- Wed Mar 21, 2012 9:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Arithmetic functions for String datatype using stagevariable
- Replies: 2
- Views: 2382
- Wed Mar 21, 2012 5:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Arithmetic functions for String datatype using stagevariable
- Replies: 2
- Views: 2382
Arithmetic functions for String datatype using stagevariable
Hi We are using Datastage 7.5v server edition on Windows machine. Before writing this,we have gone through the similar threads in this forum and came to conclusion that the string datatypes will automatically handle arithmetic functions in server jobs. we had tested this and it worked fine. we will ...