select * from DS_JOBOBJECTS doesnot list all columns
Moderators: chulett, rschirm, roy
-
zulfi123786
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
select * from DS_JOBOBJECTS doesnot list all columns
when i run this query in DataStage Administrator "select * from DS_JOBOBJECTS where OBJIDNO='7244' " it is not listing all columns from DS_JOBOBJECTS....
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You are correct. It doesn't. That's not the way UniVerse - and therefore the DataStage Engine which is based on UniVerse - works.
The columns displayed by the asterisk are defined in the file dictionary using a phrase entry called @SELECT or, if that is not present, by a phrase entry called @ or, if that is not present, only the key columns are displayed when * is specified as the select list.
The columns displayed by the asterisk are defined in the file dictionary using a phrase entry called @SELECT or, if that is not present, by a phrase entry called @ or, if that is not present, only the key columns are displayed when * is specified as the select list.
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.