05-02-2008
Have a look at whatever-you-use-to-connect-now's documentation (e.g. dbi).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi:
How will I execute a Stored Procedure that sits on NT/SQLServer.
Any help would be appreciated.
Thanks (3 Replies)
Discussion started by: mayohan
3 Replies
2. Shell Programming and Scripting
Dear Friends,
I am tryin to connect to the myql through perl scrip. I have already installed mysql and DBI modules to my Perl.
There versions are as follows,
DBD-mysql MySQL driver for the Perl5 Database
DBI Database independent interface for
It gives... (4 Replies)
Discussion started by: maheshsri
4 Replies
3. AIX
I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system.
I want this unix application to retrieve data from a SQL server 2000 server to oracle database.
how can i connect to this SQL server database from a unix application
pls help me if you can (2 Replies)
Discussion started by: samsonsimon
2 Replies
4. Shell Programming and Scripting
Hi,
While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :
Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies
5. AIX
Is it possible to connect to two databases in a single query with different username and passwords?
provide an example pls (1 Reply)
Discussion started by: rollthecoin
1 Replies
6. Ubuntu
Hi,
Anyone can help me, I can connect from ubuntu "freetds driver" to Windows sqlserver Database and doing select, insert, update, etc.
But when I try to use the Bulk Insert with these command;
1> BULK INSERT test FROM '/home/test/test.txt' WITH (FIRSTROW = 2, CODEPAGE = 'ACP',... (2 Replies)
Discussion started by: dba_macau
2 Replies
7. Linux
Well im on Fedora, and theres no sub section for Fedora so yea
Well how do you connect to an SSH, while on a windows terminal?
And also to transfer a file from my desktop to a server?
how is this done
scp command is not working for me (3 Replies)
Discussion started by: gangsta
3 Replies
8. Shell Programming and Scripting
hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders.
for example:
MSSQL
SQL SERVER
SQLSERVER
case $q in
a) echo -ne "Work database: "
echo ""
echo " 1) ORACLE"
echo... (4 Replies)
Discussion started by: gsflash80
4 Replies
9. SCO
Hi, I have a router, 192.168.1.1, and an internet router, 10.0.0.138. I have connected the server to the 1st router and assigned it a IP address of 192.168.1.1. I can ping both routers successfully but I have no access to internet. Any suggestions? sco5.0.7 (11 Replies)
Discussion started by: juan.navarrete
11 Replies
10. Programming
I have reviewed many examples on-line about running another process (either PERL or shell command or a program), but do not find any usefull for my needs way. (Reviewed and not useful the system(), 'back ticks', exec() and open())
I would like to run another PERL-script from first one, not... (1 Reply)
Discussion started by: alex_5161
1 Replies
LEARN ABOUT OSX
dbicadmin
DBICADMIN(1) User Contributed Perl Documentation DBICADMIN(1)
NAME
dbicadmin - utility for administrating DBIx::Class schemata
SYNOPSIS
dbicadmin: [-I] [long options...]
deploy a schema to a database
dbicadmin --schema=MyApp::Schema
--connect='["dbi:SQLite:my.db", "", ""]'
--deploy
update an existing record
dbicadmin --schema=MyApp::Schema --class=Employee
--connect='["dbi:SQLite:my.db", "", ""]'
--op=update --set='{ "name": "New_Employee" }'
OPTIONS
Actions
--create
Create version diffs needs preversion
--upgrade
Upgrade the database to the current schema
--install
Install the schema version tables to an existing database
--deploy
Deploy the schema to the database
--select
Select data from the schema
--insert
Insert data into the schema
--update
Update data in the schema
--delete
Delete data from the schema
--op
compatiblity option all of the above can be suppied as --op=<action>
--help
display this help
Arguments
--config-file or --config
Supply the config file for parsing by Config::Any
--connect-info
Supply the connect info as trailing options e.g. --connect-info dsn=<dsn> user=<user> password=<pass>
--connect
Supply the connect info as a JSON-encoded structure, e.g. an --connect=["dsn","user","pass"]
--schema-class
The class of the schema to load
--config-stanza
Where in the config to find the connection_info, supply in form MyApp::Model::DB
--resultset or --resultset-class or --class
The resultset to operate on for data manipulation
--sql-dir
The directory where sql diffs will be created
--sql-type
The RDBMs flavour you wish to use
--version
Supply a version install
--preversion
The previous version to diff against
--set
JSON data used to perform data operations
--attrs
JSON string to be used for the second argument for search
--where
JSON string to be used for the where clause of search
--force
Be forceful with some operations
--trace
Turn on DBIx::Class trace output
--quiet
Be less verbose
-I Same as perl's -I, prepended to current @INC
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself
perl v5.16.2 2012-10-18 DBICADMIN(1)