Sponsored Content
Full Discussion: Urgent help needed
Top Forums UNIX for Dummies Questions & Answers Urgent help needed Post 302122042 by skyineyes on Tuesday 19th of June 2007 03:03:09 AM
Old 06-19-2007
Urgent help needed

Hi

I am using DB2 as the database and i am reading syscat.columns from the database.

I want to manipulate the rows returned by running SQL query from the shell script. The manipulation involves addition and deletion of the rows from the resultset.

All the above i want to do using SQL cursors.

Please provide me a code example for the same.

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

urgent help needed !!

i have a script, which is continuously looping. i want to view the script name when i use ps command... it is only showing -sh ... UID PID PPID C STIME TTY TIME COMMAND informix 8533 20923 0 18:19:28 pts/ta 0:00 -sh but i dont have my scriptname displayed .... how can i do that my script is... (0 Replies)
Discussion started by: guhas
0 Replies

2. Shell Programming and Scripting

urgent help needed.

Ok I admit it I am stumped and I would appreciate any and all help Here is what I am trying to do. Korn Shell script I am setting a variable to another shell script that I want to invoke in my main script like so: GETDIR=/vol100/cfg/.getdir The .getdir shell script take a parameter,... (4 Replies)
Discussion started by: Batch
4 Replies

3. Shell Programming and Scripting

urgent needed

hi i want solution regarding usage of array. i m having code which is written using if- elif and can i use or access using arrays. here i wana use array values along with if -elif condition. i dnt wana use command line argument parameter1=(scram no_scram) if ; then ... (0 Replies)
Discussion started by: manish1
0 Replies

4. Windows & DOS: Issues & Discussions

Urgent XP help needed Please

Hi, Please accept my apologies if I have not explained anything clearly enough but i am a little old on new lingo!!! I am running XP from home and last night the following happened. After being logged on for pretty much the full day, I had what seemed like a pop up come up. Although most pop... (3 Replies)
Discussion started by: nike1601
3 Replies

5. UNIX for Advanced & Expert Users

Urgent help needed!!!

-------------------------------------------------------------------------------- hy guys, i got few interview questions i need someone to answer urgently: 1)If you cant get to the root, you try to fsck it, but gets errors to read file systems. What steps do you take to recover the host... (1 Reply)
Discussion started by: charneet
1 Replies

6. Shell Programming and Scripting

Urgent Help Needed.

Hi, Below is my issue which I desperately need and I want a shell script which can do this job. I need this script as I m planning to put this for a system health check. Please assist me. 1. There are 10 log files in a particular location. 2. open each log file. Goto to the end of the... (1 Reply)
Discussion started by: kashriram
1 Replies

7. UNIX for Dummies Questions & Answers

Urgent Help Needed

Hello Friends, I am a Graduate in Computers. I completed BCA degree this year. I want to make my career in UNIX. But, unfortunately I don't know anybody who can guide me. I am totally confuse because I don't know where to start and what are the future prospect in UNIX. Please give your... (4 Replies)
Discussion started by: Luckyless
4 Replies

8. Shell Programming and Scripting

Urgent Help needed !!!

Hi, I have a directory, where i get 4 files for each day... The files will be generated at any time. I am trying for a shell script for copying the file from this directory whenever new file is generated. Say for example : If the directory X has following files A1,A2,A3,A4,B1,B2,B3,B4...... (2 Replies)
Discussion started by: krishh.kk
2 Replies

9. Programming

URGENT HELP NEEDED

KING KONG ELECTRICITY AUTHORITY BILL CALCULATOR You are required to develop a script that will enable KING KONG ELECTRICITY AUTHORITY to calculate customer bills based on their meter readings. The customers are categorized into the following categories:  Residential customers  Commercial... (1 Reply)
Discussion started by: watisevil
1 Replies

10. Shell Programming and Scripting

Urgent Help needed...

Hi I want to create a script which deleted files in the following folders older than 30 days. There are a particular version of files inside it to be deleted Folders : /files0/interfaces/ResponsysSavedList/BackInStock/EmailContent/backup... (3 Replies)
Discussion started by: Scudza
3 Replies
INGRES_NUM_ROWS(3)							 1							INGRES_NUM_ROWS(3)

ingres_num_rows - Get the number of rows affected or returned by a query

SYNOPSIS
int ingres_num_rows (resource $result) DESCRIPTION
This function primarily is meant to get the number of rows modified in the database. However, it can be used to retrieve the number of rows to fetch for a SELECT statement. Note If scrollable cursors are disabled and this function is called before using ingres_fetch_array(3), ingres_fetch_object(3), or ingres_fetch_row(3), the server will delete the result's data and the script will be unable to get them. Instead, you should retrieve the result's data using one of these fetch functions in a loop until it returns FALSE, indicating that no more results are available. PARAMETERS
o $result - The result identifier for a query RETURN VALUES
For delete, insert, or update queries, ingres_num_rows(3) returns the number of rows affected by the query. For other queries, ingres_num_rows(3) returns the number of rows in the query's result. SEE ALSO
ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3). PHP Documentation Group INGRES_NUM_ROWS(3)
All times are GMT -4. The time now is 12:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy