Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Combine two arrays. for in for ?.. Post 303042800 by RudiC on Tuesday 7th of January 2020 10:54:37 AM
Old 01-07-2020
How about trying, given your shell offers

- the mapfile command
- "here documents",


and db2 reads from stdin,



Code:
mapfile -td" " F1 < file1                                                                                               
mapfile -td" " F2 < file2                                                                                               
IFS=$'\n'
for i in ${F1[*]}
  do    db2 -x  <<< ${F2[*]/#/select DOCID from ICMADMIN.$i where ITEMID= }
  done
db2 -x
select DOCID from ICMADMIN.1 where ITEMID= a
select DOCID from ICMADMIN.1 where ITEMID= b
select DOCID from ICMADMIN.1 where ITEMID= c
db2 -x
select DOCID from ICMADMIN.2 where ITEMID= a
select DOCID from ICMADMIN.2 where ITEMID= b
select DOCID from ICMADMIN.2 where ITEMID= c
db2 -x
select DOCID from ICMADMIN.3 where ITEMID= a
select DOCID from ICMADMIN.3 where ITEMID= b
select DOCID from ICMADMIN.3 where ITEMID= c
db2 -x
select DOCID from ICMADMIN.4 where ITEMID= a
select DOCID from ICMADMIN.4 where ITEMID= b
select DOCID from ICMADMIN.4 where ITEMID= c
db2 -x
select DOCID from ICMADMIN.5 where ITEMID= a
select DOCID from ICMADMIN.5 where ITEMID= b
select DOCID from ICMADMIN.5 where ITEMID= c

This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Arrays

Dear all, How can i unset arrays. I mean all the subscripts including the array after using them. Could you direct me to some links of array memory handling in the korn shell. Thanks (2 Replies)
Discussion started by: earlysame55
2 Replies

2. Web Development

PHP arrays in arrays

PHP question... I have an SQL query that's pulled back user IDs as a set of columns. Rather than IDs, I want to use their names. So I have an array of columns $col with values 1,7,3,12 etc and I've got an array $person with values "Fred", "Bert", "Tom" etc So what I want to do is display the... (3 Replies)
Discussion started by: JerryHone
3 Replies

3. UNIX for Dummies Questions & Answers

arrays how to?

Hello, I am some what of a newbie to awk scripting and I seem to be struggling with this problem. I know I need to use arrays but I can't figure out how to use them. I have an input file that looks like this; Name,Team,First Test, Second Test, Third Test Crystal,Red,5,17,22... (1 Reply)
Discussion started by: vlopez
1 Replies

4. Shell Programming and Scripting

combine

Hi I am having text file like this 001|ramu|hno221|>< sheshadripuram|delhi|560061>< 002|krishna|hno225|>< newdelhimain|delhi|560061>< i want to combine every two lines as single...line... i.e 001|ramu|hno221|sheshadripuram|delhi|560061 can u pls help me (3 Replies)
Discussion started by: suryanarayana
3 Replies

5. Shell Programming and Scripting

bash: combine arrays with weird substitution/references

Hi all. I'm trying to finish a bash script with the following elements: ARRAY="blah $ITEM blah blah" ARRAY="blah blah $ITEM blah bluh" #ARRAY="...." # ...the ARRAY elements represent a variable but defined # syntax and they're all hard-coded in the script. #(...) ITEMS='1.0 2.3... (2 Replies)
Discussion started by: yomaya
2 Replies

6. Programming

question about int arrays and file pointer arrays

if i declare both but don't input any variables what values will the int array and file pointer array have on default, and if i want to reset any of the elements of both arrays to default, should i just set it to 0 or NULL or what? (1 Reply)
Discussion started by: omega666
1 Replies

7. Shell Programming and Scripting

How can I use the arrays ?

Hi all, I have a file test1.txt with the below contents abc def ghj xyz I tried printing these values using arrays. Script tried : =========== set -A array1 `cat test1.txt` count=${#array1 } i=0 while do echo "element of array $array1" done (1 Reply)
Discussion started by: dnam9917
1 Replies

8. Programming

Arrays in C++

I've noticed something interesting in C++ programming. I've always done tricky stuff with pointers and references to have functions deal with arrays. Doing exercises again out of a C++ book has shown me an easier way, I didn't even know was there. It's weird to me. When dealing with arrays, it... (4 Replies)
Discussion started by: John Tate
4 Replies

9. Shell Programming and Scripting

Using arrays?

I have never used arrays before but I have a script like this: var1=$(for i in $(cat /tmp/jobs.021013);do $LIST -job $i -all | perl -ne 'print /.*(\bInfo.bptm\(pid=\d{3,5}).*/' | tr -d "(Info=regpid" | tr -d ')'; $LIST -job $i -all | cut -f7 -d','| sed -e "s/^\(*\)\(*\)\(*\)\(.*\)/\1... (2 Replies)
Discussion started by: newbie2010
2 Replies

10. UNIX for Dummies Questions & Answers

Arrays

Am using bash For eg: Suppose i have a array arr=(1 2 3 4 5 6 7 8 9 10 11 12) suppose i give input 5 to a script and script should able to print values greater than or equal to 5 like below: Input: 5 output: 5,6,7,8,9,10,11,12 (7 Replies)
Discussion started by: manid
7 Replies
GRID-MAPFILE-DELET(8)						  Globus Commands					     GRID-MAPFILE-DELET(8)

NAME
grid-mapfile-delete-entry - Remove entries from a gridmap file SYNOPSIS
grid-mapfile-delete-entry [-help] [-usage] [-version] [-versions] grid-mapfile-delete-entry {-dn DISTINGUISHED-NAME} {-ln LOCAL-NAME...} [[-d] | [-dryrun]] [[-mapfile MAPFILE] | [-f MAPFILE]] DESCRIPTION
The grid-mapfile-delete-entry program deletes mappings from a gridmap file. If both the -dn and -ln> options are specified, grid-mapfile-delete-entry removes entries which meet both criteria (remove entries mapping DISTINGUISHED-NAME to LOCAL-NAME for each LOCAL-NAME specified). If only -dn or -ln is specified all entries for that DISTINGUISHED-NAME or LOCAL-NAME are removed. By default, grid-mapfile-delete-entry will modify the gridmap file named by the GRIDMAP environment variable if present, or the file /etc/grid-security/grid-mapfile if not. This can be changed by the use of the -mapfile or -f command-line options. Prior to modifying a gridmap file, grid-mapfile-delete-entry saves its current contents to a file with the string .old appended to the original file name. The full set of command-line options to grid-mapfile-delete-entry are: -help, -usage Display the command-line options to grid-mapfile-delete-entry. -version, -versions Display the version number of the grid-mapfile-delete-entry command. The second form includes more details. -dn DISTINGUISHED-NAME The X.509 distinguished name to remove from the gridmap file. If the -ln option is not specified, remove all entries for this name; otherwise, remove entries that match both this name and the local name. The name should be in OpenSSL's oneline format. -ln LOCAL-NAME... The POSIX user name to remove from the gridmap file. Include multiple LOCAL-NAME strings after the -ln command-line option to remove multiple names from the gridmap. If the -dn option is not specifeid, remove all entries for these names; otherwise, remove entries that match the DISTINGUISHED-NAME and any of the LOCAL-NAME values. -d, -dryrun Display diagnostics about what would be removed from the gridmap file, but don't actually modify the file. -mapfile MAPFILE, -f MAPFILE Modify the gridmap file named by MAPFILE instead of the default. EXAMPLES
Remove all mappings for a distinguished name: % grid-mapfile-delete-entry "/DC=org/DC=example/DC=grid/CN=Joe User" Modifying /etc/grid-security/grid-mapfile ... Deleting entry: "/DC=org/DC=example/DC=grid/CN=Joe User" juser,juser2 (1) entry deleted Remove the mapping between a distinguished name and a single local username: % grid-mapfile-delete-entry "/DC=org/DC=example/DC=grid/CN=Joe User" -ln juser2 Modifying /etc/grid-security/grid-mapfile ... Current entry: "/DC=org/DC=example/DC=grid/CN=Joe User" juser (1) mapping removed: (juser2), (0) not present and ignored (0) entries deleted ENVIRONMENT VARIABLES
The following environment variables affect the execution of grid-mapfile-delete-entry: GRIDMAP Path to the default gridmap to modify. FILES
The following files affect the execution of grid-mapfile-delete-entry: /etc/grid-security/grid-mapfile Path to the default gridmap to modify if GRIDMAP environment variable is not set. SEE ALSO
grid-mapfile-add-entry(8), grid-mapfile-check-consistency(8) AUTHOR
University of Chicago Globus Toolkit 5.0.1 03/19/2010 GRID-MAPFILE-DELET(8)
All times are GMT -4. The time now is 05:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy