News

You are here:

Home
News
Pagina 32

SQL Services contro le API

News & Other15/01/2016

Possiamo fare a meno delle API di IBMi e utlizzare i servizi DB2 for i ?

Così ci dicono Susan Gantner e Jon Paris nel loro articolo

Replacing API Calls With DB2 for i Services

Negli ultimi aggiornamenti della 7.1 e 7.2 IBM continua a regalarci nuovi DB2 for i Services assolutamente interessanti …

Vediamo qualche esempio che prima di questi servizi che ci permettono di ottenere informazioni di sistema senza ricorrere all’uso della API che non è mai stato molto semplice :

Dettagli

Searching for strings in source files (not only ’25’ PDM option)

RPG & SQL Coding10/01/2016

Only few days from Christmas “Santa” Simon Hutchinson bring us some gifts … two ways to search strings in source files:

… using CLP and SQL

http://www.rpgpgm.com/2015/12/searching-for-strings-in-source-files.html

… using RPG and SQL

http://www.rpgpgm.com/2015/12/searching-for-strings-in-source-files_30.html

Dettagli

Eval-Corr … what is this ? I found it reading an italian forum where great Mr. Obelix suggest this operation code to solve ad problem with DS (see original message at http://it.comp.as400.narkive.com/Dx0ArfSk/campi-numerici-contenenti-blanks).

Googling for Eval-Corr I learn something new:

IBM manual says:

The EVAL-CORR operation assigns data and null-indicators from the corresponding subfields of the source data structure to the subfields of the target data structure. The subfields that are assigned are the subfields that have the same name and compatible data type in both data structures. For example, if data structure DS1 has character subfields A, B, and C, and data structure DS2 has character subfields B, C, and D, statement
EVAL-CORR DS1 = DS2
will assign data from subfields DS2.B and DS2.C to DS1.B and DS1.C

Dettagli

Manage User Profiles and Authorizations

System Administration10/01/2016

Default passwords, *ALLOBJ auth spread to generic users and so on … I lot of IBM i system administrators don’t bother about system security … Take a look at this old post from SecureMyi.com

Security Toolbox Essentials for Managing User Profiles

Some reports, tricks and information about System Security.

SQL Scalar Functions POSSTR, LOCATE, LOCATE_IN_STRING

Featured, News & Other, RPG & SQL Coding10/01/2016

I this post we will take a look to some SQL Scalar Functions (DB2 SQL for i) … let’s get started with a temporary table and some example data …

Dettagli

SQL Funzioni Scalar Functions POSSTR, LOCATE, LOCATE_IN_STRING

News & Other08/01/2016

In questo post vediamo di fare un po’ di chiarezza su alcune Scalar Functions di SQL del DB2 for i, creiamo prima una tabella d’esempio per capire meglio:

Dettagli

Gestione Utenti (User Profiles) e autorizzazioni

News & Other07/01/2016

La sicurezza di un sistema informatico spesso “fa acqua” anche sulle semplici impostazioni di utenti e password … in questo vecchio articolo su SecureMyi trovate una serie di consigli validi ancora oggi, sono sicuro che eseguendo i comandi proposti nell’articolo ne scoprirete delle belle … Security Toolbox Essentials for Managing User Profiles I consigli…

Dettagli

Eval-Corr valorizzare parzialmente una DS

News & Other01/01/2016

Veniamo all’operation code Eval-Corr:

Il manuale IBM dice:

The EVAL-CORR operation assigns data and null-indicators from the corresponding subfields of the source data structure to the subfields of the target data structure. The subfields that are assigned are the subfields that have the same name and compatible data type in both data structures. For example, if data structure DS1 has character subfields A, B, and C, and data structure DS2 has character subfields B, C, and D, statement
EVAL-CORR DS1 = DS2
will assign data from subfields DS2.B and DS2.C to DS1.B and DS1.C

Dettagli

All About .. CL

News & Other01/01/2016

All About … CL programming Submit Job passing packed decimals Name Notes Date RPGPGM.COM Submit Job passing packed decimals How to handle packed variables in CLP and something about Data Structures DS in CLP 10/02/2016 RPGPGM.COM Retrieving the program’s name in a CL program RPGPGM.COM – From AS400 to IBM i 13/01/2016 RPGPGM.COM Trim in…

Dettagli

All About … RDI

News & Other01/01/2016

A collection of posts for … RDi

Dettagli

News

Faq400.com Cookies Policy