Hi,
Is it possible to run the db2 utility to load or import rows from Java?
I cannot find the correct command line structure.
Thanks in advance,
Alejandrina
5  7790 
apattin, pls try "Admin_CMD" procedure, I wish it will be fit for you.
For detailed information, pls refer to information center.
apattin 写道：
Hi,
Is it possible to run the db2 utility to load or import rows from Java?
I cannot find the correct command line structure.
Thanks in advance,
Alejandrina
Thanks for the tip. It does not support load or import, though. Does
anyone know another way?
Alejandrina
Hardy wrote:
apattin, pls try "Admin_CMD" procedure, I wish it will be fit for you.
For detailed information, pls refer to information center.
apattin 写道：
Hi,
Is it possible to run the db2 utility to load or import rows from Java?
I cannot find the correct command line structure.
Thanks in advance,
Alejandrina
apattin wrote:
Thanks for the tip. It does not support load or import, though. Does
anyone know another way?
A stored procedure wrapper for the LOAD API call is described here: http://www-128.ibm.com/developerwork...dm-0505stolze/
You could further parameterize this or adjust it to IMPORT if required.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
THIS IS IT! Thank you so much.
Knut Stolze wrote:
apattin wrote:
Thanks for the tip. It does not support load or import, though. Does
anyone know another way?
A stored procedure wrapper for the LOAD API call is described here:
http://www-128.ibm.com/developerwork...dm-0505stolze/
You could further parameterize this or adjust it to IMPORT if required.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
apattin wrote:
THIS IS IT! Thank you so much.
Knut Stolze wrote:
>apattin wrote:
Thanks for the tip. It does not support load or import, though. Does
anyone know another way?
A stored procedure wrapper for the LOAD API call is described here:
http://www-128.ibm.com/developerwork...dm-0505stolze/
>>
You could further parameterize this or adjust it to IMPORT if required.
Just remember that there is also a more powerful DB2LOAD procedure already
available in DB2. It was described here in this group in more detail a
while ago.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: dB |
last post by:
I want to load an applet locally from the client's hard drive from an
html/jsp page served by Tomcat on the local machine or a remote server.
The motivation is that I need to print to the local printer, but don't
want to fork out $$$ for a cert.
The applet is simple, and is only being used to try this whole scheme out.
Here it is:
// -------------------------------------------------------
import javax.swing.JApplet;
|
by: Andrew James |
last post by:
All,
I'm having some trouble with understanding python's importing behaviour
in my application. I'm using psyco to optimise part of my code, but I'm
not sure whether it inherits throughout the rest of my application (read
this as for any imported module) if I import in in a 'higher-level'
module. For example:
A.py
====
|
by: atlantis |
last post by:
Hi,
I have a very strange problem with xsl:import when usig RELATIVE path
on AIX 5.2 server.
I have two XSL files in the same directory: "ists_xslt3.xsl" and
"ists_xslt3_layout.xsl". This is what the beginning of "ists_xslt3.xsl"
looks like:
|
by: DB2 Novice |
last post by:
I am trying to use DB2 Control Centre (version 8.2) to load one flat
file into multiple tables. However, I don't see the options in Control
Centre that allows that.
Anyone knows how to do this?
DB2 Novice
|
by: usenet |
last post by:
Hi.
Can any of you explain the major differences in LOAD and IMPORT in
laymen terms?
I've read the DB2 docs: " Inserts data from an external file
with a supported file format into a table, hierarchy, or view. A faster
alternative is LOAD; however, the load utility does not support loading
data at the hierarchy level."
| | |
by: skchonghk |
last post by:
Dear all smart experts,
I write a simple Java UDF, which should run on DB2 v8 on AIX. But it can't load the Java class. Help ugently needed!! Thanks!
I develop and deploy the Java UDF with these steps:
1. Write the java class, compile and make a jar (see below for source).
2. Call SQLJ.REPLACE_JAR ('file:/home/pws01ta/pws01ta1/examples.jar','test',0)
3. call sqlj.refresh_classes()
4. Create the function by running "create function...
|
by: asenthil |
last post by:
Hi guys,
I have got a question regarding LOAD DATA INFILE. Can some one save my day.
1. I want to import a txt file into mysql database.
when I use the following query in the mysql> prompt its fine.
which is
when I do it java I am getting error
|
by: owz |
last post by:
I am trying 2 load details about cars from a.txt file
and then display the total stock value off all cars.
public class Car
{
// attributes
private String manufacturer;
private String model;
|
by: ponvijaya |
last post by:
Hi all,
We are using import command as
import java.io.*, import java.util.* etc in the program.
Consider i am having a class A.
Is there any difference related to Memory consumptions for class A while writing import command as
import java.util.HashMap ; rather than
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
