Summary: If the .csv file is reasonably small (say under 100K) try reading it from PL/SQL using UTL_FILE. Otherwise use SQL*Loader, which is very fast but does...
Summary: Hey everybody.. I am wondering what software should I download for my PC at home to write and compile Unix Shell Script? Please reply as soon as possi...
Summary: Hi Guys, I have a unix shell script which is like this... sqlplus -s $FEB_UID/$FEB_PWD@feb_dev |& print -p "select '|'||job_id||'|' from jobre...
Summary: On the Unix side, this korn shell script, will execute your SQL: Unforutunately, I don't know a way of informix creating an Excel spreadsheet. I thi...
Summary: hi, i have an entry: FileName=/home/mqm/adr10098/sample.dat in a file. I want to open this file, search for "FileName=" and then replace the value wit...
Summary: Hi, Can anyone tell me how to write a Unix ksh script to open a file (path provided) and assign a value to a variable in the file and then save the fi...
Summary: I'm a student, and I have a hard time completing this term assignment, if anyone could help me I would appreciate it very much. I did my best to do i...
Summary: Hi guys, I am very new to the shell scripting .... I have a text file with 5 columns and all colums are seperated by some spI need to capture all indi...
Summary: I cheated by scheduling a WS_FTP task on my PC to "pull" from UNIX, rather than using a UNIX shell script to "push" to my PC. Here is the DOS batch fi...
Summary: I have a beginner's question about unix shell(csh). When I run following commmand from csh shell: %>set name = john %>echo $name %>john It works just ...
Summary: Hello! I'm trying to write a shell script, but don't know where to start. I need to do the following: - go into each directory, check for a file name...
Summary: I have a MS Word file with information about some people. I want to retrieve their email ids from this information and send them emails with a pre def...
Summary: Hi, I have a complex shell scripting requirement. 1. I need to fetch last 7 days archived log files by querying database. 2.Then I have to compare th...
Summary: I am struggling. Please help!! I need a shell script that searches for a string (and makes a backup file and substitution) but only if the string is f...
Summary: I want to control the execution of a PL/SQL procedure from a UNIX shell script. Below, I include the script. The control variable which should recive ...
Summary: I use Perl for all of these types of requirements. The core Perl libraries are usually on all Linux and UNIX system because part of the standard OS u...
Summary: Hi! I'm trying to use my shell script variables in my awk-line. Is not working! month3 is my variable and i'm aware that I can't use the $-prefix in a...
Summary: I'm not sure if this is possible, but I assume so. I have a Unix shell script (see example below) which calls 4 other unix shell scripts. However, ...
Summary: Hello I have a question. I am trying to modify a bourne shell script to include some information as to capturing measuring statistics when a process i...
Summary: Can anyone help me with comparing two vaiables in unix shell script. This is what i'm trying.... if [ $X -ne $Y ] then ----- else ---- fi Wher...
Summary: Sorry, but this won't work. This syntax: unload to myarchive delimiter "," select * from mytable; is an informix command - not a unix command. The o...
Summary: Hello All Thanks for the help..I have the ouput going to a .lis file but can I include the mailx command in the same shell script that I am using to...