The fault is because you are trying to store the whole output file in an environment variable called $SQL and you have overflowed. There is rarely ever a reason to store more than one record in an environment variable.
The solution by "skmdu" writes straight to disc and is not limited to the maximum size of an environment variable.
A similar method is:
Code:
sed -e 's/#,MKT_TBL mkt#/Table_name/g' file1 > outputfile
BTW. The code you posted does not write to a file.
Hi!
I have some shell scripts receiving in input lots of parameters and I need to select the ones having a particular value in one parameter.
A typical shell command line is:
PROMPT > shell_name.ksh -avalue_a -bvalue_b -cvalue_c -dvalue_d ...
I used a combinaton of ps and grep commands... (1 Reply)
Hi!
I have some shell scripts receiving in input lots of parameters and I need to select the ones having a particular value in one parameter.
A typical shell command line is:
PROMPT > shell_name.ksh -avalue_a -bvalue_b -cvalue_c -dvalue_d ...
I used a combinaton of ps and grep commands... (5 Replies)
Hi
Problem of ps on Solaris 8 and 9
Perhaps a silly question but I can't find a solution.
the output of the command ps -ef is truncated.
I've tried to change the terminal settings with stty putting
a big number of colums: no change.
Following the man page of ps i have set the variable... (8 Replies)
OK, I'm stumped.
I have a shell script that reads a list, and for every item in the list performs a lookup in our Active Directory. Now, it seems that when I pipe the results into grep, the complete results are not there (truncated?). I'm not sure if this is a limit of the pipe, grep, shell... (1 Reply)
May be this is a known issue. When I am using sed to change a string (globally) in multiple files, it is doing its job while truncating the file. So the xml files are losing some of the tags
Any work around? Appreciate your help guys......
Here is the code.....
#!/bin/sh
for files in... (2 Replies)
Hi Guys,
I have a master script file.
That calls the other script files. The sub script files append some of the data to the log file.
Once the master script completes one sub script execution and returns to execute other sub script that appends to the same log file. the log file gets... (2 Replies)
I'm not sure if the problem I'm seeing is an artifact of sed or simply a beginner's mistake. Here's the problem: I want to add a zero-width space following each underscore between XML tags. For example, if I had the following xml:
<MY_BIG_TAG>This_is_a_test</MY_BIG_TAG>
It should look like... (8 Replies)
Hi,
I have Solaris-10 server. /usr/ucb/ps auxww is showing full path if I am running it from root. But if I run it from non-root user, its output is truncated. I don't want to use any other alternate command.
Please suggest, what can be its solution.
Terminal is set to term. (21 Replies)
Today I needed to take a look through a load of large backup files, so I wrote the following line to find them, order them by size, and print the file sizes in GB along with the filename. What happened was odd, the output was all as expected except for the first output line which had the filename... (4 Replies)
Hi All,
here is an output of my command and the problem is that my output string is truncated, I want to exact the full string, I am on BASH shell, please help me out.
Regards
Rahul
command with Output :
lonss05903:cmdsvc01 /home/cmdsvc01 > ps -aef|grep 'Copy'
cmdsvc01 2642 8675 ... (7 Replies)
Discussion started by: rahulkalra9
7 Replies
LEARN ABOUT HPUX
setenv
setenv(3C)setenv(3C)NAME
setenv(), unsetenv() - add, update or remove an environment variable
SYNOPSIS
Parameters
envname Points to a string containing the name of an environment variable to be added or altered. This should not be a NULL
pointer or null string, and the string should not contain an equal character.
envval Points to a string containing the value to be set for the variable envname.
overwrite Indicates whether to overwrite the value of envname variable or not, if it already exists. Expected values are non-zero
and zero. If the environment variable does not exist in the environment, then the value of this variable is ignored.
DESCRIPTION
and functions update the environment of the calling process.
If envname does not exist, the function ignores the value of overwrite and adds the variable envname to the environment with the value
envval. If envname exists and overwrite is non-zero, then the variable envname is updated with the new value envval. If envname exists
and overwrite is zero, then the variable is not updated, and the function is considered to have completed successfully.
The function deletes the variable envname from the environment, if it exists. If the envname variable does not exist in the current envi-
ronment, the environment is unchanged, and the function is considered to have completed successfully.
If the application modifies environ or the pointers to which it points, the behavior of and is undefined.
EXTERNAL INFLUENCES
Locale
The category determines the interpretation of characters in string as single- and/or multi-byte characters.
International Code Set Support
Single- and multi-byte character code sets are supported.
RETURN VALUE
The and functions return zero on success; otherwise they return and set to indicate the error.
ERRORS
If the function fails, is set to one of the following values:
Sufficient memory is not available to add a variable or its value to
the environment.
The envname argument is a null pointer, points to an empty string, or points to a string containing an equal character.
If the function fails, is set to the following value:
The envname argument is a null pointer, points to an empty string, or points to a string containing an equal character.
EXAMPLES
The following code adds a new environment variable to the current environment.
The following code updates the variable
The following code removes the variable from the current environment.
WARNINGS
The and functions manipulate the environment pointed to by environ, and can be used in conjunction with However, envp (the third argument
to main) is not changed.
The uses to enlarge the environment (see malloc(3C)).
After the or function is called, environment variables may not be in alphabetical order.
AUTHOR
and were developed by HP.
SEE ALSO exec(2), getenv(3C), malloc(3C), putenv(3C), environ(5), thread_safety(5).
STANDARDS CONFORMANCE setenv(3C)