SQL: Below Query will fetch the field name,field type, field length and prompt table for a given record.

-

SQL:

SELECT REC.RECNAME,REC.FIELDNAME,CASE WHEN FLD.FIELDTYPE = 0  THEN 'Char' 
WHEN FLD.FIELDTYPE = 1  THEN 'Long Char'
WHEN FLD.FIELDTYPE = 2  THEN 'Num'
WHEN FLD.FIELDTYPE = 3  THEN 'Sign Num'
WHEN FLD.FIELDTYPE = 4  THEN 'Date'
WHEN FLD.FIELDTYPE = 5  THEN 'Time'
WHEN FLD.FIELDTYPE = 6  THEN 'Date Time'
WHEN FLD.FIELDTYPE = 8  THEN 'Image'
WHEN FLD.FIELDTYPE = 9  THEN 'Image Ref' END
,FLD.LENGTH,REC.EDITTABLE FROM PSRECFIELD REC,PSDBFIELD FLD  WHERE REC.FIELDNAME = FLD.FIELDNAME AND RECNAME = 'IIE_INT_MAP_TBL' ORDER BY FIELDNUM

Comments

Post a Comment

Popular posts from this blog

BI Publisher: If Condition with sub-string in rtf template

-
 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;
Read more