DB2

db2/400

Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

Procedure Pointer

How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400? Software/Hardware used: Iseries

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4

AS/400 file transfer window disappears

as400 file transfer window drops to the bottom never to return.

Is the new WRKDBF out yet?

Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together. Software/Hardware used: i5 v5r4

STORED PROCEDURE

Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it   Software/Hardware used: AS/400 sql400 DB2

Ideal memory for DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box.

We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space should we have? ...

DB2 Web Query record count

Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?

SQL error

I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

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...

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 get the add-on to...

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); Software/Hardware used: DB2 mainframe in Informatica

As400 - XML

Can i pass value from DB2 400 to XML.. how to do this? Software/Hardware used: AS400 - 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 Software/Hardware used: AS400 - 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.  

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 -...

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 Software/Hardware used: OS/390 2.10 and RACF and CICS

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...

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...

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. Software/Hardware used: IBM DB2 Runtime with HP 2730p Tablet