Informix 7.3 isql insert statement - text/blob/clob field insert error
Is a way around this?? I am trying to insert some data into a table whose structure is: Column name Type Nulls crs_no char(12) no cat char(4) no pr_cat char(1) ...
isql
Informix SQL - List all fields & tables
Informix iSQL has a command "info tables;" that shows all tables. The syntax for viewing the fields and their respective data types is "info columns for table;" Is there a similar command that shows table.field for all tables and all fields? LEFFLER!!!! HELP!!!! ...
From a Sybase Database, how I can get table description ( field names and types) ?
I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks. ...
How I can find the list of Sybase Indexes for a given database?
How I can find the list of Indexes for a given database in Sybase? ...
How do I create a new Firebird database from the command line?
I'd like to create a new Firebird database in my C# client application. Is there a command line utility that lets you do this? ...
Configuring SQL Anywhere to read from an ASE server
I have a Sybase ASE server that I'm able to connect to with ASE iSql totally fine. The database definition in my sql.ini file looks like: [<NAME>] master=TCP,<servername>,<port> to connect with iSql, I can make the following command-line call and it works: isql -U <username> -P <password> -S <NAME> My ultimate goal is to use SQL An...
Can I run a Firebird stored procedure from a batch file, or is there an ISQL equivalent
I want to run a Firebird stored procedure from a batch file or similar on a desktop. The stored procedure contains insert statements and update statements with if possible parameters that I would like to pass. Any ideas or other suggestions would be appreciated. ...
Escaping Problem in bash using isql
Hi there, I am currently working on a little backup script from some firebird databases and I've come up with a weird escaping problem that I don't seem to be able to solve. Here's the thing in my script I create a variable called sqllog in which I would like to put the output of a chain of commands, here it is. sqllog=`echo "SELECT * F...
Getting mapped entities from an ISQLQuery without AddEntity
Hello all, consider these POCOs: class Foo { int Id {get;set;} string Name {get;set;} } class Bar { int Id {get;set;} string PropA {get;set;} Foo PropB {get;set;} } Now what i want to achieve is using an ISQLQuery with a root entity of Bar to also hydrate the PropB property. ISQLQuery barsAround = nhSes.CreateSQLQuery("s...
MySQL ODBC Connector Error
I try to execute the following command and receive this error: [root@localhost ~]# isql -v asterisk-connector [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libmyodbc.so' : /usr/lib/libmyodbc.so: cannot open shared object file: No such file or directory [ISQL]ERROR: Could not SQLConnect I have checked and libmyodbc.so does...
How does Informix deal with temporary tables when an iSQL session is dropped?
I'm curious as to how Informix (7.3) deals with temporary tables created with no log when a session is terminated without dropping those tables. I connect using iSQL: cat |isql db Then, for example, I create one or more temporary tables with no log: select first 10 * from table into temp t0 with no log; If I don't drop this table wi...