I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Hello friends,
Assume that, I am trying to execute a "db2 connect" command from Linux shell prompt via a shell script called "sample"
sample
db2 connect to bas39
$sample
If the database is not present its should display a custom error message by catching the error message given by db2.... (1 Reply)
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Guys,
I am trying to write a shell script that connect to wcsprod database and read the query
#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
databse: wcsprod
user: wcsadm
pwd: pwd
thanks (1 Reply)
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have... (2 Replies)
Hi all,
I have a requirement to connect DB2 database and do some operations and generate a report through shell script.
Can anyone please tell me how can i connect DB2 from unix shell script?
Thanks in ADV. (2 Replies)
I have a shell script main.ksh We are calling dbscript.ksh from main.ksh
I am using select statement in dbscript.ksh but there is a problem with the select statement in dbscript.ksh but still echo $? is showing as zero. I am using DB2 commands in dbscript.ksh
Main.ksh
dbscript.ksh
echo $? ... (13 Replies)
Discussion started by: vamsi.valiveti
13 Replies
LEARN ABOUT PHP
rawurlencode
RAWURLENCODE(3) 1 RAWURLENCODE(3)rawurlencode - URL-encode according to RFC 3986SYNOPSIS
string rawurlencode (string $str)
DESCRIPTION
Encodes the given string according to RFC 3986.
PARAMETERS
o $str
- The URL to be encoded.
RETURN VALUES
Returns a string in which all non-alphanumeric characters except -_.~ have been replaced with a percent ( %) sign followed by two hex dig-
its. This is the encoding described in RFC 3986 for protecting literal characters from being interpreted as special URL delimiters, and for
protecting URLs from being mangled by transmission media with character conversions (like some email systems).
Note
Prior to PHP 5.3.0, rawurlencode encoded tildes ( ~) as per RFC 1738.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.4 | |
| | |
| | Tilde characters are no longer encoded when |
| | rawurlencode(3) is used with EBCDIC strings. |
| | |
| 5.3.0 | |
| | |
| | Now conforms to RFC 3986. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
including a password in an FTP URL
<?php
echo '<a href="ftp://user:', rawurlencode('foo @+%/'),
'@ftp.example.com/x.txt">';
?>
The above example will output:
<a href="ftp://user:foo%20%40%2B%25%2F@ftp.example.com/x.txt">
Or, if you pass information in a PATH_INFO component of the URL:
Example #2
rawurlencode(3) example 2
<?php
echo '<a href="http://example.com/department_list_script/',
rawurlencode('sales and marketing/Miami'), '">';
?>
The above example will output:
<a href="http://example.com/department_list_script/sales%20and%20marketing%2FMiami">
SEE ALSO rawurldecode(3), urldecode(3), urlencode(3), RFC 3986.
PHP Documentation Group RAWURLENCODE(3)