Table partitioning, CLOB and BLOBs in DB2 9 LUW?
Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and CLOB, LOB [...]
Answer Question
| January 31, 2008 8:48 PM
BLOB, CLOB, DB2, LOB, Table partitioning
Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and CLOB, LOB [...]
Answer Question
| January 31, 2008 8:48 PM
BLOB, CLOB, DB2, LOB, Table partitioning
Lotus Notes and AS400 (DB2)
I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but… MANAGEMNT does not want users to have any [...]
Answer Question
| January 22, 2008 5:55 PM
AS/400, DB2, Lotus Domino, Lotus Notes
I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but… MANAGEMNT does not want users to have any [...]
Answer Question
| January 22, 2008 5:55 PM
AS/400, DB2, Lotus Domino, Lotus Notes
File sort using qshell (this time with tags)
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]
Answer Question
| January 16, 2008 3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells
Hi, I’m trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a sort, removing duplicate records, and [...]
Answer Question
| January 16, 2008 3:12 PM
AS/400, Database, DB2, Linux, Qshell, Unix shells
How to use PL/I command LIKE with DB2
I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to [...]
Answer Question
| March 8, 2010 2:57 PM
DB2, iSeries programming commands, PL/I
I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to [...]
Answer Question
| March 8, 2010 2:57 PM
DB2, iSeries programming commands, PL/I
oracle calculated item
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]
Answer Question
| January 14, 2008 1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f needed and define [...]
Answer Question
| January 14, 2008 1:12 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
Julian to Gregorian Date Conv. in DB2 Web Query
I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?
Answer Question
| November 15, 2010 4:22 PM
DB2, iSeries, Query, web query
I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?
Answer Question
| November 15, 2010 4:22 PM
DB2, iSeries, Query, web query
SQL 2000 to Yukon Migration
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for [...]
Answer Question
| February 22, 2008 8:02 AM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for [...]
Answer Question
| February 22, 2008 8:02 AM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
SQL joins on encrypted data
Hi – we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across where there [...]
Answer Question
| October 5, 2007 2:35 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management
Hi – we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across where there [...]
Answer Question
| October 5, 2007 2:35 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management
C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
odbc access error…….
Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear : “[Microsoft][odbc [...]
Answer Question
| July 2, 2007 8:39 AM
Database, DB2, Oracle
Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear : “[Microsoft][odbc [...]
Answer Question
| July 2, 2007 8:39 AM
Database, DB2, Oracle
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 mainframe applications? 4) Any high [...]
Answer Question
| November 8, 2012 3:27 AM
DB2, Mainframe, Software testing tools, zSeries
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 mainframe applications? 4) Any high [...]
Answer Question
| November 8, 2012 3:27 AM
DB2, Mainframe, Software testing tools, zSeries
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 effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
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 effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
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, Java, [...]
Answer Question
| June 13, 2012 3:26 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services
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, Java, [...]
Answer Question
| June 13, 2012 3:26 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services
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 provide a message. This is [...]
Answer Question
| May 10, 2007 2:00 PM
Database, DB2, Oracle
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 provide a message. This is [...]
Answer Question
| May 10, 2007 2:00 PM
Database, DB2, Oracle
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 [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
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 [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
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 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
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 [...]
Answer Question
| January 8, 2010 12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
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 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
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 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
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 [...]
Answer Question
| March 1, 2007 12:37 PM
DB2
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 [...]
Answer Question
| March 1, 2007 12:37 PM
DB2
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
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
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
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
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.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL 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.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL Server
