DCLGEN on a PC

[ghobbs]

I have a memory lapse (not the first!) and could use some help.
I have DB2 V7.1 on my PC plus VisualAge Cobol V2.2.
There is a facility in one of these products which produces a COBOL
copybook from a DB2 table but i cannot remember its name or how
accessed.
It is the equivalent of DCLGEN on the mainframe except this PC feature
doesn't show the DB2 statements.
Can anybody point me to this please/thanks.

[Jan M. Nelken]

gh****@sympatico.ca wrote:

I have a memory lapse (not the first!) and could use some help.
I have DB2 V7.1 on my PC plus VisualAge Cobol V2.2.
There is a facility in one of these products which produces a COBOL
copybook from a DB2 table but i cannot remember its name or how
accessed.
It is the equivalent of DCLGEN on the mainframe except this PC feature
doesn't show the DB2 statements.
Can anybody point me to this please/thanks.

What happened to the Art of Using Command Line?
Searching for file name with this pattern *DCLG*:

dir *dclg* /s

would reveal that DB2 installed tool DB2CLGN.EXE in your sqllib\bin
subdirectory. Perhaps this is the tool you are looking for?

Jan M. Nelken

[Buck Nuggets]

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message:

What happened to the Art of Using Command Line?
Searching for file name with this pattern *DCLG*:

dir *dclg* /s

would reveal that DB2 installed tool DB2CLGN.EXE in your sqllib\bin
subdirectory. Perhaps this is the tool you are looking for?

Jan, lighten up a few notches. It isn't instantly obvious that a
database port to windows would retain as many command-line utilities
as db2 has. Plus, 'command line' in mvs, tso, and roscoe is a
slightly different beast than on dos or unix.

buck

[Jan M. Nelken]

Buck Nuggets wrote:

Jan, lighten up a few notches. It isn't instantly obvious that a
database port to windows would retain as many command-line utilities
as db2 has. Plus, 'command line' in mvs, tso, and roscoe is a
slightly different beast than on dos or unix.

buck

I did consider lightening up - for a few seconds and rejected the idea.
Orgiginal poster clearly stated that:

"I have DB2 V7.1 on my PC plus VisualAge Cobol V2.2."

DB2DCLGN is clearly documented in online documentation which cames with
the product and is also searchable.
Nobody was mentioning here MVS, TSO, ROSCOE or anything similiar.
Similarly, DOS is not an environment in which Db2 UDB is working or
supported.

I am intrigued by the issues where cost of searching for an answer
(using already installed product and searchable documentation)is less
that cost of asking the question in the Newsgroup on Internet (by cost I
mean number of keystrokes).

Jan M. Nelken

[Jan M. Nelken]

Buck Nuggets wrote:

Jan, lighten up a few notches. It isn't instantly obvious that a
database port to windows would retain as many command-line utilities
as db2 has. Plus, 'command line' in mvs, tso, and roscoe is a
slightly different beast than on dos or unix.

buck

I did consider lightening up - for a few seconds and rejected the idea.
Orgiginal poster clearly stated that:

"I have DB2 V7.1 on my PC plus VisualAge Cobol V2.2."

DB2DCLGN is clearly documented in online documentation which cames with
the product and is also searchable.
Nobody was mentioning here MVS, TSO, ROSCOE or anything similiar.
Similarly, DOS is not an environment in which Db2 UDB is working or
supported.

I am intrigued by the issues where cost of searching for an answer
(using already installed product and searchable documentation)is less
that cost of asking the question in the Newsgroup on Internet (by cost I
mean number of keystrokes).

Jan M. Nelken

[Mark A]

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message
news:aRW_b.10205

I am intrigued by the issues where cost of searching for an answer
(using already installed product and searchable documentation)is less
that cost of asking the question in the Newsgroup on Internet (by cost I
mean number of keystrokes).

Jan M. Nelken

How about the cost of double posting.

[Mark A]

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message
news:uOW_b.10193>

I did consider lightening up - for a few seconds and rejected the idea.
Orgiginal poster clearly stated that:

"I have DB2 V7.1 on my PC plus VisualAge Cobol V2.2."

DB2DCLGN is clearly documented in online documentation which cames with
the product and is also searchable.
Nobody was mentioning here MVS, TSO, ROSCOE or anything similiar.
Similarly, DOS is not an environment in which Db2 UDB is working or
supported.

I am intrigued by the issues where cost of searching for an answer
(using already installed product and searchable documentation)is less
that cost of asking the question in the Newsgroup on Internet (by cost I
mean number of keystrokes).

Jan M. Nelken

I think the problem is that on the mainframe, the DCLGEN is usually invoked
from a TSO menu, and not a command, and programmers don't know the name of
the program (it's just a menu selection). Programmers don't use any DB2
commands on OS/390 (DB2 commands are a completely different concept on that
platform). A search on DCLGEN would not find anything in DB2 for Linux,
UNIX, and Windows.

[PM \(pm3iinc-nospam\)]

I'm more concerned about my cost of double reading... ;-)

PM

"Mark A" <[e-mail]> a écrit dans le message de
news:9%******************@news.uswest.net...

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message
news:aRW_b.10205

I am intrigued by the issues where cost of searching for an answer
(using already installed product and searchable documentation)is less
that cost of asking the question in the Newsgroup on Internet (by cost I
mean number of keystrokes).

Jan M. Nelken

How about the cost of double posting.

[Jan M. Nelken]

Mark A wrote:

I think the problem is that on the mainframe, the DCLGEN is usually invoked
from a TSO menu, and not a command, and programmers don't know the name of
the program (it's just a menu selection). Programmers don't use any DB2
commands on OS/390 (DB2 commands are a completely different concept on that
platform). A search on DCLGEN would not find anything in DB2 for Linux,
UNIX, and Windows.

Sorry for the double posting - I cancelled redundant entry. Must have
double click - or my NNTP client interpreted my single click on send as
double click.

On my machine search on DCLGEN brings exactly one hit im Glossary, where
DCLGEN sends me to "Declaration Generator" term - where it is explained.
So next search on "Declaration Generator" brings multiple (actually
many) hits - *first* one being db2dclgn - Declaration Generator Command.

I tried to demonstrate that rudimentary Windows directory search on
substring of term sought would also be successful.

Frequently commands in DB2 for Linux, Windows, Unix (and OS/2) are
prefixed with "db2" and abbreviated tail:

db2advis - Db2 Index Advisor
db2bnd - Db2 Bind file description tool
db2dclgn - Declaration Generator

etc. etc.

I cannot guarantee that my NNTP client won't have a hickup in the future
- so I am granting you (and everybody else) a permanent license to skip
not only my double posting, but also my all postings.

Jan M. Nelken