SQL Cursor limitations?

[fernando.olmos at hpa.com.au]

More questions...

Can SQL cursors, in PH, use subfiles and defines/temps within the query
itself? I assume the answer to the defines/temps is to use variables,
but I doubt it can use subfiles. I tried the obvious... and it failed
with syntax errors on the asterisk.

sql in hisdb declare crs_invoiced_mstdet        &
cursor for                              &
        select  im.order_no,            &
                sf1.somefield    &
        from    invoiced_master     im, &
                invoiced_detail     id,  &
		    *subfile1           sf1  &
        where   id.order_no = im.order_no and &
                id.order_no = sf1.order_no and &
                im.credit_note_flag          =  'Y'             and &
                id.gl_account_no             <> 'D2480'             &
        order by im.order_no


-----Original Message-----
From: Fernando Olmos 
Sent: Wednesday, August 17, 2005 1:38 PM
To: 'powerh-l at lists.sowder.com'
Subject: RE: SQL Cursor limitations?

<snip>
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended solely for the use of the individual or entity to whom they are addressed.  If you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au, then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the presence of computer viruses by MimeSweeper.  Before opening or using any attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more information about use, disclosure and access see our Privacy Policy at www.hpa.com.au
**********************************************************************