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
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
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
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
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
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
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
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
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
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
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
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
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
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?
Answer Question | July 27, 2009 5:23 PM
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
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
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
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
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