Sponsored Content
Top Forums Shell Programming and Scripting Fast export in UNIX using Teradata creating issue Post 302643823 by unankix on Sunday 20th of May 2012 07:47:10 PM
Old 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

export issue

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

A Fast File System For Unix

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

Unix - teradata

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

Fast export in unix

/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)

Creating a file to export into Excel

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

export in unix

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

Teradata connectivity through UNIX by use bteq

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

Svn export issue

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

Minute(4) issue in teradata

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
All times are GMT -4. The time now is 05:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy