* Read column from input data and report in FVS_Compute table
!
! Text following "!" are comments that will not be echoed in output.
!
! This set of keywords will read a numeric value from the Stand or Plot
!   input data table and make it available in the output FVS_Compute
!   table. Only numeric values will be reported, alpha characters cannot
!   be processed.
! Edits required to keywords below are for:
!   - Table-name StandInit or PlotInit
!   - Key-column used Stand_CN or Stand_ID
!   - Key-value is system variable holding key for database record:
!    '%Stand_CN%' or '%Stand_ID%'
! Cycle 1 is specified on SQLIn as input needs read only once.
! The column name(s) being read on SELECT can be multiple and separated
!   by comma. If the column name is long an error will be reported on the
!   Compute statement. The name of the column will need to be shortened
!   in the database for this process to succeed.
! The SQL select statement structure is:
!   SELECT Column1,Column2...
!   FROM Table-name
!   WHERE Key-column = Key-value
! Cycle 0 is specified on Compute so that input value is reported every cycle.
! Add line to Compute block for every additional column read as:
! RepVar1 = Column1
! RepVar2 = Column2
! ...
!
* Read input data column(s) on Cycle 1
DataBase
SQLIn              1
SELECT Column1,Column2,Column3
FROM FVS_StandInit 
WHERE Stand_CN = '%Stand_CN%'
ENDSQL
END
* Load input value(s) into compute variable every cycle
COMPUTE            0
Cvar1 = Column1
Cvar2 = Column2
Cvar3 = Column3
END