delete the table entries on db2

[Former Member]

Hi,

when iam applying pathces iam getting dump,i want to delete the entires on pat01 table,whats the command to see the tables and delete the entry on pat01,02,03 tables.

Thanku

[former_member640873 · Accepted solution]

Hi kumarraju,

Another way, which may be faster performance wise, is "import from /dev/null into <table name>". This is faster as it skip deleting the rows one by one.

Regards,

[Former Member · Accepted solution]

Hi,

Thanks,how i have to see all the tables in database,and how to delete the entries in table.like in sqliam going tablethere i have to delete the entries in table.

Thanku.

[Former Member · Accepted solution]

Hi Kumarraju,

To get the tables in a database you can use the following command

db2 "LIST TABLES"

The LIST TABLES have many options, with which you can restrict what will be returned. Execute the command to see them:

db2 "? LIST TABLES"

Besides, pay attention to the Type column, which indicates whether the object is a table or a view.

Regarding your second question, I can't follow you: do you want to delete the entries in a table ?

Best regards, Edgardo

[Former Member]

db2 delete from <Table Name>

regards

dEE

[Former Member]

Hi,

iam unable lo login sap.