Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can we run a metadata script file? #295

Open
mreis1 opened this issue Feb 22, 2023 · 0 comments
Open

Can we run a metadata script file? #295

mreis1 opened this issue Feb 22, 2023 · 0 comments

Comments

@mreis1
Copy link

mreis1 commented Feb 22, 2023

Here's an example of metadata file generated from IBEXPERT which is compatible with isql except the part of SET CLIENTLIB (under comment) that fails when executed using ISQL.


--  SET CLIENTLIB 'C:\path\fbclient.dll';         <-- Needs to be put under comment to work with isql

SET NAMES ISO8859_1;

SET SQL DIALECT 3;

-- CAN BE OMITED IF WE USE AN ACTIVE DB CONNECTION
-- CONNECT '127.0.0.1/3050:C:\test.fdb' USER 'SYSDBA' PASSWORD 'masterkey';

SET AUTODDL ON;

CREATE TABLE TEST (
     T_ID bigint not null
);

ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (T_ID);

Generally I use IBExpert's Script executive to run those scripts because as far as I know this lib doesn't offer the possibility to run this type of scripts. Am i correct? Or is there a non obvious command that would allow this task to be accomplished?

Thank you in advance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant