codefori / codefori/vscode-ibmi
Not able to open JDE World sources - the source file is created using JDE case tool
- Dominant language
- TypeScript
- Stars
- 418
- Forks
- 160
- Avg merge
- 4d 19h
- Merged PRs (30d)
- 12
Description
**Describe the bug**
Not able to open JDE World sources. JDE World source file is created using the case tool and the source file column structure is different from that created using the CRTSRCPF command.
**To Reproduce**
Steps to reproduce the behavior:
1. Need a JDE World Source PF
2. Connect to an IBMi system.
3. Open a member.
4. Error obtained -
[SQL0206] Column or global variable SRCDTA not found., 42703, -206
at e. (c:\Users\Anand.Rajamani\.vscode\extensions\halcyontechltd.code-for-ibmi-3.0.13\dist\extension.js:2:1123542)
at Generator.throw ()
at s (C:\...\.vscode\extensions\halcyontechltd.code-for-ibmi-3.0.13\dist\extension.js:2:1096301)
at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
**Expected behavior**
**Screenshots**
**Environment (please complete the following information):**
- Extension version [e.g. 0.x.x]
- IBM i OS version [e.g. 7.5]
**Additional context**
JDE source file structure as below:
Field Field
Text Name Type Length Dec Loc
Sequence Number. . . . . AGSEQ S 6 2 1
Source Date. . . . . . . AGSDT S 6 0 7
Data Source. . . . . . . AGSRC A 80 13
Primary Logic Module . . AGPKEY A 10 93
Source Sub Key . . . . . AGSKEY A 10 103
Source Serial Number . . AGSRCS A 12 113
User Id. . . . . . . . . AGUSER A 10 125
Sar Number . . . . . . . AGMSAR A 8 135
Contributor guide
Research direction
Reproduce with a JDE World source PF on IBM i and inspect the extension.js stack location shown in the report, then trace the member-opening path that expects SRCDTA against the listed AG* fields. Done means the JDE World member opens without the SQL0206 error while standard source members continue to open.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript, vscode
- Domain
- devtools
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100