Not getting Source Files in Object Browser When library using a schema with a long schema name.

[SurroundLeePaul]

I'm fairly new to VS Code for IBM i. Moving over from RDi.
I cannot see any of my source file objects in Libraries that have been converted to Long Schema names. For example, our LPFRTBIL Library is
has a quoted Schema name of "LPT_FreightBill".

I narrowed it down to the CREATE TABLE command is using WHERE t.table_schema = 'LPFRTBIL'. I believe it should be using t.system_table_schema.

[worksofliam]

@SurroundLeePaul Are you able to give us the steps to recreate this issue? Specifically how you did this part?

converted to Long Schema names

[worksofliam]

I meant the select from your initial screenshot :D

[SurroundLeePaul]

that's not my SQL. IT is the SQL in the VS Code for IBM i solution.

[chrjorgensen]

@SurroundLeePaul I see your point - and you're right, we should use the system name columns instead of the SQL ones, since we display these values in the Object Browser tree. I'm working on a fix for this issue, stay tuned.

We've not encountered a situation like this before - I guess (almost) all users have libraries created by the CRTLIB command instead of SQL schemas (with long names).

[chrjorgensen]

@SurroundLeePaul We have just published a new release 2.13.6 containing a fix for your problem - please give it a spin and report back. 🙏

[SurroundLeePaul]

@chrjorgensen, Works great now. Thank you!