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 best solutions below
Related Questions in INFORMIX
- Warnings in Informix database log
- How to release Informix lock from Java
- Informix - select from a temp table created in a 4gl with Interactive debugger?
- Informix throw internal error when creating new transaction in existing one
- How do I split a time range into days using stored procedure in informix 11.5?
- Informix PDO connection : Error SQLSTATE=HY000, SQLDriverConnect: -329 sqlerrm(systables)
- Informix database connection in Play framework
- What may cause connection to be null and How to reuse null reference object?
- SQL query if not null enter field value
- How to backup a single database residing in a dbspace in Informix?
- select for update in stored procedure (concurrently increment a field)
- Informix database issue: Changing the datatype format
- Unable to save dataframe on HDFS for Informix database
- Informix weekday calendar function not working
- SQL sum column in one table where value in another table is 'S'
Related Questions in DBIMPORT
- Informix: How to truncate a table when importing a dbexport
- Bulk data import in a java application
- How to create a DB file in sqlite3 using a .schema file
- Import large database faster
- #1044 - Access denied for user 'someuser'@'localhost' to database 'somedb'
- Dbimport utility missing in informix docker image?
- i am having difficulty on exporting issues on sql
- How I can escape backtick (´) from table name and column name?
- importing complex data from csv to mysql table
- How to load remote location xml file data to mysql/(any other) database
- Temenos DBImport error when trying to import from Oracle to H2
- Need to understand dbimport utility in Informix DB
- informix dbimport throws 23103 - Code-set conversion function failed due to illegal sequence or invalid value
- How to import .sql files into SQLite3?
- Heroku, data import error with mysql2
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)
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?
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.