Hi All,
I am having a issue in a script. I am trying to execute a select * from a scirpt to a database and printing the the sql string. The * in the sqltring is printing all the files in the directory. How to handle it ?
Code:
..
..
sql="select * from emp"
execute ($sql)
echo $sql
Here my echo is not giving the sql command it is showing all the files in the directory.
Hi,
I want to just expand the macros in a set of c files from a filelist which are in different directories. I don't want the header files included in the c file to be expanded. I have a perl script which does
gcc -E <infile> -I <path to search for header files> -imacros <infile>
But in... (1 Reply)
Hello,
I'm trying to write a method which will return the extension of a file given the file's name, e.g. test.txt should return txt. I'm using C so am limited to char pointers and arrays. Here is the code as I have it:
char* getext(char *file)
{
char *extension;
int i, j;... (5 Replies)
if ; then => is it correct?
i need to check 10 files size and do the same action. The file name is same but extension of the files are different. how do i deal with it? Please help (1 Reply)
Hi all,
I have a selection of files that contain several commands that write to a file and are started as background processes similar to below.
command_to_run_simulator -simulator_arguments > log_file 2>&1 &
command_to_run_simulator -simulator_arguments > log_file 2>&1 &... (2 Replies)
Hello,
I have this problem.
I have script file, e.g.
#!/usr/bin/ksh
echo $MY_DIR
ls -lt $MY_DIR
I want to list the script but with MY_DIR variable expanded. E.g.
MY_DIR=/abc/xyz (in shell MY_DIR is set)
So I want to list the script and see:
#!/usr/bin/ksh
echo /abc/xyz
ls... (6 Replies)
Compiling xpp (The X Printing Panel) on SL6 (RHEL6 essentially):
xpp.cxx: In constructor ‘printFiles::printFiles(int, char**, int&)’:
xpp.cxx:200: error: invalid conversion from ‘const char*’ to ‘char*’
The same error with all c++ constructors - gcc 4.4.4.
If anyone can throw any light on... (8 Replies)
Hi Guys,
I have a raidz zpool that consists of four disks. 2x2TB, 1x1TB and 1x0.75TB.
Originally it was only 1x1TB, 3x0.75TB, and I had around 1.7TB of storage capacity. I've just switched out two of the 0.75TB disks for the 2x2TB ones. I did this one at a time and now the resilvering is... (2 Replies)
echo $HOME return : /home/user1echo ~ return : /home/user1My_path=~/bin/"some dir1/some dir2"
kate "$My_path/some_file"Kate open a file "~/~/bin/some dir1/some dir2/some_file" which does not exists.
I was expecting kate to open : "~/bin/some dir1/some dir2/some_file"
Any help is welcome.
... (8 Replies)
Discussion started by: jcdole
8 Replies
LEARN ABOUT CENTOS
dblink_open
DBLINK_OPEN(3) PostgreSQL 9.2.7 Documentation DBLINK_OPEN(3)NAME
dblink_open - opens a cursor in a remote database
SYNOPSIS
dblink_open(text cursorname, text sql [, bool fail_on_error]) returns text
dblink_open(text connname, text cursorname, text sql [, bool fail_on_error]) returns text
DESCRIPTION
dblink_open() opens a cursor in a remote database. The cursor can subsequently be manipulated with dblink_fetch() and dblink_close().
ARGUMENTS
conname
Name of the connection to use; omit this parameter to use the unnamed connection.
cursorname
The name to assign to this cursor.
sql
The SELECT statement that you wish to execute in the remote database, for example select * from pg_class.
fail_on_error
If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally.
If false, the remote error is locally reported as a NOTICE, and the function's return value is set to ERROR.
RETURN VALUE
Returns status, either OK or ERROR.
NOTES
Since a cursor can only persist within a transaction, dblink_open starts an explicit transaction block (BEGIN) on the remote side, if the
remote side was not already within a transaction. This transaction will be closed again when the matching dblink_close is executed. Note
that if you use dblink_exec to change data between dblink_open and dblink_close, and then an error occurs or you use dblink_disconnect
before dblink_close, your change will be lost because the transaction will be aborted.
EXAMPLES
SELECT dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
(1 row)
SELECT dblink_open('foo', 'select proname, prosrc from pg_proc');
dblink_open
-------------
OK
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_OPEN(3)