Convert PowerBuilder to Java

Conversion Samples of PowerBuilder to React and Java

Ispirer Toolkit analyzes all object dependencies during the conversion process and provides not only line-by-line conversion, but resolves type conversions as well. The software understands and transforms the necessary inheritance dependencies. It parses the entire source code, builds an internal tree with all the information about the objects, and uses it in the migration process.

The code samples below provide you with more details.

• Variables declarations conversion:

  PowerBuilder

  1. long    var1
  2.   long    var2[]
  3.   string    var3
  4.   datetime  var4
  5.   boolean    var5
  6.   decimal    var6
  7.   integer    var7
  8.   any    var8

  → React and Java

  1. let var1: number = 0;
  2. let var2: Array<number> = [];
  3. let var3: string = '';
  4. let var4: Date;
  5. let var5: boolean = false;
  6. let var6: number = 0;
  7. let var7: number = 0;
  8. let var8: any = null;

• Function conversion:

  PowerBuilder

  1. public function string sample_function();
  2. return "end"
  3. //do logic
  4. end function

  → React and Java

  1. function sampleFunction(): string {
  2.   return 'end';
  3.   //do logic
  4. }

• Subroutine conversion:

  PowerBuilder

  1. protected subroutine sample_sub (string v_app);
  2.   v_app = ""
  3. //do logic
  4. end subroutine

  → React and Java

  1. function sampleSub(vApp: string) {
  2.   vApp = '';
  3.   //do logic
  4. }

• If statement conversion:

  PowerBuilder

  1. integer i
  2.  
  3. if true then i = 1 else i = 2
  4.  
  5. if true then
  6.     i = 3
  7. end if

  → React and Java

  1. let i: number = 0;
  2.  
  3. if (true) {
  4.   i = 1;
  5. } else {
  6.   i = 2;
  7. }
  8.  
  9. if (true) {
  10.   i = 3;
  11. }

• For statement conversion:

  PowerBuilder

  1. For lv_count = 1 to 10
  2.   lb_units[lv_count].Visible = TRUE
  3. Next

  → React and Java

  1. for (lvCount = 1; lvCount < 10; lvCount++) {
  2.   lvCount[lvCount].visible = true;
  3. }

• While statement conversion:

  PowerBuilder

  1. IDX = 0
  2. do while true
  3.   if IDX = 10 then exit
  4.   IDX = IDX + 1
  5. loop

  → React and Java

  1. idx = 0;
  2. while (true) {
  3.   if (idx === 10) {
  4.     break;
  5.   }
  6.   idx = idx + 1;
  7. }

• Try catch statement conversion:

  PowerBuilder

  1. try
  2.   IDX = 1 / 0
  3. catch (Exception ex )
  4.   IDX = 100
  5. FINALLY
  6.   IDX = IDX * 2
  7. end try

  → React and Java

  1. try {
  2.   idx = 1 / 0;
  3. } catch (ex) {
  4.   idx = 100;
  5. } finally {
  6.   idx = idx * 2;
  7. }

• Try choose statement conversion:

  PowerBuilder

  1. integer    some_id
  2. boolean cond
  3.  
  4. CHOOSE CASE some_id
  5.   Case IS < 0
  6.     cond = False
  7.   CASE 0 TO 2
  8.     cond = True
  9.     some_id = 200
  10.   Case IS > 0
  11.     cond = True
  12.   CASE ELSE
  13.     cond = False
  14.     some_id = 0
  15. END CHOOSE

  → React and Java

  1. let someId: number = 0;
  2. let cond: boolean = false;
  3.  
  4. switch (true) {
  5.   case someId < 0:
  6.     cond = false;
  7.     break;
  8.   case someId >= 0 && someId <= 2:
  9.     cond = true;
  10.     someId = 200;
  11.     break;
  12.   case someId > 0:
  13.     cond = true;
  14.     break;
  15.   default:
  16.     cond = false;
  17.     someId = 0;
  18.     break;
  19. }

• Inline query conversion:

  PowerBuilder

  1. global type s_2 from structure
  2.     long        field_1
  3. end type
  4. s_2 param1[]
  5.  
  6.   INSERT INTO TAB1
  7.     (            
  8.     COL1 , COL2          
  9.     )
  10.   VALUES
  11.     (
  12.     :param1[1].field_1,
  13.     :param1[2].field_1
  14.   );

  → React and Java

  1. Client (typescript):
  2. export type s2 = {
  3.   field1: number;
  4. };
  5.  
  6. export class S2 {
  7.   static create(): s2 {
  8.     return {
  9.       field1: 0,
  10.     };
  11.   }
  12. }
  13.  
  14. let param1: Array<s2> = [];
  15.  
  16. await request({
  17.   path: 'fileName/query1',
  18.   body: {
  19.     params: [param1[0].field1, param1[1].field1],
  20.   },
  21.   method: 'POST',
  22. });
  23.  
  24. server (Java):
  25. private String QUERY1 = "INSERT INTO TAB1 "+
  26.     "( "+
  27.     "COL1 , COL2 "+
  28.     ") "+
  29.   "VALUES "+
  30.     "( ?, ?) ";
  31.  
  32.     @PostMapping(value = "/query1")
  33.     public @ResponseBody
  34.     int  query1(@RequestBody Map<String, Object> body) throws Exception {
  35.  
  36.         return sqlService. jdbcUpdate (QUERY1, (List<Object>)body.get("params"));  
  37.  }

• CURSOR conversion:

  PowerBuilder

  1. String v_uname[]
  2. Long v_unum[]
  3. Int  v_count = 1
  4.  
  5. DECLARE c_unit CURSOR FOR
  6. SELECT U_NAME, U_NUM
  7. FROM UNT
  8. WHERE A_NUM = 10;
  9.  
  10. OPEN c_unit;
  11. FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
  12. v_count ++
  13. Do While SQLCA.SQLCode = 0
  14.   FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
  15.   v_count ++
  16. Loop
  17. CLOSE c_unit;

  → React and Java

  1. Client(typescript) :
  2. let vUname: Array<string> = [];
  3. let vUnum: Array<number> = [];
  4. let vCount: number = 1;
  5.  
  6. let rows = await request({
  7.   path: 'fileName/query1',
  8.   body: {
  9.     params: [],
  10.   },
  11.   method: 'POST',
  12. });
  13.  
  14. for (let i = 0; i < rows.length; i++) {
  15.   vUname[v_count] = rows[i].U_NAME;
  16.   vUnum[v_count] = rows[i].U_NUM;
  17.   vCount++;
  18. }  
  19.  
  20. server(Java):
  21. private String QUERY1 = "SELECT U_NAME, U_NUM FROM UNT  WHERE A_NUM = 10 ";
  22.  
  23.     @PostMapping(value = "/query1")
  24.     public @ResponseBody
  25.     Object query1(@RequestBody Map<String, Object> body) throws Exception {
  26.  
  27.         Object values = sqlService.jdbcSelect(QUERY1, (List<Object>)body.get("params"));
  28.         return ResponseEntity.ok(values);
  29.     }
• How to start the client:

  1. Install nodejs
  2. Open the ReactClientName folder in vs code
  3. Open terminal (Ctrl+`)
  4. Run the command: npm i
  5. Run the command: npm run start
  6. Open the URL in your browser: http://localhost:3000/

  How to start the server:

  1. Open the JavaServerName folder in vs code
  2. Switch to the Run and Debug tab (Ctrl+Shift+D)
  3. Click the Server Application button