This is a clip from(forums.teradata.com):
To export into a fixed width flat file run this query:
and then for the fastexport script concatenate "cast (ColumnName as char(RealColumnLength))||" for each column. Cast the resulting string to a sum(RealColumnLength). I am using a simple Excel worksheet for this.
hi,
I have a password file called mypwd.bash in /home/oracle/practice directory as follows.
mypwd.bash
mypwd=oracle
export mypwd
i called the above file in the following script as follows.
passwdtest.bash
/home/oracle/practice/mypwd.bash
echo $mypwd
but nothing is getting ... (2 Replies)
We have an assignment to critique Mckusic'sk paper A Fast File System for Unix http://www.cs.berkeley.edu/~brewer/cs262/FFS.pdf. As a part of the paper we are supposed to regenerate the values found in Table 1 and Table 2a and 2b using linux. My problem is how should I regenerate these results... (2 Replies)
I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below
FOR C_FINELINE_LP AS CURSOR C_SLS FOR
SELECT * FROM WM_UTIL.FLT_DEP
WHERE LOAD_IND = 'N'
DO
.....
.....
....
END FOR;
FOR C_FLTSLS_STR_LP AS... (0 Replies)
Hello,
This is my first post so not sure what response I will get
I do have a very small knowledge of UNIX used last over 10 years ago
I have recently move over to an Apple IMAC
I need to copy all my jpg files into excel
Could someone please let me know if this is possible and... (2 Replies)
hi
i have some lines in a text file like,
export ORACLE_HOME=/home/dell/instantclient_11_2
export LD_LIBRARY_PATH=$ORACLE_HOME:${LD_LIBRARY_PATH}
export PATH=$ORACLE_HOME:$ORACLE_HOME/sdk:${PATH}
how to run this file such that every line will be exported in unix session (3 Replies)
Hi all,
When i do
"svn export <URL of the specific file in svn>"
it gives me file which is of older version instead of a file which is of latest or current working version.
On the other hand,
"svn co <URL of the directory in svn>"
It gives me latest version committed files and... (0 Replies)
I have values below for which diff field is giving error like
"invalid time interval" in teradata
Might be it is not doing calculation anymore after exceeding minute(4) value
END_TS 2/2/2018 08:50:49.000000
START_TS 1/5/2018 17:30:02.000000
SLA_TIME 23:59:59.000000
select... (0 Replies)
Discussion started by: himanshupant
0 Replies
LEARN ABOUT SUSE
od
OD(1) User Commands OD(1)NAME
od - dump files in octal and other formats
SYNOPSIS
od [OPTION]... [FILE]...
od [-abcdfilosx]... [FILE] [[+]OFFSET[.][b]]
od --traditional [OPTION]... [FILE] [[+]OFFSET[.][b] [+][LABEL][.][b]]
DESCRIPTION
Write an unambiguous representation, octal bytes by default, of FILE to standard output. With more than one FILE argument, concatenate
them in the listed order to form the input. With no FILE, or when FILE is -, read standard input.
All arguments to long options are mandatory for short options.
-A, --address-radix=RADIX
decide how file offsets are printed
-j, --skip-bytes=BYTES
skip BYTES input bytes first
-N, --read-bytes=BYTES
limit dump to BYTES input bytes
-S, --strings[=BYTES]
output strings of at least BYTES graphic chars
-t, --format=TYPE
select output format or formats
-v, --output-duplicates
do not use * to mark line suppression
-w, --width[=BYTES]
output BYTES bytes per output line
--traditional
accept arguments in traditional form
--help display this help and exit
--version
output version information and exit
Traditional format specifications may be intermixed; they accumulate:
-a same as -t a, select named characters, ignoring high-order bit
-b same as -t o1, select octal bytes
-c same as -t c, select ASCII characters or backslash escapes
-d same as -t u2, select unsigned decimal 2-byte units
-f same as -t fF, select floats
-i same as -t dI, select decimal ints
-l same as -t dL, select decimal longs
-o same as -t o2, select octal 2-byte units
-s same as -t d2, select decimal 2-byte units
-x same as -t x2, select hexadecimal 2-byte units
If first and second call formats both apply, the second format is assumed if the last operand begins with + or (if there are 2 operands) a
digit. An OFFSET operand means -j OFFSET. LABEL is the pseudo-address at first byte printed, incremented when dump is progressing. For
OFFSET and LABEL, a 0x or 0X prefix indicates hexadecimal; suffixes may be . for octal and b for multiply by 512.
TYPE is made up of one or more of these specifications:
a named character, ignoring high-order bit
c ASCII character or backslash escape
d[SIZE]
signed decimal, SIZE bytes per integer
f[SIZE]
floating point, SIZE bytes per integer
o[SIZE]
octal, SIZE bytes per integer
u[SIZE]
unsigned decimal, SIZE bytes per integer
x[SIZE]
hexadecimal, SIZE bytes per integer
SIZE is a number. For TYPE in doux, SIZE may also be C for sizeof(char), S for sizeof(short), I for sizeof(int) or L for sizeof(long). If
TYPE is f, SIZE may also be F for sizeof(float), D for sizeof(double) or L for sizeof(long double).
RADIX is d for decimal, o for octal, x for hexadecimal or n for none. BYTES is hexadecimal with 0x or 0X prefix, and may have a multiplier
suffix: b 512, kB 1000, K 1024, MB 1000*1000, M 1024*1024, GB 1000*1000*1000, G 1024*1024*1024, and so on for T, P, E, Z, Y. Adding a z
suffix to any type displays printable characters at the end of each output line. Option --string without a number implies 3; option
--width without a number implies 32. By default, od uses -A o -t oS -w16.
AUTHOR
Written by Jim Meyering.
REPORTING BUGS
Report od bugs to bug-coreutils@gnu.org
GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for od is maintained as a Texinfo manual. If the info and od programs are properly installed at your site, the com-
mand
info coreutils 'od invocation'
should give you access to the complete manual.
GNU coreutils 7.1 July 2010 OD(1)