11-29-2015
Do you really (need to) supply the IDs on the command line? How do you construct the line? How about creating an sql- file with several update lines for a max number of IDs? And then executing that?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here's the problem...
I have a mysqldump file and I need to put single quotes around the date/time timestamp. So for example I have a line like:
INSERT INTO attachments VALUES (1,182,2004-08-06 09:24:04,'description'...
and I need it to become
INSERT INTO attachments VALUES... (10 Replies)
Discussion started by: primal
10 Replies
2. Shell Programming and Scripting
I've got:
isql -U $USERID -S $SERVER -D $DATABASE -i inputfile.sql -o outputfile.txt
in inputfile I have:
go
sql#1
go
sql#2
go
sql#3
go
I also tried without "go" and with";" instead which did not work
SQL statements will work if I paste them directly into the script and use EOF
... (0 Replies)
Discussion started by: Cailet
0 Replies
3. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. Shell Programming and Scripting
Dear All,
The sqlplus 'Accept' command is not waiting for user input when I include the command within a shell script.
Note: The 'Accept' command is working fine if I execute it in a SQLPLUS Prompt.
Please fins the below sample script which i tried.
SCRIPT:
--------
#!... (4 Replies)
Discussion started by: little_wonder
4 Replies
5. UNIX for Dummies Questions & Answers
1) I wrote a script and gave the desired permissions using "chmod 755 scriptname". Now if i edit the script file, why do i need to set the permission again? Didn't i set the permission attribute.. or if i edit the file, does the inode number of file changes?
2) I am running my unix on a server... (1 Reply)
Discussion started by: animesharma
1 Replies
6. UNIX for Dummies Questions & Answers
Here is the requirement, When I run the "run file KSH (sql)", it should substitute
'${pCW_Bgn_DT}' with 201120
and
'${pCW_End_DT}' with 201124
Input File
----------
$ cat prevwk.dat
201124 20110711
run file KSH (sql)
------------------
In this file, I want to use the variables... (1 Reply)
Discussion started by: shanrice
1 Replies
7. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
8. Shell Programming and Scripting
Hi All,
Do we know how to read input file within awk script and send output toanother log file. All this needs to be in awk script, not in command line. I am running this awk through crontab.
Cat my.awk
#!/bin/awk -f
function test(var){
some code}
{
}
END
{
print"test code"
} (5 Replies)
Discussion started by: random_thoughts
5 Replies
9. Shell Programming and Scripting
Hi all,
How to pass the command line argument to a sql file
Script:
#!/bin/ksh
if ] ; then
test.sql
fi
My Sql Informix DB:
echo "select * from table where col1 = 2234
and col2 = '$3'"|dbaccess ddname
But im getting `:' unexpected error (5 Replies)
Discussion started by: Roozo
5 Replies
10. Shell Programming and Scripting
Hi All,
Seeking for your assistance to read each line $1 and $2 of input file and used it to query.
Ex. file1.txt(number range)
9064500000 9064599999
9064600000 9064699999
9064700000 9064799999
Database name: ranges_log
a_no message
9064500001 test
9064700000 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies
LEARN ABOUT POSIX
pts_setmax
PTS_SETMAX(1) AFS Command Reference PTS_SETMAX(1)
NAME
pts_setmax - Sets the value of the max group id or max user id counter
SYNOPSIS
pts setmax [-group <group max>] [-user <user max>]
[-cell <cell name>] [-noauth] [-localauth] [-force] [-help]
pts setm [-g group max>] [-u <user max>]
[-c <cell name>] [-n] [-l] [-f] [-h]
DESCRIPTION
The pts setmax command sets the value of one or both counters that track the IDs the Protection Server allocates to new users, machines, or
groups: the "max user id" counter for the AFS user IDs (AFS UIDs) assigned to users and machines, and the "max group id" counter for the
AFS group IDs (AFS GIDs) assigned to groups.
Use the pts listmax command to display the current value of both counters.
OPTIONS
-group <group max>
Sets the "max group id" counter. Precede the value with a hyphen to indicate that it is negative. When an administrator next uses the
pts creategroup command to create a group entry and does not include that command's -id argument, the Protection Server assigns the
group an AFS GID one less (more negative) than this value.
-user <user max>
Sets the "max user id" counter. When an administrator next uses the pts createuser command to create a user or machine entry and does
not include that command's -id argument, the Protection Server assigns the group an AFS UID one greater than this value.
-cell <cell name>
Names the cell in which to run the command. For more details, see pts(1).
-force
Enables the command to continue executing as far as possible when errors or other problems occur, rather than halting execution at the
first error.
-help
Prints the online help for this command. All other valid options are ignored.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. Do not combine this flag with the -cell or
-noauth options. For more details, see pts(1).
-noauth
Assigns the unprivileged identity anonymous to the issuer. For more details, see pts(1).
EXAMPLES
The following command sets the "max group id" counter to -500 and the "max user id" counter to 1000.
% pts setmax -group -500 -user 1000
PRIVILEGE REQUIRED
The issuer must belong to the system:administrators group.
SEE ALSO
pts(1), pts_creategroup(1), pts_createuser(1), pts_listmax(1)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2014-04-08 PTS_SETMAX(1)