Converting IBM i Physical Files to SQL Tables

preview_player
Показать описание
It's time to grab some old AS400 Physical Files and drag them kicking and screaming into the IBM i SQL Age...
  1. Nick Litten
  2. Nick Litten
  3. Litten
Рекомендации по теме
Converting IBM i 0:09:31

Converting IBM i Physical Files to SQL Tables

Coding in RPG 0:07:09

Coding in RPG (IBM i/AS400). Converting Physical Files to SQL Tables.

Physical and Logical 0:03:28

Physical and Logical Files | IBM i | AS400 | iSeries

[004] IBM i 0:27:30

[004] IBM i (AS/400): Import CSV file into physical file

AS400 / IBM 0:15:01

AS400 / IBM i Tutorial - Chapter 20 - File operations in RPG programming

Coding in RPG 0:17:15

Coding in RPG (IBM i/AS400). Converting file operations in RPG to embedded SQL operations in RPG.

Coding in RPG 0:11:57

Coding in RPG (IBM i/AS400). Using SQL Objects with Native RPG file operations.

IBM i, AS400 0:20:11

IBM i, AS400 Tutorial, iSeries, System i -CVTDAT command | Convert date - any format to any format

Workshop Let's 0:12:22

Workshop Let's create an IBM i Logical File

REUSEDLT Attribute - 0:15:53

REUSEDLT Attribute - Reusing deleted records for IBM i database files

Coding in RPG 0:12:53

Coding in RPG (IBM i/AS400). Converting Logical Files to SQL Indexes or Views

IBM i, AS400 0:10:40

IBM i, AS400 Tutorial, iSeries, System i-Read all source member of source PF in RPG-override-writePF

Download and Upload 0:17:14

Download and Upload data between IBM i and PC | Data Transfer and Database files having CCSID 65535

Using Externally Described 0:22:08

Using Externally Described Printer File in RPGLE in IBM i (AS400)

Subscriber IBM i 0:14:11

Subscriber IBM i DDS to SQL Conversion #QandA

CREATE TABLE vs 0:15:19

CREATE TABLE vs CRTPF in IBM i (AS400) || DDS PF to DDL Table conversion in IBM i (AS400)

Converting DDS to 0:14:50

Converting DDS to DDL results in format level identifier changed in IBM i (AS400) and How to avoid

IBM i, AS400 0:09:03

IBM i, AS400 Tutorial, iSeries, System i -DDS to DDL with generate_SQL procedure and generate srcmbr

What is the 0:12:52

What is the use of SFLNXTCHG keyword in sub file | IBM i | yusy4code

IBM i, AS400 0:13:14

IBM i, AS400 Tutorial, iSeries, System i -Read source member in SRC PF in RPG & write source to ...

Coding in RPG 0:12:26

Coding in RPG (IBM i/AS400). Creating IFS files using RPG and SQL

IBM i, AS400 0:38:30

IBM i, AS400 Tutorial, iSeries, System i - Load All subfile | Code subfile enquiry screen in RPG

Email an IBM 0:01:57

Email an IBM i File as a CSV INTRO

IBM i, AS400 0:24:04

IBM i, AS400 Tutorial, iSeries, System i -Read any 2 members out of 3(any) of a file in RPG program

Комментарии
Автор

To clarify: when at 1:50 you say that converting from physical file to SQL table the performance for accessing it from a RPG program, for example, are improved you mean that the program is left unmodified, right? That is, the SQL table is accessed with usual RPG logic, one record at the time, isn't it?
What if the RPG logic also is convert into SQL (I mean pure set-based), for example into a view or a stored procedure? Is there another performance improvement? I guess so, but direct experience is better than guessing.

s.b.
Автор

Thanks a lot Nick for sharing your knowledge to the world. It is indeed very insightful. I was wondering if you would share some knowledge/tool on how to automate file transfer from windows to ibm i IFS. Wanted to know how to avoid user intervention and automate the whole process. Thanks!

mxxt
Автор

Your video is very interesting but
How could you keep the same level identifier in the new table?
Thank you so much

TheRafagomez