Subject | [IBO] Exporting parameters from IB_Monitor |
---|---|
Author | Paul Hope |
Post date | 2006-12-13T12:58:38Z |
I often find myself copying parameter values like
EXECUTE STATEMENT
TR_HANDLE = 23220016
STMT_HANDLE = 32828316
PARAMS = [ Version 1 SQLd 14 SQLn 14
[GRNO] = 24775
[DT] = 'O'
[RC] = ' '
[REC] = 4191812
[QD] = 0
[CP] = 0
[PONO] = 50677
[LC] = '30 Dec 1899'
[BO] = 0
[OP] = 1
[CO] = 'A'
[LOCATIONS] = ''
[WH] = 'A'
[BOND] = 'N' ]
into the debugging facilities of IBExpert. This can be very tedious and
error prone so I thought I would write an export routine. So I have a
facility whereby I can highlight the parameter list, right click, select
'Export' and produce a *.prm file which can be read by IBExpert.
This works fine if the param names are the same in the SQL statement as they
are in the Stored Procedure declaration - if not IBExpert cant match them
up. Any suggestions for a better approach?
Regards
Paul
[Non-text portions of this message have been removed]
EXECUTE STATEMENT
TR_HANDLE = 23220016
STMT_HANDLE = 32828316
PARAMS = [ Version 1 SQLd 14 SQLn 14
[GRNO] = 24775
[DT] = 'O'
[RC] = ' '
[REC] = 4191812
[QD] = 0
[CP] = 0
[PONO] = 50677
[LC] = '30 Dec 1899'
[BO] = 0
[OP] = 1
[CO] = 'A'
[LOCATIONS] = ''
[WH] = 'A'
[BOND] = 'N' ]
into the debugging facilities of IBExpert. This can be very tedious and
error prone so I thought I would write an export routine. So I have a
facility whereby I can highlight the parameter list, right click, select
'Export' and produce a *.prm file which can be read by IBExpert.
This works fine if the param names are the same in the SQL statement as they
are in the Stored Procedure declaration - if not IBExpert cant match them
up. Any suggestions for a better approach?
Regards
Paul
[Non-text portions of this message have been removed]