03-03-2010
Make sure you have permission to truncate the table with the user that you are logged in.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure)
While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies
2. Shell Programming and Scripting
Dear all:
I want to write a script capable of reading specific rows and collumns of a table, into a variable.
Just imagine i have a file named table.dat which contains:
GENERAL INFORMATION
Col 1 Col2 Col3
1 1
2 2
3 3
4 4
What i want to do... (13 Replies)
Discussion started by: luiscarvalheiro
13 Replies
3. Shell Programming and Scripting
I want to add some columns to a existing tables through a shell script.
Please help. (2 Replies)
Discussion started by: ankitgupta
2 Replies
4. Shell Programming and Scripting
Hi All,
I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking.
Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies
5. Shell Programming and Scripting
Hi,
Can anyone tell me that, How to create table in Oracle database through shell script(ksh).
Table contains 3 fields,
1] Emp ID, String, primary key
2] Name, String
3] B Date, date.
Thanks in advance. (6 Replies)
Discussion started by: Poonamol
6 Replies
6. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
7. Shell Programming and Scripting
Hi,
i need a bit help. I must write a script with shell- and sed-commands, which reads a table from stdin and writes a html-table on stdout (so i can open it with a web browser). The number of columns must be a parameter for the script, so i can start it for example with: "./htmltab.sh 3... (3 Replies)
Discussion started by: scruffytramp
3 Replies
8. Shell Programming and Scripting
#! /bin/ksh
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
#. .profile
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
... (4 Replies)
Discussion started by: ankit.mca.aaidu
4 Replies
9. Homework & Coursework Questions
input file txt file
2000 1 name
2000 2 addr
2000 3 phone
2000 4 email
1000 1 name
1000 2 addr
1000 3 phone
1000 4 email
3000 1 name
3000 2 addr
3000 ... (4 Replies)
Discussion started by: senmatrix
4 Replies
10. Shell Programming and Scripting
Hi,
I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env.
I was able to connect to the prod db and then run a simple query as below.
@@@@@@@@@@
... (7 Replies)
Discussion started by: arunpvp
7 Replies
LEARN ABOUT ULTRIX
ftruncate
truncate(2) System Calls Manual truncate(2)
Name
truncate, ftruncate - truncate a file to a specified length
Syntax
truncate(path, length)
char *path;
int length;
ftruncate(fd, length)
int fd, length;
Description
The system call causes the file named by path or referenced by fd to be truncated to, at most, length bytes in size. If the file previ-
ously was larger than this size, the extra data is lost. With the file must be open for writing.
Return Values
A value of zero (0) is returned if the call succeeds. If the call fails, a -1 is returned, and the global variable errno specifies the
error.
Restrictions
Partial blocks discarded as the result of truncation are not zero-filled. This can result in holes in files that do not read as zero.
Diagnostics
The system call succeeds unless:
[ENOTDIR] A component of the path prefix is not a directory.
[ENOENT] The named file does not exist.
[EACCES] Search permission is denied for a component of the path prefix.
[EISDIR] The named file is a directory.
[EROFS] The named file resides on a read-only file system.
[ETXTBSY] The file is a pure procedure (shared text) file that is being executed.
[EFAULT] The path points outside the process's allocated address space.
[ENAMETOOLONG] A component of a pathname exceeded 255 characters, or an entire path name exceeded 1023 characters.
[ELOOP] Too many symbolic links were encountered in translating the pathname.
[EIO] An I/O error occurred updating the inode.
The system call succeeds unless:
[EBADF] The fd is not a valid descriptor.
[EINVAL] The fd references a socket, not a file.
[ETIMEDOUT] A connect request or remote file operation failed, because the connected party did not properly respond after a period of
time that is dependent on the communications protocol.
See Also
open(2)
truncate(2)