I am not familiar with COBOL programming language. But as per the requirement I have to work on a COBOL application. I am facing below issue with one SQL query in the application.
Post execution of below code snippet variable var_b should be populated with table column value var_val.
But after execution the variable var_b value is empty. As the empty value is getting generated we have run a SQL Profiler and observed that join condition is not taking complete column name but remaining query after joining condition is generated properly.
So we re-arranged the above sourced as shown in below image the value is populated properly to var_b because the query taking complete join condition in SQL Profiler.
I am using below configuration to compile COBOL application.
IDE: Microfocus Visual Cobol for VisualStudio2017
Machine: Windows10 64 bit machine
Compilation Mode: Release mode with X86
Remaining SQL select queries are executed properly only have problem with above query.
So could you please help me to understand the root cause of the issue.
Thanks in advance!