%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%
% File: pdrs.db2
%
% Author: KayLiang Ong
%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

database( {
	db2::tb_composit(	Pel_Num:integer,
			 	Amp_Code:char(6),
			 	Amount:float,
			 	Amo_Code:char(1),
			 	Layr_Num:integer	         )
			local_name tb_composit
			from 'hptwo:17010:IngresAgent/|ess_ingres|pdrs'
			user_name carnot
			password 'carnot',

	db2::tb_density(	Pel_Num	:integer,
				Buoy_Am	:float,
				Buoy_Bm	:float,
				Grad_Am	:float,
				Grad_Bm	:float,
				Null_Am	:float,	
				Null_Bm	:float		)
			local_name tb_density
			from 'hptwo:17010:IngresAgent/|ess_ingres|pdrs'
			user_name carnot
			password 'carnot',

	db2::tb_env_tnsl(	Pel_Num	:integer,
				Brk_Elng:float,
				Brk_Strs:float,
				Strength:float,
				Toughnes:float,
				Yld_Elng:float,
				Yld_Strs:float		)
			local_name tb_env_tnsl
			from 'hptwo:17010:IngresAgent/|ess_ingres|pdrs'
			user_name carnot
			password 'carnot',

	db2::tb_flm_tmod(	Pel_Num	:integer,
				Pct_Strn:integer,
				Sec_Mod	:float,
				Tan_Mod	:float		)
			local_name tb_flm_tmod
			from 'hptwo:17010:IngresAgent/|ess_ingres|pdrs'
			user_name carnot
			password 'carnot',
	
	db2::tb_flm_tstr(	Pel_Num			:integer,
				Brk_Elng		:float,
				Brk_Strs		:float,
				Yld_Elng		:float,
				Yld_Strs		:float,
				Strength		:float,
				Toughnes		:float	)
			local_name tb_flm_tstr
			from 'hptwo:17010:IngresAgent/|ess_ingres|pdrs'
			user_name carnot
			password 'carnot'
	} ).

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%