DSXchange

We tried to execute istool.sh and it worked fine.

Thanks,
Kiran

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...

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...

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 ...

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...

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...

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...

Hi,

Finally,I was successfully able to run the store procedure in OCI stage in datastage server job.

In the After SQL tab,

Call schemaname.procedurename();

We need to include open and closed braces,even though we dont have the arguments.


Thanks
Kiran

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 ...

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...

Thanks Ray.

MONTH.LAST transform is useful in this case.



Thanks
Kiran

Hi,

I had got the idea....

I had put one more constraint in February check i.e mod(YEAR,4) = 0 Then '29/':MONTHYEAR Else '28/':MONTHYEAR

Please correct if I was wrong.....



Thanks
Kiran

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...

Thanks Chulett.

you are correct,we are not certain that it contains always 6 digits.
We have padded '0' for the month to make sure that the StaVarYear always contains 6 digits.

It had resloved the problem.


Thanks
Kiran

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 ...