473,287 Members | 2,263 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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 5114
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alex Wisnoski | last post by:
I am trying to adapt Lebans' ReportUtilities to export reports (to preserve formatting) from an Access 97 application. I have made the reference to his mde and copied the modules into my db. I...
3
by: Russ | last post by:
I have a page that uses crystal reports to generate reports from a SQl server database. As of a week ago everything was working fine, but now I am all of the sudden getting errors. To the best of...
2
by: drisso | last post by:
Hello, I have searched that error on these message boards, msdn and crystaldecisions.com. I found tutorials that showed how to export a crystal report to pdf, but like many others I am getting...
0
by: Leonard Danao | last post by:
Anyone have any ideas as to why this is happenning. There are no other versions of Crystal installed aside from the one that came with vs2003 enterprise. the error happens when the...
3
by: Peter | last post by:
VS 2005 Pro. I am getting the following error when I try to export a report to PDF or any other format using Crystal Reports 11 library. Does anyone knows how to fix this problem, the same code...
2
by: linq936 | last post by:
Hi, I have this piece code, struct TriStr { MyString str1; MyString str2; MyString str3; TriStr(MyString s1, MyString s2, MyString s3){ this->str1 = s1;
1
by: Willard Farwark | last post by:
DB2 7.2. I do an export each night of important tables. Nothing else should be touching the DB at this time. About every 2 days I get the error below on the same tables most of the time. What...
0
by: arial | last post by:
Hi all, I am getting this error message while try to compile my application. I am using visual studio 2003 and crystal report 9.1.5000. I have some old application which is running fine but...
2
by: accessvbanewbie | last post by:
I keep getting an error stating OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET. This error just recently began to happen. I am exporting some records to excel into a preformatted report. The...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.