Search Results

Hi RudiC,

The query works perfectly.

My intention to store the result of the query in a variable which i cant do it through system function.

Is it the problem with AWK ?

...

Hi,

Need your advices,

Input :

select code,status,input from VIEW1.VIEWNAME where IDU_CD IN ('S','N') and status_col='derived')) union select code,status,input from VIEW1.VIEWNAME2...

Hi,

I want to retrieve the base table name for a table and replace the table with the view name in the file.

I was trying to retrieve the base with the below db2 command but i am getting...

Hi, Thanks for your reply.

But this code returns "1" instead of table name.

Hi ,

I am trying to use the below in awk but failed, any one assist please,

awk '{ print $0;
if ( $0 ~ /LOADTMP1/ )
{
print $4;
Table_name=system($( db2 -x "SELECT...

Hi Friends,

There is an command that,

SET -x

I am confused with the SET command , i have gone through man page but still.

could anyone advise the same and necessity of the SET...

Hi,

I am really sorry for this question but still i am confused.

I have shell script called sample.sh

I can execute only with the combination of ./sample.sh

Is ./ really necessary ?...

Hi Folks,

In UNIX, I am quite confused on how to use or when to use ${} $() $ .

For Example ,

if i use variable called "i" then when do i use,

${i}
$(i)
$i

or sometime with...

Hi,

I need to return a value from the function. the value will be the output from cat command which uses random fucntion.

#!/bin/ksh
hello()
{
var1=$(`cat /dev/urandom| tr -dc...

Hi Friends,

I need a quick help in unix scripts,

my aim is to generate random passwords like,

1. first 3 characters are alphabets or numbers
2. then one of special characters like...

Hi Guys,

Could you please kindly explain what exactly the below SED command will do ?

I am quite confused and i assumed that,
sed 's/[ \t]*$/ /'

1. It will remove tab and extra spaces...

Guys,

My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe,

I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to...

Hi,

My input file data will be
|ABCD|EFGH|IJKL|MNOP
|ABCD|EF\|GH|IJKL|MNOP

I am expecting output ,
|"ABCD"|"EFGH"|"IJKL"|"MNOP"
|"ABCD"|"EF|GH"|"IJKL"|"MNOP"

Note : The change...

Hi,

the folder /home/nandy/test will have two files called
notepad1
nodepad2

when i issued

/home/nandy/test> tar -cvf componse.tar ./notepad1 ./notepad2 and no error
...

Hi,

What is the exact output tells me when i issued UNAME and WHO ?

Regards,
Nantha.Y

Hi,

When i was trying to execute binary file i am getting the below " cannot execute binary file " error message."

My Unix Version is : Red Hat Enterprise Linux Server release 5.1 (Tikanga)
...

Hi,

Just need clarification here,

1. What is the purpose mentioning 1 after gsub {gsub(/\|/, " ", $2)}1'
2. Cant i do without FIELDWIDTH because i have more than 190 columns in my datafile....

Hi,

Agree but I do not want to print it rather I want to get update in the file. I meant file content should be changed as desired.

Please assist and Thanks indeed for your quick...

Hi,

The data from position 25 to 30 should not contain | as | is the delimiter. Hence the if the position 25 to 30 contain |, we just want to replace it with SPACE.

I hope that I am...

Input file :

12345|12345|12345|12345
12345|12345|12|13|12345
12345|12345|1|234|12345
12345|12345|12345|12345

Output :

12345|12345|12345|12345
12345|12345|12 13|12345
...