#395 Ingres Message multiple output

open
Core (462)
5
2006-07-04
2006-07-04
Ken
No

I have been using SQuirreL quite successfully with
Ingres R4 beta on Windows XP. It is much better than
their own tools.

I have an inconsitency to report.

In an Ingres DBP (Database Procedure) the only way to
output text to the screen is to use the Message
command. If I use this I get strange repeated output
behaviour with SQuirreL.

For example,

drop procedure "kpriest"."MessageTest"
\ create procedure "kpriest"."MessageTest" as
begin
Message 'Test Message A';
Message 'Test Message B';
Message 'Test Message C';
end
\ execute procedure "kpriest"."MessageTest"

generates:-

Warning: Test Message A
SQLState: 5000G
ErrorCode: 0
Warning: Test Message B
SQLState: 5000G
ErrorCode: 0
Warning: Test Message C
SQLState: 5000G
ErrorCode: 0
Warning: Test Message B
SQLState: 5000G
ErrorCode: 0
Warning: Test Message C
SQLState: 5000G
ErrorCode: 0
Warning: Test Message C
SQLState: 5000G
ErrorCode: 0

When I should get something like :-

MESSAGE 0: Test Message A
MESSAGE 0: Test Message B
MESSAGE 0: Test Message C

Discussion

  • Rob Manning

    Rob Manning - 2006-07-04

    Logged In: YES
    user_id=1287991

    By default, SQuirreL interprets your semi-colons as end
    of statement separators. You can configure the backslash
    ("\") as the end of statement separator in

    Session -> Session Properties -> SQL tab

    Look at the "Statement Separator" textfield. I think you'll
    see it is set to ";". Change it to "\"
    (minus the double-quotes) and click ok. Then give it a
    go. You will need to do this each time you open the
    Ingres session unless you configure it likewise in the
    File -> New Session Properties dialog. We currently don't
    support per alias session properties, but it's been on
    my list for a while. I most frequently use dbs that support
    ";" as the statement separator in their native tools so
    most of my scripts use this and everything is fine.
    However, when I connect to MS-SQL server or Sybase, I
    always have to remember to change the statement separator
    to "GO". Sheesh!

    Rob

     
  • Rob Manning

    Rob Manning - 2006-07-04
    • labels: --> Core
    • assigned_to: nobody --> manningr
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks