10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:
sqlplus username/password@dbname << EOI
SET HEADING OFF
select max(LAST_UPDT_DATE) from source_defect;
here the result is stored in... (0 Replies)
Discussion started by: Shilpi Gupta
2. Shell Programming and Scripting
Hi, I am trying to use Teradata fastexport in ksh, but getting error as below
temp1.ksh: line 7: syntax error at line 10: `newline' unexpected
below is my code:
fexp > /dev/null... (3 Replies)
Discussion started by: usrrenny
3. UNIX for Advanced & Expert Users
HI Team ,
I have interesting issue observed when using teradata sql assistant(14.1) and Informatica tool (9.5) versions.
I created SQL code in teradata where source count is 5000 records . I am using source and target database as teradata and trying to load using informatica tool . Its straight... (0 Replies)
Discussion started by: Perlbaby
4. UNIX and Linux Applications
Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into... (1 Reply)
Discussion started by: islanderman
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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?
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || ... (2 Replies)
Discussion started by: unankix
7. Shell Programming and Scripting
Hi, I've been trying to develop a script that performs the parsing of a log every 1 minute and then generating some statistics. I'm fairly new to programming and this is why I come to ask if I can lend a hand.
this is my log:
xxxx 16/04/2012 17:00:52 - xxxx714 - E234 - Time= 119 ms.... (8 Replies)
Discussion started by: jockx
How do i connect from C program to teradata Database?
The C program is being executed from a Unix script, AIX.
I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database. (3 Replies)
Discussion started by: yschd
I want to compile a program in C. It have a multiple calls to teradata. I have no idea how to compile in Aix.
The compiler that I should be use is cc.
cc -G -KPIC tdsfbd0358.c this generates a tdsfbd0358.i and after I have no Idea what I have to make, a link? how?... (3 Replies)
Discussion started by: kajum
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'
FOR C_FLTSLS_STR_LP AS... (0 Replies)
Discussion started by: yschd
guess(8) NVRAM WakeUp guess(8)
guess - Tries to guess the configuration by comparing four dumps of the NVRAM.
guess tries to figure out the position of the wakeup time settings in the NVRAM. Just run guess from within the directory, where the four
NVRAM dumps at stored as "18.104.22.168+", "22.214.171.124+", "01.00.00.00+" and "01.00.00.00-". The file names denote the wakeup time, you have
to set manually, before dumping the NVRAM:
<DD> = Day of month
<HH> = Hour
<MM> = Minute
<SS> = Second
<status> = wakeup enabled (+) or disabled (-)
nvram-wakeup(8), guess-helper(8), README.mb
Written by Sergei Haller <Sergei.Haller@math.uni-giessen.de>.
Report bugs at the bug tracking system (see HOMEPAGE) or on the mailing list email@example.com
Copyright (C) 2001-2004 Sergei Haller.
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
Linux Jul 07 2004 guess(8)