I have saved the table definition in datastage and it got saved in the repository.
I want to list the column names present in the table definition from the command line. Is there any command which lists the field names of the table definition from the command line like dsjob ??
Please provide your inputs..
How to get the table definition infomayion from command line
Moderators: chulett, rschirm, roy
How to get the table definition infomayion from command line
IBM Certified - Information Server 8.1
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Table defintiions in the local repository are stored in a hashed file, so you need a database query to retrieve them.
From the command line you can execute this query from the dssh command provided you have first executed the dsenv script.
Code: Select all
SELECT DSRID FMT '32L',EVAL "@RECORD<12>" FMT '32L' COL.HDG 'Column Names'
FROM DS_METADATA
WHERE @ID NOT LIKE '\%' DBL.SPC;
From the command line you can execute this query from the dssh command provided you have first executed the dsenv script.
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.