×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

select no. of rows from a table.

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?

RE: select no. of rows from a table.

ISPF table? DB2 table?

Frank Clarke
--America's source for adverse opinions since 1943.

RE: select no. of rows from a table.

ISPF table? Is there such a thing? It has been about fifteen years or so since I was on an IBM mainframe but back then it was just a graphical interface.

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.

Yes, ISPF is more than a graphical interface — more like a 'suite'. See my REXX blog where I blend REXX and ISPF if you're interested.

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.

I've been off the mainframe for close to twenty years now. Switched to Windows a year or two after Y2K. And I'm not nostalgic.

RE: select no. of rows from a table.

somewhere on the internet there is a pdf manual to be found for free, containing SQL COOKBOOK. I used the tips in it many times. Very easy to use. Try to get it.

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close