Hi,

I have generated a sample.sql ddl script from windows platform through db2look command.


The sample.sql copied into aix platform. How to execute the sample.sql script file in db2 command prompt.

Please help me.. how to run the ddl sample.sql script file db2 command prompt of aix platform.

Thanks,

Mohan Reddy

db2 -tvsf sample.sql

Andy

I have executed the script with below given command. but the following error:

$ db2 -tvsf sample.sql
DB21006E The input command is too long. The maximum length is 65535.


Thanks,

Mohan Reddy

What is your statement terminating character? (It usually is a semicolon ";").

Andy

Hi,

The some part of the code is pasted here below:

$ view sample.sql
"sample.sql" [Read only] 8864 lines, 479330 characters
% Using database SAMPLE ^M
% Using userid ^M
% Database Manager Version DB2/NT Version 8.2.0 ^M
% Database Codepage 1252^M
% Database Collating Sequence is UNIQUE^M
\documentclass{article} ^M
\setlength{\textwidth}{6in} ^M
\setlength{\oddsidemargin}{-0.3in} ^M
\setlength{\evensidemargin}{-0.3in} ^M
\setlength{\textheight}{8.0in} ^M
\begin{document}^M
^M
^M
\sf^M
^M
\section*{Database Manager Version: DB2/NT Version 8.2.0}^M
^M
^M
\section*{Database Codepage: 1252}^M
^M
^M
\section*{Database Name: SAMPLE}^M


..........


I think is is ^M

Thanks,

Mohan Reddy

"t" tell the system that termination char should be ";". If you want to use something else you have to use td@ where @ is your termination char

You should have used the db2look -e option. Also make sure you transfer the resulting file to the AIX box in ASCII mode.