1
  • Running a data transfer from a CL program

    Is it possible to run a data transfer from a CL program? I can create a DTF file but how would you code a CL program to run it?

    Banjo20 pointsBadges:
  • Download from iSeries to PC (TAB delimited text)

    Hi, 1.  I would like to download a file from AS/400 to PC as a TAB delimited text.  However, I realised number decimal appears as '20000.' where it should be '20000.00'.  Is there somewhere to define the format during data transfer ? 2.  Can a delimitter be changed to '|' instead of TAB ?  ...

    Shir5 pointsBadges:
  • transfer problem on iseries

    How do I transfer up a record upto 500 long and not have it wrap on the AS400 ? It will only handle 300

    travisthip15 pointsBadges:
  • Upload Excel file from PC to iseries

    I need to Upload an excel file with (.xls format) from PC to iseries. So I have changed to CSV format . I have created a folder in QDLS folder and i have placed the excel to QDLS folder using iseries navigator. So using following command i have copied all the records to Physical file.Its working...

    22917515 pointsBadges:
  • Client Access file transfer TO AS/400

    Hi Gang, I have and end user who indicates nothing has changed...famous last words. A file transfer was set up by a former IT person on the endusers PC That transfered a TXT file from her PC to the aAS400 but now when she tries to transfer the data to the iseries....she is getting CWBTF0023(???) I...

    Rmason345 pointsBadges:
  • Transferring from V4R5 to V6

    we need to transfer all the lib's,obj's, everthing from v4 to v6 now? which is the best method to do it? i'm expecting guidence through FTP method?

    Rajasekhar151,395 pointsBadges:
  • Data Transfer Field Description Names

    On the data transfer box you can choose the data options button which you can then go to details button. In choosing that button you get to the Receive Requested Details box. My questions is how do I change the Field Description name to what I need it to be when the file is downloaded.

    Cyd40 pointsBadges:
  • Disable BROWSE button from data transfer from iSeries server?

    Hi recently i discovered that my data transfer from iseries server aplication does not apply the object authority that i have in place so, all of my users can browse and download objects that they arent supposed to. My question would be if theres any way to disable the browse button on the...

    queque5 pointsBadges:
  • Append extra zero on the numeric field using Data Transfer Excel Add-in

    My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version). The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data...

    Mingwong30 pointsBadges:
  • Automatic Data transfers from iseries

    I am quite ok with manual data transfers and menu options calling transfers, but does anyone know how to get a data transfer set up from the iseries to a mapped drive on our server to run automatically, e.g. at 04:30 am ? Also, is it possible to send data from the iseries to a server that is not on...

    KasMcc230 pointsBadges:
  • Upload Spreadsheet to AS400 using Excel addin – creates graphic fields for alpha fields

    I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is 'Graphic' when I display the file field definitions.  I cannot read these fields in my RPG program - they are only text...

    PaulClemens25 pointsBadges:
  • 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...

    JohnsonMumbai1,160 pointsBadges:
  • Data transfer .XLS to iSeries

    It's worked the last 4 tries (tho had to tweak each time), but now I just get basically one long field coming in. The comma delimitors are treated as just another character byte. While setting up a "power user" to take over this function (so no .fdf or other residuals from prior successful...

    aceofdelts1,950 pointsBadges:
  • 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...

    StreetD35 pointsBadges:
  • File Transfer to iSeries from Excel 2007

    I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

    Badkarma40 pointsBadges:
  • 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 solution...

    MikeBaker5 pointsBadges:
  • 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

    DHLSameday185 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following