home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
DBSQL.ZIP
/
LISTDB.SQC
< prev
next >
Wrap
Text File
|
1990-12-01
|
1KB
|
57 lines
#include <os2.h>
#include <stdio.h>
#include <sqlenv.h>
EXEC SQL INCLUDE SQLCA;
struct sqledinfo *sqledinfo;
CHAR chDrive;
USHORT sHandle;
USHORT sCount;
SHORT i,j;
VOID main ( );
VOID main ( )
{
chDrive = 'C';
sqledops ( chDrive, &sHandle, &sCount, &sqlca );
for ( i = 0; i < sCount; i++ )
{
sqledgne ( sHandle, &sqledinfo, &sqlca );
if ( sqlca.sqlcode == 0 )
{
for ( j = 0; j < SQL_DBNAME_SZ; j++ )
printf ( "%c", sqledinfo->dbname[j] );
printf ( " " );
for ( j = 0; j < SQL_ALIAS_SZ; j++ )
printf ( "%c", sqledinfo->alias[j] );
printf ( " " );
for ( j = 0; j < SQL_INAME_SZ; j++ )
printf ( "%c", sqledinfo->intname[j] );
printf ( " " );
for ( j = 0; j < SQL_NNAME_SZ; j++ )
printf ( "%c", sqledinfo->nodename[j] );
printf ( " " );
for ( j = 0; j < SQL_CMT_SZ; j++ )
printf ( "%c", sqledinfo->comment[j] );
printf ( " " );
printf ( "\n" );
}
}
}