Page 1 of 1
select * from DS_JOBOBJECTS doesnot list all columns
Posted: Sun Sep 06, 2009 1:42 am
by zulfi123786
when i run this query in DataStage Administrator "select * from DS_JOBOBJECTS where OBJIDNO='7244' " it is not listing all columns from DS_JOBOBJECTS....
Posted: Sun Sep 06, 2009 2:44 am
by ray.wurlod
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.