Converting to .txt
Hello All, I'm trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.
Hello All, I'm trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.
45 pts.
Reading a database file via RPG program
could anyone provide me with the codeline for reading a database file via RPG program
could anyone provide me with the codeline for reading a database file via RPG program
SQL script output to a file
I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B
I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B
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.
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.
ODBC in AS/400, OS/400, System i, i5/OS
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
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
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
Grouping the records in RPG
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??
Nested Selects
A project I am working on requires that I do some stuff on a iSeries/AS400 DB (which I'm accessing through a linked server on a remote machine). I'm trying to build a query, but some of the AS400 syntax is giving me problems, and I was hoping that someone would be able to help me with this. the...
A project I am working on requires that I do some stuff on a iSeries/AS400 DB (which I'm accessing through a linked server on a remote machine). I'm trying to build a query, but some of the AS400 syntax is giving me problems, and I was hoping that someone would be able to help me with this. the...
Incremental Materialized View
Can I create Materialized View in AS/400 iSeries, which I can refresh incrementally?
Can I create Materialized View in AS/400 iSeries, which I can refresh incrementally?
How to determine the number of workstations defined in an As400?
How to determine the number of workstations defined in an As400?
How to determine the number of workstations defined in an As400?
Rretrieving data from AS400 tables with PHP?
I think I will die! Does anyone know how to get data from a table on AS400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and php installed and that works fine. The...
I think I will die! Does anyone know how to get data from a table on AS400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and php installed and that works fine. The...
how many programmes are using any perticular database file in as400
hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks
hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks
How can I map a pc keyboard key to 5250 emulation and have a dup key
I have AS400 program doing data entry. The users want to use a dup key to duplicate data entry into a subfile from one line to next. How can I map a pc key to be a dup key?
I have AS400 program doing data entry. The users want to use a dup key to duplicate data entry into a subfile from one line to next. How can I map a pc key to be a dup key?
Exceeding Limit in Excel
I am loading 20k records from our AS/400 using Excel icon(transfer from AS/400) but after 16k records loaded I am getting message indicating that limit is over need to start in another worksheet. I changed file type under RECV - Details icon in AS/400 to Excel 5 then also no use same error. Pls...
I am loading 20k records from our AS/400 using Excel icon(transfer from AS/400) but after 16k records loaded I am getting message indicating that limit is over need to start in another worksheet. I changed file type under RECV - Details icon in AS/400 to Excel 5 then also no use same error. Pls...
Delete data files on the AS400
I have a client that wants to remove all company data from an old AS400. Is there an easy way to do this, a single command or procedure?
I have a client that wants to remove all company data from an old AS400. Is there an easy way to do this, a single command or procedure?
Restoring journal receivers
A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: ...
A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: ...
