DB2 Universal Database

Replicating data between I-series and Ms-CRM using Scribe?

We are implementing MS-CRM on an Ms-SQL server. We need to replicate data from our business system (I-Series) to CRM, and similarly from MS-CRM to I-Series. Our Ms-CRM provider proposes using a product called Scribe to do this but has no experience of using this with I-series. Has anyone used...

User Auditing/Journaling

I'm new to security on the AS/400 (730). We need to have a record of what program a user calls through our ERP system or what objects are changed and who changed them. I've read some on journaling but not sure if that will work for what we need. Suggestions? Thanks Mark

embedded sql performance over large files

We have many applications using embedded sql statements. We are discovering that as the files grow larger the performance diminshes significantly. We have tried using dbmon to ensure indices are not being built on the fly. There are either indices or logicals for all keyed access sequences. Any...

Reading a File of unknown name, format, etc.

I need advice on reading a data file in RPG where I will only know the file name, the file format, etc. at run time. I would like to use an API or something to read the file into a buffer; I could then use the QUSLFLD API to get field definitions and parse the fields as required. I am not...

How can I split job by determine no. of records ?

I have a problem. My transaction file is about 20,000 records. This file is used as input/update file. It uses a long time when we run job in day end. I want to use less time. How can I split job to 4 job and each job run only 5000 records? How can I determine as follows ? job 1 process data...

File size for DB2/iSeries

When CREATE TABLE (PRIMARY KEY) is executed and before loading rows, the sizes related to the files are: DSPFD Data space size in bytes . . . . : 24576 Access path size . . . . . . . . : 139264 Total of member sizes . . . . . . : 163840 DSPOBJD Size . . . . . . . . . . . . . . . : 188416 ...

deal with microsoft access data base file from RPG program or clp

hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy

Synon/Cool:2E - internal/external func performance question

I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

List of Values in a SP Parameter

I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin ...

Syncronize DB2 email dist list with Lotus Domino v6.5

A quick question that has us stumped here. Currently we maintian our email distribution lists in DB2 on our iSeries (810), running OS400 v5r2. We syncronize the dist lists with our Domino server (v5) using a migration tool Lotus provided. We are planning to update Domino to v6r5, and our iSeries OS...

A copy tool??

Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a 'contract/policy' from our live environment to a development/test environment. This...

OVRDBF in JAVA

I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

OVRDBF in Java

I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

Move from DB2/400 flat-file system to Oracle

Rao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the Metamodel(total DDL scripts) from DB2/400 and go for data modeling. Initially, I thought Oracle Migration Work Bench...

Problems copying from a PF to a XML file using CPYTOIMPF

Sanjeev wrote in with this question recently: "We are trying to copy from a PF to a XML file using CPYTOIMPF using STMFCODPAG(*PCASCII). The copy is not consistent -- sometimes it works fine and sometime it doesn?t." Do you have any suggestions that might help him out? -- Debra Tart, associate...

Selecting and inserting library names

Jeremy wrote in with this question recently: "Within an /exec SQL statement, I want to select from a file in one library and insert into the same file in a second. How should I refer to the library names? The editor rejects my attempts to refer to the libraries as host variables as per the...

iSeries and PHP

I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...

To retrieve data from a remote system

Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...

ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY

UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security...

A DBA is required for the big iSeries server

Search400.com member Fred wrote in with this statement recently: "Despite what IBM marketings says, I think that a DBA is required for the big iSeries servers." Do you agree or disagree?" -- Debra Tart, associate editor, Search400.com