On Sequel Server 2005 I am calling a procedure on the iseries using linked server:
My procedure is:
I am getting error on "sum(decimal(glu * .01, 38, 2)) " saying:
Msg 7354, Level 16, State 1, Line 36
The OLE DB provider "STREAM" for linked server "(null)" supplied invalid metadata for column "00004". The precision exceeded the allowable maximum.
Code:
insert into #JDE_EqmTable Exec ('Call QGPL.get_eqmqty(?)', @JobNumber1) AT AS400SRV_MSDASQL
Code:
declare c1 scroll cursor with return for select glsub, sum(decimal(glu * .01, 38, 2)) from vgiprddta/f0911li where glmcu = @jobnumber and (globj = '63500 ' or globj = '73500 ' or globj = '73510 ') and (gllt = 'AA' or gllt = 'AU') and glexa = 'Equipment Distribution' group by glsub; open c1;
I am getting error on "sum(decimal(glu * .01, 38, 2)) " saying:
Msg 7354, Level 16, State 1, Line 36
The OLE DB provider "STREAM" for linked server "(null)" supplied invalid metadata for column "00004". The precision exceeded the allowable maximum.
Comment