dbTalk Databases Forums  

Re: Rookie + Ingres + Script

comp.databases.ingres comp.databases.ingres


Discuss Re: Rookie + Ingres + Script in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
OldSchool
 
Posts: n/a

Default Re: Rookie + Ingres + Script - 03-22-2006 , 08:13 AM







Radosław Witkowicki wrote:
Quote:
Hi
I have little problem with sql script`s. I have an sql script
with about 120 000 records.
snip
So my question is how to run scripts in Ingres,
maybe you know some sql command which do it.

To run a script in Unix, on the command line, its:

sql DBname < sql_script_file

Should be similar on Windows....



Reply With Quote
  #2  
Old   
David Greenberg
 
Posts: n/a

Default Re: Rookie + Ingres + Script - 03-23-2006 , 04:22 AM






I don't know what platform you are working on but on VMS the command
would be ....

$sql dbname <sql-script

Its most probably very similar in Unix.

David Greenberg



Radosław Witkowicki wrote:
Quote:
Hi
I have little problem with sql script`s. I have an sql script
with about 120 000 records. I would like to inseret that
records to my database and here is my problem, I do not
know how to do it. I was trying to do it in
Ingres Visual SQL, but I could not, when I trying to run
my script Visaul SQL always not responding or buffer is
too small. So my question is how to run scripts in Ingres,
maybe you know some sql command which do it.

Thanks a lot for a help

Regards
Radoslaw Witkowicki




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.