Use the foll:
db2 load Client from <Source file name> of del Modified by COLDEL, UseDefaults Messages <Error file name> insert into LOAD.T_ORDERS NONRECOVERABLE
Client specifies that you are running the LOAD command from a client m/c.
del specifies that the file is delimited.
Coldel, specifief that the column delimiter is comma(,)
insert says that the records are to be appended (insert) to the...
Jal
Last Activity: Mar 17 '08, 06:23 AM
Joined: Aug 16 '07
Location:
-
Rahul,
locklist is configurable online, hence you dont need to re-start the server. But increasing the locklist size may not be the only solution. You should also consider
1> doing frequent commits to release the locks
2> If application integrity requirements are not compromised use Uncommitted
Read to decrease the amount of locking.
JalajLeave a comment:
-
I trust db2clp more. GUI features from IBM are not worth talking about. They are painfully slow.
I know why people dont like the command line. An easier way out is to use the option db2 -t to get into the db2 environment (This enables ; as sql command terminator, so you can write multiline sql queries. Remember to end yr queries with a ; semicolon).
Write and edit you queries in a notepad, copy and paste to the db2clp to run the command....Leave a comment:
-
Hi,
If you are running the LOAD utility from a client machine then you need to specify the keyword CLIENT.
You can build your LOAD command around the following example:
Load CLIENT From /home/Data/datafile.dat of del Modified by COLDEL, UseDefaults Messages /home/log/datafile.err insert into koes.orders NONRECOVERABLE;
del - delimited
COLDEL specifies the column delimiter, the (,) comma following...Leave a comment:
-
Looks like you are using DB2 Command editor. Instead try using db2clp.
To Invoke db2clp type db2cmd in the Run window or on the command line.Leave a comment:
-
Arnold,
execute the foll command:
GRANT EXECUTE ON PACKAGE NULLID.SQLC2E07 TO USER FADAPP;
there would be some packages, you need to grant execute on all.
This has to be done by someone who has DBADM authority on the Database
JalajLeave a comment:
-
Hari,
What is the error that you get? do you get a timeout?
Index will only help you to access the data faster. it won't help you fetch data you are not able to fetch now.
Pls check the data or the Function you have written.
JalajLeave a comment:
-
Rahul,
Create your table or view with the defualt clause on the Column which you want to have null value.
Create table test (
Col1 Char,
Col2 Int,
MyNullCol Char DEFAULT NULL
)
JalajLeave a comment:
-
AFAIK Alter Column only works for Varchar in DB2. Hence you cannot alter a decimal column.
If this is urgent, then create a new table and move the data to the new table and then drop the old table.
Jalaj...Leave a comment:
-
Generated Column
I want a generated column which will have the current date as well as a running number concatenated yyyymmddxxxxxx
where xxxxxx is a running sequence.
Can I use a SQL query to generate the sequence No? I tried the follwing, but even something as simple as this doesnt work. It doesnt take Current date in the expression.
CREATE TABLE JS.TEST (
C1 INTEGER NOT NULL GENERATED ALWAYS AS (select month(current...
No activity results to display
Leave a comment: