What entices you more: Dell’s integration plans or its new technology advances?
During last week’s Dell Enterprise Forum, many customers said they were more interested in the company’s integration plans than in new technology advances (including its all-flash Compellent arrays and the upcoming Fluid Cache for SAN flash-caching product). Do you agree? What entices you more: Dell’s integration plans or its new technology advance?

Answer Question   |  June 18, 2013  8:09 PM
Dell, Integration, New technology

Multiple ST-SE within one file
I am using Gentran server for Windows. I am having a problem when a 837 file is sent and it contains multiple st-se within one file it will be broken down as one file for each st-se after the translation. I want one flat file that contain the same mutliple st-se in the flat files. [...]

Answer Question   |  June 5, 2013  6:55 PM
Gentran Server, Microsoft Windows, ST-SE

Application retirement and database archiving
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]

Answer Question   |  May 22, 2013  10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM

What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?
Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly (recently upgraded [...]

Answer Question   |  May 16, 2013  1:02 PM
DB2, ERP system, JDE, Oracle

Trigger
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

Answer Question   |  May 14, 2013  4:24 AM
AS/400, CLLE, DB2, RPGLE

Trigger removed
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

Answer Question   |  May 14, 2013  4:03 AM
AS/400, DB2, RPGLE

Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]

Answer Question   |  April 26, 2013  4:53 PM
AS/400, DB2, RPG, RPGILE

SQL creating an unwanted duplicate of file
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]

Answer Question   |  April 18, 2013  1:50 PM
DB2, SQL statement

ERP transaction type UDS-WO
What triggers a UDS-WO transaction type in a ERP system?

Answer Question   |  April 1, 2013  7:52 PM
ERP, ERP system

SQL insert error in php
When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]

Answer Question   |  March 19, 2013  9:20 PM
AS/400, DB2, PHP, SQL

Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]

Answer Question   |  March 20, 2013  7:59 PM
AS/400, DB2, iSeries, SQL 2008

EDIFACT DESADV
I need a sample template for EDIFACT DESADV to IDOC Delivery05 inbound.

Answer Question   |  March 13, 2013  10:25 AM
iDoc

AS/400…How to batch purchase order entry from an EDI transmission
How can purchase orders received from an EDI transmission be ‘bulk entered’ from a CSV or Excel file into the AS/400?

Answer Question   |  March 8, 2013  10:05 PM
AS/400, EDI, EDI Transactions

SAP Transaction Codes
The following transaction codes have disappeared from our PI environment.  They are in the ERP environment.   CG3Y   CG3z   How could this happen?

Answer Question   |  March 1, 2013  5:37 PM
ERP, SAP 6.0, SAP Transaction Codes

gentran, 856, BSN04, DTM03
Usually DTM03 automatically changes to match BSN04. What would cause DTM03 to be left at the default time? And what, if anything, can be done to fix this?

Answer Question   |  March 1, 2013  5:27 PM
BSN04, DTM03, Gentran

Google Earth Activation
I have “Google Earth” downloaded and installed on my system BUT when I go to open it my computer takes on amind of its own and goes ape. First off the picture changes to black then comes back with a kind of “negative” (as in photography) look. Everything is blue in color, larger and lumpy [...]

Answer Question   |  February 13, 2013  4:26 PM
Google Earth

EDI incrmentation
How to increment the second element of the REF segment by one for each occurrence in an 813 mapping version 4010?

Answer Question   |  January 21, 2013  7:20 PM
EDI, Gentran, Gentran Server

Need to identify the next sequence of number in a character field in DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]

Answer Question   |  December 18, 2012  7:34 AM
AS/400 V6r1m0, DB2

pb exe runtime eror – does not connect to db2 database from client machine
I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the [...]

Answer Question   |  December 13, 2012  11:19 AM
DB2, pb9

Anyone familiar with 4D front end to DB2 database
Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I’ve tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting…however I can’t get DB2 to maintain the formatting and I used DDS to to generate the physical file [...]

Answer Question   |  November 27, 2012  2:54 AM
DB2, iSeries