MVSFORUMS.com

Kolusu,

Thank you very much.

Regards
Kalidas

Hi,

I have about 150 generations on one GDG. I need to find the generations with one particular a/c number.

I know to use PGM=SORT and have the GDG base for SORTIN. But it is not going to tell ...

This is interesting.

Are you executing the 'OPEN CURSOR' statement multiple times.

My understanding/experience is once the 'OPEN CURSOR' statement is executed, newly inserted rows should not cau ...

Hello all,

In our shop, we use IMS to implement the Checkpoint / restart logic with COBOL & DB2.

I would like to know whether DB2 UDB has any features to support Checkpoint / restart without ...

Thanks Kolusu and Bill.

For fixed block files, the block size is normally a multiple of the record size.

What is the norm when it comes to variable length files? Say my record size is 40 to 50 bytes.

BLOCK CONTAINS ___ ...

Dick and Kolusu,

I very much appreciate your responses.

Regards
Kalidas

I read from a DB2 book that an Alias is available to all users but Synonym is private to the who user who creates it. Aliases are stored in SYSTABLES and Synonyms are stored in SYSSYNONYMS. I would ...

Thanks Kolusu. I started reading this redbook and it is very informative.

How are Relative Record files allocated? Please provide an example JCL.

I have Generation Data Group (GDG) with 10 generations. Is there a command to increase the number of generations to 20?

How can an application program (say coded in COBOL) know whether a queue its accessing is a Local or Remote Queue? Is there any command that can be used to determine this?

Using SORT utility can I merge two files of different LRECL. Say file 1 has LRECL of 300 and file 2 has LRECL of 200. I want the merged file to have LRECL of 300 and all records from file 1 and file ...