Hi all,
I have a doubt in SQL Loader.
We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for
a column while loading data using SQL Loader into table or multiple tables.
My requirment is this.
For the first run in SQL... (2 Replies)
Trying to compile all SQL files using a shell script. But the below code is not working. Below Code works fine when for loop is not there(commenting line no: 1,2 and 9).
1. sq_lfile=`ls *.sql`
2. for current_sql_file in $sql_file
3. do
4. sqlplus uname/pass@Service>>SQLLOG << -ENDOFSQL... (3 Replies)
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this.
#!/bin/sh
minlimit=0
maxlimit=10
size=100
while... (0 Replies)
Hi,
Am using a if condition to match a pattern but I get the following error..
if
then
echo "The value is $hidType"
return 0
elseif -a ]
echo "The value is $hidType"
return 0
fi
I get the following error
+ echo The value is mode
The value is mode
+
./a2: mode:... (2 Replies)
Error Message: dm2_oraver: 9xdm2_oraver2: LT11/w_standard/gold_wh/install/dm2_updatetns.ksh: 11MAR13: 0403-009 The spe
cified number is not valid for this command.
if means the line number in the ksh, it is ((CntNew=Cnt+1)).
Please let me know the best way to debug and find it out. I am... (4 Replies)
Hi, This is my first post.
I have a korn shell script which outputs a select statment to a file. There is only one column and one row which contains a record count of the select statement.
The select statement looks something like this:
SELECT COUNT(some_field) AS "count_value"
... (2 Replies)
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Hi Experts
I would like to ask if there is a way to validate if the variable passed is in this kind of sample format "06-10" or "10-01". It was really a challenge to me on how to start and echnically the "6-10" stands for "June 10" and "10-01" stands as "October 1", overall it needs to have ... (3 Replies)
Discussion started by: ersan-poguita
3 Replies
LEARN ABOUT DEBIAN
qmsg
qmsg(1B) PBS qmsg(1B)NAME
qmsg - send message to pbs batch jobs
SYNOPSIS
qmsg [-E] [-O] message_string job_identifier ...
DESCRIPTION
To send a message to a job is to write a message string into one or more output files of the job. Typically this is done to leave an
informative message in the output of the job.
The qmsg command writes messages into the files of jobs by sending a Message Job batch request to the batch server that owns the job. The
qmsg command does not directly write the message into the files of the job.
OPTIONS -E Specifies that the message is written to the standard error of each job.
-O Specifies that the message is written to the standard output of each job.
If neither the -E nor the -O option is specified, the message will be written to the standard error of the job.
OPERANDS
The first operand, message_string, is the message to be written. If the string contains blanks, the string must be quoted. If the final
character of the string is not a newline, a newline character will be added when written to the job's file.
All following operands are job_identifiers which specify the jobs to receive the message string. The qmsg command accepts one or more
job_identifier operands of the form:
sequence_number[.server_name][@server]
STANDARD ERROR
The qmsg command will write a diagnostic message to standard error for each error occurrence.
EXIT STATUS
Upon successful processing of all the operands presented to the qmsg command, the exit status will be a value of zero.
If the qmsg command fails to process any operand, the command exits with a value greater than zero.
SEE ALSO qsub(1B), pbs_msgjob(3B)Localqmsg(1B)