02-27-2009
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
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
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
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
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
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
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
touch a_yyyymmdd_hhmmss (1 Reply)
Discussion started by: hemanthsaikumar
1 Replies
8. Shell Programming and Scripting
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
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
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
LEARN ABOUT CENTOS
pixmap
pixmap(n) Tix Built-In Commands pixmap(n)
NAME
pixmap - image type for the XPM file format.
SYNOPSIS
image create pixmap ?name? ?options?
DESCRIPTION
XPM is a popular X Window image file format for storing color icons. The pixmap image type defined by the Tix(n) library can be used to
create color images using XPM files.
CREATING PIXMAPS
Like all images, pixmaps are created using the image create command. Pixmaps support the following options:
-data string
Specifies the contents of the source pixmap as a string. The string must adhere to the XPM file format (e.g., as generated by the
pixmap(1) program). If both the -data and -file options are specified, the -data option takes precedence. Please note that the XPM
file parsing code in the xpm library is extremely fragile. The first line of the string must be "/* XPM */" or otherwise a segmata-
tion fault will be caused.
-file name
name gives the name of a file whose contents define the source pixmap. The file must adhere to the XPM file format (e.g., as gener-
ated by the pixmap(1) program).
IMAGE COMMAND
When a pixmap image is created, Tk also creates a new command whose name is the same as the image. This command may be used to invoke var-
ious operations on the image. It has the following general form:
imageName option ?arg arg ...?
Option and the args determine the exact behavior of the command. The following commands are possible for pixmap images:
imageName cget option
Returns the current value of the configuration option given by option. Option may have any of the values accepted by the image cre-
ate pixmap command.
imageName configure ?option? ?value option value ...?
Query or modify the configuration options for the image. If no option is specified, returns a list describing all of the available
options for imageName (see Tk_ConfigureInfo for information on the format of this list). If option is specified with no value, then
the command returns a list describing the one named option (this list will be identical to the corresponding sublist of the value
returned if no option is specified). If one or more option-value pairs are specified, then the command modifies the given option(s)
to have the given value(s); in this case the command returns an empty string. Option may have any of the values accepted by the
image create pixmap command.
KEYWORDS
pixmap(1), image(n), Tix(n)
Tix 4.0 pixmap(n)