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
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
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
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
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
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
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
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
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
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
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
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
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
CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
File lock on DB2 AS/400
How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I’m acccessing it ?
Answer Question
| September 18, 2012 1:42 PM
AS/400 - CL Command, DB2
How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I’m acccessing it ?
Answer Question
| September 18, 2012 1:42 PM
AS/400 - CL Command, DB2
AS400 DB2 Server User Access Audit
Is there any way to track “User Account” information on a DB2 server specifically when a users account is locked?
Answer Question
| August 22, 2012 3:57 PM
AS/400, audit, DB2, logging, Security
Is there any way to track “User Account” information on a DB2 server specifically when a users account is locked?
Answer Question
| August 22, 2012 3:57 PM
AS/400, audit, DB2, logging, Security
Character delimited csv with double byte data
I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using “Text to Columns” but the delimiter characters are missing and the text is garbled. Several of the [...]
Answer Question
| August 3, 2012 2:50 PM
CCSID, DB2, DBCS, Japanese
I have a physical file on the iSeries (V7R1) that I am trying to send to the IFS using CPYTOIMPF. When I open the file on the IFS using Excel I expected to be able to parse the data using “Text to Columns” but the delimiter characters are missing and the text is garbled. Several of the [...]
Answer Question
| August 3, 2012 2:50 PM
CCSID, DB2, DBCS, Japanese
Importing a .dbf file into IBM DB2 table
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]
Answer Question
| July 19, 2012 3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]
Answer Question
| July 19, 2012 3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4
I would like to run a report on AS/400 to indentify which DB2 tables to reorg.
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
Expired or deleted RACF accounts that are still active in DB2
Hello, I have a question related to ‘expired or deleted RACF accounts that are still active in DB2′. In our shop, with z/OS as the operating system and RACF as a security tool. While DB2 native security is used to manage access for each of the DB2 objects such as database, table, view, or storage [...]
Answer Question
| March 14, 2012 10:10 PM
DB2, RACF, z/OS
Hello, I have a question related to ‘expired or deleted RACF accounts that are still active in DB2′. In our shop, with z/OS as the operating system and RACF as a security tool. While DB2 native security is used to manage access for each of the DB2 objects such as database, table, view, or storage [...]
Answer Question
| March 14, 2012 10:10 PM
DB2, RACF, z/OS
as400
what is the difference between source and object? Does source occupies the memory space?
Answer Question
| March 6, 2012 4:59 AM
AS/400, DB2
what is the difference between source and object? Does source occupies the memory space?
Answer Question
| March 6, 2012 4:59 AM
AS/400, DB2
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
Answer Question
| November 1, 2011 10:05 AM
DB2
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
Answer Question
| November 1, 2011 10:05 AM
DB2
Tried to go larger than storage limit for object OBJECTNM OBJECTNM
OBJECTNM is our file name. Some of thedetails of the file are given below. Member size . . . . . . . . . . . . . . . . : SIZE *NOMAX Access path size . . . . . . . . . . . . . [...]
Answer Question
| October 14, 2011 3:28 AM
AS/400, AS/400 objects, DB2, iSeries, iSeries data center
OBJECTNM is our file name. Some of thedetails of the file are given below. Member size . . . . . . . . . . . . . . . . : SIZE *NOMAX Access path size . . . . . . . . . . . . . [...]
Answer Question
| October 14, 2011 3:28 AM
AS/400, AS/400 objects, DB2, iSeries, iSeries data center
