Use SQL views to transfer packed data using FTP

A standard logical file cannot convert numeric data to character, either. But a view can use the CHAR function to convert any numeric data to left-justified values that have the sign and the decimal point.

To test this idea, take the following steps:

1. Create a PF with a single packed 5,0 field.

2. Create an LF that makes the packed field look like a zoned field.

3. Create a view over the PF that converts the packed field to character.

create view somelib/charview (pckfld) as select char(pckfld) from packedpf

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT iSeries programmer tips Groovy programming on IBM i EGL Rich UI on IBM i: Do you Dojo? Running PHP open source applications: NOBODY needs authority Programming for the Web on the IBM i, what is possible Using geocoding on AS/400 to enhance your Web presence The best technologies and tools for System i programmers in 2009 Seven IBM i project lessons learned in 2008 Documenting nested program structures on the AS/400 What is an integrated database? An automated CL method of moving a query from AS/400 to Excel FTP Simplify the process of converting a spool file from iSeries into an Excel spreadsheet Generically send a text file from the IFS via FTP Automate Client Access to find files on Windows scheduler SAVF by FTP on AS/400 -- error "source file not found" Use a virtual directory to move a .bmp file from the IFS to a remote server to run a software package Transferring binary files to IFS from a PC via FTP FTP from AS/400 to PC folder How to FTP without knowing the file name IFS folder error Creating the correct member type in a source physical file via FTP

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

4. Add some data, both positive and negative - I used 5 and -4.

5. Start an FTP session from Windows, using ASCII mode.

6. Executing "get packedpf packedpf.txt" results in the usual garbage.

7. Executing "get zonedpf zonedpf.txt" gets closer but no decimal point, and the sign is obscured.

00500
0040}

8. Executing "get charview charview.txt" gives almost a useful result.

5.00
-4.00

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Visit the ITKnowledge Exchange and get answers to your developing questions fast.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.