by: Rick |
last post by:
When using the load utility on a CSV file, it seems I always need to
edit the input file and add an extra comma after the last field in
order for MySql to parse the line properly.
I use a...
|
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...
|
by: Robert Schultz |
last post by:
I have a C/C++ file that I simply want to 'extract' a function from.
Something like: extract <function name> <c or cpp file>
I want it to return from the beginning of the function, to the end.
...
|
by: Ravi Ambros Wallau |
last post by:
Hi:
We developed a set of ASP.NET Web Applications that never runs in
stand-alone mode, but always inside a portal (Rainbow Portal). All modules
are copied on that portal.
My question is: load...
|
by: jrthor2 |
last post by:
I have a shell script I am trying to run that loads a table from a
control file. The file I am trying to load is delimited by the "}"
character. How do I set the delimeter code? Here is my load...
|
by: huyuhui |
last post by:
The following is a question of LOAD utility.
Question:
How does the DB2 enforce table check constraints for data added to
table with the LOAD utility?
A. With the BUILD phase of LOAD
B. With the...
|
by: Fabian Braennstroem |
last post by:
Hi,
I would like to remove certain lines from a log files. I had
some sed/awk scripts for this, but now, I want to use python
with its re module for this task.
Actually, I have two different...
|
by: Gregor =?UTF-8?B?S292YcSN?= |
last post by:
Hi!
I've tried LOAD .... INSERT INTO TABLE_NAME. The docs say about INSERT
option:
"One of four modes under which the load utility can execute. Adds the loaded
data to the table without...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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,...
|