473,396 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > sql0501n during import

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

SQL0501N during import

Receiving the following error when trying to run the following from a User
ID who has CONTROL on the table. This works fine when I run from an account
which has SYSADM privileges. It also runs when I use INSERT instead of
REPLACE. Anybody seen this one before?
db2 "import from /dev/null of del replace into hcsrods.tb_excp_provider"

SQL3015N An SQL error "-501" occurred during processing.

SQL0501N The cursor specified in a FETCH or CLOSE statement is not open.
SQLSTATE=24501

Thanks.
Nov 12 '05 #1
0 2401
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
Loading functions from a file during run-time
by: Bryant Huang | last post by:
Hello! I would like to read in files, during run-time, which contain plain Python function definitions, and then call those functions by their string name. In other words, I'd like to read in...
Python
8
How to specify Date format during LOAD DATA INFILE ?
by: Ray in HK | last post by:
Will it be possible to specify the date format of type DATE during data loading ?
MySQL Database
0
replication problem: target database cannot be accessed during replication
by: Markus Enders | last post by:
Hi everybody, we are using version 7 of db2 and need to replicate a database. We are using two web-based systems, which access two different databases. One system is used for import data...
DB2 Database
0
How to resolve foreign key change during import?
by: minjie | last post by:
Hello, I have to implement the following requirement: from an application, a user can export some info retrieved from DB2, and later import the info into another DB2 on another machine. The user...
DB2 Database
5
SQL0501N error in simple procedure
by: Yaro | last post by:
Hello I have odd problem with simple procedure (DB2. 8.1 FP10 Win32) CREATE PROCEDURE ADM.P_REORG_RUNSTATS(IN par_TabName VARCHAR(128), IN par_Reorg INTEGER,IN par_Runstats INTEGER) SPECIFIC...
DB2 Database
3
import conflict
by: rplzqx402 | last post by:
Hello, I have a problem where I need to set up two separate Python projects that each live under the same package. Once they are distributed, they will live under the same filesystem path, but...
Python
1
Type of __builtins__ changes from module import to execution?
by: Adam Hupp | last post by:
I've noticed some unexpected behavior with __builtins__ during module import. It seems that during module import __builtins__ is a dict but at all other times it is a module. For example, if...
Python
10
Different kinds of Import Errors
by: Thomas Guettler | last post by:
If you look at this code, you see there are two kind of ImportErrors: 1. app_name has no attribute or file managment.py: That's OK. 2. managment.py exists, but raises an ImportError: That's not...
Python
0
Re: Python -v import behavior
by: M.-A. Lemburg | last post by:
On 2008-04-30 18:42, Sean Ryan wrote: The -v option only causes Python to print more information to stderr explaining where it is looking for modules. You should be seeing any dynamic loader...
Python
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!