Re: Create table by batch file/command line?
From: hackian@my-deja.com
>
>I am trying to understand how to automate the
>creation of a table from an NT command line using
>a batch file. I also need to do this for stored
>procedures.
>
>I looked at DBAccess but that seems to act like a
>utility that does not take any arguements? I
>know I need to specify the database and give user
>information. I have a .sql file that I created
>by saving the table.
>
>I was trying for something like...
>
>DBACESS TABLE mytable.sql
>
>I am missing connection information.
Good to know, thank you.
Have you tried: dbaccess databasename yourscript.sql ?
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
In article <8a8t90$co$1@news.xmission.com>,
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote:
>
> From: hackian@my-deja.com
> >
> >I am trying to understand how to automate the
> >creation of a table from an NT command line using
> >a batch file. I also need to do this for stored
> >procedures.
> >
> >I looked at DBAccess but that seems to act like a
> >utility that does not take any arguements? I
> >know I need to specify the database and give user
> >information. I have a .sql file that I created
> >by saving the table.
> >
> >I was trying for something like...
> >
> >DBACESS TABLE mytable.sql
> >
> >I am missing connection information.
>
> Good to know, thank you.
>
> Have you tried: dbaccess databasename yourscript.sql ?
Yes, I get Connection a permission error:
387: No Connect Permission
111: ISAM: No record found
I am in a command window at the console of the server. I tryed putting
CONNECT USER username USING password;
in the .sql file. That does not seem to help.
Sincerely,
Ian.
Sent via Deja.com http://www.deja.com/
Before you buy.