Search results for query: *

we re-started the Crystal server & it worked!

Hello all - udb db2 8.2 CR 9 We've changed the instance for the DB2, re-publish the report via the web sphere & here is the message .... com.crystaldecisions.report.web.viewer.CrystalReportInteractiveViewer Logon failed. Details: Unable To Connect to DB2 Server BASYSDW Error in File...

I set the parms to NULL it works THANKS FOR YOUR HELP, Ann [dazed]

Try hiding duplicates by clicking on the field property & selct "suppress duplicates" option Hope it helps, Ann

no results

in CR, but i am testing it first on the command line or running it on the server thanks:)

thank you for your help!

I did, it build w/o error, but does not work for the null parm Thanks all for your help, Ann

Here is the code I've code , e1.empl_name from elg_summary h inner join (select empl, empl_name from UMASS_EMPL) as e1 on h.EMPLOYER = e1.empl , elg_summary s cheers! Ann [morning]

Hello everyone – Any help is appreciated!!! I need to join another table to the following SP with extracts the data from one table based on the change of coverage. I need to add the employer name that comes from a diffirent table I tried to JOIN by did not work Here is my SP: CREATE...

Fetch C1 into ...; ??????

I've got the code for the null input parms from the earlier posts from Ddiamond I am getting an error on variable declaration CREATE PROCEDURE BASYS.UMASS ( IN IN_FROM_DATE DATE, IN_NEW_BEN_PLAN CHAR (6), IN_OLD_BEN_PLAN CHAR (6), IN_EMPL CHAR (9) ) DYNAMIC RESULT SETS 1...

where 1=1 what does it mean? Thank you for your help I've changed the code (it works!!!) There are few more things I have to add: 1. The user requested to do the search by Employer (Enter one employer if none is entered SELECT * ) 2. Add the employer NAME I created a table with EMPL# & NAME...

Dan - The condition is based on the benefit’s date month. The end day of the previous coverage should be one month less than the beginning month of the current coverage My SP is set-up to handle the DOHIGH input parameter. SP: CREATE PROCEDURE BASYS.UMASS ( IN FROM_DATE DATE, BENEFIT_PLAN...

THIS MIGHT WORK AS WELL? MONTH ( STD.END_DATE) = MONTH ( '2005-07-01') - 01 AND YEAR ( STD.END_DATE ) = YEAR ('2005-07-01')

Any help is appreciated! I need to select records with END_DATE of previous month. How do I account for January ? SELECT DISTINCT HIGH.MEMBER_SSN , HIGH.BENEFIT_PLAN , HIGH.BEN_DATE AS BEGIN_DATE , HIGH.END_DATE AS HIGH_END_DATE , STD.BENEFIT_PLAN , STD.BEN_DATE AS...

here it is : Any suggestions on how to make it better? SELECT DISTINCT HIGH.MEMBER_SSN , HIGH.BENEFIT_PLAN , date ( SUBSTR ( HIGH.BEN_DATE,1,4) || '-' || SUBSTR( HIGH.BEN_DATE, 5,2) || '-' || SUBSTR ( HIGH.BEN_DATE,7,2 ) ) AS HIGH_BEGIN_DATE , date ( SUBSTR (...

Hello everyone! Using DB2 8.2 vers on aix. Really appreciate your help! Trying to create a SP with input parms. The first part is the SELECT statement. (The member could change the coverage from DOHIGH to DOSTAN & other way around) The user enters the date & BENEFIT_PLAN parameters. The...

Apologize for the obscure question Please disregard…. Ann [blush]

Hello everyone - DB2 UDB 8.2 CR 9 Any help is appreciated!!! I am trying to create a SP with input parameters. parms: ?date, ?from high (from DOHIGH to DOSTAN) / from standard (from DOSTAN to DOHIGH) Data: MEMBER_SSN END_DATE BENEFIT_PLAN ---------- -------- ------------ 99999999...