Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eirez
  • Order by date
  1. eirez

    Crystal's vs SQR - capcity

    Sreedevi, Crystal reports should be used mainly for printing low volume or infrequent use reports. If you crank out 2,000 vouchers a day, that could be acceptale, but 20,000 vouchers (assuming single sheet) is going overboard. You will need a fulltime printer person to load the paper and...
  2. eirez

    New to Peoplesoft CRM

    HI DBA, PeopleSoft CRM is the latest and greatest in programs. With it come a lot of childhood issues: the data scheme is so weird and complicated (to enable data object flexibility, of course) that optimization is very dependent on the amount of data and which modules you use. One of my...
  3. eirez

    Integration Scenarios

    At Surebridge, we develop integration points for our clients using Integration Broker if possible, and many times we use file layout data interchange using app engine. For batch integrations, we use file layout + app engine peoplecode + ci and/or sql objects. For real time integration we use...
  4. eirez

    help: exec sql declare cursor being skipped/ignored

    I am sorry Marc, but I clicked on the Star button (Mark this post as a helpful post) URL, but I guess I clicked on the wrong one. I'll click on it a few more times to make you happy =)
  5. eirez

    help: exec sql declare cursor being skipped/ignored

    Thank you MArc. Big star for you! I put the declare in working storage and the old MVS program started to work. Ever onward....
  6. eirez

    help: exec sql declare cursor being skipped/ignored

    THANK YOU ALL The problem was not the declare nor the fetch. The problem was in the logic structure. Thank you Marc for teaching me that a DECLARE CURSOR does not execute. It allowed me to continue the debugging process and find the REAL reason for the problem. Erol
  7. eirez

    help: exec sql declare cursor being skipped/ignored

    Thanks Marc! You are right. I misunderstood the symptom. The declare and open cursor sql exec work, but the FETCH INTO sql exec does not work. The following fetch is not moving to the next record: EXEC SQL FETCH AG_GL_XREF_CUR INTO...
  8. eirez

    help: exec sql declare cursor being skipped/ignored

    Database: Oracle Connection: ODBC Compiler: NETEXPRESS 3.0 I am trying to open a cursor on a table in a database. When the program runs, it skips the exec sql declare cursor and tries to execute the exec sql open cursor. Of course, this generates and error. When I removed the declare cursor...

Part and Inventory Search

Back
Top