Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
is this enough to make the data perfect export into delimited file? there are some posted that i read, they included the table field names.
what is the different of this 2 (with table field names and without?
can anyone suggest for the import script into oracle?
2. Relevant commands, code, scripts, algorithms:
Code:
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 '/cardpro/brac/v5/dev/dat/BBBBB.DEL' OF DEL select * FROM BBBBB"
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/CCCCC.DEL' OF DEL select * FROM CCCCC"
...
..
db2 terminate
3. The attempts at a solution (include all code and scripts):
Code:
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 '/cardpro/brac/v5/dev/dat/BBBBB.DEL' OF DEL select * FROM BBBBB"
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/CCCCC.DEL' OF DEL select * FROM CCCCC"
...
..
db2 terminate
4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Xavier university, Philippines, lincaro, computer engineering
Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 01-20-2017 at 05:56 AM..
Reason: Added CODE tags.
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 CENTOS
drop_text_search_template
DROP TEXT SEARCH TEMPLATE(7) PostgreSQL 9.2.7 Documentation DROP TEXT SEARCH TEMPLATE(7)NAME
DROP_TEXT_SEARCH_TEMPLATE - remove a text search template
SYNOPSIS
DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TEXT SEARCH TEMPLATE drops an existing text search template. You must be a superuser to use this command.
PARAMETERS
IF EXISTS
Do not throw an error if the text search template does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of an existing text search template.
CASCADE
Automatically drop objects that depend on the text search template.
RESTRICT
Refuse to drop the text search template if any objects depend on it. This is the default.
EXAMPLES
Remove the text search template thesaurus:
DROP TEXT SEARCH TEMPLATE thesaurus;
This command will not succeed if there are any existing text search dictionaries that use the template. Add CASCADE to drop such
dictionaries along with the template.
COMPATIBILITY
There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.
SEE ALSO
ALTER TEXT SEARCH TEMPLATE (ALTER_TEXT_SEARCH_TEMPLATE(7)), CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7))
PostgreSQL 9.2.7 2014-02-17 DROP TEXT SEARCH TEMPLATE(7)
01-20-2017
