Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Question Unanswered: Oracle specific LPAD, RPAD Equivalent in DB2 UDB. Help Required--Matter Urgent

    Hi friends,
    I am trying to port an Oracle Database to DB2 UDB. I have a situation at hand, which demands that I convert a select statement with LPAD and RPAD functions to UDB. For the sake of clarity, the SQL Statement is as follows:

    insert into fgt_notify_queue(id,time_stamp,event_id,object_id, trigger_time,domain_id, flags)
    values( 'noque' || lpad(ltrim(rtrim(to_char(fgt_notify_queue_seq.next val))), 15, '0') ,xxnewts, xxevent_id, xobj_id, xnotify_on, xdomain_id, '0000000000');


    Kindly help me out as I am new to DB2 UDB and SQL-PL, I am an Oracle guy and have been handed over this task.

    Thanks in Advance.
    Manish Kumar.
    Last edited by manishkumar; 11-29-04 at 04:44.

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Please read Must Read before posting. Number 3 is interesting.

    Grofaty
    Last edited by grofaty; 11-29-04 at 09:23.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •