Sponsored Content
Top Forums UNIX for Advanced & Expert Users to create format file for bcp in Post 302292198 by Arunprasad on Friday 27th of February 2009 05:57:38 AM
Old 02-27-2009
Java to create format file for bcp in

I want to create the format file for bcp in a file to the table.
My Versions are:
Unix: Sun OS,
DB: Sybase.

How can i create the format file.
Is there any way to create the format by bcp command
or some system sp.

Please help.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to create concatenate a file in tab format

Hi, Do you know given a file which is SED at the same time, how to read it and AWK it in tabs format. Means:- I have an input file which is (at the same time perform sed):- 1 2 3 4 5 6 7 I would like to print out in tab format which is:- 1 2 3 4 5 6 7 .... (12 Replies)
Discussion started by: ahjiefreak
12 Replies

2. Shell Programming and Scripting

create filename with 'DD/MM/YYYY' date format

Hi, I can use the following command to create a file with some name then underscore and then date appended to it in the format 'DD-MM-YYYY': touch "newfile_`date '+%d-%m-%Y'`" But it gives me error when I try with the similar command to create a file with the date format 'DD/MM/YYYY'. I... (4 Replies)
Discussion started by: royalibrahim
4 Replies

3. Shell Programming and Scripting

Help to Create this file format structure

This data comes form the table and exported into the file in this format File1 Format weboffercode1,sourcecode1,1,1,1,1,1,1 weboffercode1,sourcecode2,1,1,1,1,1,1 weboffercode1,sourcecode1,1,1,1,1,1,1 weboffercode1,sourcecode3,1,1,1,1,1,1 weboffercode1,sourcecode3,1,1,1,1,1,1 ... (4 Replies)
Discussion started by: enigma_83
4 Replies

4. Shell Programming and Scripting

How to format or create a matrix report from file

Dear Unix champs, I have a input file as attached, i would like to create an report from the file as below FileType | EQUENS0001 | EQUENS0002 | EQUENS1100 | EQUENS0003 --------+-------------------------------------------------------- Msg No |... (3 Replies)
Discussion started by: manas_ranjan
3 Replies

5. Shell Programming and Scripting

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: bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword -efile.dat.err Regards,... (0 Replies)
Discussion started by: shilpa_acc
0 Replies

6. Programming

Create table with date format.

Hello, Could you please let me know the correct format of CREATE TABLE statement with DATE format. CREATE TABLE EMP_TABLE1 ( NAME VARCHAR(6) PRIMARY KEY, ADDRESS VARCHAR(6), BIRTH_DATE DATE ); I want BIRTH_DATE to be in "YYYYMMDDHHMISS" format. How we can create table with... (4 Replies)
Discussion started by: Poonamol
4 Replies

7. Shell Programming and Scripting

Needed touch command to create a file in the following format

needed touch command to create a file in the following format touch a_yyyymmdd_hhmmss (1 Reply)
Discussion started by: hemanthsaikumar
1 Replies

8. Shell Programming and Scripting

Best way to point/update a file during PROD and BCP failover.

Hi All, In UNIX servers we are switching from DR to PROD. After switching to DR we need to update some configuration files which contains the server names. Ex - If we switch to BCP we need to update BCP server name. If we switch back to PROD we need to update PROD server name. I... (1 Reply)
Discussion started by: Girish19
1 Replies

9. Shell Programming and Scripting

How to create a file from output of vertica table query in UTF-8 format?

Hello, In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data. file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies

10. UNIX for Beginners Questions & Answers

Create movie from jpg (or other picture format) file

hi linux expert is there any program for create movie file from pictures file (like jpg)? Many Thanks samad (1 Reply)
Discussion started by: abdossamad2003
1 Replies
BCP(1)							 Boost C++ Libraries Documentation						    BCP(1)

NAME
bcp - extract subsets of Boost SYNOPSIS
bcp --list [options] module-list bcp [options] module-list output-path bcp --report [options] module-list html-file bcp --help DESCRIPTION
Copies all the files, including dependencies, found in module-list to output-path. output-path must be an existing path. With --list, prints the list of all the files in module-list, including dependencies. With --report, writes the HTML report to html-file. With --help, prints a quick usage reminder. It is useful for Boost authors who want to distribute their library separately from Boost and for Boost users who want to distribute a sub- set of Boost with their application. module-list When the --scan option is not used, a list of Boost files or library names to copy. It can be: - The name of a tool: for example "build" will find "tools/build". - The name of a library: for example "regex". - The title of a header: for example "scoped_ptr" will find "boost/scoped_ptr.hpp". - The name of a header: for example "scoped_ptr.hpp" will find "boost/scoped_ptr.hpp". - The name of a file: for example "boost/regex.hpp". When the --scan option is used, a list of (probably non-boost) files to scan for Boost dependencies, the files in the module list are not therefore copied/listed. File dependencies C++ source files are scanned for #includes, all #includes present in the Boost source tree will then be scanned for their dependencies and so on. C++ source files are associated with the name of a library, if that library has source code (and possibly build data), then include that source in the dependencies. C++ source files are checked for dependencies on Boost.Test (for example to see if they use cpp_main as an entry point). HTML files are scanned for immediate dependencies (images and style sheets, but not links). HTML report contains: - all the licenses in effect, plus the files using each license, and the copyright holders using each license - any files with no recognizable license (please report these to the Boost mailing lists) - any files with no recognizable copyright holders (please report these to the Boost mailing lists) - all the copyright holders and the files on which they hold copyright - file dependency information - indicates the reason for the inclusion of any particular file in the dependencies found OPTIONS
--boost=path sets the location of the Boost tree to path --scan treat the module list as a list of (possibly non-boost) files to scan for Boost dependencies --cvs only copy files under CVS version control --unix-lines make sure that all copied files use Unix style line endings EXAMPLES
bcp scoped_ptr /foo Copies boost/scoped_ptr.hpp and dependencies to /foo. bcp boost/regex.hpp /foo Copies boost/regex.hpp and all dependencies including the regex source code (in libs/regex/src) and build files (in libs/regex/build) to /foo. Does not copy the regex documentation, test or example code. bcp regex /foo Copies the full regex lib (in libs/regex) including dependencies (such as the Boost.Test source required by the regex test programs) to /foo. bcp regex config build /foo Copies the full regex lib (in libs/regex) plus the config lib (libs/config) and the build system (tools/build) to /foo including all the dependencies. bcp --scan --boost=/boost foo.cpp bar.cpp boost Scans the [non-boost] files foo.cpp and bar.cpp for Boost dependencies and copies those dependencies to the sub-directory boost. bcp --report regex.hpp boost-regex-report.html Creates a HTML report called boost-regex-report.html for the Boost module regex.hpp. AUTHORS
Author of bcp is John Maddock. Author of this manpage is Domenico Andreoli, who copied stuff from bcp --help and the HTML documentation. Boost C++ Libraries March 2006 BCP(1)
All times are GMT -4. The time now is 07:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy