Search found 5 matches

by onmalik
Thu May 25, 2006 5:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table/view/trigger/procedure does not exist
Replies: 8
Views: 2644

Any Solutions ppl ! :idea:
by onmalik
Mon May 22, 2006 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table/view/trigger/procedure does not exist
Replies: 8
Views: 2644

the problem still remains... here is the script generated by datastage... .logtable DBName.LOGMultiLoadedData; .logon testing/DBName,PASSWORD; .begin import mload tables DBName.MultiLoadedData WORKTABLES MultiLoadedData ERRORTABLES ErrorTableM1 ErrorTableM3 CHECKPOINT 0; .layout internal indicators;...
by onmalik
Thu May 11, 2006 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table/view/trigger/procedure does not exist
Replies: 8
Views: 2644

well my first post clearly described the scenario of wat i m trying to do...however in short i want to insert the data in a table in a database using multiload...and i have the permissions on the database i m trying to insert the data in...

Regards,
by onmalik
Thu May 11, 2006 4:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table/view/trigger/procedure does not exist
Replies: 8
Views: 2644

No Dats not the case i have specified the database in the teradata_multiload stage tab...

had it been the cause then it would have never given the second error of the table already exists!

Regards
by onmalik
Thu May 11, 2006 2:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table/view/trigger/procedure does not exist
Replies: 8
Views: 2644

Table/view/trigger/procedure does not exist

Assalam-O-Allaikom, i made a server job in DataStage,which has two sequential files and there is a transformer which performs a join on those two files tables and then muliloads the data in the db. Now the problem dat i m facing is dat when i compile the job it compiles fines but when i run it there...