DATE, TIME and TIMESTAMP fields in the database files
Hi I created DATE, TIME and TIMESTAMP fields in a physical file. But I donot know how to populate the values to these fields from a COBOL program. When I include the file in a cobol program, the date field comes as FILLER PIC X(10), the tome field comes as FILLER PIC X(8) and the timestamp field...
Hi I created DATE, TIME and TIMESTAMP fields in a physical file. But I donot know how to populate the values to these fields from a COBOL program. When I include the file in a cobol program, the date field comes as FILLER PIC X(10), the tome field comes as FILLER PIC X(8) and the timestamp field...
5 pts.
Reading a file twice in CL
I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?
I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?
Accessing Oracle database on Linux from Mainframe
I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.
I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.
STRQMQRY not sum up the right total
I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn't add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? Thanks.
I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn't add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? Thanks.
Maximum program per trigger event
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
ODBC Connections to AS400 from HP-UX or Solaris systems.
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM's...
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM's...
Impact Analysis - None Answered till now
Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that....
Hi all, I have a question and submitted long back. But till now i didn't get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a utility for that....
Error executing stored procedure calling a CL that run an STRQMQRY
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC ...
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC ...
MMAIL
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: "The value specified for one of the...
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: "The value specified for one of the...
OPNDBF
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in the COBOL...
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in the COBOL...
Upgrade OS from V4R5 to V5R2 and SQL stopped working
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) ...
Hi, We have just upgraded from V4R5 to V5R2 and have difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) ...
CPYTOPCD command.
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
AS/400 - iSeries SQL Update of on table with values from another joined table
I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table, from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no...
I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table, from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no...
CPYF in arrival sequence
Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.
Anyone know a quick and dirty to copy data from a keyed physical file to another physical in arrival sequence in a CLP program? I can't find a native os/400 command that will do it.
ODBC Request from iSeries to Excel
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless I...
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless I...
How to use API to access DB2 file on iSeries
Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com
Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com
iseries prepared stored procedure call from ile rpg
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?
AS400 File Transfer using RUMBA Office V 7.3.0
We use RUMBA Office V 7.3.0 for AS/400 Display. We would like to restrict certain users from using the RUMBA AS/400 to PC File Transfer. Is there a way we can do this from the 400? The only reason that I ask is that we are a corporation and have more than 70 AS/400's. A user can use a sign on...
We use RUMBA Office V 7.3.0 for AS/400 Display. We would like to restrict certain users from using the RUMBA AS/400 to PC File Transfer. Is there a way we can do this from the 400? The only reason that I ask is that we are a corporation and have more than 70 AS/400's. A user can use a sign on...
SYSTEM OPENESS INCLUDES
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD's labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01...
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD's labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01...
