 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 9 matches |
| Author | Message |
|---|---|
 Topic: Outer Join |
|
| db2patient Replies: 1 Views: 1109 |
 Forum: Database Posted: Sat May 17, 2008 2:21 pm Subject: Outer Join |
| I have three tables to join one of them involves outer join with another. I am hibernate and spring user. We use DB2 on z/OS. I have the following SQL.
SELECT DISTINCT FORM.FORNAME, ... |
|
| Topic: Identity Columns |
|
| db2patient Replies: 2 Views: 1566 |
Forum: Database Posted: Wed Mar 21, 2007 8:47 am Subject: Identity Columns |
| Dear Sir,
We have couple of tables which has Generated Always Identity columns. I see from IBM manuals running the load utility on these tables will change the sequence numbers. We want to keep the s ... |
|
| Topic: Limit on DB2 Table Columns |
|
| db2patient Replies: 2 Views: 1461 |
Forum: Database Posted: Wed Mar 14, 2007 2:13 pm Subject: Limit on DB2 Table Columns |
| Thank you very much sir. The link you gave me a good reference. You are great. | |
| Topic: Limit on DB2 Table Columns |
|
| db2patient Replies: 2 Views: 1461 |
Forum: Database Posted: Wed Mar 14, 2007 2:02 pm Subject: Limit on DB2 Table Columns |
| Dear Sir,
We are in DB2 version 7. Is there any column limit on a table? How many columns at maximum a table can have? We got to define a new table which will have 300 coumns. Thank you. |
|
| Topic: Generated Keys |
|
| db2patient Replies: 2 Views: 1462 |
Forum: Database Posted: Fri Mar 09, 2007 9:40 pm Subject: Generated Keys |
| Thank you sir. I appreciate all your help | |
| Topic: Generated Keys |
|
| db2patient Replies: 2 Views: 1462 |
Forum: Database Posted: Thu Mar 08, 2007 3:53 pm Subject: Generated Keys |
| Hi,
Can I use GENERATED IDENTITY columns as Primary and Foreign Key relation ship? I have two tables both of these tables have a GENRATED IDENTITY columns which are unique. Can I buid primary and for ... |
|
| Topic: DB2 Object Priviliges change from one TSO-ID to another. |
|
| db2patient Replies: 1 Views: 1156 |
Forum: Database Posted: Thu Feb 09, 2006 4:15 pm Subject: DB2 Object Priviliges change from one TSO-ID to another. |
| i think you can do through platinum tool using option 4 from the main panel. | |
| Topic: DB2 Version 8 dataset size. |
|
| db2patient Replies: 2 Views: 1348 |
Forum: Database Posted: Fri Feb 03, 2006 3:17 pm Subject: DB2 Version 8 dataset size. |
| Thank you sir. | |
| Topic: DB2 Version 8 dataset size. |
|
| db2patient Replies: 2 Views: 1348 |
Forum: Database Posted: Thu Jan 26, 2006 2:52 pm Subject: DB2 Version 8 dataset size. |
| Hi,
What is the maximum size of vsam dataset size of a table space in version 8. I could not find in the guide. As for as i know in version 7 it was 2GB. Is it same in veriosn 8 too? Please clarify ... |
|
All times are GMT - 5 Hours |