codefori / codefori/vscode-ibmi

Not able to open JDE World sources - the source file is created using JDE case tool

Closed
#3,449 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.