Search found 4 matches

by BMW83
Sat Feb 27, 2016 1:26 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Catalog query assistance
Replies: 0
Views: 1454

DB2 Catalog query assistance

We have a partitioned DB2 table and I want to know if I can query the catalog tables to find out what column(s) are being used for the partitioning. When I run a query against SYSIBM.SYSTABLEPART, I can find the below for the TSNAME. TSNAME PARTITION IXNAME ROWS LIMITKEY ---------+---------+--------...
by BMW83
Thu Mar 13, 2014 7:14 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - combining different record types
Replies: 4
Views: 3906

Thanks for the tip. I will look into it.
by BMW83
Thu Mar 13, 2014 5:06 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - combining different record types
Replies: 4
Views: 3906

There can be multiple 300 records for a 200 record. If a 200 record exists, there will be at least one 300 rec. If this is not the case, there are problems with the file. I need the data in positions 26,4 of the 200 rec appended to the end of the 300 rec. I modified the control cards to the below an...
by BMW83
Wed Mar 12, 2014 9:40 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFSORT - combining different record types
Replies: 4
Views: 3906

DFSORT - combining different record types

I tried to find an example that does this but could not. Input file Example: 100FILE HEADER X 150FILE SUB HEADER 1 X 200FILE SUB HEADER 2 ZFXY 300 A 301 B 304 C 300 F 301 G 314 H 320 I 290FILE SUB TRAILER2 K 200FILE SUB HEADER 2 ABCX 300 L 301 M 290FILE SUB TRAILER2 Q 190FILE SUB TRAILER 1 R 140FILE...