how to get the sql query behind a spid in sybase

The command you need to use to find the text of a spid say one that is blocking is dbcc sqltext.

This can be used like this

dbcc sqltext()
you can also use this command to get see whats is happening in a block you can do this by

use master
go
select * from syslogshold this will find the longest running transaction.
go
dbcc traceon(3604)
go
dbcc sqltext (104)
go
SQL Text: INSERT INTO JMA2_HstYtdSave ( Class, A_B, SUN_DB, Ent_ID, LAcct_ID, CC_ID, PJ_ID, Period, Amount, Type, Cat, LAcct, Acct_ID, CP_ID, LM_Gr, SU_CC_ID, FU_ID, CC, PE_BL_ID, Div_ID, BL_ID, BU_ID )\t\t VALUES ( 'Hst', 'A', 'DB7', '720', '800000001', '3110', ' ', 2008012, -0.050, 'H', 'FU', 'Head count Avg', '0010E', ' ', 'HC', ' ', 'CM30_105_0005', 'Money Market', 'woPE', 'IB', 'CM30', 'CM30_105' )
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.