easycobcoder README

Easy Cob Coder is an extention which simplifies some commonly required steps that we otherwise do manually.

Features

Input Section
- Must open Git checkout directory via File > Open Folder in VS Code to enable plugin features.
- Auto-detects the current git branch and derives Prod Branch (e.g., V22-TRUNK) and Version ID (e.g., V22).
- Lets you pick a Workarea (folders like _wa_*).
- Reads *.INI in the selected workarea to discover LPCONNSTRING and populate DB / Server for SQL deploy.
- Workarea Section buttons:
  - Before using the buttons below, run wa_ini <client_name> in the terminal to set up the environment for your client.
  - Clean: runs wa_clean.bat for the detected Prod Branch folder.
  - Copy: runs wa_copy.bat <ProdBranch> from the Prod Branch folder.
  - Launch: runs LPSTART.BAT <workarea ini> (prefers env.ini, otherwise first *.ini in the workarea).
COB Build
- Shows modified .COB files, plus optional extra entries from CompileList.txt in the selected workarea.
- Builds selected COB modules using the configured Jenkins batch, in parallel, with detailed logs in the EasyCobCoder Build output.
SQL Deploy
- Shows modified .SQL files, plus optional extra entries from SqlDeploy.txt in the selected workarea.
- Deploys selected SQL scripts using sqlcmd to the selected Server/DB.
- Applies SQL ordering rules based on filename prefixes and skips excluded prefixes.
- Deploy button is disabled until Workarea + DB are selected.
Vconvert (CORPDBGN)
- Run CORPDBGN utility to auto-generate PRDB and SQL scripts from .GEN configuration files.
- Enter a Table ID and click the run button to execute wa_corpdbgn.bat.
- Automatically maps Version ID (e.g., V22) to numeric version codes (e.g., 12200).
- After completion, the SQL files list is refreshed to include newly generated files.
- Requires a Workarea to be selected in the Input Section.

Windows Key Shortcut	Mac Key Shortcut	Description
Ctrl+Shift+alt+k	Shift+Option+Cmd+k	Tag line(s) with current date
Ctrl+Shift+alt+i	Shift+Option+Cmd+i	Specify and Save Tag to use
Ctrl+Shift+alt+s	Shift+Option+Cmd+s	Tag line(s) with saved date
Ctrl+Shift+alt+r	Shift+Option+Cmd+r	Refresh file lists (COB/SQL + CompileList/SqlDeploy)
Ctrl+Shift+alt+a	Shift+Option+Cmd+a	Add current open `.COB` to `CompileList.txt` OR `.SQL` to `SqlDeploy.txt`

Requirements

Extension designed for Cobol code only, if you are not a cobol developer might not help you much.

Git must be available (used for branch detection and modified file lists).
COB build requires access to the configured Jenkins batch path.
SQL deploy requires sqlcmd installed and available on PATH.
One-time setup: Run the following PowerShell command to allow script execution:
```
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser
```
Environment Path: Add \\vc03-b21-fs02\UTILITY\Bat to your system's PATH environment variable.

Extension Settings

This extension contributes the following settings:

Build

easycobcoder.build.batchPath: Path to the Cobol compile batch file.
easycobcoder.build.lpreleaseBase: Base UNC path used to build the reference EXEC path.
easycobcoder.build.prodBranchFolder: Optional override (e.g., V22-TRUNK). If empty, auto-detect is used.
easycobcoder.build.sourceSubdir: Source folder under the prod branch folder (default SRC-COB).
easycobcoder.build.flags: Numeric flags passed to the batch after the job number.
easycobcoder.build.compilerVersion: Compiler/runtime version string (example V8.0).
easycobcoder.build.maxParallel: Max parallel module builds.

SQL

easycobcoder.sql.useTrustedConnection: Uses Windows Integrated auth (-E) when true.
easycobcoder.sql.username / easycobcoder.sql.password: SQL auth when not using trusted connection.
easycobcoder.sql.namingConvention: Inline ordering/exclusion rules by filename prefix.
easycobcoder.sql.batchSeparator: Batch separator used by sqlcmd (default ;).

Workarea

easycobcoder.workarea.cleanBatPath: Path to wa_clean.bat.
easycobcoder.workarea.copyBatPath: Path to wa_copy.bat.
easycobcoder.workarea.launchBat: Launch command/batch (default LPSTART.BAT).

Known Issues

No issues known yet. Pre-Release.

Release Notes

2.4.0

Vconvert (CORPDBGN): Added support for running CORPDBGN utility to auto-generate PRDB and SQL scripts from .GEN configuration files.
Auto-refresh SQL files list after CORPDBGN completion.
Updated requirements: PowerShell execution policy setup and PATH environment variable configuration.

2.0.0

Initial release with:

Tag line(s) with current or saved date
Input Section with auto-detection of Git branch, Prod Branch, and Version ID
Workarea buttons: Clean, Copy, Launch
COB Build with parallel module builds
SQL Deploy with ordering rules

1.0.0

Initial Release, commenting functionality

Enjoy!

EasyCobCoder

Siddharth Goel