Mainframe Performance Testing
I am doing a research and would like to get answers to the following questions, I appreciate and value your experience and time: 1) What are the different types of mainframe applications? 2) What are the general performance issues that are expected? 3) What tools are used in performance testing...
I am doing a research and would like to get answers to the following questions, I appreciate and value your experience and time: 1) What are the different types of mainframe applications? 2) What are the general performance issues that are expected? 3) What tools are used in performance testing...
0 pts.
Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...
Email Validation Software
We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC,...
We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC,...
outer join issue
Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to...
Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to...
media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....
Optimizing/Indexing to find last transaction
I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...
I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...
Updating one record with a field of another record where two other fields match
I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL...
I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL...
Schedule SQL on an I5
Hi, Can anyone advise the best method of scheduling an ISQL statement to run on an I5. I need to run some update statements after hours etc. and I don't want to have to run the commands manaully each time. It has been suggested that a RUNSQL will do what I need but I am unable to find any...
Hi, Can anyone advise the best method of scheduling an ISQL statement to run on an I5. I need to run some update statements after hours etc. and I don't want to have to run the commands manaully each time. It has been suggested that a RUNSQL will do what I need but I am unable to find any...
Lotus Domino Database Structure
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
how to interconnect sql server with remote oracle server
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
Windows Server 2003 Web Edition Configuration
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from...
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from...
Oracle Database Issue
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on top it...
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on top it...
Visual Basic 2005
My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do I do this ???
My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do I do this ???
Count Distinct Rows on Multiple Columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
database access
how can i connect to a ms access database which resides on other computer in a network using vb6.0
how can i connect to a ms access database which resides on other computer in a network using vb6.0
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB - real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files...
DB2/400 Stored Procedure Security
I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never used SP or UDFs so...
I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never used SP or UDFs so...
Converting datetime (time portion) to varchar
I have an issue with a report I am converting from Crystal Reports to SRS. The reports datasource is a SQL stored procedure, that converts a datetime column to a varchar column containing just the time portion of the data. The time is converted to 24 hr format. CR was able to with it's built in...
I have an issue with a report I am converting from Crystal Reports to SRS. The reports datasource is a SQL stored procedure, that converts a datetime column to a varchar column containing just the time portion of the data. The time is converted to 24 hr format. CR was able to with it's built in...
RUN TIME ERROR 339
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: 'Run-Time Error 339 component 'CRYSTL32.OCX' or one...
Query
I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command --- SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM...
I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command --- SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM...
