View data from UDB file

[Former Member]

I am very new to SAP.

I am using Ultralite database as a local db.Used Sybase Central to open the sample .udb file.Tables, Indexes, and all displayed. But when i am trying to view the data using the "Interactive SQL" statements, noting displayed. the table is empty. what may be issue?

[former_member182948]

Hi,

Sybase Central can display the table data.

(Choose "Data" tab on the table.)

Can you see the table data on the Sybase Central?

Regards,

Koichi

[Former Member]

Yeah. i tried with that option only.But the data results is empty always.

[former_member182948]

Sybase Central and Interactive SQL are different tools.

Unfortunately, I don't understand what you saw.

Can you show me the screenshot (data results)?

[Former Member]

Attached image.

[former_member182948]

Thank you for your reply.

I understood that the table data weren't displayed on Sybase Central.

I think there are 3 possibilities.

1. The database may have corrupted.
   You would have to validate the UDB file by the next command.
   
   example.
   ulvalid -c DBF=sample.udb
   
   For details, please see the next document.
   http://dcx.sap.com/index.html#sa160/en/uladmin/fo-utilities-s-5719233.html
   
   
2. The data aren't displayed for some reason.
   If there are some data in the table,
   You can check data existing in the table by the next query.
   
   example.
   SELECT COUNT(*) FROM TableName
   
   Please execute the query from Interacive SQL.
   If there are data in the table, row count may be displayed.
   
   
3. The UDB file which you are using is wrong.
   If the database wasn't corrupt and there is no data in the table,
   you may have seen a different UDB file.
   (Or you saw a different table.)
   You can see the database information by the next command.
   
   example.
   ulinfo -c DBF=sample.udb
   
   For details, please see the next document.
   http://dcx.sap.com/index.html#sa160/en/uladmin/ulcs-utilities-s-4378964.html

Regards

[former_member199074]

what happens when you insert a row into the udb using sql central?