Recent IT Questions

1 - 20 of 386
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

db2/400

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

View Answer   |  Nov 3 2009  12:06 AM GMT
AS/400 simulator, DB2/400, DB2
asked by I6

  195 pts.

Procedure Pointer

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

View Answer   |  Oct 30 2009  11:38 AM GMT
AS/400 Procedure Pointer, AS/400 Pointers, AS/400
asked by Kar

  90 pts.

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

View Answer   |  Oct 26 2009  10:42 AM GMT
AS/400 database, DB2/400, i5/OS
asked by R.otto

  375 pts.

AS/400 file transfer window disappears

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

View Answer   |  Oct 22 2009  3:21 PM GMT
AS/400 File Transfer, DB2
asked by Dothendo

  15 pts.

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

View Answer   |  Oct 21 2009  1:51 PM GMT
i5, iSeries, AS/400
asked by Yorkshireman

  3200 pts.

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

Answer Question   |  Oct 21 2009  5:14 AM GMT
SQL stored procedures, SQL/400, DB2
asked by AS400SQL

  10 pts.

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

Answer Question   |  Oct 1 2009  5:05 PM GMT
Linux, Linux Box, DB2
asked by ITKE

  10045 pts.

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?

View Answer   |  Sep 30 2009  3:59 PM GMT
DB2 Web Query, DB2
asked by BUEHLER

  15 pts.

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

View Answer   |  Sep 27 2009  4:57 PM GMT
SQLRPGLE, DB2/400, DB2
asked by Nutangujar

  745 pts.

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

View Answer   |  Sep 25 2009  8:47 PM GMT
DB2/400, DB2, Physical Files
asked by Anky

  10 pts.

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

Answer Question   |  Sep 23 2009  2:38 PM GMT
Office 2007, DB2, QMF
asked by AuntDi

  5 pts.

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

View Answer   |  Sep 20 2009  1:24 AM GMT
DB2 query, DB2
asked by Rulala

  5 pts.

As400 - XML

Can i pass value from DB2 400 to XML.. how to do this? Software/Hardware used: AS400 - XML

View Answer   |  Sep 10 2009  4:52 PM GMT
AS/400, XML, DB2
asked by Nutangujar

  745 pts.

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

View Answer   |  Sep 10 2009  2:12 PM GMT
DB2, AS/400, AS/400 file specification
asked by Nutangujar

  745 pts.

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.  

View Answer   |  Sep 10 2009  7:57 AM GMT
Physical Files, AS/400, DB2
asked by C007

  50 pts.

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

View Answer   |  Sep 9 2009  2:27 PM GMT
DB2, RPG, AS/400
asked by Nutangujar

  745 pts.

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

View Answer   |  Sep 9 2009  12:27 AM GMT
RACF, OS/390, CICS
asked by RACF

  5 pts.

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

View Answer   |  Aug 30 2009  6:15 PM GMT
DB2, AS/400
asked by Nutangujar

  745 pts.

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

View Answer   |  Aug 20 2009  1:44 PM GMT
Access Datasheet, iSeries Access, AS/400
asked by CompEng

  570 pts.

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

Answer Question   |  Aug 13 2009  1:57 PM GMT
IBM DB2, DB2, HP 2730p
asked by Jmonroe700ing

  5 pts.

1 - 20 of 386
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>