02-23-2005
What I do at work
We have an application on the Unix side that has a job that creates a comma delimited file every night. That file gets written to a specific directory. I have that directory shared out using Samba. Our Microsoft SQL admin then has a daily job that imports the data file into the SQL tables using a UNC path to the Samba share on the Unix box. Works like a charm.
As the other comment noted, we need more specifics to really address your particular situation, but... the basics are:
1. Set up a script or use the functionality of your Unix application to generate a comma delimited data file
2. Use cron to schedule that job to happen at a specified interval (daily, hourly, etc...)
3. Use some kind of file transfer protocol (Samba, FTP, SCP, NFS) to allow your SQL server to grab that data file
4. Set up a script or use the functionality of your SQL application to import the comma delimited data file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
2. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
3. Shell Programming and Scripting
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies
4. Shell Programming and Scripting
Hi,
So I'm kinda new to shell scripts and the like. I've picked up quite a bit of use from browsing the forums here but ran into a new one that I can't seem to find an answer for.
I'm looking to parse/find a string AND the next 15 or so charachters that follow the string within a text file... (1 Reply)
Discussion started by: kar23me
1 Replies
5. Shell Programming and Scripting
Hi,
I am trying to export the data to an .ixf file.
I have read the table names from a .dat file and those table name should be passed to the select * from schema.TABLENAME query .
I am trying the below loop
while read TABLE; do
db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES... (5 Replies)
Discussion started by: vikyalex4
5 Replies
6. AIX
sorry for being a noob, i am trying to find which user accessed the server at what time and there ip address at first i used who command but the output didn't contain the ip address then i used the last command which provided me with the ip of the users but when i searched i searched and found that... (1 Reply)
Discussion started by: hercules_1010
1 Replies
7. Shell Programming and Scripting
Hi,
I want to write a shell script which connect to my database with the following credentials :
User name : user
PWD : rap_user_1
Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID : PTNC1
Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
8. Shell Programming and Scripting
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
9. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
10. Shell Programming and Scripting
Greetings,
After a few hours of trial and error, I decide to ask for some help.
I am new to AWK and shell script, so please don't laugh :p
I made the below script, to gather data from some logs and have the output into a CSV file :
#!/bin/sh
#Script to collect Errors
... (9 Replies)
Discussion started by: Yagami_Sama
9 Replies
LEARN ABOUT DEBIAN
alzabo::debug
Alzabo::Debug(3pm) User Contributed Perl Documentation Alzabo::Debug(3pm)
NAME
Alzabo::Debug - Creates constants used to turn on debugging
SYNOPSIS
export ALZABO_DEBUG='SQL|TRACE'
... load and run code using Alzabo ...
export ALZABO_DEBUG=METHODMAKER
... load and run code using Alzabo ...
DESCRIPTION
This module creates constants used by other modules in order to determine what debugging output should be generated.
The interface is currently experimental.
USAGE
Currently, the only way to turn on debugging is by setting the "ALZABO_DEBUG" environment variable. This variable can contain various
flags, each separated by a pipe char (|). Each flag turns on different types of debugging output.
These flags must be set before Alzabo is loaded, as debugging is turned on or off through the use of constants.
The current flags are:
* SQL
Generated SQL and its associated bound variables.
* TRACE
A stack trace will be generated any time SQL is generated.
* METHODMAKER
The "Alzabo::MethodMaker" module will generate verbose output describing the methods it is creating.
* REVERSE_ENGINEER
The modules involved in reverse-engineering will generate output describing what it finds during reverse-engineering.
* ALL
Turn on all flags.
For now, all debugging output is sent to "STDERR".
perl v5.8.8 2007-12-23 Alzabo::Debug(3pm)