IDS Forum

Re: C-ISAM and ISQL

Posted By: Sérgio Ferreira
Date: Tuesday, 8 July 2008, at 2:42 p.m.

In Response To: RE: C-ISAM and ISQL (Larry Sorensen)

One possible strategy is to move your C programs to ESQL/C. The work
involved will be:
- Move the files that access to database to .ec
- Change all C-ISAM queries to SQL queries. This task depend on the
way you do it.

Sérgio

Larry Sorensen escreveu:
> One last question for those of you with programming experience:
>
> What kind of an effort do you think it would take to revise applications to
> communicate with an SE database rather than a C-ISAM database. I know the
> question is vague, but what kinds of calls, connections would need to be
> modified, etc?
>
> Larry
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Larry
> Sorensen
> Sent: Tuesday, July 08, 2008 11:07 AM
> To: ids@iiug.org
> Subject: RE: C-ISAM and ISQL [12596]
>
> I appreciate all of the comments on this. It appears that we have had a
> version of SE on the old server just for use with ISQL.
>
> Larry
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jonathan Leffler
> Sent: Wednesday, July 02, 2008 12:04 AM
> To: ids@iiug.org
> Subject: Re: C-ISAM and ISQL [12541]
>
> On Sat, Jun 28, 2008 at 4:59 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote:
>
>
>> We have an old C-ISAM database on an old version of SCO. We have an old
>> version of ISQL that we use to talk to the database. We are setting up a
>>
> new
>
>> copy of the database on a current version of Linux with the latest version
>>
>
> of
>
>> C-ISAM. In speaking with IBM, ISQL no longer communicates directly to
>>
> C-ISAM.
>
>> We would like an ISQL-like tool that we could use to run ad hoc queries.
>>
>> Short of migrating to SE or trying to use a datablade, are there any tools
>>
>
>
>> that we can use for this?
>>
>
>
>> To: ids@iiug.org
>> From: jleffler.iiug@gmail.com>
>> Subject: Re: C-ISAM and ISQL [12531]
>> Date: Fri, 27 Jun 2008 02:40:31 -0400
>>
>>
>> On Thu, Jun 26, 2008 at 11:44 AM, LARRY SORENSEN <lsorensen25@msn.com>
>>
> wrote:
>
>>> Does anyone know of any tools, either at iiug or elsewhere, that work
>>> similar to ISQL and will talk to a C-ISAM database?
>>>
>> What do you mean?
>> Or, perhaps, what's wrong with Informix Standard Engine?
>> Please elaborate
>> on your requirements if SE is not the answer.
>>
>
> Well, ISQL never did talk directly to a C-ISAM database other than via
> SE, so you must have had SE on the old system. How old is 'very old'?
> Unless you are positively ante-diluvian (meaning prior to version
> 4.00), you will have had SE as well as ISQL on the (SCO) machine,
> whether you realized it or not. (If you are positively ante-diluvian,
> then you had sqlexec, which became SE from 4.00 onwards, and was
> effectively the same as having SE on the system even so.)
>
> I'm not aware of any tools other tools that interact directly with
> C-ISAM. I assume there's a reason why you can't move away from C-ISAM
> -- for example, why you can't simply import the data into IDS?
>
> You should get SE for Linux and use that (and ISQL); it will be far
> the simplest operation.
>
>

Messages In This Thread

• RE: C-ISAM and ISQL
  LARRY SORENSEN -- Thursday, 26 June 2008, at 2:44 p.m.
  • Re: C-ISAM and ISQL
    Jonathan Leffler -- Friday, 27 June 2008, at 2:40 a.m.
    • RE: C-ISAM and ISQL
      LARRY SORENSEN -- Saturday, 28 June 2008, at 7:59 p.m.
      • Re: C-ISAM and ISQL
        Jonathan Leffler -- Wednesday, 2 July 2008, at 2:03 a.m.
        • RE: C-ISAM and ISQL
          Larry Sorensen -- Tuesday, 8 July 2008, at 1:07 p.m.
          • RE: C-ISAM and ISQL
            Larry Sorensen -- Tuesday, 8 July 2008, at 2:00 p.m.
            • Re: C-ISAM and ISQL
              Sérgio Ferreira -- Tuesday, 8 July 2008, at 2:42 p.m.
            • Re: C-ISAM and ISQL
              Art Kagel -- Tuesday, 8 July 2008, at 11:20 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.