Y'all, this one is killin' me. I ran it against a VIEW (defined below)
and it failed. So, I saved the VIEW data as a TABLE, `tRPT_DRIVER_vA`.
It succeeded the first time I ran it, but has failed each time since.
CROSSTAB COUNT PROPOSAL_NUMBER FOR PROPOSAL_STATUS_DESCRIPTION_20 BY
PROPOSAL_FISCAL_YY FROM tRPT_DRIVER_vA
The data was copied from an ORACLE DB into RBv8, including long names
when present. I am in VISTA, but I sure hope that's not the cause of
the trouble, cause I gotta' try and make this work TODAY.
The only other symptoms observed so far is that after the failure, the
table, `tRPT_DRIVER_vA` was LOCKed when I re-started RBase.
Any ideas?
Thanks,
Steve in Memphis
-- *** BGN VIEW DDL ***
CREATE VIEW +
vRPT_DRIVER_vA +
(PROPOSAL_NUMBER, +
PROPOSAL_FISCAL_YY, +
PROPOSAL_FISCAL_MM, +
SPONSOR_PROPOSAL_NUMBER, +
PROPOSAL_MAX_SEQUENCE_NUMBER, +
PROPOSAL_TYPE_CODE, +
CURRENT_ACCOUNT_NUMBER, +
RP_TITLE, +
SPONSOR_CODE, +
TYPE_OF_ACCOUNT, +
ACTIVITY_TYPE_CODE, +
REQUESTED_START_DATE_INITIAL, +
REQUESTED_START_DATE_TOTAL, +
REQUESTED_END_DATE_INITIAL, +
REQUESTED_END_DATE_TOTAL, +
TOTAL_DIRECT_COST_INITIAL, +
TOTAL_DIRECT_COST_TOTAL, +
TOTAL_INDIRECT_COST_INITIAL, +
TOTAL_INDIRECT_COST_TOTAL, +
DEADLINE_DATE, +
PROPOSAL_STATUS_CODE, +
PROPOSAL_STATUS_DESCRIPTION_20, +
PROPOSAL_CURRENT_AWARD_NUMBER, +
PROPOSAL_CREATE_TIMESTAMP, +
PROPOSAL_UPDATE_TIMESTAMP) +
AS +
SELECT +
p.PROPOSAL_NUMBER, +
(SGET(p.PROPOSAL_NUMBER,2,1)), +
(SGET(p.PROPOSAL_NUMBER,2,3)), +
p.SPONSOR_PROPOSAL_NUMBER, +
p.SEQUENCE_NUMBER, +
p.PROPOSAL_TYPE_CODE, +
p.CURRENT_ACCOUNT_NUMBER, +
p.RP_TITLE, +
p.SPONSOR_CODE, +
p.TYPE_OF_ACCOUNT, +
p.ACTIVITY_TYPE_CODE, +
p.REQUESTED_START_DATE_INITIAL, +
p.REQUESTED_START_DATE_TOTAL, +
p.REQUESTED_END_DATE_INITIAL, +
p.REQUESTED_END_DATE_TOTAL, +
p.TOTAL_DIRECT_COST_INITIAL, +
p.TOTAL_DIRECT_COST_TOTAL, +
p.TOTAL_INDIRECT_COST_INITIAL, +
p.TOTAL_INDIRECT_COST_TOTAL, +
p.DEADLINE_DATE, +
p.STATUS_CODE, +
(SGET(ps.DESCRIPTION,20,1)), +
p.CURRENT_AWARD_NUMBER, +
p.CREATE_TIMESTAMP, +
p.UPDATE_TIMESTAMP +
FROM +
R_PROPOSAL p, +
R_PROPOSAL_STATUS ps +
WHERE +
SEQUENCE_NUMBER IN (SELECT MAX(p2.SEQUENCE_NUMBER) +
FROM R_PROPOSAL p2 +
WHERE p2.PROPOSAL_NUMBER=p.PROPOSAL_NUMBER) +
AND +
p.STATUS_CODE = ps.PROPOSAL_STATUS_CODE
-- *** END VIEW DDL ***
J. Stephen Wills
Program Manager, Research Informatics
Office of the Vice Chancellor for Research
University of Tennessee Health Science Center
62 S. Dunlap, Suite 400
Memphis, TN 38163
Office: 901-448-2389
FAX : 901-448-7133
