SQL Column problem
Date: 1 Dec 1994 21:26:16 GMT
Message-ID: <3blf1o$148_at_news.cais.com>
Hello all:
I have an Oracle/Sql question. The following query worked under version 6, but after upgrading to 7 I get as error message. First the query:
DEFINE THE_DATE = "12/01/94";
DEFINE THE_DOC = "SRP ASSET CATALOG";
SET ECHO OFF;
SET FEEDBACK ON; SET PAGESIZE 55; SET LINESIZE 65;
column rsc.rsc_id||rsc.version format a10 heading 'RA ID'; column component_long_name format a50 heading 'Asset Long Name'; set termout off;
SPOOL cat_1201.94
SET NEWPAGE 0;
SET SPACE 4;
TTITLE LEF THE_DATE CEN THE_DOC RIGHT 'PAGE' FORMAT 999 -
SQL.PNO SKIP SKIP CENTER 'EXTRACTABLE ASSETS' SKIP ' ';
select rsc.rsc_id||'.'||rsc.version, rsc.component_long_name
from rcl.application_of_sw_descriptor, rcl.rsc
where descriptor_facet = 'availability'
and descriptor_facet_term like 'extractable%'
and application_of_sw_descriptor.rsc_id = rsc.rsc_id and rsc.site_id = '01' and application_of_sw_descriptor.rsc_id_version = rsc.version order by component_long_name;
SET NEWPAGE 0;
SET SPACE 4;
TTITLE LEF THE_DATE CEN 'SRP ASSET CATALOG' RIGHT 'PAGE' FORMAT 999 -
SQL.PNO SKIP SKIP CENTER 'CARDS LIBRARY ASSETS' SKIP -
CENTER 'AVAILABLE THROUGH DSRS' SKIP ' ';
select rsc.rsc_id||'.'||rsc.version, rsc.component_long_name
from rcl.application_of_sw_descriptor, rcl.rsc
where descriptor_facet = 'availability'
and descriptor_facet_term like 'extractable%'
and application_of_sw_descriptor.rsc_id = rsc.rsc_id and rsc.site_id = 'i0' and application_of_sw_descriptor.rsc_id_version = rsc.version order by component_long_name;
.
.
.
.
Now for the error message:
unknown COLUMN option beginning "'.'||rsc.v..."
Again, this query was fine when we were using Version 6.
Thanks in advance.
...Ken
-- Kenneth C. Ford (Ken) |I love deadlines. I like the whooshing ken_at_cais.com |sound they make as they fly by. fordke_at_ssed1.ims.disa.mil | --Douglas AdamsReceived on Thu Dec 01 1994 - 22:26:16 CET