G
G
Gokilla2018-01-17 19:04:15
SQL
Gokilla, 2018-01-17 19:04:15

Deal with command line linter cmd inl?

The command line (cmd.exe) includes *.bat files, they run in it (in unix, *.sh files are used for this, by analogy they are called bash scripts), at the moment I am solving the automation task for Windows, but the solution is also useful for unix and python.
Created the following linter.bat file:
C:\Linter\bin\inl -u SYSTEM/MANAGER
CREATE TABLE Customers (
ID CHAR(10) NOT NULL Primary key,
Custom_name CHAR(25) NOT NULL,
Custom_address CHAR(25) NULL,
Custom_city CHAR(25) NULL,
Custom_Country CHAR(25) NULL
);
After the first line of launching the login / password program, it will pop up:
SQL>
And in order to write the creation of a table into it, the following lines from 'create table' to ');" bat file how to do (answers for bash and python will do)?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Gokilla, 2018-01-17
@Gokilla

The following linter.bat solution helped:
C:\Linter\bin\inl -u SYSTEM/MANAGER -f D:\operators.sql
And the D:\operators.sql file:
CREATE TABLE Customers (
ID CHAR(10) NOT NULL Primary key,
Custom_name CHAR(25) NOT NULL,
Custom_address CHAR(25) NULL,
Custom_city CHAR(25) NULL,
Custom_Country CHAR(25) NULL
);

V
Viktor Taran, 2018-01-18
@shambler81

here there are a million solutions,
for example, you can simply fill it with a file
or the most classic version
<<EOF...EOF.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question