05-08-2019
That code snippet seems a bit overcomplicated with its double loop and sed operating on intermediate files. Do you know about the (oracle) set head off equivalent in mysql: -N and -s? Et voila, two sed invocations gone. You then could pipe the first select(id numbers) into the second loop.
What's the result of the first select per every single loop iteration given we have three times the same film title in file 2 ?
One more question: is 2 the name of the input file, and thus NOT a file descriptor?
Last edited by RudiC; 05-08-2019 at 08:15 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello all
I'm new to this site and I have to say that ,it is just awesome. I was able to get most of my questions answered by reading the archives.
I've been a UNIX programmer for a while now but new to administration.
I just installed SunOS 5.9 on my desktop ( i86pc) . Everything... (3 Replies)
Discussion started by: luft
3 Replies
2. Solaris
Hi,
we are running solaris 9 on V280R. Due to power failure, one disk's label and lost its details like drive type etc.
Disk details:
<SUN72G cyl 14087 alt 2 hd 24 sec 424>
single partition on slice 6 with UFS.
The below i see when i run "format" command
.....
.....
4.... (1 Reply)
Discussion started by: prvnrk
1 Replies
3. Solaris
Hello,
I have a problem - I created a chrooted jail for one user. When I'm logged in as root, everything work fine, but when I'm logged in as a chrooted user - I have many problems:
1. When I execute the command ping, I get weird results:
bash-3.00$ usr/sbin/ping localhost ... (4 Replies)
Discussion started by: Przemek
4 Replies
4. Shell Programming and Scripting
Hi everyone, I am trying to replace a string that contains a space using sed. A typical input file is:
CATEGORY=1 1:1.0
CATEGORY=2 13:1.0
CATEGORY=3 1:99.0
CATEGORY=8 14:1.0
CATEGORY=11 1:1.0
I want to use a string (as it can change) to make replacements using
... (3 Replies)
Discussion started by: BlueberryPickle
3 Replies
5. HP-UX
My environment is HP-UX...
NIS CEL | uname -a
HP-UX s53kj113 B.11.11 U 9000/800 1510201964 unlimited-user license
I ran this command directly from the server's sqllplus. Logically, it should have work.
But in my case, it always escaped the 1st character of the next command after the... (3 Replies)
Discussion started by: aimy
3 Replies
6. AIX
Hi Guys,
I found on one of the server there are 2 VG's which I dont have any Idea of who created .. as below
bash-3.00$ lsvg
old_rootvg
rootvg
datavg
altinst_rootvg
altinst_rootvg under is meant for alternate disk installation.. But I'm not sure for which version of OS it was... (5 Replies)
Discussion started by: kkeng808
5 Replies
7. Solaris
Dear all I have formatted/labeled/partitioned my new disk but when trying to mount it is returning 'unknown fstype' .Can you please let me know how to solve this problem? Thank you (37 Replies)
Discussion started by: hadimotamedi
37 Replies
8. Shell Programming and Scripting
My OS is Linux GL version 2.4.26. I am trying to make a shell script that outputs a chart displaying info of who is online, boot time, and the real time, I have manage to get it to work, but I still get the error "./user/script: line 1: : command not found." I do in fact have access to root, if... (2 Replies)
Discussion started by: thatguy565
2 Replies
9. Shell Programming and Scripting
Error mounting: mount exited with exit code 1: helper failed with:
mount: wrong fs type, bad option, bad superblock on /dev/sdb1,
missing codepage or helper program, or other error
In some cases useful info is found in syslog - try
dmesg | tail or soThis happens when I try... (17 Replies)
Discussion started by: 1in10
17 Replies
10. Programming
In my further exploration of Arduino, today I decided to install the arduino-cli on my mac today.
https://github.com/arduino/arduino-cli
I followed the instructions for macOS but when I got to this part:
arduino-cli board list
I got the dreaded "Unknown" Fully Qualified Board Name... (1 Reply)
Discussion started by: Neo
1 Replies
break(1) User Commands break(1)
NAME
break, continue - shell built-in functions to escape from or advance within a controlling while, for, foreach, or until loop
SYNOPSIS
sh
break [n]
continue [n]
csh
break
continue
ksh
*break [n]
*continue [n]
DESCRIPTION
sh
The break utility exits from the enclosing for or while loop, if any. If n is specified, break n levels.
The continue utility resumes the next iteration of the enclosing for or while loop. If n is specified, resume at the n-th enclosing loop.
csh
The break utility resumes execution after the end of the nearest enclosing foreach or while loop. The remaining commands on the current
line are executed. This allows multilevel breaks to be written as a list of break commands, all on one line.
The continue utility continues execution of the next iteration of the nearest enclosing while or foreach loop.
ksh
The break utility exits from the enclosed for, while, until, or select loop, if any. If n is specified, then break n levels. If n is
greater than the number of enclosing loops, the outermost enclosing loop shall be exited.
The continue utility resumes the next iteration of the enclosed for, while, until, or select loop. If n is specified then resume at the n-
th enclosed loop. If n is greater than the number of enclosing loops, the outermost enclosing loop shall be used.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words that follow a command preceded by ** that are in the format of a variable assignment are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign, and also that word splitting and file name genera-
tion are not performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
csh(1), exit(1), ksh(1), sh( 1), attributes(5)
SunOS 5.10 17 Jul 2002 break(1)