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