Search results for query: *

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...

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...

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...

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 =)

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

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

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...

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...