DSXchange

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...

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.

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

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?

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,

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

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;

Any Solutions ppl !