Re: Convert ntx index

From: Frans <loon_at_luna.nl>
Date: Mon, 14 Feb 2000 14:31:50 GMT
Message-ID: <38a80f64.23249931_at_news.nl.net>

On Thu, 10 Feb 2000 08:53:06 +0100, "Denis" <denismichel_at_hotmail.com> wrote:

>
>How to translate and convert, via ODBC or something else, Clipper ntx
>indexes into Oracle 8.x ?

If you open a ntx file with 'vi' or 'notepad', you can see for wich fields the index file is.

---

   V N  ntx_char->v1

---

If you have a hex-editor it is much easier te find out. Here a example:

---

00000 06 00 19 00 ¦ 00 1C 00 00 ¦ 00 00 00 00 ¦ 56 00 4E 00 ?.?..?......V.N.
00010 00 00 0A 00 ¦ 05 00 6E 74 ¦ 78 5F 63 68 ¦ 61 72 2D 3E .?.?.ntx_char->
00020 76 31 00 00 ¦ 00 00 00 00 ¦ 00 00 00 00 ¦ 00 00 00 00 v1..............
00030 00 00 00 00 ¦ 00 00 00 00 ¦ 00 00 00 00 ¦ 00 00 00 00 ...............

---

ntx_char is the table name
v1 is the field name

As far as I know it starts at pos 23

You can also have a combination like:
 str(m_beg->srt)+m_beg->ecl+m_beg->Uit
This is a combo of 3 fields, 1 of type num and 2 of type char

Good luck
>Tnx,
>Denis
>
Received on Mon Feb 14 2000 - 15:31:50 CET