By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,719 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,719 IT Pros & Developers. It's quick & easy.

Error code for Export

P: n/a
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.

Nov 20 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.