DSXchange

But when I use EVAL 'UPCASE(@RECORD)' LIKE '%$Table%'. I get results which I do not require. Suppose I am seraching for Word FACT_CLAIMS.

LIKE would give me jobs where FACT_CLAIMS_BACKLOG, FACT_CLAIMS _DEFRRED is used along with FACT_CLAIMS.

I want only jobs which has the exact word FACT_CLAIMS.

I am not able to get desired results using the following the command: SELECT NAME FMT '50L', CATEGORY FMT '60L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL 'UPCASE(@RECORD)' = '$Table') $Table is parameter passed in shell script But when I use LIKE instead of '=', I am ...

Hi, I want to pass a parameter from Unix command prompt to Datastage UV prompt. eg: SELECT * FROM DS_JOBS WHERE NAME=<PARAMETER> The value of the parameter has to be passed from Unix Prompt to UV prompt (i.e after executing the steps 1 cd `cat /.dshome` 2 . ./dshome 3 bin/dssh 4.Execute a command wh...

Is there any way to get the ouput of commands executed in Administartor into an excel or a file.

eg: I want to get the output of following commands into a file

1. LIST.READU
2. SELECT * FROM DS_JOBS

Hi,

I passed the exam today with 97%. I was thrilled to see my pass percentage.

Thanks to vmcburney for his blogs,
Thanks to Members of Dsxchange for their posts And
Thanks to DataStage PDFs.

Hi , I want to store the output of the following command at TCL prompt to a file (bascially an excel) SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'TERRITORY_AMOUNT_FACTOR',1) > 0 then '...

Hi Deanwalker, As said before I want to get certfied in 000-415 exam. So i want to get hands on on Parallel Architecture (I have been working on Server for 4 yrs). As only 7.5x2 EE is availbale on Windows, I want to try this. I need to install the Software 7.5x2 on Windows XP( though it works on Win...

But there are not the 7.5x2 DataStage EE CDs.

Could not exactly understand the above statement.
7.5x2 is Enterprise Edition only right.

Or you mean the website is not providing 7.5x2 EE CDs[/quote]

I am searching for 7.5x2 software. So thought of replying to this thread Yes there is here is the website http://www.zoomerart.net/index.php?target=desc&progid=3339 Can we download 7.5x2 from this site? Is it okay to get the software from this site Hope 7.5x2 all parallel stages when installed o...

Is there any site where we could get the downloadable software for 7.5x2?

I thought of replying to the post as this is what I am interested in. The Server to Parallel Transition Lab Video Tutorial by ray is not in full length. i.e it comes around 2-3 mminutes only. Any updates on this where we could get full version. Or the full version is already available which I am not...

Hi Smith,

How could I get an evaluation copy . What is the process for this. Whom should I contact for this?

Hi, I have been working on Datastage Server Edition for the past 4 years. I never worked on Enterprise Edition except once for a period of 5 days an year ago I want to pass 000-415 certification. But I do not have the Software to do hands-on on Enterprise Edition as my customer currently uses Server...

We have Sequencers and subsequencers where there are many email notifications and mails send through DS routines. Our objective is, when we take take the same sequencers and subsequencers from Production to development, we dont want emails sent (as emails would be sent to Business and Management Peo...

Hi, I though of replying to this topic as I searched and found this problem similar to me. I am facing the same problem with dssearch command. Only few jobs (which are present in in Dependencies Tab) of the Sequencer are getting displayed using dssearch command Is there any way that all jobs of the ...