/* search FDR database */ /* signal on error */ signal on syntax trace o cgi = 'PHOTO'; vers = '1.2'; errto = 'STMK@VM.MARIST.EDU' e1 = time('R') cmdstat1 = fdrstats() /* vtime ttime reads writes sios */ 'REXX FDRHTTP' cgi vers text = getvar('TEXT') type = getvar('TYPE') db = getvar('DB') text = fdresc(text) CELLFORM = 'LID;15-DATE;17-JUNK;2-TITLE;1024-', 'FILEID;50' 'OUTPUT

Your Search Results

' 'OUTPUT ' 'OUTPUT ' , '' , '' , '' , '' , '' if (type == "title") then do text = translate(text) srch = "UCTITLE like '%"text"%' order by lid" end /* title */ else srch = "(DT1 like '%"text"%') order by dt1" /* Handle the different eras */ select when (db == "1") then ndb="DEPRESSV" when (db == "2") then ndb="WWIIV" when (db == "3") then ndb="FDRV" otherwise ndb="DEPRESSV" end sel ="SELECT lid, dt1, title, number" , "from FDR."NDB" where" , srch 'OUTPUT' '' "CALLPIPE (name photo03 end ?) sql noind release" sel , "| > SQL DATA W" "CALLPIPE literal" CELLFORM"%&%PHOTO | > STEM DATA W" "CALLPIPE (name photo03 end ?) sql noind release" sel , "| c: count lines" , "| rexx stempros "CELLFORM"%&%PHOTO" , "| change /\// |*: " , "?" , "c: | var num" If rc <> 0 then signal sqlerr 'OUTPUT
Library IDDateTitlePhoto

' num ' matches returned.' /*%include fdrsuff */ /* suffix */ e2 = time('R') 'REXX FDRCLEAN' cmdstat1 e1 e2 'OUTPUT ' exit 0 getvar: arg sub . v = symbol('form.sub.1') If v = 'VAR' then return form.sub.1 else return '' sqlerr: errrc = rc errsigl = sigl errtxt = 'SQL error' 'CALLPIPE (name sqlerr) SQLCODES | VAR cgi_sqlcodes' If errrc = -900 then address command 'CP IPL' signal errcleanup Error: errrc = rc signal off error 'OUTPUT' 'Error' , 'Sorry, ' cgi ' has' , 'experienced a serious error.' , 'If the error persists, contact ' , 'Error Report' errsigl = sigl errtxt = errortext(errrc) signal errcleanup Syntax: errrc = rc signal off syntax 'OUTPUT' 'Error' , 'Sorry, ' cgi ' has' , 'experienced a serious syntax error.' , 'If the error persists, contact ' , 'Error Report' errsigl = sigl errcleanup: signal off error signal off syntax srcline = sourceline(errsigl) 'OUTPUT' "" "OUTPUT" '' DumpIt: address command 'EXEC FDRCDUMP'