UDS and DS
I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this? Software/Hardware used: Iseries
I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this? Software/Hardware used: Iseries
External DB2 Database link/trigger
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4
Member Level ID
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...
query/400
plz tell me how to work with query/400 on as/400 machine...thanks Software/Hardware used: as/400,IBM i
plz tell me how to work with query/400 on as/400 machine...thanks Software/Hardware used: as/400,IBM i
Bad data in as/400 database.. cant display record
We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...
We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...
client access 32 bit ODBC drivers
where can i download 32bit client access ODBC drivers onto my windows(XP) system so that i wanna migrate my access files to AS/400 files.Plz guide Software/Hardware used: as/400
where can i download 32bit client access ODBC drivers onto my windows(XP) system so that i wanna migrate my access files to AS/400 files.Plz guide Software/Hardware used: as/400
MS-Access data access
I wanted to access a MS-Access database file on my PC to my AS/400 and want to convert it into a physical file.Can anybody give me the steps in this process and requirements for that? thanks Software/Hardware used: as/400
I wanted to access a MS-Access database file on my PC to my AS/400 and want to convert it into a physical file.Can anybody give me the steps in this process and requirements for that? thanks Software/Hardware used: as/400
What is Database Pagefault in AS/400
What is Database Page fault in AS/400 it is releated to WRKACTJOB plese send the answer if any one knows
What is Database Page fault in AS/400 it is releated to WRKACTJOB plese send the answer if any one knows
How to export meta-data
I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru 'file commands''display file field...
I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru 'file commands''display file field...
What causes the last used date to be updated on a file?
I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is...
I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is...
Rebuilding Logical Files
What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?
What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?
whats are the contents of a databse fields after the record is written
I have a field in a file eg. NewQueue. Once I write or update a record in the file that has field NewQueue, are the contents of that field still available for evaluation?
I have a field in a file eg. NewQueue. Once I write or update a record in the file that has field NewQueue, are the contents of that field still available for evaluation?
I am not a programmer
I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.
I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.
Is a DB on AS400 always DB2 ?
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
Maximum number of records that can be stored
What is the Maximum number of records that can be stored on an as400 data file.
What is the Maximum number of records that can be stored on an as400 data file.
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.
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.
How to get the row count of a PF with RPG ILE?
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.


