Search results for query: *

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...

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...

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...

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...

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...

The date is defined as CHAR (20041231) select MEMBER_SSN , date ( LEFT ( END_DATE,4) || '-' || SUBSTR(END_DATE, 5,2) || '-' || RIGHT (END_DATE,2 ) ) END_DATE, BENEFIT_PLAN from elg_summary fetch first 10 rows only & the error...SQL0440N No authorized routine named "DATE" of type...

Hello everyone! What is the quickest formula to convert the following data: 9/15/1971 (DEFINED AS TEXT) 12/3/1942 to this format: 1971-09-15 1942-12-03 Thank you for your help! Ann [morning]

Hi Everyone - I am using unix AIX Version 5.2. What command should I use to see the CPU utilization & how many bytes, % every file in the system is using to see if it needs to be reorganized/resized. Thanks a lot for your help! Ann. [ponytails]

Hello Everyone – CR version 9.2 DB2 UDB 8 on AIX When I call the SP on the command line the dates are in the table. On the CR it displays 12/30/1899 for all off my date fields. When I browsed the data field it only shoes 12/30/1899. Any ideas what the problem might be? THANKS A LOT, ANN [3eyes]

Hello everyone! REALLY APPRECIATE ALL YOUR HELP! I need to create a sample procedure with one input parameter. If the parameter is null than select all from the table, else select the data based on the fund. Here is the procedure: CREATE PROCEDURE basys.MemberByFund ( IN in_fund VARCHAR(6) )...

Hello everyone! I am using DB2 8.2 on AIX. I am trying to export the table in ASCII (TEXT) format. I have a basic export statement to export the data file delimited by spaces. export to "c:\temp\HRS" of del modified by nochardel decplusblank striplzeros THANK YOU FOR YOUR HELP! Ann...

Hello everyone! I am using DB2 V8.1 UDB. Here is the data: ssn: hrs: year(yymm): 999999999 100.00 6603 999999999 100.00 6606 999999999 100.00 6609 999999999 050.00 6612 999999999 100.00 6703 999999999 100.00 6706 999999999 100.00 6709...

Hello Everyone! I have 3 input parameters on the report TYPE, DATE FROM & DATE TO on the report On the Select Exert the formula is: if {?CHECK TYPE } = "B" then {ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to {?ISSUED DATE TO} else {ILGW_VACATION.ISSUED_DATE} in {?ISSUED DATE FROM} to...

Hi everyone – REALLY, APPRECIATE YOUR HELP! Trying to create a crystal report with DB2 (IBM) back end. Here is the data: MEMBER_SSN CHECK CHECK_STATUS ISSUED_DATE AMT WHT_TYPE WHT_AMT WH_DESCRIPTION WH_TAX_CODE ---------- --------- ------------ ----------- ------------...

Hi Everyone - Using: DB2 8.0 on UNIX box I am trying to set-up a task to ftp the file from the unix box to the network Any suggestions on the script? THANKS A LOT!

Hello, I have a check_type parameter field on the report. (allowed multiple values) The user is prompt to choose V or P. If the user would not select any only records with P option will be displayed on the screen. if the user did not select anything P & V should be displayed. It should be...

Hello, I have a check_type parameter field on the report. (allowed multiple values) The user is prompt to choose V or P. If the user would not select any only records with P option will be displayed on the screen. if the user did not select anything P & V should be displayed. It should be...

I created a table & the length of one of the columns needs to be adjusted. How can I do it w/o re-creating the table? Thanks a lot for help!

Hi everyone! Please help! 1) ACT_VAL_04_TOT tbl to be updated Columns: SSN, (populated already) EARN, (populated already) HRS, (populated already) Q1_EARN, (needs to be updated) Q1_HRS, (needs to be updated) Q2_EARN, Q2_HRS, Q3_EARN, Q_3_HRS, Q4_EARN, Q4_HRS Here is the table...

Any help is appreciated!!!! DB2 8.2 on AIX.environment. How do I export the result query into the non-delimited ASCII file and specify the export location? Here is my export statement: EXPORT TO testexp OF DEL SELECT EARN, HRS FROM BASYS.ACT_VAL_04 FETCH FIRST 500 ROWS ONLY EXPORT TO...