how to start db2 programming in mainframes detailed
Answer Question | October 22, 2010 2:50 AM
DB2, DB2 administration, DB2 configuration, Mainframe, Mainframe programming
Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.
Answer Question | September 20, 2010 1:27 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables
hi! I’m new here! I have a report and this is connect to db2/as400. When I compile i have the next error “[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause….” I don’t know what is happenning. The query I run in other program and this is right, so I think is something with Jreports!! thanks [...]
Answer Question | September 24, 2010 3:04 PM
AS/400, AS/400 DB2, AS/400 Query, DB2, JReport
How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for both platforms (AS/400 and mainframe)?[Br _extended=”true” />
Answer Question | June 29, 2011 6:11 AM
AS/400, AS/400 DB2, DB2, DB2 administration
I have around 5 years of IT experience in Mainframe and Midrange operations. As I’m more intersted in database administration, recently I did IBM DB2 9 Fundamentals certification and also IBM Mainframe application development course ( JCL,VSAM,COBOL,DB2,CICS) but it was 5 years back. I want to go for professional certification in DB2 for Z/OS as [...]
Answer Question | September 27, 2011 10:52 PM
AS/400, AS/400 DB2, DB2, IT career planning, z/OS
Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?
Answer Question | July 22, 2010 4:43 AM
AS400 physical file, DB2, DB2/400, Physical File
i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.
Answer Question | July 5, 2011 6:27 AM
DB2, Qshell, QTEMP Library, SQL procedure
We have a new web app that we want to be able to run 24/7. My question from our web staff is “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be [...]
Answer Question | July 2, 2010 2:50 PM
AS/400 High Availability, DB2, iSeries, ODBC
I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks
Answer Question | June 20, 2011 12:27 AM
DB2, iSeries, SQL Server 2005
I want to know how to connect using connection string to DB2 instead of using pf file in RPG program.
Answer Question | June 2, 2010 5:10 AM
DB2, RPG Data Access to DB2, RPG Program
How to learn DB2? Is there any possible way to install in a PC and practice? if then guide me please……………
Answer Question | May 4, 2010 12:05 PM
DB2, DB2 administration, DB2 certification
Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..
Answer Question | May 5, 2010 2:55 AM
AS/400 DB2, DB2, System i
In what way DYNSTL keyword be usefull??? Can anyone please explain with example… Will be very Thankfull.
Answer Question | March 22, 2011 8:52 AM
I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this [...]
Answer Question | February 26, 2010 4:50 AM
DB2, DB2 query, DB2 Web Query
I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF. Is this possible just with an SQL query without using OVRDBF etc.?
Answer Question | February 15, 2010 8:17 AM
AS/400 SQL, DB2, Physical Files, SQL
How to set isolation level in iseries DB2? please reply.
Answer Question | February 11, 2010 4:44 AM
AS/400 DB2, DB2
I want to define AUTHID while create stored procedure in DB2/AS400. This can be done in oracle as CREATE OR REPLACE PROCEDURE PRC AUTHID DEFINER / CURRENT_USER can this also be done in iSeries AS/400 DB2?
Answer Question | February 17, 2010 10:10 AM
AS/400 Authorization List, DB2, DB2 stored procedures
hI,GUYS,Actually select and omit used in lagical file to control the records,values like. But without key field how can i use these select and omit condition in logical file? And one more doubt is what is the exact uses of %SCAN,%SUBST, %SUBDT,%EOF,%CHECK,%COMMIT,%FOUND.Plese explain these
Answer Question | February 6, 2010 5:15 AM
How to know who is or which application moving my TS to READ ONLY in a z/OS environment?
Answer Question | February 3, 2010 2:39 PM
DB2, iSeries objects, z/OS
Hi, all I have no familiarity with DB2, but plenty in Oracle and SQL Server and other RDMS. In Oracle, I can access a flat file on disk by defining it as an External File. Similar functionality in SQL Server. My question then: Does DB@ on the mainframe have the same type of feature? Thanks [...]
Answer Question | February 3, 2010 6:04 PM
DB2, DB2 file system, File systems, Flat files