DB2/400 stored procedures
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Answer Question
| April 14, 2009 6:12 PM
AS/400 development, AS/400 stored procedures, DB2 stored procedures, DB2/400
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Answer Question
| April 14, 2009 6:12 PM
AS/400 development, AS/400 stored procedures, DB2 stored procedures, DB2/400
Journaling and commitment control
Is it mandatory to journal a file to open it under commitment control? thanks
Answer Question
| April 8, 2009 8:25 AM
AS/400 commitment control, AS/400 journaling, DB2/400, iSeries commitment control
Is it mandatory to journal a file to open it under commitment control? thanks
Answer Question
| April 8, 2009 8:25 AM
AS/400 commitment control, AS/400 journaling, DB2/400, iSeries commitment control
DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]
Answer Question
| May 18, 2009 9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]
Answer Question
| May 18, 2009 9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR
How to check DB2 version in AS/400 green screen command line?
How to check db2 version in as400 green screen command line?
Answer Question
| April 7, 2009 5:34 AM
AS/400 administration, AS/400 command functions, DB2, DB2/400, Green Screen
How to check db2 version in as400 green screen command line?
Answer Question
| April 7, 2009 5:34 AM
AS/400 administration, AS/400 command functions, DB2, DB2/400, Green Screen
Accessing AS/400 DB2 physical files with Java
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I [...]
Answer Question
| May 20, 2009 7:00 AM
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File
Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I [...]
Answer Question
| May 20, 2009 7:00 AM
AS/400 development, DB2/400, Java, Java/400, JD Edwards World, JDE, ODBC, Physical File
Process of swapping the kernels
HI i am working on a sap application where the OS is OS400 and the Data Base is DB2/400, now i want to know the process of swapping the kernels Can any one explain it or refer some meteral for teh same . thanks in advance kiran
Answer Question
| March 12, 2009 10:07 AM
DB2/400, OS/400, SAP development
HI i am working on a sap application where the OS is OS400 and the Data Base is DB2/400, now i want to know the process of swapping the kernels Can any one explain it or refer some meteral for teh same . thanks in advance kiran
Answer Question
| March 12, 2009 10:07 AM
DB2/400, OS/400, SAP development
How to Determine Database Access on AS/400
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
Answer Question
| March 8, 2009 3:36 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
Answer Question
| March 8, 2009 3:36 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
How to retreive stored procedure from DB2/400
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload … …
Answer Question
| May 9, 2012 9:34 AM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload … …
Answer Question
| May 9, 2012 9:34 AM
AS/400 DB2, AS/400 development, DB2 stored procedures, DB2/400
DB2/400
WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?
Answer Question
| January 31, 2011 6:06 PM
AS/400 database, AS/400 DB2, DB2/400
WHEN ACCESS PATH WILL BE CREATED AND WHEN OPEN DATA PATH WILL BE CREATED?
Answer Question
| January 31, 2011 6:06 PM
AS/400 database, AS/400 DB2, DB2/400
journalling a file
Is journalling a must for commitment control of a file on AS/400
Answer Question
| January 23, 2009 3:29 PM
AS/400 journaling, DB2/400
Is journalling a must for commitment control of a file on AS/400
Answer Question
| January 23, 2009 3:29 PM
AS/400 journaling, DB2/400
Native database implementation on AS/400
Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.
Answer Question
| December 23, 2008 2:32 AM
AS/400 database, AS/400 database administration, DB2, DB2/400, Open source databases
Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.
Answer Question
| December 23, 2008 2:32 AM
AS/400 database, AS/400 database administration, DB2, DB2/400, Open source databases
What is the use of primary files in DB2/400?
whats the use of primary file any real example please? in what scenario should we prefer to fully procedural file?
Answer Question
| December 19, 2008 6:22 AM
DB2, DB2/400, DB2/400 primary files
whats the use of primary file any real example please? in what scenario should we prefer to fully procedural file?
Answer Question
| December 19, 2008 6:22 AM
DB2, DB2/400, DB2/400 primary files
Tuning DB2/400 queries on iSeries
We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?
Answer Question
| December 10, 2008 9:40 PM
AS/400, DB2/400, iSeries, performance tuning
We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?
Answer Question
| December 10, 2008 9:40 PM
AS/400, DB2/400, iSeries, performance tuning
Referential integrity and AS/400
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy
Answer Question
| December 8, 2008 6:42 AM
Database, DB2, DB2/400, Oracle, RDBMS, Referential integrity, SQL Server
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy
Answer Question
| December 8, 2008 6:42 AM
Database, DB2, DB2/400, Oracle, RDBMS, Referential integrity, SQL Server
DB2/400 to Oracle 10g
I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able [...]
Answer Question
| November 21, 2008 8:03 PM
AS/400 migration, DB2/400, iSeries Navigator, Migration from DB2/400 to Oracle 10g, Oracle 10g, Oracle migration, Oracle Migration Workbench, V5R3
I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able [...]
Answer Question
| November 21, 2008 8:03 PM
AS/400 migration, DB2/400, iSeries Navigator, Migration from DB2/400 to Oracle 10g, Oracle 10g, Oracle migration, Oracle Migration Workbench, V5R3
DB2/400
difference between db2 and db2/400
Answer Question
| September 23, 2009 7:38 AM
DB2, DB2/400, IBM DB2
difference between db2 and db2/400
Answer Question
| September 23, 2009 7:38 AM
DB2, DB2/400, IBM DB2
How can we automate the DB2/400 used in AS/400 through QTP?
We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.
Answer Question
| November 13, 2008 4:52 AM
AS/400 database, AS/400 testing, DB2/400, HP QuickTest Professional, QTP, QTP TE Add-in, QTP Terminal Emulator Add-in, QuickTest Professional
We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.
Answer Question
| November 13, 2008 4:52 AM
AS/400 database, AS/400 testing, DB2/400, HP QuickTest Professional, QTP, QTP TE Add-in, QTP Terminal Emulator Add-in, QuickTest Professional
Converting a varchar to a numberic in SQL query
How can we convert a varchar field to Numberic in a SQL Query in db2 400?
Answer Question
| December 4, 2008 5:50 PM
AS/400, DB2, DB2/400, SQL Query, VARCHAR
How can we convert a varchar field to Numberic in a SQL Query in db2 400?
Answer Question
| December 4, 2008 5:50 PM
AS/400, DB2, DB2/400, SQL Query, VARCHAR
DB2/400
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]
Answer Question
| July 22, 2009 11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]
Answer Question
| July 22, 2009 11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY
RPG/400
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database
Answer Question
| November 3, 2008 2:02 PM
AS/400 database, AS/400 import/export, AS/400 migration, COBOL/400, DB2/400, RPG/400, Unisys DMSII
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database
Answer Question
| November 3, 2008 2:02 PM
AS/400 database, AS/400 import/export, AS/400 migration, COBOL/400, DB2/400, RPG/400, Unisys DMSII
