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?
676 Views Asked by Starc At
1
There are 1 best solutions below
Related Questions in DATABASE
- Crystal Reports 2013: Formula repeating same error
- Crystal Reports 2013: Formula field will not display on page
- Crystal Reports Pie Chart Percentage Doesn't Sum Up to 100%
- Asp.net Crystal Reports changes to child reports not showing in vs2017 debug/release mode
- Multiple range filters on a string type field breaks date range filter
- Crystal Reports Cross-tab space between columns in CR Viewer
- How to manipulate multi-value string parameters for a SQL Command in Crystal Reports
- Update from Crystal 2008 to 2013 Issues
- Inconsistent returning of data in crystal report 2013
- Crystal Reports 2013: Adding Leading Zeros to Sum in Group Footer
Related Questions in DATABASE-CONNECTION
- Crystal Reports 2013: Formula repeating same error
- Crystal Reports 2013: Formula field will not display on page
- Crystal Reports Pie Chart Percentage Doesn't Sum Up to 100%
- Asp.net Crystal Reports changes to child reports not showing in vs2017 debug/release mode
- Multiple range filters on a string type field breaks date range filter
- Crystal Reports Cross-tab space between columns in CR Viewer
- How to manipulate multi-value string parameters for a SQL Command in Crystal Reports
- Update from Crystal 2008 to 2013 Issues
- Inconsistent returning of data in crystal report 2013
- Crystal Reports 2013: Adding Leading Zeros to Sum in Group Footer
Related Questions in INFORMIX
- Crystal Reports 2013: Formula repeating same error
- Crystal Reports 2013: Formula field will not display on page
- Crystal Reports Pie Chart Percentage Doesn't Sum Up to 100%
- Asp.net Crystal Reports changes to child reports not showing in vs2017 debug/release mode
- Multiple range filters on a string type field breaks date range filter
- Crystal Reports Cross-tab space between columns in CR Viewer
- How to manipulate multi-value string parameters for a SQL Command in Crystal Reports
- Update from Crystal 2008 to 2013 Issues
- Inconsistent returning of data in crystal report 2013
- Crystal Reports 2013: Adding Leading Zeros to Sum in Group Footer
Related Questions in DATABASE-CONNECTIVITY
- Crystal Reports 2013: Formula repeating same error
- Crystal Reports 2013: Formula field will not display on page
- Crystal Reports Pie Chart Percentage Doesn't Sum Up to 100%
- Asp.net Crystal Reports changes to child reports not showing in vs2017 debug/release mode
- Multiple range filters on a string type field breaks date range filter
- Crystal Reports Cross-tab space between columns in CR Viewer
- How to manipulate multi-value string parameters for a SQL Command in Crystal Reports
- Update from Crystal 2008 to 2013 Issues
- Inconsistent returning of data in crystal report 2013
- Crystal Reports 2013: Adding Leading Zeros to Sum in Group Footer
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 # Hahtags
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