05-18-2009
scripting issue
Hello,
Guys I am having a sql script file which contains some sql statements including inserting values, One column is of the data type date.
Now i am having a KSH script for inserting values via this script into the database.
The problem I am facing that when I am inserting value in the column with 'date' data type as sysdate through KornShell, the entry is getting updated in the table in the database. But suppose I am giving like 18-May-2009, it is not getting updated through KornShell script into the database instead of which it is giving me the error like MAY-identifier to be declared???
Please help me for this...
And one more thing how to declare an alphanumeric variable like '18-MAY-2009' in KornShell..
Plz let me know... Its very urgent..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
folks;
i'm trying to write a shell script to do the following:
1. i have a file with 39 fields, i'm trying to add 10 more fields with (!) as a field separator. with the following requirement:
if field number 20 has a value, then field number 40 will show as (!M!), and if the field number 20 does... (2 Replies)
Discussion started by: moe2266
2 Replies
2. Shell Programming and Scripting
Hi guys...
I am a newbie to scripting... I have a small requirement... I dont whether u r clear with my requirement... But plz try to help me...
Like,
tell me some kind of scripts that can help me in retreiving the data from the datasets.
Regards,
Mahesh... (1 Reply)
Discussion started by: mraghunandanan
1 Replies
3. Shell Programming and Scripting
Hi guys...
I am newbie to Shell Scripting...
I am querying the Oracle database.I want a Shell script for fetching some data from datasets in Oracle database and displaying in an excel sheet.This is my requirement..
Can u plz help me guys..
Regards,
Mahesh... (4 Replies)
Discussion started by: mraghunandanan
4 Replies
4. Shell Programming and Scripting
Hi Guys,
I am quite new to Shell Scripting... I need ur help.. This is very urgent.
The thing is like,
I need to match a IP address (ex 192.168.200.56) i.e, xxx.xxx.xxx.xx inside a KSH script,but if we enter in different format other than the specified format (ex jjj.ksj., 1.0...), it should... (3 Replies)
Discussion started by: mraghunandanan
3 Replies
5. Shell Programming and Scripting
Hello,
I have an ASCII file (many files of the same format, but different dates and numbers) in the format like below:
2008.01.02,08:00,1.46520,1.46520,1.46410,1.46440,70
2008.01.02,08:05,1.46450,1.46560,1.46440,1.46540,79
2008.01.02,08:10,1.46530,1.46540,1.46490,1.46500,46... (8 Replies)
Discussion started by: chief2000
8 Replies
6. Shell Programming and Scripting
I am having an issue with a script that I created today, my first attempt at this, and was wondering if anyone can give me insight to what changes need to be made. Below is a copy of the script that I have written. WEe are trying to monitor whether or not a services is running. I do have a cron... (1 Reply)
Discussion started by: lsudubee
1 Replies
7. Shell Programming and Scripting
needing this script to shut down 1 IceS and start up another, close the 2nd one after 12 seconds and then reboot. here is what i have so far
#!/bin/bash
ShutDown() {
echo "Shutdown in progress."
wall <<ENDOFWALL
CI Shutdown has been intiated!!!!
Shutdown will occur in 30 seconds...... (1 Reply)
Discussion started by: Zaine
1 Replies
8. Shell Programming and Scripting
I am having a problem. which I have described below>>
I have to run a script with the format : <File_name><Start_date><End_date>
abcd.sh 19-JAN-2015 01-May-2014
problem is I need to compare these two dates and throw an error as start date must be less than or equal to end date.
But... (13 Replies)
Discussion started by: Chandan_Bose
13 Replies
9. Shell Programming and Scripting
Hi All,
I am facing a problem when i am trying to run shell script more than 5 times.
I have shell script(.sh file) which ran perfectly fine in the early attempts(1,2,3,4 runs). But if i try to run the script more number of times, i am facing the below error message.
Too many ('s
I do... (3 Replies)
Discussion started by: am24
3 Replies
10. Shell Programming and Scripting
Hi Experts,
I'm stuck with a single liner bash script. Need your help to fix it.
Let me brief you that what is my expectations from this script.
I need the interfaces configured for a list of servers, their respective IP address and FQDN in a output file. The output should be in the same... (3 Replies)
Discussion started by: arun_adm
3 Replies
LEARN ABOUT PHP
db2_fetch_array
DB2_FETCH_ARRAY(3) 1 DB2_FETCH_ARRAY(3)
db2_fetch_array - Returns an array, indexed by column position, representing a row in a result set
SYNOPSIS
array db2_fetch_array (resource $stmt, [int $row_number = -1])
DESCRIPTION
Returns an array, indexed by column position, representing a row in a result set. The columns are 0-indexed.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
o $row_number
- Requests a specific 1-indexed row from the result set. Passing this parameter results in a PHP warning if the result set uses a
forward-only cursor.
RETURN VALUES
Returns a 0-indexed array with column values indexed by the column position representing the next or requested row in the result set.
Returns FALSE if there are no rows left in the result set, or if the row requested by $row_number does not exist in the result set.
EXAMPLES
Example #1
Iterating through a forward-only cursor
If you call db2_fetch_array(3) without a specific row number, it automatically retrieves the next row in the result set.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
$result = db2_execute($stmt);
while ($row = db2_fetch_array($stmt)) {
printf ("%-5d %-16s %-32s %10s
",
$row[0], $row[1], $row[2], $row[3]);
}
?>
The above example will output:
0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00
Example #2
Retrieving specific rows with db2_fetch_array(3) from a scrollable cursor
If your result set uses a scrollable cursor, you can call db2_fetch_array(3) with a specific row number. The following example
retrieves every other row in the result set, starting with the second row.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$result = db2_exec($stmt, $sql, array('cursor' => DB2_SCROLLABLE));
$i=2;
while ($row = db2_fetch_array($result, $i)) {
printf ("%-5d %-16s %-32s %10s
",
$row[0], $row[1], $row[2], $row[3]);
$i = $i + 2;
}
?>
The above example will output:
0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00
SEE ALSO
db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_fetch_row(3), db2_result(3).
PHP Documentation Group DB2_FETCH_ARRAY(3)