Frederic Clement

A father of 3 kids playing with SQL, DBE on #db2fori #ibmi

[Frederic Clement @freddotclem]

Finally took the time to set up @liquibase. The extension may need a lifting because #db2fori is neither z/os nor LUW, but it seems to work! https://t.co/niumGAeUg2 #IBMIOSS

[Frederic Clement @freddotclem]

#db2fori. Has any one experience with a #SSDT (my first love :) ), @FlywayDb or @liquibase -like solution on #IBMi? I know it is not out of reach. This is the next step on my journey to database DevOps.

[Frederic Clement @freddotclem]

Overthinking it in #sql
... WHERE coalesce(MaybeNull, 'haha') = 'haha'

[Frederic Clement @freddotclem]

- Grant on procedure...
- OK

- ... with Linked Server references
- ..wait... Hell no!

[Frederic Clement @freddotclem]

@notesofbarry Nice review!
Do you see the product as something that would also help the DBE? It seems more application oriented.

[Liam barry @notesofbarry]

Also I released the Db2 for i extension in preview today! feel free to give it a go & share some feedback https://t.co/YMQKxx9O0R

[Frederic Clement @freddotclem]

Not so long ago, I had my code dismissed because it used #SQL and "Not everybody knows it in the company"... and now I hear it is still a thing in 2022 even on the #ibmi.

[Frederic Clement @freddotclem]

@pranavkul @craigmullins @IDUGDb2 @db2community The MERGE ... WHEN MATCHED ... DELETE ?
https://t.co/nZUIuqaGOW

[Frederic Clement @freddotclem]

values (
try_cast(1=1 as int),
try_cast(1=0 as char(10)),
try_cast(1=cast(NULL as int) as char(10)),
try_cast(cast(NULL as int) as char(10)),
try_cast('NoInt' as int)
);
1-Logical expression are values - fun
2-TRY_CAST and NULL result ;)
Happy #ibmi 7.5 release to all of you!

[Frederic Clement @freddotclem]

@mgeise @liquibase So on the point 🤣.
But it tells more about myself, not being a Java dev.
I had to clone the rep for a quickfix and try to compile with maven (first ever install) with a series of trial and error.
The github/workflow files did help.

[Frederic Clement @freddotclem]

Finally took the time to set up @liquibase. The extension may need a lifting because #db2fori is neither z/os nor LUW, but it seems to work! https://t.co/niumGAeUg2 #IBMIOSS

[Frederic Clement @freddotclem]

#db2fori. Has any one experience with a #SSDT (my first love :) ), @FlywayDb or @liquibase -like solution on #IBMi? I know it is not out of reach. This is the next step on my journey to database DevOps.

[Frederic Clement @freddotclem]

@ChrJorgensen @JanssonSven Sounds like DB2 Multisystem comming at no extra cost is good news for you. Or did you used an other product?

[Frederic Clement @freddotclem]

@AlexanderStix The restriction is documented.
https://t.co/dpqkasG6tf.
IS DISTINCT FROM limits us to equi-join... but yeah, there's always way to reformulate the statement for available synthax... it was just an "Idea".

[Frederic Clement @freddotclem]

First RFE ... hum, I meant Idea #db2fori
https://t.co/RFvLGoyAhV !

[Frederic Clement @freddotclem]

@dbeaver_news ... until the "Aargh ... I should have saved it as a file".

[Frederic Clement @freddotclem]

@notesofbarry ... a new "Idea"? So bad it is not covered in the catalog :(

[Frederic Clement @freddotclem]

go listen the last https://t.co/p1rpN3xDc0.
Among other, a friendly reminder from @MarinaSchwenk26 at @IncredibleIBMi: "Don't hardcode".

[Liam barry @notesofbarry]

For the time being, I will be going into PR-review-only mode for Code for #ibmi https://t.co/d8RYOEbjvA

[Frederic Clement @freddotclem]

@notesofbarry Okay... it was a version for people not wanting to read all the material provided yesterday. The emphasis was more on security and new Nav.

With all these new sysadmin db2/ibmi services... you really want to block sql injection and *ALLOBJ user rights.

[Frederic Clement @freddotclem]

https://t.co/8IDzAX6suu
Let's watch!

[Frederic Clement @freddotclem]

@ChrJorgensen @notesofbarry And I was wondering how ISVs with their heavy Eclipse plugins would deal with more vscode... ninja move!

[Frederic Clement @freddotclem]

Going through the #ibmi 7.5 anouncement related to #db2fori.

As a DBE, TRY_CAST, boolean operators and Multiversion DB2 Mirror are making my top 3 for now.

Merlin is... an unexpected move considering the work from @notesofbarry on vs-code.