• Windows Scheduling iSeries Data Transfer

    I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...

    Heather4000 pointsBadges:
  • Conversion Project

    We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....

    ITnavan0 pointsBadges:
  • OLE DB using Library List

    Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice... Thank you

    TG50 pointsBadges:
  • Cannot end RGZPFM on V5R4 (Journaled file)

    Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can...

    AS400DBA15 pointsBadges:
  • bi-directional data synchronization on System i for db2 databases

    I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?

    Aroyzen15 pointsBadges:
  • Merging of files in AS400

    What is the use of merging files in AS400? How do you do this?

    0 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • Client Access Data Transfer

    I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to a...

    Joe9250610 pointsBadges:
  • Optimizing/Indexing to find last transaction

    I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...

    MODMOD0 pointsBadges:
  • Problems eliminating HEX 41 character.

    I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...

    Selectsoft65 pointsBadges:
  • AS400 disk initialize info

    Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...

    Jf79210 pointsBadges:
  • Comparing 2 files .CSV and getting the missing data using AS400.

    I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

    0 pointsBadges:
  • FTP from iSeries DB2 to iSeries AIX (Oracle)

    I'm taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode...

    Dlanor20 pointsBadges:
  • SQL RRN Processing – by Key?

    I'm putting together a job that needs to process a large masterfile in a very short period of time. To do this, I'm (sorta) cloning an existing SQLRPGLE application that runs multiple concurrent copies of a program...each processing a range of the file by RRN. The number of copies is dynamic, set...

    ChuckM0 pointsBadges:
  • AS400 intreface with other platforms

    Can anybody tell me how to interface As/400 with other platforms say windows or linux for example

    Cute98862892710 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • Is it possible to reorganize a very big transaction in one night?

    I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

    Cookiekitty110 pointsBadges:
  • Commit utilization in SQL stored procedures

    I need an explample of an SQL stored procedure running in an DB2 environment that uses commitment control. I don't want use RPG. I would like to call it from QSQLSRC via LXISCH (AS400 scheduler) and update over 100,000 records in 20,000 row increments. Any Suggestions? Thanks!

    Whitera0 pointsBadges:
  • SYNON vs COBOL

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

    Rituraj0 pointsBadges:
  • Optical storage

    I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...

    Rick1020060 pointsBadges:

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