Connect JasperServer and Sql 2008
i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to [...]

Answer Question   |  September 1, 2010  4:03 AM
Jasper, JasperServer, JDBC, SQL, SQL 2008, SQL Server 2008, SQL Testing

numeric test in SQL
I have a complex select query and must now add an additonal condition. One of the elements must be numeric. The ‘isnumeric’ function keeps erroring out on me. select FWVCCOA_FMS_CENTER cfmsctr,        fwvccoa_fund_code  cfundcde,        fwvccoa_orgn_code  corgncde,        ftvfund_orgn_code_def forgncde,        fwvccoa_prog_code  cprogcde,        ftvfund_prog_code_def fprogcde   from temple_finance.fwvccoa, ftvfund [strong]where ISNUMERIC(FWVCCOA_ACCI_CODE)= 1[/strong]  and fwvccoa_fund_code [...]

Answer Question   |  December 15, 2009  2:35 PM
SQL error messages, SQL Testing, WINSQL Numeric Function

SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)
Under ISDB, JOBLOG showed’ Internal Error 1001 has occurred SQLCOD -901′ SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’ SQLERP was ‘QSQROUTE’ – According to Manual ‘DB2 Universal Database for ISeries Appendix B SQL Comms Area’, SQLERP contains the name of the [...]

Answer Question   |  April 24, 2009  11:29 AM
RPG, SQL, SQL in RPG, SQL Testing