Thank you everyone for the advice and guidance you shared to me. it gives a lot of ideas to me on how build my script.
Actually, the script ran too long maybe because I didn't command commit after I delete data in table before I run the import script. After I command commit then I run the script and it very fast to complete. Linux
But I cannot confirm also if that was the caused that the script ran too long.
---------- Post updated at 06:01 PM ---------- Previous update was at 05:40 PM ----------
I have encounter another problem hopefully can advice me on the issue.
I successful export data from oracle but I put into TABLE.DEL file.
then I used TABLE.DEL to import into db2.
Not all data was successful import into db2, the other data was rejected.
results below:
Is the issue was during the export? Because supposedly during export should be the file .dmp and I change into .DEL?
Please advice me..
Thanks
Last edited by rbatte1; 01-25-2017 at 06:45 AM..
Reason: Added CODE tags for output and corrected spellings/case/etc.
Hi,
Can I do the following:
On SunOS 5.8
/etc/vfstab:
remote-host:/Volumes/webdata - /export/home/webdata nfs - yes rw,vers=3,soft,intr,bg,timeo=600
In /etc/auto_direct:
/home/science $HOST:/export/home/webdata/science
/home/science-edu ... (2 Replies)
I've been wondering about this one, is there any way to do the following with ZFS ACL's (i.e. "copy" the ACL over to another file)?
getfacl /bla/dir1 | setfacl -f - /bla/dir2
I know about inheritence on dirs, it doesn't work in this scenario I'm working on. Just looking to copy the ACL's.
... (3 Replies)
Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
I have a calling script which consists of calls to other scripts via the sh command.
ie vi callscript.sh
sh smallscript1.sh
extra unix commands
sh smallscript2.sh
exit
In smallscript1, I prompt for a filename, which I handle via :-
read f1
export f1
I then need... (5 Replies)
Hi,
I need to export an existing PGP key and import it into GnuPG on a different machine.
This is how I did the export:
pgp -kx myuser _myuser_public
pgp -kx myuser _myuser_private secring.skr
(this is from the pgp installation directory that contains secring.skr).
This produced two... (0 Replies)
A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Hi Guys,
I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle.
db2 connect to Tablename user id using psswrd
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA"
db2 "EXPORT TO... (3 Replies)
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
Hello.
During startup /etc/bash.bashrc.local generates some array
.....
source /.../.../system_common_general_array_env_var
.....
The file system_common_general_array_env_var contains :
LEAP_VERSION='42.3'
ARRAY_MAIN_REPO_LEAP=('zypper_local' 'openSUSE-Leap-'"$LEAP_VERSION"'-Non-Oss' ... (2 Replies)
Discussion started by: jcdole
2 Replies
LEARN ABOUT PHP
sqlite_num_rows
SQLITE_NUM_ROWS(3)SQLITE_NUM_ROWS(3)sqlite_num_rows - Returns the number of rows in a buffered result setSYNOPSIS
int sqlite_num_rows (resource $result)
DESCRIPTION
Object oriented style (method):
int SQLiteResult::numRows (void )
Returns the number of rows in the buffered $result set.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
Note
This function cannot be used with unbuffered result handles.
RETURN VALUES
Returns the number of rows, as an integer.
EXAMPLES
Example #1
Procedural example
<?php
$db = sqlite_open('mysqlitedb');
$result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'");
$rows = sqlite_num_rows($result);
echo "Number of rows: $rows";
?>
Example #2
Object-oriented example
<?php
$db = new SQLiteDatabase('mysqlitedb');
$result = $db->query("SELECT * FROM mytable WHERE name='John Doe'");
$rows = $result->numRows();
echo "Number of rows: $rows";
?>
SEE ALSO sqlite_changes(3), sqlite_query(3), sqlite_num_fields(3).
PHP Documentation Group SQLITE_NUM_ROWS(3)