I Cookies vengono usati per fornirti un servizio migliore. Proseguendo con la navigazione, acconsenti al loro utilizzo. Per negare il consenso o eliminarli dal tuo browser visita www.aboutcookies.org. Per maggiori informazioni leggi l'informativa.

Prosegui
BlogFaq400BlogFaq400
Menu
  • Home
  • About
  • Contatti
  • Faq400
  • Italiano
  • English

Browsing category

02c – Miscellanea DB2 for i (EN)

6 posts
02 - DB2 for i (EN)02a - SQL (EN)02c - Miscellanea DB2 for i (EN)

Smarter SQL functions with control statements

1 December 2019
02 - DB2 for i (EN)02a - SQL (EN)02c - Miscellanea DB2 for i (EN)

Utility XSQL :"Compile" SQL objects into desired library - Part.2

3 November 2019
In the first “episode” of this article we learned how to create into a specified library an object built from an SQL script. Here we present a free tool that allows you to run SQL scripts with embedded variables !
Read more
02 - DB2 for i (EN)02a - SQL (EN)02c - Miscellanea DB2 for i (EN)

"Compile" SQL objects into desired library - 1

20 October 2019
In SQL scripts for DDL-defined objects (tables, views, indexes, etc.) it is not good to explicitly specify library names. We provide here a small utility command that allows to “compile” all the objects defined with SQL script specifying the destination library.
Read more
01e - Programming miscellanea (EN)02a - SQL (EN)02c - Miscellanea DB2 for i (EN)

Reading spool files with SQL

13 October 2019
To read the contents of a spool file you can make a program that runs the CPYSPLF command and then reads the output file. But why write a program when SQL can do all the work?
Read more
02a - SQL (EN)02c - Miscellanea DB2 for i (EN)

SQL: How many rows in my select statement?

30 September 2019
Sometimes we need to know in advance how many records will be fetched from an SQL query. SQL already knows everything … let’s see how to do it !
Read more
02 - DB2 for i (EN)02c - Miscellanea DB2 for i (EN)04g - System Admin miscellanea

RTVDSKINF / PRTDSKINF Goodbye!

30 September 2019
Let’s summarize the operation of these two commands: RTVDSKINF is the command that collects information relating to the disk space occupied by objects, libraries, … Once launched, it is necessary to wait a while to…
Read more
  • Topics

    01 - Programming (EN)1301a - RPG (EN)301d - Rational RDi and other tools (EN)301e - Programming miscellanea (EN)702 - DB2 for i (EN)1002a - SQL (EN)1202c - Miscellanea DB2 for i (EN)603 - Open Source (EN)303d - Phython (EN)203e - Ruby on Rails (EN)104 - System Administration (EN)1104a - Access Client Solution / Client Access (EN)104d - IFS (EN)204f - Security104g - System Admin miscellanea705 - Web Services (EN)305a - IBM i Web Services miscellanea306 - Miscellanea (EN)106a - Training and Books106b - News1Poll (EN)1
  • Newsletter subscription

  • Sede Legale:
    Via Manzoni 37 | 20900 Monza (MB)

    Email:
    info@faq400.com

     Telefono:
    +39 02 83595380

    Social:

©Copyright © 2019 Faq400 srl - P.IVA e C.F. 09866120968 - Privacy Policy - Cookie Policy