Comments (4)
marco44
commented on August 27, 2024
I've just pushed a patch for this. Please tell me if this fixes it.
from db2topg.
yhunkim
commented on August 27, 2024
The patch changes the VARCHAR(4 OCTETS) to VARCHAR($1), which is not recognized by PSQL create table command.
Also, some of the table names which were double quoted e.g. "DataBaseTable2_e" are all converted to databasetable2_e.
Thank you.
from db2topg.
marco44
commented on August 27, 2024
I pushed a correction for varchar…
For the case, yes, for now everything is lowercased. I didn't meet a case sensitive schema for db2 yet. If you have such a schema and really need to keep the case, please send it to me at cousinmarc at gmail.com, so that I can test it properly.
from db2topg.
yhunkim
commented on August 27, 2024
Thank you! This patch works for the VARCHAR case.
from db2topg.
Related Issues (19)
- db2topg.pl is throwing error HOT 8
- While running db2tppg.pl getting an error HOT 7
- Error while executing db2topg.pl file HOT 3
- Cannot open /home/db2topgdir/TABLEDESC, No such file or directory at ./deltocopy.pl line 234 HOT 7
- Issue while using db2topg.pl HOT 1
- index create HOT 2
- Error while executing db2topg.pl script for DB2 sample schema HOT 10
- 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
- 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
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.