Regarding DSUtility

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 12:30 pm

Hi Gurus,
I didn't find any code, i tried to search with keyword @RECORD , i didn't get the link. Can Gurus help me with the link.

Please help me Gurus.

cheers;
vijay

narasimha · Post by **narasimha** » Fri Jan 12, 2007 12:52 pm

Did an exact search found 75 matches for @RECORD.
You can find a nice explaination here

Saama · Post by **Saama** » Fri Jan 12, 2007 1:39 pm

Hi Gurus,
From the administrator, iam giving the command
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), 'PROJDEF' , 1)>0 THEN 'FOUND' ELSE ' ' '' AS FOUND FMT '5L' FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND FOUND='FOUND' GROUP BY JOB_NAME,DS_JOBS.CATEGORY,OBJECT_NAME,DS_JOBOBJECTS.OLETYPE,FOUND;

iam getting error : scanned as "select" statement.

please help me, am i going wrong with the select statement.
How should i manipulate the query so that i can get the list of parameters used by particular stage. plz gurus can you post the code.

plz help me.

cheers;
vijay

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 2:04 pm

Hi Gurus,

Can anyone post the code from datastage administrator or from the operating system that gives the list of parameters used by particular stage.
plz help me Gurus.

cheers;
vijay

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 12, 2007 2:09 pm

vijaykumar wrote:Hi Gurus,

Can anyone post the code from datastage administrator or from the operating system that gives the list of parameters used by particular stage.
plz help me Gurus.

cheers;
vijay

Are you kidding?

You are back to the same question you asked in the beginning. If there is someone who knows or has an answer, they will get back. Please don't urge members.

narasimha · Post by **narasimha** » Fri Jan 12, 2007 2:26 pm

What you are trying to achieve here is not very commonly done by everybody.
Thats the reason why there is delay in people getting back to you.
As Whale said, a little patience required here please.

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 2:40 pm

Hi Gurus,
Sorry, indeed you are helping me a lot.

cheers;
vijay

ray.wurlod · Post by **ray.wurlod** » Fri Jan 12, 2007 3:26 pm

Another reason is time zones, and the need to sleep occasionally.

Your specification is imprecise. Job parameters have as many as three values: the design-time defaults, created in Designer; the run-time defaults, set in Director, and the actual run-time values, set when a job run request is issued. Naturally these are stored in separate locations; in the first two cases in undocumented locations.

Please post the entire (detail) error message; it will, for example, indicate how must of the query was successfully parsed.

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 3:34 pm

Hi Gurus,
Hi Gurus,
From the administrator, iam giving the command
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), 'PROJDEF' , 1)>0 THEN 'FOUND' ELSE ' ' '' AS FOUND FMT '5L' FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND FOUND='FOUND' GROUP BY JOB_NAME,DS_JOBS.CATEGORY,OBJECT_NAME,DS_JOBOBJECTS.OLETYPE,FOUND;

iam getting error : improper syntax, its saying syntax is incorrect.
plz help me with the syntax.
cheers;
vijay

DSguru2B · Post by **DSguru2B** » Fri Jan 12, 2007 4:01 pm

You did not close the double quotes in your query. Copy paste the bottom code as it is.

Code: Select all

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), 'PROJDEF' , 1)>0 THEN 'FOUND' ELSE ''" AS FOUND FMT '5L' FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND FOUND='FOUND' GROUP BY JOB_NAME,DS_JOBS.CATEGORY,OBJECT_NAME,DS_JOBOBJECTS.OLETYPE,FOUND;

Saama · Post by **Saama** » Fri Jan 12, 2007 4:34 pm

Hi Gurus,
I copied and pasted the code as it is, iam getting the output as
IF INDEX(UPCASE(@RECORD),PROJDEF,1)>0 THEN FOUND ELSE.
jobname=salma
category=vijay
object name=xxx
ole type=yyy
It doesn't give desired output, please help me.
cheers;
vijay

narasimha · Post by **narasimha** » Fri Jan 12, 2007 5:22 pm

The query what you have will not give you your desired results.
This gives you the jobs in your project which use PROJDEF.

The link was provided to you as an explaination for @RECORD given by Ray.
You need to use that as base to develop your query.

vijaykumar · Post by **vijaykumar** » Fri Jan 12, 2007 5:50 pm

Hi Gurus,
I tried a lt but couldn't comeup, Its only possible with gurus, please if any Guru helps me i will really appreciate.

cheers;
vijay

ray.wurlod · Post by **ray.wurlod** » Fri Jan 12, 2007 6:40 pm

You query requested job name, category, object name and OLE type.

The result contained job name, category, object name and OLE type.
You have to trust that the database has selected only those records that contain "PROJDEF", since you have not asked for that to be displayed.

QED

If you want a different result, you need to specify a different query. But you still have not asserted what you want in the result.

Help us to help you. I can read minds, but not at this distance. And in any case, I only do so in return for remuneration.

us1aslam1us · Post by **us1aslam1us** » Fri Jan 12, 2007 7:00 pm

Vijay,
I will ask you again the same thing " what is the reason for doing it that particular way when you can obtain this in a simple way?"

If your answer is your 'Team Lead wants it that way' then ask him for the particulars 'why he need it that way?', 'what exactly he wants to do with it?'