tag:blogger.com,1999:blog-8846338869468701351.post5738289232834997538..comments2024-02-07T16:53:07.465+01:00Comments on Consultorio Cobol: SYSTABLES, SYSCOLUMNS y SYSINDEXESTallianhttp://www.blogger.com/profile/07467131702681958877noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8846338869468701351.post-64621886785551841052018-05-16T07:07:09.898+02:002018-05-16T07:07:09.898+02:00ñoñogloria andreahttps://www.blogger.com/profile/05618740480902483779noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-30293534142323895962016-08-31T20:40:42.610+02:002016-08-31T20:40:42.610+02:00muy buen aportemuy buen aporteEkriakonhttps://www.blogger.com/profile/01845012142612508182noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-61561530868828496602016-08-22T11:27:27.082+02:002016-08-22T11:27:27.082+02:00Y aqui estan todas....http://www.ibm.com/support/k...Y aqui estan todas....<br><br>http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/cattab/src/tpc/db2z_catalogtablesintro.html<br><br>Mtellohttps://www.blogger.com/profile/02151036470903100563noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-32970806318077170352016-08-22T11:16:30.950+02:002016-08-22T11:16:30.950+02:00-- TABLAS QUE NO ESTAN VACIASSELECT T.NAME ,SUBST...-- TABLAS QUE NO ESTAN VACIAS<br><br>SELECT T.NAME ,SUBSTR(T.NAME,1,3),TOTALROWS <br>FROM SYSIBM.SYSTABLESPACESTATS A<br> ,(SELECT DBNAME , NAME FROM SYSIBM.SYSTABLES <br> WHERE CREATOR ='creator' AND NAME LIKE 'nombre%' ) T <br>WHERE <br>A.DBNAME = T.DBNAME<br>AND TOTALROWS > 0 WITH UR;<br><br>--PROGRAMAS QUE USAN UNA TABLA<br>SELECT DNAME from SYSIBM.SYSPACKDEPMtellohttps://www.blogger.com/profile/02151036470903100563noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-15466025531500397222016-08-11T17:03:18.166+02:002016-08-11T17:03:18.166+02:00Hola, les aporto una Query para utilizarla en Syba...Hola, les aporto una Query para utilizarla en Sybase<br>----------------------------------------------------<br>--COLUMNAS DE UNA TABLA PARA SYBASE<br>SET NOCOUNT ON<br>DECLARE @objeto_tabla INT<br><br>SELECT @objeto_tabla = OBJECT_ID('dbo.MI_TABLA')<br><br>SELECT name<br>FROM syscolumns<br>WHERE id = @objeto_tabla --Número de ID de MI_TABLA<br><br>SELECT name<br>FROM syscolumns<br>WHEREBen Shttps://www.blogger.com/profile/17659114387474822070noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-17270308884216868172015-04-22T14:37:03.259+02:002015-04-22T14:37:03.259+02:00Excelente aporte!!! graciasExcelente aporte!!! graciascarlos camilo ogashttps://www.blogger.com/profile/04468065150060809809noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-83080926248628844692012-10-18T11:33:03.617+02:002012-10-18T11:33:03.617+02:00que bien me ha venido, muchas gracias!!!que bien me ha venido, muchas gracias!!!Staretzhttps://www.blogger.com/profile/17086505826157412503noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-68218332985175913712011-05-24T14:09:17.307+02:002011-05-24T14:09:17.307+02:00Pa eso estamos ;), gracias a tiPa eso estamos ;), gracias a tiLobochttps://www.blogger.com/profile/18012287945984711504noreply@blogger.comtag:blogger.com,1999:blog-8846338869468701351.post-78270945217547573492011-05-24T12:36:13.575+02:002011-05-24T12:36:13.575+02:00Un aporte de la ptm.... Gracias, un saludo.JheykoUn aporte de la ptm.... Gracias, un saludo.<br>JheykoAnónimonoreply@blogger.com