Switching to SQL File Definitions from DDS

Switching to SQL File Definitions from DDS

SQL iQuery for IBM i

with

Bob Cozzi

bob@ Twitter: @bobcozzi

? 2017 Cozzi Productions, Inc.

iQ



Transforming Db2 into Excel, JSON & more with SQL

Download this Presentation

iQ



Transforming Db2 into Excel and JSON using SQL

SQL iQuery

Powerful Database Query and SQL Scripting for IBM i

? Cozzi Productions, Inc.

? Web or Command Line SQL processor

? Powerful Scripting Tool "SiLQ" Supports IBM i DB2 SQL

? Run any SQL command

? Send SQL SELECT results to your choice of output formats

? CSV, Sylk, JSON, Excel, XML, PDF, Print, Display, etc.

iQ



Transforming Db2 into Excel and JSON using SQL

SQL iQuery

SQL Processing and Scripting for IBM i

Your Data

Your Data with SQL iQuery

{JSON}

TXT

CSV

,

*Write One and Done!

? 2016 Cozzi Productions, Inc.

Results are blah

iQ



Transforming Db2 into Excel and JSON using SQL

Classic IBM i DDS File Definition

ReCcoolurdmFnor(FmiealtdN) Namame es Column Headings and Text

Primary Key Fields

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download