470,591 Members | 2,170 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Error code for Export

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

Similar topics

3 posts views Thread by Russ | last post: by
reply views Thread by Leonard Danao | last post: by
3 posts views Thread by Peter | last post: by
2 posts views Thread by linq936 | last post: by
1 post views Thread by Willard Farwark | last post: by
reply views Thread by arial | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.