LIST OF DS_ TABLES

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

LIST OF DS_ TABLES

Post by karthi_gana »

All,

I am taking effor to get the list of all DS_ tables used in datastage. For this, I have gathered the table list from here and summarized the list for future use or keep this as reference for all the new developers (like me).

DS_CONTAINERS
DS_DATATYPES
DS_JOBS
DS_JOBOBJECTS
DS_METADATA
DS_ROUTINES
DS_STAGETYPES
DS_TRANSFORMS

If i missed any table (may be hashed file), add it here!
Karthik
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

I'm sure these have been listed before. Did you Search DSXchange?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
kmsekhar
Premium Member
Premium Member
Posts: 58
Joined: Fri Apr 16, 2010 12:58 pm
Location: Chn

Re: LIST OF DS_ TABLES

Post by kmsekhar »

Add One more Table for Design-Time Information
DS_TEMPnn

Miscellneous Table
DS_AUDIT
Thanks,
Sekhar
Top
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:
Contact vamsi.4a6

Re: LIST OF DS_ TABLES

Post by vamsi.4a6 »

could you please tell me where to run these queries?If it is in command prompt in which path i need to run the queries?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Developers don't really need to know about these tables. They seem to be falling into disuse in any case.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “General”