What is the SQL command to list all tables in a database?
What is the SQL command to list all columns in a table?
i have a field in db2 table which is of type date
the field content is 28.08.1997
while selecting the field i want it to be retrived it as 28081997 ie i want to remove the seperators an...
Hi,
I'm new to DB2. I'm trying to create the following stored procedure for my DB2 database:
CREATE PROCEDURE audit_event_remove_sp (IN v_cutofftime TIMESTAMP)
RESULT SETS 1
S...
( Product : DBMS -> ORACLE, DB2 and SQL Server )
Hi Experts,
I want to know the difference between the functions SYSDATE, CURRENT_DATE, CURRENT_TIMESTAMP in ORACLE, DB2 and SQL Server.?
...
I like to use inner join and outer join among multiple tables on UDB...
For this, I wrote below, but it basically picking up too many duplicated records. basically I do not like to have dupli...
it says how can i clear and incrrease it it plz give steps
thanks
bobby
SQL0964C The transaction log for the database is full. SQLSTATE=57011
hi guys
I have a store proc like this
>>>>>>>>>>>>>>>>>>>>>>
CREATE PROCEDURE RETRIEVE1600
(
IN I_DOC_FEE_CODE CHAR(4),
IN I_EFF_START_DATE D...
Hello experts,
I am new in DB2. How can I store a Credit Card Expiry date (MM/YY) in DATE format?
And what is the correct syntax to insert a date, in various format?
Thanks in advane for...
Hi, I need to retrieve data from a DB2 table daily in a SSIS pacage (SQL Server 2005). I need to filter data by matching a Date column (F1) with Yesterday's date. This Date field F1 contains d...
I've tried several commands to do a describe for a table. I can't find one that works. I've tried using DESCRIBE TABLE schema.tablename and it doesn't work. What I'm I missing? This should...
Hello,
I've two tables, one called westpac_data and the other called pol_policy. The linking field between those two tables is cardnbr on the westpac_data table and plc_bill_acctnum on the...
Dear experts
A schema in DB2 refers to a qualifying name used to group objects together within a database.
from the above statement what exactly is schema in laymans terms. what objec...
Hi all,
I am trying to find empty tablespaces - tablespaces with no tables - in my DB2 Z/OS environment and from my control center. The script that I am using is returning error code -206. Th...
After I load a table with these commands:
db2 load from c:\data.txt of del warningcount 1000 messages i:\data.log replace into schema.tablename
db2 load from c:\data.txt of del terminate...
I'm familiar with how to write Oracle stored procedures. Would someone be willing to write an equivilant DB2 stored procedure for the following:
CREATE OR REPLACE PROCEDURE simple_usp(
...
Dear experts
I am using Db2-ExpressC
In the db2 command editor i am trying to create a table and insert records in that table.
I have done that in oracle but am new to db2. this is my tab...
any way i can around this query
select ICRTDT ,
substr (cast (int( ICRTDT)+20000000 as char (8)), 1, 4) || '-' ||
substr (cast (int( ICRTDT)+20000000 as char (8)), 5, 2) || '-' |...
Hi experts,
This should be the simple question.
I am calling db2 stored procedure having output parameter from the command prompt.
How to display (ECHO) the output parameter value of ...
Problem with DB2 DATETIME data retrieved and placed in a vb.net string variable, then attempting to convert back to datetime in an update query.
Example:
A Datetime column has data that...
I'm wondering what I can code in DB2 so it's something like:
BETWEEN '2007-02-04 00:00:00' AND 'TODAY'S DATE'
hello every1,
in my table, there is a column called submittime, the value for this column is the current time when the row was created.
my questions is, after certain time, say one year,...
1) What are the default isolation levels of DB2. How do we access this from GUI and command line or is it just a setting in sql.ini file etc.
2) How do we change isolation level for entire ...
I have installed DB2 v 8.1 on my system. When I try to execute the command "db2start" from the command prompt, I get the following error:
-----------------------------------------------------...
I am using DB2 database as a back-end for PB70. I want to concatenate two fields from a table out of which one is string and the other is numeric.
I tried following sqls (Field1 is string;...
[IBM iSeries running AS400]
I created the following stored procedure:
=======
CREATE PROCEDURE TBLNAME.proc_test (IN p_custnum VARCHAR(8),
...
