Can I run a Firebird stored procedure from a batch file, or is there an ISQL equivalent

Posted by Mark on Stack Overflow See other posts from Stack Overflow or by Mark
Published on 2010-05-13T16:06:20Z Indexed on 2010/05/14 10:14 UTC
Read the original article Hit count: 224

Filed under:

firebird

|

isql

|

batch-file

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.

© Stack Overflow or respective owner

Related posts about firebird

How to migrate data from a Firebird database to PostGreSQL on Linux

as seen on Server Fault - Search for 'Server Fault'
Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to another, not as a migration tool. There's also: Firebird… >>> More
Firebird .NET: Database backup not working (small file)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options… >>> More
Need to compare blobs in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating… >>> More
Does firebird support transactional schema changes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does firebird support transactional schema changes? It seems to me that MySQL does not (am I correct?). >>> More
Firebird sequence-backed ID shorthand

as seen on Stack Overflow - Search for 'Stack Overflow'
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird = 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, >… >>> More

Related posts about isql

Escaping Problem in bash using isql

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Seeking best flavor of Linux for ISQL 7.3 app

as seen on Server Fault - Search for 'Server Fault'
Im looking for the most compact, best performing & easiest flavor of Linux in which INFORMIX-SQL 7.3 is supported. I have looked at PCLinux. The ISQL app is single-user and the end-user is very familiar with DOS, but frightened by Linux. >>> More
Windows GUI for I4GL/ISQL (Pro's/Con's)

as seen on Stack Overflow - Search for 'Stack Overflow'
Would anyone be interested in joining a discussion on iiug.orgforumsclassics about the pro's/con's of IBM creating a Windows GUI for I4GL and ISQL? >>> More
What's the difference between tsql and isql?

as seen on Stack Overflow - Search for 'Stack Overflow'
I saw this in this post,and is really confused >>> More
Mimic ISQL Perform screen with I4GL

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to mimic ISQL Perform screen functionality (i.e. QBF, master/detail, etc.) with a 4GL program? >>> More