AnsweredAssumed Answered

What is the NSQL comment character for fields?

Question asked by Lowell on Feb 22, 2015
Latest reply on Feb 23, 2015 by another_martink

What is the NSQL comment character?

 

For example, I have some of the following fields, I don't want to lose the syntax for some of my case statements, how do I just comment out the lines I don't need?

 

In Oracle, It's -- for a single line and /*  */ for a block.  What are the NSQL syntax for this?

 

SELECT

@SELECT:DIM:USER_DEF:IMPLIED:RELEASESTAT:OCR.ID:RELEASE_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:I.ID:PROJECT_PKID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:I.CODE:PROJECT_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:OCP.OBJ_REQUEST_TYPE:PROJECT_TYPE_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:PT.PROJECT_TYPE:PROJECT_TYPE@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:I.NAME:PROJECT_NAME@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:I.IS_ACTIVE:PROJECT_IS_ACTIVE@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:MGR.ID:PROJ_MGR_PKID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:MGR.EXTERNAL_ID:PROJ_MGR_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:MGR.FIRST_NAME || ' ' || MGR.LAST_NAME:PROJ_MGR_NAME@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:MGR.EMAIL_ADDRESS:PROJ_MGR_EMAIL@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:OCR.TRG_REL_NAME:RELEASE_NAME@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:OCR.TRG_REL_STAT:RELEASE_STATUS_ID@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:RS.RELEASE_STATUS:RELEASE_STATUS@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:OCR.TRG_NUM_OF || ' of ' || RELC.RELEASE_COUNT:RELEASE_NUMBER@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:RELEASESTAT:(z_list_join(CURSOR(SELECT TO_CHAR(T1.PRFINISH,'MM/DD/YYYY') FROM

ODF_CA_TASK OCT1

INNER JOIN PRTASK T1 ON OCT1.ID = T1.PRID

WHERE OCT1.TRG_REL_STAT = OCR.ID

AND OCT1.TRG_POR_MILESTONE = 'ALL_FEAT_COMP' AND T1.PRSTATUS = 2 ))):ALL_FEAT_COMP_ACTDT@,

Outcomes