On Wed, 12 Nov 2003 14:22:18 +0100, [Email Address Removed] wrote:

>questions
>
>1) With db2 how do you run the scripts contained within a file on the file
>system using the command line tools.

db2 -tf script.sql

This says use the file script.sql as the input, and each sql statement is terminated
with a semicolon. Use "db2 ? options" to get a more detailed list about the -t
options.

>2) I made a mistake yesterday the OS we intend to do a migration from is
>not AIX but OS/400.
> Knowing there are limitations on the OS/400 platforms, I wonder then
>if with OS/400 it is possible to use the db2look utility to create empty
>structures in the database on linux and then the db2move to populate the
>tables.
>
>Thanks in advance
>
>Trevor
>
>__________________________________________________________________
>Tiscali ADSL SENZA CANONE, paghi solo quello che consumi!
>Navighi a 1,5 euro all'ora e il modem e' gratis! Abbonati subito.
>http://point.tiscali.it/Adsl/prodotti/senzacanone/
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page