DSjob runs fine when using a table but fails using a view

Hope · Post by **Hope** » Mon May 21, 2007 1:32 pm

My datastage job pulls data from a teradata table and writes it to flat file.
This table exists in DEV and TEST but is not present in Production.
DBA has created a view instead of a table.
This view is from 2 different tables.
This job runs fine using the table on Dev,Test but fails when using the view.
The director log says Invalid password. It drops all the columns.
I am not sure if it the password issue or the view which is not taking all the columns?.
Can anyone please help.

DSguru2B · Post by **DSguru2B** » Mon May 21, 2007 1:47 pm

Can you use the the same username and password and access the table from your favourite sql tool?

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2007 3:06 pm

If the log says invalid user name/password it's almost certainly invalid user name/password.

47shailesh · Post by **47shailesh** » Tue May 22, 2007 2:57 am

Confirm with ur DBA on which schema he has created the view....

Case might be the username/password you are passing to the DSjob may be for schema other than on which view resides...

chulett · Post by **chulett** » Tue May 22, 2007 7:08 am

That would cause a different error, specifically "Table or View does not exist". Your user/password is wrong for the instance you connected to, period. And DataStage doesn't care if you source from a View or a Table, it all works the same.