Search Results

Search: Posts Made By: rollthecoin
1,547
Posted By rollthecoin
While $$$$$$
db2 connect...

LINE=........

while [ "$LINE" != 0 ]
do
read LINE
A=`echo $LINE|awk -F/ '{print $1}'`
B=`echo $LINE|awk -F/ '{print $2}'`
done

echo $A
echo $B
db2 terminate
script...
12,022
Posted By rollthecoin
the data to be put in LINE is like 10dfs 20-gy...
the data to be put in LINE is like
10dfs 20-gy 30=tyop/40tup 50poi 60-ghu

when i gave this data in
A=`echo $LINE|tr '/' ' '|awk '{print $1}'`
B=`echo $LINE|tr '/' ' '|awk '{print $2}'`
echo...
12,022
Posted By rollthecoin
i gave the command in my script as echo $fol...
i gave the command in my script as

echo $fol | awk -F/ '{ print $1 "," $2 }'

will this succeed?
I just et the output as

valueof$1,valueof$2

This is not getting substitute in the place...
12,022
Posted By rollthecoin
i substituted the value for tea. how to give...
i substituted the value for tea.

how to give the command with $tea?
12,022
Posted By rollthecoin
no values are there. its just blank
no values are there. its just blank
12,022
Posted By rollthecoin
I dont get any values for those $1 and $2
I dont get any values for those $1 and $2
12,022
Posted By rollthecoin
I am not getting the values in $1 and $2. ...
I am not getting the values in $1 and $2.

Is there any other way to follow this?
12,022
Posted By rollthecoin
but the output 423562143124/53125351276 is...
but the output
423562143124/53125351276 is already stored in a variable '$tea'

Is it possible to use the awk command on $tea.

May i know that please.
12,022
Posted By rollthecoin
ksh :: want to cut the strings
I have contents like

423562143124/53125351276
sdgas/347236
sjhdk;ls'ald/y62783612763

I need a command that would make the string before / and after / as separate output as (A should contain ...
1,875
Posted By rollthecoin
Thx a lot for trying to help me. Now i have...
Thx a lot for trying to help me.

Now i have rectified that mistake.

can we use substr for the decimal type of data?

I get Error like this
SQL0440N No authorized routine named "SUBSTR" of...
1,875
Posted By rollthecoin
substitue of values.
$db2 connection ...........Q

a=`$db2 -x "select A from tablename where z in (select z from tablename Q where condition fetch first 1 rows only ) with ur"`
b=`$db2 -x "select B from tablename...
Forum: AIX 07-05-2008
4,183
Posted By rollthecoin
The input is not constant. It varies repeatedly.
The input is not constant. It varies repeatedly.
Forum: AIX 06-26-2008
5,324
Posted By rollthecoin
download UNIX AIX
what are things should i download and from where?
which website? i want to study unix AIX and try all the commands
Forum: AIX 06-26-2008
4,183
Posted By rollthecoin
i need two spaces between 3 and 5
i need two spaces between 3 and 5
Forum: AIX 06-26-2008
4,183
Posted By rollthecoin
column space
Is it possible to give spaces using unix commands at a particular column?

eg:
123 56 89(input)
123 56 89(output)
Forum: AIX 04-28-2008
2,510
Posted By rollthecoin
Connecting to DB
Is it possible to connect to two databases in a single query with different username and passwords?

provide an example pls
2,439
Posted By rollthecoin
Is this a script . Can i have it in a well...
Is this a script . Can i have it in a well defined form? please
2,439
Posted By rollthecoin
A script pls( To retrieve database information)
KSH - Unix -AIX - db2

**************
Get the input from the user say '123' (It varies)

Then i want to connect to a database say "D1"
then i want th extract from the database by giving "select...
Forum: AIX 04-22-2008
51,904
Posted By rollthecoin
I want to insert space without referencing the...
I want to insert space without referencing the 234 or adf or watever?
Forum: AIX 04-22-2008
51,904
Posted By rollthecoin
Hi, I want to insert a single or two or...
Hi,

I want to insert a single or two or three spaces at a particular position.
Hope u understood from the input and how the output should be?
How to determine the position after 234 or adf or...
Forum: AIX 04-18-2008
51,904
Posted By rollthecoin
Myscript #!/usr/bin/ksh sed...
Myscript

#!/usr/bin/ksh
sed '/[^A-Za-z0-9.,#&@]//g' /home/1.txt > /home/2.txt


it throws error like this
"sed: 0602-403 /[^A-Za-z0-9.,#&@]//g is not a recognized function."


why is it...
Forum: AIX 04-16-2008
51,904
Posted By rollthecoin
No. I will tell you clearly. i want to...
No.

I will tell you clearly.

i want to delete a invalid character(which i told you as example '2'.)

The query should check for characters which is not present in the following
A to Z,
a...
Forum: AIX 04-14-2008
51,904
Posted By rollthecoin
How can i replace a character with blank space?
i want a command for my script!!!

say file consists of character 123 125 127.

i need a query to replace the number 2 with 0

so the output should be 103 105 107.

i use unix-aix
Forum: AIX 04-04-2008
2,581
Posted By rollthecoin
To run scripts
How to run a script from any directory?

Should i include any environment or wat should i start with in writing a script ?
Showing results 1 to 24 of 24

 
All times are GMT -4. The time now is 09:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy