IDS Forum

Re: fetch statement with shell script

Posted By: rroussey@comcast.net
Date: Thursday, 26 March 2009, at 2:23 p.m.

In Response To: Re: RE: fetch statement with shell script (Keith Simmons)

Stored procedures may be your best bet:

- can trap for errors

- do transactions with BEGIN / ROLLBACK / COMMIT

- cursors

- can set up (error) logs

- can make "system" calls which

- can "echo message > /logdir/logfile"

- run an external program

Bob

----- Original Message -----
From: "Keith Simmons" <smiley73@googlemail.com>
To: ids@iiug.org
Sent: Thursday, March 26, 2009 11:55:00 AM GMT -05:00 US/Canada Eastern
Subject: Re: RE: fetch statement with shell script [15346]

2009/3/26 LAKSHMI DEVI PALANISSAMY <lakshmidevip@hcl.in>:
> Art
>
> Thanks for the detailed inputs. But i would like to tell you that we have
> limitations in installing any frontend application because of the following
> reason.
>
> Am sorry for specifying wrong environment (RHEL) that we use in the initial
> post.
>
> To be clear, we are in the process of breaking down the functionalities
> performed inside .ec file to a simple shell script and this script has to
run
> on SCO Open Server 3.0 and the product is already in the market and it is
not
> recommended to add/remove any packages at client site.
>
> We can just use KSH and run the shell script to carry on with database
> transactions and we are left with no other choice.
>
> We are struck up on finding a way how to keep the database connection open
> throughout the script and keep on executing only the queries and validate
the
> response code to carry on with the next SQL statement
>
> One another important thing is, we create some temporary tables for
> manipulations and if we use
>
> dbccess <dbname> <<!
> <statement to create temp tables>
> !
>
> then the tables that we created are getting cleared once this statement is
> executed as the session closes rite after this statement with the selected
> database.
>
> This is exactly where we need your help in getting a solution to find out
how
> to keep all these temp tables alive as we would require the temp tables
> to process the SQL statements that follow
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

To coin a phrase, you do insist on 'flogging a dead horse'. What you
are trying to do is NOT possible in the environment in which you are
operating. You MUST use some kind of programming language that is
designed to maintain open sessions. Temp tables are ALWAYS dropped
with the connection.
Read waht you are being told, understand you cannot do this, decide on
your programming platform and then come back with queries.

Keith

*******************************************************************************

Messages In This Thread

• fetch statement with shell script
  LAKSHMI DEVI PALANISSAMY -- Wednesday, 25 March 2009, at 11:06 a.m.
  • Re: fetch statement with shell script
    Keith Simmons -- Wednesday, 25 March 2009, at 11:20 a.m.
  • Re: fetch statement with shell script
    Art Kagel -- Wednesday, 25 March 2009, at 12:03 p.m.
    • Re: fetch statement with shell script
      LAKSHMI DEVI PALANISSAMY -- Wednesday, 25 March 2009, at 2:36 p.m.
      • RE: fetch statement with shell script
        Anthony Judish -- Wednesday, 25 March 2009, at 2:44 p.m.
        • Re: RE: fetch statement with shell script
          LAKSHMI DEVI PALANISSAMY -- Thursday, 26 March 2009, at 9:29 a.m.
          • Re: RE: fetch statement with shell script
            Art Kagel -- Thursday, 26 March 2009, at 9:59 a.m.
            • Re: RE: fetch statement with shell script
              LAKSHMI DEVI PALANISSAMY -- Thursday, 26 March 2009, at 11:25 a.m.
              • Re: RE: fetch statement with shell script
                Keith Simmons -- Thursday, 26 March 2009, at 11:55 a.m.
                • Re: fetch statement with shell script
                  rroussey@comcast.net -- Thursday, 26 March 2009, at 2:23 p.m.
              • Re: RE: fetch statement with shell script
                Art Kagel -- Thursday, 26 March 2009, at 2:19 p.m.
              • Re: RE: fetch statement with shell script
                DAVE GRIFFEN -- Friday, 27 March 2009, at 5:45 p.m.
      • Re: fetch statement with shell script
        GPalmer@tsys.com -- Wednesday, 25 March 2009, at 3:48 p.m.
      • Re: fetch statement with shell script
        Art Kagel -- Wednesday, 25 March 2009, at 4:02 p.m.
        • Re: fetch statement with shell script
          Jonathan Leffler -- Monday, 30 March 2009, at 2:50 a.m.
  • Re: fetch statement with shell script
    Marco Greco -- Wednesday, 25 March 2009, at 12:22 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.