I tried to load data into MySQL
The command I used is as below,
load data local infile 'c:/tmp_0124/COL_LIQ_RPT.del ' into table COL_LIQ_RPT fields terminated by ';' lines terminated by '\n'
In this command, it just describe how to seperate the field and the lines.
Now, I have a flat data, which character values are in ""
In MySQL load commad, could I add something...
zhif
Last Activity: Mar 17 '08, 02:57 PM
Joined: Oct 17 '06
Location:
-
how to 'terminate' the character data to remove ""?
-
zhif started a topic How can I export the data with del but don't wanna put "" ouside the character data?in DB2How can I export the data with del but don't wanna put "" ouside the character data?
Hello everybody,
I am trying to export the data from DB2 database to MySQL.
The command I used is
db2 "export to sys_state.del of del modified coldel; select * from sys_state"
But, I tried to modify the chardel to be blank, by default chardel for del is "". I tried to move it out.
So, I ever tried to use below command later on
db2 -x "select... -
The Question about REDIRECT RESTORE
I tried to test this process on my personal laptop. Could you help me to take a look where is the problem as below?
1. I created a source database, name: db100 <-- db2 create db db100
2. Collect the source database tablespace containers’ information <-- db2 list tablespace containers for 0 show detail
Then I got as below
Tablespace Containers for Tablespace 0
Container... -
Simple Query Questions
I just got the following questions
Q1. How can I create a list of tables in LETMAP with the row counts of each?
Q2. How can I get the database LETMAP's space? and the each table's space in LETMAP?
LETMAP is database name.
For Q1, I tried to use
db2 "select tabschema, tabname, (select count(*) from tabschema.tabna me) from syscat.tables"
When I execute... -
Possible reason for this message in db2diag.log (II)
What will the potential reason cause the following two error messages.
2007-04-13-10.41.26.994282-240 I117470C515 LEVEL: Error
PID : 57806 TID : 1 PROC : db2agentg (HAMDB2 ) 0
INSTANCE: db2inst1 NODE : 000 DB : LETMAP
APPHDL : 0-703 APPID: CF82B7D0.DD39.0 70411155341
FUNCTION: DB2... -
Possible reason for these two error messages in db2diag.log
I checked db2diag.log. There are the following two kinds of error messages
(I)
2007-04-09-14.23.06.313673-240 I50090C517 LEVEL: Error
PID : 54008 TID : 1 PROC : db2agentg (HAMDB2 ) 0
INSTANCE: db2inst1 NODE : 000 DB : CAT_DWGS
APPHDL : 0-604 APPID: CF82B7D0.C6B9.0 70409152519 ... -
Thanks sir. Indeed, like you said, after I uninstalled it, I did not delete the conatiners and nodes for the database when I uninstalled it.
So, after I deleted all the files in C:/Program Files/IBM after I did uninstall process and deleted C:/DB2, the default instance when I installed the DB2, the reinstall the SAMPLE database is successful this time.
Thank you very much.
Cheers, -
How can I connect to SAMPLE database?
I installed IBM DB2 Database for Window (Ver. 9) before.
Meanwhile, I installed the database SAMPLE.
Because I forgot my password, I uninstalled later on.
Several days ago, I reinstalled again. When I try to connect to sample database (db2 => connect to sample user db2admin), it shows,
SQL1013N The database alias "SAMPLE" could not be found. SQLSTATE=42705
However, when I tried...
No activity results to display
Leave a comment: