Remove this line and see... echo off? what does that do?... Like I said I am not an expert in sqlplus!
--ahamed
The problem here is the output.txt file is not getting created in time.This file contains the output of sql query.
so as it is not finding the file in time it is throwing error. what have to be done here is to wait until the execution of query is completed and file is created.
I manually created output.txt file in the directory and tested it.It is working fine.
All the other part is working fine.
Echo off,heading off commands etc are used to filter the output so that it does not contain column names etc of the table.
---------- Post updated at 08:03 AM ---------- Previous update was at 07:18 AM ----------
Quote:
Originally Posted by ahamed101
Remove this line and see... echo off? what does that do?... Like I said I am not an expert in sqlplus!
--ahamed
I have removed echo off and executed,it also didnt result success
I am getting a variable as x=2006/01/18
now I have to extract each field from it.
Like x1=2006, x2=01 and x3=18.
Any idea how?
Thanks a lot for help.
Thanks
CSaha (6 Replies)
Dear friends,
I'm a novice Unix user and I'm trying to learn the ropes. I have a big task I have to accomplish and I'm convinced Unix can get the job done, I just haven't figured out how. I recently posted on the topic of cutting text between unique text patterns and somebody helped me a great... (24 Replies)
Hi,
i have a line with several fields (indefinite number of - count varies) separated by colon.
Now, i need to pick each field (except the first one) and have it assigned to variable within a loop. In other words, in the first iteration of the loop, the variable must be assigned with 2nd... (2 Replies)
Greetings,
I would like to extract records from a fixed width text file that have unique field elements.
Data is structured like this:
John A Smith NY
Mary C Jones WA
Adam J Clark PA
Mary Jones WA
Fieldname / start-end position
Firstname 1-10... (8 Replies)
I need some assistance, I am writing a script in bash.
I want to do two things:
1/. I want to replace the LF at the end of the RFH Ø ¸MQSTR ¸ so I can process the file record by record using a while loop.
2/. I want to extract two fields from each record, they are identified with... (1 Reply)
I am need to extract a number of values from a file, put have now clue how to do this.
The file looks like this:
# My file
Dest=87;CompatibleSystemSoftwareVersion=2.5300-;
Dest=87;ImageVersion=000061f3;SystemSoftwareVersion=2.5300;CDN=http://my.backup.com/download.txt;CDN_Timeout=30;
I... (3 Replies)
Hi,
I have multiple files in a directory all I am trying to do is to read the files in the directory and extract data from 2nd field till 10th field and put it in a new files. The files are pipe delimited. The new file will have the same name as the old file but the prefix of PRE_oldfilename.
... (1 Reply)
Hi,
I need to extract last character of the field retrieved from the database using select command.
eg:
select event,text from event_data;
o/p: Event1,text1
But I need to extract only '1' from the fields...similarly '2' from Event2,text2 and '3' from Event3,text3 etc., and need to pass... (6 Replies)
I have one file A.txt which is comma separated and I want to extract first 4 field's in a file and also I want to add one more column in output
A.txt in output for all records. A.txt should not be hard coded since I do not filename it may be any file. (1 Reply)
Hello All,
I have a requirement to split the input.xml file different files and i have tried using earlier examples(where i have posted in the forum), but still no luck
Here is my input.xml
<jms-system-resource>
<name>UMSJMSSystemResource</name>
... (4 Replies)
Discussion started by: Siv51427882
4 Replies
LEARN ABOUT CENTOS
papi_get_multiplex
PAPI_get_multiplex(3) PAPI PAPI_get_multiplex(3)NAME
PAPI_get_multiplex -
Get the multiplexing status of specified event set.
SYNOPSIS Detailed Description
C Interface:
#include <papi.h>
int PAPI_get_multiplex( int EventSet );
Fortran Interface:
#include fpapi.h
PAPIF_get_multiplex( C_INT EventSet, C_INT check )
Parameters:
EventSet an integer handle for a PAPI event set as created by PAPI_create_eventset
Return values:
PAPI_OK
PAPI_EINVAL One or more of the arguments is invalid, or the EventSet is already multiplexed.
PAPI_ENOEVST The EventSet specified does not exist.
PAPI_EISRUN The EventSet is currently counting events.
PAPI_ENOMEM Insufficient memory to complete the operation.
PAPI_get_multiplex tests the state of the PAPI_MULTIPLEXING flag in the specified event set, returning TRUE if a PAPI event set is
multiplexed, or FALSE if not.
Example:
* int EventSet = PAPI_NULL;
* int ret;
*
* // Create an empty EventSet
* ret = PAPI_create_eventset(&EventSet);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Bind it to the CPU component
* ret = PAPI_assign_eventset_component(EventSet, 0);
* if (ret != PAPI_OK) handle_error(ret);
*
* // Check current multiplex status
* ret = PAPI_get_multiplex(EventSet);
* if (ret == TRUE) printf("This event set is ready for multiplexing.")
* if (ret == FALSE) printf("This event set is not enabled for multiplexing.")
* if (ret < 0) handle_error(ret);
*
* // Turn on multiplexing
* ret = PAPI_set_multiplex(EventSet);
* if ((ret == PAPI_EINVAL) && (PAPI_get_multiplex(EventSet) == TRUE))
* printf("This event set already has multiplexing enabled0);
* else if (ret != PAPI_OK) handle_error(ret);
*
See Also:
PAPI_multiplex_init
PAPI_set_opt
PAPI_create_eventset
Author
Generated automatically by Doxygen for PAPI from the source code.
Version 5.2.0.0 Tue Jun 17 2014 PAPI_get_multiplex(3)