All examples for DEFINE
# Definition using an SQL database

*define
stname	SKBT		# define 'stname' equal 'SKBT'

	# obtain from database "stations_dbase" (set up by tool dbase)
	# the station id corresponding to station named 'SKBT'

dbsql	stations_dbase		
	
	select name, station_id from stations		# SQL query 
		where name = {stname};

	>> define stid = station_id		# extraction of the desired field from database response