DB2
in [SQL]
|
DB2 Express-C on Vista/Business Hello, Looking back on it - knowing what I know now - I should have run setup.exe by right clicking and explicitly running as an Administrator. Well, here I am. I installed DB2 Express-C from an account that is a member of the Administrators group. I got a pop-up that said: One or more errors occurred ... 30 Jul 2008 08:11
Looking for participants for a 30-minute DB2 survey Hello, I am a Ph.D. candidate at the University of Toronto, doing my research in conjunction with IBM Canada through the Centre for Advanced Studies (IBM CAS). Part of my research involves conducting a survey to better understand how DBAs use information about new features to attune their trust in these features... 29 Jul 2008 12:38
Automatic maintenance policy files Has anyone used automaint_get_policyfile and automaint_set_policyfile? There seems to be a few bugs. I called automaint_get_policyfile and in <DaysOfMonth> label it ranges from 1 through 31. If I try to run automaint_set_policyfile without editting, I get an error indicating an invalid value. A little bit of ... 29 Jul 2008 11:36
conversion from db2 to oracle I find this expression in Oracle query: cast(convert(char(10) ,dateadd(d,i,start),120) as datetime ) as taskday. How to convert it in DB2? Thank's in advance LENY g. -- Message posted via http://www.dbmonster.com ... 29 Jul 2008 19:53
Change value in IMPORT Hi! Is it possible to change a value of a column in IMPORT command. Something like: IMPORT FROM TABLE1.IXF OF IXF METHOD N (TAB_NAME, TAB_DATE) INSERT INTO TMP_TABLE1(TAB_NAME, CURRENT DATE - 2 DAYS) Best regards, Kovi -- ____________________________ |http://kovica.blogspot.com| --------------------... 6 Aug 2008 10:45
Query size limits What are the current query size limits (bytes) for various DB2 products? ... 28 Jul 2008 16:10
db2 username length 8 characters limit Hello, is there a possibility to log on to a user whose length is greater than 8 characters. My system is AIX and system base authentication . At IBM I found this information: Limit Windows Linux / UNIX Group Name Length Up to 30 characters Up to 30 characters User Name Length Up to 30 characters (1) (2) Up to... 28 Jul 2008 08:58
How does a SYSIBMADM created Hi , How does a SYSIBMADM schema created. Is this a default in V9 ? , bcos i dont see it created by default in V8+ . Thanks & Regards, Kamalnath.V ... 29 Jul 2008 02:24
Is there a 'non-mandatory' relationship in DB2 8 for Z/OS? I'm working with a data model which is managed in the AllFusion ERwin tool. Within the modeler, some of the FK relationships are 'non-mandatory' - which is to say that for a given child value, a parent value is optional. This is different from an optional child key, where the child table allows null values - in ... 25 Jul 2008 18:39 |