 |
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 8 matches |
| Author | Message |
|---|---|
 Topic: report data to PS file |
|
| chandrankk Replies: 3 Views: 1964 |
 Forum: Database Posted: Wed Apr 19, 2006 12:00 am Subject: report data to PS file |
| EXPORT DATA TO 'dataset.name' can be used if it is just query without any forms. | |
| Topic: Table lock and performance |
|
| chandrankk Replies: 8 Views: 3455 |
Forum: Database Posted: Tue Apr 04, 2006 6:04 am Subject: Table lock and performance |
| inserting/updating a huge a number of records has another drawback. When the logs become full DB2 may stop and this will cause a major problem. You can't control the log when you do an insert/update. ... | |
| Topic: Delete Duplicates |
|
| chandrankk Replies: 12 Views: 6953 |
Forum: Database Posted: Fri Dec 16, 2005 5:12 am Subject: Delete Duplicates |
| Sorry, I understood the question wrongly.
I tested the query by Kolusu and am getting the same result cp is getting. That is, it is deleting all the duplicate rows. I don't know what is wrong here. |
|
| Topic: db2 - rollback |
|
| chandrankk Replies: 3 Views: 1768 |
Forum: Database Posted: Fri Dec 16, 2005 5:01 am Subject: db2 - rollback |
| everything will be rolled back if you don't commit in between. | |
| Topic: SQL query |
|
| chandrankk Replies: 4 Views: 2625 |
Forum: Database Posted: Thu Dec 15, 2005 9:07 am Subject: SQL query |
| I think the below query will do. (Got a chance to think for a while after a long time. Sorry for the wrong answer last time)
Select X.SNo, X.Product From ( select SNo, Product, cou ... |
|
| Topic: Delete Duplicates |
|
| chandrankk Replies: 12 Views: 6953 |
Forum: Database Posted: Thu Dec 15, 2005 8:25 am Subject: Delete Duplicates |
| I am just thinking why a simple DISTINCT will not do in this case
Ofcourse, it will not work if you are considering only a partial set as the key |
|
| Topic: PLAN NAME or COLLID at runtime in COBOL program |
|
| chandrankk Replies: 4 Views: 3199 |
Forum: Database Posted: Tue Dec 06, 2005 11:36 pm Subject: PLAN NAME or COLLID at runtime in COBOL program |
| Try this
EXEC SQL VALUES(CURRENT PACKAGESET) INTO(:HV1) your host variable should have the collection id. I think, there are some limitations for using this like if the progr ... |
|
| Topic: SQL query |
|
| chandrankk Replies: 4 Views: 2625 |
Forum: Database Posted: Tue Dec 06, 2005 8:30 am Subject: SQL query |
| you do a join on the 2 tables using customer id and then select only the distinct serial no and product type
regards |
|
All times are GMT - 5 Hours |