ISeries Data Transfer

Empty/Null value field gets downloaded as Junk value when data is captured into Oracle from iseries

When no value has been moved into a particular field in a database, then the field contains Junk value. This by itself does not cause any problem in terms of the working of the application on i series. But when the MIS team tries to download the data into Oracle, then if the file being downloaded...

ISeries Data Transfer VS CPYTOIMPF

When transfering data from the AS400 to a PC as a text file using the iSeries transfer, the numeric values are right justified and this is what I need. I am trying to setup a CL that will do this with out any user interaction. But whenever I try to do this on the AS400 using CPYTOIMPF or CPYTOSTMF...

SQL Data Types Conversions

I'm new to SQL. Anyone have a good example or link of converting from one data type to another. We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or "numeric" data types. Our iSeries ERP...

How to transfer tab delimited text file to As400

How can I transfer a tab delimited text file to AS400 and retaining the delimiter to identify fields? Thanks, Alex Bernardo