DSXchange

Hi, I am facing an error while loading more than 6 million data. Iam working on datastage 7.5.1 A version. The requirement is something like, we have source data coming out from an oracle enterprise which undergoes some processing(lookup with other tables, etc) and it is being loaded to another Oracle enterprise in another schema. While loading to this oracle enterprise iam getting an error:

SQL Loader-2026: The load was aborted because SQL loader cannot continue.

An error has occurred within the external SQL loader, if I recall correctly the error message itself will point to a file on disk which, in turn, contains the detailed error message(s) which caused the job to abort.

There should be other errors logged as well that explain why it "cannot continue". And you need to find the .log file it generated which will have all of the gory details in it. From what I recall, this and the .ctl file it built will be in your 'scratch' area.