10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:
sqlplus username/password@dbname << EOI
SET HEADING OFF
SPOOL MAX_DATE_VAL.txt
select max(LAST_UPDT_DATE) from source_defect;
SPOOL OFF
here the result is stored in... (0 Replies)
Discussion started by: Shilpi Gupta
0 Replies
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:
#!/bin/ksh
LOGON_STR="TDDB/user,paswd;"
DATAFILE=/path/a.lst;
DEBUG=0
>$DATAFILE
fexp > /dev/null... (3 Replies)
Discussion started by: usrrenny
3 Replies
3. 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
1 Replies
4. Shell Programming and Scripting
In a .txt file i have a set of teradata queries which i need to execute and capture result for all queries.Is there any way to run teradata queries from a file? (1 Reply)
Discussion started by: katakamvivek
1 Replies
5. 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
6. Shell Programming and Scripting
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?
.LOGON
.EXPORT file=export.txt;
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || ... (2 Replies)
Discussion started by: unankix
2 Replies
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
8 Replies
8. Programming
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
3 Replies
9. Programming
hi,
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.
I tried
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
3 Replies
10. 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
ruptime(1) General Commands Manual ruptime(1)
NAME
ruptime - show status of local machines
SYNOPSIS
DESCRIPTION
outputs a status line for each machine on the local network that is running the daemon. status lines are formed from packets broadcast
once every 3 minutes between daemons (see rwhod(1M)) on each host on the network. Each status line has a field for the name of the
machine, the status of the machine (up or down), how long the machine has been up or down, the number of users logged into the machine, and
the 1-, 5- and 15-minute load averages for the machine when the packet was sent.
The status of the machine is reported as ``up'' unless no report has been received from the machine for 11 minutes or more.
The length of time that the machine has been up is shown as:
Load averages are the average number of jobs in the run queue over the last 1-, 5- and 15-minute intervals when the packet was sent.
An example status line output by might be:
The above status line would be interpreted as follows:
is presently ``up'' and has been up for 1 day, 5 hours and 15 minutes. It currently has 7 users logged in. Over the last 1-minute inter-
val, an average of 1.47 jobs were in the run queue. Over the last 5-minute interval, an average of 1.16 jobs were in the run queue. Over
the last 15-minute interval, an average of 0.80 jobs were in the run queue.
If a user has not used the system for an hour or more, the user is considered idle. Idle users are not shown unless the option is speci-
fied.
Options
If no options are specified, the listing is sorted by host name. Options change sorting order as follows:
Sort by load average.
Sort by up time.
Sort by the number of users.
Reverse the sort order.
DIAGNOSTICS
No status report files in
Ask the system administrator to check whether the daemon is running.
AUTHOR
was developed by the University of California, Berkeley.
FILES
Data files
SEE ALSO
rwho(1), rwhod(1M).
ruptime(1)