I wanted to write some records say 10000 in database table but got sql error -904 after inserting some records say 2000. I deleted 25 records of old records and than run the program again and this time after inserting 2025 records I got the same error? How can I solve this problem?
How to solve sql error -904 in inserting data
228 Views Asked by Soraya At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in DB2
- IBM DB2 console doesn't work after SSL certificate update
- SQL - Recursive Calculation Solution Required
- Concurrently open statements
- SQL Error: -302, SQLState: 22001 while using String function with a dynamic parameter in db2/hibernate
- Ibm Db2 Jdbc Connection
- DB2 and JSON, inconsistent quotation of integers
- SqlException in DBeaver24.0.1 when doing datasets connection
- How to inject the DBContext of Entity Framework Core to AutoFac
- TSM DB2 SQL query for display backup vm
- Azure Function Crash w/ Relation to IBM.EntityFrameworkCore
- RPG file using dynamic SQL fails to display data to display file
- GRAPHQL in Mainframe DB2
- Problem updating table A using data from table B
- Dynamic SQL with Hibernate
- open fetch and close cursor DB2
Related Questions in DB2-ZOS
- Problem with Flyway - cannot access to SYSCAT.TABLES
- How to output DB table update count report without accessing Db2 BSDS in BMC Log Master
- Connect to Db2 on z/OS from Windows. Connection failed due to a license error
- How do you get db2 clidriver license db2consv_t.lic?
- How to solve sql error -904 in inserting data
- Replacing the 113th position in a string with 'X' in DB2 SQL
- Cannot get the describe information for the calling stored procedure
- Db2 SQL - how to switch among different where conditions
- Insert/update Hex value to DB2 Z/OS PreparedStatement
- Running SQL PL on DB2 z/OS directly without stored procedures
- Can I index / insert keys to a DB2 large table to speed up selects?
- How do I set "for fetch only" when querying ibm db2 using the jdbc driver from spark?
- Exception "Unknown PrimitiveTypeKind DateTimeOffset" when save model in .Net Framework 4.8 in DB2
- db2 sql query on 4 tables not running? (taking too long?)
- Need suggestion with Procedure code error in DB12 Z/OS
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?
The log of the MSTR adress space of the DB2 instance should show the "unavalable resource" message DSNT501I including the reason code and in case of deadlock/timeout message DSNT375I/DSNT276I will show the offending user/plan. If you can't access it yourself you could try contacting your DBA.