The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > High Level Programming
Need help ! SQL and Proc *C Need help ! SQL and Proc *C
Google UNIX.COM
Forums Portal Register Forum Rules FAQContribute Members List Arcade Search Today's Posts Mark Forums Read


High Level Programming Post questions about C, C++, Java, SQL, and other programming languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
proc bache_gowda UNIX for Dummies Questions & Answers 7 05-23-2005 08:18 AM
mounting /proc or /usr moxxx68 UNIX for Advanced & Expert Users 5 12-05-2004 12:10 PM
/proc aojmoj UNIX for Advanced & Expert Users 3 11-20-2002 01:54 PM
about /proc fuqiang1976 UNIX for Dummies Questions & Answers 1 09-10-2001 04:46 AM
/proc 100% asutoshch UNIX for Dummies Questions & Answers 1 03-31-2001 11:24 PM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-16-2006
Registered User
  

Join Date: Aug 2005
Posts: 36
Stumble this Post!
Unhappy Need help ! SQL and Proc *C

hi all !
Please help me
When I select data from oracle with proc * C prog.
I count the number of rows
For example the total rows is 1000000
but the number of result return is a limit number 5000 for ex
So How can I know this limit
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 05-17-2006
Registered User
  

Join Date: Mar 2006
Posts: 45
Stumble this Post!
check the environment variables like ROWCOUNT for database access and set them accordingly using EXEC SQL statements.
Reply With Quote
  #3 (permalink)  
Old 05-17-2006
Registered User
  

Join Date: Aug 2005
Posts: 36
Stumble this Post!
how to check ?
Reply With Quote
  #4 (permalink)  
Old 05-17-2006
...@...
  

Join Date: Feb 2004
Location: NM
Posts: 3,844
Stumble this Post!
ARRAYSIZE determines how fetches work.

If you post your SELECT statement then we can help.
Reply With Quote
  #5 (permalink)  
Old 05-17-2006
Registered User
  

Join Date: Aug 2005
Posts: 36
Stumble this Post!
I define the arraysize is 5000
The total rows is 2500
But cnt=sqlca.sqlerrd[2] just 550
How ?
Reply With Quote
  #6 (permalink)  
Old 05-18-2006
Registered User
  

Join Date: Sep 2005
Location: india
Posts: 78
Stumble this Post!
yes ROWCOUNT is correct variable to rely on .
Reply With Quote
Google The UNIX and Linux Forums
Reply

« database in C | probelm with purify »
Thread Tools
Display Modes
Linear Mode Linear Mode




All times are GMT -7. The time now is 11:35 PM.

The UNIX and Linux Forums RSS Feeds - Contact Us - The UNIX and Linux Forums - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0