Error code for Export

[chaitu]

Hi,

Can anybody tell me what the error code for Export is. Like i get the
message

SQL3104N The Export utility is beginning to export data to file
"/home/db2as/sqllib/bluee_tables1/DBCHECK.ixf".

if it is beginning to export and

SQL3105N The Export utility has finished exporting "1" rows.

if it successfully completes Export.

What is the SQL error code if it fails to Export and what does the
error exactly say?

Thanks in advance.

[truthinlife@yahoo.com]

Re: Error code for Export

Mostly an informational message:

db2 ? SQL3105N


SQL3105N The Export utility has finished exporting "<number>"
rows.

Explanation:

This is the summary message for the export utility which is
printed at the end of the message file. This message will state
how many rows resulting from the SELECT statement were processed
before the export utility terminated.

User Response:

If an sqlcode of 0 was returned from the utility, then no
response is required. If an sqlcode of 3107 was returned, check
the message file for warnings that occurred during the export and
resubmit the command if desired. If a negative sqlcode was
returned, an error occurred during the export and the data file
may not contain all the data requested. The command should be
resubmitted with the error corrected.

chaitu wrote:

Hi,
>
Can anybody tell me what the error code for Export is. Like i get the
message
>
SQL3104N The Export utility is beginning to export data to file
"/home/db2as/sqllib/bluee_tables1/DBCHECK.ixf".
>
if it is beginning to export and
>
SQL3105N The Export utility has finished exporting "1" rows.
>
if it successfully completes Export.
>
What is the SQL error code if it fails to Export and what does the
error exactly say?
>
Thanks in advance.