Visit Our UNIX and Linux User Community


how can I bcp out a table into a text file including the header row in the text file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how can I bcp out a table into a text file including the header row in the text file
# 1  
Old 07-21-2009
how can I bcp out a table into a text file including the header row in the text file

Hi All,

I need to BCP out a table into a text file along with the table headers. Normal BCP out command only bulk copies the data, and not the headers.

I am using the following command:
Code:
bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword  -efile.dat.err

Regards,
Shilpa.

Last edited by Yogesh Sawant; 07-21-2009 at 07:26 AM.. Reason: added code tags

Previous Thread | Next Thread
Test Your Knowledge in Computers #421
Difficulty: Medium
JavaScript is strongly typed.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match text to lines in a file, iterate backwards until text or text substring matches, print to file

hi all, trying this using shell/bash with sed/awk/grep I have two files, one containing one column, the other containing multiple columns (comma delimited). file1.txt abc12345 def12345 ghi54321 ... file2.txt abc1,text1,texta abc,text2,textb def123,text3,textc gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies

2. Shell Programming and Scripting

Find header in a text file and prepend it to all lines until another header is found

I've been struggling with this one for quite a while and cannot seem to find a solution for this find/replace scenario. Perhaps I'm getting rusty. I have a file that contains a number of metrics (exactly 3 fields per line) from a few appliances that are collected in parallel. To identify the... (3 Replies)
Discussion started by: verdepollo
3 Replies

3. Shell Programming and Scripting

At text to field 1 of header row using awk

I am just trying to insert the word "Index" using awk. The below is close but seems to add the word at the end and I can not get the syntax correct to add from the beginning. Thank you :). awk -F'\t' -v OFS='\t' '{ $-1=$-1 OFS "Index"}$1=$1' file current output Chr Start End ... (3 Replies)
Discussion started by: cmccabe
3 Replies

4. UNIX for Dummies Questions & Answers

Loading text file into table

Hi, I have text file with comma seprater shown below lu8yh,n,Fri,Feb,7,2014,16:5 deer4 deer4,n,Tue,Aug,21,,2012,on r43ed r43ed,n,Tue,Nov,12,2013,12: e43sd e43sd,n,Tue,Jan,1,,2013,on, I am using below code to load the text file into table #!/bin/ksh... (16 Replies)
Discussion started by: stew
16 Replies

5. Shell Programming and Scripting

Select row from file and text

Hi all! I would like to solve a problem but I have no clue of how do it!I will be grateful if someone could help me! Briefly I have a big file like this: >ENSMUSG00000000204 | ENSMUST00000159637 GGCGAGGCTTACGCCATTTTACCTCAGCGAGCATTCATAAAGCTGCGAGCATTCATACAG >ENSMUSG00000000204 |... (3 Replies)
Discussion started by: giuliangiuseppe
3 Replies

6. Shell Programming and Scripting

Make a table from a text file

Hi, I have a pipe separated text file. Can some someone tell me how to convert it to a table? Text File contents. |Activities|Status1|Status2|Status3| ||NA|$io_running2|$io_running3| |Replication Status|NA|$running2|$running3| ||NA|$master2|$master3|... (1 Reply)
Discussion started by: rocky88
1 Replies

7. Shell Programming and Scripting

Put Header on Text file of all column

Hi I have in put file A.txt ABCDE1 JFHFJFJF3 1 1 SC1 12/10 ABCDE2 JFHFJFJF5 1 1 SC1 12/10 ABCDE3 JFHFJFJF5 1 1 SC1 12/10 ABCDE4 JFHFJFJF6 1 1 SC1 12/10 I want output in .csv with header: Name SUb_N x y No Board ABCDE1 JFHFJFJF3 1 1 SC1 12/10 ABCDE2 JFHFJFJF5 1 1 SC1... (7 Replies)
Discussion started by: pareshkp
7 Replies

8. Shell Programming and Scripting

Help in script - Getting table name from a text file

hhhhhhhhhh (5 Replies)
Discussion started by: sams
5 Replies

9. Shell Programming and Scripting

Convert Header into Column in Text file

Hi Gurus, I have a requirement like this and have to create a UX shell scripts. Thanks in advance. File-in: ------ Header2007-12-012007-11-21 100|xyz|was 101|wsa|qws ...... ....... Output should be: ------------------- 2007-12-01|100|xyz|was 2007-12-01|101|wsa|qws ...... .......... (7 Replies)
Discussion started by: vsubbu1000
7 Replies

10. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
HTML::FormFu::Element::SimpleTable(3pm) 		User Contributed Perl Documentation		   HTML::FormFu::Element::SimpleTable(3pm)

NAME
HTML::FormFu::Element::SimpleTable - simple table element SYNOPSIS
The following is yaml markup for a table consisting of a header row containing 2 "th" cells, and a further 2 rows, each containing 2 "td" cells. type: SimpleTable headers: - One - Two rows: - - type: Input name: one_a - type: Input name: two_a - - type: Input name: one_b - type: Input name: two_b DESCRIPTION
Sometimes you just really need to use a table to display some fields in a grid format. As its name suggests, this is a compromise between power and simplicity. If you want more control of the markup, you'll probably just have to revert to using nested block's, setting the tags to table, tr, td, etc. and adding the cell contents as elements. METHODS
headers Input Value: @headers "headers" accepts an arrayref of strings. Each string is xml-escaped and inserted into a new header cell. rows Input Value: @rows "rows" accepts an array-ref, each item representing a new row. Each row should be comprised of an array-ref, each item representing a table cell. Each cell item should be appropriate for passing to "element" in HTML::FormFu; so either a single element's definition, or an array-ref of element definitions. odd_class Input Value: $string The supplied string will be used as the class-name for each odd-numbered row (not counting any header row). even_class Input Value: $string The supplied string will be used as the class-name for each even-numbered row (not counting any header row). SEE ALSO
Is a sub-class of, and inherits methods from HTML::FormFu::Element::Block, HTML::FormFu::Element HTML::FormFu AUTHOR
Carl Franks, "cfranks@cpan.org" LICENSE
This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-01-23 HTML::FormFu::Element::SimpleTable(3pm)

Featured Tech Videos