declare @JobNumber int
declare @JobNumber1 char(12)
declare @ItemNumber char(20)
declare @ItemNumber1 char(8)
declare @DateFrom datetime
declare @DateTo datetime 
declare @JdeDateFrom int
declare @JdeDateTo int 
set @JobNumber = 3505040
set @JobNumber1 = '     3505040'
set @ItemNumber = '01010                '
set @ItemNumber1 = '01010    ' 
set @JdeDateFrom = 0
set @JdeDateTo = 0

create table	#JDE_LaborHrsDetailTable
		(  jde_job_date datetime,
           jde_cost_code char(15),
		   jde_equipment_id char(10),
		   jde_equipment_name char(20),
           jde_employee_name char(15),
           jde_employee_hours decimal(8,2),
           jde_equipment_hours decimal(8,2) 
		   
                                               )

insert into #JDE_LaborHrsDetailTable(jde_job_date, jde_cost_code, jde_equipment_id, jde_equipment_name,
                                   jde_employee_name, jde_employee_hours, jde_equipment_hours)
Exec ('Call QGPL.get_labdet(?,?,?,?)', @JobNumber1, @ItemNumber1, @JdeDateFrom, @JdeDateTo) AT AS400SRV_MSDASQL1

select * from #JDE_LaborHrsDetailTable order by jde_job_date

drop table #JDE_LaborHrsDetailTable

spid    dbid    obid            indld   type    mode    status  
90	 12	0	        0	DB     	S	GRANT
90	  2	174623665	0	TAB    	IX	GRANT