dbTalk Databases Forums  

[Info-Ingres] set printrules diagnostics

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] set printrules diagnostics in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] set printrules diagnostics - 04-17-2009 , 09:16 AM






Hi All,



I've been playing with some rfps and tracing their activity using the
'set printrules' statement.



And it seems OK right upto the point that the procedure called by the
rule executes a sub procedure.



What I've noticed is that the 'parameters passed' diagnostic is
incorrectly '0' on the sub procedure.



Try this:

1. createdb bowtest

2. sql bowtest < load_stuff.sql | \

egrep -e'\<E_[A-Z]{2}[0-9A-F]{4}' | \

grep -v -e'E_US0965' -e'E_US0AC1'



3. sql bowtest << SQL_END

\r

set printrules

\p\g

/* If the problem exists then the dignostic from printrules will claim
the

* parameters passed to sub_proc will be zero, not 2.

*/

insert into test_xxx values(1,2,3);

\p\g

\q

SQL_END



Marty



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.