Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to rid of Deadlock or timeout?
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 =... -
db2 statistics
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... -
Trigger
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! -
SQL1652N File I/O error occurred
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... -
DB2 STORED PROCEDURE WITH IMBEDDED CALL FUNCTION
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... -
FTP from Unix db2 server to another unix server
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...- cristi22
- Thread
- Replies: 1
- Forum: UNIX Scripting
-
UPDATE TABLE'S VALUE BASED ON THE OTHER TABLE
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... -
SELECT WITH NULL VALUES
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... -
LIST TABLES SIZES IN BYTES for schema
Hello all Can i create a list of table & indexes & their sized in db2? list tables for schema myschemy... size in bytes? thanks, cristi -
MQT IN STORED PROCEDURE
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 --... -
STRING MANIPULATIONS
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... -
CASTING SUMMARIZED FIELDS
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 -
STRING MANIPULATIONS
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... -
STRING MANIPULATION (PATRIAL FIELD EXTRACT)
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... -
DB2 ASCII EXPORT
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! -
REORG CHECK
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... -
ERROR ON ALTER COLUMN
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... -
DYNAMIC SQL VERSUS STATIC SQL
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 (... -
CASE IN THE SELECT
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 (... -
FULL OUTER JOIN
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...
