RE: Comment in SQL Source

Well, I must have typed something wrong. Thanks. And -- is line based in
RUNSQLSTM which I like. It let's me do this:

create table Document (                                       
        ID int not null as identity,                          
        TemplateID int not null,                              
        MRN numeric(6,0) not null,                            
        VisitID int,                                          
        Document clob(16M),                                   
        DocumentStatus char(1) not null default 'D',          
        foreign key (TemplateID) references Template (ID),    
        --foreign key (VisitID) references Visit (ID),        
        check (DocumentStatus in ('D', 'F')), --Draft,Final   
        Primary Key (ID)                                      
        )                                                     

Where I'm not ready to add the FK constraint but I can leave it in the
source code.

-Walden 


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Payne
Sent: Tuesday, January 24, 2006 11:24 AM
To: Midrange Systems Technical Discussion
Subject: RE: Comment in SQL Source

-- works for me, it is not just one line however, but everything after
that comes after it in the statement

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Tuesday, January 24, 2006 11:17 AM
To: Midrange Systems Technical Discussion
Subject: Comment in SQL Source

All,
 
I've got a brain block. How do I tell the SQL processor (RUNSQLSTM or
STRSQL or OpsNav) that a line is a comment and not for
computer-consumption? I'm not talking about the set comment on
statement, but more like an * after the C in RPG.
 
I was thinking it was either // or -- but neither seem to work.
 
-Walden
 
------------
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
<blocked::blocked::http://www.techsoftinc.com/> 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

 
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.