Search Results

Thanks RudiC.. got it and is working now..:)

Thanks RudiC..

I amend my script but there another error. can you help point my mistake. Thanks
while read match
do
sqlplus user/pwd@table <<EOF
describe $match;
done < Match_Table
exit...

Hi All,

I created my first script that will display all table fields. since the tables are too many, I write script that will automate describe all the tables and put into one file.

I know for...

Hi RudiC,

Thanks for your reply.

The table definition for both are the same and no differences.

I think the oracle export dump files are not compatible to import into db2. is there other way...

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...

Hi rbatte1,

Thanks for your reply.

Actually, the table that I'm tried to import the data is empty. you can check also the attached text file for the error messages I found during import. most...

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...

Thanks gandolf989

---------- Post updated at 01:25 PM ---------- Previous update was at 01:17 PM ----------

Hi All,

Anyone please help? I run my import script in unix but im not sure why its...

Thank you very much Robin (as rbatte1), I appreciated your replied.

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...

Noted with thanks..

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...