07-13-2007
Uploading a flat file into the database.
I want to upload a text file into the database. what is the command for that?
Thanks in Advance.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello There..
I came to a situation where I need to write flat files using shell scripts, I need to pull the records from the oracle database and create the flat file, This process should be automated.
Can any shell script expert out here to help me.. please..
Will be really glad to... (3 Replies)
Discussion started by: coolbuddy
3 Replies
2. Solaris
one of the business users is ftping files into unix box using user name ftp_user, where as i am using infa_user to login into same unix box. When i am trying to access those or copy over those files from upload directory it says permission denied.
Though i know the password of ftp_user to... (4 Replies)
Discussion started by: Ariean
4 Replies
3. Shell Programming and Scripting
Hi
I'm using this script to upload a file from local system to sftp server.
But in the log file i'm getting an error "Error during upload"
Can you please help me out ...
### CONFIGURATION
LOCAL_DIR=/abc/out
FILE_MASK="File*.txt"
LOG_DIR=/abc/error/File_`date "+%Y%m%d%H%M%S"`.LOG... (3 Replies)
Discussion started by: Jaychandra
3 Replies
4. Shell Programming and Scripting
I have ftp url, username and passwd.
My file is named app.log.
How do I upload this to my ftp server???
I read the manual but I didn't understand much...:cool: (4 Replies)
Discussion started by: hakermania
4 Replies
5. Programming
I have a B+ tree flat file database which is used by the application we use.
I would like to implement a SQL kind of access for that DB.
I have implemented my data structures to parse and store the user written query for execution.
But i would like to know, do we have any standard data... (2 Replies)
Discussion started by: kumaran_5555
2 Replies
6. UNIX for Advanced & Expert Users
I'm wondering about the best way to store large amounts of sorted data, sorted by date/time, in a manner to allow fast retrieval of ranges of dates. Deletion isn't necessary.
A database hardly seems ideal, since they're not optimized for sorted data, and allow things I don't need like the... (18 Replies)
Discussion started by: Corona688
18 Replies
7. Shell Programming and Scripting
Hello there,
At my formal company, there was a flat database library that was very convenient to use (under Unix Solaris)
Here is an example:
The below file (say printerslice) was used to store data of our printers.
We used it to ftp files to printers.
You could query the db as
... (2 Replies)
Discussion started by: pthomsin
2 Replies
8. Shell Programming and Scripting
Is it possible to upload a file from unix server to sharepoint server through shell or perl scripting. I have the sharepoint link where it needs to be uploaded.
Could you please share your views on this ? (0 Replies)
Discussion started by: scriptscript
0 Replies
9. Shell Programming and Scripting
Hi
The below script used to work fine. Suddenly it's uploading empty file. I am very new to perl. Please help me to find out the problem.
#!/usr/bin/perl
#script: upload.pl
use CGI qw/:standard/;
print header,
start_html('File upload');
print_form();
print_results() if... (2 Replies)
Discussion started by: Anupam_Halder
2 Replies
10. UNIX for Advanced & Expert Users
I have setup our SFTP server:
SFTP Setup:
/etc/ssh/sshd_config:
Subsystem sftp internal-sftp
Match Group sftpusers
PasswordAuthentication yes
ChrootDirectory /srv/sftponly
AllowTCPForwarding no
X11Forwarding no
ForceCommand internal-sftp
Adding the... (5 Replies)
Discussion started by: metallica1973
5 Replies
LEARN ABOUT REDHAT
drop_database
DROP
DATABASE(7) SQL Commands DROP DATABASE(7)
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
INPUTS
name The name of an existing database to remove.
OUTPUTS
DROP DATABASE
This message is returned if the command is successful.
DROP DATABASE: cannot be executed on the currently open database
You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this
command again.
DROP DATABASE: may not be called in a transaction block
You must finish the transaction in progress before you can call this command.
DESCRIPTION
DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed
by the database owner (usually the user that created it).
DROP DATABASE cannot be undone. Use it with care!
NOTES
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
[dropdb(1)], which is a wrapper around this command, instead.
Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.
COMPATIBILITY
SQL92
DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.
SQL - Language Statements 2002-11-22 DROP DATABASE(7)