SQL Column problem

From: Ken Ford <ken_at_cais.cais.com>
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 Adams
Received on Thu Dec 01 1994 - 22:26:16 CET

Original text of this message