DSXchange

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

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.

My other jobs, based on similar logic are running fine.

Thanks to all of you. I have resolved the problem. Actually view name was very big, thats why this error came. So I just reduce the no of characters from the view name & now its running fine.

Thanks,
Bhaskar