powerbuilder query to sql query

Question

I want to convert this powerbuilder query to SQL query but I am not getting any proper tutorial.I tried to convert this Powerbuilder query into sql based query but I am not very much sure about it.

PBSELECT( VERSION(400) TABLE(NAME=~"childpart~" ) COLUMN(NAME=~"childpart.child_part_no~") COLUMN(NAME=~"childpart.part_no~") COLUMN(NAME=~"childpart.component_qty~") COLUMN(NAME=~"childpart.regist_person~") COLUMN(NAME=~"childpart.regist_date~") COLUMN(NAME=~"childpart.regist_time~") COLUMN(NAME=~"childpart.upd_person_name~") COLUMN(NAME=~"childpart.upd_date~") COLUMN(NAME=~"childpart.upd_time~")WHERE(    EXP1 =~"childpart.child_part_no~"   OP =~"=~"    EXP2 =~":p_child_part_no~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"childpart.part_no~"   OP =~"=~"    EXP2 =~":p_part_no~" )

SQL converted query

SELECT childpart.child_part_no ,childpart.part_no ,childpart.component_qty ,childpart.regist_person ,childpart.regist_date ,childpart.regist_time ,childpart.upd_person_name ,childpart.upd_date ,childpart.upd_time FROM childpart WHERE EXP1 = childpart.child_part_no OR EXP2 = p_child_part_no and EXP1 = childpart.part_no OR EXP2 = p_part_no

Any help will be appreciated.Thank you in advance.

Answer 1

When you view the Query in PowerBuilder, simply click on Design -> Convert to Syntax

Answer 2

Correct converted query:

SELECT childpart.child_part_no,childpart.part_no,childpart.component_qty,childpart.regist_person,childpart.regist_date,childpart.regist_time,childpart.upd_person_name,childpart.upd_date,childpart.upd_time 
FROM  childpart   
WHERE childpart.child_part_no=:p_child_part_no AND childpart.part_no=:p_part_no