Search results for query: *

Hi, Please help with the deadlock... I already did "force application all"....did not work and set the integrety does not work coz of the deadlock... The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 Lock Name =...

Hello Please help! How to list all tables on the tablespace? How to count number of rows per table along with the space information? Is there a utility where you can specify your tables to export all the data from these tables in comma delimited format? I don't need to export all tables from...

I am trying to create a trigger(s) on insert / delete / update The DAILY_PNR_LOG table should be updated with the key & the timestamp whenever the PNR_MEMBER table was updated / rows were deleted or inserted. Platform: Aix Database: UDB DB2 v9.1.300.257 Thanks a lot for you help!

Hello - Could you please help me figure out why the load is failing? It’s been running all along & I’ve attempted to load the file today with the following message: SQL3500W The utility is beginning the "LOAD" phase at time "04/29/200810:02:06.642163". SQL2061N An attempt to access media...

please help!!! We have various crystal intranet reports on the company's web-site and assosiated SPs. Each time the user runs the CR report via the bill_test_call stored procedure: i need to update the data in the ACCUMILATED_BILLING table based on the result set of the bill_test_call here...

Please help newbee in unix! There is a task which runs on the DB2 via the task center: task: connect to ali user ali using ali; export to "/sanbasys/basysload/MEMBER.IXF" of IXF select * from MEMBER; export to ..... connect reset; I need to create a unix shell to: (1) ftp MEMBER.IXF and...

Please help with DB2 UPDATE: I am trying to update the VALS_DV_SSA_06 table (ben amount) with the Amt from the temp_rf. The ben field is decimal (9,2) and the amt field is a varchar. (1) UPDATE VALS_DV_SSA_06 SET ben = ( SELECT double(cast (rtrim(amt) as char(5))) from temp_rf) where ssn...

Hello all - Here is the data sample: ssn: zip country_code --------------------------------- 123456789, " ", TU 999999999, 10003, USA 555555555, " ", "" should not be on the outfile 666666666,"07036", "" I need to extract the data for the mailing purposes & select...

Hello all Can i create a list of table & indexes & their sized in db2? list tables for schema myschemy... size in bytes? thanks, cristi

Hello - I am trying to built an SP to dynamically create an MQT with parms. this following code is failing... Please help! CREATE PROCEDURE BASYS.TAX_AMT_TBL_test ( IN CHK_YY VARCHAR(4) ) ------------------------------------------------------------------------ -- SQL Stored Procedure --...

Hello all - Trying to break the name - i've got some feedback & tried to follow but got lost somewhere in the middle...please help! alpha = WELCH,NORMAN,R need to break it into first last & mi fields: here is what i did SUBSTR(alpha,1,POSSTR(alpha,',')-1) as last_name the above code is good...

Hello all - Please help with casting I need to pass the field as decimal (9,2). Both quantity & rate fields are defined as decimal (9,2) sum ( cast (decimal(12,2), (rate * qty) ) as amount is not working.... :( thanks, cristi

Hello All - Please help with my string ordeals... Need to separate the alpha: Alpha = LastName,FirstName,MiddleName Data: SANDERS,JOHNNIE TORRES,DAISY,C Results: LAST_NAME MI FIRST_NAME SANDERS JOHNNIE TORES C DAISY Missing the code for MI & the First should not have the...

Hello all - Have to separate the state & the city from the address_3 field: My code does not work in case if there is no coma in the field: NEW YORK becomes NEW YO = city & RK = state or Here is my code: SELECT address_3, SUBSTR(ADDRESS_3,1,CASE...

Hello all - DB2 V 8.2 on aix. Need to create a proc to export the data from the table in ASCII delimited format (etc: start from 1 to 9 = ssn, 10 to 40 name & so on) db2 - a "export to "c:/temp/testfile.txt" select ssn (1,9), name(10,40) from member" ?????? Any help is appreciated!

Hello all - I reorg all indexes & runstats.. Could someone please explain what does the following means?? Any help is appriciated!!! why CONT_D_WK * other indexes have "*" ?? :db2 reorgchk current statistics on table basys.CONT_DETAIL Table statistics: F1: 100 * OVERFLOW / CARD < 5 F2...

Hello all - I am trying to delete the TIMESTAMP column from the table. I tried it for the smaller table & it worked. I am getting the following message: [IBM][CLI Driver][DB2/6000] SQL0443N Routine "ALTOBJ" (specific name "") has returned an error SQLSTATE with diagnostic text "SQL0443...

Hello all - I've changed my sp to run dynamically with prepare statement & it does not return any results. It runs fine in the regular procedure. Any ideas, please???!!! I think it has something to do with quotes… CREATE PROCEDURE BASYS.UMASS_ADD_NK_test (...

Hello all - How do I add the condition to look for Quarter 3 earn in case if the 4th Quarter earn is null (WORK_PERIOD is char 200501….). Here is my select for Q4 only: SELECT MEMBER_WORK_PERIOD.MEMBER_KEY , MEMBER_WORK_PERIOD.EMPLOYER_NO , SUM ( CASE WHEN WORK_PERIOD IN (...

Hello all - I have to merge the following two statements into one select to produce 8 columns of data (q1 thru q4 nrfp, q1 thru q4 nrf2p) based on the ssn number. I need to use the FULL OUTER JOIN and create one record with NRFP & NRF2P columns. Any ideas are appreciated!!!! --nrfp select...