I am currently using DB2 . I do not know much about load statement. I am using this query to load data..
LOAD FROM "IXAC.CSV" OF DEL METHOD P ( IX ,1,2,3,4,) MESSAGES "SYAC.MSG" INSERT INTO SYNC.AC_COUNT ( "TYPE", AC1, AC2, AC3, AC4 ) ; COMMIT;
在“IXAC.CSV”中,有4种与 com相分离的 in。 我的问题是,如何在每行加一字后插入附件九。
我对此进行了尝试,但没有取得任何成功。 我在数据库中更新。
Help me .. Thanks in advance ...
改变数据库中的表格定义,使第九栏的缺省值(如你想要的“贫穷人口”?)
然后,负荷正常,排在第九栏。
如果您能够编辑.csv的工作文件,则您可以使用一个文本编辑(如超代版),支持野心或在其发现/替代特征中经常表述,并以“九”取代每批运输回程/线,(如果你想具体写一个文字说明,可以选择)。 然后,您的卷宗将掌握所有数据。
SQL Server question. When doing INSERT INTO T1 SELECT (C1, C2) FROM T2 I don t want to specify column names of T1 because they are the same as in T2 Is it possible to do so? Currently I m getting ...
I need to duplicate a row a couple thousand times. I need to change one column from the copied row based on a list of ids. Psuedo-code: INSERT INTO MyTable (TabID, Other Columns) VALUES (TabID = (...
I ve been battling this for a while. I m trying to implement a many to one association. I have a bunch of rows in a table, called readings. These accumulate over time, and every now and then I want to ...
After I copy mdf file (and his log file) I tries to Insert data. I receive the following message: "An attempt to attach an auto-named database for file [fileName].mdf failed. A database with the same ...
I have this table: CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (P_Id) ) 1. insert into ...
I have a temp table (question_desc, ans1, ans2, ans3, ans4, correct_ans, marks) with say 10 entries. From this table I have to insert values in two other tables: questions (q_id(auto-generated), ...
I am trying to work out the best way to stop double booking in my application. I have a table of unique id s each can be sold only once. My current idea is to use a transaction to check if the ...
I have created a database where I use uniqueidentifier as the primary key. I m trying to run a parametrized query that in the end looks like this. (insert into someTable (uniqueID) Values( 76c14693-...
