Look at this post on StackOverflowSQL Generate list of dates between two dates
How can we generate a list of sequential day from two given dates ?
II got ideas reading some posts on StackOverflow .. in particular at a MichaelTiefenbacher answer …
SQL Generare una lista di date … tra due date
Mi rendo conto che dal titolo non è proprio così chiaro quello che voglio dire … vorrei generare una lista di date successive partendo da una data fino ad un’altra definita … ad esempio tutte le date della settimana dal 22/02/2016 al 28/02/2016. Ho preso spunto da una discussione su StackOverflow .. che vi invito a tenere…
Dettagli
Fill data in a GoogleDocs SpreadSheet from IBMi via Rest WebService
Now, with 7.1 and 7.2 with some PTF prerequisite (Building a REST service with integrated web services server for IBM i: Part 1), we can expose our RPG programs and service programs as Rest Web Service ….and this open a world of possibilities.
In this post I try to fill a Google Docs Spreadsheet with a RPG Service Program via a Rest Web Service.
Can you imagine ? Write your Budget or an Order or a Price List or something else in a GDocs Spreadsheet and upload data directly to your tables/files on IBMi … or fill your Spreadsheet with an RPG program.
Read more to see step by step process..
DettagliFour Hundred Guru – Parsing Delimited Text Data Natively in SQL
Absolutely not to be missed this two posts by Michael Sansoterra at IT Jungle Four Hundred Guru, Parsing Delimited Text Data Natively in SQL, Part 1 Parsing Delimited Text Data Natively In SQL, Part 2: Java To The Rescue We can learn how to use UDTF SQL Function to read a CSV file from IFS, store…
DettagliFour Hundred Guru – Parsing Delimited Text Data Natively in SQL
Assolutamente da non perdere questi due post di Michael Sansoterra su IT Jungle Four Hundred Guru, Parsing Delimited Text Data Natively in SQL, Part 1 Parsing Delimited Text Data Natively In SQL, Part 2: Java To The Rescue dove possiamo vedere come leggere e fare il parsing ad esempio di un CSV direttamente da SQL tramite…
DettagliRPGPGM.COM Submit Job passing packed decimals
RPGPGM.COM Submit Job passing packed decimals Another good post by Simon Hutchinson about handle packed decimal variabiles and parameters in CLP code … Pay attention also at DS Data Structures in CLP.
RPGPGM.COM Submit Job passing packed decimals
RPGPGM.COM Submit Job passing packed decimals Another good post by Simon Hutchinson about handle packed decimal variabiles and parameters in CLP code … Pay attention also at DS Data Structures in CLP.
How to remove strange Hex Char in SQL
Getting text data from PC or other systems we often figth with strange hex char and we may have some problems viewing that on 5250 screen or printing on paper.
Here’s a good trick stolen from a Jim_it’s comment on Code400.com : Replace the ellipsis character in text string
DettagliCome pulire una stringa dagli Hexadecimal Char con SQL
Recuperando dati da PC o altri sistemi capita spesso di ritrovarsi dei caratteri strani nei testi che creano problemi in stampa e in presentazione 5250 ….
Questo metodo suggerito su Code400.com : Replace the ellipsis character in text string da Jim_IT utilizza SQL ed è molto semplice:
Dettagli