I am new on this forum . I have to face a particoular implementation issue and I need some help .
Requirement :
I need to read a particoular file (an xml file) and after reading it I need to call an Oracle Stored Procedure passing the content of the file as paramenter , in order to update a particoular CLOB column on a table .
This the code I used (I'm using ksh on AIX 5.3 o.s.) .
Code:
#!/bin/ksh
# Shell Type : Korn Shell
SetXMLClob()
{
echo "Starting SetXMLClob function....."
LOGID=$2
FILENAME=$3
PROCEDURE_NAME=$4
LOGFILE=$1/Log/$PROCEDURE_NAME"_"$LOGID.log
export LOGFILE
VALUE=$(cat $FILENAME | sed -e ':a' -e 'N' -e '$!ba' -e 's/\n//g')
LENGTH=`expr length "$VALUE"`
VALUE=`expr substr "$VALUE" 3 "$LENGTH"`
echo $VALUE
CHAR="'"
while [ $LENGTH -gt 1 ];
do
SUBVALUE=`expr substr "$VALUE" 1 999`
SUBLENGTH=`expr length "$SUBVALUE"`
SUBVALUE=$CHAR$SUBVALUE$CHAR
echo $SUBVALUE
echo $LENGTH
export SUBVALUE
$1/spool_procedure.sh "$PROCEDURE_NAME" "'"$LOGID"'"
if [ $SUBLENGTH -ge $LENGTH ]; then
LENGTH=0
else
INDEX=`expr $SUBLENGTH + 1`
VALUE=`expr substr "$VALUE" "$INDEX" "$LENGTH"`
LENGTH=`expr length "$VALUE"`
fi
done
}
################################################### MAIN BODY
case $1"" in
"/SET")
echo "----------------------" >> $LOGFILE
SetXMLClob $2 $3 $4 $5;;
esac
I think the best solution is to loop through the file and extract at each interaction the first 1000 bytes of the file but I don't know how to do this in ksh .
Hi,
I have a file a.lst which lists all files.
as
a.dat
b.dat
c.dat
I want to process these files mentioned in the list file in a loop.
Say I want to display only the first line of all the files a.dat , b.dat, c.dat.
How can I go about it?
Please help. (5 Replies)
Okay...
I've solved one problem.
Here's the next.
I'm writing a script file that needs to go through a directory and list all files in that directory.
I'm using TCL/TK.
I figured out how to go through the directory and how to loop through it, but I ran into a little problem.
... (2 Replies)
This isn't working for multiple files. It works for one file though.
exists1=$(ls | grep gspp*)
for FILES in $exists1
do
echo "Loading $exists1"
... (23 Replies)
I posted this in the Solaris forum, but I don't think it's platform specific, so I'm posting it here.
Here is the situation. We are a company that has been using a professional publishing system, the software is called "ProType". It runs on Solaris 2.4, however it is no longer supported and we... (6 Replies)
Hi all,
I'm having a problem with a script which should ultimately provide a filename by reading a value from file1 and file2 then join together.
I'm planning to use a loop/ loops to get the values out of both files and create a single string unfortunately the code currently treats the second... (7 Replies)
I am writing a ksh which has to load 7 files(.dat files) from input directory into oracle tables using sql loader. The process has to take each file at a time and once if it is loaded succesfully using sql loader into oracle tables then the process has to pick next file and load it into oracle... (2 Replies)
Hi all, I am trying to make a for loop invoking files with different extensions (*.ugrd and *.vgrd) and I cant just make it work. Cant figure out how to load the files so as to use them in subsequent commands like the ones in this pseudo code. the files are arranged such that in one date for... (8 Replies)
I have a req. where i need to read data from multiple files and take counts of row which satisfy the condition. e.g.:
FILE1:
Col1 Col2 Col3
12 ab cd
15 de fg
25 gh tm
FILE2:
Col1 Col2 Col3
21 ab1 cd1
13 de1 fg1
25 gh1 tm1
---
---
FILE-N...
i need to find the count of rows... (6 Replies)
So my script is supposed to repeat for every server in my file, but as of now it is getting stuck on my awk commands
# Read file cred.txt (with one IP per line), connect to servers (one at a time), and download directory listing
i=1
param=$(sed -n "{$1}p" $parm_dir/cdm_param.txt) #Get the last... (6 Replies)
Hi all,
Please guide. It has to do with parsing the input file names.
I have a fairly large number of files, I want to do some operations on them in a pairwise fashion (every file has a pair).
The names are in the following pattern, with the pairs of files named with _1 and _2 , the... (4 Replies)
Discussion started by: newbie83
4 Replies
LEARN ABOUT PHP
mssql_num_fields
MSSQL_NUM_FIELDS(3)MSSQL_NUM_FIELDS(3)mssql_num_fields - Gets the number of fields in resultSYNOPSIS
int mssql_num_fields (resource $result)
DESCRIPTION mssql_num_fields(3) returns the number of fields in a result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns the number of fields, as an integer.
EXAMPLES
Example #1
mssql_num_fields(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Select some data from our database
$data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Construct a table
echo '<table border="1">';
$header = false;
// Iterate through returned results
while ($row = mssql_fetch_array($data)) {
// Build the table header
if (!$header) {
echo '<thead>';
echo '<tr>';
for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
echo '<td>' . ucfirst($row[$i]) . '</td>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$header = true;
}
// Build the row
echo '<tr>';
foreach($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '</tr>';
}
// Close table
echo '</tbody>';
echo '</table>';
// Clean up
mssql_free_result($data);
mssql_close($link);
?>
SEE ALSO mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).
PHP Documentation Group MSSQL_NUM_FIELDS(3)