Beginning DB2 programming in mainframes
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?
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

Jreport problem – floating point literal
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

Comparing DB2 between AS/400 and mainframes
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

DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400
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

db2/400
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

Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
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

DB2 / ODBC file availability
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

Inserting DB2 records on iSeries to SQL Server 2005 Table
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

Data Access to DB2 in RPG program
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?
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

DB2 data over web browser
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

DYNSLT
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
DB2

DB2 Web Query – Active Report Show Unreadbale Data
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

Querying multiple member PF with SQL
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

Isolation level in iseries DB2
How to set isolation level in iseries DB2? please reply.

Answer Question   |  February 11, 2010  4:44 AM
AS/400 DB2, DB2

AUTHID in 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

SELECT AND OMIT in RPGILE
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
DB2, RPGILE

Mainframe – Someone moving my DB2 Object to READ ONLY
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

DB2 (Oracle funtionality in)
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