system storage
Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP(‘/’) NOW I AM INITIALIZING 10000 RECORD WITH DEFAULT VALUE BY USING INZPFM COMMAND…. THEN HOW MANY BYTES STORAGE WILL EACH RECORD OR ENTRY OCCUPY.  

Answer Question   |  September 30, 2009  8:47 PM
AS/400 storage, DB2, DB2/400, Physical Files

Office 2007
I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I [...]

Answer Question   |  September 23, 2009  2:38 PM
DB2, Office 2007, QMF

mainframe db2 – get current month and year
Please advise. My DB2 statement does not work. gl_date is a date field, format is ‘yyyy-mm-dd’. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date);

Answer Question   |  September 21, 2009  1:24 AM
DB2, DB2 query

As400 – XML
Can i pass value from DB2 400 to XML.. how to do this?

Answer Question   |  September 11, 2009  4:52 PM
AS/400, DB2, XML

AS400 – DB2 file names
Given a view name, how will i find its physical file name… e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

Answer Question   |  September 15, 2009  2:12 PM
AS/400, AS/400 file specification, DB2

IDelete QPFRDATA
Hi, I just want to ask if it is possible to delete the PF (Physical File) inside my performance data library without causing any problem on my AS400 system. I found out that its file is so big.  

Answer Question   |  September 11, 2009  7:57 AM
AS/400, DB2, Physical Files, QPFRDATA

DB2
i have display file which inputs a varibale say Var1…. This is updated in a PF. My problem is program is not updating this varibale in this file. it updates all other varibales…i checked the library list and evrythng is in place… in PF, the field name is Var1. i use the same name for DSPF [...]

Answer Question   |  September 11, 2009  2:27 PM
AS/400, DB2, RPG

GET OPID SEGMENT CICS FROM A COBOL/DB2/CICS PROGRAM (RACF)
Please I need Get the OPID segment CICS  of RACF from a COBOL/CICS  Program.   Thanks JORGE

Answer Question   |  September 9, 2009  12:27 PM
CICS, COBOL, DB2, OS/390, RACF

AS400 – DB2 concepts
In AS400, suppose I have 4 files to update and system encounters failure while updating 4th file…..I such scenario will the transactions on first 3 files will rollback…. how can i write a sample program to test this… i want to understand how ‘Transaction’ is defined in this scenario… Is it – 1…Update all 4 [...]

Answer Question   |  September 2, 2009  6:15 PM
AS/400, DB2

Access & iSeries AS400 Tbl and Query Issues Error Code 5001
I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the INMSP300 showing and only those in [...]

Answer Question   |  August 20, 2009  1:44 PM
Access Datasheet, AS/400, DB2, iSeries Access

IBMDB2 runtime issues with HP 2730p laptop
When displaying catalogue with IBM DB2 Runtime, a blank display appears.  It will not display the command windowl  This problem occurs only with the HP 2730p Tablet.

Answer Question   |  August 13, 2009  1:57 PM
DB2, HP 2730p, IBM DB2

What’s a good, simple reliable way to log errors for later investigation?
I’m doing new work in an old old system. It’s built with a bit of everything you could use from System/34 onwards – except maybe WSU. Naturally, as I Put together new functions, I test return codes, record locks, database integrity as I go. Just spent a couple of hours finding out that a function [...]

Answer Question   |  August 5, 2009  12:42 PM
DB2, DB2 error logs, i5, Joblogs, Logging Operators

CPYTOIMPF
i am new to as400 and i wanted to transfer file from as400 to pc using CPYTOIPMF as per advised here. BUt i am receiving an error File system error occurred. Error number 3025. whats wrong? thanks

Answer Question   |  December 13, 2011  7:41 AM
AS/400 error messages, CPYTOIMPF, DB2, Error number 3025

Automatic transfer of AS400 output file to PC folder
Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this manually. [...]

Answer Question   |  August 3, 2009  2:09 AM
AS/400 output files, AS/400 Transfer, DB2

When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

Answer Question   |  July 27, 2009  5:23 PM
DB2

how to block update command when using STRSQL ( db2/400)?
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

Answer Question   |  July 24, 2009  4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL

How to select 1 record in DB2
As usual, I often use: select top 1 * from table but in DB2, I can’t. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

Answer Question   |  April 18, 2013  5:34 PM
DB2, SELECT statement

SQL embedded in RPGLE
RPGLE program with five modules updating different set of files. Main module calls others each time a customer is being processed to change some specific detail in many files. There are many customers, so the modules are called many times (LR is set on only at the end of the whole process). Each module has [...]

Answer Question   |  July 7, 2009  7:20 AM
DB2, iSeries, performance, RPGLE, SQL

Delete OLD files from Table not having date or timestamp
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn’t have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn’t have creation date field. So, like [...]

Answer Question   |  July 30, 2009  10:46 AM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL

Difference between ODBC and JDBC?
I’m writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to [...]

Answer Question   |  April 19, 2013  1:49 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL