Re: [EXTERNAL] Liam Alan on using VS Code for COBOL (and RPG and CL)

On Aug 10, 2022, at 10:12 AM, Kelly Cookson via COBOL400-L <cobol400-l@xxxxxxxxxxxxxxxxxx> wrote:

When I modify a source member using Code for IBMi in VS Code, and save the source member, the dates get zeroed out. So something besides a simple install of the IBMi Development Pack (which contains Code for IBMi) is needed--at least it is for me.

I found the page where Liam helped someone fix this issue, but Liam told the person he needed db2util installed. Again, I posted the link to the page where Liam helped someone get this resolved earlier.

I'm working on it now. I've asked our IBMi admins to get db2util installed.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486 ext. 12676
www.dotfoods.com


-----Original Message-----
From: COBOL400-L <cobol400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Wednesday, August 10, 2022 8:23 AM
To: COBOL Programming on the IBM i (AS/400 and iSeries) <cobol400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [COBOL400-L] [EXTERNAL] Liam Alan on using VS Code for COBOL (and RPG and CL)

I have no clue what db2Util does for you - I do not have it installed and use SQL with no issues.

As to dates: https://urldefense.com/v3/__https://halcyon-tech.github.io/vscode-ibmi/*/pages/settings/connection?id=enable-source-dates__;Iw!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrZ9yS2Nm$ <https://urldefense.com/v3/__https://halcyon-tech.github.io/vscode-ibmi/*/pages/settings/connection?id=enable-source-dates__;Iw!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrZ9yS2Nm$ >

Does this not do what you need?


Jon P.

On Aug 10, 2022, at 9:14 AM, Kelly Cookson via COBOL400-L <cobol400-l@xxxxxxxxxxxxxxxxxx> wrote:

That's what I was saying in my previous post. I need to enable SQL in VS Code and install db2util on the IBMi. Then check to see what happens with the dates. This is from the link I posted:
https://urldefense.com/v3/__https://github.com/halcyon-tech/vscode-ibm
i/issues/414__;!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW
0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyraHtuz1i$
However, on that same page, Liam said this:
"I am afraid there are no plans to show all source dates on every line, but there is a plan to make search dates searchable. The issue for that is #279."

I first need to ask our IBMi admins to install db2util. Then I need to enable SQL on my VS Code and play around with some source members (new members, existing members, members I open but do not change, etc.). If everything works in a way acceptable to my shop, then I'm good. But it's not a done deal until I can confirm it.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486 ext. 12676
http://www.dotfoods.com


-----Original Message-----
From: COBOL400-L <cobol400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jon Paris
Sent: Wednesday, August 10, 2022 7:36 AM
To: COBOL Programming on the IBM i (AS/400 and iSeries)
<cobol400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [COBOL400-L] [EXTERNAL] Liam Alan on using VS Code for
COBOL (and RPG and CL)

Have you raised it as an issue Kelly? I thought those issues were fixed a long time ago now. Unless you are editing source on the IFS in which case there is no date maintained.

Liam has very quickly fixed all of the issues I've reported.


Jon P.

On Aug 9, 2022, at 11:55 PM, Kelly Cookson via COBOL400-L <cobol400-l@xxxxxxxxxxxxxxxxxx> wrote:

I really like the IBMi Development Pack for Visual Studio Code. I apparently need to set up a couple of things to stop the source code dates from being zeroed out when the source member is saved to the IBMi.
https://urldefense.com/v3/__https://github.com/halcyon-tech/vscode-ibmi/issues/414__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZEvTUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbe4_xqXV$
Source code dates are considered important in our shop. If I can't
get things working well enough with the source code dates, then I
have to stay with RDi. :(

The COBOL extension by BitLang, which is bundled in the IBMi Development Pack, now includes the following source member file name extensions: *.cbl, *.cblle, *sqlcblle, and *cblcpy.
https://urldefense.com/v3/__https://github.com/spgennard/vscode_cobol/issues/316__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZEvTUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbckaUTqP$
The owner (spgennard) was very responsive when I made this request.

If you want syntax highlighting for SQL source code (e.g., DB2 for i SQL stored procedures), then the PL/SQL extension by Casian Ruset works relatively well for syntax highlighting. PL/SQL is Oracle's implementation of the SQL/PSM standard. SQL PL is IBM's implementation of the SQL/PSM standard. These two implementations are not the same. But the syntaxes are close enough that the syntax highlighting works fairly well for SQL PL.

I use Visual Studio Code for editing other languages: HTML, CSS, JavaScript. I will be using it for .NET development later this year or early next year. I also used it while playing around with React/JSX. I am definitely motivated to use Visual Studio Code for IBMi development--I just need to figure out how to handle the source code dates.

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
1-217-773-4486 ext. 12676
http://www.dotfoods.com

-----Original Message-----
From: COBOL400-L <cobol400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jon Paris
Sent: Tuesday, August 9, 2022 3:59 PM
To: cobol Programming on the IBM i (AS/400 and iSeries)
<cobol400-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] [COBOL400-L] Liam Alan on using VS Code for COBOL
(and RPG and CL)

Those of you who are still stuck with SEU due the price of RDi might be interested in seeing what Liam's IBM i extension can do for you. Cos you _really_ need to put SEU in your past!

--
This is the COBOL Programming on the IBM i (AS/400 and iSeries)
(COBOL400-L) mailing list To post a message email:
COBOL400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit:
https://urldefense.com/v3/__https://lists.midrange.com/mailman/listin
f
o/cobol400-l__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZE
v TUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbZiuPa_-$
or email: COBOL400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.com/v3/__https://archive.midrange.com/cobol400-l__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZEvTUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbcNARIky$ .

--
This is the COBOL Programming on the IBM i (AS/400 and iSeries)
(COBOL400-L) mailing list To post a message email:
COBOL400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit:
https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinf
o/cobol400-l__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZEv
TUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbZiuPa_-$
or email: COBOL400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/cobol400-l__;!!BZnD2a2Aqg!D4kBSohqtiYRqqbbimGMwlPxdvwLBvsmzgzuo2jZEvTUS_VpZaNP7RIGqF7zijrY-15aq8X5RM5cHsikbcNARIky$ .

--
This is the COBOL Programming on the IBM i (AS/400 and iSeries)
(COBOL400-L) mailing list To post a message email:
COBOL400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit:
https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinf
o/cobol400-l__;!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW
0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrdd-Aqrn$
or email: COBOL400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.com/v3/__https://archive.midrange.com/cobol400-l__;!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrbraaGjz$ .

--
This is the COBOL Programming on the IBM i (AS/400 and iSeries) (COBOL400-L) mailing list To post a message email: COBOL400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/cobol400-l__;!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrdd-Aqrn$
or email: COBOL400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/cobol400-l__;!!BZnD2a2Aqg!FslevyABmtWuweRm4VvRL99O1g4E73oscI6Bz6qsMW0mDnCtP7OTRPCkkjlMPT7LVpTyPYNxgJ4TB3wyrbraaGjz$ .

--
This is the COBOL Programming on the IBM i (AS/400 and iSeries) (COBOL400-L) mailing list
To post a message email: COBOL400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/cobol400-l
or email: COBOL400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/cobol400-l.