- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Informix- printing to a report
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-21-2006 06:28 AM
тАО09-21-2006 06:28 AM
Informix- printing to a report
foreach curs into rpt.*
it skips the loop...
here's my related code:
let str = "select a.wc, a.cc, a.bn, a.in, b.id
, b.bs, a.ps from table1 a, table2 b"
start report attachedBilling to "attached_billing.out"
prepare datacurs from str
declare curs cursor for datacurs
foreach curs into rpt.*
display "Processing. Please wait...." at 6,10
output to report attachedBilling(rpt.*)
end foreach
finish report attachedBilling
Any idea why it seems to be not fetching any info from the cursor?
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-21-2006 09:01 AM
тАО09-21-2006 09:01 AM
Re: Informix- printing to a report
1. check that you do have some data in your tables! The symptoms are consistent with a NOTFOUND from your select.
2. add a WHERE clause to your SQL to join the tables together.
Check your whenever error statement to get more debug info.
Also try sending the report to a pipe or something else and put displays in the report section itself.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2006 03:36 AM
тАО09-27-2006 03:36 AM
Re: Informix- printing to a report
Any ideas?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2006 03:51 AM
тАО09-27-2006 03:51 AM
Re: Informix- printing to a report
do you have to issue a specific open command ?:
open curs
foreach curs into rpt.*
Also I would change the names to avoid any potential reserved word problem. So str => qstring and curs => dcursr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2006 05:05 AM
тАО09-27-2006 05:05 AM
Re: Informix- printing to a report
I also did what you suggested- to change the name of the cursor and the select string as to not confuse the program in case there were any preset system variables, but I still get null printed out to the report..