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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ancheswaroop

    Select records from table one which are not match

    Table 1: TRAN_ADJUSTMENT_REC Table 2: DLY_TRAN_FILE I am matching this two tables with this Query select count(1) from TEDCLZ.TRAN_ADJUSTMENT_REC INNER JOIN TEDCLZ.DLY_TRAN_FILE on cast((REPLACE(substr(cast(date(cast(substr(TEDCLZ.DLY_TRAN_FILE.AT31_TRANSACTION_DATE,5,3) as int))as...
  2. ancheswaroop

    How to change date format

    TABLE 1 TRANSACTION_DATE ------------------- 11052005 12112005 01222006 02192006 02125006 (MMDDYYYY) TABLE 2 AT31_TRANSACTION_DATE ------------------------ 2005270 2005340 2006022...
  3. ancheswaroop

    How to change date format

    '2006'||SUBSTR(DIGITS(DAYOFYEAR('2006-'||TRAN_DATE_TRANSACTION,1,2||'-'||TRAN_DATE_TRANSACTION,1,2)),8) this one working fine but i have some days records with year 2005
  4. ancheswaroop

    How to change date format

    Here i have to change the format mm dd to yyyymmm if date is Feb 3 2006 mm dd show 02 03 yyyymmm show as 2006034 (yyyymmm)2006034 is 2006Jan 31 days + Feb 3 days(31+3=34) mm dd(02 01) to yyyymmm (2006032)
  5. ancheswaroop

    How to change date format

    How to change date format from mm dd(02 01) to yyyymmm (2006032)
  6. ancheswaroop

    How to matching this two Tables

    To change date format i use this in select dtatement substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,5,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,7,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,3,2)) as CHDATE, but how to use this CHDATE
  7. ancheswaroop

    How to matching this two Tables

    Note: format of data in LG3_DATE= 20060120(yyyymmdd) but in IN_TRANSACTION_DATE= 012006(mmddyy) Format of LG3_TIME=114921506063 Format of IN_TRANSACTION_AMOUNT=114921 Format of LG3_TRANSACTION_AMOUNT= '+00000000052.19' Format of IN_TRANSACTION_AMOUNT= '000000052.19' I have to match two...
  8. ancheswaroop

    How to match two tables having different data formet

    //(column1, -9,9)// what is this
  9. ancheswaroop

    i can't run this

    select substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,5,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,7,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,3,2) as CHDATE, TEDCLZ.CA_AUTH_DLY_FILE.LG3_TIME, TEDCLZ.CA_AUTH_DLY_FILE.LG3_TRANSACTION_AMOUNT, TEDCLZ.CA_AUTH_DLY_FILE.LG3_APPROVAL_CODE...
  10. ancheswaroop

    I can not run this Quary

    i am using db2
  11. ancheswaroop

    How to match two tables having different data formet

    I have to match two tables with one columns but columns are with different data formet columns 1 having data as +000000150.20 and columns 2 data as 000150.20 data type of this columns=char how can i match this two tables
  12. ancheswaroop

    I can not run this Quary

    select substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,5,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,7,2) || substr(TEDCLZ.CA_AUTH_DLY_FILE.LG3_DATE,3,2) as CHDATE, TEDCLZ.CA_AUTH_DLY_FILE.LG3_TIME, TEDCLZ.CA_AUTH_DLY_FILE.LG3_TRANSACTION_AMOUNT, TEDCLZ.CA_AUTH_DLY_FILE.LG3_APPROVAL_CODE...

Part and Inventory Search

Back
Top