Hi,
Can somebody tell "how can EVAL be used like DECODE"?
Thanks
George
Search found 76 matches
- Wed Apr 29, 2009 12:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can i use a CASE statement in a SELECT statement ?
- Replies: 11
- Views: 7991
- Tue Apr 28, 2009 11:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can i use a CASE statement in a SELECT statement ?
- Replies: 11
- Views: 7991
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...
- Tue Apr 28, 2009 2:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can i use a CASE statement in a SELECT statement ?
- Replies: 11
- Views: 7991
Can i use a CASE statement in a SELECT statement ?
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
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
- Mon Oct 13, 2008 1:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
- Fri Oct 10, 2008 1:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
- Thu Oct 09, 2008 10:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
- Thu Oct 09, 2008 10:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
- Thu Oct 09, 2008 10:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
- Thu Oct 09, 2008 10:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
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...
- Tue Oct 07, 2008 10:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job 5550 Phantom 4056 (Access violation)
- Replies: 11
- Views: 6930
DataStage Job 5550 Phantom 4056 (Access violation)
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...
- Fri Mar 07, 2008 4:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Better Performance
- Replies: 4
- Views: 2965
- Fri Mar 07, 2008 4:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Better Performance
- Replies: 4
- Views: 2965
Better Performance
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 ...
- Fri Jul 27, 2007 4:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed file size
- Replies: 6
- Views: 3617
- Sun Jul 08, 2007 11:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Regarding Multi row return
- Replies: 1
- Views: 1946
Re: Regarding Multi row return
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...
- Thu Jul 05, 2007 9:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed file Indexed
- Replies: 11
- Views: 4586