|
Browse by Tags
All Tags » Databases ( RSS)
-
|
If you have created any schedule jobs or you just need to see what jobs are available in a server you use the dba_jobs table. The following links provides more details about this view: http://www.praetoriate.com/data_dictionary/dd_dba_jobs.htm
|
-
|
This is way a discused with a friend for migrating a VB6 RDS CreateRecordset Private Function Foo(rs As ADOR.Recordset) As Boolean On Error GoTo Failed Dim ColumnInfo(0 To 1), c0(0 To 3), c1(0 To 3) Dim auxVar As RDS.DataControl Set auxVar = New RDS.DataControl...
|
-
|
This code is so handy that I'm posting it just to remember. I preffer to serialize my datasets as attributes instead of elements. And its just a matter of using a setting. See: Dim cnPubs As New SqlConnection( "Data Source=<servername>;user...
|
-
|
case sentitive SQL SErver...
|
-
|
Source IP for connected applications in DB2 Usually when there are performance problems you need to track who is connected to the database. Especially in development environments because production environments are more restricted with who has access...
|
-
|
The idea was to create a harry potter like title jeje. Today I had a new issue with DB2 (everyday you learn something new). I got to work and we had some tables that you could not query or do anything. The system reported something like: SQL0668N Operation...
|
|
|
|