how to assign to each variable after selected? Post: 302306584

Sponsored Content

Top Forums Shell Programming and Scripting how to assign to each variable after selected? Post 302306584 by ryanW on Monday 13th of April 2009 08:27:40 AM

04-13-2009

Registered User

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

10 More Discussions You Might Find Interesting

1. 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.

2. 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?

3. 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...

4. 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...

5. 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...

6. 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...

7. 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

8. 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...

9. 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...

10. 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 ...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

assign a value to variable

Discussion started by: markjason

2. Shell Programming and Scripting

assign a value to a variable

Discussion started by: Shivdatta

3. Shell Programming and Scripting

Not able to assign a value to variable

Discussion started by: Amey Joshi

4. UNIX for Dummies Questions & Answers

outputting selected characters from within a variable

Discussion started by: skinnygav

5. Shell Programming and Scripting

Assign this to a variable....

Discussion started by: ak835

6. Shell Programming and Scripting

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

Discussion started by: tiger2000

7. Shell Programming and Scripting

Shell assign variable to another variable

Discussion started by: 3junior

8. UNIX for Beginners Questions & Answers

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

Discussion started by: ektubbe

9. UNIX for Beginners Questions & Answers

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

Discussion started by: geomarine

10. UNIX for Beginners Questions & Answers

Assign value to variable

Discussion started by: Master_Mind