>I have three tables. One stores all available 'Width'. One stores all available 'Substance'. One stores the transaction with 'Width', 'Substance', and 'Weight'. How do I generate a crosstab with the following look with 'Weight' as the content?
>
> Subs1 Subs2 ......
>Wdth1
>Wdth2
>..
>..
>..
>
>
>My transaction may not have all the widths and substances. I tried using FULL JOIN but it gives me an extra NULL row and an extra NULL column. Is there a way I can get rid of the NULL row and the extra NULL column. (the NULL row and column arise because the transaction does not have all the available widths and substances)
>
>Any idea?
Open the program (using MODI COMM (_GENXTAB)). The comments at the beginning of the file have a description of what parameters, their order, and defaults. You don't have to generate a cursor or table with just three columns. This should give you the information you need to solve your problem.
hth,
George
George
Ubi caritas et amor, deus ibi est