Table/view/trigger/procedure does not exist

[onmalik]

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 comes an error when i go to see the log file to find out the error. i find an error which is really straightforward and easy to understand and should have an easy solution but dats not the case

however here's the error...

**** 12:07:38 UTY0817 MultiLoad submitting the following request:
BEGIN MLOAD TableName;
**** 12:07:38 UTY0805 RDBMS failure, 3807: Table/view/trigger/procedure 'TableName' does
not exist.

but when i create the table then it gives the error that the table already exits...

Now it has a problem when the table is not there...and it has a problem when the table is there...

Any Prompt Solutions would be highly appreciated...

Regards...

[ArndW]

It looks like you have neglected to specify a Schema and the mload defaults to a different schema and thereofore the table is not being found.

[onmalik]

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

[ArndW]

Ok, what are your load options set to? Are you trying to do a delete table in there and do you have sufficient SQL permissions for all actions you intend?

[onmalik]

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,

[ArndW]

I guess we have different ideas of clarity, then.
What happens when you manually start the teradata mload from outside of DataStage?

[onmalik]

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;
.field C1 * varchar(50);
.field C3 * varchar(50);
.field C5 * varchar(50);
.field cust_id * integer;
.field acct_start_date * date;
.dml label tdmload;
insert DBName.MultiLoadedData (C1, C3, C5, cust_id, acct_start_date)
values (:C1, :C3, :C5, :cust_id, :acct_start_date);
.import INFILE \\.\pipe\tdmpipe_DSLink11.DBName.MultiLoadedData AXSMOD np_AXSMOD.dll format fastload layout internal apply tdmload;
.end mload;
.if &SYSETCNT then;
.logoff 20;
.endif;
.if &SYSUVCNT then;
.logoff 20;
.endif;
.logoff;

[onmalik]

Any Solutions ppl !

[ray.wurlod]

Etiquette Note
If you want solutions urgently sign up with your support provider for premium service. Learn the true cost of "urgent". This is an all-volunteer site; those who have answers post as and when they can.