home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 18 REXX
/
18-REXX.zip
/
rexxgdb2.zip
/
G2Ht.CMD
< prev
next >
Wrap
OS/2 REXX Batch file
|
1997-08-10
|
2KB
|
75 lines
/* rexx */
signal on error
signal on syntax name error
signal on halt name error
signal on failure name error
'@echo off'
'cls'
say
say 'G2Ht --- Testing REXXGDB2.DLL HTML table tag creator function'
say ' (G2HSelect2Table)'
say 'Simon Husin (husin@ibm.net)'
say 'Kent, Washington, U.S.A., Nov 1996 - Aug 1997'
say
sql = 'Select * from staff'
sq2 = 'Select * from department'
sq3 = 'Select * from org'
sq4 = 'Select * from employee'
htmlfn = 'G22HTML.HTM'
requestedrows = 9999999
nullchar = ''
varcharlen = ''
show_border = '1'
show_rownum = '1'
show_header = '1'
if rxfuncquery('g2LoadFuncs') then do
say
say 'Loading REXXGDB2 Functions...'
call rxfuncadd 'g2LoadFuncs', 'REXXGDB2', 'g2LoadFuncs'
say 'Result =' g2LoadFuncs()
end
say
say 'Connecting to SAMPLE database...'
call g2connectshare 'SAMPLE'
if result \= 0 then do
say 'SQLCODE'result
return 10
end
say
'@DEL' htmlfn '1>NUL 2>NUL'
call time 'R'
call g2h htmlfn, 1, '<FORM METHOD="POST">'
call g2hselect2table htmlfn, 1, 'sq4', 999,,,1,1, 1
call g2hselect2table htmlfn, 1, 'sq3', 999,,, ,1, 1
call g2hselect2table htmlfn, 1, 'sq2', 999,,,1, , 1
call g2hselect2table htmlfn, 1, 'sql', 999,,,1,1, 1
call g2h htmlfn, 1, '</FORM>'
elapse = time('E')
'@netscape file:///'htmlfn
/* '@explore -q' htmlfn */
say 'Execution time' elapse
say
say 'Commiting...'
call g2commit
return 0
error:
say 'Error detected at line' SIGL
return 10
syntax:
say 'Syntax error detected at line' SIGL
return 20