11-17-2017
Ok, let me describe the requirement again and that is copy the files from one location to another and rename the copied files.
Source location and names to rename the files comes from SQL query. Query results two columns. One is the report name and other is path where file is currently placed.
Shell script will read the report name and path from the first row of the query.
Copy the file then rename it and moves towards next record and so on till end of query records.
---------- Post updated 11-17-17 at 02:06 AM ---------- Previous update was 11-16-17 at 05:34 AM ----------
I would like to thanks for the support and advise. Lean something new from experts.
Problem has been solved.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am newbie and am just trying to connect to oracle from shell script ,,,but I am getting the following error
./prog.sh: line 20: syntax error: unexpected end of file
The scripts is :
#!/bin/bash
O=$IFS; IFS=",";
while read a b c d
do
echo $c
... (6 Replies)
Discussion started by: thana
6 Replies
2. UNIX for Advanced & Expert Users
I ran the following scripts and everytime i get the errot as follows
Line 54: unexpected EOF while looking for matching ','
line 57 syntex error unexpected end of file#!/bin/ksh
set -x
BKUP_DIR=/u03/backups/abu/nightly_backup
LOG_FILE=/u03/backups/abu/backup.log
ORACLE_HOME=... (9 Replies)
Discussion started by: manna
9 Replies
3. Shell Programming and Scripting
Hi everyone,
I am trying to search for a string in a file that is partly made up of a variable. Here's the code:
echo "parentCategory = $parentCategory"
echo "parentCategoryFormatted = $parentCategoryFormatted"
numUrlsFoundInParentCategory=`grep -c "<Topic r:id=\"Top\/World\/Français\/"... (2 Replies)
Discussion started by: BlueberryPickle
2 Replies
4. UNIX for Dummies Questions & Answers
hello everyone...im having this problem with unexpected EOF with line 85 which is..i cant see whats wrong with it..can any1 plz help me out.
read -p "$p1 please enter the number of tries you wish to have:" lifeline
function main()
{
guessnum=0
read -p "Please enter if its sinle player game... (1 Reply)
Discussion started by: Freakhan
1 Replies
5. Shell Programming and Scripting
Hi,
i have a script as below.
i'm using sun solaris 10.
Script :
#! /bin/sh
load() {
find /stage_area/loadfiles/telsims/test/ -type f -name "*$1" -print > /tmp/testfile.txt
fc=`cat /tmp/testfile.txt | wc -l | sed 's/ //g'`
if ; then
echo " Files Not Avaliable"
exit
else... (12 Replies)
Discussion started by: apple2685
12 Replies
6. Shell Programming and Scripting
i'm writing a bash script that uploads a file to my server but it keeps saying unexpected EOF... i cannot see the problem with it, and it worked before i edited the script to work on my ipod touch as well. Here is the troublsome code...
if ; then
tar -czf "file(Mac).tar.gz" "/folder" >... (11 Replies)
Discussion started by: DuskFall
11 Replies
7. UNIX for Dummies Questions & Answers
When opening a new window under Terminal, got that message:
Last login: Sun Oct 30 10:35:12 on ttys000
-bash: /Users/MyName/.profile: line 47: syntax error: unexpected end of file
I tried several clues like using BBedit or emacs to get rid of it, nothing does. Maybe shell commands cut or... (1 Reply)
Discussion started by: shub22
1 Replies
8. Shell Programming and Scripting
Hello
I use opensuse build service to build packages (oh surprise !)
I have integrate a command in a spec whose worked and now this exit with:
unexpected EOF while looking for matching `"'
Command:
if \.").mk ]; then
ln -s $(pwd)/mozilla/security/coreconf/Linux2.6.mk \
... (5 Replies)
Discussion started by: posophe
5 Replies
9. Shell Programming and Scripting
I have a piece of Linux script. It tells me some syntax error. I couldn't find it. Please help me to identify them. Thanks. The code looks like this:
export ORACLE_SID=MYDB
export SPW=`cat /opt/oracle/scripts/.sys_pw_$ORACLE_SID`
export check_arch=`sqlplus -s << EOF
/ as sysdba... (7 Replies)
Discussion started by: duke0001
7 Replies
10. Shell Programming and Scripting
Hi everyone, I'm really new in shell scripting and having trouble resolving this error.
Can someone please tell me why I'm getting these errors?
Error Message:
./test.sh: line 50: unexpected EOF while looking for matching `''
./test.sh: line 53: syntax error: unexpected end of file
... (4 Replies)
Discussion started by: simonirang
4 Replies
LEARN ABOUT PHP
mssql_query
MSSQL_QUERY(3) MSSQL_QUERY(3)
mssql_query - Send MS SQL query
SYNOPSIS
mixed mssql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
mssql_query(3) sends a query to the currently active database on the server that's associated with the specified link identifier.
PARAMETERS
o $query
- An SQL query.
o $link_identifier
- A MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3). If the link identifier isn't specified, the last
opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect(3) was called, and use it.
o $batch_size
- The number of records to batch in the buffer.
RETURN VALUES
Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.
EXAMPLES
Example #1
mssql_query(3) example
<?php
// Connect to MSSQL
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
if (!$link || !mssql_select_db('php', $link)) {
die('Unable to connect or select database!');
}
// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);
echo $row[0];
// Clean up
mssql_free_result($version);
?>
NOTES
Note
If the query returns multiple results then it is necessary to fetch all results by mssql_next_result(3) or free the results by
mssql_free_result(3) before executing next query.
SEE ALSO
mssql_select_db(3), mssql_connect(3).
PHP Documentation Group MSSQL_QUERY(3)