Is there any good way to truncate the data of a table when importing a dbexport. I realize that I need to amend the number of rows in the .sql file, but how do I need to amend the unload file?
Informix: How to truncate a table when importing a dbexport
656 views Asked by weismat At
1
There are 1 answers
Related Questions in INFORMIX
- Informix Golang client package
- How to resolve this error when using OpenQuery in SQL Server to extract data from an Informix database
- Trigger/Stored Procedure causing sql error 127 Informix 12.10.FC10
- Update a huge number of rows without lock entire table in Informix
- Informix ODBC Driver][Informix]A character to numeric conversion process
- Update rows in an Informix database by incrementing serial numbers
- Informix - get DB Server Name / Alias for connected Session
- How can get full name from INFO TABLES at Informix DB
- Is there a way to get the sql statement about the creation of the row type?
- How to connect to informix DB using data direct informix driver and python on Linux
- IBM VS.NET SE Integration & Extensions package did not load correctly
- IBM Informix Error "-556 Cannot create, drop or modify an object that is external to the current Database"
- Find opaque types in the Informix database
- Informix: SQL does not accept double quote to surround a string
- Update a table in informix (an entire field)
Related Questions in DBIMPORT
- Temenos DBImport error when trying to import from Oracle to H2
- informix dbimport throws 23103 - Code-set conversion function failed due to illegal sequence or invalid value
- Dbimport utility missing in informix docker image?
- How I can escape backtick (ยด) from table name and column name?
- Need to understand dbimport utility in Informix DB
- How to load remote location xml file data to mysql/(any other) database
- importing complex data from csv to mysql table
- i am having difficulty on exporting issues on sql
- #1044 - Access denied for user 'someuser'@'localhost' to database 'somedb'
- How to create a DB file in sqlite3 using a .schema file
- Heroku, data import error with mysql2
- Import large database faster
- Bulk data import in a java application
- Informix: How to truncate a table when importing a dbexport
- How to import .sql files into SQLite3?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
If you really just want to load zero rows for the table, then copy
/dev/nullover the original data file. I haven't checked whether dbimport actually goes out to look for the data file when the SQL file says "0 rows to load", but it might well do so, load what it finds, and report the discrepancy. If the SQL file says "0 rows" and the data file contains 0 rows, then it shouldn't complain.