regarding command line utility
Moderators: chulett, rschirm, roy
regarding command line utility
hi gurus,
my job design is odbc---->transformer---->odbc
after compiling and running the job its stored in the repository.i use command line utility from administrator.
i have search for commands.
i have used LIST.DICT DS_JOBS, its displaying a list.
but my job name is saa, will this command display my job.
plz help me with the command that displays my job, regarding my metadata and transform components used.plz help me .
cheers;
saama
my job design is odbc---->transformer---->odbc
after compiling and running the job its stored in the repository.i use command line utility from administrator.
i have search for commands.
i have used LIST.DICT DS_JOBS, its displaying a list.
but my job name is saa, will this command display my job.
plz help me with the command that displays my job, regarding my metadata and transform components used.plz help me .
cheers;
saama
LIST.DICT just displays the dictionary items not the contents. Plus DS_JOBS just has info about the jobs, not the stages. I say stick to DS functions to retrieve job meta data and stage info. Also, search for kduke's ETLStats.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
You can just say :
to get a list of all of your jobs.
Or you can use:
Searching the forum will get you many answers most of the times. I guess you didn't search before posting.
There are a lot posts for the search term 'LIST' or 'LIST DS_JOBS'. If you think your topic is resolved. Please mark it as resolved.
Whale.
Code: Select all
LIST DS_JOBS
Or you can use:
Code: Select all
SELECT * FROM DS_JOBS WHERE NAME = 'YourJobName'
There are a lot posts for the search term 'LIST' or 'LIST DS_JOBS'. If you think your topic is resolved. Please mark it as resolved.
Whale.
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
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
This is the perfect answer for your needs.chulett wrote:Why not just open the job in Designer and click the button that looks like an Internet Explorer icon? It will generate a lovely little HTML document will all that stuff in it for you... no charge.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's an even better answer if you've been bothered to document your job design.
Axiom: there is never time to retrofit documentation.
Moral: do documentation first.
Axiom: there is never time to retrofit documentation.
Moral: do documentation first.
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.
Hi gurus,
Thanks very much.
i have used command line utility
SELECT * FROM DS_JOBS WHERE NAME='JOBNAME'
i also used another command, which i searched in the forum.
when i use SORT.ITEM DS_JOBOBJJECTS.
it displays record numbers.
how to identify my job when i use SORT command.
plz help me in identifying job.
cheers;
saama
Thanks very much.
i have used command line utility
SELECT * FROM DS_JOBS WHERE NAME='JOBNAME'
i also used another command, which i searched in the forum.
when i use SORT.ITEM DS_JOBOBJJECTS.
it displays record numbers.
how to identify my job when i use SORT command.
plz help me in identifying job.
cheers;
saama
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What are you trying to accomplish?
The join between DS_JOBS and DS_JOBOBJECTS is made as
The join between DS_JOBS and DS_JOBOBJECTS is made as
Code: Select all
DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
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.
Hi,
thanks guru.
i just wanted to view transformation used in the jobs from the command line utility, the metadata, the source table and target table used.
can we find these details of my job from command line utility.
my team lead wants to know that.
once again thanks.
my design is odbc---->transformer--->odbc.
thanks.
cheers;
saama
thanks guru.
i just wanted to view transformation used in the jobs from the command line utility, the metadata, the source table and target table used.
can we find these details of my job from command line utility.
my team lead wants to know that.
once again thanks.
my design is odbc---->transformer--->odbc.
thanks.
cheers;
saama
You find yourself at the top of a cliff. Before you are two paths to your objective at the bottom:
A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route.
B) A shiny new express elevator.
You have chosen... A.
A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route.
B) A shiny new express elevator.
You have chosen... A.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
I mean real LOL...Uncontrollably.chulett wrote:You find yourself at the top of a cliff. Before you are two paths to your objective at the bottom:
A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route.
B) A shiny new express elevator.
You have chosen... A.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How about you tell your team lead that the answer is "no"?
After all, SQL can not be executed directly from the command line, and the table definition of DS_JOBOBJECTS is made deliberately incomplete by the vendor.
But you might like to use the -report option with the dsjob command.
After all, SQL can not be executed directly from the command line, and the table definition of DS_JOBOBJECTS is made deliberately incomplete by the vendor.
But you might like to use the -report option with the dsjob command.
Code: Select all
dsjob -report [-useid] <project> <job|jobid> [report type>]
report type = BASIC | DETAIL | XML
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.