|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Update a database table in a for loop
Post 303025584 by gull04 on Tuesday 6th of November 2018 08:39:19 AM
11-06-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. UNIX for Advanced & Expert Users
Hi all,
i am new to the unix enviorment i have got a urgent requirement where we need to migrate the date from the folder heirachy that contains the "IMAGES". These images are to be uploaded on to the database table.
Uploading images from the a single folder (Static) to the... (0 Replies)
Discussion started by: shashisaini24
0 Replies
3. Shell Programming and Scripting
I want to connect to one database and collect data from any table using shell script. (0 Replies)
Discussion started by: rinku
0 Replies
4. UNIX for Advanced & Expert Users
HI All,
Newbie here.
I have a script which generates the tables in teradata database with time stamp like below.I want to add some more code to delete the archive tables which are 2months old.
. $HOME/.profile
t_name=$1
procdate=`date +%y%m%d`
log_dir=$Folder/log
tab=`echo... (0 Replies)
Discussion started by: Maverick79
0 Replies
5. Shell Programming and Scripting
Hello Guys,
I'm new to Shell scripting, and i need someone to help me with this issue:
I'm trying to do a dynamic update query on Sysbase database table using shell script.
Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index.
If the loop is... (10 Replies)
Discussion started by: Alaeddin
10 Replies
6. UNIX for Dummies Questions & Answers
Hi, I want to create a table on our unix box that allows the user to tab through it and select certain option by putting an asterix or similair into it.
e.g.
--------------
|Start App | |
|Stop App |*|
etc...
Can this be done using a script (never seen any graphics options in ksh, but... (2 Replies)
Discussion started by: dlam
2 Replies
7. UNIX for Dummies Questions & Answers
hi
i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database
i have a main database - db1
and i have a table in that database - userips
i wish to create a cron job that truncates or removes all the info... (9 Replies)
Discussion started by: wingchun22
9 Replies
8. Shell Programming and Scripting
Hi ,
I have inserted some records in a table having column "value1 varchar2(4000)" and want to spool in a file.
I have written as below
set echo off
set feed off
set hea off
set wra off
set lin 500
spo temp_table
and fired select query as below
select value1 from temp_table;
spo... (6 Replies)
Discussion started by: CaapAjayShukla
6 Replies
9. UNIX for Advanced & Expert Users
Hello
I have 2 servers that need a database table to be one way synchronized (server A needs to push the table to server B)
I considered using a FEDERATED DB, but decided against it for my particular application (Server B has several apps that would be calling the table repeatedly, and a... (3 Replies)
Discussion started by: kettlewell
3 Replies
10. Shell Programming and Scripting
Hello All Members,
I am new to this forum and to the shell scripting. I want to write a shell script to do the following:
Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies
LEARN ABOUT PHP
ingres_next_error
INGRES_NEXT_ERROR(3) 1 INGRES_NEXT_ERROR(3) ingres_next_error - Get the next Ingres error SYNOPSIS
bool ingres_next_error ([resource $link]) DESCRIPTION
Get the next Ingres error for the last executed query. Each call to ingres_next_error(3) can be followed by a call to ingres_errno(3), ingres_error(3) or ingres_errsqlstate(3) to get the respective error number, error text, or SQL STATE. While ingres_next_error(3) returns TRUE, there are more errors to fetch. PARAMETERS
o $link - The connection link identifier RETURN VALUES
ingres_next_error(3) returns TRUE if there is another error to retrieve or FALSE when there are no more errors SEE ALSO
ingres_errno(3), ingres_error(3), ingres_errsqlstate(3). PHP Documentation Group INGRES_NEXT_ERROR(3)