Could not see the table while importing the table in DS

anandkumar442 · Post by **anandkumar442** » Thu Oct 13, 2011 2:30 am

Hi ,

I have requirement to load the data from source table to a temporary table. I created a table, and am able to select,describle it in Database. But when I try to import the table definition through DataStage, I could not see the table.

Even, when I run the job by defining table definition manually, its aborting with the below error:
Write mode failure: Table_Name doesn't exist.

Could you please let me know, where the issue is .

Thanks,
Anand.

suse_dk · Post by **suse_dk** » Thu Oct 13, 2011 2:59 am

Did you create a local or global tmp table?

anandkumar442 · Post by **anandkumar442** » Thu Oct 13, 2011 3:17 am

Hi Sussane,

Thanks for your quick response.
Its a global temp table only. I have already created such tables, which were importable. But this alone is creating a issue.

Thanks,
Anand.

suse_dk · Post by **suse_dk** » Thu Oct 13, 2011 4:20 am

...and your user are still connected to SQL server when you try to import the table?
...and the DS user have the right permissions for the database?

anandkumar442 · Post by **anandkumar442** » Thu Oct 13, 2011 10:40 am

suse_dk wrote:...and your user are still connected to SQL server when you try to import the table?
...and the DS user have the right permissions for the database?

Hi Sussane ,

Thanks for your support.
Actually, there was change in the DSN of the Database. New DSN has been added. Now its resolved.

Thanks,
Anand.