select no. of rows from a table.
select no. of rows from a table.
(OP)
How can we retrieve no. of rows present in a table without using count function?
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
RE: select no. of rows from a table.
Frank Clarke
--America's source for adverse opinions since 1943.
RE: select no. of rows from a table.
I get your point - I just haven't heard of ISPF in a long time. I wrote a Clist application and a COBOL application using it.
RE: select no. of rows from a table.
So your question is directed at DB2 tables with which I am barely noddingly familiar.
Frank Clarke
--America's source for adverse opinions since 1943.
RE: select no. of rows from a table.
RE: select no. of rows from a table.
about ISPF: do in edit something like this:
PROF NONSENSE
put an 'a' in the margin and give command
MODEL
You will find some ready made sources and ==NOTE== s
The notes can be kept using line command MD on the note or MD999 or whatever you like. An ISPF quick reference for editing can be nice to have if you want to want to renew your knowledge.