-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: Truncate DataBase with comands SQL.
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Success! Subscription added.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
This group has been set to read-only. Please go to our new Developer forums to publish your content instead.
Read only
Truncate DataBase with comands SQL.
Former Member
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2009 Apr 06 8:08 PM
1,345
- SAP Managed Tags
- ABAP Development
- SQL
I need delete data of a Z table using SQL commands in SAP, ex.
exec sql.
Truncate table ZTABLE05.
endexe.
But, When I use this command displeing a dump 'DBIF_DSQL2_SQL_ERROR '.
From Uilian Silva.
1 ACCEPTED SOLUTION
Read only
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2009 Apr 06 8:15 PM
709
- SAP Managed Tags
- ABAP Development
- SQL
Try this way
exec sql.
Truncate table "ZTABLE05" " In double quote & no dot in the last
endexec.
a®s
2 REPLIES 2
Read only
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2009 Apr 06 8:15 PM
710
- SAP Managed Tags
- ABAP Development
- SQL
Try this way
exec sql.
Truncate table "ZTABLE05" " In double quote & no dot in the last
endexec.
a®s
Read only
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2009 Apr 06 8:44 PM
Bluesky