MVSFORUMS.com

hi there,

i wonder if another possibility would be to use a freespace "big enough" when creating the table. it would reduce the chances of having a split of CI because of the inserts and, ...

hi,

i'd like to have a table whose lines are physically sorted in a given sequence.

this is because we need to run a select under cics and if we use an orderby clause to sort the lines online, t ...

i did a test today.
i run a query that selected 42000 lines, with an orderby clause.
it took 5 seconds or so to run.
then i added a 'fetch 1st 1000 rows only" and to my surprise the time was a ...

hey kolusu,
thanks a lot.
i've heard that fetch 1st improves performance a lot, but i wonder why if it only affects the last stage of the select.
it will only improve the performance if i have a ve ...

hi,

i have a cursor that will select thousands (or millions) of lines. this is the requirement.

i thought i could limit the number of rows read with a fetch 1st (and prevent the aplication of ab ...

hi,
I've searched the manual and tried some options with no result.
is there a way to generate a formatted dump without recompiling the program with the fdump compile option and only using a run tim ...

i think the real problem is the number of bytes to be sorted.
have you tried to increase a few parameters like mincore and so on.
if the position of your sort key really counts, why don't you try re ...

I think the most resource-consuming operation is the DB2 access.
Sometimes, creating an index will increase your sql performance a lot.
Other possible solution would be to store the rows selected w ...

Thanks a lot for the replies.

Unfortunately it won't work for me because I need to run an E35 for each outfile.

I tried but got an error message.

Thanks again.

Hello,

I

The advantages of dynamic calls usually outweigh the disadvantages, especially if the called program changes frequently. With CPU speeds being what they are nowadays, I wouldn't expect a lot of diffe ...

I'm aware the dynamic call has a worse performance than the static one.

During my tests I couldn't see any difference though.

I wonder if there's a real difference and how big it is.

My batch ...

I agree: it

Hi,
I don't think it's a good idea to insert lines in a db2 table in batch mode with embedded Sql.
The problem is that if the program abends, you'll have your db2 table partially populated.
If you ...

Hi,

Is it important to declare the operational sign in Cobol variables, if I'm dealing only with positive values?

I mean, is there a reason to use

01 fields pic S9(09) comp-3.

instead of ...