DSXchange

Thanks for your response. Yes those are the requirements that I posted in my first message. But can I install InfoSphere Information Server V8.1 on Windows 2003 Server 64 bits? The requirement's doc is saying that it can be installed in 32 bits, but nothing for 64 bits. Thanks for any comments or re...

Hello everybody. How are you today? I know, snow is everywhere, we're looking for sun :roll: , but as we say 'After the rain the beautiful weather' 8) Ok, my friends this is my problem: I'm trying to install DataStage Server 8.1 on Red Hat Enterprise Linux Server release 5.3. I'm using an ssh connex...

Thanks ray.wurlod,

I also don't have the license for the repository, so...
I opened a ticket support from IBM
I'll keep you informed, whenever i have a solution.

Ok fellows, I found a solution! I made one query in one stage with 3 columns (Id_Produit, Nb_Produit,Nb_Entree): SELECT Distinct (Tbl.JAPOLIP_WNPRO) as Id_Produit , (Select count(*) From JAPOLIP JP2 where JP2.JAPOLIP_WNPRO= Tbl.JAPOLIP_WNPRO AND JP2.JAPOLIP_DEFPO < #aaaammjj# ) AS Nb_Produit , (Sele...

God day my Friends, This is my new problem: I have created 2 stages with user defined sql query like this: Stage1 will have 2 columns (Id_Produit, Nb_Produit) : SELECT Distinct(Tbl.JAPOLIP_WNPRO) as Id_Produit, (Select count(*) From JAPOLIP JP2 where JP2.JAPOLIP_WNPRO= Tbl.JAPOLIP_WNPRO AND JP2.JAPO...

Yes My Friend, all works fine. This is wath i did: I create my liste of month, year (012001,022001,..,122009), I pasted in the delimited value field of the start loop stage. I modified my stage DateAlim to get the paramater and then split it into month and year in its transformer. I set the parametr...

My Friends, No news, good news. It worked finally not via datasatage, but i asked oracle to do the job for me, and it do it well :) I just create a new computed column in my source Table stage with this value Cost= NVL(Mouvement_Link.MBTMV, 0) - NVL(Mouvement_Link.MTVMV, 0) it worked well. This is b...

Thanks for your respons.
Yes exact this is a server job!

Good day My Friends, this my problem, its simple but?!! I'm trying to do a simple addition from 2 colons. My first colon is : Mouvement_Link.MBTMV with type Decimal(12,2) My second is: Mouvement_Link.MTVMV with type Decimal(12,2) For the addition and to test if the colons are not null i created this...

Thanks, The problem is I can't change the Clob Type because I'm not allowed to change anything in the DB. it's a prod DB, and I'm using it as a source for a datawarehouse. But, i think the clob is not the problem, because as i said, the other tables that all have the same type CLOB, works fine in da...

if (you_want_cookie='ok') then 'ok' else 'I dont want a cookie!'

if (you_want_cookie='ok') then 'ok' else 'I dont want a cookie!'

Good day my Friends, This is my problem, I'm trying to import many XML file form many Tables from an Oracle database, I have set everything(jobs, stages) and everything is OK , Except for one and only one table . Well I tried then to find where the problem is, i know that for the others tables it wo...

Magnificent, superb, all works as wanted!!! This is a simple tutorial link introducing how to use xml input. http://it.toolbox.com/wiki/index.php/Load_XML_files_using_a_DataStage_Parallel_job This is more complex tutorial for xml input: http://www.ibm.com/developerworks/data/library/techarticle/dm-0...

Ok the first step is resolved! :P Now i can see only the data, i had to check in the xml Input stage--> output--> Transform String--> Repetition element requiered. Now i'll try the seconds steps getting the information from database and inserting in flat file. The 3 steps will be inserting in other ...