Transform DB2 to XML from AS/400
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...
800 pts.
AS/400 data mapping with CPYFRMIMPF
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...
DB2 logical files
HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram
HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram
Compare a field from a file to a column from DB2
Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.
Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.
DB2/400 stored procedures
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Can you please tell me how to create stored procedures in AS/400 and when they are to be used?
Journaling and commitment control
Is it mandatory to journal a file to open it under commitment control? thanks
Is it mandatory to journal a file to open it under commitment control? thanks
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 field, apparently any...
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 field, apparently any...
How to check DB2 version in AS/400 green screen command line?
How to check db2 version in as400 green screen command line?
How to check db2 version in as400 green screen command line?
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 am...
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 am...
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
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
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.
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.
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 ... ...
How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...
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.
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.
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?
whats the use of primary file any real example please? in what scenario should we prefer to fully procedural file?
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?
We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?
Referential integrity and AS/400
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy
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...
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...
