DSXchange

Hi,

Can somebody tell "how can EVAL be used like DECODE"?

Thanks
George

Hi, Thanks for the reply. I am sorry i dont know how to use EVAL or I-descriptor:( I went through the PDF (universe Gudie to Retrive) but still not clear about EVAL. how will i use EVAL insted of CASE in the below SQL SELECT CASE BEG_AMT WHEN 0 THEN 1 ELSE BEG_AMT END FROM HASH_PS_F_LEDGER Thanks Ge...

Hi,

Can i use a CASE statement in a SELECT statement.This Select statement is quering a hased file which is used inside a routine?

If possible kindly requesting you for the sql syntax

Thanks
George Sebastian

Thanks chulett,

Let me report this issue with IBM and let us see if there is any solution available for this issue.

Will update you all soon

Thanks
George Sebastian [:)]

Thanks for Your reply chulett,
The experiment infact worked with OCI stage. So Is this a BUG with the DRS stage?

Thanks
George Sebastian

Thanks for Your reply chulett,

Since we have customers having different databases we cannot use the OCI Stage

Thanks for Your reply chulett,

Since we have customers having different databases I am afriad that we cannot deliver this fix.

The Database is Oracle and we are using DRS stage.

Thanks
George Sebastian

Thanks chulett. I dont have any CLOB datatype in my job but i have VARACHAR 2000,which i have used in PIVOT stage. I have 2 similar jobs aborting with the same reason. 1st job abort will happen in the Transformer just after the PIVOT stage in the 2nd job abort will happen in the Transformer just bef...

Hi All, While running ajob i am getting the following error. DataStage Job 5550 Phantom 4056 Program "JOB.2006043476.DT.1489159782.TRANS6": Line 150, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage J_Fact_PS_F_STU_RECRT..Build_PS_E_AD...

Hi all,

What about using 28 DRS and after that the using a Sequencial file(with append option) insted of using Link collector.
which one will be a better design

Please advise

Thanks
George

Hi Everyone, I have a design issue. In the source DRS I need to get data from 28 tables.The structure of the tables are same but having very huge amount of data. (all the rows are distinct) I would kindly like to know which one will give me a better performance My options are 1.Using a UNION in the ...

Hi



ANALYZE.FILE <<Hashed File Name>>

use it in administrator command box.

Thanks
George

George, there are a few ways to return all matching values from a lookup. The one in question is achieved as follows - 1. Populate your hashed file with the right key(s). Let's call the hashed file MyLkpFile . 2. Now, in the job where the lookup is to be used, use a UV stage with its data source set...

Thanks Ray,


I got the point.I am learning ... :D

Thanks All,

George Sebastian