from which database comes a .idb format?
up vote
0
down vote
favorite
I want to import to read and convert a database in .idb format . I was told that this file comes from a IBM tool used on indows 98. I do not know exactly from which tool.
I have the following files
a .idb file of 1Go size which was called directly by the application using this database with this call procedure
SERVER NAME=localhost:C:BELAIR3APPSERAPPSER.IDB
a .db file
a .lck file
a .mb file
a .px file
a .sql file with some procedures, here is the beginning:
CONNECT "localhost:C:BELAIR3appserAPPSER.IDB"
USER SYSDBA PASSWORD masterkey;
set term ^ ;
CREATE PROCEDURE CHERCHENOMDPP(
NUMERO INTEGER
)
RETURNS (
NOMDPP VARCHAR(50)
)
AS
DECLARE VARIABLE vnom VARCHAR(50);
DECLARE VARIABLE vprenom VARCHAR(50);
DECLARE VARIABLE vnombre INTEGER;
BEGIN
SELECT b_nom,b_prenom FROM DPPSER
WHERE b_numdpp = :numero
INTO :vnom, :vprenom;
if (vnom is null) then
nomdpp = "???";
else if (vprenom is null) then
nomdpp = vnom;
else
nomdpp = vnom||" "||vprenom;
SUSPEND;
END ^
database rdbms
edited Nov 12 at 0:29
Josh
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
add a comment |
up vote
0
down vote
favorite
I want to import to read and convert a database in .idb format . I was told that this file comes from a IBM tool used on indows 98. I do not know exactly from which tool.
I have the following files
a .idb file of 1Go size which was called directly by the application using this database with this call procedure
SERVER NAME=localhost:C:BELAIR3APPSERAPPSER.IDB
a .db file
a .lck file
a .mb file
a .px file
a .sql file with some procedures, here is the beginning:
CONNECT "localhost:C:BELAIR3appserAPPSER.IDB"
USER SYSDBA PASSWORD masterkey;
set term ^ ;
CREATE PROCEDURE CHERCHENOMDPP(
NUMERO INTEGER
)
RETURNS (
NOMDPP VARCHAR(50)
)
AS
DECLARE VARIABLE vnom VARCHAR(50);
DECLARE VARIABLE vprenom VARCHAR(50);
DECLARE VARIABLE vnombre INTEGER;
BEGIN
SELECT b_nom,b_prenom FROM DPPSER
WHERE b_numdpp = :numero
INTO :vnom, :vprenom;
if (vnom is null) then
nomdpp = "???";
else if (vprenom is null) then
nomdpp = vnom;
else
nomdpp = vnom||" "||vprenom;
SUSPEND;
END ^
database rdbms
edited Nov 12 at 0:29
Josh
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
According to the first google response forIBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…
– Nick.McDermaid
Nov 11 at 23:56
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I want to import to read and convert a database in .idb format . I was told that this file comes from a IBM tool used on indows 98. I do not know exactly from which tool.
I have the following files
a .idb file of 1Go size which was called directly by the application using this database with this call procedure
SERVER NAME=localhost:C:BELAIR3APPSERAPPSER.IDB
a .db file
a .lck file
a .mb file
a .px file
a .sql file with some procedures, here is the beginning:
CONNECT "localhost:C:BELAIR3appserAPPSER.IDB"
USER SYSDBA PASSWORD masterkey;
set term ^ ;
CREATE PROCEDURE CHERCHENOMDPP(
NUMERO INTEGER
)
RETURNS (
NOMDPP VARCHAR(50)
)
AS
DECLARE VARIABLE vnom VARCHAR(50);
DECLARE VARIABLE vprenom VARCHAR(50);
DECLARE VARIABLE vnombre INTEGER;
BEGIN
SELECT b_nom,b_prenom FROM DPPSER
WHERE b_numdpp = :numero
INTO :vnom, :vprenom;
if (vnom is null) then
nomdpp = "???";
else if (vprenom is null) then
nomdpp = vnom;
else
nomdpp = vnom||" "||vprenom;
SUSPEND;
END ^
database rdbms
edited Nov 12 at 0:29
Josh
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
I want to import to read and convert a database in .idb format . I was told that this file comes from a IBM tool used on indows 98. I do not know exactly from which tool.
I have the following files
a .idb file of 1Go size which was called directly by the application using this database with this call procedure
SERVER NAME=localhost:C:BELAIR3APPSERAPPSER.IDB
a .db file
a .lck file
a .mb file
a .px file
a .sql file with some procedures, here is the beginning:
CONNECT "localhost:C:BELAIR3appserAPPSER.IDB"
USER SYSDBA PASSWORD masterkey;
set term ^ ;
CREATE PROCEDURE CHERCHENOMDPP(
NUMERO INTEGER
)
RETURNS (
NOMDPP VARCHAR(50)
)
AS
DECLARE VARIABLE vnom VARCHAR(50);
DECLARE VARIABLE vprenom VARCHAR(50);
DECLARE VARIABLE vnombre INTEGER;
BEGIN
SELECT b_nom,b_prenom FROM DPPSER
WHERE b_numdpp = :numero
INTO :vnom, :vprenom;
if (vnom is null) then
nomdpp = "???";
else if (vprenom is null) then
nomdpp = vnom;
else
nomdpp = vnom||" "||vprenom;
SUSPEND;
END ^
database rdbms
database rdbms
edited Nov 12 at 0:29
Josh
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
edited Nov 12 at 0:29
Josh
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
edited Nov 12 at 0:29
Josh
11.4k63453
edited Nov 12 at 0:29
Josh
11.4k63453
edited Nov 12 at 0:29
Josh
11.4k63453
11.4k63453
asked Nov 11 at 23:08
Vertigo
11
asked Nov 11 at 23:08
Vertigo
11
asked Nov 11 at 23:08
Vertigo
11
11
According to the first google response forIBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…
– Nick.McDermaid
Nov 11 at 23:56
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09
add a comment |
According to the first google response forIBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…
– Nick.McDermaid
Nov 11 at 23:56
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09
According to the first google response for
IBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…– Nick.McDermaid
Nov 11 at 23:56
According to the first google response for
IBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…– Nick.McDermaid
Nov 11 at 23:56
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53254153%2ffrom-which-database-comes-a-idb-format%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53254153%2ffrom-which-database-comes-a-idb-format%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
According to the first google response for
IBM .idb, this might be "iBase Designer" ibm.com/support/knowledgecenter/en/SSXVXZ_2.2.0/…– Nick.McDermaid
Nov 11 at 23:56
seems difficult. the database was used on windows 98
– Vertigo
Nov 13 at 22:16
The idb file is an Interbase file and it can be opened with Firebird
– Vertigo
Nov 14 at 0:09