I've got a strange situation in one of my database tables. I started getting errors stating that the identity column's size wasn't big enough for the record about to be inserted. This is odd...
Can you please give me syntax for converting timestamp to date
thanks
I'm trying to write a trigger to capture data and insert into another table for auditing purposes.
I'm getting the following error:
-- [IBM][CLI Driver][DB2/NT64] SQL0797N The trigger "LYNX...
My task of Migration according to following process is completed, DB2 9.5
On AIX
1) db2 move sampleDB export
2) db2 look -d sampleDB -e -l -x -a >DB.dll
3) db2cfexp Config.out backup
On W...
I want to retrieve the PK column immediately after an insert. I know in SQL to do this is scope_identity or @@identity. But how do I do it in DB2 (in a stored prc)? Code example please.
...
we can call module through callb
can we call procedure through callb opcode?
I am looking for a utility that will be able to insert new records or update records from an input file in MS SQL Server 2005.
Also is there a bulk insert that will insert new records but s...
HI
If I have declared a field as
db2 create table tablename(fieldname timestamp)
can i insert a data 00:00:00 into that field? I need to import from csv which has a field in this format
Hi Experts,
We got this old application here and it's on AS400 using a back end DB2 database.
I'm using MS access over ODBC to get the result of queries and display fancy reports.
so far Ev...
Hi,
I have a file called Dept.txt in C drive on Windows XP.I want to import it to the Dept Table defined on DB2 UDB.Below is the syntax i'm using. But it's not working at all.Can someone ...
I want to know which procedures are using DB2 table called EMP. How to do that using select statement. I know the following show me all the tables for different schema. Thanks.
select *...
In Oracle you can use a special type of outer join - a partitioned outer join - to fill gaps in sparse data. Is this function available in DB2?
Our accounting system runs on Server 2003 and uses a Unidata 6 database. Sometimes, at seemingly random times but not every day, when I stop the database services (there are three of them) to ...
I need some DB2 SQL that will return me the equivalent of java's System.currentTimeMillis(). When I run it in Java I get a 13 digit number. I need that same number, but from DB2. This is CL...
Hi,
I need to select records where value is not null, and not empty. Is there any function like
if (not isEmpty(name) )?
If not, what is the best way to handle it (for all data typ...
Hi Experts!
Not familiar with DB2 .. how do you look at CURRENT DATE 7 DAY?
This will throw an error:
select *, CURRENT DATE 7 DAY AS minDate, CURRENT DATE 6 DAY AS maxDate, DAT...
Problem background:- I need to populate VFMINSTR.EXCHRATE(tablename.col name) from BOTMFXINSTR.CONTRARATEDESC. Fkey relation bet both table exists on VFMINSTRKY = BOTMFXINSTRKY.
Datatype VFM...
Hi,
I need to create a DB2 procedure to add about 14 numbers (if they are positive)
example
set result=0;
if num1 > 0 then
set result = result + num1;
end if;
if num2 > 0 then
...
I have a Universe server and I can currently get UV/ODBC data from it to other servers and applications on my local network using our local IP 172.16.x.x .
To set this up initially you have...
1) Can you post good link(s) on what predicates will pick index and what not?
2) Under what circumstances with LIKE clause predicate pick an index?
3) How can rewrite queries so that for pr...
Hi Experts,
Need to install MS OLE DB Provider For DB2 on my XP Pro puter, but getting an error msg becuase I've SNA server installed (not sure what that is).
According to the doc this i...
hi guys
I have a query like this
SELECT
concat(concat(CUST, '-'), CUST_TO) AS "id"
FROM schema.Customer A
WHERE A.custId = '111'
Group by CUST,CUST_TO
but the re...
Hi there.
I am trying to remove duplicates getting error below
delete from (select DISTINCT TRIM(COALESCE(CHAR(A.AA),'*'))||':'||TRIM(COALESCE(CHAR(A.BB),'*'))||':'||TRIM(COALESCE(CHAR(A.C...
Is there any script to find out what procedures executed recently in DB2 ?
I want to extract data from a db2 table into an ascii file, delimited by the TAB character.
I also want to take in a tab delimited file of data in the appropriate format and load it into a ...
