Hi All,
Iam running a job which extracts data using a hash file from universe database(data is in different partitions) to load into a sequential file.
In hash file after giving details of the partition, columns, When I entered key column value in Selection tab for extracting a specified single row, I get an error when I selected view data " unexpected explicit item id". Without specifing anything in Selection, I can view data.
I think its a problem in the dictionary of that filename. As the syntax is working for another partition.
error reading data from universe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try either of the following.
(1) Put the key value on the Selection tab inside single quotes.
(2) Replace the explicit key value with an appropriate clause (a WITH clause (without the WITH) for a Hashed File stage, a WHERE clause (without the WHERE) for a UV stage).
(1) Put the key value on the Selection tab inside single quotes.
(2) Replace the explicit key value with an appropriate clause (a WITH clause (without the WITH) for a Hashed File stage, a WHERE clause (without the WHERE) for a UV stage).
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.
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Re: error reading data from universe
Hi,pkomalla wrote:" unexpected explicit item id".
This error comes when you specify wrong column in select tab.
Please see column name in column tab of hash file and specify correct column name in selection tab.
Thanks,
Anupam