DB2

Select privilage on all the tables in a schema.
On Apr 28, 11:04 pm, Knut Stolze <sto...(a)de.ibm.com> wrote: Lennart wrote: On Apr 25, 9:02 pm, Gladiator <vkamalnath1...(a)gmail.com> wrote: Any Suggestions on the below scenario will be helpful to us. # There are 10 tables in a schema “S1” and  I have to give select privilege (Only read acce... 19 Jun 2008 01:14

How can I installed DB2TOP on my windows or Linux?
Hi all I will like to use DB2TOP for monitoring but have no idea how to install it on my machines - both windows and linux. My environment is DB2v8.1 fixpk 16 (windows and Linux) and a DB2v9.5 on a linux server. I have looked for db2top in the windows bin directory and could not find it. I downloaded DB2TOP... 19 Jun 2008 01:14

How to get list of database?
"Erwin Leonardi" <erwinleonardi(a)gmail.com> wrote in message news:f1fe3648-1579-4437-b553-c439f853a146(a)c65g2000hsa.googlegroups.com... Hi there, Suppose computer PC1 is my database server in which DB2 is running. I have an application running in computer PC2. The application PC2 will connect to DB2 in P... 19 Jun 2008 01:14

Please help win my bet with our DBA
Hi everyboidy. My DBA is saying that this problem can not be done by single query and it should be done in a COBOL programm. I bet him a dinner that it could be done in at least 3 different ways in a single query. So far i am done with 2 queries. Very intresting problem: Input Table: --------------------... 19 Jun 2008 01:14

Lock waits during online backup
michael.spoden(a)web.de wrote: Thanks Mark, thanks Jayesh. I've found the following in the manuals about the online option in the backup command: 'During an online backup, DB2 obtains IN (Intent None) locks on all tables existing in SMS table spaces as they are processed and S (Share) locks on LOB d... 19 Jun 2008 01:14

DB2, vim, and dbext
Dave Hughes wrote: Ian wrote: Dave Hughes wrote: Anyone else out there a regular DB2 and vim user? Real Men use Emacs (and, therefore, sql-db2). I can prove this using the fact that DB2 still comes with elisp packages in sqllib/bin. :-) No flame wars, please. I use vi(m) a... 19 Jun 2008 01:14

Takers for a Friday SQL puzzle? Timestamps and recursion...
On Jun 13, 4:26 pm, peteh <phazz...(a)intellicare.com> wrote: Hi All; I have a request for a report that will show a summary (count) of timestamped events by the event type in 15 minute increments. I'd like to do it in a single SQL statement. So my source data will resemble this: 12179 'CSR INQRY '... 19 Jun 2008 01:14

address key
>>> On 6/12/2008 at 12:17 PM, in message <1ecf7738-a3c8-475b-a704-f697d34e9be5(a)e53g2000hsa.googlegroups.com>, --CELKO--<jcelko212(a)earthlink.net> wrote: With the minor tweak of changing the "AND AR1.relationship_ind = 'DA'" to instead be "AND AR2.relationship_ind = 'DA'" it now appears to do exactly what... 19 Jun 2008 01:14

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