Hi,
How to format a number in ksh. For example
x=RANDOM $$
I want x to be of 20 digits long, so if x = 12345 I want it to be left paded with 15 zeros.
Thanks. (2 Replies)
hi all,
in ksh, how do i format a decimal number (e.g 3381.19) to integer (e.g 3381). This number is average time response for server in millisec and i wanted to display it in a more readable format i.e in seconds without any decimals.
thanks in advance. (2 Replies)
Hello,
I am attempting to format the output of my unix ksh script. Currently looks like ...
FTP TO HR : Down
FTP FROM HR 4011a : Up
FTP FROM HR 4019a : Down
FTP FROM HR : Down
Would like the status to be aligned as follows:
... (4 Replies)
In Unix/Ksh, when I try to look inside a file it says that the file may be a binary file and if I want to see it anyway. When i say 'yes', it shows me the content filled with unreadable symbols (looks like binary). Is there a command that I can run from the Unix prompt to convert/translate that... (3 Replies)
I am currently returning an sql result with a number value that I want to format as an amount. The sql runs smoothly on its own, but when run inside my ksh script an error is encountered:
ERROR at line 3:
ORA-01481: invalid number format model
My sql is --
select distinct
... (6 Replies)
I have a script that reaches out to several systems and pulls back infomation in serveral files. I would like to take the infomation returned and reformat it so I can export it to excel.
Below is current output:
File1:item1:abc=1
File1:item2:efg
File2:item1:ab=1
File2:item2:efg... (3 Replies)
I have ksh script reading file like
while read -r line
do
echo $line
sleep 1
#process_file $line
done<$file_nm
I want to write this line to another file after some manuplation.Put $line giving me line after changing line format(space removed).Please help me how can i read line by... (3 Replies)
Hi Everyone,
I have a ksh script that queries a database. The query output looks like this:
$queryResult =
echo ${queryResult} = name1
echo ${queryResult} = age1
echo ${queryResult} = name2
echo ${queryResult} = age2
...
I need to insert those values into a new array that would... (2 Replies)
Dear Friends,
Is there anyway we can convert the textfile to pdf file. I have used mv a.txt a.pdf command but dont able open the file in pdf.
Plz advice . (2 Replies)
My argument has data as below.
10.9.9.85
-rwxr-xr-x user1 2019-10-15 17:40 /app/scripts/testingscr5.scr 127869538
-rwxr-xr-x user1 2019-10-15 17:40 /app/scripts/testingscr56scr 127869538
....... (note all these between lines will start with hyphen '-' )
-rwxr-xr-x user1 2019-10-15 17:40... (3 Replies)
Discussion started by: mohtashims
3 Replies
LEARN ABOUT PHP
cubrid_pconnect
CUBRID_PCONNECT(3) 1 CUBRID_PCONNECT(3)cubrid_pconnect - Open a persistent connection to a CUBRID serverSYNOPSIS
resource cubrid_pconnect (string $host, int $port, string $dbname, [string $userid], [string $passwd])
DESCRIPTION
Establishes a persistent connection to a CUBRID server.
cubrid_pconnect(3) acts very much like cubrid_connect(3) with two major differences.
First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, port, dbname and
userid. If one is found, an identifier for it will be returned instead of opening a new connection.
Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for
future use (cubrid_close(3) or cubrid_disconnect(3) will not close links established by cubrid_pconnect(3)).
This type of link is therefore called 'persistent'.
PARAMETERS
o $host
-Host name or IP address of CUBRID CAS server.
o $port
-Port number of CUBRID CAS server (BROKER_PORT configured in $CUBRID/conf/cubrid_broker.conf).
o $dbname
-Name of database.
o $userid
-User name for the database.
o $passwd
-User password.
RETURN VALUES
Connection identifier, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_connect(3) example
<?php
printf("%-30s %s
", "CUBRID PHP Version:", cubrid_version());
printf("
");
$conn = cubrid_pconnect("localhost", 33000, "demodb", "dba");
if (!$conn) {
die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg());
}
$db_params = cubrid_get_db_parameter($conn);
while (list($param_name, $param_value) = each($db_params)) {
printf("%-30s %s
", $param_name, $param_value);
}
printf("
");
$server_info = cubrid_get_server_info($conn);
$client_info = cubrid_get_client_info();
printf("%-30s %s
", "Server Info:", $server_info);
printf("%-30s %s
", "Client Info:", $client_info);
printf("
");
$charset = cubrid_get_charset($conn);
printf("%-30s %s
", "CUBRID Charset:", $charset);
cubrid_disconnect($conn);
?>
The above example will output:
CUBRID PHP Version: 9.1.0.0001
PARAM_ISOLATION_LEVEL 3
LOCK_TIMEOUT -1
MAX_STRING_LENGTH 1073741823
PARAM_AUTO_COMMIT 1
Server Info: 9.1.0.0212
Client Info: 9.1.0
CUBRID Charset: iso8859-1
SEE ALSO cubrid_connect(3), cubrid_connect_with_url(3), cubrid_pconnect_with_url(3), cubrid_disconnect(3), cubrid_close(3).
PHP Documentation Group CUBRID_PCONNECT(3)