how to assign to each variable after selected?

Login or Register to Ask a Question and Join Our Community

how to assign to each variable after selected?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting how to assign to each variable after selected?

04-13-2009

Registered User

35, 0

Join Date: Mar 2009

Last Activity: 1 February 2010, 1:27 AM EST

Posts: 35

Thanks Given: 0

Thanked 0 Times in 0 Posts

how to assign to each variable after selected?

Hi Everyone,

I need to assign the value to the variable after selection.
Anyone can help me?

for example:
data_type_SQL=$($CONNECT cat <<-__EOF__
SET NOCOUNT ON
select location_type, location_id, warehouse from JEALOCATION where
LOCATION_ID="$data_LocID_SQL"

for "data_type_SQL" will store the content after selected from databse.
the content should be
->>> |locationtype|locationID|warehouse|

How to make them to assignment to the varuable that i decrela?

local_ty=locationtype
local_id=locationID
wareH=warehouse

thank you

ryanW

View Public Profile for ryanW

Find all posts by ryanW

04-13-2009

Registered User

33, 0

Join Date: Apr 2009

Last Activity: 24 September 2009, 11:44 AM EDT

Posts: 33

Thanks Given: 0

Thanked 0 Times in 0 Posts

Hi,
echo the reply from DB

local_ty=$(echo " |locationtype|locationID|warehouse|" | cut -d\| -f2)
local_id=$(echo " |locationtype|locationID|warehouse|" | cut -d\| -f3)
wareH=$(echo " |locationtype|locationID|warehouse|" | cut -d\| -f4)

Bye

sauron

View Public Profile for sauron

Find all posts by sauron

04-13-2009

Registered User

35, 0

Join Date: Mar 2009

Last Activity: 1 February 2010, 1:27 AM EST

Posts: 35

Thanks Given: 0

Thanked 0 Times in 0 Posts

Hi Sauron..

Thank you again..
the way u teach me.. is working...
but..
the local_ty and local_id no value after i debug in the log..
here is the code.

select LOC_TYPE, LOCATION_ID, WAREHOUSE from JEALOCATION where
LOCATION_ID="$data_LocID_SQL"

data_type_SQL=|G |NRTW |NRT |

localty=$(echo " |$LOC_TYPE|$LOCATION_ID|$WAREHOUSE|" | cut -d\| -f2)
localid=$(echo " |$LOC_TYPE|$LOCATION_ID|$WAREHOUSE|" | cut -d\| -f3)
wareH=$(echo " |$LOC_TYPE|$LOCATION_ID|$WAREHOUSE|" | cut -d\| -f4)
echo "localty=$localty localid=$localid wareH=$wareH" >> ttt.log
result -->>> localty= localid= wareH=NRT

thank you

ryanW

View Public Profile for ryanW

Find all posts by ryanW

04-13-2009

Registered User

33, 0

Join Date: Apr 2009

Last Activity: 24 September 2009, 11:44 AM EDT

Posts: 33

Thanks Given: 0

Thanked 0 Times in 0 Posts

Hi ,
where do you assign a value to:
$LOC_TYPE
$LOCATION_ID
$WAREHOUSE

? i'm a bit confused

sauron

View Public Profile for sauron

Find all posts by sauron

04-13-2009

Registered User

35, 0

Join Date: Mar 2009

Last Activity: 1 February 2010, 1:27 AM EST

Posts: 35

Thanks Given: 0

Thanked 0 Times in 0 Posts

those variable get from select statement.

select LOC_TYPE, LOCATION_ID, WAREHOUSE from JEALOCATION where
LOCATION_ID="NTTR"

LOC_TYPE,LOCATION_ID,WAREHOUSE

ryanW

View Public Profile for ryanW

Find all posts by ryanW

04-13-2009

Registered User

33, 0

Join Date: Apr 2009

Last Activity: 24 September 2009, 11:44 AM EDT

Posts: 33

Thanks Given: 0

Thanked 0 Times in 0 Posts

Hi,
i don't understand why you need to use:
localty=$(echo " |$LOC_TYPE|$LOCATION_ID|$WAREHOUSE|" | cut -d\| -f2)

when you can use
localty=$(echo "$LOC_TYPE")
etc

sauron

View Public Profile for sauron

Find all posts by sauron

04-13-2009

Registered User

35, 0

Join Date: Mar 2009

Last Activity: 1 February 2010, 1:27 AM EST

Posts: 35

Thanks Given: 0

Thanked 0 Times in 0 Posts

Hi Sauron,

for select statement...

data_type_SQL=$($CONNECT cat <<-__EOF__
SET NOCOUNT ON
select LOC_TYPE, WAREHOUSE, LOCATION_ID from JEALOCATION where
LOCATION_ID="$data_LocID_SQL"

got value inside in each LOC_TYPE, WAREHOUSE, LOCATION_ID from data_type_SQL variable..

but when i try to assign each variable... those 3 is empty..

localty=$(echo "$LOC_TYPE")
wareH=$(echo "$WAREHOUSE")
localid=$(echo "$LOCATION_ID")

here is the result after i debug
****************************************

data_type_SQL=|G |NRT |NRTW |

localty=
wareH=
localid=

***************************************

Can u help me?
Thank you

ryanW

View Public Profile for ryanW

Find all posts by ryanW

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Assign value to variable

Hi Guys, I need to assign the value of which has rows to a variable, Can you advise how to do that hive --orcfiledump /hdfs_path/ | grep "Rows" Rows: 131554 I need to assign this row count itself to a unix variable count=$(hive --orcfiledump /hdfs_path/ | grep "Rows") Expected ...

2. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use...

3. UNIX for Beginners Questions & Answers

Need to pass variable in a command and assign value to a variable

Hello All, Hope you're doing well ! I am trying below command to be passed in a shell script, header_date_14 is a variable and $1 is the name of a file I intend to pass as a command line argument, however command line argument is not being accepted. header_date_14=$(m_dump...

4. Shell Programming and Scripting

Shell assign variable to another variable

How can I assign a variable to an variable. IE $car=honda One way I can do it is export $car=honda or let $car=2323 Is there any other ways to preform this task

5. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one...

6. Shell Programming and Scripting

Assign this to a variable....

bash-3.00$ /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}' *.* bash-3.00$ A=` /usr/bin/netstat -an -f inet | awk -F' ' '{if ($1$4 == "tcp*.21")print $5}'` bash-3.00$ echo $A db2_lastdone.bkp As you can see ,after running command i get *.* in return but the same...

7. UNIX for Dummies Questions & Answers

outputting selected characters from within a variable

Hi all, if for example I had a variable containing the string 'hello', is the any way I can output, for example, the e and the 2nd l based on their position in the string not their character (in this case 2 and 4)? any general pointers in the right direction will be much appreciated, at...

8. Shell Programming and Scripting

Not able to assign a value to variable

Hi Experts, I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp. The input file is cat config.csv...

9. Shell Programming and Scripting

assign a value to a variable

I have a list of names in a file. i want to assign those names to a variable in such a manner eg: $cat file.txt pete lisa john var=pete-lisa-john how do i do this in shell scripting?

10. Shell Programming and Scripting

assign a value to variable

I have to assign a result of a query to a vairable like this how can i do this Query = select count(*) from table x=`db2 ${Query}| sed -n '4p'` but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. . Thanks Mark.

Login or Register to Ask a Question