Time to make a splash!

[FaStOnE]

Welp! It looks as though I need to get back up-to-speed with the COBOL generation...

Anyone have any initial sites I can visit to get going with this? I found this site and it has some pretty good information to get going. I need some examples of using Embeded SQL with COBOL though. We have some hefty tables that need processing and I'm going to have to institute some guidelines of utilizing SQL with some Blocking Optimization techniques.

Sooooo.... any help would be appreciated!

[MichaelCatalani]

Re: Time to make a splash!

May the force be with you!

[jamief]

Re: Time to make a splash!

COBOL --- and do they all eat soup with their hands .??!!!...

[BenThurley]

Re: Time to make a splash!

One of the guys here said he looked at some COBOL once. His exact words were "right those are the comments, now where is the code"?

[Terry Wincheste]

Re: Time to make a splash!

Check Chapter 3 at this link:

http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/rzajp/rzajpmst.pdf

Terry

[toeside]

Re: Time to make a splash!

... We have some hefty tables that need processing and I'm going to have to institute some guidelines of utilizing SQL with some Blocking Optimization techniques.

Although COBOL supports embedded SQL, I would suggest using SQL tools like QM Query (STRQMQRY, etc.) inside CL to do as much data manipulation as possible. Use the COBOL only if you have processing that can't be done reasonably well with SQL. You'll find the performance against large data sets much more satisfactory... especially if you optimize by building carefully chosen access paths.