The Run SQL Scripts function, a.k.a. the SQL Script Center or Script Center, allows the user to execute all or a subset of a script that contains one or more SQL statements and/or batch CL commands. It is part of the Navigator Database function and is an extremely powerful and flexible tool with lots of function that can have a very positive impact on application developer productivity.

One of these functions is Visual Explain, which is used to investigate and improve the performance of SQL statements. Visual Explain creates a query graph or diagram that graphically displays the execution of

A colleague and I were recently tracking the way data progresses through a poorly documented information system. We were trying to determine at which point in the process a certain field’s decimal positions were being discarded. We began at the beginning, which happened to be a CSV file from a PC-based system. How could we quickly determine whether or not the CSV file had values in the decimal positions of the seventh field?

We used SQL. I’ll provide a simple illustration. Here are the commands, in case you want to try this yourself.

Let’s first create a CSV file we

I tried running the attached FTP script to automatically transfer AS/400 Integrated File System (AS/400 IFS) files to a Windows server, but I can’t get it to work. I can run my transfer commands manually but not automatically. Can you tell me what I’m doing wrong?

–Dave

Thanks, Dave. I’ll give it a shot. Here’s the FTP script that you sent me.

OPEN system_name
USERNAME
PASSWORD
CD /ifs_directory_name
LCD C:directory_name
MGET *.*
QUIT

Here’s the Windows FTP command that you’re using to run the script.

ftp -s:getfile.scr system_name

Once you run the command, you get the following FTP error:

>