Connect to a SQL server from AIX

10 More Discussions You Might Find Interesting

1. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4...

2. AIX

Command to connect to remote AIX server

Hi All, Im looking for a command that can remotely connect to another AIX machine and execute scripts present in that server(Possible scenarios are a complete a restart of 3 servers in a cluster through a single script execution present in one of the servers). Im relatively new to AIX and...

3. SuSE

Connect to SQL server from Linux

I am trying to establish connection with SQL server 2008 through ODBC on Linux. First step would be 1. How to verify if ODBC driver for SQL server is installed on Linux OS. PLease let me know how to do it/ if there is any link which could be helpful in this context. thanks in advance

4. Shell Programming and Scripting

how to Connect from ksh script to SQL server

I need to connect sql server 2008 from korn shell script. Can you please give me the script which connects sql server 2008 from korn shell script.

5. Emergency UNIX and Linux Support

How to connect Unix and Sql Server 2005?

Hi All Can any one please help me about How to connect Unix with Sql Server 2005 I want to do it urgently and i didn't find the way.

6. AIX

Help Me - AIX server connect to a VPN network

Hi, I have a task requested by my boss to create a script to enable a server to connect to a vpn network and then to connect to another server to upload some data... How can I connect to a vpn network from AIX server? via telnet? ssh? I have tried to google but mostly the answers are...

7. Shell Programming and Scripting

connect to SQL server from shell script

Hi all, I need to connect to SQL server from shell script. Then need to execute queries from shell script as below 1. To compare values of an array with SQL table's entry. I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS. Kindly let...

8. Solaris

connect to SQL server from shell script

Hi all, I need to connect to SQL server from shell script. Then need to execute queries from shell script as below 1. To compare values of an array with SQL table's entry. Kindly let me know on how to do this Thanks, Double post. Continue here

9. Shell Programming and Scripting

connect to SQL server from shell script

Hi all, I need to connect to SQL server from shell script. Then need to execute queries from shell script. Kindly let me know on how to do this Thanks, Ananthi.U

10. Solaris

Connect From VB to SQL Server

Dear All Now I can't connect from VB to Sybase on Unix. How could I do? Please help me.

LEARN ABOUT DEBIAN

sql::translator::parser::sqlite

SQL::Translator::Parser::SQLite(3pm)			User Contributed Perl Documentation		      SQL::Translator::Parser::SQLite(3pm)

NAME

       SQL::Translator::Parser::SQLite - parser for SQLite

SYNOPSIS

	 use SQL::Translator;
	 use SQL::Translator::Parser::SQLite;

	 my $translator = SQL::Translator->new;
	 $translator->parser("SQL::Translator::Parser::SQLite");

DESCRIPTION

       This is a grammar for parsing CREATE statements for SQLite as described here:

	   http://www.sqlite.org/lang.html

       CREATE INDEX

       sql-statement ::=
	   CREATE [TEMP | TEMPORARY] [UNIQUE] INDEX index-name
	    ON [database-name .] table-name ( column-name [, column-name]* )
	    [ ON CONFLICT conflict-algorithm ]

       column-name ::=
	   name [ ASC | DESC ]

       CREATE TABLE

       sql-command ::=
	   CREATE [TEMP | TEMPORARY] TABLE table-name (
	       column-def [, column-def]*
	       [, constraint]*
	    )

       sql-command ::=
	   CREATE [TEMP | TEMPORARY] TABLE table-name AS select-statement

       column-def ::=
	   name [type] [[CONSTRAINT name] column-constraint]*

       type ::=
	   typename |
	    typename ( number ) |
	    typename ( number , number )

       column-constraint ::=
	   NOT NULL [ conflict-clause ] |
	   PRIMARY KEY [sort-order] [ conflict-clause ] |
	   UNIQUE [ conflict-clause ] |
	   CHECK ( expr ) [ conflict-clause ] |
	   DEFAULT value

       constraint ::=
	   PRIMARY KEY ( name [, name]* ) [ conflict-clause ]|
	   UNIQUE ( name [, name]* ) [ conflict-clause ] |
	   CHECK ( expr ) [ conflict-clause ]

       conflict-clause ::=
	   ON CONFLICT conflict-algorithm

       CREATE TRIGGER

       sql-statement ::=
	   CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]
	   database-event ON [database-name .] table-name
	   trigger-action

       sql-statement ::=
	   CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF
	   database-event ON [database-name .] view-name
	   trigger-action

       database-event ::=
	   DELETE |
	   INSERT |
	   UPDATE |
	   UPDATE OF column-list

       trigger-action ::=
	   [ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]
	       BEGIN
		   trigger-step ; [ trigger-step ; ]*
	       END

       trigger-step ::=
	   update-statement | insert-statement |
	   delete-statement | select-statement

       CREATE VIEW

       sql-command ::=
	   CREATE [TEMP | TEMPORARY] VIEW view-name AS select-statement

       ON CONFLICT clause

	   conflict-clause ::=
	   ON CONFLICT conflict-algorithm

	   conflict-algorithm ::=
	   ROLLBACK | ABORT | FAIL | IGNORE | REPLACE

       expression

       expr ::=
	   expr binary-op expr |
	   expr like-op expr |
	   unary-op expr |
	   ( expr ) |
	   column-name |
	   table-name . column-name |
	   database-name . table-name . column-name |
	   literal-value |
	   function-name ( expr-list | * ) |
	   expr (+) |
	   expr ISNULL |
	   expr NOTNULL |
	   expr [NOT] BETWEEN expr AND expr |
	   expr [NOT] IN ( value-list ) |
	   expr [NOT] IN ( select-statement ) |
	   ( select-statement ) |
	   CASE [expr] ( WHEN expr THEN expr )+ [ELSE expr] END

       like-op::=
	   LIKE | GLOB | NOT LIKE | NOT GLOB

AUTHOR

       Ken Youens-Clark <kclark@cpan.org>.

SEE ALSO

       perl(1), Parse::RecDescent, SQL::Translator::Schema.

perl v5.14.2							    2012-01-18				      SQL::Translator::Parser::SQLite(3pm)

AIX