I'm having trouble saving data in my result-set from my data browser to
a table.  

Here is what I get at the command line when I attempt to do it:

R>run SQL_2Day_Proposals_CT_CDACT_Pending_from_IPROP_20081021vA.RMD
-ERROR- RBTI_QBE is an undefined view. ( 677)
-ERROR- Syntax error (2367)
-ERROR- RBTI_QBE is an undefined table. (2038)
-ERROR- Illegal table name - IPROP_PLOG (2037)
-ERROR- RBTI_QBE is an undefined view. ( 677)



Here is the contents of the RMD file:

--*********************************************************
BROWSE +
   p.PROPOSAL_NUMBER AS PROPOSAL_NUMBER, +
   p.SEQUENCE_NUMBER AS SEQUENCE_NUMBER, +
   p.RP_TITLE AS RP_TITLE, +
   plr.REVIEW_DATE AS REVIEW_DATE, +
   plr.REVIEW_USER AS REVIEW_USER, +
   plr.COMMENTS AS COMMENTS +
FROM +
   R_PROPOSAL p +
LEFT OUTER JOIN R_PROPOSAL_LOG_REVIEW plr +
             ON p.PROPOSAL_NUMBER = plr.PROPOSAL_NUMBER +
WHERE (p.PROPOSAL_TYPE_CODE = 12 OR p.PROPOSAL_TYPE_CODE = 8) +
  AND p.STATUS_CODE = 1

RETURN
--*********************************************************


The problem occurs with or without the Aliases, '... AS
PROPOSAL_NUMBER', and I'm at a loss at the moment.

It also fails in the same fashion when run from the command line rather
than the file.

Any ideas?

Thanks,
Steve in Memphis 


Reply via email to