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

    Row Count in UNION for DB2

    just as i thought... you've helped to confirm my thought. thanks.
  2. newdbprgr

    Row Count in UNION for DB2

    Faced with this problem, any idea how to go about it? SELECT * FROM ( (SELECT COL1, COL2, MAX(COL3), ROWNUMBER() OVER (ORDER BY COL1) AS ROW_NEXT WHERE COL1 = 'A' GROUP BY COL1, COL2) UNION (SELECT COL1, COL2, COL3, ROWNUMBER() OVER (ORDER BY COL1) AS ROW_NEXT WHERE COL1 != 'A'...
  3. newdbprgr

    Problem encountered (Urgent)

    Thanks. Case Closed. I've requested vendor to change it to NUMBER.
  4. newdbprgr

    Problem encountered (Urgent)

    I need to cover at least 99999999.999999 to 0.000001. IF I didn't specify the precision of the DECIMAL, what will the default precision?
  5. newdbprgr

    Problem encountered (Urgent)

    I've escalated this matter to the other company, as I can't do much on my part. The code is on another server with firewall setting, unable to request to open to view source. Thanks SantaMufsa and thargtheslayer for your reply. I will tell them to change the datatype over at their side, which...
  6. newdbprgr

    Problem encountered (Urgent)

    Hi all, due a recent update to 10g Oracle, the application doesn't seem to be working properly. CREATE OR REPLACE PROCEDURE INS_APPL ( P_QTY IN DECIMAL, P_NAME IN VARCHAR2) I've always passed in String for both the variables and it has been working fine with the previous...

Part and Inventory Search

Back
Top