Sponsored Content
Top Forums Shell Programming and Scripting Fast export in UNIX using Teradata creating issue Post 302643159 by unankix on Friday 18th of May 2012 02:38:55 PM
Old 05-18-2012
Fast export in UNIX using Teradata creating issue

Hi All,

I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full length file?
Code:
.LOGON 
.EXPORT file=export.txt;
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || 
(CAST(B.column1 AS CHAR(2))) ||
:
:
(CAST(B.columnN AS CHAR(6)),''))) AS CHAR(550)) (title '')
FROM Table1;
.EXPORT RESET;
.LOGOFF;

Thanks.

Last edited by joeyg; 05-18-2012 at 03:42 PM.. Reason: Please wrap CodeTags around commands and data.
 

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
CGI::Fast(3pm)						 Perl Programmers Reference Guide					    CGI::Fast(3pm)

NAME
CGI::Fast - CGI Interface for Fast CGI SYNOPSIS
use CGI::Fast qw(:standard); $COUNTER = 0; while (new CGI::Fast) { print header; print start_html("Fast CGI Rocks"); print h1("Fast CGI Rocks"), "Invocation number ",b($COUNTER++), " PID ",b($$),".", hr; print end_html; } DESCRIPTION
CGI::Fast is a subclass of the CGI object created by CGI.pm. It is specialized to work well FCGI module, which greatly speeds up CGI scripts by turning them into persistently running server processes. Scripts that perform time-consuming initialization processes, such as loading large modules or opening persistent database connections, will see large performance improvements. OTHER PIECES OF THE PUZZLE
In order to use CGI::Fast you'll need the FCGI module. See http://www.cpan.org/ for details. WRITING FASTCGI PERL SCRIPTS
FastCGI scripts are persistent: one or more copies of the script are started up when the server initializes, and stay around until the server exits or they die a natural death. After performing whatever one-time initialization it needs, the script enters a loop waiting for incoming connections, processing the request, and waiting some more. A typical FastCGI script will look like this: #!/usr/bin/perl use CGI::Fast; &do_some_initialization(); while ($q = new CGI::Fast) { &process_request($q); } Each time there's a new request, CGI::Fast returns a CGI object to your loop. The rest of the time your script waits in the call to new(). When the server requests that your script be terminated, new() will return undef. You can of course exit earlier if you choose. A new version of the script will be respawned to take its place (this may be necessary in order to avoid Perl memory leaks in long-running scripts). CGI.pm's default CGI object mode also works. Just modify the loop this way: while (new CGI::Fast) { &process_request; } Calls to header(), start_form(), etc. will all operate on the current request. INSTALLING FASTCGI SCRIPTS
See the FastCGI developer's kit documentation for full details. On the Apache server, the following line must be added to srm.conf: AddType application/x-httpd-fcgi .fcgi FastCGI scripts must end in the extension .fcgi. For each script you install, you must add something like the following to srm.conf: FastCgiServer /usr/etc/httpd/fcgi-bin/file_upload.fcgi -processes 2 This instructs Apache to launch two copies of file_upload.fcgi at startup time. USING FASTCGI SCRIPTS AS CGI SCRIPTS
Any script that works correctly as a FastCGI script will also work correctly when installed as a vanilla CGI script. However it will not see any performance benefit. EXTERNAL FASTCGI SERVER INVOCATION
FastCGI supports a TCP/IP transport mechanism which allows FastCGI scripts to run external to the webserver, perhaps on a remote machine. To configure the webserver to connect to an external FastCGI server, you would add the following to your srm.conf: FastCgiExternalServer /usr/etc/httpd/fcgi-bin/file_upload.fcgi -host sputnik:8888 Two environment variables affect how the "CGI::Fast" object is created, allowing "CGI::Fast" to be used as an external FastCGI server. (See "FCGI" documentation for "FCGI::OpenSocket" for more information.) FCGI_SOCKET_PATH The address (TCP/IP) or path (UNIX Domain) of the socket the external FastCGI script to which bind an listen for incoming connections from the web server. FCGI_LISTEN_QUEUE Maximum length of the queue of pending connections. For example: #!/usr/local/bin/perl # must be a FastCGI version of perl! use CGI::Fast; &do_some_initialization(); $ENV{FCGI_SOCKET_PATH} = "sputnik:8888"; $ENV{FCGI_LISTEN_QUEUE} = 100; while ($q = new CGI::Fast) { &process_request($q); } CAVEATS
I haven't tested this very much. AUTHOR INFORMATION
Copyright 1996-1998, Lincoln D. Stein. All rights reserved. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. Address bug reports and comments to: lstein@cshl.org BUGS
This section intentionally left blank. SEE ALSO
CGI::Carp, CGI perl v5.12.1 2010-07-01 CGI::Fast(3pm)
All times are GMT -4. The time now is 07:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy