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
sleep(1) General Commands Manual sleep(1)
NAME
sleep - Suspends execution for at least the specified time
SYNOPSIS
sleep seconds
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
sleep: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
None
OPERANDS
Non-negative integer specifying the number of seconds for which execution is to be suspended.
DESCRIPTION
The sleep command suspends execution of a process for at least the interval specified by seconds, which can range from 0 to 2,147,483,647
seconds. Depending on system activity, the actual time of suspension may be longer. See the sleep(3) reference page.
[Tru64 UNIX] seconds can be entered as a non-negative decimal, octal, or hexadecimal value.
NOTES
If sleep receives a SIGALARM signal before process execution has resumed, sleep takes one of the following actions: Terminates normally
with a 0 (zero) exit status. (See the sleep(3) reference page for more information.) Ignores the signal Performs default processing
EXIT STATUS
The following exit values are returned: Execution was successfully suspended for at least the requested time, or a SIGALARM signal was
received. An error occurred.
EXAMPLES
To display a message at 4-minute intervals for 20 minutes, create a shell script called remind containing the following:
for i do sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i done
To display the message Try calling NHK at 4-minute intervals, enter: remind 'Try calling NHK' To run a command at regular intervals,
create a shell script containing the following:
while true do
date
sleep 60 done
This displays the date and time once a minute. To execute a command after a specified interval, enter the following; (sleep 3600;
echo Time's up) &
This displays the message "Time's up" after one hour.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of sleep: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for-
mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of
LC_MESSAGES.
SEE ALSO
Commands: wait(1)
Functions: alarm(3), pause(3), sigaction(2), sleep(3)
Standards: standards(5)
sleep(1)