home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
kcss0012.zip
/
SAMPLES
/
DAX
/
UNKNOWN.CSS
< prev
Wrap
Cascading Style Sheet File
|
1998-02-21
|
2KB
|
67 lines
/* Copyright (c) 1998 IBK-Landquart-Switzerland. All rights reserved.
*
* Module : Unknown.css
* Application : Sample to query an unknown table
* Author : Peter Koch, IBK
*
* Date Description Who
* --------------------------------------------------------------------------
* Feb 1998 First release P.Koch, IBK
* Feb 1998 Modified for V0.12 P.Koch, IBK
*/
#loadLibrary 'KcSysLib'
#loadLibrary 'KcStrLib'
#loadLibrary 'KcDaxLib'
main()
{
// check arguments
if (sizeof(mainArgVals) < 4) {
const exc[3] = {
'usage : CSS UNKNOWN name/password@connection tablename',
' ',
'example: CSS UNKNOWN SCOTT/TIGER@SALES EMP'
};
throw exc;
}
// connect
var name, pass, conn, a = 2;
name = strSplitConnectString(mainArgVals[a++], pass, conn);
var lnk = daxConnect('db2', conn, name, pass);
// start processing
var csr = daxParse(lnk, "select * from "+mainArgVals[a]+" order by 1");
var cols = daxSelectColumns(csr);
var line, size[cols];
// display title
for (var i=0; i<cols; i++) {
size[i] = daxSelectColumnSize(csr,i);
line +=
strSubString(
daxSelectColumnName(csr,i),
1, size[i]+1
);
}
sysLog(line);
// underline the title
line = '';
for (i=0; i<cols; i++)
line += strSubString('',1,size[i],'-')+' ';
sysLog(line);
// query and display the rows
var col[cols];
while (daxFetch(csr, col)) {
line = '';
for (i=0; i<cols; i++)
line += strSubString(col[i],1,size[i])+' ';
sysLog(line);
}
sysLog();
sysLog(daxRowsProcessed(csr)+" row(s) selected");
daxDisconnect(lnk);
}