 |
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 4 matches |
| Author | Message |
|---|---|
 Topic: Fetch first few bytes from an Integer field |
|
| shantharam_k Replies: 4 Views: 2315 |
 Forum: Database Posted: Fri Aug 08, 2008 2:21 am Subject: Fetch first few bytes from an Integer field |
| Using BETWEEN is probably the best bet for you.
However, any idea on why the filed is defined as INT? There is no gain in terms of space as both use 4 bytes. And u need to carry the extra overhead ... |
|
| Topic: Db2 Table Unload |
|
| shantharam_k Replies: 16 Views: 10184 |
Forum: Database Posted: Fri Aug 08, 2008 12:22 am Subject: Db2 Table Unload |
| Here it is :
1. First Write a Program in REXX to get the no of Partitions in the TS by querying SYSIBM.SYSTABLESPACE (U can also run IKJEFT01 to get this using DSNTEP2 & scan the output of this ... |
|
| Topic: Space Error - B37 in UNLOAD UTILITY |
|
| shantharam_k Replies: 3 Views: 1913 |
Forum: Database Posted: Thu Aug 07, 2008 7:00 am Subject: Space Error - B37 in UNLOAD UTILITY |
| If your table being unload has VARCHARs try using NOPAD (or NOT PADDED, not very sure).. It helps saving space | |
| Topic: Db2 Table Unload |
|
| shantharam_k Replies: 16 Views: 10184 |
Forum: Database Posted: Thu Aug 07, 2008 6:44 am Subject: Db2 Table Unload |
| I think you have two round about ways:
Approach1: 1. Create a number of empty datasets (say 200) 2. Then unload the data using TEMPLATE specifying partitions into these datasets. Only some of t ... |
|
All times are GMT - 5 Hours |