Mainframe quality assurance testing tools
I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...
I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...
0 pts.
sql update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
Simple but not so
I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?
I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?
error in connection between oracle8i&developer2000
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
career advice
i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...
i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...
CLOB and VARCHAR2
Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb)....
Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb)....
Changing Server Name Where ORACLE is Loaded
I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work? Many thanks, Sam
I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work? Many thanks, Sam
Installing Oracle 9i on Windows XP
When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?
When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?
please solve this query
Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t...
Create Emp table containing an Empno column with the following sample data:- EMP ------- EMPNO ----------- 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ------------ 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 Don?t...
Uploading a file from a USB up to Mainframe & re-generating a PDS
I created a flat file from a PDS using IEBCOPY, downloaded that flat file to hardrive and subsequently copied to a flash drive. Now, I'm trying to upload this file & re-create the PDS that it originally came from but am getting errors: "wrong length record" Have tried uploading to various record...
I created a flat file from a PDS using IEBCOPY, downloaded that flat file to hardrive and subsequently copied to a flash drive. Now, I'm trying to upload this file & re-create the PDS that it originally came from but am getting errors: "wrong length record" Have tried uploading to various record...
need help in vb code
Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [CODE] id Time Code Price Res 1 10:00:00...
Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example [CODE] id Time Code Price Res 1 10:00:00...
Microsoft Access Query Question
I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named "PapersPresented" I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make...
I have created a Database that will create a Resume from Data entered. What I am having problems with are in a Query I have created named "PapersPresented" I have several Authors for One Paper. I want to combine the multiple Authors for each paper so as to eliminate the data redundancy and make...
Access Oracle/Sybase/Informix from RPG
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...
DB2 Stored Procedure V4R4 without ILE C/400
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...
Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? ...
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? ...
pl/sql ref cursor question
Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1....
Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1....
passing variables..................
hello, i am calling 3 variables A,B,C by issuinng CALL A,B,C.in the called programme i have by mistake coded procedure division using C,A,B. how will the actual and formal variables get attached,i mean what values would be passed to the main programme. thanx a lot
hello, i am calling 3 variables A,B,C by issuinng CALL A,B,C.in the called programme i have by mistake coded procedure division using C,A,B. how will the actual and formal variables get attached,i mean what values would be passed to the main programme. thanx a lot
Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...
problem while accessing a Temporary dataset
hello, i have about 25 steps in my jcl, in the 4th step i have created a temporary data set and passed it to subsequent steps(5th,6th,9th and so on). while accesing it in the 7th step an ABEND occurs and the job terminates abnormally. now i want my jcl to...
hello, i have about 25 steps in my jcl, in the 4th step i have created a temporary data set and passed it to subsequent steps(5th,6th,9th and so on). while accesing it in the 7th step an ABEND occurs and the job terminates abnormally. now i want my jcl to...
