Hi,
My job design is as follows,
View (source)(DB2) --------> Transformer ----------> Target table (DB2)
-
Lookup view (DB2) ---------------
While running the job I m getting error as "Error retrieving system catalog information for requested tables" "Invalid string or buffer length. SQLSTATE=HY090". Though I am able to view the data from all the view & the target table from datastage designer. Can you please help me in getting clue why this error is coming?
Thanks,
Bhaskar
Error retrieving system catalog information for table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 67
- Joined: Thu Apr 06, 2006 7:13 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you have the requisite SELECT privilege on the DB2 system tables needed to check table and column definitions, to verify that the metadata in your job design matches them.
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: 67
- Joined: Thu Apr 06, 2006 7:13 am
-
- Participant
- Posts: 67
- Joined: Thu Apr 06, 2006 7:13 am