Regarding DSUtility
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 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
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
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Are you kidding?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
![Mad :x](./images/smilies/icon_mad.gif)
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 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
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
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;
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
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.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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?'
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?'
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)