DB2
in [SQL]
|
Database Application Front End Hey, I have been studying and working on databases for quite a time now. I know quite a lot about databases. Now I have been assigned a project where I have to build an application using the database. I know all the work to be done with database. The cause of worry is front end of the application. Since I have n... 19 Jun 2008 01:14
convert a decimal number into character hi , I have a column with datatype as decimal(31,2) . The data is like 123456.67 , 7634578.99 Is it a way to convert the entire number into character . like '1232456.67' . The output should not be like as below : db2 => select char(decimal(BAL_PRINCIPAL,31,2)) from BIKASHK.RPT_BA_PAD331 where integer(Ba... 7 May 2008 08:31
parameter limit for XML datatype Hi, I want to pass a 2-3GB file as a parameter (XML type) to a Stored procedure. Is that possible? What is the max limit of parameter size for XML datatype? Thanks. ... 7 May 2008 06:40
Shift_JIS to UTF-8 Conversion Hi All, I've a small requirement, wherein I need to convert the data in Sybase from Shift_JIS to UTF-8 while migrating it to DB2. How can I accomplish this? Thanks Srikanth ... 7 May 2008 04:18
db2 connect 4 minut delay after adding partitions Hi! I have a previous post on the subject that connect takes a long time. I uninstalled db2 completely. Installed V9.5 Installed fixpack 1 created das created an instance installed database sample. Tested to connect to sample from DB2 CC - Worked OK Stopped db2. configured UDB to use Openssh following Lia... 7 May 2008 01:56
Again against generated columns or (missing) row value constructor in where clause Table definition: CREATE TABLE "SCHEMA1 "."X2" ( "C1" CHAR(20) NOT NULL , "C2" CHAR(10) NOT NULL , "C3" CHAR(30) NOT NULL GENERATED ALWAYS AS (C1|| C2) ) IN "USERSPACE1" ; -- DDL Statements for primary key on Table "SCHEMA1 "."X2" ... 7 May 2008 10:08
Looking for SQL statements database I am working on a piece of code which analyzes the execution plan of DB2 SQL statements. In order to test it, I need a set of statements (and the definitions of the objects to which the statements refer)which cover as many execution plan options as possible (different operator types, different options, diverse p... 6 May 2008 23:24
Date function in DB2 V8.1 for Z/OS I need to get the first day of the previous month in a query. I thought CURRENT DATE and DAYOFMONTH would allow me to da it but it is noe WHERE DTXL >= 1st day of previous month Anyone got a good idea? ... 6 May 2008 23:24
db2 v8 Hi, At what point in the range of db2 v8 fixpaks do they start referring to it generally as db2 v8.2 (vs 8.1)? Thank you ... 6 May 2008 22:20
How to add leading zeroes I have the following column: 1.4.1 1.10.1 1.10.1.2.2 1.22.99.1 2 2.8.11 2.7.7 I am trying to add leading zeros to every part before dots, to make them 3 digit numbers: 001.004.001 001.010.001 001.010.001 001.022.099.001 002 002.008.011 002.007.007 My first try did't ... 6 May 2008 22:20 |