|
by: Carmine |
last post by:
I'm getting this error when I submit the job:
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LOADSQL
DSNU005I DSNUGPRS - EXEC SQL
DSNU082I DSNUGPRS - INVALID KEYWORD - EXEC
DSNU005I DSNUGPRS - DECLARE C1 CURSOR FOR SELECT * FROM LIQ53TST.TLS_BRANCH
DSNU005I DSNUGPRS - ENDEXEC
DSNU005I DSNUGPRS - LOAD DATA
DSNU005I DSNUGPRS - INCURSOR(C1)
DSNU005I DSNUGPRS - REPLACE LOG NO
|
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: PRS |
last post by:
Why does 'SELECT * FROM countries' truncate characters and SELECT country
FROM countries does not ?
mysql> SELECT * FROM countries;
+-------------+-----------+
| country | capital |
+-------------+-----------+
|ghanistan | Kabul
|lbania | Tirane
|
by: Sumanth |
last post by:
Are there any implementations of truncate in db2. Is it going to be
implemented in the future?
Is there an alternate way of doing a truncate of a table that has a high
record count without using "load" and is fast?
Thanks,
Sumanth
|
by: asheesh.rastogi |
last post by:
Hi,
I am running DB2 UDB 8.2.4 on AIX 5.3. We are in process of migrating
huge chunks of data as part of benchmarking exercise. I need to collect
statistics like CPU time and total time taken to load data. We are
using DB2 LOAD to load data into tables. I have shifted through the DB2
manual but all I can find is the -v option of the CLP, which only gives
me the total time taken to load the data. Is there anyway to capture
CPU time...
|
|
by: damezumari |
last post by:
I would like to know how many of the visitors to my site has js enabled
and how many has it turned off.
I haven't found a simple solution searching Google groups so I suggest
the following using php and mysql:
Create a table mc_jscount table in mysql with two fields nonjs (int)
and js (int). Create one record with nonjs and js set to zero.
Put this code at the top of your page:
|
by: TMN |
last post by:
Hi All
I am new to PHP and I do not understand why the following works ??
$file=urlencode("displayIncidents.php");
echo "<a href=statistics.php?fileName=$file&delete=true>Delete
Incident</a><br />";
When this link is selected the statistics.php simply includes the file
that passed to it - but why does it find the file and not try to load
|
by: Eric Davidson |
last post by:
I am try to find a way to get load to reject a record if the data is
too large and not just truncate it.
eg.
c:\temp\fred3.txt
------
a23456789012345678901234567890
b23456789012345678901234567890b234567890
|
by: Henry J. |
last post by:
I know that we can use import or load to truncate tables without
filling up trans log in DB2. Is it possible to do this in a stored
procedure? How about in CLI/C++? My impression is that import/load
are not SQL statements, hence may not be included in stored procs or
called from CLI. Is that correct? I tried to use import/load in a
stored proc and they were rejected as syntax errors.
If it is the case, we'd have only one option,...
|
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: 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 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: 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.
|