I am new to informix, I would like to know what is the connection string of informix to run a sql file through windows command prompt. for example to run sql file in windows command prompt with mssql we use command " sqlcmd -S myServer\instanceName -i C:\myScript.sql "
what is the informix connection string to run a sql file through windows command prompt?
728 Views Asked by Starc At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in DATABASE-CONNECTION
- sqlalchemy force all connections to close mysql
- Android: How to connect oracle database using Android Java code?
- Can not connect to local database via SSMS
- EF Database not Connected Exception
- Why my mysql transaction is not working properly?
- PHP error connecting to MS SQL 2005 using CodeIgniter
- How to manage multiple connections for different users
- What is the connection URL to be used for Cassandra?
- Database connection suffers of concurrent threads
- Unable to connect to database after migrating to Hibernate 4
- What happens if you close a closed connection?
- Closing of DB connections and exception handling
- Database Design Advice for a Social Network App Needed
- Eclipse 4 RCP with ibm rational Doors Database
- could not find installable isam access #2
Related Questions in INFORMIX
- Warnings in Informix database log
- How to release Informix lock from Java
- Informix - select from a temp table created in a 4gl with Interactive debugger?
- Informix throw internal error when creating new transaction in existing one
- How do I split a time range into days using stored procedure in informix 11.5?
- Informix PDO connection : Error SQLSTATE=HY000, SQLDriverConnect: -329 sqlerrm(systables)
- Informix database connection in Play framework
- What may cause connection to be null and How to reuse null reference object?
- SQL query if not null enter field value
- How to backup a single database residing in a dbspace in Informix?
- select for update in stored procedure (concurrently increment a field)
- Informix database issue: Changing the datatype format
- Unable to save dataframe on HDFS for Informix database
- Informix weekday calendar function not working
- SQL sum column in one table where value in another table is 'S'
Related Questions in DATABASE-CONNECTIVITY
- Inter-related combo boxes in WPF
- DataBase Connectivity on the client side using (JavaScript)
- How can I have database connectivity for HTML5 for mobile applications to store data on a web server?
- Query SQL From Excel 2007 And Return Several Values
- Linux connecting to mysql PHP
- Connecting to databases in C# : ArgumentException
- MongoDB connectivity with PHP dropping after idle time
- The method 'getUsers' was called on null. Receiver: null Tried calling: getUsers()
- Why is this java code not saving data in database?
- Error in Connecting Visual Studio 2019 with Oracle 19c
- what is the informix connection string to run a sql file through windows command prompt?
- ODBC Driver for SQL Server vs SQL Server Native Client
- interchange rows and columns in java using database connectivity
- Oracle Error: ORA-12154: TNS: could not resolve the connect identifier specified
- Query regarding database connectivity in db4o
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Unfortunately Informix has no such tool for client side. On Windows machine you can install ClientSDK or JDBC driver. ClientSDK comes with ODBC driver. Having ODBC and JDBC drivers you can use many open source SQL editors or even create simple utility which will be able to run SQL commands from file. For such simple tasks I prefer Jython+Informix JDBC driver.
On server side you can use db-access. I believe Web interface (ISA Informix Server Administrator) uses it via CGI or similar technology.
You should also read great Jonathan answer to: Remote Informix 11.5 Command Line Client