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 scribe before with I-series? If [...]

Answer Question   |  March 2, 2006  12:36 PM
AS/400, CLP, CRM, DataCenter, DB2 Universal Database, PC/Windows Connectivity, SQL, SQL Server

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

Answer Question   |  November 30, 2009  9:39 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development

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 idea on how to improve performance without [...]

Answer Question   |  November 30, 2009  4:04 PM
AS/400, DB2 Universal Database

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 [...]

Answer Question   |  November 30, 2009  1:41 PM
DB2 Universal Database, RPGLE

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 [...]

Answer Question   |  November 29, 2009  3:55 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE

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 [...]

Answer Question   |  February 13, 2006  4:24 PM
DB2 Universal Database

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

Answer Question   |  November 28, 2009  12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE

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 function call it, [...]

Answer Question   |  April 28, 2009  5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE

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 Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in(‘Value1′, ‘Value2′,’Value3′, etc);

Answer Question   |  February 9, 2006  2:42 PM
Application development, Crystal Reports, DB2 Universal Database

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 to v5r3 in [...]

Answer Question   |  February 2, 2006  11:38 AM
DB2 Universal Database, Lotus Domino

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 would involves copying all contract/policy [...]

Answer Question   |  February 20, 2006  4:43 AM
Application development, AS/400, DataCenter, DB2 Universal Database, RPG

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?

Answer Question   |  November 25, 2009  6:25 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development

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?

Answer Question   |  November 25, 2009  11:47 PM
Application development, AS/400, CLP, DB2 Universal Database, Java

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 (OMWB)would work. Unfortunately, it does not [...]

Answer Question   |  January 23, 2006  11:00 AM
DB2 Universal Database

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 editor, Search400.com

Answer Question   |  January 23, 2006  10:51 AM
DB2 Universal Database

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 [...]

Answer Question   |  January 24, 2006  10:47 AM
DB2 Universal Database

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?. [...]

Answer Question   |  January 16, 2006  9:56 AM
Application development, AS/400, DB2 Universal Database, Networking

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 either [...]

Answer Question   |  November 23, 2009  11:11 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries

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 Printing & Output Web Development – Debra Tart, associate editor, Search400.com

Answer Question   |  December 23, 2005  6:47 AM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development

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

Answer Question   |  December 22, 2005  6:32 PM
DB2 Universal Database