Comments (7)
well, the TABLEDESC should have been created by the db2topg step. If you don't have a TABLEDESC, it means that either you didn't do this step, or the file is in another directory.
from db2topg.
The only issue is that the objects in this unsure file wont be migrated. The unsure file is produced so that you can inpect it, see if there are things you may want to try to migrate, and rewrite them yourself. The content cannot be re-written by db2topg (because of large differences in SQL or PL language mostly)
from db2topg.
Thanks that was in another directory i just moved it into the same and now it is working.
Now if i run unsure.sql and error occurs
psql.bin:/home/db2topgdir/unsure.sql:32: ERROR: syntax error at or near "LANGUAGE"
LINE 1: CREATE OR REPLACE FUNCTION rmsvcchk_fn LANGUAGE plpgsql RETU...
^
psql.bin:/home/abc/db2topgdir/unsure.sql:32: STATEMENT: CREATE OR REPLACE FUNCTION rmsvcchk_fn LANGUAGE plpgsql RETURNS (trigger) AS
NEW AS N FOR EACH ROW MODE DB2SQL WHEN (LCASE(N.SVR_SERVERNAME) = (SELECT
LCASE(SVR_SERVERNAME) FROM RMSERVER WHERE LCASE(N.SVR_SERVERNAME) = LCASE(SVR_SERVERNAME)))
SIGNAL SQLSTATE '75000' ('Servername already exists')
;
from db2topg.
Yes, that's the principle of the "unsure" file: there are statements that probably won't run in PostgreSQL.
To be honest, I didn't even try to run it once with stored procedures in it, these are too different between postgresql and db2.
from db2topg.
IS there any issue happens if we not run that unsure.sql
from db2topg.
Yes i checked that in db2 and it was some different kind ok data all other data was restored.
OK thanks for the valuable information and also thanks for such a great script db2topg
from db2topg.
I'm delighted it helped you.
from db2topg.
Related Issues (19)
- db2topg.pl is throwing error HOT 8
- Issues in db2topg.pl HOT 1
- db2topg.pl is throwing error
- db2topg guess_encoding dies HOT 2
- ./db2topg.pl command giving error HOT 1
- línea 7: error sintáctico cerca del elemento inesperado `newline' HOT 1
- Tablespace error HOT 2
- tablespace error .
- db2topg global symbol error .
- Error in show report command. HOT 1
- While running db2tppg.pl getting an error HOT 7
- empty string inserted as null
- [db2inst1@OESdb2pocserver db2topg-master]$ vi /u01/db2inst1/my_db2_sql_script.sql [db2inst1@OESdb2pocserver db2topg-master]$ ./db2topg.pl -f /u01/db2inst1/my_db2_sql_script.sql -o /u01/db2inst1/output_dir/ -d TESTDB -u adminuser -p ***** I don't understand ALTER TABLE "DB2INST1"."EMPLOYEE" ADD CONSTRAINT "PK_EMPLOYEE" PRIMARY KEY ("EMPNO") ENFORCED in an ALTER TABLE section at ./db2topg.pl line 829, <IN> line 202. HOT 2
- VARCHAR column conversion HOT 4
- Error while executing db2topg.pl file HOT 3
- Issue while using db2topg.pl HOT 1
- index create HOT 2
- Error while executing db2topg.pl script for DB2 sample schema HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from db2topg.