|
by: kk |
last post by:
Hello,
I am using the udb 8.1 task scheduler to schedule a load. Is there
any way to also schedule an OS command (win32) to delete the file
after the load? I have a python script that will do what I need, I
just need to call it after the load. One more question: is there
anyway to use the import (rather than the load) to import fixed width
data. It is scheduled every 10 minutes. I would rather insert and
update rather than load....
|
by: JS |
last post by:
EE instance DB2 v7.2.0 fixpack 3 on WIN2K.
I select some data from a table A and write it to a file using the COALESCE
function and whitespace as the null character:
eg coalesce(col1, ' '). This column has 10,000 nulls in table A.
Select count(*) from table A where col1 is null=10,000
Using the load utlity, I load the data file as follows into table B which
has not null constraint on col1:
LOAD FROM LOAD.TEST OF ASC
MODIFIED BY...
|
by: Prince Kumar |
last post by:
When running LOAD with "ALLOW READ ACCESS", I get the following error
if select is running againt the table (isolation UR).
load.sql
---------
db2 load from /u02/data/dly_d040817_test.dat of asc \
modified by implieddecimal nullindchar=Y \
fastparse anyorder \
METHOD L \(01 10,11 12,13 15,16 24,25 28,29 48,49 64\) \
MESSAGES /u02/load/msg/auth_detail.msg \
|
by: jane |
last post by:
I'm going to use cursor load to load 200GB data in my production
database.
My database has 2 partitions.
but I cannot find more info in the manual about this cursor load.
I'm concern about loading 200GB , this large amount of data, is there
any limitation?
|
by: claus.hirth |
last post by:
When I execute the following statment using the Command Center it
works:
LOAD CLIENT FROM 'Y:\\TheFixedWidthData.txt' OF ASC METHOD L ( 1 1,2
11,12 17) REPLACE INTO S00.TheTargetTable NONRECOVERABLE WITHOUT
PROMPTING
Yet when I try to execute the same statement in a PreparedStatement it
does not work, but gives me a SQLException:
|
|
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: John |
last post by:
Hi,
I tried to load a mixedmode dll (MC++) with AppDomain.Load(Byte ) in a C#
Client.
During the Load Process I got the following Exception:
System.IO.FileLoadException: Ausnahme von HRESULT: 0x80131019.
at System.Reflection.Assembly.nLoadImage(Byte rawAssembly, Byte
rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark)
at System.AppDomain.Load(Byte rawAssembly) ...
|
by: **Developer** |
last post by:
I have a Form (FV&C) containing a userconrtrol (CF&E)
I do a ShowDialog for the form and the form's Load calls a method of the
UserControl.
The first time I do this the usercontrol appears on the form as I'd expect
after the method had been run.
The second time I do this the usercontrol appears on the form as if the
usercontrols Load had last been run.
|
by: danfan46 |
last post by:
Hi.
I'm on DB2 9.5.0.1 on Linux AMD 64 and the database has four
partitions
where catalog is on partion 0 and user data on 1 thru 3.
After a load failure (path to load file was wrong) I cannot access the
tables, even though the loads have been rerun with success.
set integrity for ..table..
|
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, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
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: 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, and deployment—without 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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|