05-20-2012
Hi Spacebar,
Thanks for the reply. I am trying to do the same thing (but not ran the query you have mentioned in your answer).
I am casting all the columns with their original length and then casting all the columns as the total length of the output file (550 byte). But, still it is not coming as desired.
Its urgent and I am not able to do it.Looking for help from all of you guys. thanks.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: ravi raj kumar
2 Replies
2. UNIX for Advanced & Expert Users
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)
Discussion started by: sigismo
2 Replies
3. Programming
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)
Discussion started by: yschd
0 Replies
4. UNIX for Dummies Questions & Answers
/opt/teradata/client/bin/fexp <<EOP
.LOGTABLE load_work.datastore_log1 ;
.LOGON BOX/userid,password;
.BEGIN EXPORT
SESSIONS 20;
.EXPORT OUTFILE $path MODE RECORD FORMAT TEXT;
select
trim(cast(PROC_YYMM_DT as char(5))) (title ''),
cast('~' as char(1)),
trim(cast(ACCNO as char(21)))... (1 Reply)
Discussion started by: depakjan
1 Replies
5. OS X (Apple)
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)
Discussion started by: Nacnud
2 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: mprakasheee
3 Replies
7. Shell Programming and Scripting
Hi,
I want a script for connecting teradata to load the file to teradata table.
Can you please help me out.
Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: nnsjw702
0 Replies
9. Shell Programming and Scripting
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
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD