Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Spooling data from the database in .csv file with boundary Post 302895815 by Pramod_009 on Wednesday 2nd of April 2014 01:41:20 PM
Old 04-02-2014
Hi Yoda,

I have already tried with the colsep, but the thing is, since the data is small, so i just wanted to be pooled out from the database and send these data in a tabular format in the message body.

Please suggest me if anything can be done on this.

Thanks in Advance...
Pramod
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unix script to export data from csv file to oracle database

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

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies

3. UNIX for Dummies Questions & Answers

Shell scripting+connect to oracle database+spooling

Hi! Everyone I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv file then email to customer. Can anybody let me know how to go about that. I have create... (14 Replies)
Discussion started by: Mr Mo
14 Replies

4. UNIX for Dummies Questions & Answers

Option in sql script to include column headers when spooling file to .csv format

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement. Thanks, Akbar (4 Replies)
Discussion started by: s1a2m3
4 Replies

5. Shell Programming and Scripting

Reading data from DataBase and Writing to a file

Hi All, Please help me in writing data to a file in one row. In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row. Please find the code below writes : ... (2 Replies)
Discussion started by: rajeshorpu
2 Replies

6. Shell Programming and Scripting

Help with loading data from DB2 database to CSV file

Hi everyone!! I need help regarding this. How can we load data from DB2 Database tables into a Comma Separated File? I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file? It is very urgent for me. Please help me out guys. ... (1 Reply)
Discussion started by: ss3944
1 Replies

7. UNIX and Linux Applications

Retrieving data from a database and store to a file

Hi I'm using and Oracle 10g Database. I want to write a script to retrieve data from the database and store it toa file. I'm using simple sql statements such as Select * from celltable I don't know how to specify the database name etc. I have this but it doesn't work ... (1 Reply)
Discussion started by: ladyAnne
1 Replies

8. Shell Programming and Scripting

Execute stored procedure through script in sybase database and store the output in a .csv file

Hi, I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output. I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies

9. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies

10. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
PKMESG(3PVM)							  PVM Version 3.4						      PKMESG(3PVM)

NAME
pvm_pkmesg, pvm_pkmesgbody, pvm_upkmesg - Pack messages into other messages. SYNOPSIS
C int info = pvm_pkmesg( int bufid ) int info = pvm_pkmesgbody( int bufid ) int newbufid = pvm_upkmesg( ) Fortran call pvmfpkmesg( bufid, info ) call pvmfpkmesgbody( bufid, info ) call pvmfupkmesg( bufid, newbufid ) PARAMETERS
bufid Message buffer to pack. newbufid New message buffer unpacked or result code. info Result code. DESCRIPTION
These functions are used to include messages in other messages, as data elements. pvm_pkmesg packs the specified message into the current send buffer. The entire body of the message is packed, along with header attributes: length context tag message tag wait identifier encoding checksum source and destination addresses The buffer specified must not be the same as the current send buffer. Multiple messages can be packed into a single message, and packed messages can be mixed with any other data types. pvm_upkmesg unpacks a message from the current receive buffer, allocating a new message buffer for it. The body of the newly created mes- sage, and header attributes listed above, match the one originally packed using pvm_pkmesg. pvm_pkmesgbody is similar to pvm_pkmesg, but packs only the body of the specified message, omitting the header fields. In other words, it splices the messages together (the included message is left unaltered). When calling pvm_pkmesgbody, the encoding types of the two mes- sages must match because the included message body is simply appended to the send buffer. Calls to pvm_pkmesgbody can be mixed with calls to pack any other data types. Note: pvm_upkmesgbody doesn't exist, because PVM doesn't keep track of the boundary between the two messages. EXAMPLES
pvm_recv(-1, -1); pvm_initsend(PvmDataDefault); pvm_pkstr("here is the message I received..."); pvm_pkmesg(pvm_getrbuf()); ERRORS
The following error conditions can be returned by pvm_pkmesg, pvm_pkmesgbody or pvm_upkmesg: PvmBadParam An invalid value was specified for bufid argument, or bufid is the current send buffer. PvmNoSuchBuf Message buffer bufid doesn't exist. PvmNoMem Libpvm is unable to allocate memory to pack data. PvmNoData The end of the message has been reached, perhaps because pack and unpack calls were mismatched. PvmNoBuf There is no current send (or receive) buffer. PvmMismatch pvm_pkmesgbody was called and the encoding types of bufid and the current send buffer don't match. SEE ALSO
pvm_getrbuf(3PVM), pvm_getsbuf(3PVM), pvm_pack(3PVM), 10 February, 1995 PKMESG(3PVM)
All times are GMT -4. The time now is 03:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy